$450,000
SOLD OCT 17, 2025

48 Celeste Dr Rensselaer, NY 12144

3 Beds
2.5 Baths
2,055 Sq Ft
9,148 Sq Ft Lot

Recently Sold

$219 Per Sq Ft

8% Above List Price

1 Day on Market

Highlights

  • View of Trees or Woods
  • Deck
  • No HOA
  • Red Mill School Rated A
  • Wood Flooring
  • Game Room

About This Home

As of October 2025

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.

Last Agent to Sell the Property

Marie Bettini

Albany Realty Group LLC Listed on: 09/03/2025

Last Buyer's Agent

Gordon Iwan

Howard Hanna Capital Inc License #10401365179

Howard Hanna Capital Inc

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,368

Year Built

  • Built in 1989 | Remodeled

Lot Details

  • 9,148 Sq Ft Lot
  • Lot Dimensions are 75x124
  • Landscaped
  • Level Lot
  • Front and Back Yard Sprinklers

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Driveway

Property Views

  • Pond
  • Woods

Home Design

  • Block Foundation
  • Vinyl Siding
  • Asphalt

Interior Spaces

  • Built-In Features
  • Crown Molding
  • Paddle Fans
  • Self Contained Fireplace Unit Or Insert
  • Gas Fireplace
  • Blinds
  • Sliding Doors
  • ENERGY STAR Qualified Doors
  • Family Room
  • Living Room
  • Dining Room
  • Game Room

Kitchen

  • Eat-In Kitchen
  • Gas Oven
  • Microwave
  • Ice Maker
  • ENERGY STAR Qualified Dishwasher
  • Kitchen Island

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary bedroom located on second floor
  • Walk-In Closet
  • Bathroom on Main Level
  • Ceramic Tile in Bathrooms

Laundry

  • Laundry on main level
  • Washer and Dryer

Finished Basement

  • Basement Fills Entire Space Under The House
  • Interior Basement Entry

Home Security

  • Security System Owned
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Deck
  • Covered Patio or Porch
  • Shed

Schools

  • Columbia High School

Utilities

  • Humidifier
  • Forced Air Heating and Cooling System
  • Wood Insert Heater
  • Heating System Uses Natural Gas
  • 200+ Amp Service
  • Power Generator
  • Gas Water Heater
  • High Speed Internet

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Legal Lot and Block 33 / 2
  • Assessor Parcel Number 382400 166.5-2-33

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,368

Year Built

Built in 1989 | Remodeled

Lot Details

9,148 Sq Ft Lot

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Year Built: 1989
  • Directions: From Rts 9&20 Turn onto Ridge Rd then L onto Celeste Dr.
  • Above Grade Finished Sq Ft: 2055.0
  • Architectural Style: Colonial
  • General Taxes Description: Estimated
  • Financial Details School Taxes: 3508.0
  • School Taxes Description: Estimated
  • Lot Size Acres: 0.21
  • Lot Size: 75x124
  • New Construction: No
  • Full Bathroom Level: Second
  • Half Bathroom Level: First
  • Primary Bathrooms Level: Second
  • Primary Bedroom Level: Second
  • Sale Detail Seller Contribution: No
  • Subdivision Name: Select One
  • Garage Yn: Yes
  • Special Features: None

Interior Features

  • Flooring: Carpet, Ceramic Tile, Hardwood, Tile
  • Basement: Full, Finished, Interior Entry
  • Interior Amenities: Walk-In Closet(s), Ceramic Tile Bath, High Speed Internet, Paddle Fan, Built-in Features, Crown Molding, Eat-in Kitchen, Kitchen Island
  • Appliances: Refrigerator, Dishwasher, Microwave, Ice Maker, Gas Oven, Washer/Dryer, Humidifier, Gas Water Heater, ENERGY STAR Qualified Appliances
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Below Grade Sq Ft: 621.0
  • Door Features: Sliding Doors, ENERGY STAR Qualified Doors
  • Fireplace Features: Gas, Insert, Family Room
  • Fireplaces: 1
  • Living Area: 2055.0
  • Other Equipment: Dehumidifier
  • Bedroom Level: Second
  • Dining Room Level: First
  • Family Room Level: First
  • Kitchen Level: First
  • Living Room Level: First
  • Sunroom Level: First
  • Window Features: Blinds
  • Bathroom Levels Full Bathroom 1: 2nd
  • Bathroom Levels Full Bathroom 2: 2nd
  • Bathroom Levels Half Bathroom 1: 1st
  • Fireplace: Yes
  • Dining Room Type: Formal Dining Room

