The listing facts are current enough for an initial property review.
for saleRealtyLens property overview
$945,000
25 Celeste Ct
Brooklyn, NY, 11229
View more Brooklyn, NY property pages4Beds
1.75Baths
1,872Sqft
$505$/sqft
Listing Notes
Gerritsen Beach! Showpiece in the new section of Gerritsen Beach! Waiting for its new owner! Beautiful 3 Bedroom home with a 3rd floor loft (4th bedroom). First floor has oversized Living Room, Full Eat-in-Kitchen, Full Bath and Formal Dining Room. Second floor has 3 Bedrooms and 3/4 Bath. Third floor is an open loft and that can be 4th Bedroom, Den or home gym. There is a large rear yard with a shed, pergola and private parking for 2 cars! Make this home yours!! Call today.
Market Insights
Near nearby median+2.9%
$505/sqft vs a nearby median of $491/sqft.
Nearby median$491/sqft
Nearby properties8
Property size1,872 sqft
- +2.9% versus the nearby median price per square foot.
- Price history is limited, so current comps matter more than trend alone.
- 1,872 sqft creates a usable price-per-square-foot read.
Pricing Read
Yardstick fair value$882k$803k – $961k · 50% confidence
vs ask $945k+$63k (+6.7%)
Asking price is about 6.7% above where comps + adjustments land — there is room to negotiate.
$491/sqft median across 7 tight comps × 1,872 sqft= $919k
- Transit access−$28k −3.0%
- Days-on-market gravity−$28k −3.0%
- Pre-war character+$23k +2.5%
- Moderate flood-area edge−$5k −0.5%
Cumulative NYC adjustments−$37k−4.0%
Property Read
The property is close to nearby price-per-square-foot levels, so the decision will likely come down to condition and layout.
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
- 222 days
- Last price change
- No change recorded
- Listed
- Oct 2, 2025
- Photos
- 24 photos
- Property type
- single family
- Status
- for sale
- Last sold
- Apr 11, 1996 · $195,000
Features & Amenities
Central AirDining RoomHardwood FloorsBig YardPrivate ParkingBeach
Photos
Building Facts
- Year built
- 1920
- Stories
- 2
- Total units
- 1
- Residential units
- 1
- Building area
- 1,059 sqft
- Lot size
- 1,785 sqft
- Land use
- One and two family buildings
- Building class
- A1
From NYC public records where available.
Price History
May 4, 2026Initial record
$945,000for sale
Public Records
DOB violations0 open
0 total recorded against the building
HPD violations0 open
0 total recorded
ACRIS documents27
Tax-lot deed, mortgage, and transfer records on file
311 calls (12 mo)30,565
Top: illegal parking
Top complaint types in ZIP 11229
- Illegal Parking6,081
- Noise - Residential3,246
- Blocked Driveway2,956
- HEAT/HOT WATER2,271
- Abandoned Vehicle1,158
Recent Transfers (ACRIS)
- Nov 26, 2021DEED
- Dec 1, 1988DEED
Sourced from NYC Open Data (DOB, HPD, ACRIS). Updated as the city republishes — check the original source for live status.