Skip main navigation
For sale
  • $1,759,000

    18183 Piedmont Rd, Stewartstown, PA 17363

    11beds
    9,748sqft
    : 
    Loading
    Get pre-qualified
    Farm
    Built in 2005
    18.13 Acres Lot
    $-- Zestimate®
    $180/sqft
    $-- HOA

    What's special

    Private settingPrivate officeLarge patioSeparate accommodations for in-lawsBeautiful hardwood flooring
    This exceptional 18-acre horse farm features a spacious estate exceeding 9,700 square feet of finished living space, complete with separate accommodations for in-laws. Nestled in a private setting, the property includes fenced pastures with a run-in shed, a 140’ x 70’ barn housing a 120’ x 70’ indoor riding arena and ten horse stalls, as well as a 60’ x 40’ shop and a 27’ x 32’ woodshop to support agricultural activities. The outdoor space boasts a large patio, an in-ground swimming pool with a pool house and gazebo area, and offers stunning views of lush greenery alongside a creek. This well-equipped property not only facilitates daily farm operations but also provides a move-in ready home with ample family space and luxurious features. The main level showcases beautiful hardwood flooring, a private office, and a great room with a cathedral ceiling, while the gourmet kitchen is equipped with a double oven, granite countertops, a breakfast area, and a center island. The upper level includes a master suite featuring herringbone hardwood flooring, a walk-in closet, and a luxurious bath designed for a spa-like experience, complete with a jetted tub and a dual-sided walk-in shower. The fully finished lower level offers a recreation room with a wet bar and pool table, a movie room, four additional bedrooms, and a full bath, creating a complete separate living area. An attached three-car garage connects the main residence to the in-law quarters, which includes a full kitchen, living and dining areas, two bedrooms, a walk-in closet with laundry hookups, and a handicap-accessible full bath, making this property a comprehensive and desirable estate.
    139 days
    |
    1,065
    |
    58
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Adam Flinchbaugh 717-288-7766,

    Keller Williams Keystone Realty 7177555599

    Source: Bright MLS,MLS#: PAYK2097706MLS Logo

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 11
      • Bathrooms: 5
      • Full bathrooms: 4
      • 1/2 bathrooms: 1
      • Main level bathrooms: 2
      • Main level bedrooms: 2
      Rooms
      • Room types: Living Room, Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Kitchen, Foyer, Breakfast Room, Bedroom 1, Great Room, Laundry, Office, Recreation Room, Utility Room, Media Room, Bonus Room, Primary Bathroom, Full Bath, Half Bath, Additional Bedroom
      Primary bedroom
      • Features: Attached Bathroom, Cathedral/Vaulted Ceiling, Ceiling Fan(s), Flooring - HardWood, Crown Molding, Primary Bedroom - Sitting Area, Walk-In Closet(s)
      • Level: Upper
      • Area: 520 Square Feet
      • Dimensions: 20 X 26
      Primary bedroom
      • Features: Ceiling Fan(s), Flooring - Carpet, Recessed Lighting, Walk-In Closet(s)
      • Level: Main
      • Area: 224 Square Feet
      • Dimensions: 14 X 16
      Other
      • Features: Ceiling Fan(s), Flooring - Carpet
      • Level: Main
      • Area: 156 Square Feet
      • Dimensions: 12 X 13
      Bedroom 1
      • Features: Ceiling Fan(s), Flooring - Carpet
      • Level: Lower
      • Area: 187 Square Feet
      • Dimensions: 17 X 11
      Bedroom 2
      • Features: Ceiling Fan(s), Flooring - Carpet, Recessed Lighting
      • Level: Upper
      • Area: 840 Square Feet
      • Dimensions: 21 X 40
      Bedroom 2
      • Features: Ceiling Fan(s), Flooring - Carpet
      • Level: Lower
      • Area: 216 Square Feet
      • Dimensions: 12 X 18
      Bedroom 3
      • Features: Attic - Access Panel, Flooring - HardWood, Ceiling Fan(s), Walk-In Closet(s)
      • Level: Upper
      • Area: 195 Square Feet
      • Dimensions: 13 X 15
      Bedroom 3
      • Features: Ceiling Fan(s), Flooring - Carpet
      • Level: Lower
      • Area: 165 Square Feet
      • Dimensions: 11 X 15
      Bedroom 4
      • Features: Ceiling Fan(s), Flooring - HardWood
      • Level: Upper
      • Area: 176 Square Feet
      • Dimensions: 11 X 16
      Bedroom 4
      • Features: Ceiling Fan(s), Flooring - Carpet
      • Level: Lower
      • Area: 140 Square Feet
      • Dimensions: 10 X 14
      Bedroom 5
      • Features: Ceiling Fan(s), Flooring - HardWood
      • Level: Upper
      • Area: 156 Square Feet
      • Dimensions: 13 X 12
      Primary bathroom
      • Features: Flooring - Ceramic Tile, Soaking Tub
      • Level: Upper
      • Area: 228 Square Feet
      • Dimensions: 12 X 19
      Bonus room
      • Features: Flooring - HardWood, Recessed Lighting
      • Level: Main
      • Area: 418 Square Feet
      • Dimensions: 19 X 22
      Breakfast room
      • Features: Balcony Access, Flooring - Ceramic Tile
      • Level: Main
      • Area: 190 Square Feet
      • Dimensions: 10 X 19
      Dining room
      • Features: Balcony Access, Chair Rail, Crown Molding, Flooring - HardWood
      • Level: Main
      • Area: 221 Square Feet
      • Dimensions: 13 X 17
      Foyer
      • Features: Flooring - HardWood, Crown Molding
      • Level: Main
      Other
      • Features: Flooring - Ceramic Tile, Bathroom - Tub Shower
      • Level: Upper
      • Area: 50 Square Feet
      • Dimensions: 5 X 10
      Other
      • Features: Flooring - Ceramic Tile
      • Level: Lower
      • Area: 30 Square Feet
      • Dimensions: 6 X 5
      Other
      • Features: Flooring - Luxury Vinyl Plank
      • Level: Main
      • Area: 70 Square Feet
      • Dimensions: 10 X 7
      Great room
      • Features: Cathedral/Vaulted Ceiling, Ceiling Fan(s), Fireplace - Gas, Flooring - HardWood, Recessed Lighting
      • Level: Main
      • Area: 400 Square Feet
      • Dimensions: 20 X 20
      Half bath
      • Features: Flooring - HardWood
      • Level: Main
      • Area: 60 Square Feet
      • Dimensions: 6 X 10
      Kitchen
      • Features: Breakfast Bar, Breakfast Nook, Granite Counters, Dining Area, Double Sink, Flooring - HardWood, Kitchen Island, Eat-in Kitchen, Kitchen - Gas Cooking, Lighting - Pendants, Recessed Lighting, Pantry
      • Level: Main
      • Area: 266 Square Feet
      • Dimensions: 14 X 19
      Kitchen
      • Features: Flooring - Luxury Vinyl Plank, Pantry, Kitchen - Electric Cooking
      • Level: Main
      • Area: 104 Square Feet
      • Dimensions: 8 X 13
      Laundry
      • Features: Flooring - Ceramic Tile
      • Level: Main
      • Area: 120 Square Feet
      • Dimensions: 8 X 15
      Living room
      • Features: Crown Molding, Flooring - HardWood
      • Level: Main
      • Area: 182 Square Feet
      • Dimensions: 13 X 14
      Living room
      • Features: Flooring - Luxury Vinyl Plank, Fireplace - Gas, Cathedral/Vaulted Ceiling, Ceiling Fan(s), Dining Area
      • Level: Main
      • Area: 432 Square Feet
      • Dimensions: 16 X 27
      Media room
      • Features: Flooring - Carpet
      • Level: Lower
      • Area: 209 Square Feet
      • Dimensions: 11 X 19
      Mud room
      • Features: Flooring - Ceramic Tile, Recessed Lighting
      • Level: Main
      • Area: 323 Square Feet
      • Dimensions: 17 X 19
      Office
      • Features: Flooring - HardWood, Recessed Lighting
      • Level: Main
      • Area: 170 Square Feet
      • Dimensions: 10 X 17
      Recreation room
      • Features: Flooring - HardWood, Fireplace - Gas, Recessed Lighting, Wet Bar
      • Level: Lower
      • Area: 384 Square Feet
      • Dimensions: 16 X 24
      Utility room
      • Level: Lower
      • Area: 100 Square Feet
      • Dimensions: 10 X 10
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Central Air, Electric
      Appliances
      • Included: Gas Water Heater
      • Laundry: Laundry Room, Mud Room
      Features
      • 2nd Kitchen, Additional Stairway, Attic, Bar, Breakfast Area, Ceiling Fan(s), Central Vacuum, Chair Railings, Crown Molding, Dining Area, Double/Dual Staircase, Entry Level Bedroom, Family Room Off Kitchen, Open Floorplan, Formal/Separate Dining Room, Eat-in Kitchen, Kitchen Island, Kitchen - Table Space, Pantry, Primary Bath(s), Recessed Lighting, Soaking Tub, Sound System, Bathroom - Stall Shower, Store/Office, Bathroom - Tub Shower, Upgraded Countertops, Walk-In Closet(s), 9'+ Ceilings
      • Flooring: Carpet, Ceramic Tile, Hardwood, Wood
      • Basement: Full,Finished
      • Number of fireplaces: 3
      • Fireplace features: Gas/Propane
      Interior area
      • Total structure area: 9,748
      • Total interior livable area: 9,748 sqft
      • Finished area above ground: 7,948
      • Finished area below ground: 1,800
      Video & virtual tour

      Property

      Parking
      • Total spaces: 3
      • Parking features: Covered, Garage Faces Front, Garage Door Opener, Inside Entrance, Oversized, Attached
      • Attached garage spaces: 3
      Accessibility
      • Accessibility features: None
      Features
      • Levels: Two
      • Stories: 2
      • Patio & porch: Deck, Patio
      • Exterior features: Bump-outs, Extensive Hardscape, Lighting, Balcony
      • Has private pool: Yes
      • Pool features: In Ground, Private
      • Has view: Yes
      • View description: Pasture
      Lot
      • Size: 18.13 Acres
      • Features: Stream/Creek
      Details
      • Additional structures: Above Grade, Below Grade, Outbuilding, Shed(s)
      • Parcel number: 32000BL0010N000000
      • Zoning: AG
      • Special conditions: Standard
      • Horses can be raised: Yes

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial
      • Property subtype: Farm
      Materials
      • Vinyl Siding
      • Foundation: Block
      • Roof: Architectural Shingle
      Condition
      • New construction: No
      • Year built: 2005

      Utilities & green energy

      • Sewer: On Site Septic
      • Water: Well

      Community & HOA

      Community
      • Subdivision: Hopewell Twp
      HOA
      • Has HOA: No
      Location
      • Region: Stewartstown
      • Municipality: HOPEWELL TWP

      Financial & listing details

      • Price per square foot: $180/sqft
      • Tax assessed value: $883,759
      • Annual tax amount: $21,765
      • Date on market: 2/13/2026
      • Listing agreement: Exclusive Right To Sell
      • Listing terms: Cash,Conventional
      • Ownership: Fee Simple

        Estimated market value

        Not available

        Estimated sales range

        Not available

        $3,400/mo

        Price history

        DateEventPrice
        2/13/2026Listed for sale$1,759,000$180/sqft
        Source: Bright MLS #PAYK2097706 Report a problem
        1/8/2026Listing removed$1,759,000$180/sqft
        Source: Bright MLS #PAYK2085094 Report a problem
        6/30/2025Listed for sale$1,759,000-5.4%$180/sqft
        Source: Bright MLS #PAYK2085094 Report a problem
        6/30/2025Listing removed$1,859,000$191/sqft
        Source: Bright MLS #PAYK2075040 Report a problem
        1/27/2025Listed for sale$1,859,000-4.7%$191/sqft
        Source: Bright MLS #PAYK2075034 Report a problem
        1/26/2025Listing removed$1,950,000$200/sqft
        Source: Bright MLS #PAYK2066238 Report a problem
        8/3/2024Listed for sale$1,950,000+609.1%$200/sqft
        Source: Bright MLS #PAYK2065868 Report a problem
        12/27/2004Sold$275,000$28/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$21,883 $745,340
        2024$21,883 $745,340
        2023$21,883 +3.5%$745,340
        2022$21,138 $745,340
        2021$21,138 $745,340
        2020$21,138 +0.4%$745,340
        2019$21,064 $745,340
        2018$21,064 +426.3%$745,340
        2017$4,002 $745,340
        2016-- $745,340 +0.1%
        2015-- $744,310

        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        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.

        Climate risks

        Neighborhood: 17363

        Getting around

        0 / 100
        Car-Dependent
        10 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • High: Kennard-dale
        • District: South Eastern

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

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts