RealtyLens
for saleRealtyLens property overview
$688,888

37 Celeste Ct

Brooklyn, NY, 11229
View more Brooklyn, NY property pages
4Beds
2Baths
1,358Sqft
$507$/sqft

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

Below nearby median-16%

$507/sqft vs a nearby median of $603/sqft.

Nearby median$603/sqft
Nearby properties12
Property size1,358 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

Yardstick fair value$773k$703k$843k · 50% confidence
vs ask $689k−$84k (−12.2%)

Asking price is about 12.2% below the fair value — likely to draw competing offers if it's still on market.

$603/sqft median across 12 tight comps × 1,358 sqft= $818k
  • 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%
Cumulative NYC adjustments−$45k−5.5%

Property Read

FreshnessCurrent market data

The listing facts are current enough for an initial property review.

Market Position-16% vs nearby

The asking price per square foot is below the nearby median, which can be worth a closer comp check.

Price MovementInitial price point

Price history is still limited; review again as more market activity becomes available.

Diligence Read1 item to check
AI ReadinessReady to analyze
Assistant read

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

Dining RoomLaundry RoomTwo Or More StoriesGarage 1 Or MoreBeachFixer Upper

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

May 4, 2026Initial record
$688,888for sale

Public Records

DOB violations0 open

0 total recorded against the building

HPD violations0 open

0 total recorded

ACRIS documents16

Tax-lot deed, mortgage, and transfer records on file

311 calls (12 mo)30,594

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.

You can also find this listing on StreetEasy.

Listing data sourced from streeteasy.com. RealtyLens enriches and contextualises it for you, but the original listing lives on the source.