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.
Contingent
$775,000
123 Harkins Mill Rd, Rochester, PA 15074
3beds
3,105sqft
Est.:
Single Family Residence
Built in 2005
2 Acres Lot
$744,300 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
- 67 days |
- 471 |
- 9 |
Zillow last checked:
Listing updated:
Listed by:
Christine Wilson 724-318-6681,
COMPASS PENNSYLVANIA, LLC 724-318-6681
Source: WPMLS,MLS#: 1743422
Originating MLS: West Penn Multi-List
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
$744,300
$707,000 - $782,000
$2,465/mo
Price history
| Date | Event | Price |
|---|---|---|
| 4/16/2026 | Contingent | $775,000$250/sqft |
Source: | ||
| 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
| Year | Property taxes | Tax 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
Monthly payment
Est. payment$--/mo
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: 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.
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.
- Pennsylvania
- Beaver County
- Rochester
- 15074
- 123 Harkins Mill Rd



