123 Barrett Rd

Lawrence, NY 11559

$4,899,000
Price
6
Beds
5,400 Sq. Ft.
$907 / Sq. Ft.
5,400
Sq. Ft.
$907
per Sq. Ft.
Virtual Tour
Virtual Tour
a front view of a house with a yard
a living room with furniture and a wooden floor
a living room with furniture fireplace and a large window
a living room with furniture a flat screen tv and a floor to ceiling window
a view of a dining room with furniture window and wooden floor
a kitchen with stainless steel appliances granite countertop a refrigerator a sink dishwasher a stove and white countertops with wooden floor
a living room with furniture and a large window
a living room with furniture and a flat screen tv
a spacious bedroom with a bed a couch and a book shelf
a view of counter top space with granite countertop a sink and cabinets
a bathroom with a toilet sink and mirror
a bedroom with a bed and a window
a bathroom with a sink and a mirror
a bedroom with bed and window
a living room with furniture and a flat screen tv
a bathroom with a granite countertop toilet sink and mirror
a bathroom with a toilet and shower
a bedroom with a bed and a dresser
a bedroom with a bed and a window
a bathroom with a toilet a sink and mirror
a utility room with dryer and washer
a living room with furniture and a wooden floor
a view of a backyard
a view of a building with a outdoor space
a view of a patio with table and chairs near a barbeque
a view of a backyard with a slide trees and wooden fence
a view of a park with houses park
a view of a trees with a yard
a view of a dining room with furniture window and outside view

Description

Step into 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...Step into 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 spectacular 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! All offers being reviewed!
  1. Listed by Etty A. Levy • BERKSHIRE HATHAWAY
    P: (516)-295-3000 C: (516)-852-1439 ELevy@bhhslaffey.com
  2. Listed by Jordan Rosenberg • BERKSHIRE HATHAWAY
    P: (516)-295-3000 C: (516)-459-0278 jrosenberg@bhhslaffey.com

Property Details for 123 Barrett Road

City/Township
Hempstead
View
Water
Architectural Style
Contemporary, Estate
Garage Spaces
2.00
Waterfront
No
Section Area
Causeway
LISTING UPDATED: 10/29/2025 07:09 AM

Property Details for 123 Barrett Road

StatusActive
MLS #831476
Days on Market318
Taxes$24,871 / year
HOA Fees-
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeSingle Family
Year Built1950
Lot Size1.58 AC / 68,824 SF
CountyNassau County

Location

Listing Courtesy of BERKSHIRE HATHAWAY, Etty A. Levy; BERKSHIRE HATHAWAY, Jordan Rosenberg
Add your commute

Virtual Tour

Building Information for 123 Barrett Road

Stories-Year Built1950Building Size-Lot Size1.58 AC / 68,824 SF

Payment Calculator

$25,949 per month

30 year fixed, 6.15% Interest

Principal and Interest

$23,877

Property Taxes

$2,073

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 123 Barrett Road

Summary
Location and General Information
  • Village: Lawrence
  • Senior Community YN: No
  • Directions: Causeway to Barrett Road.
  • Property Attached: No
  • Structure Type: false
  • State Or Province: NY
School Information
  • School District: Lawrence
  • Elementary School District: Lawrence
  • Elementary School: Lawrence Early Childhood-#4 School
  • Middle Or Junior School District: Lawrence
  • Middle Or Junior School: LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS
  • High School District: Lawrence
  • High School: Lawrence Senior High School
Rental
Rental
  • Lease Considered: No
Unit Information
Unit Information
  • Building Units Total: 1
Room Information
Room 1 Information
  • Room Level: Basement
  • Room Type: Basement
  • RoomDescription 1: Boiler Room, Bedroom, 1/2 Bath
Room 2 Information
  • Room Level: First
  • Room Description: Formal Living Room, Formal Dining Room, Kitchen, Den, Office, 1/2 Bath
Room 3 Information
  • Room Level: Other
  • Room Description: (Sub-Level 1) Bedroom With Full Bath En-Suite, Laundry Room
Room 4 Information
  • Room Level: Second
  • Room Description: Primary Bedroom En-Suite With Full Bath & Heated Floor & Tons Of Closets
Room 5 Information
  • Room Level: Third
  • Room Description: 4 Bedrooms (1BR W/Terrace), 2 Full Baths (1 being Jack & Jill)
Taxes and HOA Information
Taxes and HOA Information
  • Parcel Number: 2023-40-112-00-0024-0
  • Association: No
Interior and Exterior Features
Interior Features
  • Amenities: 1st Floor Bedrm, Back Yard, Basketball Court, Breakfast Bar, Building Security, Carpet, Casement, Ceiling Fan(s), Chandelier, Contemporary, Deck, Double Vanity, Eat in Kitchen, Electric Dryer Hookup, Entrance Foyer, Estate, Family Room, Fire Alarm, Fire Pit, Floor to Ceiling Windows, Formal Dining, Garden, Gas Grill, Granite Counters, Hardwood Floors As Seen, In Ground, Kitchen Island, Laundry Room, Living Room, Marble Counters, Patio, Pergola, Pool Cover, Primary Bathroom, Smoke Detector(s), Solar Heat, Speakers, Tile, Video Cameras, Walk In Closet, Washer/Dryer Hookup, Water View, Well, Wood Burning Stove
  • Interior 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, Walk-In Closet(s), Washer/Dryer Hookup
  • Appliances: Dishwasher, Electric Cooktop, Electric Oven, Microwave, Refrigerator, Wine Refrigerator
  • Number Of Kitchens: 1.0
  • Total Rooms: 12
  • Basement: Finished, Full, Walk-Out Access
  • Attic Description: Partially Finished
  • Fireplace: Yes
  • Fireplaces Total: 3
  • Fireplace Features: Family Room, Living Room, Wood Burning Stove
  • Location Amenities: Walk Out Basement, Basketball Court, Wood Burning Stove, Hardwood Floors As Seen, 1st Fl Master Bedroom, Dual Sinks, Eat in Kitchen, Entry Foyer, Foyer, Formal Dining Room, Granit Countertops, Island Kitchen, Marble Countertops, Walk In Closet, WD Hookup, Deck, Patio, In Ground Pool, Water View, Casement Windows
  • Laundry Features: Electric Dryer Hookup, Laundry Room
  • Security Features: Building Security,Fire Alarm,Smoke Detector(s),Video Cameras
  • Spa: No
  • Window Features: Casement,Floor to Ceiling Windows
  • Flooring: Carpet, Hardwood, Tile
  • Exclusions: Chandelier in Dining Room, Chandelier in Entrance
  • Living Area: 5,400.00
  • Basement: Yes
