Active Under Contract
3D Tour3D Tour
Single family home for sale at 254 French Rd, Piseco, NY 12139 | MLS# S1576782 | Listing updated on 2026-07-29
Photo 1 of Single family home for sale at 254 French Rd, Piseco, NY 12139 | MLS# S1576782 | Listing updated on 2026-07-29
Photo 2 of Single family home for sale at 254 French Rd, Piseco, NY 12139 | MLS# S1576782 | Listing updated on 2026-07-29
Photo 3 of Single family home for sale at 254 French Rd, Piseco, NY 12139 | MLS# S1576782 | Listing updated on 2026-07-29
Photo 4 of Single family home for sale at 254 French Rd, Piseco, NY 12139 | MLS# S1576782 | Listing updated on 2026-07-29
46+
Beds Icon

Virtual Tour

Beds Icon

Street View

$789,000

Monthly Est:$3,927

  • Beds Icon7 Beds
  • Beds Icon
    4 Baths
  • Beds Icon5,088sqft

254 French Rd, Piseco, NY 12139

$3,927/moEst:

Get Pre-Approved

  • Single Family Residence

  • Built in 1915

  • $-- HOA

  • 31 acres lot

  • $155/sq.ft

Description

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; 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. 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 home gym. Negotiable conveyances include the home gym fitness equipment (Peloton cardio bike, Hydrow rower, Proform elliptical and Nautilus gym), home theatre equipment (Epson projector, motorized screen, 7.1 surround sound system), 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 fibre-optic Wi-Fi internet, all right down the road from a network of groomed snowmobile trails.

  • Houzeo last checked: 12 hours ago
  • Listing updated: July 29, 2026 at 5:55 pm
  • Listing Provided by: Heather Timm-Keen (315) 369-5434 DRE #10311210684 | TIMM ASSOCIATES SOTHEBY'S (315) 369-3951
  • Source: New York State Alliance of MLSs, Buffalo-NY | MLS#: S1576782 New York State Alliance of MLSs, Buffalo-NY

Property Details

  • Status

    Active Under Contract

  • Type

    Single Family Residence

  • No. of Stories

    3

  • County

    Hamilton County

  • City

    Piseco

  • Neighborhood

    --

  • Year Built

    1915

  • HOA Fees

    -

  • Finished Area

    5,088 sqft

  • Lot Size

    31 acres lot

  • Basement Area

    - sqft

  • MLS Name

    New York State Alliance of MLSs, Buffalo

  • MLS Number

    S1576782

  • MLS Status

    ActiveUnderContract

  • Days on Market

    703

  • Cumulative Days on Market

    628

Continue Your Journey in App

Find your dream home, receive real-time updates, and many more!

Location

Facts & Features

Rooms

  • Bedrooms & bathrooms

    Bedrooms: 7

    Bathrooms: 4

  • Bedroom1

    Level: Second

    Area: 306.00 Square Feet

    Dimensions: 18.00 x 17.00

  • Bedroom2

    Level: Lower

    Area: 195.00 Square Feet

    Dimensions: 13.00 x 15.00

  • LivingRoom

    Level: Lower

    Area: 300.00 Square Feet

    Dimensions: 20.00 x 15.00

  • FamilyRoom

    Level: Lower

    Area: 266.00 Square Feet

    Dimensions: 14.00 x 19.00

  • Bar

    Level: Lower

    Area: 400.00 Square Feet

    Dimensions: 20.00 x 20.00

  • Kitchen

    Level: Lower

    Area: 285.00 Square Feet

    Dimensions: 15.00 x 19.00

Interior

  • Exterior Features

    Blacktop Driveway, Propane Tank Owned

  • Cooling

    Window Units

  • Sewer

    Septic Tank

  • Flooring

    Carpet, Hardwood, Tile, Varies

  • Appliances

    Built In Range, Built In Oven, Double Oven, Dishwasher, Exhaust Fan, Gas Oven, Gas Range, Microwave, Propane Water Heater, Refrigerator, Range Hood, Wine Cooler

  • Heating

    Propane, Forced Air

  • Interior Features

    Breakfast Bar, Ceiling Fans, 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

Construction

  • Year Built

    Year Built: 1915

  • Home type

    Single Family Residence

  • Construction Materials

    Wood Siding

  • Architectural Style

    Historic Antique, Traditional

  • Foundation Details

    Stone

  • Property Condition

    Resale

  • Roof

    Metal

Utilities & Energy

  • Parking Features

    Detached, Garage, Storage, Workshop In Garage, Garage Door Opener

  • Utilities

    High Speed Internet Available

  • Water Source

    Well

  • Laundry Features

    Main Level

  • Basement

    Full, Walk Out Access

Other Features

  • Lot Features

    Adjacent To Public Land, Irregular Lot

  • Patio And Porch Features

    Open, Porch

Price History

DateEventPrice

07/29/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #S1576782

Contingent (Active Under Contract)

$789,000

$155/sqft

07/29/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #S1576782

Off Market

$789,000

$155/sqft

07/05/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #S1576782

Price Decreased

$789,000 -0.75%

$155/sqft

05/28/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #S1576782

Price Decreased

$795,000 -5.36%

$156/sqft

02/26/2026

Source: mls_logoNew York State Alliance of MLSs, Buffalo-NY #S1576782

Price Increased

$840,000 +1.82%

$165/sqft

Show more

Based on data from the New York State Alliance of MLSs (CNYIS, Inc., UNYREIS and WNYREIS) through Oct 12, 2026, 10:30AM.. All information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable by is not guaranteed accurate by the MLS. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. All information provided is deemed reliable but is not guaranteed and should be independently verified. © 2026 the New York State Alliance of MLSs. All Rights Reserved.

Advertising Broker: Derek Greene | The Greene Realty Group