Our Listings

to
 
 
 
Property Criteria
Features
  •  
Display Tools
Search

17909  properties match your search;

17748 with Multiple photos ;  2280 with Virtual Tour ;  248 with Videos

Save Search
Showing 1771 - 1780 of 17909 results| view:  results per page« first|...|176|177|178|179|...|last »
  • Welcome to this exquisite Sprawling Farm Ranch located on the prestigious Duck Pond Road off of Piping Rock Road. Nestled on a spacious .68-acre lot, this expansive home boasts beautifully landscaped grounds with mature plantings and specimen trees that offer a tranquil and private setting. With over 5000 square feet of living space, this home features oak wood floors throughout. The expansive great room welcomes you with an open layout combining the living room and dining room, complete with a coffered ceiling and a gas-burning fireplace. The gourmet eat-in kitchen is a chef’s dream, showcasing a center island, granite countertops, double ovens, six burner Wolf gas range stovetop, two dishwashers, and a subzero refrigerator. The kitchen opens to a large den with a gas fireplace and glass doors leading to a blue stone patio and outdoor dining area. The outdoor dining area features a wood-burning fireplace and two levels of seating areas, perfect for entertaining guests. The first floor also includes a primary bedroom with a spacious walk-in closet, a dressing area, and an ensuite bathroom. Additionally, there is a second bedroom/home office with its own full bath on the same floor. On the second floor, you will find another primary suite with an ensuite bath and walk-in closet, as well as another bedroom with a large walk-in closet and a full bath with a washer and dryer. A separate guest bedroom, located off the kitchen via a separate staircase on the second floor, offers its own private ensuite full bath. Completing this remarkable property are two separate garages that can accommodate four cars, with additional entry to spaces on the basement level. This home is truly a luxurious retreat offering unparalleled comfort, convenience, and style. Full house Automatic Generator installed 2016. Ring camera at front door. This extraordinary Sprawling Farm Ranch offers a unique opportunity for families seeking a home with separate living areas, ideal for accommodating multiple generations comfortably under one roof. Several of the rooms are virtually staged with furniture as well as the pool in the backyard. See photos. 72
    138 Duck Pond Rd Oyster Bay, NY 11542
    $1,899,000
    5 Bedrooms 5 Full Baths
    Single Family For Sale ML# 3561302
    Welcome to this exquisite Sprawling Farm Ranch located on the prestigious Duck Pond Road off of Piping Rock Road. Nestled on a spacious .68-acre lot, this expansive home boasts beautifully landscaped grounds with mature plantings and specimen trees that offer a tranquil and private setting. With over 5000 square feet of living space, this home features oak wood floors throughout. The expansive great room welcomes you with an open layout combining the living room and dining room, complete with a coffered ceiling and a gas-burning fireplace. The gourmet eat-in kitchen is a chef’s dream, showcasing a center island, granite countertops, double ovens, six burner Wolf gas range stovetop, two dishwashers, and a subzero refrigerator. The kitchen opens to a large den with a gas fireplace and glass doors leading to a blue stone patio and outdoor dining area. The outdoor dining area features a wood-burning fireplace and two levels of seating areas, perfect for entertaining guests. The first floor also includes a primary bedroom with a spacious walk-in closet, a dressing area, and an ensuite bathroom. Additionally, there is a second bedroom/home office with its own full bath on the same floor. On the second floor, you will find another primary suite with an ensuite bath and walk-in closet, as well as another bedroom with a large walk-in closet and a full bath with a washer and dryer. A separate guest bedroom, located off the kitchen via a separate staircase on the second floor, offers its own private ensuite full bath. Completing this remarkable property are two separate garages that can accommodate four cars, with additional entry to spaces on the basement level. This home is truly a luxurious retreat offering unparalleled comfort, convenience, and style. Full house Automatic Generator installed 2016. Ring camera at front door. This extraordinary Sprawling Farm Ranch offers a unique opportunity for families seeking a home with separate living areas, ideal for accommodating multiple generations comfortably under one roof. Several of the rooms are virtually staged with furniture as well as the pool in the backyard. See photos.
    Presented By: Douglas Elliman Real Estate  631-549-4400
    Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
  • Excellent 2, 808sqft 2-family house located at the heart of Jamaica featuring 10 Bedrooms, 3 Full Bathrooms, a fully finished Basement and a Private Driveway. Selling As is. Will be delivered vacant. R7A Zoning. FAR 4 for facility. Total 16, 000 buildable sqft, confirm with your Architect. Close to Subway, Buses, Schools, Banks, groceries, supermarkets, shopping, restaurants, and all other community amenities. 6
    175-46 88th Avenue Queens, NY 11432
    $1,899,000
    7 Bedrooms 3 Full Baths
    Single Family For Sale ML# 3553109
    Excellent 2, 808sqft 2-family house located at the heart of Jamaica featuring 10 Bedrooms, 3 Full Bathrooms, a fully finished Basement and a Private Driveway. Selling As is. Will be delivered vacant. R7A Zoning. FAR 4 for facility. Total 16, 000 buildable sqft, confirm with your Architect. Close to Subway, Buses, Schools, Banks, groceries, supermarkets, shopping, restaurants, and all other community amenities.
    Presented By: Exit Realty Prime  718-262-0205
    Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
  • Astonishing Water-Front Colonial With Boat Dock!! 137 ft of Level Shoreline W/Full View of Conscience Bay- A Weather- protected and Safe Haven for Kayaking, Inner Tubing, Water Skiing, and Wakeboarding. Fixed Pier W/Open Grate Composite Decking & Seasonal Aluminum Ramp to Floating Dock. Less Than 10 Min Cruise to LI Sound. In this Home You’ll Feel Like Royalty. Beautiful Hardwood Flooring, Large Living Room W/Cozy Fireplace and Enchanting Views Through Large Picture Window. Gorgeous Great Room W/Updated Kitchen, Breakfast Nook & Den area W/Gas Fireplace - Overlooks Backyard sanctuary With Sliders to Genuine Slate Patio. Gorgeous Updated Gunite IG Pool & Hot Tub, Privacy Landscaping... All Great for Entertaining or Tranquil Relaxation. Minutes from Old Field Lighthouse, Old Field Beach, and Frank Melville Park & Grist Mill. Enjoy All the Exceptional Dining, Shopping, and Entertainment Three Village Offers. 72
    149 Old Field Rd Brookhaven, NY 11733
    $1,899,000
    4 Bedrooms 3 Full Baths 1 Half Bath
    Single Family For Sale ML# 3550178
    Astonishing Water-Front Colonial With Boat Dock!! 137 ft of Level Shoreline W/Full View of Conscience Bay- A Weather- protected and Safe Haven for Kayaking, Inner Tubing, Water Skiing, and Wakeboarding. Fixed Pier W/Open Grate Composite Decking & Seasonal Aluminum Ramp to Floating Dock. Less Than 10 Min Cruise to LI Sound. In this Home You’ll Feel Like Royalty. Beautiful Hardwood Flooring, Large Living Room W/Cozy Fireplace and Enchanting Views Through Large Picture Window. Gorgeous Great Room W/Updated Kitchen, Breakfast Nook & Den area W/Gas Fireplace - Overlooks Backyard sanctuary With Sliders to Genuine Slate Patio. Gorgeous Updated Gunite IG Pool & Hot Tub, Privacy Landscaping... All Great for Entertaining or Tranquil Relaxation. Minutes from Old Field Lighthouse, Old Field Beach, and Frank Melville Park & Grist Mill. Enjoy All the Exceptional Dining, Shopping, and Entertainment Three Village Offers.
    Presented By: Realty Connect USA L I Inc  631-941-4300
    Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
  • Nestled in Oyster Bay Cove, this beautiful farm ranch sits on 2 acres of land with highly sought-after amenities. This property offers a luxury living experience with over 6, 000 sq. ft. of livable space. 5 bedrooms and 6 Baths. Custom high ceilings throughout the house. From the moment you step inside, you are astonished by the immaculate craftsmanship and modern elegance. Every detail has been flawlessly thought out with the highest quality finishes and amenities that create an unparalleled living experience. The mudroom starts with radiant heated floors. The kitchen features premium new appliances from 2023, a quartz countertop installed in 2023, radiant heated floors, beautiful cabinetry, a gas stove, and a large center island that is open to the spacious family and breakfast room, making it perfect for entertaining and family gatherings. The primary suite features a luxurious radiant heated floor bath with his/her walk-in closets. The lower level is the ideal space for recreational activities. The backyard is an oasis, featuring a heated saltwater swimming pool with a motorized cover, an attached spa, an outdoor kitchen, and fully automated porch screens. Double-car garage doors were installed 2 years ago. Brand new automated skylight shades were installed in Feb 2024. The central speaker system is available on the 1st level. 10-year-old Hardie plank siding. A 5, 000-watt portable gasoline-fed generator is included in the sale. Anderson windows and doors. All bedrooms are wired for intercom. 2nd level recently had a major remodel August of 2024 with brand-new flooring and a fresh paint job. Every amenity is at your fingertips! MUST SEE! 36
    23 Yellow Cote Rd Oyster Bay, NY 11771
    $1,949,000
    $1,899,000
    5 Bedrooms 3 Full Baths 1 Half Bath Sq. Ft. 6016.00:#
    Single Family For Sale PRICE REDUCED ML# 3538531
    Nestled in Oyster Bay Cove, this beautiful farm ranch sits on 2 acres of land with highly sought-after amenities. This property offers a luxury living experience with over 6, 000 sq. ft. of livable space. 5 bedrooms and 6 Baths. Custom high ceilings throughout the house. From the moment you step inside, you are astonished by the immaculate craftsmanship and modern elegance. Every detail has been flawlessly thought out with the highest quality finishes and amenities that create an unparalleled living experience. The mudroom starts with radiant heated floors. The kitchen features premium new appliances from 2023, a quartz countertop installed in 2023, radiant heated floors, beautiful cabinetry, a gas stove, and a large center island that is open to the spacious family and breakfast room, making it perfect for entertaining and family gatherings. The primary suite features a luxurious radiant heated floor bath with his/her walk-in closets. The lower level is the ideal space for recreational activities. The backyard is an oasis, featuring a heated saltwater swimming pool with a motorized cover, an attached spa, an outdoor kitchen, and fully automated porch screens. Double-car garage doors were installed 2 years ago. Brand new automated skylight shades were installed in Feb 2024. The central speaker system is available on the 1st level. 10-year-old Hardie plank siding. A 5, 000-watt portable gasoline-fed generator is included in the sale. Anderson windows and doors. All bedrooms are wired for intercom. 2nd level recently had a major remodel August of 2024 with brand-new flooring and a fresh paint job. Every amenity is at your fingertips! MUST SEE!
    Presented By: Daniel Gale Sothebys Intl Rlty  516-677-0030
    Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
  • Welcome to this exceptional 40-acre equestrian farm, a sanctuary that seamlessly blends luxury with the practicality of a well-designed space. Stepping inside the main house reveals a warm and inviting ambiance. The five spacious bedrooms are elegantly designed, providing ample space for both residents and guests to unwind and enjoy. The main barn, a potential subdivision, boasts 23 meticulously designed stalls within its spacious interior. In addition to providing excellent accommodations for the horses, this barn also features a kitchen, as well as two heated tack rooms, ensuring easy access and organization of riding gear. The main barn also includes a heated viewing room overlooking the indoor arena and a dedicated washing room for the horses. Along the farm, you’ll also find a man-made pond, elevating the farm’s stunning, country-like setting. Also located on the property is a smaller barn with 7 stables and a hay loft, offering additional storage for hay and feed. The farm further presents a spacious riding arena and multiple outdoor riding rings. This equestrian farm estate stands as a testament to pure beauty and serenity embraced by nature, potentially offering the opportunity for a delightful subdivision with picturesque views. 37
    39 Foley Rd Warwick (Town), NY 10990
    $1,899,000
    5 Bedrooms 2 Full Baths Sq. Ft. 2121.00:#
    Single Family For Sale ML# H6272387
    Welcome to this exceptional 40-acre equestrian farm, a sanctuary that seamlessly blends luxury with the practicality of a well-designed space. Stepping inside the main house reveals a warm and inviting ambiance. The five spacious bedrooms are elegantly designed, providing ample space for both residents and guests to unwind and enjoy. The main barn, a potential subdivision, boasts 23 meticulously designed stalls within its spacious interior. In addition to providing excellent accommodations for the horses, this barn also features a kitchen, as well as two heated tack rooms, ensuring easy access and organization of riding gear. The main barn also includes a heated viewing room overlooking the indoor arena and a dedicated washing room for the horses. Along the farm, you’ll also find a man-made pond, elevating the farm’s stunning, country-like setting. Also located on the property is a smaller barn with 7 stables and a hay loft, offering additional storage for hay and feed. The farm further presents a spacious riding arena and multiple outdoor riding rings. This equestrian farm estate stands as a testament to pure beauty and serenity embraced by nature, potentially offering the opportunity for a delightful subdivision with picturesque views.
    Presented By: Christie’s Int. Real Estate  845-205-3521
    Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
  • 6 Family Building for Sale in PRIME Astoria/LIC Location! Superbly maintained building offering investors an income generating opportunity without upfront renovation costs. Located in the heart of Astoria, just off the ever-popular Broadway and steps to the train, this multi-family building sees continuous tenant demand! SET-UP ***First floor: (2) 1 Bedroom Apartments ***Second floor: (1) 1-Bedroom Apartment (1) 2-Bedroom Apartment ***Third floor: (1) 1-Bedroom Apartment (1) 2-Bedroom Apartment ***Basement: Full, unfinished ***Semi-Detached, Brick - Beds: 8 Baths: 6 Rooms: 20 Sqft: 2, 067 ***Annual Income: $131, 064 ***Annual Expenses: $38, 579 ***Net Operating Income: $ $92, 485 ***Lot Size: 20.67x100 ***Bldg Size: 20.75x85 ***Taxes: $21329 ***Zoning: R5 TRANSPORTATION & LOCATION: Conveniently located just a 5-minute walk from the N/W subway station, providing quick access to Manhattan in under 20 minutes. With Citibike stations and multiple bus lines nearby, residents enjoy numerous transportation options. This prime Astoria spot is surrounded by popular dining, shopping, and entertainment options and is a high demand area for renters. ***TURN-KEY INCOME*** Ready for immediate income generation with easy to rent units. All units in great condition with some recent updates meeting modern tenant requirements. *HIGH RENTAL DEMAND* Astoria is known for its booming rental market and sees consistent tenant demand driven by all of the conveniences, cultural appeal and convenient transit/proximity to Manhattan. 23
    34-35 30th Street Queens, NY 11106
    $1,898,000
    8 Bedrooms 6 Full Baths Sq. Ft. 5200.00:#
    Multi Family Commercial ML# 3590466
    6 Family Building for Sale in PRIME Astoria/LIC Location! Superbly maintained building offering investors an income generating opportunity without upfront renovation costs. Located in the heart of Astoria, just off the ever-popular Broadway and steps to the train, this multi-family building sees continuous tenant demand! SET-UP ***First floor: (2) 1 Bedroom Apartments ***Second floor: (1) 1-Bedroom Apartment (1) 2-Bedroom Apartment ***Third floor: (1) 1-Bedroom Apartment (1) 2-Bedroom Apartment ***Basement: Full, unfinished ***Semi-Detached, Brick - Beds: 8 Baths: 6 Rooms: 20 Sqft: 2, 067 ***Annual Income: $131, 064 ***Annual Expenses: $38, 579 ***Net Operating Income: $ $92, 485 ***Lot Size: 20.67x100 ***Bldg Size: 20.75x85 ***Taxes: $21329 ***Zoning: R5 TRANSPORTATION & LOCATION: Conveniently located just a 5-minute walk from the N/W subway station, providing quick access to Manhattan in under 20 minutes. With Citibike stations and multiple bus lines nearby, residents enjoy numerous transportation options. This prime Astoria spot is surrounded by popular dining, shopping, and entertainment options and is a high demand area for renters. ***TURN-KEY INCOME*** Ready for immediate income generation with easy to rent units. All units in great condition with some recent updates meeting modern tenant requirements. *HIGH RENTAL DEMAND* Astoria is known for its booming rental market and sees consistent tenant demand driven by all of the conveniences, cultural appeal and convenient transit/proximity to Manhattan.
    Presented By: Realty Executives Today  718-274-2400
    Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
  • Luxurious, Contemporary Style Large 2 Family House Situated in a Desirable Little Neck Neighborhood. This Contemporary Stylish 2 Family Home built in 2022, 3 bedrooms 2 baths on each floor , features 2434 sqft Interior Space with Utmost attention to every square inch.washer and dryer on each floor . Enjoy High-End Quality with This Luxury Home’s Stunning High-Open Ceiling and chandelier in the Grand Living room. Beautiful Windows Allow for Tons of Natural Sunlight and Ambience. This house also includes a Fully Finished High Ceiling Basement with open layout , AC split unit and Full Bath. Excellent School district #26 (PS94, Jhs 67 and Cardozo High School). Close to Shops, Supermarket, Library and Schools. Encompassing both comfort and quality, this luxurious house is also an income producing property , definitely not one to miss , Must See! 36
    46-17 Little Neck Parkway Queens, NY 11362
    $1,898,000
    6 Bedrooms 5 Full Baths Sq. Ft. 2434.00:#
    Single Family For Sale ML# 3583410
    Luxurious, Contemporary Style Large 2 Family House Situated in a Desirable Little Neck Neighborhood. This Contemporary Stylish 2 Family Home built in 2022, 3 bedrooms 2 baths on each floor , features 2434 sqft Interior Space with Utmost attention to every square inch.washer and dryer on each floor . Enjoy High-End Quality with This Luxury Home’s Stunning High-Open Ceiling and chandelier in the Grand Living room. Beautiful Windows Allow for Tons of Natural Sunlight and Ambience. This house also includes a Fully Finished High Ceiling Basement with open layout , AC split unit and Full Bath. Excellent School district #26 (PS94, Jhs 67 and Cardozo High School). Close to Shops, Supermarket, Library and Schools. Encompassing both comfort and quality, this luxurious house is also an income producing property , definitely not one to miss , Must See!
    Presented By: EXP Realty  888-276-0630
    Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
  • Nestled in the prestigious village of Plandome Manor in Manhasset, this exquisite home offers over 3, 300-square-foot of living space with a perfect blend of luxury and convenience. The grand entrance opens to an expansive den with a stunning vaulted cathedral ceiling, creating an immediate sense of elegance and openness. Set on nearly half an acre of land, the home features beautiful updates including refined oak wood floors and a renovated kitchen with granite countertops, ideal for hosting gatherings. Two fireplaces add warmth and charm, while recent updates such as a brand-new in-ground cesspool, a replaced roof, and a finished basement ensure a move-in-ready experience. The large deck overlooks a spacious backyard, offering endless possibilities for outdoor living and entertainment. This property enjoys unparalleled access to local amenities and the picturesque waterfront of Manhasset Bay, and is just minutes from shopping, dining, and public transportation with access to parking, ensuring the ultimate blend of convenience and luxury. This home is designed to meet the needs of the most discerning buyer. 34
    2 Stonytown Rd North Hempstead, NY 11030
    $1,898,000
    5 Bedrooms 2 Full Baths 1 Half Bath Sq. Ft. 3320.00:#
    Single Family For Sale ML# 3579316
    Nestled in the prestigious village of Plandome Manor in Manhasset, this exquisite home offers over 3, 300-square-foot of living space with a perfect blend of luxury and convenience. The grand entrance opens to an expansive den with a stunning vaulted cathedral ceiling, creating an immediate sense of elegance and openness. Set on nearly half an acre of land, the home features beautiful updates including refined oak wood floors and a renovated kitchen with granite countertops, ideal for hosting gatherings. Two fireplaces add warmth and charm, while recent updates such as a brand-new in-ground cesspool, a replaced roof, and a finished basement ensure a move-in-ready experience. The large deck overlooks a spacious backyard, offering endless possibilities for outdoor living and entertainment. This property enjoys unparalleled access to local amenities and the picturesque waterfront of Manhasset Bay, and is just minutes from shopping, dining, and public transportation with access to parking, ensuring the ultimate blend of convenience and luxury. This home is designed to meet the needs of the most discerning buyer.
    Presented By: LAFFEY REAL ESTATE  516-627-4343
    Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
  • 485 Arlington Rd is a sun-filled gracious colonial new to the market! This 3500+ sq ft refined home sits on almost .25 acre of professionally landscaped grounds in Cedarhurst SD#15. With 5 bedrooms and 3.5 baths, the oversized rooms provide ease of use, comfort, and a provide the perfect flow for entertaining. The home features a large newly renovated eat-in-kitchen, a formal living room with fireplace and formal dining room all with original coffered ceilings, and a primary suite with en suite bath and extra-large closets. In addition there are high ceilings throughout, gleaming hardwood floors, 2 zone gas heat, 2 zone central air, tremendous storage, a 2 car garage, an xl private driveway, an in-ground sprinkler system, a security system, a large brick patio, and lush landscaped grounds. Low Taxes too!! This lovely home is conveniently located to railroad, public transportation, schools, restaurants, shopping and Houses of Worship. Must See! 36
    485 Arlington Rd Hempstead, NY 11516
    $1,898,000
    5 Bedrooms 3 Full Baths 1 Half Bath Sq. Ft. 3510.00:#
    Single Family For Sale ML# 3570303
    485 Arlington Rd is a sun-filled gracious colonial new to the market! This 3500+ sq ft refined home sits on almost .25 acre of professionally landscaped grounds in Cedarhurst SD#15. With 5 bedrooms and 3.5 baths, the oversized rooms provide ease of use, comfort, and a provide the perfect flow for entertaining. The home features a large newly renovated eat-in-kitchen, a formal living room with fireplace and formal dining room all with original coffered ceilings, and a primary suite with en suite bath and extra-large closets. In addition there are high ceilings throughout, gleaming hardwood floors, 2 zone gas heat, 2 zone central air, tremendous storage, a 2 car garage, an xl private driveway, an in-ground sprinkler system, a security system, a large brick patio, and lush landscaped grounds. Low Taxes too!! This lovely home is conveniently located to railroad, public transportation, schools, restaurants, shopping and Houses of Worship. Must See!
    Presented By: Howard Hanna Coach  516-374-0100
    Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
  • NEW CONSTRUCTION Spacious and Stylish, in a private Beach community. This thoughtfully designed plan, features 5 beds, 4.5 bath. Two en-suite primary bedrooms. 9ft ceilings thru out. Designer kitchen with island. Second floor has an additional bonus space. Large walkout basement with 9 ft ceilings.Heated pool and outdoor showing add to the North Fork experience.Close to winery’s, shopping and transportation. Additional Information: ParkingFeatures:1 Car Attached, 4
    1855 Greenway East Southold, NY 11957
    $1,895,000
    5 Bedrooms 4 Full Baths 1 Half Bath Sq. Ft. 2950.00:#
    Single Family For Sale ML# H6335251
    NEW CONSTRUCTION Spacious and Stylish, in a private Beach community. This thoughtfully designed plan, features 5 beds, 4.5 bath. Two en-suite primary bedrooms. 9ft ceilings thru out. Designer kitchen with island. Second floor has an additional bonus space. Large walkout basement with 9 ft ceilings.Heated pool and outdoor showing add to the North Fork experience.Close to winery’s, shopping and transportation. Additional Information: ParkingFeatures:1 Car Attached,
    Presented By: Corcoran Baer & McIntosh  845-358-9440
    Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
Showing 1771 - 1780 of 17909 results| view:  results per page« first|...|176|177|178|179|...|last »
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