• buy
  • rent
  • sell
  • agents
new developmentWORLD OF ELLIMAN
The latest in luxury property, lifestyle & culture, curated just for you.

company

  • about us
  • leadership
  • offices
  • press & news
  • elliman cares
  • join as an agent
  • careers
  • elliman global
  • investors

resources

  • WORLD OF ELLIMAN
  • elliman insider
  • magazines
  • market reports
  • research reports
  • Elliman Private Listings
  • Elliman Exclusives
  • Featured Cities
  • guides to buying & selling

brand portfolio

  • new development
  • commercial
  • relocation
  • sports & entertainment
  • farm & ranch
  • building broker specialists
  • title services
  • estate, trust & probate

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont
  • SITE MAP
  • TERMS
  • PRIVACY
  • COOKIE PREFERENCES
  • DO NOT SELL OR SHARE MY PERSONAL INFORMATION
  • NYS Housing Discrimination Disclosure Notice & Form
  • NYS Standard Operating Procedure
  • NYS Tenants' Rights to Reasonable Accommodations for persons with disabilities
  • California Consumer Privacy Act Notice
  • Texas Consumer Protection Notice
  • Texas Real Estate Commission Information About Brokerage Services
  • text of new york city human rights law
  • new york city commission on human rights
  • nyc source of income discrimination information
  • nyc source of income discrimination tenant faqs

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. FOR COLORADO VIEWERS, INFORMATION ABOUT NON-COMMERCIAL PROPERTIES IS PROVIDED EXCLUSIVELY FOR YOUR PERSONAL, NON-COMMERCIAL USE.

575 MADISON AVENUE, NEW YORK, NY 10022. 212.891.7000 © 2025 DOUGLAS ELLIMAN REAL ESTATE. EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES, OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS, AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT, OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY.LISTING DATA REFRESHED ON NOV 04 2025 AT 7:10 PM.

DOUGLAS ELLIMAN IS A LICENSED REAL ESTATE BROKER IN CALIFORNIA WITH LICENSE # 01947727, COLORADO WITH LICENSE # EC100053892, CONNECTICUT WITH LICENSE # REB.0314827, THE DISTRICT OF COLUMBIA WITH LICENSE # REO40000160, FLORIDA WITH LICENSE # CQ1020232, MARYLAND WITH LICENSE # 645270, MASSACHUSETTS WITH LICENSE # 422764, NEVADA WITH LICENSE # 1454643, NEW JERSEY WITH LICENSE # 0572105, NEW YORK WITH LICENSE # 10991211812, TEXAS WITH LICENSE # 9008706, AND VIRGINIA WITH LICENSE # 0226035659.

POWERED BY PURLIN.AI

123 Barrett Rd

lawrence, NY 11559

$4,899,000

  • 6 BR
    4 BA, 2 HALF BA
    APPROX. 5,400 SF

INTERESTED? LET'S CONNECT

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!

Details

5,400 Sq Ft

1.58 Private Acres Lot Size

Single Family Home

$24,871 Annual Tax

Built in 1950

MLS/Listing ID 831476

Amenities & Features

Casement Windows

Water View

Pool - Inground

Style - Estate

Ceiling Fans

Washer/Dryer Hookup

Lot - Back Yard

Parking - EV Charging Station

Wood Burning Stove Fireplace

Living Room Fireplace

Family Room Fireplace

Tile

Hardwood

Carpet

Heating - Radiant Floor

Heating - Radiant

Heating - Hot Water

Heating - Electric

Heating - Baseboard

Walk-in Closets

Kitchen Island

Microwave

Refrigerator

Parking - Attached

Wine Refrigerator

Backyard

Basketball Court

Garden

Gas Grill

Cooling - Central Air

Construction - Foam Insulation

Construction - Frame

Construction - Stone

Construction - Vinyl Siding

Style - Contemporary

Dishwasher

Electric Cooktop

Electric Oven

Parking - Driveway

Parking - Garage

Lot - Landscaped

Lot - Near Golf Course

Lot - On Golf Course

Electric Dryer Hookup

Laundry Room

Breakfast Bar

Chandelier

Double Vanity

Eat-in Kitchen

Entrance Foyer

Granite Countertops

Pool - Cover

Pool - Solar Heated

Deck

Patio

ONEKEY

Source of Data: ONEKEY MLS

estimate my mortgage

TOTAL MONTHLY COST

-

  • PRINCIPAL & INTEREST

    -

  • PROPERTY TAXES

    -

  • COMMON CHARGES

    -

HOME PRICE
DOWN PAYMENT
term
INTEREST

Interested in 123 Barrett Rd?