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
$785,300 Zestimate®
$231/sqft
$3,994 Estimated rent
Owner options
What's special
Zillow last checked: 8 hours ago
Listing updated: September 22, 2025 at 11:24am
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 & neighborhood
Security
- Security features: Smoke Detector(s), Carbon Monoxide Detector(s)
Location
- Region: Schenectady