Skip main navigation
For sale
  • $4,899,000

    123 Barrett Road, Lawrence, NY 11559

    6beds
    5,400sqft
    Single Family Residence, Residential
    Built in 1950
    1.58 Acres Lot
    $-- Zestimate®
    $907/sqft
    $-- HOA

    What's special

    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!
    154 days
    on Zillow
    |
    366
    |
    12
    |

    Zillow last checked: 7 hours ago

    Listing updated: June 09, 2025 at 03:09am

    Listing by:

    BERKSHIRE HATHAWAY 516-295-3000,

    Etty A. Levy 516-852-1439,

    Jordan Rosenberg 516-459-0278,

    BERKSHIRE HATHAWAY

    Source: OneKey® MLS,MLS#: 831476MLS Logo
    Travel times

    Tour with a buyer's agent

    We'll find a local expert to take you on a private tour of 123 Barrett Road.

    Next available tour time:Today at 11am

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 6
    • Bathrooms: 6
    • Full bathrooms: 4
    • 1/2 bathrooms: 2
    Other
    • Description: Formal Living Room, Formal Dining Room, Kitchen, Den, Office, 1/2 Bath
    • Level: First
    Other
    • Description: (Sub-Level 1) Bedroom With Full Bath En-Suite, Laundry Room
    • Level: Other
    Other
    • Description: Primary Bedroom En-Suite With Full Bath & Heated Floor & Tons Of Closets
    • Level: Second
    Other
    • Description: 4 Bedrooms (1BR W/Terrace), 2 Full Baths (1 being Jack & Jill)
    • Level: Third
    Basement
    • Description: Boiler Room, Bedroom, 1/2 Bath
    • Level: Basement
    Heating
    • Baseboard, Electric, Hot Air, Hot Water, Radiant
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Electric Cooktop, Electric Oven, Microwave, Refrigerator, Wine Refrigerator
    • Laundry: Washer/Dryer Hookup, Electric Dryer Hookup, Laundry Room
    Features
    • 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
    • Flooring: Carpet, Hardwood, Tile
    • Windows: Casement, Floor to Ceiling Windows
    • Basement: Finished,Full,Walk-Out Access
    • Attic: Partially Finished
    • Number of fireplaces: 3
    • Fireplace features: Family Room, Living Room
    Interior area
    • Total structure area: 5,400
    • Total interior livable area: 5,400 sqft

    Property

    Parking
    • Total spaces: 40
    • Parking features: Attached, Driveway, Electric Vehicle Charging Station(s), Garage
    • Garage spaces: 2
    • Has uncovered spaces: Yes
    Features
    • Patio & porch: Deck, Patio
    • Exterior features: Basketball Court, Fire Pit, Garden, Gas Grill, Speakers
    • Has private pool: Yes
    • Pool features: In Ground, Pool Cover, Solar Heat
    • Fencing: Back Yard
    • Has view: Yes
    • View description: Water
    • Has water view: Yes
    • Water view: Water
    Lot
    • Size: 1.58 Acres
    • Features: Back Yard, Front Yard, Landscaped, Near Golf Course, On Golf Course, Sprinklers In Front, Sprinklers In Rear
    Details
    • Additional structures: Pergola
    • Parcel number: 2023401120000240
    • Special conditions: None
    • Other equipment: Pool Equip/Cover

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Contemporary,Estate
    • Property subtype: Single Family Residence, Residential
    Materials
    • Foam Insulation, Stone, Vinyl Siding
    Condition
    • Year built: 1950

    Utilities & green energy

    • Sewer: Septic Tank
    • Utilities for property: Sewer Connected

    Community & HOA

    Community
    • Security: Building Security, Fire Alarm, Smoke Detector(s), Video Cameras
    HOA
    • Has HOA: No
    Location
    • Region: Lawrence

    Financial & listing details

    • Price per square foot: $907/sqft
    • Tax assessed value: $1,610,000
    • Annual tax amount: $24,870
    • Date on market: 3/18/2025
    • Listing agreement: Exclusive Right To Sell
    • Exclusions: Chandelier in Dining Room, Chandelier in Entrance
    • Loading
    • Loading