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
    $747,700 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.
    7 hours
    |
    306
    |
    12
    |

    Zillow last checked: 7 hours ago

    Listing updated: 14 hours ago

    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

    $747,700

    $710,000 - $785,000

    $1,866/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
    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,621/mo
    Principal & interest
    $3697
    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