NOT LISTED FOR SALE

509 Windsor Ct Schenectady, NY 12309

Estimated Value: $877,318 - $971,000

4 Beds
5 Baths
4,017 Sq Ft
$228/Sq Ft Est. Value

Last Sold December 10, 2020

Last sale price $580,000 $144 Per Sq Ft

Est. 58% increase in value since last sale

Current estimated payment $5,707/month

128 Days on Market

Highlights

  • Deck
  • Contemporary Architecture
  • Vaulted Ceiling
  • Craig Elementary School Rated A-
  • Private Lot
  • Wood Flooring

About This Home

As of December 2020

Stunning Contemporary home on a private cul-de-sac in exclusive Windsor Estates. This 4000+ sq. ft. luxury home offers 4 bedrooms, 3 full baths and 2 half baths. Featuring 2 story foyer,1st flr study w/ custom built-in cabinetry, living room w/ vaulted ceiling,grand FDR w/ tray ceiling and crown molding, spacious eat-in-kitchen w/ island and dry bar,family room w/ custom wall entertainment system, gas FP & surround sound system through out many rooms and a sunlit 4 season room addition. Sliding glass doors from kitchen/sunroom lead to spacious deck & private yard. 2nd flr master suite w/ dble sided gas FP, jetted tub, 3 additional spacious bedrooms. Additional 1800 sq ft of finished basement space w/ rec room, entertainment wet bar w/ granite counters, work out room & half bath. 3 car gar. Excellent Condition

Last Agent to Sell the Property

Christine Serafini

Miranda Real Estate Group Inc License #40SE0980789 Listed on: 06/02/2020

Last Buyer's Agent

Binglin Li

RealtyUSA.com

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $21,390

Year Built

  • Built in 1999

Lot Details

  • Cul-De-Sac
  • Property has an invisible fence for dogs
  • Landscaped
  • Private Lot
  • Front and Back Yard Sprinklers

Parking

  • 3 Car Attached Garage
  • Driveway
  • Off-Street Parking

Home Design

  • Contemporary Architecture
  • Brick Exterior Construction
  • Vinyl Siding
  • Asphalt

Interior Spaces

  • Wet Bar
  • Built-In Features
  • Dry Bar
  • Chair Railings
  • Crown Molding
  • Tray Ceiling
  • Vaulted Ceiling
  • Paddle Fans
  • Gas Fireplace
  • Bay Window
  • French Doors
  • Sliding Doors
  • Finished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Eat-In Kitchen
  • Built-In Gas Oven
  • Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary bedroom located on second floor
  • Walk-In Closet
  • Jetted Tub in Primary Bathroom
  • Ceramic Tile in Bathrooms

Laundry

  • Laundry Room
  • Laundry on main level

Home Security

  • Home Security System
  • Fire and Smoke Detector

Outdoor Features

  • Deck
  • Exterior Lighting
  • Porch

Schools

  • Niskayuna High School

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Legal Lot and Block 33.1 / 1
  • Assessor Parcel Number 422400 40.16-1-33.1

Home Details

Home Type

Single Family

Est. Annual Taxes

$21,390

Year Built

Built in 1999

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Year Built: 1999
  • Directions: Balltown Rd. to Nott St East, cross over Van Antwerp Rd. to Windsor Drive, right on St. Ann and left on Windsor Court.
  • Above Grade Finished Sq Ft: 4017.0
  • Architectural Style: Contemporary
  • Financial Details General Taxes: 8501.0
  • General Taxes Description: Actual
  • Financial Details School Taxes: 12889.0
  • School Taxes Description: Actual
  • Lot Size: .54
  • New Construction: No
  • Parking Features Parking Total: 6.0
  • Full Bathroom Level: Second
  • Primary Bathrooms Level: Second
  • Primary Bedroom Level: Second
  • Sale Detail Seller Contribution: No
  • Subdivision Name: Windsor Estates
  • Garage Yn: Yes
  • Appliances Refrigerators: Yes
  • Architectural Style:Contemporary: Yes
  • Flooring:Carpet: Yes
  • Laundry Features:Main Level: Yes
  • Percent Basement Finished: Yes
  • Flooring:Hardwood: Yes
  • Cooling:Central Air: Yes
  • Appliances Microwave: Yes
  • Flooring:Ceramic Tile: Yes
  • Fencing:Invisible: Yes
  • Special Features: VirtualTour

