Prepare to be truly wowed the moment you step into this architectural masterpiece. One-of-a-kind home set on a double lot with breathtaking views of the Mohawk River. Watch boats sail and bald eagles fly from almost anywhere in the house, including your bed in the lofted master bedroom or your very own infrared sauna. A stunning floor plan, soaring ceilings, expansive living room, wall of windows, top-of-the-line kitchen, beautiful woodwork throughout. Spectacular bathroom suite, w/a separate shower & jet tub. HE multi-zone radiant heating, 2 two-ton mini-split ACs (one of which is also a heat pump), & a wood-burning stove. Attached 2-car garage, circular driveway, mature trees (some fruit-bearing). This almost one-acre of waterfront property is about luxury! Seller relocating for work.
Closed
$507,500
788 Middle Street, Niskayuna, NY 12309
3beds
2,472sqft
Single Family Residence, Residential
Built in 2004
0.75 Acres lot
$-- Zestimate®
$205/sqft
$-- HOA
What's special
Zillow last checked: 7 hours ago
Listing updated: September 23, 2024 at 10:57pm
Listed by:
Barbara A Walton 518-527-5800,
Walton Realty Group
Bought with:
Barbara A Walton, 10311204421
Walton Realty Group
Source: Global MLS,MLS#: 202224984

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Primary bedroom
- Level: Third
Bedroom
- Level: Third
Bedroom
- Level: Second
Full bathroom
- Level: Second
Full bathroom
- Level: Third
Dining room
- Level: Second
Family room
- Level: First
Foyer
- Level: First
Living room
- Level: Second
Heating
- Heat Pump, Propane, Radiant Floor
Cooling
- Central Air, Ductless
Appliances
- Included: Convection Oven, Cooktop, Dishwasher, Disposal, Double Oven, Microwave, Range Hood, Refrigerator, Washer/Dryer
- Laundry: Laundry Room, Main Level
Features
- High Speed Internet, Sauna, Solid Surface Counters, Vaulted Ceiling(s), Cathedral Ceiling(s), Ceramic Tile Bath, Kitchen Island
- Flooring: Slate, Wood, Ceramic Tile, Hardwood
- Doors: Atrium Door, French Doors
- Number of fireplaces: 1
- Fireplace features: Wood Burning Stove, Living Room
Interior area
- Total structure area: 2,472
- Total interior livable area: 2,472 sqft
- Finished area above ground: 2,472
- Finished area below ground: 200
Property
Parking
- Total spaces: 10
- Parking features: Paved, Attached, Driveway, Garage Door Opener
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Patio & porch: Patio
- Exterior features: Lighting
- Fencing: Other
- Has view: Yes
- View description: River
- Has water view: Yes
- Water view: River
- Waterfront features: River Front
- Body of water: Mohawk River
Lot
- Size: 0.75 Acres
- Features: Views
Details
- Parcel number: 31.11113
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Custom
- Property subtype: Single Family Residence, Residential
Materials
- Cedar, Stone, Stucco
- Foundation: Slab
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2004
Utilities & green energy
- Sewer: Septic Tank
- Water: Public
Community & neighborhood
Location
- Region: Niskayuna