Exterior Features

  • Exterior Features: Drive-Paved
  • Roof: Asphalt
  • Construction Type: Vinyl Siding
  • Fencing: None
  • Foundation Details: Block
  • Other Structures: Shed(s)
  • Patio And Porch Features: Deck, Composite Deck, Front Porch, Covered
  • View: Pond, Trees/Woods
  • Waterfront: No
  • Property Condition: Updated/Remodeled

Garage/Parking

  • Garage Spaces: 2.0
  • Parking Features: Attached, Garage Door Opener, Driveway, Garage
  • Attached Garage: Yes
  • Total Parking Spaces: 4.0
  • Property Detail:Parking YN: Yes

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air
  • Electric: 200+ Amp Service, Circuit Breakers, Generator
  • Heating: Natural Gas, Forced Air, Fireplace Insert
  • Laundry Features: Main Level, Laundry Closet
  • Security: Carbon Monoxide Detector(s), Security System Owned, Smoke Detector(s)
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Association: No

Schools

  • Junior High Dist: East Greenbush

Lot Info

  • Lot Features: Landscaped, Level, Sprinklers In Front, Sprinklers In Rear
  • Parcel #: 382400 166.5-2-33
  • Lot Size Sq Ft: 9147.6

Tax Info

  • Tax Annual Amount: 6368.0
  • Tax Block: 2
  • Tax Lot: 33

MLS Schools

  • HighSchool: Columbia

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 3, 2025
Closed on
Oct 17, 2025
Sold by
Wejrowski
Bought by
Bhatti Ammar A
Seller's Agent
Marie Bettini
Albany Realty Group LLC
Buyer's Agent
Gordon Iwan
Howard Hanna Capital Inc
List Price
$415,000
Sold Price
$450,000
Premium/Discount to List
$35,000
8.43%
Views
36
Current Estimated Value
$451,646

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$1,646
Avg. Annual Appreciation
0.83%
Original Mortgage
$427,500
Outstanding Balance
$426,288
Interest Rate
6.3%
Mortgage Type
New Conventional
Estimated Equity
$25,358

Purchase Details

Closed on
Sep 26, 2024
Sold by
Wejrowski Patrick A and M-Wejrowski Karen J
Bought by
Wejrowski

Purchase Details

Closed on
Jun 18, 2018
Sold by
Wejrowski Patrick A
Bought by
Wejrowski Patrick A and Wejrowski Karen J
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Type Sale Price Title Company
Deed $450,000 --
Quit Claim Deed -- None Available
Quit Claim Deed -- None Available
Quit Claim Deed -- None Available
Interfamily Deed Transfer -- --
Interfamily Deed Transfer -- --
Interfamily Deed Transfer -- --
Interfamily Deed Transfer -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $427,500 New Conventional
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
10/17/2025 10/17/25 Sold $450,000 +8.4% $219 / Sq Ft
09/04/2025 09/04/25 Pending -- -- --
09/03/2025 09/03/25 For Sale $415,000 -- $202 / Sq Ft
Source: Global MLS

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $7,456 $221,000 $19,000 $202,000
2023 $7,574 $221,000 $19,000 $202,000
2022 $7,669 $221,000 $19,000 $202,000
2021 $7,749 $221,000 $19,000 $202,000
2020 $6,813 $221,000 $19,000 $202,000
2019 $6,328 $221,000 $19,000 $202,000
2018 $6,328 $221,000 $19,000 $202,000
2017 $5,711 $190,500 $21,000 $169,500
2016 $5,543 $190,500 $21,000 $169,500
2015 -- $190,500 $21,000 $169,500
2014 -- $190,500 $21,000 $169,500
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Global MLS

MLS Number: 202525060

Global MLS

APN: 2400-166.5-2-33

Your Personal Tour Guide

Ask me questions while you tour the home.