NOT LISTED FOR SALE

24 Hamlet Dr Unit 1 Mount Sinai, NY 11766

Estimated Value: $1,059,951 - $1,155,000

5 Beds
5.5 Baths
5,200 Sq Ft
$590/mo HOA Fee

Last Sold October 24, 2024

Last sale price $1,025,000 $197 Per Sq Ft

Est. 10% increase in value since last sale

Current estimated payment $7,766/month

85 Days on Market

Highlights

  • Golf Course Community
  • In Ground Pool
  • Panoramic View
  • Mount Sinai Middle School Rated A
  • Home fronts a pond
  • Floor-to-Ceiling Windows

About This Home

As of October 2024

EXQUISITE GLEN EAGLE ESTATE IN THE PRESTIGIOUS GATED COMMUNITY OF HAMLET WILLOW CREEK. Step into this luxurious home through glorious double doors, and be greeted by a breathtaking two-story glass living room wall offering panoramic views of the pond and golf course. This beautiful home boasts 5 bedrooms and 5.5 bathrooms, with a stunning open floor plan designed for both elegance and comfort. The sun-soaked family room, seamlessly connected to the kitchen, features sliding glass doors that open onto an oversized Trex deck overlooking the tranquil pond. The first floor also includes a bedroom with a full bathroom, a half bathroom, a formal dining room, and a convenient laundry room. On the second floor, the Primary Suite offers cathedral ceilings, oversized windows, an expansive walk-in closet, and a spa-like ensuite complete with a commode stall, shower, and soaking tub. The Junior Primary Suite includes its own ensuite bathroom. Two generously sized bedrooms share a Jack & Jill bathroom, ensuring comfort and privacy for all. The walk-out lower level features 9' ceilings and sliding glass doors leading to a paver patio, perfect for entertaining. This home is equipped with a Sonos whole-house entertainment system with CAT 5 wiring and speakers, an alarm system, central vacuum (CVAC), central air conditioning (CAC), and a dehumidifier system to maintain optimal humidity levels. The three-car garage, with an epoxy floor and its own CVAC system, adds both convenience and style. With 3-zone heating and 2-zone CAC, this home is designed for both luxury and efficiency. Welcome to your dream home in the heart of the prestigious Hamlet Willow Creek Community amenities include Inground pool, kiddie pool, hot tub, clubhouse with kitchen, locker rooms with sauna, gym, playground, tennis & basketball courts. THIS HOME IS A MUST SEE! LOW TAXES!!!

Last Agent to Sell the Property

Agustina DeLaCruz

BERKSHIRE HATHAWAY Brokerage Phone: 516-741-3070 License #10401253653 Listed on: 06/18/2024

BERKSHIRE HATHAWAY

Last Buyer's Agent

Jeffrey Stineback

Compass Greater NY LLC License #10401273040

Compass Greater NY LLC

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $12,306

Year Built

  • Built in 2006 | Remodeled in 2022

Lot Details

  • Home fronts a pond
  • No Common Walls

HOA Fees

  • $590 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Entry on the 1st floor
  • Frame Construction
  • Blown-In Insulation
  • Stone Siding
  • Vinyl Siding

Interior Spaces

  • 5,200 Sq Ft Home
  • 2-Story Property
  • Cathedral Ceiling
  • 1 Fireplace
  • Floor-to-Ceiling Windows
  • Entrance Foyer
  • Formal Dining Room
  • Storage
  • Wood Flooring
  • Panoramic Views
  • Home Security System

Kitchen

  • Eat-In Kitchen
  • Marble Countertops
  • Granite Countertops

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet
  • Powder Room
  • In-Law or Guest Suite

Finished Basement

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

Outdoor Features

  • Basketball Court
  • Balcony
  • Deck
  • Patio

Schools

  • Mount Sinai Elementary School
  • Mount Sinai Middle School
  • Mount Sinai High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Listing and Financial Details

  • Legal Lot and Block 170 / 1001
  • Assessor Parcel Number 0200-165-10-01-00-170-000

Community Details

Overview

  • Association fees include exterior maintenance, snow removal, trash
  • Gleneagle Estate Home

Amenities

  • Clubhouse
  • Community Kitchen

Recreation

  • Golf Course Community
  • Tennis Courts
  • Community Pool
  • Park

Pet Policy

  • Dogs and Cats Allowed

Security

  • Gated Community

Property Details

Home Type

Condominium

Est. Annual Taxes

$12,306

Year Built

Built in 2006 | Remodeled in 2022

Lot Details

0

HOA Fees

$590 per month

Listing Details

  • Property Type: Residential
  • Architectural Style: Other
  • Property SubType: Condominium
  • Property Condition: Mint
  • Levels: Two
  • Year Built: 2006
  • New Construction: No
  • Year Built Effective: 2022
  • Attribution Contact: 516-741-3070
  • Ownership: Condo
  • Special Features: None
  • Property Sub Type: Condos
  • Year Renovated: 2022

Interior Features

  • Interior Amenities: First Floor Bedroom, Cathedral Ceiling(s), Eat-in Kitchen, Floor to Ceiling Windows, Formal Dining, Entrance Foyer, Granite Counters, Guest Quarters, Marble Counters, Master Bath, Pantry, Powder Room, Storage, Walk-In Closet(s)
  • Living Area Units: Square Feet
  • Fireplaces: 1
  • Flooring: Hardwood
  • Common Walls: No Common Walls
  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Basement: Finished, Full, Walk-Out Access
  • Entry Level: 1
  • Total Bedrooms: 5
  • Fireplace: Yes
  • Living Area: 5200
  • AtticDescription: See Remarks
  • SquareFootage: 5200.00
  • SquareFootageSource: Municipality

