#821749, Listing Office: Realty Connect USA LLC
$4,899,000 List price
123 Barrett Rd Lawrence, NY 11559
6 beds
4 full, 2 partial
5,400 sqft
1.6 acres
$907 / sqft
House
Property details
About 123 Barrett Rd
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.
Highlights
Home typeSingle Family Residence
HeatingBaseboard, Electric, Forced Air, Hot Water, Radiant, Radiant Floor
StatusActive
CoolingCentral Air
Size5,400 sqft
BasementYes
Lot size1.58 Acres
Year built1950
ParkingAttached, Driveway, Electric Vehicle Charging Station(s), Garage
MLS #831476
Garage2 spaces
ViewWater
Private poolYes
Virtual tour
Summary
- MLS Number: 831476
- MLS Name: ONEKEY2
- Office Name: BERKSHIRE HATHAWAY
- Office Phone: (516) 295-3000
Listings courtesy of OneKey MLS as distributed by MLS GRID.
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.
The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the OneKey™ MLS. Real Estate listings held by brokerage firms other than this broker are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers. This information is provided exclusively for consumers’ personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed.
Information Copyright 2025, OneKey™ MLS. All Rights Reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
This advertisement does not suggest that the broker has a listing in this property or properties or that any property is currently available.
Last updated on: 4/12/2025, 9:11:49 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹
$4,899,000
123 Barrett Rd
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
| Date | Event | Price |
|---|---|---|
| Jun 16, 2004 | Home Sold | $1,675,000 |
| Nov 12, 1993 | Home Sold | $984,520 |
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2024 | $1,610 | $7,341 |
| 2023 | $1,610 | $19,186 |
| 2022 | $1,610 | $17,541 |
| 2021 | $1,994 | $24,242 |
| 2020 | $1,994 | $20,855 |
| 2019 | $2,192 | $21,493 |
| 2018 | $2,338 | $22,132 |
| 2017 | $2,484 | $22,295 |
History based on county public records data.
Nearby schools
4
Lawrence Elementary School
Public District 4-6
0.7 mi
•195 Broadway
6
P.S. 197 The Ocean School
Public District KG-6
0.9 mi
•825 Hicksville Rd
10
Success Academy Charter School-Far Rockaway
Public Charter KG-5
1.2 mi
•1045 Nameoke St Fl 3
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $183,088. The most common annual income of people living in Lawrence, NY is between $100k-200k. Residents typically live in married, no kids family. The majority of residents in this area have post secondary degree education.
How much money do the neighbors make?
0%
<35k
19%
35k-100k
42%
100k-200k
39%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
What types of families live nearby?
15%
Single, No Kids
3%
Single, with Kids
47%
Married, No Kids
35%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
15%
<11 yrs old
15%
12-17 yrs old
12%
18-34 yrs old
38%
35-64 yrs old
20%
65+ yrs old
What do the neighbors do for fun?
Men's Tennis
Skiing/snowboarding
PGA/LPGA
Where do the neighbors shop?
Bloomingdales
Nordstrom
Chico's
Where do the neighbors go to eat?
Bonefish Grill
California Pizza Kitchen
Qdoba
What do the neighbors drive?
Lexus
BMW
Cadillac
What do the neighbors listen to?
News
Talk/Personality
Classical
All data provided by Home Junction and Claritas
Similar homes for sale
#811761, Listing Office: BERKSHIRE HATHAWAY
$10,000 Closing Credit¹
#820777, Listing Office: Keller WIlliams Realty Liberty
$10,000 Closing Credit¹
#L3573240, Listing Office: BERKSHIRE HATHAWAY
$10,000 Closing Credit¹
#836470, Listing Office: Howard Hanna Coach
#832911, Listing Office: World Prop Intl Sea to Sky
$10,000 Closing Credit¹
#811031, Listing Office: Pin It Realty LLC
Frequently asked questions
About 123 Barrett Rd
This home is located at 123 Barrett Rd in Lawrence, NY and zip code 11559 in the Town of Hempstead neighborhood. This 5,400 square foot home, which was built in 1950, sits on a 1.58 acre lot. Features: 6 bedrooms, 6 bathrooms. It has been listed on Rocket Homes since March 5, 2025 and is currently priced at $4,899,000.
In March 2025 more than 0 listings in Lawrence, NY were sold above the asking price. During the same period more than 1 listings were sold at asking price, while more than 2 were sold below. The number of homes for sale in Lawrence, NY increased by 15.4% between February and March 2025. In March 2025, listings were on the market for 108 days. During the same period, the median list price in this real estate market was $2,150,000.
From Rocket Homes Real Estate and based on county public records data.