NOT LISTED FOR SALE

52 Celeste Dr Rensselaer, NY 12144

Estimated Value: $391,000 - $458,000

3 Beds
2 Baths
1,410 Sq Ft
$295/Sq Ft Est. Value

Last Sold May 26, 2022

Last sale price $350,719 $249 Per Sq Ft

Est. 18% increase in value since last sale

Current estimated payment $2,829/month

2 Days on Market

Highlights

  • In Ground Pool
  • Mountain View
  • Ranch Style House
  • Red Mill School Rated A
  • Deck
  • No HOA

About This Home

As of May 2022

Live in a very desirable neighborhood in the East Greenbush School district. This spacious 3 bedroom/ 2 bathroom open floor plan ranch home has been lovingly maintained. Enjoy the private, fenced-in backyard with an in-ground pool and great mountain views. Extra bonus is the living space included in the finished basement which could be used as a family/game room and includes a bar. Lots of ample storage space located in the unfinished part of the basement. Nothing to do to this lovely home, but move in!

Last Agent to Sell the Property

Kathie Spangler

Julie & Co Realty, LLC License #30SP1026055 Listed on: 04/04/2022

Julie & Co Realty, LLC

Last Buyer's Agent

Brian Sinkoff

CM Fox Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,200

Year Built

  • Built in 1988

Lot Details

  • 9,148 Sq Ft Lot
  • Lot Dimensions are 75' x 124'
  • Back Yard Fenced
  • Landscaped
  • Garden
  • Property is zoned Single Residence

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Block Foundation
  • Composition Roof
  • Vinyl Siding

Interior Spaces

  • Paddle Fans
  • Double Pane Windows
  • Sliding Doors
  • Mountain Views

Kitchen

  • Eat-In Kitchen
  • Built-In Electric Oven
  • Dishwasher
  • Kitchen Island

Flooring

  • Carpet
  • Ceramic Tile
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • 2 Full Bathrooms

Laundry

  • Laundry Room
  • Laundry on main level

Finished Basement

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

Outdoor Features

  • In Ground Pool
  • Deck
  • Front Porch

Schools

  • Columbia High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Underground Utilities
  • 200+ Amp Service
  • High Speed Internet

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Legal Lot and Block 2-31 / 5
  • Assessor Parcel Number 166.5-2-31

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,200

Year Built

Built in 1988

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Zoning: Single Residence
  • Year Built: 1988
  • Directions: From 787 take take 3A East to Route 20 & 9 South. Go 2 miles, turn right on Ridge and then left on Celeste. House is on the left side.
  • Above Grade Finished Sq Ft: 1410.0
  • Architectural Style: Ranch
  • Financial Details General Taxes: 6200.0
  • General Taxes Description: Actual
  • Lot Size Acres: 0.21
  • Lot Size: 75' x 124'
  • New Construction: No
  • Parking Features Parking Total: 4.0
  • Full Bathroom Level: First
  • Laundry Room Level: First
  • Primary Bedroom Level: First
  • Sale Detail Buyer Zip Code: 12061
  • Sale Detail Seller Contribution: No
  • Garage Yn: Yes
  • Appliances Refrigerators: Yes
  • Flooring:Carpet: Yes
  • Laundry Features:Main Level: Yes
  • Fencing:Back Yard: Yes
  • Percent Basement Finished: Yes
  • Cooling:Central Air: Yes
  • Architectural Style:Ranch: Yes
  • Flooring:Ceramic Tile: Yes
  • Basement Heated: Yes
  • Flooring:Vinyl: Yes
  • Fencing:Fenced: Yes
  • Foundation Details:Block2: Yes
  • Electric:_two_00 Amp Service: Yes
  • View:Mountain(s)2: Yes
  • Levels One: Yes
  • Special Features: None

Interior Features

  • Flooring: Vinyl, Carpet, Ceramic Tile
  • Basement: Finished, Full, Heated, Interior Entry
  • Interior Amenities: High Speed Internet, Paddle Fan, Walk-In Closet(s), Eat-in Kitchen, Kitchen Island
  • Appliances: Built-In Electric Oven, Dishwasher, Refrigerator
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Below Grade Sq Ft: 600.0
  • Door Features: Sliding Doors
  • Living Area: 1410.0
  • Bedroom Level: First
  • Foyer Level: First
  • Kitchen Level: First
  • Living Room Level: First
  • Window Features: Double Pane Windows
  • Appliances Dishwasher: Yes
  • Interior Features:High Speed Internet: Yes
  • Interior Features:Paddle Fan: Yes
  • Full Basement: Yes
  • Kitchen Features:Eat-in Kitchen: Yes
  • Interior Features:Walk-In Closet(s): Yes
  • Kitchen Features:Kitchen Island: Yes
  • Attic Features:Hatch: Yes
  • Kitchen Features:Semi-Modern Kitchen: Yes
  • Basement:Interior Entry: Yes
  • Appliances:Built-In Electric Oven: Yes

