Skip main navigation
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
    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
    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#: S1576782MLS LogoOriginating 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