Newest Listings

to
 
 
 
Property Criteria
Features
  •  
Display Tools
Search

    5175  properties match your search;

    5175 with Multiple photos ;  764 with Virtual Tour ;  51 with Videos

    Save Search
    Showing 231 - 240 of 5175 results| view:  results per page« first|...|22|23|24|25|...|last »
    • Brand New contemporary huge legal 2 Family House in the heart of Little Neck. New foundation basement with large 40 x115 sq ft. lot. Each floor has 4 bedroom and 2 baths. Large Living Room, Dining Room, Eat-in-Kitchen. Hardwood Floor, Central AC. Park-like large backyard. Near tranquil nature reserve. Close to Local bus (#12, #36, #N20G) and express bus (QM3) to Manhattan. Walk to LIRR. Excellent school district (PS 94 and JHS 67). Near restaurants and supermarkets on Northern Blvd. Convenient to all. Great for Investment. 15
      42-30 247th Street Little Neck, NY 11363
      $2,480,000
      8 Bedrooms 5 Full Baths Sq. Ft. 3016.00:# Square Feet
      Multi Family For Sale ML# 3584976
      Brand New contemporary huge legal 2 Family House in the heart of Little Neck. New foundation basement with large 40 x115 sq ft. lot. Each floor has 4 bedroom and 2 baths. Large Living Room, Dining Room, Eat-in-Kitchen. Hardwood Floor, Central AC. Park-like large backyard. Near tranquil nature reserve. Close to Local bus (#12, #36, #N20G) and express bus (QM3) to Manhattan. Walk to LIRR. Excellent school district (PS 94 and JHS 67). Near restaurants and supermarkets on Northern Blvd. Convenient to all. Great for Investment.
      Presented By: AAA Young Shuen Realty Inc  718-461-9494
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Luxury Living in Bayside Gables Find your oasis in Bayside Gables, where luxury meets convenience in a gated community setting. This spacious home offers 3, 640 sqft of living space with a mother-and-daughter layout, separate entrance, gleaming hardwood floors, and a welcoming wood-burning fireplace. Located near shopping, dining, schools, parks, and more, this move-in ready gem is the perfect place to unwind and relax. Make this your forever home and enjoy the perks of upscale living. 32
      214-17 27th Avenue Bayside, NY 11360
      $2,480,000
      7 Bedrooms 4 Full Baths 1 Half Bath Sq. Ft. 3640.00:# Square Feet
      Single Family For Sale ML# 3583993
      Luxury Living in Bayside Gables Find your oasis in Bayside Gables, where luxury meets convenience in a gated community setting. This spacious home offers 3, 640 sqft of living space with a mother-and-daughter layout, separate entrance, gleaming hardwood floors, and a welcoming wood-burning fireplace. Located near shopping, dining, schools, parks, and more, this move-in ready gem is the perfect place to unwind and relax. Make this your forever home and enjoy the perks of upscale living.
      Presented By: Douglas Elliman Real Estate  516-883-5200
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Introducing a stunning residence in the heart of Hollis Hills, where modern luxury meets timeless sophistication. This brand-new 4.5 bedroom, 5-bathroom masterpiece has been meticulously crafted to cater to the most discerning tastes. Offering unparalleled elegance and functionality, the property is equipped with state-of-the-art features, including a comprehensive security system with cameras, a built-in sound system, radiant heated floors, and a central AC/heat system to ensure comfort throughout the year. The grandeur of the home is immediately apparent in the spacious master suite-a true private retreat with a balcony, and a spa-inspired ensuite bathroom complete with a rain shower, dual vanities, and high-end finishes that exude opulence. Each additional bedroom has been thoughtfully designed, providing ample space and luxurious touches to ensure comfort. For your convenience, there are two laundry areas, one located on the second floor and another in the finished basement, perfect for streamlining household routines. The property also boasts an indoor garage and a two-car driveway. Nestled within one of the most coveted neighborhoods, this residence is located within walking distance of top-rated schools, houses of worship, and community centers. This exceptional property gives you the ultimate in luxury living, combining modern design, premium finishes, and a prime location. 28
      82-15 209th Street Hollis Hills, NY 11427
      $2,478,000
      4 Bedrooms 5 Full Baths
      Single Family For Sale ML# 3584190
      Introducing a stunning residence in the heart of Hollis Hills, where modern luxury meets timeless sophistication. This brand-new 4.5 bedroom, 5-bathroom masterpiece has been meticulously crafted to cater to the most discerning tastes. Offering unparalleled elegance and functionality, the property is equipped with state-of-the-art features, including a comprehensive security system with cameras, a built-in sound system, radiant heated floors, and a central AC/heat system to ensure comfort throughout the year. The grandeur of the home is immediately apparent in the spacious master suite-a true private retreat with a balcony, and a spa-inspired ensuite bathroom complete with a rain shower, dual vanities, and high-end finishes that exude opulence. Each additional bedroom has been thoughtfully designed, providing ample space and luxurious touches to ensure comfort. For your convenience, there are two laundry areas, one located on the second floor and another in the finished basement, perfect for streamlining household routines. The property also boasts an indoor garage and a two-car driveway. Nestled within one of the most coveted neighborhoods, this residence is located within walking distance of top-rated schools, houses of worship, and community centers. This exceptional property gives you the ultimate in luxury living, combining modern design, premium finishes, and a prime location.
      Presented By: Exit Realty First Choice  718-380-2500
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Welcome Home to The Estates at Melville, an Exclusive Community of 21 Luxury Homes in the Heart of Melville. This impressive home has over 4500 sq ft of living space providing the perfect blend of comfort and style. It’s the perfect home to entertain, step inside this modern open concept living space filled with natural light and chefs kitchen ready for your design ideas! Features include 5 bedrooms 4.5 baths, room for mom or guest quarters, full basement with 10ft ceilings! 3 car garage. Make this home your own by choosing interior finishes. This location is known for it’s suburban charm and convenient location. This community offers a blend of luxury, community, and convenience making it one of Long Islands most desirable neighborhoods. Call me for a private tour don’t miss this opportunity to customize this to your liking! 4
      Lot #3 Equestrian Lane Melville, NY 11747
      $2,475,000
      5 Bedrooms 4 Full Baths 1 Half Bath Sq. Ft. 4500.00:# Square Feet
      Single Family For Sale NEWOPEN HOUSE ML# 3588485
      Welcome Home to The Estates at Melville, an Exclusive Community of 21 Luxury Homes in the Heart of Melville. This impressive home has over 4500 sq ft of living space providing the perfect blend of comfort and style. It’s the perfect home to entertain, step inside this modern open concept living space filled with natural light and chefs kitchen ready for your design ideas! Features include 5 bedrooms 4.5 baths, room for mom or guest quarters, full basement with 10ft ceilings! 3 car garage. Make this home your own by choosing interior finishes. This location is known for it’s suburban charm and convenient location. This community offers a blend of luxury, community, and convenience making it one of Long Islands most desirable neighborhoods. Call me for a private tour don’t miss this opportunity to customize this to your liking!
      Presented By: Daniel Gale Sothebys Intl Rlty  516-677-0030
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
      Upcoming Open House View Location
      11/02/2024 - 11/02/2024 11:00AM - 1:00PM
    • Welcome Home to The Estates at Melville, an Exclusive Community of 21 Luxury Homes in the Heart of Melville. This impressive home has over 5000 sq ft of living space providing the perfect blend of comfort and style. It’s the perfect home to entertain, step inside this modern open concept living space filled with natural light and chefs kitchen ready for your design ideas! Features include 5 bedrooms 5.5 baths, room for mom or guest quarters, full basement with 10ft ceilings! Make this home your own by choosing interior finishes. This location is known for it’s suburban charm and convenient location. This community offers a blend of luxury, community, and convenience making it one of Long Islands most desirable neighborhoods. Call me for a private tour don’t miss your opportunity! 4
      Lot 2 Equestrian Lane Unit Lot 2 Melville, NY 11747
      $2,475,000
      5 Bedrooms 5 Full Baths 1 Half Bath Sq. Ft. 5000.00:# Square Feet
      Single Family For Sale NEWOPEN HOUSE ML# 3588469
      Welcome Home to The Estates at Melville, an Exclusive Community of 21 Luxury Homes in the Heart of Melville. This impressive home has over 5000 sq ft of living space providing the perfect blend of comfort and style. It’s the perfect home to entertain, step inside this modern open concept living space filled with natural light and chefs kitchen ready for your design ideas! Features include 5 bedrooms 5.5 baths, room for mom or guest quarters, full basement with 10ft ceilings! Make this home your own by choosing interior finishes. This location is known for it’s suburban charm and convenient location. This community offers a blend of luxury, community, and convenience making it one of Long Islands most desirable neighborhoods. Call me for a private tour don’t miss your opportunity!
      Presented By: Daniel Gale Sothebys Intl Rlty  516-677-0030
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
      Upcoming Open House View Location
      11/02/2024 - 11/02/2024 11:00AM - 1:00PM
    • This newly renovated home is designed to blend elegant traditional, chic living and the best, most striking, modern interior luxury style. This breathtaking ranch is one of a kind and is set on a peaceful one-acre property on a cul-de-sac. High ceilings and an open floor plan set the stage for spacious and inviting living. The entry foyer with skylight opens to the family room with its soaring ceiling, double sided fireplace, sliding glass door to a wraparound deck with walls of windows overlooking the garden and the in-ground pool. The sunken living room and formal dining room provide a fantastic flow of interior space for large-scale entertaining. The chef’s level kitchen has a large island with waterfall counters, all new top-of-the-line appliances, and a breakfast area for casual dining. The large primary suite has two separate dual bathrooms and a walk-in closet. Bedroom with new en-suite bathroom. Two additional bedrooms with a hall bathroom. Powder room and laundry room round out the main floor. The lower level (1, 621 sf) holds untapped potential for a recreation/media room or gym. 27
      12 Glen Drive Harrison, NY 10528
      $2,475,000
      4 Bedrooms 4 Full Baths 1 Half Bath Sq. Ft. 3549.00:# Square Feet
      Single Family For Sale NEWOPEN HOUSE ML# H6332239
      This newly renovated home is designed to blend elegant traditional, chic living and the best, most striking, modern interior luxury style. This breathtaking ranch is one of a kind and is set on a peaceful one-acre property on a cul-de-sac. High ceilings and an open floor plan set the stage for spacious and inviting living. The entry foyer with skylight opens to the family room with its soaring ceiling, double sided fireplace, sliding glass door to a wraparound deck with walls of windows overlooking the garden and the in-ground pool. The sunken living room and formal dining room provide a fantastic flow of interior space for large-scale entertaining. The chef’s level kitchen has a large island with waterfall counters, all new top-of-the-line appliances, and a breakfast area for casual dining. The large primary suite has two separate dual bathrooms and a walk-in closet. Bedroom with new en-suite bathroom. Two additional bedrooms with a hall bathroom. Powder room and laundry room round out the main floor. The lower level (1, 621 sf) holds untapped potential for a recreation/media room or gym.
      Presented By: Houlihan Lawrence Inc.  914-833-0420
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
      Upcoming Open House View Location
      11/03/2024 - 11/03/2024 2:00PM - 4:00PM
    • Be the first to live in this brand-new three-bedroom, three-and-a-half-bathroom duplex featuring sprawling designer interiors, private outdoor space and an unbeatable location surrounded by the best Park Slope recreation and amenities. Inside this 1, 839-square-foot sanctuary, tall ceilings dotted with recessed LED lighting rise above rift and quartered white oak wide-plank floors and floor-to-ceiling windows. The condominium’s lower level sets the stage for relaxing and entertaining with a sun-kissed open layout that flows through the spacious living/dining room to a Juliet balcony overlooking treetop northern views. The magazine-worthy kitchen impresses with Scavolini pearl grey lacquered wood cabinetry, Ocean Grey quartz countertops and backsplashes, and a fleet of upscale appliances, including a Bertazzoni range, dishwasher, built-in microwave and wine refrigerator. A lovely powder room and coat closet add wonderful convenience to the level. Bedrooms are tucked on the upper floor for optimal peace and privacy. Retreat to the expansive primary suite to explore the king-size bedroom bordered by another Juliet balcony, a huge walk-in closet and an en suite spa bathroom finished with a custom Scavolini double vanity, wide medicine cabinet, Toto commode and a Hansgrohe thermostatic shower, all surrounded by Twine Asian Statuary and DreamStone Carrara Gioia marble. Two secondary bedrooms - one en suite and one with an adjacent full bath - open to a sunny south-facing balcony. A large laundry room with an in-unit washer-dryer, a linen closet and central HVAC add comfort and ease to this beautiful Brooklyn residence. Designed by Italian architect and interior design firm Studio20miglia, 186 16th Street is a stunning new construction boutique condominium featuring just three beautiful duplex residences. The pet-friendly building features a virtual doorman system, a handsome lobby and a package room. From this sought-after Park Slope location, you’re just four blocks from 586-acre Prospect Park and its magnificent open space, cultural institutions, events and year-round greenmarkets. Abundant nightlife, dining and shopping lines the nearby streets, and the vibrant neighborhoods of Gowanus, Greenwood Heights, Red Hook, Carroll Gardens, Sunset Park and Industry City are just minutes away. Nearby R, F and G trains and the Gowanus and Prospect Expressways provide easy access to the rest of the city and beyond. 23
      186 16th Street Unit 2 Park Slope, NY 11215
      $2,450,000
      3 Bedrooms 3 Full Baths 1 Half Bath Sq. Ft. 1839.00:# Square Feet
      Condo For Sale OPEN HOUSE ML# 3583815
      Be the first to live in this brand-new three-bedroom, three-and-a-half-bathroom duplex featuring sprawling designer interiors, private outdoor space and an unbeatable location surrounded by the best Park Slope recreation and amenities. Inside this 1, 839-square-foot sanctuary, tall ceilings dotted with recessed LED lighting rise above rift and quartered white oak wide-plank floors and floor-to-ceiling windows. The condominium’s lower level sets the stage for relaxing and entertaining with a sun-kissed open layout that flows through the spacious living/dining room to a Juliet balcony overlooking treetop northern views. The magazine-worthy kitchen impresses with Scavolini pearl grey lacquered wood cabinetry, Ocean Grey quartz countertops and backsplashes, and a fleet of upscale appliances, including a Bertazzoni range, dishwasher, built-in microwave and wine refrigerator. A lovely powder room and coat closet add wonderful convenience to the level. Bedrooms are tucked on the upper floor for optimal peace and privacy. Retreat to the expansive primary suite to explore the king-size bedroom bordered by another Juliet balcony, a huge walk-in closet and an en suite spa bathroom finished with a custom Scavolini double vanity, wide medicine cabinet, Toto commode and a Hansgrohe thermostatic shower, all surrounded by Twine Asian Statuary and DreamStone Carrara Gioia marble. Two secondary bedrooms - one en suite and one with an adjacent full bath - open to a sunny south-facing balcony. A large laundry room with an in-unit washer-dryer, a linen closet and central HVAC add comfort and ease to this beautiful Brooklyn residence. Designed by Italian architect and interior design firm Studio20miglia, 186 16th Street is a stunning new construction boutique condominium featuring just three beautiful duplex residences. The pet-friendly building features a virtual doorman system, a handsome lobby and a package room. From this sought-after Park Slope location, you’re just four blocks from 586-acre Prospect Park and its magnificent open space, cultural institutions, events and year-round greenmarkets. Abundant nightlife, dining and shopping lines the nearby streets, and the vibrant neighborhoods of Gowanus, Greenwood Heights, Red Hook, Carroll Gardens, Sunset Park and Industry City are just minutes away. Nearby R, F and G trains and the Gowanus and Prospect Expressways provide easy access to the rest of the city and beyond.
      Presented By: Revived Residential  929-379-3750
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
      Upcoming Open House View Location
      11/02/2024 - 11/02/2024 1:00PM - 2:00PM
    • This stunning 5 bedroom, 5.5 bath Colonial sits on 2.1 private acres in a cul-de-sac, offering 5, 652 SqFt of elegant living space. Recently renovated, features a gourmet kitchen with a Viking 6-burner stove, SUB-ZERO fridge and outdoor Lynx grill. A circular driveway with a basketball net and a 3 car garage offers ample parking. The landscaped backyard has a smartphone-controlled Gunite pool, two decks and fencing around the entire perimeter. The walk-out lower level boasts a sauna, 7-seat theater, gym, office and playroom. The home includes a spacious two-story family room, hardwood floors throughout, smart thermostats, internet controlled Insteon lighting and a wood-burning fireplace. Additional highlights: a luxurious master bath steam shower, 20W full house GENERAC generator, Tesla charger, Sonos music system and Honeywell internet controlled thermostats for modern convenience. 3 new AC compressors, new boiler and new pool heater. 25
      2 Hemlock Rise North Castle, NY 10504
      $2,445,000
      5 Bedrooms 5 Full Baths 1 Half Bath Sq. Ft. 5652.00:# Square Feet
      Single Family For Sale NEW ML# H6334428
      This stunning 5 bedroom, 5.5 bath Colonial sits on 2.1 private acres in a cul-de-sac, offering 5, 652 SqFt of elegant living space. Recently renovated, features a gourmet kitchen with a Viking 6-burner stove, SUB-ZERO fridge and outdoor Lynx grill. A circular driveway with a basketball net and a 3 car garage offers ample parking. The landscaped backyard has a smartphone-controlled Gunite pool, two decks and fencing around the entire perimeter. The walk-out lower level boasts a sauna, 7-seat theater, gym, office and playroom. The home includes a spacious two-story family room, hardwood floors throughout, smart thermostats, internet controlled Insteon lighting and a wood-burning fireplace. Additional highlights: a luxurious master bath steam shower, 20W full house GENERAC generator, Tesla charger, Sonos music system and Honeywell internet controlled thermostats for modern convenience. 3 new AC compressors, new boiler and new pool heater.
      Presented By: Continental Real Estate Group  877-996-5728
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Two family located in desired area of Williamsburg features 2bed/1bath over 3bed/1bath. Basement has two rooms, one full bath with ESO. Front yard has huge parking lot can park 4 trucks. The entire building has 6bedroom, 3bathroom. The property is good for investment or self-living. The building will be delivered vacant. Location closed to subway and highway. This 2family can also sell with next door warehouse as package deal. the total combined lot size will be 75x103. Good opportunity for self use or investment. 26
      120 Kingsland Avenue East Williamsburg, NY 11222
      $2,400,000
      5 Bedrooms 3 Full Baths
      Multi Family For Sale ML# 3584704
      Two family located in desired area of Williamsburg features 2bed/1bath over 3bed/1bath. Basement has two rooms, one full bath with ESO. Front yard has huge parking lot can park 4 trucks. The entire building has 6bedroom, 3bathroom. The property is good for investment or self-living. The building will be delivered vacant. Location closed to subway and highway. This 2family can also sell with next door warehouse as package deal. the total combined lot size will be 75x103. Good opportunity for self use or investment.
      Presented By: Exit Realty First Choice  718-380-2500
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Nestled in the serene enclave of Wykagyl Park, New Rochelle, this Mediterranean-inspired home offers unparalleled charm and elegance. With its impressive curb appeal, this fully furnished rental sits gracefully on .35 acres of meticulously landscaped land, boasting a three-car garage for added convenience. Step inside to discover a thoughtfully designed layout, where the first floor welcomes you with spacious living areas including a large living room, charming family room, and a chef’s kitchen perfect for culinary adventures. Additionally, a bedroom and home office provide versatility, while the dining room, sunroom, and one and a half bathrooms cater to both comfort and functionality. Ascend the elegant sweeping staircase to the second floor, where 6 bedrooms await, accompanied by 3.5 bathrooms, including the sprawling master bathroom measuring 20 x 12, complete with a balcony. The lower level of this Mediterranean retreat offers more than just parking space with its three-car garage; it also features a gym and ample storage room. Large picturesque windows throughout the home invite abundant natural light, creating an ambiance reminiscent of Mediterranean living. Experience the tranquility and sophistication of this exceptional property, where every detail exudes timeless beauty and luxury. 32
      58 Croft Terrace New Rochelle, NY 10804
      $2,600,000
      $2,400,000
      6 Bedrooms 6 Full Baths Sq. Ft. 6398.00:# Square Feet
      Single Family For Sale PRICE REDUCED ML# H6331661
      Nestled in the serene enclave of Wykagyl Park, New Rochelle, this Mediterranean-inspired home offers unparalleled charm and elegance. With its impressive curb appeal, this fully furnished rental sits gracefully on .35 acres of meticulously landscaped land, boasting a three-car garage for added convenience. Step inside to discover a thoughtfully designed layout, where the first floor welcomes you with spacious living areas including a large living room, charming family room, and a chef’s kitchen perfect for culinary adventures. Additionally, a bedroom and home office provide versatility, while the dining room, sunroom, and one and a half bathrooms cater to both comfort and functionality. Ascend the elegant sweeping staircase to the second floor, where 6 bedrooms await, accompanied by 3.5 bathrooms, including the sprawling master bathroom measuring 20 x 12, complete with a balcony. The lower level of this Mediterranean retreat offers more than just parking space with its three-car garage; it also features a gym and ample storage room. Large picturesque windows throughout the home invite abundant natural light, creating an ambiance reminiscent of Mediterranean living. Experience the tranquility and sophistication of this exceptional property, where every detail exudes timeless beauty and luxury.
      Presented By: Yaffa Realty LLC  408-504-0767
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    Showing 231 - 240 of 5175 results| view:  results per page« first|...|22|23|24|25|...|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