First time on the market! Discover the perfect blend of elegance & comfort in this exquisite custom Colonial,nestled on 2 lush acres in New Sewickley Twp.This thoughtfully designed home showcases impeccable craftsmanship w/gleaming hardwood floors that greet upon entry. The welcoming 2-story great room features an abundance of large,bright windows to frame your amazing views.Main level primary suite w/vaulted ceiling,his & her closets,spa-like full bath provides a perfect retreat.Chef's kitchen has spacious layout w/granite counters,SS appliances,abundant walk-in pantry &all the storage you'll need w/style & efficiency.Upstairs find full bath,2 large BR's & 27x23 storage room that could be finished.Finished walkout LL is true highlight w/full kitchen,entertaining area,gym space &storage room. Car enthusiasts will love the oversized 3-car attached garage PLUS a detached one-car garage.This property is a unique opportunity to enjoy luxury living w/tranquil setting.This is a Pristine gem!
For sale
Price increase: $500 (12/5)
$795,000
123 Harkins Mill Rd, Rochester, PA 15074
3beds
3,105sqft
Est.:
Single Family Residence
Built in 2005
2 Acres Lot
$758,700 Zestimate®
$256/sqft
$-- HOA
What's special
Lush acresDetached one-car garageEntertaining areaFinished walkout llFull kitchenImpeccable craftsmanshipPrimary suite
- 91 days |
- 1,483 |
- 76 |
Zillow last checked: 9 hours ago
Listing updated: December 21, 2025 at 12:52pm
Listed by:
Christine Wilson 724-318-6681,
COMPASS PENNSYLVANIA, LLC 724-318-6681
Source: WPMLS,MLS#: 1722162
Originating MLS: West Penn Multi-List
Originating MLS: West Penn Multi-ListTour 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: 22x19
Dining room
- Level: Main
- Dimensions: 14x14
Entry foyer
- Level: Main
- Dimensions: 14x10
Game room
- Level: Lower
- Dimensions: 23x18
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, Microwave, Refrigerator, Stove
Features
- Kitchen Island, Pantry
- Flooring: Hardwood, Other, 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: 87120SF
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: $256/sqft
- Tax assessed value: $930,800
- Annual tax amount: $6,897
- Date on market: 9/24/2025
Estimated market value
$758,700
$721,000 - $797,000
$1,733/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 12/5/2025 | Price change | $795,000+0.1%$256/sqft |
Source:  WPMLS #1722162 Report a problem | ||
| 11/28/2025 | Price change | $794,500-0.1%$256/sqft |
Source: WPMLS #1722162 Report a problem | ||
| 9/24/2025 | Listed for sale | $795,000+97.4%$256/sqft |
Source: WPMLS #1722162 Report a problem | ||
| 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 |
|---|---|---|
| 2023 | -- | -- |
| 2022 | -- | -- |
| 2021 | -- | -- |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$4,993/mo
Principal & interest
$3821
Property taxes
$894
Home insurance
$278
Climate risks
Neighborhood: 15074
Nearby 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.
- Loading
- Loading