Exterior Features
  • Exterior Features: Basketball Court, Fire Pit, Garden, Gas Grill, Speakers
  • Exterior Property Features: Basketball Court, Fire Pit, Garden, Gas Grill, Speakers, In Ground, Pool Cover, Solar Heat, Deck, Patio, Attached, Driveway, Electric Vehicle Charging Station(s), Garage, Back Yard, Casement, Floor to Ceiling Windows, Front Yard, Landscaped, Near Golf Course, On Golf Course, Sprinklers In Front, Sprinklers In Rear
  • Elevation Certificate: No
  • Fencing: Back Yard
  • Patio And Porch Features: Deck,Patio
  • Construction Materials: Foam Insulation, Frame, Stone, Vinyl Siding
  • Other Structures: Pergola
  • Horse: No
  • Pool Private: Yes
  • Pool Features: In Ground,Pool Cover,Solar Heat
  • Pool Details: In Ground,Pool Cover,Solar Heat
Lot Information
  • Lot Features: Back Yard, Front Yard, Landscaped, Near Golf Course, On Golf Course, Sprinklers In Front, Sprinklers In Rear
  • Site Features: Back Yard, Front Yard, Landscaped, Near Golf Course, On Golf Course, Sprinklers In Front, Sprinklers In Rear
  • Building Area Units: Square Feet
Parking
  • Parking Features: Attached, Driveway, Electric Vehicle Charging Station(s), Garage
  • Parking Total: 40.00
  • Garage: Yes
  • Carport: No
Utilities
  • Cooling: Central Air
  • Heating: Baseboard, Electric, Hot Air, Hot Water, Radiant, Radiant Floor
  • Heat Fuel Type: Baseboard, Electric, Hot Air, Hot Water, Radiant, Radiant Floor
  • Number Of Heating Zones: 3
  • Sewer: Septic Tank
  • Water Source: Well
  • Utilities: Sewer Connected
Green Features
  • Green Features: Casement, Floor to Ceiling Windows, Dishwasher, Electric Cooktop, Electric Oven, Microwave, Refrigerator, Wine Refrigerator, Baseboard, Electric, Hot Air, Hot Water, Radiant, Radiant Floor, Basketball Court, Fire Pit, Garden, Gas Grill, Speakers, In Ground, Pool Cover, Solar Heat
Virtual Tour
Agent
Payment and Rate
  • Down Payment Resource: No

Property History for 123 Barrett Road

DateEvent & SourcePriceAppreciation
May 17, 2004

Sold (Public Record)

Public Record #242321207

$1,675,000—
DateEvent & SourcePrice
05/17/2004

Sold (Public Record)

Public Record #242321207

$1,675,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 123 Barrett Road

Taxable ValueLand$924Additions$686Total$1,610
Tax Record2025$22,536 ($1,878 / month)
Home Facts
Baths5Total Finished SqFt4,568 SqFtAbove Grade Finished SqFt4,253 SqFtFinished Basement SqFt315 SqFtStories2Lot Size68,825 SqFtStyleSingle Family ResidenceYear Built1950CountyNASSAUAPN40-112-00-0024Fireplace TypeHas Fireplace

Schools near 123 Barrett Road

This home is within Lawrence Union Free School District.
Rating
School
Type
Grades
Distance
Lawrence Primary School at #2 School
Public - K to 3
Lawrence Elementary School at Broadway Campus
Public - 1 to 6
Lawrence Middle School
Public - 7 to 8
Lawrence Senior High School
Public - 9 to 12
Rating
School
Distance
Lawrence Primary School at #2 School
PublicK to 3

Lawrence Elementary School at Broadway Campus
Public1 to 6

Lawrence Middle School
Public7 to 8

Lawrence Senior High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

Explore Nearby Homes

More information about 123 Barrett Road, Lawrence, NY 11559

123 Barrett Road is a single family home for sale in Lawrence, NY 11559. This property was listed for sale on March 18, 2025 by BERKSHIRE HATHAWAY, it's currently listed at $4,899,000. It has been on the market for a total of 318 days and was last sold on May 17, 2004. This listing's school district is Lawrence Union Free School District. Nearby schools include Lawrence Primary School at #2 School, Lawrence Elementary School at Broadway Campus and Lawrence Middle School. 123 Barrett Road is a 6-bed, 6-bath, 5,400 sqft single family home built in 1950.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of BERKSHIRE HATHAWAY, Etty A. Levy; BERKSHIRE HATHAWAY, Jordan Rosenberg

Based on information submitted to the MLS GRID as of 10/29/2025 07:09 AM. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed by MLS GRID. Use of the MLS GRID data may be subject to an end user license agreement prescribed by the applicable MLS of the Member Participant, if any, and as amended from time to time.