Newest Listings

to
 
 
 
Property Criteria
Features
  •  
Display Tools
Search

    4678  properties match your search;

    4448 with Multiple photos ;  613 with Virtual Tour ;  43 with Videos

    Save Search
    Showing 301 - 310 of 4678 results| view:  results per page« first|...|29|30|31|32|...|last »
    • Young 2 families brick house in the heart of Whitestone. located in the quite residential street, There are two 3 bedrooms with 2 full baths units, high ceiling in the basement, walk out to backyard. central air system, hard wood floors, granite countertops. close school , could be 2-3 parking spaces on the driveway. will be delivered vacant. buyers should verify all information independently. 12
      151-07 17th Avenue Whitestone, NY 11357
      $1,880,000
      6 Bedrooms 4 Full Baths Sq. Ft. 2310.00:# Square Feet
      Multi Family For Sale NEW ML# 3589407
      Young 2 families brick house in the heart of Whitestone. located in the quite residential street, There are two 3 bedrooms with 2 full baths units, high ceiling in the basement, walk out to backyard. central air system, hard wood floors, granite countertops. close school , could be 2-3 parking spaces on the driveway. will be delivered vacant. buyers should verify all information independently.
      Presented By: Sany Realty Group LLC  718-799-0726
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Welcome to this stunning, custom-built, two-story brick residence in the heart of Whitestone, meticulously renovated with top-tier imported finishes and premium appliances, including Miele, Bertazzoni, and Viking. The home radiates elegance and modern sophistication, starting with a grand foyer and custom walnut flooring that set a luxurious tone from the moment you enter. The upper level boasts four spacious bedrooms and two bathrooms, including a master suite complete with a walk-in closet. The expansive, high-ceilinged living room is both beautiful and functional, offering a welcoming and refined space for relaxation and gatherings. On the lower level, the open-concept kitchen combines elegance with functionality, featuring radiant heated floors, a large granite island, a premium appliance suite, and custom cabinetry. Adjacent to the kitchen, the cozy family room opens seamlessly to the tranquil patio and backyard through glass doors, perfect for effortless indoor-outdoor living. The spacious walk-out lower level offers abundant closet and storage space with additional access to the backyard. The versatile unfinished basement can be customized to suit the buyer’s preferred use. Outdoor spaces are thoughtfully designed for entertaining, and the home includes central air and an attached two-car garage. Every detail has been thoughtfully crafted, with custom walnut flooring throughout and bathrooms enhanced by walnut cabinetry, adding a refined, cohesive aesthetic. A beautiful staircase with imported walnut steps leads to the upper level, where you’ll find four spacious bedrooms and two bathrooms, including a luxurious master suite complete with a walk-in closet. The expansive, high-ceilinged living room is designed to offer both beauty and functionality, creating an inviting space for relaxation and gatherings. Conveniently located near Francis Lewis Park and just minutes from major highways and bridges, this exceptional home blends timeless elegance with modern convenience, creating an unparalleled living experience. 31
      243 150th Street Whitestone, NY 11357
      $1,880,000
      4 Bedrooms 3 Full Baths 1 Half Bath
      Single Family For Sale ML# 3588776
      Welcome to this stunning, custom-built, two-story brick residence in the heart of Whitestone, meticulously renovated with top-tier imported finishes and premium appliances, including Miele, Bertazzoni, and Viking. The home radiates elegance and modern sophistication, starting with a grand foyer and custom walnut flooring that set a luxurious tone from the moment you enter. The upper level boasts four spacious bedrooms and two bathrooms, including a master suite complete with a walk-in closet. The expansive, high-ceilinged living room is both beautiful and functional, offering a welcoming and refined space for relaxation and gatherings. On the lower level, the open-concept kitchen combines elegance with functionality, featuring radiant heated floors, a large granite island, a premium appliance suite, and custom cabinetry. Adjacent to the kitchen, the cozy family room opens seamlessly to the tranquil patio and backyard through glass doors, perfect for effortless indoor-outdoor living. The spacious walk-out lower level offers abundant closet and storage space with additional access to the backyard. The versatile unfinished basement can be customized to suit the buyer’s preferred use. Outdoor spaces are thoughtfully designed for entertaining, and the home includes central air and an attached two-car garage. Every detail has been thoughtfully crafted, with custom walnut flooring throughout and bathrooms enhanced by walnut cabinetry, adding a refined, cohesive aesthetic. A beautiful staircase with imported walnut steps leads to the upper level, where you’ll find four spacious bedrooms and two bathrooms, including a luxurious master suite complete with a walk-in closet. The expansive, high-ceilinged living room is designed to offer both beauty and functionality, creating an inviting space for relaxation and gatherings. Conveniently located near Francis Lewis Park and just minutes from major highways and bridges, this exceptional home blends timeless elegance with modern convenience, creating an unparalleled living experience.
      Presented By: Tru International Realty Corp  929-608-9600
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Location, location, and location!!!! 3 Story 2 family house on Grand Ave. Close to subway and bus station off Queens Blvd. The kitchens and baths are all recently updated. Two car attached garage at rear. 22
      86-34 Grand Avenue Elmhurst, NY 11373
      $1,880,000
      6 Bedrooms 3 Full Baths 2 Half Baths Sq. Ft. 2500.00:# Square Feet
      Multi Family For Sale ML# 3588011
      Location, location, and location!!!! 3 Story 2 family house on Grand Ave. Close to subway and bus station off Queens Blvd. The kitchens and baths are all recently updated. Two car attached garage at rear.
      Presented By: Karten Real Estate Svcs LLC  929-605-5545
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Welcome to this exceptional income-producing two-family property, perfectly nestled between Beech and Cherry Avenues on 149th Street in the heart of Murray Hill, Flushing. Whether you’re an investor or looking for multi-generational living, this home offers a prime opportunity in a highly sought-after neighborhood. With schools, shops, and restaurants just around the corner, you’ll also appreciate the convenience of Flushing Hospital just four blocks away. Commuting is a breeze with the Murray Hill LIRR station a mere five blocks from your doorstep, whisking you into Manhattan and throughout NYC and Long Island in no time. Set in a vibrant community, this property combines functionality with charm, providing spacious layouts in both units. A fantastic investment that offers comfort and convenience. Don’t miss out on owning a piece of one of Flushing’s best-kept secrets-schedule a viewing today and discover why this home is truly a cut above the rest. Potential income is worthwhile for any investor or end user. 25
      42-74 149th Street Flushing, NY 11355
      $1,880,000
      7 Bedrooms 2 Full Baths Sq. Ft. 3067.00:# Square Feet
      Multi Family For Sale ML# 3587100
      Welcome to this exceptional income-producing two-family property, perfectly nestled between Beech and Cherry Avenues on 149th Street in the heart of Murray Hill, Flushing. Whether you’re an investor or looking for multi-generational living, this home offers a prime opportunity in a highly sought-after neighborhood. With schools, shops, and restaurants just around the corner, you’ll also appreciate the convenience of Flushing Hospital just four blocks away. Commuting is a breeze with the Murray Hill LIRR station a mere five blocks from your doorstep, whisking you into Manhattan and throughout NYC and Long Island in no time. Set in a vibrant community, this property combines functionality with charm, providing spacious layouts in both units. A fantastic investment that offers comfort and convenience. Don’t miss out on owning a piece of one of Flushing’s best-kept secrets-schedule a viewing today and discover why this home is truly a cut above the rest. Potential income is worthwhile for any investor or end user.
      Presented By: Compass Greater NY LLC  646-404-1578
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Discover this versatile three-family brick home perfectly situated just two blocks from the subway, with R6A, C1-3 zoning that allows for future expansion! The property includes an attached one-car garage and a full finished basement with direct access to the backyard - a rare find in a prime Astoria location. The top-floor unit features hardwood floors throughout, three bedrooms, 1.5 bathrooms, a spacious living room, and an eat-in kitchen, offering ample space and comfort. On the second floor, you’ll find another three-bedroom, 1.5-bathroom unit with hardwood floors throughout, a large living room that opens to a front balcony, perfect for morning coffee or evening relaxation. This level also includes an eat-in kitchen and a bedroom with private stairway access to the backyard. The first-floor apartment is a two-bedroom unit with a spacious living room, open layout kitchen and hardwood floors throughout. With expansion potential and proximity to everything Astoria has to offer, this property is an ideal investment or a wonderful place to call home. 24
      28-12 Astoria Boulevard Astoria, NY 11102
      $1,877,000
      8 Bedrooms 3 Full Baths 3 Half Baths
      Multi Family For Sale NEW ML# 3589954
      Discover this versatile three-family brick home perfectly situated just two blocks from the subway, with R6A, C1-3 zoning that allows for future expansion! The property includes an attached one-car garage and a full finished basement with direct access to the backyard - a rare find in a prime Astoria location. The top-floor unit features hardwood floors throughout, three bedrooms, 1.5 bathrooms, a spacious living room, and an eat-in kitchen, offering ample space and comfort. On the second floor, you’ll find another three-bedroom, 1.5-bathroom unit with hardwood floors throughout, a large living room that opens to a front balcony, perfect for morning coffee or evening relaxation. This level also includes an eat-in kitchen and a bedroom with private stairway access to the backyard. The first-floor apartment is a two-bedroom unit with a spacious living room, open layout kitchen and hardwood floors throughout. With expansion potential and proximity to everything Astoria has to offer, this property is an ideal investment or a wonderful place to call home.
      Presented By: Blue Brick Real Estate  718-614-8349
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • 2005 Built two family building with an excellent layout. Total of 4 levels, there is a full basement walk-in, first floor is a legal 4 bedroom apartment, 2 full bathrooms, a living room, dining room and kitchen. Second floor is duplex with the third floor and has a beautiful high vaulted ceiling and balcony with a total of 5 bedrooms, 3 bathrooms and two full living rooms. Low taxes, private driveway, backyard and two car garage. Conveniently located within minutes to Q38, Q29, Q11, Q21, E, M, R Trains and the I-495 and Queens Blvd. 33
      8433 60 Drive Middle Village, NY 11379
      $1,873,000
      9 Bedrooms 5 Full Baths
      Multi Family For Sale NEW ML# 3589720
      2005 Built two family building with an excellent layout. Total of 4 levels, there is a full basement walk-in, first floor is a legal 4 bedroom apartment, 2 full bathrooms, a living room, dining room and kitchen. Second floor is duplex with the third floor and has a beautiful high vaulted ceiling and balcony with a total of 5 bedrooms, 3 bathrooms and two full living rooms. Low taxes, private driveway, backyard and two car garage. Conveniently located within minutes to Q38, Q29, Q11, Q21, E, M, R Trains and the I-495 and Queens Blvd.
      Presented By: Compass Greater NY LLC  646-662-8888
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Introducing this elegant brick home, boasting 4 spacious bedrooms and 3.5 baths. The property seamlessly blends timeless architectural charm with modern amenities. Its open-concept design connects the den, living, and dining areas, complete with a cozy fireplace and a built-in library. The large eat-in kitchen leads out to a delightful backyard porch, perfect for outdoor relaxation. The first floor showcases brand-new hardwood flooring throughout, a convenient bedroom, a full bathroom, and a powder room. On the second floor, the expansive primary suite features two walk-in closets and a newly renovated en-suite bath, complemented by two additional bedrooms with ample closet space and a shared full bath. The finished basement offers exceptional versatility with an additional bonus room, a home office, a laundry room, ample storage, and a boiler room. The property also includes a generator powered by gas, a long driveway, and a one-car garage, providing both convenience and privacy. This home is a perfect blend of comfort, functionality, and classic appeal, ideal for modern living. 32
      22 Elliot Rd Great Neck, NY 11021
      $1,870,000
      4 Bedrooms 3 Full Baths 1 Half Bath Sq. Ft. 3172.00:# Square Feet
      Single Family For Sale ML# 3586716
      Introducing this elegant brick home, boasting 4 spacious bedrooms and 3.5 baths. The property seamlessly blends timeless architectural charm with modern amenities. Its open-concept design connects the den, living, and dining areas, complete with a cozy fireplace and a built-in library. The large eat-in kitchen leads out to a delightful backyard porch, perfect for outdoor relaxation. The first floor showcases brand-new hardwood flooring throughout, a convenient bedroom, a full bathroom, and a powder room. On the second floor, the expansive primary suite features two walk-in closets and a newly renovated en-suite bath, complemented by two additional bedrooms with ample closet space and a shared full bath. The finished basement offers exceptional versatility with an additional bonus room, a home office, a laundry room, ample storage, and a boiler room. The property also includes a generator powered by gas, a long driveway, and a one-car garage, providing both convenience and privacy. This home is a perfect blend of comfort, functionality, and classic appeal, ideal for modern living.
      Presented By: Douglas Elliman Real Estate  516-205-2279
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • 4
      267-19 Union Turnpike New Hyde Park, NY 11040
      $1,859,000
      4 Bedrooms 3 Full Baths
      Single Family For Sale ML# 3583886
      Presented By: Signature Premier Properties  516-741-4333
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Once in a lifetime opportunity, Developers dream. One of the largest properties in all of Middle Village! Corner lot with 74 feet of frontage located directly on the corner lot depth 90 ft, Zoned R 4-1. Currently, the property has a two family home with detached 2 car garage. Total lot square footage 6660 ft.? Located just blocks from Stop & Shop and Elmhurst Park. Close to public transportation, blocks from Q58 and Q59 on Grand Ave., Stones-throw from 495. 11
      57-52 75th Street Middle Village, NY 11379
      $1,858,000
      5 Bedrooms 2 Full Baths
      Multi Family For Sale NEW ML# 3591196
      Once in a lifetime opportunity, Developers dream. One of the largest properties in all of Middle Village! Corner lot with 74 feet of frontage located directly on the corner lot depth 90 ft, Zoned R 4-1. Currently, the property has a two family home with detached 2 car garage. Total lot square footage 6660 ft.? Located just blocks from Stop & Shop and Elmhurst Park. Close to public transportation, blocks from Q58 and Q59 on Grand Ave., Stones-throw from 495.
      Presented By: Coldwell Banker American Homes  631-863-9800
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Whitestone prime location, quiet neighborhood, corner lot property for sale. Well maintained solid brick property. Amazing income generating potential. Three bedrooms on each floor. Multiple entrances for privacy. Separated gas and electrical meters for each unit. Easy to manage, must see. Property Characteristics 12
      149-04 12th Avenue Whitestone, NY 11357
      $1,858,000
      12 Bedrooms 4 Full Baths 1 Half Bath
      Multi Family For Sale ML# 3588599
      Whitestone prime location, quiet neighborhood, corner lot property for sale. Well maintained solid brick property. Amazing income generating potential. Three bedrooms on each floor. Multiple entrances for privacy. Separated gas and electrical meters for each unit. Easy to manage, must see. Property Characteristics
      Presented By: E Realty International Corp  718-886-8110
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    Showing 301 - 310 of 4678 results| view:  results per page« first|...|29|30|31|32|...|last »
    OneKey™ MLS The data relating to real estate for sale on this web site comes in part from the OneKey™ MLS. Real Estate listings held by brokerage firms other than Douglas Elliman - Pesce Lanzillotta Group are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers.
    The Pesce & Lanzillotta Group C:  516.888.9711 E:  info@pl-team.com

    Contact Us

     Submit

    Offices in NYC, Long Island, & The Hamptons
    516.888.9711

    NY Fair Housing Notice
    NY Reasonable Accomodations Notice for Prospective Tenants
    DMCA Notice   |   Login
    powered by www.erealtymedia.com
    Share
    O: 516.888.9711
    Contact

    The Pesce & Lanzillotta Group

    Office: 516.888.9711 Email: info@pl-team.com
    8223 Jericho Turnpike, Woodbury, NY 11797