123 Barrett Road
Lawrence, NY 11559
- 6 beds
- 6 baths
- 5,400 sqft
- ~2 acre lot
- $907 per sqft
- 1950 build
- – on site
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, 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. 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.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Mar 5, 2025
•
MLS# 831476 —
The Building
-
Year Built:1950
-
Basement:true
-
Architectural Style:Contemporary, Estate
-
Construction Materials:Foam Insulation, Frame, Stone, Vinyl Siding
-
Patio And Porch Features:Deck, Patio
-
Building Area Units:Square Feet
-
Exterior Features:Basketball Court, Fire Pit, Garden, Gas Grill, Speakers
-
Window Features:Casement, Floor to Ceiling Windows
-
Security Features:Building Security, Fire Alarm, Smoke Detector(s), Video Cameras
-
Laundry Features:Electric Dryer Hookup, Laundry Room
-
Attic:Partially Finished
Interior
-
Living Area:5400
-
Total Rooms:12
-
Interior Features:First Floor Bedroom, Breakfast Bar, Ceiling Fan(s), Chandelier, Double Vanity, Eat-in Kitchen, Entrance Foyer, Formal Dining, Granite Counters, Heated Floors, Kitchen Island, Marble Counters, Primary Bathroom, Speakers, Walk-In Closet(s), Washer/Dryer Hookup
-
Fireplace Features:Family Room, Living Room, Wood Burning Stove
-
Fireplaces Total:3
-
Fireplace:true
-
Flooring:Carpet, Hardwood, Tile
-
Living Area Source:Other
-
# of Kitchens:1
Financial & Terms
-
Lease Considered:false
The Property
-
Fencing:Back Yard
-
Lot Features:Back Yard, Front Yard, Landscaped, Near Golf Course, On Golf Course, Sprinklers In Front, Sprinklers In Rear
-
Lot Size Acres:1.58
-
Parcel Number:2023-40-112-00-0024-0
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Property Attached:false
-
Waterfront:false
-
Other Equipment:Pool Equip/Cover
-
Horse:false
Listing Agent
- Contact info:
- Agent phone:
- (516) 852-1439
- Office phone:
- (516) 295-3000
Taxes
-
Tax Year:2025
-
Tax Source:Other
-
Tax Annual Amount:22536
Beds
-
Total Bedrooms:6
Baths
-
Full Baths:4
-
Half Baths:2
-
Total Baths:6
The Listing
-
Special Listing Conditions:None
Heating & Cooling
-
Heating:Baseboard, Electric, Hot Air, Hot Water, Radiant
-
Cooling:Central Air
-
# of Heating Zones:3
Utilities
-
Sewer:Septic Tank
-
Utilities:Sewer Connected
-
Water Source:Dug Well
-
Electric Company:Pseg
Appliances
-
Appliances:Dishwasher, Electric Cooktop, Electric Oven, Microwave, Refrigerator, Wine Refrigerator
Schools
-
High School:Lawrence Senior High School
-
Elementary School:Lawrence Early Childhood #4 School
-
High School District:Lawrence
-
Middle School:LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS
The Community
-
Association:false
-
Senior Community:false
-
Pool Features:In Ground, Pool Cover, Solar Heat
-
Pool Private:true
-
Spa:false
Parking
-
Parking Features:Attached, Driveway, Electric Vehicle Charging Station(s), Garage
-
Parking Total:40
-
Garage:true
-
Garage Spaces:2
-
Carport:false
Extra Units
-
Other Structures:Pergola
Monthly cost estimate

Asking price
$4,899,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$26,232
|
Taxes | $1,878 |
Insurance | $1,347 |
Utilities | $373 See report |
Total | $29,830/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
3/5/25
Mar 5, 2025
|
Coming Soon | ONEKEY | $4,899,000 |