by RH Advisors
For Sale
For Rent
Blog
Property Records
Schools
SEARCH
Property Records
For Sale
For Rent
MORE
Blog
Schools
See Home Value
Putnam
24 Lake Celeste Drive
Photo of 24 Lake Celeste Drive
Sold on Jul 31, 2026

15

Map

Photo of 24 Lake Celeste Drive
Photo of 24 Lake Celeste Drive
$645,000
● House - Off Market

24 Lake Celeste Drive

Philipstown, NY 10524
bedrooms
2 Beds
bathrooms
1 Bath, 1 Half Bath
square feet
1,106 Ft²
$4,239
Est. Monthly
$333
HOA / Fees

About This Property

Tucked within the private lake community of Lake Celeste, just 50 miles from New York City, this inviting lakefront retreat offers the perfect balance of relaxation and recreation. Residents enjoy a non-motorboat lake, clay tennis courts, sandy beach, canoeing, hiking trails, and unforgettable sunset views. This charming two-bedroom, one-and-a-half-bath home is rich with warmth and character, featuring a stone fireplace, classic wood paneling, custom built-ins, and skylights that fill the interiors with natural light. An updated kitchen, new roof, and thoughtful improvements make the home equally suited for effortless weekend escapes or comfortable full-time living.
Unit Size
1,106 Ft²
Days on Market
71 days
Land Size
0.10 acres
Price per sqft
$583
Property Type
House
Property Taxes
$738
HOA Dues
$333
Year Built
1940

Payment Calculator

Home Price
Down Payment
%
Loan Term
Interest %

Your Estimated Monthly Payment

Principal + Interest:
Property Tax:
HOA:
Home Insurance:
Mortgage Insurance:

Cap Rate Calculator

Purchase Price
Monthly Property Taxes
Monthly Rental Income
Maintenance & HOA
Income Per Year
Expenses Per Year
Operating Profit Per Year
Cap Rate 100% Occupancy
N/A (extreme outlier)

What does this mean?

Based on our analysis, the cap rate of this property is 1.25%. A negative cap rate indicates that the property might not be feasible as an income-producing asset. The median cap rate for a near zip code 11238 is 4.23%.

How much can I actually make?

Actual monthly rental income may vary between $4,760 and $7,140 depending on unit-specific characteristics. You can change the amount using the slider to further explore.

How is cap rate calculated?

Cap Rate = Net Operating Income (NOI) / Property Asset Value.

When calculating the cap rate, we assume 100% occupancy. Leverage (mortgage) is not considered.

Cap Rate provided by RealtyHop and RentHop, learn more about cap rate here.

