Immaculate home in Guilderland Schools featuring hardwood floors up and down, fresh paint throughout, and a grand two-story entry with a beautiful front door. Enjoy a two-story great room with fireplace and built-ins, first-floor study with window seat and attached full bath, perfect for guests. The kitchen boasts new appliances, lighting, tile backsplash and under cabinet lighting. Elegant dining room with tray ceiling, crown molding, and wet bar. Oak tread stairs lead to a spacious primary suite with two closets, double-entry bath, tile shower, dual vanities, and soaking tub. New furnace and hot water heater. Set on a cul-de-sac with a large fenced yard, patio, pool and a 3-car garage!
Closed
$780,000
6004 Queen Mary Court, Schenectady, NY 12303
4beds
3,374sqft
Single Family Residence, Residential
Built in 2004
0.47 Acres Lot
$818,400 Zestimate®
$231/sqft
$4,412 Estimated rent
Home value
$818,400
$720,000 - $933,000
$4,412/mo
Zestimate® history
Owner options
List your home for rent
$4,412/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$4,412/mo
Rent Zestimate®
Refinance and save
$5,262/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$5,262/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:
Shannon McCarthy 518-663-6315,
eXp Realty
Bought with:
Hassan Khan, 10491211126
The People's Real Estate Group
Source: Global MLS,MLS#: 202521777
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 4
Primary bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: Second
Primary bathroom
- Level: Second
Full bathroom
- Level: First
Full bathroom
- Level: Second
Full bathroom
- Level: Second
Full bathroom
- Level: Basement
Den
- Level: First
Dining room
- Level: First
Family room
- Level: First
Kitchen
- Level: First
Laundry
- Level: First
Living room
- Level: First
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Cooktop, Dishwasher, Disposal, Dryer, Microwave, Oven, Refrigerator, Wine Cooler
- Laundry: Laundry Room, Main Level
Features
- High Speed Internet, Tray Ceiling(s), Walk-In Closet(s), Wet Bar, Built-in Features, Cathedral Ceiling(s), Central Vacuum, Ceramic Tile Bath, Crown Molding, Eat-in Kitchen, Kitchen Island
- Flooring: Tile, Hardwood
- Basement: Finished,Full
- Number of fireplaces: 1
- Fireplace features: Family Room, Gas
Interior area
- Total structure area: 3,374
- Total interior livable area: 3,374 sqft
- Finished area above ground: 3,374
- Finished area below ground: 0
Property
Parking
- Total spaces: 6
- Parking features: Attached, Driveway, Garage Door Opener
- Garage spaces: 3
- Has uncovered spaces: Yes
Features
- Patio & porch: Patio
- Pool features: In Ground
- Fencing: Fenced
Lot
- Size: 0.47 Acres
- Features: Sprinklers In Front, Cul-De-Sac
Details
- Additional structures: Shed(s)
- Parcel number: 013089 27.05220
- Zoning description: Single Residence
- Special conditions: Standard
- Other equipment: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence, Residential
Materials
- Vinyl Siding
- Foundation: Concrete Perimeter
- Roof: Asphalt
Condition
- Updated/Remodeled
- New construction: No
- Year built: 2004
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Connected
Community & HOA
Community
- Security: Smoke Detector(s), Carbon Monoxide Detector(s)
HOA
- Has HOA: No
Location
- Region: Schenectady
Financial & listing details
- Price per square foot: $231/sqft
- Tax assessed value: $772,000
- Annual tax amount: $15,973
- Date on market: 7/16/2025
Price history
| Date | Event | Price |
|---|---|---|
| 9/22/2025 | Sold | $780,000-2.5%$231/sqft |
Source:  Global MLS #202521777 Report a problem | ||
| 8/11/2025 | Pending sale | $799,900$237/sqft |
Source: Global MLS #202521777 Report a problem | ||
| 7/16/2025 | Listed for sale | $799,900$237/sqft |
Source: Global MLS #202521777 Report a problem | ||
| 6/26/2025 | Listing removed | $799,900$237/sqft |
Source: Global MLS #202518703 Report a problem | ||
| 6/3/2025 | Listed for sale | $799,900+0.1%$237/sqft |
Source: Global MLS #202518703 Report a problem | ||
| 5/20/2025 | Listing removed | $799,000$237/sqft |
Source: NY State MLS #11361229 Report a problem | ||
| 3/31/2025 | Price change | $799,000-5.9%$237/sqft |
Source: NY State MLS #11361229 Report a problem | ||
| 3/4/2025 | Price change | $849,000-3.4%$252/sqft |
Source: NY State MLS #11361229 Report a problem | ||
| 1/10/2025 | Price change | $879,000-2.2%$261/sqft |
Source: NY State MLS #11361229 Report a problem | ||
| 11/7/2024 | Listed for sale | $899,000+63.8%$266/sqft |
Source: NY State MLS #11361229 Report a problem | ||
| 12/26/2023 | Sold | $549,000-29%$163/sqft |
Source: Global MLS #202328696 Report a problem | ||
| 10/17/2023 | Sold | $772,720+18.9%$229/sqft |
Source: Public Record Report a problem | ||
| 7/8/2012 | Listing removed | $650,000$193/sqft |
Source: Coldwell Banker Prime Properties, Inc. #201125634 Report a problem | ||
| 8/13/2011 | Listed for sale | $650,000+34%$193/sqft |
Source: Listhub #201125634 Report a problem | ||
| 12/11/2006 | Sold | $485,000$144/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $579,000 |
| 2024 | -- | $579,000 |
| 2023 | -- | $579,000 |
| 2022 | -- | $579,000 |
| 2021 | -- | $579,000 |
| 2020 | -- | $579,000 |
| 2019 | -- | $579,000 +17.4% |
| 2018 | -- | $493,000 |
| 2017 | -- | $493,000 |
| 2016 | -- | $493,000 |
| 2015 | -- | $493,000 |
| 2014 | -- | $493,000 |
| 2013 | -- | $493,000 |
| 2012 | -- | $493,000 |
| 2011 | -- | $493,000 |
| 2010 | -- | $493,000 |
| 2009 | -- | $493,000 |
| 2008 | -- | $493,000 +6% |
| 2007 | -- | $465,000 |
| 2006 | -- | $465,000 |
| 2005 | -- | $465,000 +1228.6% |
| 2004 | -- | $35,000 +250% |
| 2003 | -- | $10,000 |
| 2002 | -- | $10,000 |
| 2001 | -- | $10,000 |
| 2000 | -- | $10,000 |
Find assessor info on the county website
Neighborhood: 12303
Nearby homes
- $695,1004 bd2 ba3k sqft6003 Queen Mary Ct, Schenectady, NY 12303Off Market
- $675,1004 bd2 ba3k sqft5007 Colonial Dr, Schenectady, NY 12303Off Market
- $837,2004 bd3 ba3k sqft5007 Colonial Dr, Guilderland, NY 12084Off Market
- $693,4004 bd3 ba3k sqft3052 New Williamsburg Dr, Schenectady, NY 12303Off Market
- $700,0004 bd4 ba3.1k sqft3054 New Williamsburg Dr, Schenectady, NY 12303Sold
- $670,8004 bd3 ba2.6k sqft3050 New Williamsburg Dr, Schenectady, NY 12303Off Market
- $876,3003 bd4 ba3.9k sqft5009 Colonial Dr, Schenectady, NY 12303Off Market
- $768,6004 bd2 ba2.7k sqft3056 New Williamsburg Dr, Schenectady, NY 12303Off Market
Nearby schools
GreatSchools rating
- 8/10Lynnwood Elementary SchoolGrades: K-5Distance: 1.1 mi
- 7/10Farnsworth Middle SchoolGrades: 6-8Distance: 4.5 mi
- 8/10Guilderland High SchoolGrades: 9-12Distance: 3 mi
Schools provided by the listing agent
- Elementary: Lynnwood
- High: Guilderland
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 .
$818,400
2% more
+$16,368
With Zillow Showcase(estimated)
$834,768
- New York
- Albany County
- Schenectady
- 12303
- 6004 Queen Mary Court
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Schenectady Topics
