Turn-of-the-century grandeur meets effortless modern living at The John Riley House (c. 1906). Nestled in Schenectady's iconic GE Realty Plot, this impressive Colonial Revival masterpiece delivers timeless elegance on a truly majestic scale. From the moment you step inside, you are greeted by breathtaking 11-foot first-floor ceilings and a soaring 23-foot dramatic floating staircase—setting an unforgettable stage for entertaining. Meticulously updated while honoring its historic integrity, the home features a light-filled rear addition featuring a chef's dream kitchen, sunlit dining area, and inviting family room anchored by a cozy gas stove. Retreat upstairs to an expansive primary suite complete with a private bath, walk-through closet, and abundant storage. Outdoors, summer evenings belong on the breezy side porch—the ultimate spot for drinks, laughter, and lively conversation with neighbors. Complete with gleaming hardwood floors, abundant natural light, a sun-drenched four-season reading room with its own gas fireplace, and a detached three-car garage, this remarkable residence arrives on the market in pristine condition thanks to thoughtful, high-end improvements. Simply turn the key and welcome home! New steam boiler 2022. 2023 - new roof, both shingles and flat rolled rubber, new skylights, chimneys repointed, new liners and washer and dryer installed on 1st floor. 2024 - new 50 gallon water heater, ventilation exhaust on 3rd floor bathroom installed. OPEN HOUSE Sunday the 25th, 12-2PM. Detached three car garage sold as is.
Active
$539,500
1175 Stratford Road, Schenectady, NY 12308
4beds
4,501sqft
Single Family Residence, Residential
Built in 1906
0.39 Acres Lot
$530,700 Zestimate®
$120/sqft
$-- HOA
What's special
Abundant natural lightExpansive primary suiteDetached three-car garageLight-filled rear additionWalk-through closetPrivate bathSunlit dining area
- 8 days
- 1,826
- 180
Likely to sell faster than
Zillow last checked:
Listing updated:
Listed by:
Howard Hanna Capital Inc 518-371-4500,
Dawn Meifert 214-577-5701
Source: Global MLS,MLS#: 202628638
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Primary bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: Third
Primary bathroom
- Level: Second
Half bathroom
- Level: First
Full bathroom
- Level: Second
Full bathroom
- Level: Second
Full bathroom
- Level: Third
Den
- Level: First
Den
- Level: First
Dining room
- Level: First
Family room
- Level: First
Kitchen
- Level: First
Laundry
- Level: First
Living room
- Level: First
Heating
- Hot Water, Natural Gas
Cooling
- Window Unit(s)
Appliances
- Included: Dishwasher, Disposal, Double Oven, Gas Oven, Range Hood, Refrigerator, Washer/Dryer
- Laundry: Gas Dryer Hookup, In Basement, Laundry Room, Main Level
Features
- Solid Surface Counters, Vaulted Ceiling(s), Walk-In Closet(s), Built-in Features, Ceramic Tile Bath, Chair Rail, Crown Molding, Eat-in Kitchen, Kitchen Island
- Flooring: Tile, Ceramic Tile, Hardwood
- Doors: French Doors
- Windows: Wood Frames
- Basement: Bilco Doors,Full,Sump Pump
- Number of fireplaces: 2
- Fireplace features: Bedroom, Family Room, Gas, Living Room, Wood Burning
Interior area
- Total structure area: 4,501
- Total interior livable area: 4,501 sqft
- Finished area above ground: 4,501
- Finished area below ground: 0
Video & virtual tour
Property
Parking
- Total spaces: 4
- Parking features: Paved, Detached, Garage Door Opener, Driveway
- Garage spaces: 3
- Has uncovered spaces: Yes
Features
- Patio & porch: Side Porch, Covered, Porch
- Exterior features: Garden, Lighting
- Fencing: Stone,Back Yard,Chain Link
- Has view: Yes
- View description: Garden
Lot
- Size: 0.39 Acres
- Features: Level, Garden, Landscaped
Details
- Additional structures: Garage(s)
- Parcel number: 421500 39.68124
- Zoning description: Single Residence
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence, Residential
Materials
- Clapboard, Stone
- Foundation: Stone
- Roof: Flat,Rubber,Shingle,Asphalt
Condition
- New construction: No
- Year built: 1906
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Connected
Community & HOA
Community
- Security: 24 Hour Security
- Subdivision: General Electric Realty Plot
HOA
- Has HOA: No
Location
- Region: Schenectady
Financial & listing details
- Price per square foot: $120/sqft
- Tax assessed value: $532,870
- Annual tax amount: $15,521
- Date on market: 10/21/2026
- Listing terms: Assumable
Estimated market value
$530,700
$504,000 - $557,000
$3,792/mo
Price history
| Date | Event | Price |
|---|---|---|
| 10/21/2026 | Listed for sale | $539,500+22.5%$120/sqft |
Source:  Global MLS #202628638 Report a problem | ||
| 2/22/2023 | Sold | $440,500+0.3%$98/sqft |
Source: Global MLS #202229599 Report a problem | ||
| 1/10/2023 | Pending sale | $439,000$98/sqft |
Source: Global MLS #202229599 Report a problem | ||
| 11/4/2022 | Listed for sale | $439,000+39.4%$98/sqft |
Source: Global MLS #202229599 Report a problem | ||
| 7/30/2010 | Sold | $315,000-10%$70/sqft |
Source: Global MLS #201015385 Report a problem | ||
| 3/24/2010 | Listed for sale | $350,000+52.2%$78/sqft |
Source: Realty USA #201015385 Report a problem | ||
| 12/19/2000 | Sold | $230,000+2.2%$51/sqft |
Source: Public Record Report a problem | ||
| 9/22/1997 | Sold | $225,000$50/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $321,800 |
| 2024 | -- | $321,800 |
| 2023 | -- | $321,800 |
| 2022 | -- | $321,800 |
| 2021 | -- | $321,800 |
| 2020 | -- | $321,800 |
| 2019 | -- | $321,800 |
| 2018 | -- | $321,800 |
| 2017 | $12,267 | $321,800 |
| 2016 | -- | $321,800 |
| 2015 | -- | $321,800 |
| 2014 | -- | $321,800 |
| 2013 | -- | $321,800 |
| 2012 | -- | $321,800 |
| 2011 | -- | $321,800 |
| 2010 | -- | $321,800 |
| 2009 | -- | $321,800 +35.3% |
| 2008 | -- | $237,800 |
| 2007 | -- | $237,800 |
| 2006 | -- | $237,800 |
| 2005 | -- | $237,800 |
| 2004 | -- | $237,800 +11% |
| 2002 | -- | $214,200 |
| 2001 | -- | $214,200 |
| 2000 | -- | $214,200 |
Find assessor info on the county website
Monthly payment
Climate risks
Neighborhood: Union Street
Nearby schools
Schools provided by the listing agent
- Elementary: Jessie T. Zoller
- High: Schenectady
Source: Global MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Similar homes
- $439,5007 bd5 ba3.4k sqft1424 Wendell Avenue, Schenectady, NY 12308Active
MLS ID #202628650, Dawn Meifert, Listing by: Howard Hanna Capital Inc. Global MLS - $445,4405 bd3 ba3.2k sqft1555 Wendell Avenue, Schenectady, NY 12308Active
MLS ID #202628541, Joshua Shuhart, Listing by: Coldwell Banker Prime Properties. Global MLS - $550,0004 bd4 ba3.3k sqft1935 Heritage Road, Schenectady, NY 12309Active
MLS ID #202627458, Melissa Matey, Listing by: Miranda Real Estate Group Inc. Global MLS - $539,9004 bd3 ba2.3k sqft365 W Highland Drive, Guilderland, NY 12303Active
MLS ID #202628732, Bruce W Dedon, Listing by: Coldwell Banker Prime Properties. Global MLS
