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!
Active
$799,900
6004 Queen Mary Court, Schenectady, NY 12303
4beds
3,374sqft
Single Family Residence, Residential
Built in 2004
0.47 Acres Lot
$789,000 Zestimate®
$237/sqft
$-- HOA
What's special
First-floor studyDouble-entry bathLarge fenced yardDual vanitiesWet barSpacious primary suiteUnder cabinet lighting
- 12 days
- on Zillow |
- 901 |
- 62 |
Zillow last checked: 7 hours ago
Listing updated: June 08, 2025 at 11:32pm
Listing by:
eXp Realty 888-276-0630,
Shannon McCarthy 518-663-6315
Source: Global MLS,MLS#: 202518703

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
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: Second
Full bathroom
- Level: Second
Full bathroom
- Level: First
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: $237/sqft
- Tax assessed value: $706,098
- Annual tax amount: $15,973
- Date on market: 6/3/2025
- Loading
- Loading