Skip main navigation
For sale
  • $775,000

    123 Harkins Mill Rd, Rochester, PA 15074

    3beds
    3,105sqft
    : 
    Single Family Residence
    Built in 2005
    2 Acres Lot
    $749,400 Zestimate®
    $250/sqft
    $-- HOA

    What's special

    Additional detached one-car garageFinished walkout lower levelOversized three-car attached garageThoughtful craftsmanship throughoutMain-level primary suiteGenerous walk-in pantryDual ovens
    This beautifully crafted custom Colonial is nestled on 2 peaceful acres in New Sewickley Township—where space, comfort, and everyday moments come together effortlessly. Step inside to a warm and inviting entry highlighted by gleaming hardwood floors and thoughtful craftsmanship throughout. The stunning two-story great room quickly becomes the heart of the home, filled with natural light from soaring windows that frame picturesque views of the surrounding landscape—perfect for cozy evenings or gathering with family and friends. The main-level primary suite offers a private retreat at the end of the day, featuring a vaulted ceiling, spacious his-and-her closets, and a relaxing spa-like bath designed for unwinding. The chef’s kitchen blends style and function with granite countertops, stainless steel appliances, dual ovens, and a generous walk-in pantry—perfect for everything from weeknight dinners to holiday gatherings. Just off the kitchen, a covered porch creates the perfect spot to enjoy morning coffee, dine outdoors, or unwind while taking in the peaceful views of your surrounding acreage. Upstairs, two generously sized bedrooms and a full bath provide comfortable space for family or guests, while the expansive 27x23 storage room offers exciting potential to create additional living space, a studio, or a playroom. The finished walkout lower level adds incredible versatility, complete with a full kitchen, entertaining area, gym space, and ample storage—ideal for hosting, relaxing, or multi-generational living.Outside, the beauty of the two-acre setting provides privacy and room to breathe. An oversized three-car attached garage plus an additional detached one-car garage offers plenty of space for vehicles, hobbies, and storage.A home like this isn’t just a place to live—it’s a place to truly enjoy life.
    18 days
    |
    3,580
    |
    143
    |

    Zillow last checked: 7 hours ago

    Listing updated: March 22, 2026 at 11:03am

    Listed by:

    Christine Wilson 724-318-6681,

    COMPASS PENNSYLVANIA, LLC 724-318-6681

    Source: WPMLS,MLS#: 1743422MLS LogoOriginating MLS: West Penn Multi-List

    Tour with a local agent

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 4
      • Full bathrooms: 3
      • 1/2 bathrooms: 1
      Primary bedroom
      • Level: Main
      • Dimensions: 17x13
      Bedroom 2
      • Level: Upper
      • Dimensions: 17x13
      Bedroom 3
      • Level: Upper
      • Dimensions: 14x13
      Bonus room
      • Level: Upper
      • Dimensions: 27x23
      Bonus room
      • Level: Lower
      • Dimensions: 23x18
      Dining room
      • Level: Main
      • Dimensions: 14x14
      Entry foyer
      • Level: Main
      • Dimensions: 14x10
      Family room
      • Level: Lower
      • Dimensions: 22x19
      Game room
      • Level: Lower
      • Dimensions: 50x29
      Kitchen
      • Level: Main
      • Dimensions: 17x16
      Kitchen
      • Level: Lower
      • Dimensions: 20x14
      Laundry
      • Level: Main
      • Dimensions: 11x8
      Living room
      • Level: Main
      • Dimensions: 21x17
      Heating
      • Forced Air, Gas
      Cooling
      • Central Air, Electric
      Appliances
      • Included: Some Gas Appliances, Convection Oven, Dishwasher, Disposal, Microwave, Stove
      Features
      • Kitchen Island, Pantry
      • Flooring: Ceramic Tile, Hardwood, Carpet
      • Windows: Multi Pane, Screens
      • Basement: Full,Finished,Walk-Out Access
      Interior area
      • Total structure area: 3,105
      • Total interior livable area: 3,105 sqft

      Property

      Parking
      • Total spaces: 4
      • Parking features: Attached, Detached, Garage, Garage Door Opener
      • Has attached garage: Yes
      Features
      • Levels: Two
      • Stories: 2
      • Pool features: None
      Lot
      • Size: 2 Acres
      • Dimensions: 2
      Details
      • Parcel number: 691450211P00

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial,Two Story
      • Property subtype: Single Family Residence
      Materials
      • Brick, Vinyl Siding
      • Roof: Asphalt
      Condition
      • Resale
      • Year built: 2005

      Utilities & green energy

      • Sewer: Septic Tank
      • Water: Well

      Community & HOA

      Location
      • Region: Rochester

      Financial & listing details

      • Price per square foot: $250/sqft
      • Tax assessed value: $930,800
      • Annual tax amount: $7,332
      • Date on market: 3/13/2026
      Get pre-qualifiedBe ready to make an offer.
      Connect with an agentGet info on this home, tour, and more.
      Calculate monthly paymentSee if you can afford this home.

        Estimated market value

        $749,400

        $712,000 - $787,000

        $3,145/mo

        Price history

        Price history
        DateEventPrice
        3/13/2026Listed for sale$775,000+92.4%$250/sqft
        Source: WPMLS #1743422 Report a problem
        9/13/2021Sold$402,806$130/sqft
        Source: Public Record Report a problem
        1/5/2021Listing removed--
        Source: Howard Hanna Report a problem

        Public tax history

        Public tax history
        YearProperty taxesTax assessment
        2025$743 +1.9%$48,230
        2024$729 $48,230
        2023-- --
        2022-- --
        2021-- --
        2020$4,887 --
        2019$4,887 +287.7%--
        2018$1,260 +17.1%$48,480
        2017$1,076 $48,480
        2016$1,076 $48,480
        2015$1,076 $48,480
        2014$1,076 $48,480
        2013-- $48,480
        2012-- $48,480
        2011-- $48,480
        2010-- $48,480
        2008-- $48,480
        2007-- $48,480
        2006-- $48,480

        Find assessor info on the county website

        BuyAbility℠ payment

        Est. payment
        $4,887/mo
        Principal & interest
        $3963
        Property taxes
        $924
        More affordability tools

          Climate risks

          Neighborhood: 15074

          Getting around

          1 / 100
          Car-Dependent

          Nearby schools

          GreatSchools rating
          Schools provided by the listing agent
          • District: Freedom Area

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

          Local experts in 15074

          Similar homes

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