$1,350,000
SOLD MAR 27, 2025

24 Hamlet Dr Plainview, NY 11803

4 Beds
2.5 Baths
2,917 Sq Ft
$752/mo HOA Fee

Recently Sold

$463 Per Sq Ft

4% Below List Price

83 Days on Market

Highlights

  • Lake Front
  • Basketball Court
  • Floor-to-Ceiling Windows
  • Judy Jacobs Parkway Elementary School Rated A+
  • In Ground Pool
  • Gated Community

About This Home

As of March 2025

The Hamlet at Olde Oyster Bay is a gated, self-contained, country- club living community with every possible amenity for today's discerning buyers. Rare and new to the market, this fully detached home has a primary on the main plus 3 additional bedrooms. Spacious, with nearly 3000 square feet of living space, this is the only home available with primary on the main. From the grand two-story entry to double height living spaces, floor to ceiling windows, a formal dining room, double height family room, open concept to eat-in center island kitchen, this floor plan is brilliant. The eat-in kitchen has stainless steel appliances, under counter lighting Microwave/Convection double oven combination, upgraded tall cabinets with crown molding, tumbled marble backsplash, granite counter-tops, hi-hat lighting and adjoining butler's pantry. The kitchen is open to a double height den with a custom built-in and sliders to rear kidney shaped patio. A main level primary has a tray ceiling, two walk-in closets, hi-hat lighting and sliders to rear. An ensuite marble bath has a jacuzzi tub, frameless door shower and dual sink vanity. On the second level there are three additional bedrooms, full bath and a large landing over-looking impressive views of the primary living spaces. This beautiful home has natural gas heating, floor to ceiling windows, hardwood floors, 2 car garage, private yard with mature trees and perennial gardens plus oversized patio. Natural light streams throughout this home. A very desirable 24-hour manned gated community with amenities including restaurant, bar, indoor and outdoor pools, club house, gym (his/her lockers), spa rooms, beauty salon, tennis, pickle ball, poolside snack bar and playground. A once in a lifetime to own a timeless home with rich appointments for the most particular buyers! Please inquire about buyer fees., Additional information: Appearance:Mint+,ExterioFeatures:Tennis

Last Agent to Sell the Property

Patti Pascullo

Douglas Elliman Real Estate Brokerage Phone: 516-921-2262 License #30PA0610102 Listed on: 09/05/2024

Douglas Elliman Real Estate

Last Buyer's Agent

Patti Pascullo

Douglas Elliman Real Estate Brokerage Phone: 516-921-2262 License #30PA0610102 Listed on: 09/05/2024

Douglas Elliman Real Estate

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $23,089

Year Built

  • Built in 2001

Lot Details

  • Lake Front
  • Front and Back Yard Sprinklers

HOA Fees

  • $752 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Frame Construction
  • Vinyl Siding

Interior Spaces

  • 2,917 Sq Ft Home
  • 2-Story Property
  • Central Vacuum
  • Built-In Features
  • Cathedral Ceiling
  • Drapes & Rods
  • Blinds
  • Floor-to-Ceiling Windows
  • Window Screens
  • Entrance Foyer
  • Formal Dining Room
  • Attic Fan
  • Home Security System

Kitchen

  • Eat-In Kitchen
  • Convection Oven
  • Cooktop
  • Microwave
  • Dishwasher
  • Marble Countertops
  • Granite Countertops

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom on Main
  • En-Suite Primary Bedroom
  • Walk-In Closet

Laundry

  • Dryer
  • Washer

Outdoor Features

  • In Ground Pool
  • Basketball Court
  • Patio
  • Private Mailbox

Schools

  • Plainview-Old Bethpage Middle Sch
  • Plainview-Old Bethpage/Jfk High School

Utilities

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

Listing and Financial Details

  • Exclusions: Chandelier(s),Grill
  • Legal Lot and Block 113 / 119
  • Assessor Parcel Number 2489-13-119-00-0113-0

Community Details

Overview

  • Association fees include exterior maintenance, snow removal, trash
  • Ashford

Amenities

  • Door to Door Trash Pickup
  • Clubhouse

Recreation

  • Tennis Courts
  • Community Pool
  • Community Spa

Security

  • Gated Community

Property Details

Home Type

Condominium

Est. Annual Taxes

$23,089

Year Built

Built in 2001

Lot Details

0

HOA Fees

$752 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Architectural Style: Other
  • Property SubType: Condominium
  • Levels: Two
  • Exclusions: Chandelier(s),Grill
  • Year Built: 2001
  • Attribution Contact: 516-921-2262
  • CurrentPrice: 1350000.00
  • MlsMajorChangeType: Sold
  • CurrentPrice_By_LivingArea: 462.80425
  • ListPrice_By_LivingArea: 479.60233
  • ListPrice_By_OriginalListPrice: 1.00000
  • Special Features: None
  • Property Sub Type: Condos

