Redfin is joining Rocket

Discover how we're simplifying your journey home.

$4,899,000

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

IDX 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

IDXThe 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/12/2025, 7:41:27 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.

Price information

Property sales

DateEventPrice
Jun 16, 2004
Home Sold
$1,675,000
Nov 12, 1993
Home Sold
$984,520

Tax history

YearAssessmentProperty 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.

All data from GreatSchools

Neighborhood

The neighbors living near this home have an average income of $183,088. Residents of Lawrence, NY typically earn between $100k-200k each year. Typical family type is married, no kids. Residents of this area typically 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 TennisMen's Tennis
  • Skiing/snowboardingSkiing/snowboarding
  • PGA/LPGAPGA/LPGA

Where do the neighbors shop?

  • BloomingdalesBloomingdales
  • NordstromNordstrom
  • Chico'sChico's

Where do the neighbors go to eat?

  • Bonefish GrillBonefish Grill
  • California Pizza KitchenCalifornia Pizza Kitchen
  • QdobaQdoba

What do the neighbors drive?

  • LexusLexus
  • BMWBMW
  • CadillacCadillac

What do the neighbors listen to?

  • NewsNews
  • Talk/PersonalityTalk/Personality
  • ClassicalClassical
All data provided by Home Junction and Claritas

Similar homes for sale

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.

While more than 1 listings in Lawrence, NY in June 2025 were sold above asking price, there were more than 1 listings sold at asking price, and more than 0 were sold below. In June 2025 in Lawrence, NY there were 10.3% more homes for sale than in May. 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.

More resources