Exterior Features

  • Exterior Features: Drive-Paved, Garden
  • Roof: Composition
  • Construction Type: Brick, Drywall, Vinyl Siding
  • Fencing: Back Yard, Fenced
  • Foundation Details: Block
  • Patio And Porch Features: Deck, Front Porch
  • Pool Features: In Ground, Outdoor Pool
  • View: Mountain(s)
  • Waterfront: No
  • Construction Materials:Drywall: Yes
  • Construction Materials:Vinyl Siding: Yes
  • Door Features:Sliding Doors: Yes
  • Exterior Features:Drive-Paved: Yes
  • Patio And Porch Features:Deck: Yes
  • Lot Features:Landscaped: Yes
  • Construction Materials:Brick: Yes
  • Exterior Features:Garden: Yes
  • Lot Features:Views: Yes
  • Patio And Porch Features:Front Porch: Yes
  • Window Features:Double Pane Windows: Yes
  • Pool Features:Outdoor Pool: Yes

Garage/Parking

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

Utilities

  • Utilities: Underground Utilities
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Electric: 200+ Amp Service
  • Heating: Forced Air, Natural Gas
  • Laundry Features: Laundry Room, Main Level
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Forced Air: Yes
  • Heating:Natural Gas: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Parcel Tax HOA:Association YN: No

Schools

  • Junior High Dist: East Greenbush

Lot Info

  • Land Lease: No
  • Lot Features: Views, Landscaped
  • Parcel #: 166.5-2-31
  • Lot Size Sq Ft: 9147.6
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Annual Amount: 6200.0
  • Tax Block: 5
  • Tax Lot: 2-31
  • Tax Tract: 166

MLS Schools

  • HighSchool: Columbia

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 4, 2022
Closed on
May 26, 2022
Sold by
Guzzardi Michael A
Bought by
Rotundo Carley and Colon Stephen
Seller's Agent
Kathie Spangler
Julie & Co Realty, LLC
Buyer's Agent
Brian Sinkoff
CM Fox Real Estate
List Price
$315,000
Sold Price
$350,719
Premium/Discount to List
$35,719
11.34%
Current Estimated Value
$415,408

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$64,689
Avg. Annual Appreciation
5.35%
Original Mortgage
$250,000
Outstanding Balance
$237,888
Interest Rate
5.11%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$177,520

Purchase Details

Listed on
Jun 24, 2013
Closed on
Aug 29, 2013
Sold by
Morrison Stephanie
Bought by
Guzzardi Michael
Seller's Agent
John Mesko
Coldwell Banker Prime Properties
Buyer's Agent
David Phaff
Howard Hanna Capital Inc
List Price
$229,000
Sold Price
$221,000
Premium/Discount to List
-$8,000
-3.49%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.42%
Original Mortgage
$176,800
Interest Rate
4.34%
Mortgage Type
Purchase Money Mortgage
Source: Public Records

Range of Values:

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 Buyer Sale Price Title Company
Rotundo Carley $350,719 None Available
Guzzardi Michael $221,000 Brown & Brown
Morrison Stephanie -- Anthoy Maney
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Rotundo Carley $250,000
Previous Owner Guzzardi Michael A $6,773
Previous Owner Morrison Stephanie $176,800
Previous Owner Morrison Stephanie L $50,000
Previous Owner Morrison Stephanie L $20,000
Previous Owner Morrison Stephanie L $92,552
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/26/2022 05/26/22 Sold $350,719 +9.9% $249 / Sq Ft
04/06/2022 04/06/22 Pending -- -- --
04/04/2022 04/04/22 Price Changed $319,000 +1.3% $226 / Sq Ft
04/04/2022 04/04/22 For Sale $315,000 +42.5% $223 / Sq Ft
08/29/2013 08/29/13 Sold $221,000 -3.5% $157 / Sq Ft
07/10/2013 07/10/13 Pending -- -- --
06/24/2013 06/24/13 For Sale $229,000 -- $162 / Sq Ft
Source: Global MLS

Tax History Compared to Growth

Source: Public Records

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 $6,793 $238,500 $19,000 $219,500
2023 $8,165 $238,500 $19,000 $219,500
2022 $7,977 $230,000 $19,000 $211,000
2021 $8,060 $230,000 $19,000 $211,000
2020 $6,566 $230,000 $19,000 $211,000
2019 $6,599 $230,000 $19,000 $211,000
2018 $6,599 $230,000 $19,000 $211,000
2017 $6,154 $204,500 $21,000 $183,500
2016 $5,974 $204,500 $21,000 $183,500
2015 -- $204,500 $21,000 $183,500
2014 -- $204,500 $21,000 $183,500
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Global MLS

MLS Number: 202214793

Global MLS

APN: 2400-166.5-2-31