What's not to love in this one owner, Marini built Colonial in Onderdonk Estates. Original owners have maintained and updated this home over the years with the addition of a 4 season room with views of the koi pond and waterfalls in the back yard. The retractable awning over the Trex deck helps it stay cool on hot summer days. Interior boasts a newer kitchen with granite counters and plenty of counter and cabinet space for entertaining. All kitchen appliances carry a 10 warranty which started in 2020. Family Room with full wall fieldstone gas fireplace w/insert invites coziness on those cold winter nights. Second floor includes primary suite with en suite and walk in closet, main bath and two other bedrooms. One is currently used as an office. This home's interior doors are all solid wood, the 2 c garage has a new door, a floor drain and opener, roof is 20yrs old, sprinkler system front and back, furnace 8yrs, and yay! there's a whole house generator! Showings begin Friday 9/5.
Closed
$450,000
48 Celeste Drive, Rensselaer, NY 12144
3beds
2,055sqft
Single Family Residence, Residential
Built in 1989
9,147 Square Feet Lot
$469,200 Zestimate®
$219/sqft
$3,072 Estimated rent
Home value
$469,200
$404,000 - $544,000
$3,072/mo
Zestimate® history
Owner options
List your home for rent
$3,072/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,072/mo
Rent Zestimate®
Refinance and save
$3,179/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$3,179/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked:
Listing updated:
Listed by:
Marie C Bettini 518-428-9391,
Albany Realty Group LLC
Bought with:
Gordon Iwan, 10401365179
Howard Hanna Capital Inc
Source: Global MLS,MLS#: 202525060
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: Second
Primary bathroom
- Level: Second
Half bathroom
- Level: First
Full bathroom
- Level: Second
Dining room
- Level: First
Family room
- Level: First
Game room
- Level: Basement
Kitchen
- Level: First
Living room
- Level: First
Sun room
- Level: First
Heating
- Fireplace Insert, Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, ENERGY STAR Qualified Appliances, Gas Oven, Gas Water Heater, Humidifier, Microwave, Refrigerator, Washer/Dryer
- Laundry: Laundry Closet, Main Level
Features
- High Speed Internet, Ceiling Fan(s), Walk-In Closet(s), Built-in Features, Ceramic Tile Bath, Crown Molding, Eat-in Kitchen, Kitchen Island
- Flooring: Tile, Carpet, Ceramic Tile, Hardwood
- Doors: ENERGY STAR Qualified Doors, Sliding Doors
- Windows: Blinds
- Basement: Finished,Full,Interior Entry
- Number of fireplaces: 1
- Fireplace features: Family Room, Gas, Insert
Interior area
- Total structure area: 2,055
- Total interior livable area: 2,055 sqft
- Finished area above ground: 2,055
- Finished area below ground: 621
Property
Parking
- Total spaces: 4
- Parking features: Attached, Driveway, Garage Door Opener
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Patio & porch: Composite Deck, Covered, Deck, Front Porch
- Fencing: None
- Has view: Yes
- View description: Pond, Trees/Woods
- Has water view: Yes
- Water view: Pond
Lot
- Size: 9,147 Square Feet
- Features: Level, Sprinklers In Front, Sprinklers In Rear, Landscaped
Details
- Additional structures: Shed(s)
- Parcel number: 382400 166.5233
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence, Residential
Materials
- Vinyl Siding
- Foundation: Block
- Roof: Asphalt
Condition
- Updated/Remodeled
- New construction: No
- Year built: 1989
Utilities & green energy
- Electric: Circuit Breakers, Generator
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Security: Smoke Detector(s), Security System Owned, Carbon Monoxide Detector(s)
HOA
- Has HOA: No
Location
- Region: Rensselaer
Financial & listing details
- Price per square foot: $219/sqft
- Tax assessed value: $353,000
- Annual tax amount: $6,368
- Date on market: 9/3/2025
Price history
| Date | Event | Price |
|---|---|---|
| 10/17/2025 | Sold | $450,000+8.4%$219/sqft |
Source:  Global MLS #202525060 Report a problem | ||
| 9/4/2025 | Pending sale | $415,000$202/sqft |
Source: Global MLS #202525060 Report a problem | ||
| 9/3/2025 | Listed for sale | $415,000$202/sqft |
Source: Global MLS #202525060 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $353,000 +59.7% |
| 2024 | -- | $221,000 |
| 2023 | -- | $221,000 |
| 2022 | -- | $221,000 |
| 2021 | -- | $221,000 |
| 2020 | -- | $221,000 |
| 2019 | -- | $221,000 |
| 2018 | -- | $221,000 +16% |
| 2017 | $5,525 | $190,500 |
| 2016 | -- | $190,500 |
| 2015 | -- | $190,500 |
| 2014 | -- | $190,500 |
| 2013 | -- | $190,500 -19.3% |
| 2012 | -- | $236,200 |
| 2011 | -- | $236,200 |
| 2010 | -- | $236,200 -4% |
| 2009 | -- | $246,000 |
| 2008 | -- | $246,000 +304.6% |
| 2007 | -- | $60,800 |
| 2006 | -- | $60,800 |
| 2005 | -- | $60,800 |
| 2004 | -- | $60,800 |
| 2003 | -- | $60,800 |
| 2002 | -- | $60,800 |
| 2001 | -- | $60,800 +1.5% |
| 2000 | -- | $59,900 |
Find assessor info on the county website
Neighborhood: 12144
Nearby homes
- $402,8003 bd2 ba1.8k sqft50 Celeste Dr, Rensselaer, NY 12144Off Market
- $395,4003 bd2 ba1.3k sqft46 Celeste Dr, Rensselaer, NY 12144Off Market
- $14,700-- bd-- ba-- sqftCeleste Dr, Rensselaer, NY 12144Off Market
- $416,6003 bd2 ba1.6k sqft44 Celeste Dr, Rensselaer, NY 12144Off Market
- $421,5003 bd2 ba1.4k sqft52 Celeste Dr, Rensselaer, NY 12144Off Market
- $571,2003 bd3 ba1.9k sqft55 Celeste Dr, Rensselaer, NY 12144Off Market
- $467,9005 bd2 ba2.3k sqft55 Celeste Dr, Rensselaer, NY 12144Off Market
- $495,2004 bd3 ba2.1k sqft53 Celeste Dr, Rensselaer, NY 12144Off Market
Nearby schools
GreatSchools rating
- 6/10Red Mill SchoolGrades: PK-5Distance: 1 mi
- 7/10Howard L Goff SchoolGrades: 6-8Distance: 1.6 mi
- 8/10Columbia High SchoolGrades: 9-12Distance: 2.4 mi
Schools provided by the listing agent
- High: Columbia
Source: Global MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Sell for more on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$469,200
2% more
+$9,384
With Zillow Showcase(estimated)
$478,584
- New York
- Rensselaer County
- Rensselaer
- 12144
- 48 Celeste Drive
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Rensselaer Topics