Exterior Features

  • Construction Materials: Blown-In Insulation, Frame, Stone, Vinyl Siding
  • Waterfront Features: Pond
  • Pool Features: In Ground
  • Pool Private: Yes
  • View: Panoramic
  • Exterior Features: Balcony, Basketball Court, Tennis Court(s)
  • Patio and Porch Features: Deck, Patio
  • View YN: Yes
  • FloodZoneReportYN: 0

Garage/Parking

  • Attached Garage: Yes
  • Garage: Yes
  • Parking Description: Attached, 3 Car Attached

Utilities

  • Cooling: Central Air
  • Cooling: Yes
  • Heating: Natural Gas, Forced Air
  • Security: Security System
  • Sewer: Public Sewer
  • Water Source: Public
  • GarbageRemoval: Other
  • Hot Water: Gas Stand Alone

Condo/Co-op/Association

  • HOA Fee Includes: Exterior Maintenance, Snow Removal, Trash
  • Association Amenities: Kitchen In Clubhouse, Gated
  • Association Fee: 590
  • Association Fee Frequency: Monthly
  • Senior Community: No
  • DevelopmentName: Hamlet Willow Creek

Association/Amenities

  • Community Features: Clubhouse, Pool, Tennis Court(s), Golf, Gated, Park

Schools

  • Middle School: Mount Sinai Middle School

Lot Info

  • Lot Size Acres: 0.22
  • Lot Size Sq Ft: 9583
  • Parcel Number: 0200-165-10-01-00-170-000
  • Property Attached: No

Rental Info

  • Lease Considered: No
  • Pets Allowed: Dogs OK, Cats OK, Yes

Tax Info

  • Tax Annual Amount: 12306
  • Tax Block: 1001
  • Tax Lot: 170
  • Tax Map Number: 0200-165-10-01-00-170-000
  • IncludedInTaxes: Trash

MLS Schools

  • Elementary School: Mount Sinai Elementary School
  • High School: Mount Sinai High School
  • Middle School District: Mount Sinai

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 18, 2024
Closed on
Oct 10, 2024
Sold by
L-Rodriguez Viviana M
Bought by
Kim Eugene and Kim Irene
Seller's Agent
Agustina DeLaCruz
BERKSHIRE HATHAWAY
Buyer's Agent
Jeffrey Stineback
Compass Greater NY LLC
List Price
$1,050,000
Sold Price
$1,025,000
Premium/Discount to List
-$25,000
-2.38%
Views
123
Current Estimated Value
$1,124,488

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$99,488
Avg. Annual Appreciation
7.69%

Purchase Details

Closed on
Jan 19, 2021
Sold by
Iqbal Singh Gill T
Bought by
Lemoine-Rodriguez V M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$695,000
Interest Rate
5.88%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Aug 27, 2018
Sold by
Gill Iqbal and Gill Devendra
Bought by
Iqbal Singh Gill T

Purchase Details

Closed on
Oct 31, 2017
Sold by
Tseng Sally and Liao Vincent
Bought by
Gill Iqbal and Gill Devendra

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$754,400
Interest Rate
3.85%
Mortgage Type
Stand Alone Refi Refinance Of Original Loan

Purchase Details

Closed on
Mar 19, 2004
Sold by
The Hamlet At Willow Creek Llc
Bought by
Liao Vincent and Tseng Sally
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

Purchase History

Date Buyer Sale Price Title Company
Kim Eugene $1,025,000 None Available
Kim Eugene $1,025,000 None Available
Lemoine-Rodriguez V M $927,000 None Available
Lemoine-Rodriguez V M $927,000 None Available
Iqbal Singh Gill T -- --
Iqbal Singh Gill T -- --
Gill Iqbal $943,000 --
Gill Iqbal $943,000 --
Gill Iqbal $943,000 --
Gill Iqbal $943,000 --
Liao Vincent $720,000 Chicago Title
Liao Vincent $720,000 Chicago Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Lemoine-Rodriguez V M $695,000
Previous Owner Gill Iqbal $754,400
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
10/24/2024 10/24/24 Sold $1,025,000 +2.5% $197 / Sq Ft
09/12/2024 09/12/24 Pending -- -- --
07/26/2024 07/26/24 Price Changed $999,999 -4.8% $192 / Sq Ft
06/18/2024 06/18/24 For Sale $1,050,000 -- $202 / Sq Ft
Source: OneKey® MLS

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 $14,493 $3,309 $200 $3,109
2023 $14,493 $3,309 $200 $3,109
2022 $12,051 $3,309 $200 $3,109
2021 $12,051 $3,309 $200 $3,109
2020 $12,650 $3,309 $200 $3,109
2019 $12,650 $0 $0 $0
2018 -- $3,429 $200 $3,229
2017 $12,180 $3,429 $200 $3,229
2016 $12,127 $3,429 $200 $3,229
2015 -- $3,429 $200 $3,229
2014 -- $3,429 $200 $3,229
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: OneKey® MLS

MLS Number: KEY3560002

OneKey® MLS

APN: 0200-165-10-01-00-170-000