Welcome to this exquisite contemporary colonial estate, gracefully situated on over 1.5 acres of serene, park-like grounds. Stunning water views can be enjoyed throughout the house, creating a tranquil ambiance throughout the home. The expansive kitchen seamlessly connects to the open-concept den, serving as the heart of the home—perfect for family gatherings. For more formal entertaining, the property offers an elegant dining room and a spacious living room. The home features many floor to ceiling windows allowing for bright natural light and incredible water views. The full finished basement includes a cozy den, a bedroom, and a half bath, providing extra living space. A convenient first-floor bedroom with an en-suite full bath is ideal for guests or multigenerational living. The private primary suite, located on its own level, features a luxurious full bath for ultimate privacy, with many closets for storage. Additionally, there are four generously sized bedrooms and two full baths, ensuring ample space for family and guests. This estate offers both beauty and functionality, all while benefiting from low taxes!
For sale
$4,899,000
123 Barrett Road, Lawrence, NY 11559
6beds
5,400sqft
Single Family Residence, Residential
Built in 1950
1.58 Acres Lot
$-- Zestimate®
$907/sqft
$-- HOA
What's special
- 154 days
- on Zillow |
- 366 |
- 12 |
Zillow last checked: 7 hours ago
Listing updated: June 09, 2025 at 03:09am
Listing by:
BERKSHIRE HATHAWAY 516-295-3000,
Etty A. Levy 516-852-1439,
Jordan Rosenberg 516-459-0278,
BERKSHIRE HATHAWAY
Source: OneKey® MLS,MLS#: 831476

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 6
- Full bathrooms: 4
- 1/2 bathrooms: 2
Other
- Description: Formal Living Room, Formal Dining Room, Kitchen, Den, Office, 1/2 Bath
- Level: First
Other
- Description: (Sub-Level 1) Bedroom With Full Bath En-Suite, Laundry Room
- Level: Other
Other
- Description: Primary Bedroom En-Suite With Full Bath & Heated Floor & Tons Of Closets
- Level: Second
Other
- Description: 4 Bedrooms (1BR W/Terrace), 2 Full Baths (1 being Jack & Jill)
- Level: Third
Basement
- Description: Boiler Room, Bedroom, 1/2 Bath
- Level: Basement
Heating
- Baseboard, Electric, Hot Air, Hot Water, Radiant
Cooling
- Central Air
Appliances
- Included: Dishwasher, Electric Cooktop, Electric Oven, Microwave, Refrigerator, Wine Refrigerator
- Laundry: Washer/Dryer Hookup, Electric Dryer Hookup, Laundry Room
Features
- First Floor Bedroom, Breakfast Bar, Ceiling Fan(s), Chandelier, Double Vanity, Eat-in Kitchen, Entrance Foyer, Formal Dining, Granite Counters, Kitchen Island, Marble Counters, Primary Bathroom, Speakers
- Flooring: Carpet, Hardwood, Tile
- Windows: Casement, Floor to Ceiling Windows
- Basement: Finished,Full,Walk-Out Access
- Attic: Partially Finished
- Number of fireplaces: 3
- Fireplace features: Family Room, Living Room
Interior area
- Total structure area: 5,400
- Total interior livable area: 5,400 sqft
Video & virtual tour
Property
Parking
- Total spaces: 40
- Parking features: Attached, Driveway, Electric Vehicle Charging Station(s), Garage
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Patio & porch: Deck, Patio
- Exterior features: Basketball Court, Fire Pit, Garden, Gas Grill, Speakers
- Has private pool: Yes
- Pool features: In Ground, Pool Cover, Solar Heat
- Fencing: Back Yard
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
Lot
- Size: 1.58 Acres
- Features: Back Yard, Front Yard, Landscaped, Near Golf Course, On Golf Course, Sprinklers In Front, Sprinklers In Rear
Details
- Additional structures: Pergola
- Parcel number: 2023401120000240
- Special conditions: None
- Other equipment: Pool Equip/Cover
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary,Estate
- Property subtype: Single Family Residence, Residential
Materials
- Foam Insulation, Stone, Vinyl Siding
Condition
- Year built: 1950
Utilities & green energy
- Sewer: Septic Tank
- Utilities for property: Sewer Connected
Community & HOA
Community
- Security: Building Security, Fire Alarm, Smoke Detector(s), Video Cameras
HOA
- Has HOA: No
Location
- Region: Lawrence
Financial & listing details
- Price per square foot: $907/sqft
- Tax assessed value: $1,610,000
- Annual tax amount: $24,870
- Date on market: 3/18/2025
- Listing agreement: Exclusive Right To Sell
- Exclusions: Chandelier in Dining Room, Chandelier in Entrance
- Loading
- Loading