The listing facts are current enough for an initial property review.
37 Celeste Ct
Listing Notes
"NEW SECTION" OF Gerritsen Beach RARE DOUBLE LOT- LIVABLE HANDYMAN- CONTRACTOR SPECIAL 37 Celeste Court offers something rare in Gerritsen Beach: a double lot with a livable shell, ready for your vision. This is a handyman special on a double lot ideal for a contractor, investor or handy homeowner willing to put in the work.
Market Insights
$507/sqft vs a nearby median of $603/sqft.
- -16% versus the nearby median price per square foot.
- Price history is limited, so current comps matter more than trend alone.
- 1,358 sqft creates a usable price-per-square-foot read.
Pricing Read
Asking price is about 12.2% below the fair value — likely to draw competing offers if it's still on market.
- Transit access−$25k −3.0%
- Days-on-market gravity−$25k −3.0%
- Pre-war character+$20k +2.5%
- Sparse street life−$12k −1.5%
- Moderate flood-area edge−$4k −0.5%
Property Read
The asking price per square foot is below the nearby median, which can be worth a closer comp check.
Price history is still limited; review again as more market activity becomes available.
Generate a buyer-agent read of this listing — pricing, risks, comp check, and negotiation leverage. Takes a few seconds.
Generated from the facts shown on this page and nearby market data. Not a professional appraisal.
Listing Details
- Days on market
- 199 days
- Last price change
- No change recorded
- Listed
- Oct 25, 2025
- Photos
- 3 photos
- Property type
- single family
- Status
- for sale
- Garage
- 1 space
Features & Amenities
Building Facts
- Year built
- 1920
- Stories
- 2
- Total units
- 1
- Residential units
- 1
- Building area
- 1,358 sqft
- Lot size
- 3,570 sqft
- Land use
- One and two family buildings
- Building class
- A1
From NYC public records where available.
Price History
Public Records
0 total recorded against the building
0 total recorded
Tax-lot deed, mortgage, and transfer records on file
Top: illegal parking
Top complaint types in ZIP 11229
- Illegal Parking6,087
- Noise - Residential3,247
- Blocked Driveway2,958
- HEAT/HOT WATER2,271
- Abandoned Vehicle1,159
Sourced from NYC Open Data (DOB, HPD, ACRIS). Updated as the city republishes — check the original source for live status.