Last updated: 2 months ago (OneKey MLS #KEY1002478)

Price History

Date / Event Date Event Price
Jul 31, 2026 Sold
Premium
Sold
Jun 22, 2026 In contract -
In contract
May 21, 2026 Listed by Houlihan Lawrence Inc. $645,000
Listed by Houlihan Lawrence Inc.

Property Highlights

Fireplace

Building Info

Overview

    General

  • Year Built: 1940
  • Effective Year Built: 1940
  • Bedroom Count: 2
  • Bathroom Count: 2
  • Full Bathrooms: 1
  • Partial Bathrooms: 2
  • Building Condition: 6
  • Building Quality: 7
  • Construction Type: 0
  • Building Style: 4
  • Exterior Walls Type: 17
  • Interior Walls Type: 0
  • Roof Shape Type: 0
  • Roof Cover Type: 0
  • Floor Count: 100
  • Floor Cover: 0
  • Basement Type: 6
  • Basement Area: 0
  • Garage Type: 0
  • Parking Space Count: 0
  • Patio Type: 20
  • Porch Type: 0
  • Pool Type: 0
  • Location Influence Type: 12

    Dimensions

  • Lot Size Square Feet: 4,240
  • Lot Size Depth Feet: 2,120
  • Lot Size Frontage Feet: 200
  • Total Building Area: 1,106
  • Building Area: 1,106
  • Building Area Measurement: L

    Heating and Cooling

  • Fireplace Count: 1
  • Air Conditioning: 0
  • Heating: 4
  • Heated Square Feet: 1,106
  • Heating Fuel Type: 3

    Utilities

  • Sewer System: 4
  • Water Service: 5

Building

  • Building Type: 0
  • Property Class: R
  • Land Acres: 0000000097
  • Standard Land Use Code: 1001
  • County Land Use Code: 210

Neighborhood

  • School District Name: Lakeland Central School District
  • Census Tract: 010800

Zoning

  • Zoning: R80

Geography

  • Account Number: 151025
  • District: 372689
  • Section: 72.17
  • Parcel: 372689 72.17-1-11
  • Block: 1
  • Lot: 11.000
  • Municipality: PHILIPSTOWN (TOV)
  • Latitude: 41.3622
  • Longitude: -73.9001

    Address

  • Full Address: 24 Lake Celeste Dr
  • Address - House Number: 24
  • Address - Street Name: Lake Celeste
  • Address - Suffix Type: Dr
  • State: NY
  • City Name: Garrison
  • Carrier Code: R001
  • 4-Digit Zip Code: 3730
  • Zip Code: 10524

Valuation

    Tax

  • Tax Year: 2023
  • Tax Amount: $763,312
  • Tax Rate Code Area: 555401

    Appraisal Valuation

  • Standard Deviation: 0.1468
  • Valuation Date: Feb 14, 2024
  • Confidence Score: 82
  • Final Value: 695,898
  • High Value: 798,083
  • Low Value: 593,714

    Market Valuation

  • Market Total Value: $319,137
  • Market Land Value: $154,174
  • Market Improvement Value: $164,963

    Assessments Valuation

  • Assessed Year: 2023
  • Assessed Total Value: $112,400
  • Assessed Land Value: $54,300
  • Assessed Improvements Value: $58,100
Data used for valuation calculations is provided by RealtyHop, and other third party sources
Request mortgage information redaction

Comparables

Unit
Status
Type
Beds
Baths
ft²
Price/ft²
Asking Price
Listed On
Closing Price
Sold On
HOA + Taxes

About Putnam

Stats & Trends

Median Asking:

$579,000

Sale Price/ft²

$317

Below Asking

0.01%

Average Days on Market

85

Average Home Size

2444 ft²

Average Home Age

57.5 years

Currently For Sale

276 Listings
Based on RH Advisors, Inc. calculations of home data from MLS and/or public records.

Similar Homes for Sale

Currently no similar homes around

Nearby Rentals

Unit for rent at 8 Anton Place, Lake Peekskill, NY, 10537

$3,095 /mo

  • 2 Beds
  • 1 Bath
  • 1,200 ft²
8 Anton Place, Lake Peekskill, NY, 10537 Listing by Jorge A. Guerrero Jr
Unit for rent at 103 Old Highland Turnpike, Garrison, NY, 10524

$5,500 /mo

  • 3 Beds
  • 3 Baths
  • 2,408 ft²
103 Old Highland Turnpike, Garrison, NY, 10524 Listing by Mishara Canino

Rentals Near You

Click here to view more rentals in the neighborhood.
OneKey

Last Updated: 2 months ago
Data Source: OneKey MLS

Frequently Asked Questions

When was property at 24 Lake Celeste Drive built and last sold?
The property at 24 Lake Celeste Drive was built in 1940 and last sold on Jan 1, 1970 for $0.
How much is this home worth?
The estimated value of the home located at 24 Lake Celeste Drive is $636,863.
What are some comparable homes to 24 Lake Celeste Drive?
There are currently no comparable homes to 24 Lake Celeste Drive.
Recent Neighborhood News
Lake House Prices Near NYC in 2026: What Waterfront Actually Costs (Labor Day Buyer's Guide)
9 New York City Seafood and Raw Bars
Why Some NYC Tenement Apartments Had Bathtubs in the Kitchen
The Current Status of iBuying in 2026: What To Know
Popular Searches
Philipstown Homes for Sale
Philipstown Houses for Sale
Philipstown Condos for Sale
Philipstown Multifamily for Sale
Philipstown Land for Sale
Philipstown Commercial for Sale
Philipstown Homes with Basements
Philipstown Homes with Pools
Nearby Cities
New City Homes for Sale
Beacon Homes for Sale
Newburgh Homes for Sale
Peekskill Homes for Sale
Ossining Homes for Sale
Woodbury Homes for Sale
Jefferson Valley-Yorktown Homes for Sale
Stony Point Homes for Sale
Nearby Property Records
Putnam County, NY Property Records
Rockland County, NY Property Records
Orange County, NY Property Records
Westchester County, NY Property Records
Dutchess County, NY Property Records
Fairfield County, CT Property Records
Passaic County, NJ Property Records
Bergen County, NJ Property Records
Nearby Counties
Fishkill Homes for Sale
Poughkeepsie Homes for Sale
East Fishkill Homes for Sale
Newburgh Homes for Sale
Wappinger Homes for Sale
Carmel Homes for Sale
Cortlandt Homes for Sale
Haverstraw Homes for Sale
Top Real Estate Agents
Top Agents in Philipstown
Top Agents in 12603
Top Agents in Fishkill
Top Agents in Poughkeepsie
Top Agents in 12550
Top Agents in 12590
Top Agents in East Fishkill
Top Agents in 12533