Interior Features

  • Appliances: Gas Water Heater, Convection Oven, Cooktop, Dishwasher, Dryer, Microwave, Oven, Refrigerator, Washer
  • Interior Amenities: Built-in Features, Central Vacuum, Entertainment Cabinets, Cathedral Ceiling(s), Eat-in Kitchen, Entrance Foyer, Granite Counters, Master Downstairs, Pantry, Walk-In Closet(s), Formal Dining, First Floor Bedroom, Marble Counters, Primary Bathroom
  • Flooring: Carpet, Hardwood
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: None
  • Inclusions: ,Alarm System,Attic Fan,B/I Shelves,Central Vacuum,Convection Oven,Cook Top,Curtains/Drapes,Dishwasher,Door Hardware,Dryer,Entertainment Cabinets,Garage Door Opener,Garage Remote,Mailbox,Microwave,Refrigerator,Screens,Shades/Blinds,Wall Oven,Wall to Wall
  • Stories: 2
  • Total Bedrooms: 4
  • Living Area: 2917
  • Window Features: Blinds, Drapes, Screens, Floor to Ceiling Windows
  • Basement YN: No
  • ResoLivingAreaSource: PublicRecords

Exterior Features

  • Construction Materials: Vinyl Siding, Frame
  • Waterfront Features: Lake Front
  • Pool Features: In Ground
  • Pool Private: Yes
  • Spa: Yes
  • Exterior Features: Mailbox, Basketball Court
  • Patio and Porch Features: Patio
  • Waterfront: Yes

Garage/Parking

  • Total Parking Spaces: 2
  • Garage Spaces: 2
  • Garage: Yes
  • Parking Description: Garage Door Opener, Attached, Driveway, Garage

Utilities

  • Cooling: Attic Fan, Central Air
  • Heating: Natural Gas, Forced Air
  • Security: Security System
  • Utilities: Trash Collection Public
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fee Includes: Exterior Maintenance, Other, Snow Removal, Trash
  • Association Amenities: Spa/Hot Tub, Trash, Gated, Tennis Court(s)
  • Association Fee: 751.89
  • Association Fee Frequency: Monthly
  • Senior Community: No
  • Phone: 516-692-8700
  • Association: Yes

Association/Amenities

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

Schools

  • Middle School: Plainview-Old Bethpage Middle Sch

Lot Info

  • Lot Dimensions: 50x110
  • Lot Size Sq Ft: 5500
  • Lot Features: Sprinklers In Front, Sprinklers In Rear
  • Parcel Number: 2489-13-119-00-0113-0
  • Property Attached: No
  • Additional Parcels: No

Rental Info

  • Lease Considered: No

Tax Info

  • Tax Annual Amount: 23089.19
  • Tax Block: 119
  • Tax Lot: 113

MLS Schools

  • High School: Plainview-Old Bethpage/Jfk Hs

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 5, 2024
Closed on
Mar 27, 2025
Sold by
Berman Lynn
Bought by
Lieberman Stewart and Silverstein Carol
Seller's Agent
Patti Pascullo
Douglas Elliman Real Estate
Buyer's Agent
Patti Pascullo
Douglas Elliman Real Estate
List Price
$1,399,000
Sold Price
$1,350,000
Premium/Discount to List
-$49,000
-3.5%
Views
25
Current Estimated Value
$1,385,630

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$35,630
Avg. Annual Appreciation
3.79%

Purchase Details

Closed on
Jan 22, 2002
Sold by
Hamlet On Olde Oyster Bay
Bought by
Berman Lynn
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 Type Sale Price Title Company
Bargain Sale Deed $1,350,000 Fidelity Title Insurance Co
Bargain Sale Deed $1,350,000 Fidelity Title Insurance Co
Bargain Sale Deed $1,350,000 Fidelity Title Insurance Co
Deed $545,000 Thomas J Cote
Deed $545,000 Thomas J Cote
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
03/27/2025 03/27/25 Sold $1,350,000 0.0% $463 / Sq Ft View Prior Sale
03/27/2025 03/27/25 Sold $1,350,000 -3.5% $463 / Sq Ft
11/28/2024 11/28/24 Pending -- -- --
11/27/2024 11/27/24 Pending -- -- --
09/05/2024 09/05/24 For Sale $1,399,000 -3.5% $480 / Sq Ft
08/02/2024 08/02/24 For Sale $1,450,000 -- $497 / Sq Ft
Source: OneKey® MLS

Tax History Compared to Growth

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 $19,465 $792 $328 $464
2024 $6,178 $864 $358 $506
2023 $21,695 $954 $396 $558
2022 $21,695 $926 $384 $542
2021 $21,969 $1,056 $438 $618
2020 $26,712 $1,523 $588 $935
2019 $26,494 $1,523 $588 $935
2018 $24,812 $1,632 $0 $0
2017 $16,914 $1,632 $485 $1,147
2016 $24,276 $1,917 $630 $1,287
2015 $8,568 $2,118 $630 $1,488
2014 $8,568 $2,118 $630 $1,488
2013 $7,813 $2,118 $630 $1,488
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: OneKey® MLS

MLS Number: L3576670

OneKey® MLS

APN: 2489-13-119-00-0113-0