6 days on Rocket
#883537, Listing office: HomeCoin.com
$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 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!
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
- Partial Bathrooms: 2
- Full Bathrooms: 4
- Appliances: Dishwasher, Electric Cooktop, Electric Oven, Microwave, Refrigerator, Wine Cooler
- Basement: Yes
- Flooring Type: Carpet, Hardwood, Tile
- Interior: 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
- Total Bedroom Count: 6
- Garage Space: 2 spaces
- Private Pool: Yes
- Parking: Attached, Driveway, Electric Vehicle Charging Station(s), Garage
- View: Water
- Exterior: Basketball Court, Fire Pit, Garden, Gas Grill, Back Fence, Deck, Patio
- Architectural Style: Contemporary, Estate
- Heating: Baseboard, Electric, Forced Air, Hot Water, Radiant, Radiant Floor
- Cooling: Central Air
- List Price: $4,899,000
- Price/SqFt: $907
- Annual Tax Amount: $7,341
- Tax Year: 2024
- Lot: Back Yard, Front Yard, Landscaped, Near Golf Course, On Golf Course, Sprinklers In Front, Sprinklers In Rear
- Directions: Causeway to Barrett Road.
- Year Built: 1950
- Living Area: 5,400 SqFt
- Lot Size: 1.58 Acres
- 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.
DMCA Notice
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: 7/18/2025, 11:41:29 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
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 majority of Lawrence, NY residents have income between $100k-200k annually. Most families are married, no kids. The most common level of education of people living in this area is post secondary degree.
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
#833405, Listing office: Annett C Ellis Realty Inc
#862841, Listing office: BERKSHIRE HATHAWAY
#854310, Listing office: Howard Hanna Coach
#883185, Listing office: Five Towns Miller Realty Inc
#811761, Listing office: BERKSHIRE HATHAWAY
#845278, Listing office: Milky Forst Properties Inc
#882396, Listing office: Milky Forst Properties Inc
#852958, Listing office: BERKSHIRE HATHAWAY
#875917, Listing office: RPB Realty
Frequently asked questions
About 123 Barrett Rd
The listing price of 123 Barrett Rd property is $4,899,000.
The property 123 Barrett Rd is a house located in Lawrence, New York, 11559.
Active Listing: 123 Barrett Rd is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 123 Barrett Rd are: Lawrence Elementary School (GreatSchools Rating 4/10), P.S. 197 The Ocean School (GreatSchools Rating 6/10), Success Academy Charter School-Far Rockaway (GreatSchools Rating 10/10), Lawrence Middle School (GreatSchools Rating 3/10), Village Academy (GreatSchools Rating 6/10), I.S. 53 Brian Piccolo (GreatSchools Rating 3/10), Queens High School for Information, Research and Technology (GreatSchools Rating 5/10), Frederick Douglass Academy Vi High School (GreatSchools Rating 1/10), Acadey of Medical Technology - A College Board School (GreatSchools Rating 4/10).
According to the records, the last property tax for 2024 is $7,341 (source: MLS/based on county public records data).
The last sale was on June 16, 2004 for $1,675,000 (source: MLS/tax record).
The property at 123 Barrett Rd has 6 bedrooms and 4 full and 2 half bathrooms.
The property 123 Barrett Rd is 5,400 SqFt (source: MLS/tax record).
The year of construction for 123 Barrett Rd is 1950.
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.
Over 1 listings were sold over their listed price in June 2025 in Lawrence, NY. In the same period over 0 listings were sold below the listed price and 1 listings were sold for the listed price. Between May and June 2025, Lawrence, NY real estate market has seen increase in the number of listings by 10.3%. In June 2025, listings were on the market for 12 days. During the same period, the median list price in this real estate market was $1,200,000.
From Rocket Homes Real Estate and based on county public records data.