Interior Features

  • Flooring: Carpet, Ceramic Tile, Hardwood
  • Basement: Finished, Full
  • Interior Amenities: High Speed Internet, Jet Tub, Paddle Fan, Tray Ceiling(s), Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar, Built-in Features, Ceramic Tile Bath, Chair Rail, Crown Molding, Dry Bar, Eat-in Kitchen, Kitchen Island
  • Appliances: Built-In Electric Oven, Built-In Gas Oven, Dishwasher, Disposal, Microwave, Oven, Range, Refrigerator
  • Full Bathrooms: 3
  • Half Bathrooms: 2
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1800.0
  • Door Features: French Doors, Sliding Doors
  • Fireplace Features: Bedroom, Family Room, Gas
  • Living Area: 4017.0
  • Bedroom Level: Second
  • Dining Room Level: First
  • Kitchen Level: First
  • Living Room Level: First
  • Sunroom Level: First
  • Window Features: Bay Window(s)
  • Fireplace: Yes
  • Appliances Dishwasher: Yes
  • Interior Features:High Speed Internet: Yes
  • Interior Features:Paddle Fan: Yes
  • Full Basement: Yes
  • Interior Features:Dry Bar: Yes
  • Kitchen Features:Eat-in Kitchen: Yes
  • Interior Features:Jet Tub: Yes
  • Interior Features:Walk-In Closet(s): Yes
  • Kitchen Features:Kitchen Island: Yes
  • Interior Features:Ceramic Tile Bath: Yes
  • Attic Features:Hatch: Yes
  • Interior Features:Wet Bar: Yes
  • Fireplace Features:Gas2: Yes
  • Interior Features:Chair Rail: Yes
  • Interior Features:Crown Molding: Yes
  • Appliances:Oven: Yes
  • Appliances Range: Yes
  • Appliances:Built-In Electric Oven: Yes
  • Appliances:Built-In Gas Oven: Yes
  • Interior Features:Built-in Features: Yes
  • Interior Features:Vaulted Ceiling(s): Yes
  • Fireplace Features:Family Room: Yes
  • Fireplace Features:Bedroom: Yes
  • Interior Features:Tray Ceiling(s): Yes
  • Fireplace Features:Full Bathroom: Yes

Exterior Features

  • Exterior Features: Drive-Paved, Gas Grill, Lighting
  • Roof: Asphalt
  • Construction Type: Brick, Vinyl Siding
  • Fencing: Invisible
  • Patio And Porch Features: Deck, Porch
  • Waterfront: No
  • Construction Materials:Vinyl Siding: Yes
  • Patio And Porch Features:Porch: Yes
  • Door Features:Sliding Doors: Yes
  • Exterior Features:Drive-Paved: Yes
  • Patio And Porch Features:Deck: Yes
  • Lot Features:Cul-De-Sac: Yes
  • Lot Features:Landscaped: Yes
  • Lot Features:Private: Yes
  • Construction Materials:Brick: Yes
  • Door Features:French Doors: Yes
  • Lot Features:Sprinklers In Front: Yes
  • Lot Features:Sprinklers In Rear: Yes
  • Exterior Features:Lighting: Yes
  • Exterior Features:Gas Grill: Yes
  • Window Features:Bay Window(s): Yes

Garage/Parking

  • Garage Spaces: 3.0
  • Parking Features: Off Street, Paved, Attached, Driveway
  • Attached Garage: Yes
  • Total Parking Spaces: 6.0
  • Property Detail:Garage Spaces: 3.0
  • Parking Features:Off Street: Yes
  • Parking Features:Attached: Yes
  • Parking Features:Driveway: Yes
  • Parking Features:Paved: Yes
  • Parking Features:Garage: Yes

Utilities

  • Utilities: Cable Available
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Electric: Automatic Generator
  • Heating: Forced Air, Natural Gas, Zoned
  • Laundry Features: Laundry Room, Main Level
  • Security: Smoke Detector(s), Security System
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Forced Air: Yes
  • Heating:Natural Gas: Yes
  • Heating:Zoned: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Parcel Tax HOA:Association YN: No

Schools

  • Junior High Dist: Niskayuna

Lot Info

  • Lot Features: Private, Sprinklers In Front, Sprinklers In Rear, Cul-De-Sac, Landscaped
  • Parcel #: 422400 40.16-1-33.1

Tax Info

  • Tax Annual Amount: 21390.0
  • Tax Block: 1
  • Tax Lot: 33.1

MLS Schools

  • HighSchool: Niskayuna

Matterport 3D Tour

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 2, 2020
Closed on
Oct 19, 2020
Sold by
Gordon Brian and Gordon Debra S
Bought by
Liu Feng and Sun Pengbo
Seller's Agent
Christine Serafini
Miranda Real Estate Group Inc
Buyer's Agent
Binglin Li
RealtyUSA.com
List Price
$689,900
Sold Price
$580,000
Premium/Discount to List
-$109,900
-15.93%
Current Estimated Value
$916,080

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$336,080
Avg. Annual Appreciation
9.38%
Original Mortgage
$464,000
Interest Rate
2.3%
Mortgage Type
New Conventional
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 Buyer Sale Price Title Company
Liu Feng -- None Available
Liu Feng -- Legacy Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Liu Feng $464,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
12/10/2020 12/10/20 Sold $580,000 -3.3% $144 / Sq Ft
10/07/2020 10/07/20 Pending -- -- --
10/05/2020 10/05/20 Price Changed $599,900 -4.8% $149 / Sq Ft
09/22/2020 09/22/20 Price Changed $629,900 -3.1% $157 / Sq Ft
09/01/2020 09/01/20 Price Changed $649,900 -5.8% $162 / Sq Ft
06/01/2020 06/01/20 For Sale $689,900 -- $172 / 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 $28,132 $630,000 $104,000 $526,000
2023 $284 $630,000 $104,000 $526,000
2022 $27,757 $630,000 $104,000 $526,000
2021 $23,420 $630,000 $104,000 $526,000
2020 $21,595 $660,000 $104,000 $556,000
2019 $12,889 $660,000 $104,000 $556,000
2018 $21,394 $660,000 $104,000 $556,000
2017 $22,017 $660,000 $104,000 $556,000
2016 $21,180 $660,000 $104,000 $556,000
2015 -- $748,000 $104,000 $644,000
2014 -- $748,000 $104,000 $644,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Global MLS

MLS Number: 202018775

Global MLS

APN: 040-016-0001-033-001-0000