First time on the market! Experience the perfect blend of elegance and comfort in this stunning custom-built Colonial, gracefully set on 2 lush acres in New Sewickley Township. From the moment you step inside, impeccable craftsmanship shines through with gleaming hardwood floors and a welcoming, light-filled entry. The impressive two-story great room is framed by expansive windows that flood the space with natural light and showcase breathtaking views of the surrounding landscape. The main-level primary suite is a true retreat, featuring a vaulted ceiling, his-and-her closets, and a spa-inspired full bath designed for relaxation. The chef’s kitchen offers both style and functionality with granite countertops, stainless steel appliances, a spacious walk-in pantry, and abundant storage—perfect for everyday living and entertaining alike. Upstairs, you’ll find two generously sized bedrooms, a full bath, and an expansive 27x23 storage room with endless potential to be finished into additional living space. The finished walkout lower level is a standout, complete with a full kitchen, entertaining area, gym space, and ample storage—ideal for guests or extended living. Car enthusiasts will appreciate the oversized three-car attached garage, plus an additional detached one-car garage. This pristine property offers luxury living in a serene, private setting—truly a rare and remarkable opportunity.
For sale
Price cut: $8K (1/23)
$787,000
123 Harkins Mill Rd, Rochester, PA 15074
3beds
3,105sqft
Est.:
Single Family Residence
Built in 2005
2 Acres Lot
$759,800 Zestimate®
$253/sqft
$-- HOA
What's special
Additional detached one-car garageFinished walkout lower levelOversized three-car attached garageMain-level primary suiteSerene private settingSpacious walk-in pantryAbundant storage
- 137 days |
- 2,802 |
- 109 |
Zillow last checked: 8 hours ago
Listing updated: January 29, 2026 at 07:23pm
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: $253/sqft
- Tax assessed value: $930,800
- Annual tax amount: $6,897
- Date on market: 9/24/2025
Estimated market value
$759,800
$722,000 - $798,000
$2,644/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 1/23/2026 | Price change | $787,000-1%$253/sqft |
Source:  WPMLS #1722162 Report a problem | ||
| 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 | ||
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,972/mo
Principal & interest
$3759
Property taxes
$938
Home insurance
$275
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
