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.
For sale
$775,000
123 Harkins Mill Rd, Rochester, PA 15074
3beds
3,105sqft
Est.:
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
- 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#: 1743422
Originating 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
Video & virtual tour
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
Estimated market value
$747,700
$710,000 - $785,000
$1,866/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 3/13/2026 | Listed for sale | $775,000+92.4%$250/sqft |
Source: | ||
| 9/13/2021 | Sold | $402,806$130/sqft |
Source: Public Record Report a problem | ||
| 1/5/2021 | Listing removed | -- |
Source: Howard Hanna Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax 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-DependentNearby schools
GreatSchools rating
- 4/10Freedom Area Middle SchoolGrades: 5-8Distance: 4.9 mi
- 5/10Freedom Area Senior High SchoolGrades: 9-12Distance: 4.7 mi
- 6/10Freedom Area Elementary SchoolGrades: K-4Distance: 4.9 mi
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.



