$4,899,000

123 Barrett Rd Lawrence, NY 11559

Estimated payment $27,945/month

Total Views 9,267
6 Beds
6 Baths
5,400 Sq Ft
$907 Price per Sq Ft

Highlights

  • Water Views
  • Basketball Court
  • Solar Heated In Ground Pool
  • On Golf Course
  • Building Security
  • Estate

About This Home

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!

Listing Agent

Etty Levy

BERKSHIRE HATHAWAY Brokerage Phone: 516-295-3000 License #10401356366 Listed on: 03/18/2025

BERKSHIRE HATHAWAY

Co-Listing Agent

Jordan Rosenberg

BERKSHIRE HATHAWAY Brokerage Phone: 516-295-3000 License #10401380214

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $24,870

Year Built

  • Built in 1950

Lot Details

  • 1.58 Acre Lot
  • On Golf Course
  • Landscaped
  • Front and Back Yard Sprinklers
  • Garden
  • Back Yard Fenced and Front Yard

Parking

  • 2 Car Attached Garage
  • Electric Vehicle Home Charger
  • Driveway

Home Design

  • Estate
  • Contemporary Architecture
  • Frame Construction
  • Stone Siding
  • Vinyl Siding

Interior Spaces

  • 5,400 Sq Ft Home
  • Indoor Speakers
  • Ceiling Fan
  • Chandelier
  • Wood Burning Stove
  • Casement Windows
  • Entrance Foyer
  • Living Room with Fireplace
  • 3 Fireplaces
  • Formal Dining Room
  • Water Views

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Microwave
  • Dishwasher
  • Wine Refrigerator
  • Kitchen Island
  • Marble Countertops
  • Granite Countertops

Flooring

  • Wood
  • Carpet
  • Radiant Floor
  • Tile

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Main Floor Bedroom
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • Double Vanity

Laundry

  • Laundry Room
  • Washer and Dryer Hookup

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Home Security

  • Video Cameras
  • Fire and Smoke Detector

Pool

  • Solar Heated In Ground Pool
  • Pool Cover

Outdoor Features

  • Basketball Court
  • Deck
  • Patio
  • Outdoor Speakers
  • Fire Pit
  • Pergola

Location

  • Property is near a golf course

Schools

  • Lawrence Early Childhood-#4 Elementary School
  • Lawrence Middle School At Broadway Campus
  • Lawrence Senior High School

Utilities

  • Central Air
  • Radiant Heating System
  • Baseboard Heating
  • Hot Water Heating System
  • Well
  • Septic Tank

Community Details

  • Building Security
  • Building Fire Alarm

Listing and Financial Details

  • Exclusions: Chandelier in Dining Room, Chandelier in Entrance
  • Assessor Parcel Number 2023-40-112-00-0024-0

Home Details

Home Type

Single Family

Est. Annual Taxes

$24,870

Year Built

Built in 1950

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Architectural Style: Contemporary, Estate
  • Property SubType: Single Family Residence
  • Exclusions: Chandelier in Dining Room, Chandelier in Entrance
  • Year Built: 1950
  • Attribution Contact: 516-295-3000
  • Co List Office Mls Id: KEYBHHS04
  • Co List Office Phone: 516-295-3000
  • Carport Y N: No
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dishwasher, Electric Cooktop, Electric Oven, Microwave, Refrigerator, Wine Refrigerator
  • Interior Amenities: 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
  • Fireplaces: 3
  • Flooring: Carpet, Hardwood, Tile
  • Fireplace Features: Family Room, Living Room, Wood Burning Stove
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Basement: Finished, Full, Walk-Out Access
  • Total Bedrooms: 6
  • Fireplace: Yes
  • Living Area: 5400
  • Window Features: Casement, Floor to Ceiling Windows
  • Other Equipment: Pool Equip/Cover
  • Basement YN: Yes

Exterior Features

  • Other Structures: Pergola
  • Construction Materials: Foam Insulation, Frame, Stone, Vinyl Siding
  • Fencing: Back Yard
  • Pool Features: In Ground, Pool Cover, Solar Heat
  • Pool Private: Yes
  • Spa: No
  • View: Water
  • Exterior Features: Basketball Court, Fire Pit, Garden, Gas Grill, Speakers
  • Patio and Porch Features: Deck, Patio
  • Waterfront: No

Garage/Parking

  • Total Parking Spaces: 40
  • Garage Spaces: 2
  • Garage: Yes
  • Parking Description: Attached, Driveway, Electric Vehicle Charging Station(s), Garage

Utilities

  • Cooling: Central Air
  • Heating: Baseboard, Electric, Hot Air, Hot Water, Radiant, Radiant Floor
  • Laundry Features: Electric Dryer Hookup, Laundry Room
  • Security: Building Security, Fire Alarm, Smoke Detector(s), Video Cameras
  • Sewer: Septic Tank
  • Utilities: Sewer Connected
  • Water Source: Well

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Schools

  • Middle School: LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS

Lot Info

  • Horses: No
  • Lot Size Acres: 1.58
  • Lot Features: Back Yard, Front Yard, Landscaped, Near Golf Course, On Golf Course, Sprinklers In Front, Sprinklers In Rear
  • Parcel Number: 2023-40-112-00-0024-0
  • Property Attached: No

Rental Info

  • Lease Considered: No

Tax Info

  • Tax Annual Amount: 24870.5
  • Tax Year: 2025

MLS Schools

  • Elementary School: Lawrence Early Childhood-#4 School
  • High School: Lawrence Senior High School
  • Middle School District: Lawrence

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $7,341 $1,604 $921 $683
2024 $7,341 $1,610 $924 $686
2023 $19,187 $1,610 $924 $686
2022 $19,187 $1,610 $924 $686
2021 $23,423 $1,994 $1,145 $849
2020 $21,434 $2,046 $1,642 $404
2019 $20,856 $2,192 $1,649 $543
2018 $21,494 $2,338 $0 $0
2017 $15,116 $2,484 $1,661 $823
2016 $22,295 $2,630 $1,586 $1,044
2015 $7,462 $2,776 $1,492 $1,284
2014 $7,462 $2,776 $1,492 $1,284
2013 $7,232 $2,916 $1,567 $1,349
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/18/2025 03/18/25 For Sale $4,899,000 -- $907 / Sq Ft
Source: OneKey® MLS

Purchase History

Date Type Sale Price Title Company
Bargain Sale Deed -- Fidelity National Title
Interfamily Deed Transfer -- Fidelity National Title Ins
Deed $1,675,000 --
Deed $960,000 --
Interfamily Deed Transfer $305,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $500,000 Commercial
Source: Public Records

Source: OneKey® MLS

MLS Number: 831476

OneKey® MLS

APN: 2023-40-112-00-0024-0