Located on 32 stunning acres in the Adirondacks, the historic Mountainview Lodge has been meticulously renovated, upgraded, and modernized for use as a single-family home, vacation home, or B&B. With seven bedrooms and four full bathrooms, the Lodge has high-quality flooring and cabinetry throughout with beautiful lighting and solid oak trim and doors; a new 50-year metal roof was added in 2024; and a new whole-home 22 KW generator was added in 2025. The main floor has a spacious custom kitchen, and an adjoining family room flooded with natural light; a formal dining room and adjoining pantry; a living room with a gas fireplace and 4K TV; a primary suite with lovely views and an amazing closet; and a guest bath with a jacuzzi tub and a laundry area with two washers and two dryers! Adjoining the family room is a spectacular movie room with motorized blackout shades, a ten-foot screen, and a 7.1 surround sound system. There are two second floors in this home. A spiral staircase leads to a charming guest suite with a beautiful rustic bathroom, storage area, and an adorable sleeping loft for the kids; the other leads to a spectacular four-room suite, guest bathroom, and two more bedrooms. The home's third floor features a beautifully appointed office and a fully equipped home gym, including a Peloton cardio bike, a Hydrow rower, a Proform elliptical, and a Nautilus gym. Numerous items come with the property, such as the home gym fitness equipment, home theatre projector, motorized screen, surround sound speakers, blackout shades, a 75” OLED TV, two 65” 4K TVs, five room air conditioners, and assorted office, bedroom, and living room furniture. Additional features include a two-story barn, two basements, DirecTV, and high-speed fiber optic wi-fi internet, and all of this right down the road from a network of groomed snowmobile trails
Active
Price cut: $35K (7/1)
$875,000
254 French Rd, Piseco, NY 12139
7beds
5,088sqft
Single Family Residence
Built in 1915
32.76 Acres Lot
$922,100 Zestimate®
$172/sqft
$-- HOA
What's special
Two-story barnMotorized blackout shadesHydrow rowerBlackout shadesFour-room suiteNautilus gymHome gym
- 279 days
- on Zillow |
- 189 |
- 9 |
Zillow last checked: 7 hours ago
Listing updated: July 01, 2025 at 10:17am
Listing by:
TIMM ASSOCIATES SOTHEBY'S 315-369-3951,
Heather Timm-Keen 315-369-5434
Source: NYSAMLSs,MLS#: S1576782
Originating MLS: Mohawk Valley

Travel times
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 7
- Bathrooms: 4
- Full bathrooms: 4
- Main level bathrooms: 2
- Main level bedrooms: 1
Bedroom 1
- Level: Second
- Dimensions: 18.00 x 17.00
Bedroom 2
- Level: Lower
- Dimensions: 13.00 x 15.00
Other
- Level: Lower
- Dimensions: 20.00 x 20.00
Family room
- Level: Lower
- Dimensions: 14.00 x 19.00
Kitchen
- Level: Lower
- Dimensions: 15.00 x 19.00
Living room
- Level: Lower
- Dimensions: 20.00 x 15.00
Heating
- Propane, Forced Air
Cooling
- Window Unit(s)
Appliances
- Included: Built-In Range, Built-In Oven, Double Oven, Dishwasher, Exhaust Fan, Gas Oven, Gas Range, Microwave, Propane Water Heater, Refrigerator, Range Hood, Wine Cooler
- Laundry: Main Level
Features
- Breakfast Bar, Ceiling Fan(s), Dry Bar, Den, Separate/Formal Dining Room, Jetted Tub, Kitchen Island, Kitchen/Family Room Combo, Pantry, Partially Furnished, Natural Woodwork, Convertible Bedroom, Bath in Primary Bedroom, Main Level Primary
- Flooring: Carpet, Hardwood, Tile, Varies
- Basement: Full,Walk-Out Access
- Number of fireplaces: 1
Interior area
- Total structure area: 5,088
- Total interior livable area: 5,088 sqft
Video & virtual tour
Property
Parking
- Total spaces: 3
- Parking features: Detached, Garage, Storage, Workshop in Garage, Garage Door Opener
- Garage spaces: 3
Features
- Stories: 3
- Patio & porch: Open, Porch
- Exterior features: Blacktop Driveway, Propane Tank - Owned
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Pond
- Body of water: Other
- Frontage length: 111111
Lot
- Size: 32.76 Acres
- Dimensions: 530 x 1632
- Features: Adjacent To Public Land, Irregular Lot
Details
- Additional structures: Barn(s), Outbuilding
- Parcel number: 134.00514 & 134.005110.200
- Special conditions: Standard
- Other equipment: Generator, Satellite Dish
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Historic/Antique,Traditional
- Property subtype: Single Family Residence
Materials
- Wood Siding
- Foundation: Stone
- Roof: Metal
Condition
- Resale
- Year built: 1915
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
- Utilities for property: High Speed Internet Available
Green energy
- Energy efficient items: Appliances, Windows
Community & HOA
Location
- Region: Piseco
Financial & listing details
- Price per square foot: $172/sqft
- Tax assessed value: $285,500
- Annual tax amount: $6,166
- Date on market: 11/8/2024
- Listing terms: Cash,Conventional
- Loading