Keller Williams Landmark
    Vinny Thompson
    (718) 749-9192vinny@askvinnythompson.com
    • Search
    • Featured Properties
    • Pending Listings
    • Open Houses
    • 1000 House Challenge
    • ExcapeFromNYC
    • KW Real Estate Planner
    • Agent to Agent Referrals
    • Ask Vinny Thompson Podcast
    • Decluttering Services
    • Selling
    • Buying
    • Communities
      • Brooklyn
      • Queens
      • Long Island
      • Bronx
      • Yonkers
      • Mount Vernon
      • Manhattan
    • About
      • Meet Vinny
      • 100 House Challenge
      • My Videos
      • Articles
      • Testimonials
      • Fair Housing Notice
      • Standardized Operations
    • Contact
    • Vinny Thompson(718) 749-9192
      vinny@askvinnythompson.com
      Copy Email
    • 75-35 31st Avenue, STE 202
      Jackson Heights, NY 11370
      (718) 749-9192
      vinny@askvinnythompson.com

    Company

    • Home
    • About
    • Testimonials
    • Contact

    Services

    • Buying
    • Selling
    • Home Valuation
    • Mortgage Calculator

    Explore

    • Property Search
    • Featured Properties
    • Communities
    • Agent to Agent Referrals
    Keller Williams Landmark - Footer Logo
    • Standard Operating Procedure for Purchases of Real Estate
    • Fair Housing Notice
    • Privacy
    • Terms
    • DMCA
    • Accessibility
    • Fair Housing
    © 2025 Keller Williams Realty Landmark II. All rights reserved.
    Website built by CloseHack.
    OneKey MLS

    IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

    $4,899,000
    For Sale

    123 Barrett Road

    Hempstead, NY 11559
    6 beds | 5 baths | 1.58 acres | #831476
    • Save
    • Contact
    • Share
    • Price Change Alerts
    32 photos
    Type:Purchase
    Structure:House
    Zone:Residential

    Description

    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!

    • Interior Details
        • InteriorFirst Floor Bedroom, Breakfast Bar, Ceiling Fan(s), Chandelier, Double Vanity, Eat-in Kitchen, Entrance Foyer, Formal Dining, Gr
        • Fireplaces3
      • Heating & Cooling
        • HeatingBaseboard, Electric, Hot Air, Hot Water, Radiant, Radiant Floor
        • CoolingCentral Air
      • Beds & Baths
        • Bedrooms6
        • Bathrooms5
        • Full Baths4
        • Half Baths2
    • Property Details
        • Lot DescriptionBack Yard, Front Yard, Landscaped, Near Golf Course, On Golf Course, Sprinklers In Front, Sprinklers In Rear
        • Exterior MaterialsBasketball Court, Fire Pit, Garden, Gas Grill, Speakers
        • Pool FeaturesIn Ground, Pool Cover, Solar Heat
        • ViewWater
        • Pool1
      • Measurements
        • Acres1.58
      • Parking
        • Parking FeaturesAttached, Driveway, Electric Vehicle Charging Station(s), Garage
        • Parking TypeGarage
        • Parking Spaces2
        • Parking Garage1
    • Construction Details
        • Property TypePurchase
        • Basement1
      • Condition
        • Year Built1950
    • Utilities / Energy Details
        • AppliancesDishwasher, Electric Cooktop, Electric Oven, Microwave, Refrigerator, Wine Refrigerator
        • Utility FeaturesSewer Connected
        • Sewer InformationSeptic Tank
        • Utility SourceWell
    • Community and Neighborhood Details
        • Middle SchoolLAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS
        • Elementary SchoolLawrence Early Childhood-#4 School
        • High SchoolLawrence Senior High School
        • CountyNassau County
        • School DistrictLawrence
    • Financial Details
        • Original List Price$4,899,000
        • Taxes Annual$24,870
        • Days on Market (Cumulative)270
    • Other
        • MLS #831476

    Location

    Legal

    IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

    Last Updated: Today at 1:36 AM. Source: ONEKEY

    Provided By
    Listing Agent: Etty A. Levy (#KEY215894)
    Listing Office: BERKSHIRE HATHAWAY (#KEYBHHS04)

    Keller Williams LandmarkAsk Vinny Thompson team
    Facebook
    Google
    OR

    Interested in Purchasing 123 Barrett Road?

    Get an estimate on monthly payments on this property.

    Note: The results shown are estimates only and do not include all factors. Speak with a licensed agent or loan provider for exact details. This tool is sourced from CloseHack.

    Estimated Monthly Payment
    $0.00
    Loan Amount
    $0.00
    $
    years

    Down Payment

    $
    %
    10.0%

    Interest Rate

    %
    6.0%

    Tax Rate

    %
    2.6%
    $
    $
    annually
    $
    monthly