Seller's Agent in 2024
Cheryl Constantine
Douglas Elliman Real Estate
(516) 978-8785
10 in this area
36 Total Sales
20 S Equestrian Ct Hauppauge, NY 11788
Estimated Value: $1,141,000 - $1,363,000
5
Beds
5
Baths
--
Sq Ft
1.29
Acres
Highlights
- In Ground Pool
- Panoramic View
- Colonial Architecture
- Hauppauge Middle School Rated A-
- 1.29 Acre Lot
- Deck
About This Home
As of May 2024Welcome to your dream home! If you're looking for a delightful blend of luxury & natural beauty, then you will be able to move right in to this phenomenal home & immediately enjoy your own private backyard oasis & ultimate vacation style property without ever leaving home. Most desirable end of cul-de-sac location, backing 60 acres of serene greenbelt for extraordinary nature ambiance & privacy, 1.29 acre professionally landscaped property, numerous specimen trees, exterior lighting, rock walls, 30x50 lake style gunite heated pool with oversized spa, waterfalls flowing into spa & then cascading into main pool, surrounded by bluestone patio. 14000 gallon Koi Pond practically maintenance free with top of the line combination bead filtration, vortex, & settling pond, moss rocked stream with bridge over the top. An absolute dream backyard! Entire house hooked up to top of the line gas generator in case of storms/power outages. Inside the home is almost completely updated, many custom details by a well known Manhattan designer. Shows like a model home with exquisite architectural details throughout. Coffered ceiling in the spacious 2nd floor primary suite with full wall of built-ins, surround sound, additional closet space, custom makeup vanity with granite countertops. Balcony overlooking backyard. Updated primary bathroom with large spa-like shower, jets in every direction + rain shower & separate removable showerhead, vaulted ceilings, skylight, custom cabinets with granite countertop. Full bathroom & 3 additional generous sized bedrooms on 2nd floor (one being used as enormous walk-in closet, which the seller plans to take system with them when they move). Guest bedroom & full bathroom on the main level. Italian granite & marble throughout the house. Limestone kitchen floors & foyer. Custom built great room & den with wet bar, gas fireplace, oak wood floors, 400 gallon custom built aquarium with practically maintenance free filtration. All top of the line kitchen appliances, sub zero refrigerator, Wolfe double wall oven, warming drawer & cooktop, Miele dishwasher, 2 extra Sub Zero built-in refrigerator drawers, wine cooler, cherry wood cabinetry. Pasta pot filler faucet over cooktop. Half bathroom with trey ceiling & all stone moldings from Italy. Updated circuit breakers in full finished basement w/gym area, gaming area, laundry, utilities. Garage tech system + storage in the 2 car attached garage with inside entrance. Huge Driveway, wrought iron fence, desirable curb appeal. Don't miss out, this one won't last long on the market!
Last Agent to Sell the Property
Douglas Elliman Real Estate Brokerage Phone: 516-759-0400 License #30MU1019046 Listed on: 04/13/2024
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $16,973
Year Built
- Built in 1992 | Remodeled in 2017
Lot Details
- 1.29 Acre Lot
- Cul-De-Sac
- East Facing Home
- Private Entrance
- Back Yard Fenced
- Private Lot
- Sprinkler System
Parking
- 2 Car Attached Garage
- Driveway
- On-Street Parking
- Off-Street Parking
Home Design
- Colonial Architecture
- Frame Construction
- Wood Siding
Interior Spaces
- Wet Bar
- Cathedral Ceiling
- 1 Fireplace
- New Windows
- Entrance Foyer
- Formal Dining Room
- Den
- Storage
- Panoramic Views
- Finished Basement
- Basement Fills Entire Space Under The House
- Home Security System
Kitchen
- Eat-In Kitchen
- Marble Countertops
- Granite Countertops
Flooring
- Wood
- Wall to Wall Carpet
Bedrooms and Bathrooms
- 5 Bedrooms
- Main Floor Bedroom
- Walk-In Closet
- Powder Room
- In-Law or Guest Suite
Outdoor Features
- In Ground Pool
- Balcony
- Deck
- Patio
Location
- Borders State Land
Schools
- Bretton Woods Elementary School
- Hauppauge Middle School
- Hauppauge High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Cesspool
Listing and Financial Details
- Legal Lot and Block 1 / 0001
- Assessor Parcel Number 0500-029-00-01-00-001-002
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 13, 2024
Closed on
May 29, 2024
Sold by
Schiffman David
Bought by
Syed Fatima
Seller's Agent
Cheryl Constantine
Douglas Elliman Real Estate
Buyer's Agent
Ronnie Ali
Winzone Realty Inc
List Price
$1,450,000
Sold Price
$1,450,000
Views
80
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$179,000
Avg. Annual Appreciation
-0.11%
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Syed Fatima | $145,000 | Misc Company | |
| Syed Fatima | $145,000 | Misc Company |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 05/31/2024 05/31/24 | Sold | $1,450,000 | 0.0% | -- |
| 04/26/2024 04/26/24 | Pending | -- | -- | -- |
| 04/20/2024 04/20/24 | For Sale | $1,450,000 | -- | -- |
Source: OneKey® MLS
Tax History Compared to Growth
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 |
|---|---|---|---|---|
| 2024 | -- | $76,100 | $22,800 | $53,300 |
| 2023 | -- | $76,100 | $22,800 | $53,300 |
| 2022 | $13,126 | $76,100 | $22,800 | $53,300 |
| 2021 | $13,126 | $76,100 | $22,800 | $53,300 |
| 2020 | $13,455 | $76,100 | $22,800 | $53,300 |
| 2019 | $13,126 | $0 | $0 | $0 |
| 2018 | -- | $76,100 | $22,800 | $53,300 |
| 2017 | $13,862 | $76,100 | $22,800 | $53,300 |
| 2016 | $13,300 | $76,100 | $22,800 | $53,300 |
| 2015 | -- | $76,100 | $22,800 | $53,300 |
| 2014 | -- | $76,100 | $22,800 | $53,300 |
Source: Public Records
Agents Affiliated with this Home
-
Cheryl Constantine
-
Ronnie Ali
R
Buyer's Agent in 2024
Ronnie Ali
Winzone Realty Inc
(718) 848-6200
1 in this area
15 Total Sales
Map
Source: OneKey® MLS
MLS Number: KEY3544474
APN: 0500-029-00-01-00-001-002
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale or lease on this web site comes in part from OneKey® MLS. Real estate listings held by brokerage firms other than Ten-X are marked with the OneKey® MLS logo or an abbreviated logo and detailed information about them includes the name of the listing broker.
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.
Copyright 2025 OneKey® MLS. All rights reserved.
Nearby Homes
- 47 Orchard St
- 9 Hamlet Dr
- 35 Rose St
- 14 Hamlet Dr
- 3 Primrose Ln Unit 3
- 5 Primrose Ln Unit 5
- 134 Lawrence Ave
- 45 Hamlet Dr
- 116 Southern Blvd
- 146 Walter Ave
- 143 Walter Ave
- 58 Hauppauge Rd
- 24 Victory St
- 1039 Terry Rd
- 243 Sunflower Ln
- 147 Wayne St
- 000 Long Island Motor Pkwy
- 76 Teddy Ct
- 115 Wood Ln
- 10 Jackson St
- 19 S Equestrian Ct
- 18 S Equestrian Ct
- 630 Bedford Ave
- 17 S Equestrian Ct
- 16 S Equestrian Ct
- 15 S Equestrian Ct
- 14 S Equestrian Ct
- 12 S Equestrian Ct
- 683 Bedford Ave
- 24 Michele Ln
- 10 S Equestrian Ct
- 9 S Equestrian Ct
- 20 Michele Ln
- 25 Michele Ln
- 16 Michele Ln
- 354 Liberty St
- 2056 Motor Pkwy
- 12 Michele Ln
- 687 Bedford Ave
- 1 N Equestrian Ct