Skip main navigation
Active
    • Price cut: $25K (10/9)
    $850,000

    254 French Rd, Piseco, NY 12139

    7beds
    5,088sqft
    Single Family Residence
    Built in 1915
    32.76 Acres Lot
    $922,100 Zestimate®
    $167/sqft
    $-- HOA

    What's special

    Two-story barnMotorized blackout shadesHydrow rowerFour-room suiteNautilus gymHome gymAmazing closet
    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
    423 days
    |
    216
    |
    24
    |

    Zillow last checked: 8 hours ago

    Listing updated: October 30, 2025 at 03:41pm

    Listing by:

    TIMM ASSOCIATES SOTHEBY'S 315-369-3951,

    Heather Timm-Keen 315-369-5434

    Source: NYSAMLSs,MLS#: S1576782MLS LogoOriginating MLS: Mohawk Valley

    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: $167/sqft
    • Tax assessed value: $285,500
    • Annual tax amount: $6,166
    • Date on market: 11/8/2024
    • Cumulative days on market: 404 days
    • Listing terms: Cash,Conventional
    Heather Timm Keen - NY Licensed Assoc. R.E. Broker

    (315) 369-5434

    By pressing Contact Agent, you agree that the real estate professional identified above may call/text you about your search, which may involve use of automated means and pre-recorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply. You also agree to our Terms of Use. Zillow does not endorse any real estate professionals. We may share information about your recent and future site activity with your agent to help them understand what you're looking for in a home.

    Estimated market value

    $922,100

    $876,000 - $968,000

    Not available

    Price history

    Price history
    DateEventPrice
    10/9/2025Price change$850,000-2.9%$167/sqft
    Source: NYSAMLSs #S1576782 Report a problem
    7/1/2025Price change$875,000-3.8%$172/sqft
    Source: NYSAMLSs #S1576782 Report a problem
    6/2/2025Price change$910,000-3.7%$179/sqft
    Source: NYSAMLSs #S1576782 Report a problem
    4/21/2025Price change$945,000-2.1%$186/sqft
    Source: NYSAMLSs #S1576782 Report a problem
    11/8/2024Listed for sale$965,000$190/sqft
    Source: NYSAMLSs #S1576782 Report a problem

    Public tax history

    Public tax history
    Tax history is unavailable.

    BuyAbility℠ payment

    Estimated monthly payment
    All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
    HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
    Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
    See how much you could borrow to make a competitive offer.

    Boost your down payment with 6% savings match

    Earn up to a 6% match & get a competitive APY with a *. Zillow has partnered with to help get you home faster.

    Learn more*Terms apply. Match provided by Foyer. Account offered by Pacific West Bank, Member FDIC.

    Climate risks

    Neighborhood: 12139

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • District: Poland

    Source: NYSAMLSs. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Skip to the end of the carouselSkip to the beginning of the carousel
    • Loading

    Nearby cities

    Nearby zip codes

    Other Hoffmeister Topics