Welcome to this beautiful sprawling Farm Ranch located on the prestigious Duck Pond Road off of Piping Rock Road. Nestled on a spacious .68-acre lot, this exquisite 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., Additional information: Appearance:Mint++,Interior Features:Guest Quarters,Separate Hotwater Heater:Yes
Pending
$1,750,000
138 Duck Pond Road, Glen Cove, NY 11542
5beds
--sqft
Single Family Residence, Residential
Built in 1952
0.69 Acres Lot
$1,718,800 Zestimate®
$--/sqft
$-- HOA
What's special
Gas-burning fireplaceEnsuite bathroomExpansive great roomOutdoor dining areaCenter islandWalk-in closetSubzero refrigerator
- 262 days
- on Zillow |
- 143 |
- 0 |
Zillow last checked: 7 hours ago
Listing updated: March 31, 2025 at 01:05pm
Listing by:
Douglas Elliman Real Estate 631-549-4400,
Kerri E. Striano,
Alissa Striano 917-797-8640,
Douglas Elliman Real Estate
Source: OneKey® MLS,MLS#: L3561302

Travel times
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 5
Bedroom 1
- Description: 2nd Primary w/Ensuite Full Bath
- Level: First
Bedroom 2
- Description: Primary w/Ensuite Full Bath
- Level: Second
Bedroom 3
- Description: Additional bedroom
- Level: Second
Bathroom 1
- Description: Full
- Level: First
Bathroom 2
- Description: Full w/additional washer/dryer
- Level: Second
Other
- Description: Storage, Laundry Room
- Level: Basement
Other
- Description: Office
- Level: First
Other
- Description: Dining Room
- Level: First
Kitchen
- Description: Eat-In w/hi-end appliances, double wall oven, sub-zero fridge, 2 dishwashers
- Level: First
Living room
- Description: With woodburning/gas fireplace
- Level: First
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Convection Oven, Dishwasher, ENERGY STAR Qualified Appliances, Oven, Refrigerator, Indirect Water Heater
Features
- Cathedral Ceiling(s), Eat-in Kitchen, Entrance Foyer, Granite Counters, Pantry, Formal Dining, First Floor Bedroom, Primary Bathroom
- Flooring: Hardwood
- Basement: Full,Walk-Out Access
- Attic: Partial
- Number of fireplaces: 3
Video & virtual tour
Property
Parking
- Parking features: Garage Door Opener, Private, Attached
Features
- Levels: Three Or More
- Patio & porch: Patio
Lot
- Size: 0.69 Acres
- Dimensions: .69
- Features: Sprinklers In Front, Sprinklers In Rear, Near Public Transit
Details
- Parcel number: 0600230600000090
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence, Residential
Materials
- Brick, Shingle Siding
Condition
- Year built: 1952
- Major remodel year: 2004
Utilities & green energy
- Electric: Generator
- Water: Public
- Utilities for property: Trash Collection Public
Community & HOA
Community
- Features: Fitness Center
- Security: Security System
HOA
- Has HOA: No
Location
- Region: Glen Cove
Financial & listing details
- Tax assessed value: $899,750
- Annual tax amount: $18,052
- Date on market: 6/24/2024
- Listing agreement: Exclusive Right To Sell
- Loading