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.
Single-familyProperty Type
2005Year Built
2 acresLot Size
$243Price/Sq.Ft.
4 spacesParking
Listed by • COMPASS PENNSYLVANIA, LLC
Bought with Pierre Khoury• BERKSHIRE HATHAWAY THE PREFERRED REALTY
Est. $3,140 per month, based on comparable rentals
Sale and tax history for 123 Harkins Mill Rd
Sale History
Tax History
Date
Event
Price
Public Records
Jun 8, 2026
Sold
$755,000
$243/sq ft
West Penn MLS #1743422
May 29, 2026
Pending
—
May 29, 2026
Sold
$755,000
$243/sq ft
Apr 16, 2026
Contingent
—
Mar 12, 2026
Listed
$775,000
$250/sq ft
West Penn MLS #1722162
Mar 11, 2026
Relisted
—
Mar 2, 2026
Contingent
—
Mar 2, 2026
Price Changed
$775,000
$250/sq ft
Jan 23, 2026
Price Changed
$787,000
$253/sq ft
Dec 5, 2025
Price Changed
$795,000
$256/sq ft
Nov 28, 2025
Price Changed
$794,500
$256/sq ft
Sep 24, 2025
Listed
$795,000
$256/sq ft
+45
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, dual ovens, all 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.
Year
Property tax
Land + Additions
Assessment*
2026
$7,332 (+6.3%)
$56,400 + $409,000
$465,400
2025
$6,897 (−2.0%)
$56,400 + $409,000
$465,400
2024
$7,037 (+8.9%)
$56,400 + $409,000
$465,400
2023
$6,464 (+1.4%)
$56,400 + $409,000
$465,400
2022
$6,376 (+2.5%)
$8,000 + $50,550
$58,550
2021
$6,218 (+8.0%)
$8,000 + $50,550
$58,550
2020
$5,756 (+2.4%)
$8,000 + $49,100
$57,100
2019
$5,619 (+3.0%)
$8,000 + $49,100
$57,100
2018
$5,453
$8,000 + $49,100
$57,100
2017
$5,453 (+8.4%)
$8,000 + $49,100
$57,100
2016
$5,030 (+6.1%)
$8,000 + $49,100
$57,100
2015
$4,739 (+6.8%)
$8,000 + $49,100
$57,100
2014
$4,436
$8,000 + $49,100
$57,100
Public record
Beds
3
Baths
2.5
Stories
2
Lot width
—
Lot depth
—
Lot size
2 Acres
Year renovated
—
Sq. Ft.
2,586
Year built
2005
Style
Single Family Residential
County
Beaver County
APN
691450211006
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 9, 2026.
Property details
Parking
Garage/Carport Information
Has Garage
Has Attached Garage
Parking
Features: Attached, Detached, Garage, Garage Door Opener
Appliances: Some Gas Appliances, Convection Oven, Dishwasher, Disposal, Microwave, Stove
Interior Features
Window Features: Multi Pane, Screen(s)
Flooring: Ceramic Tile, Hardwood, Carpet
Other Features: Kitchen Island, Pantry
Exterior
Building Information
Stories: 2
Roof Details: Asphalt
Construction Details: Brick, Vinyl Siding
Lot Information
Lot Size Area: 2
Lot Size Acres: 2
Lot Size Dimensions: 2
Property Information
Resale
Financial
Assessments and Fees
Assessed Value: $930,800
Tax Information
Annual Tax Amount: $7,332
Utilities
Utility Information
Sewer: Septic Tank
Water Source: Well
Heating & Cooling
Has Cooling
Cooling: Central Air, Electric
Has Heating
Heating: Forced Air, Gas
Public facts
Beds: 3
Baths: 2.5
Sq. Ft.: 2,586
Stories: 2.0
Lot Size: 2 acres
Style: Single Family Residential
Year Built: 2005
Year Renovated: —
County: Beaver County
APN: 691450211006
Home facts updated by county records on Sep 9, 2026
Around this home
Schools
Freedom Area Elementary School
Public K-4 • Assigned • 4.9mi
4/10
Freedom Area Middle School
Public 5-8 • Assigned • 4.9mi
5/10
Freedom Area Senior High School
Public 9-12 • Assigned • 4.8mi
5/10
Provided by GreatSchools
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
3/10 Heat Factor
7 days above 96° expected this year, 17 days in 30 years
2/10 Wind Factor
Minor risk of severe winds over next 30 years
3/10 Air Factor
2 unhealthy days expected this year, 4 days in 30 years
Provided by First Street
Historical weather
Rochester, PA • 15074
Average low and high temperatures (°F)
31
17
39
23
58
36
67
46
69
51
82
62
85
67
82
59
78
57
66
44
52
37
41
26
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
90/ 100
Exceptional sunlight
Sunscore
This home ranks in the top 25% for direct sun exposure in Rochester. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
9.8 hrs
6.1 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$700,000 – $847,000
Reach more buyers when you sell with Redfin. Plus, you'll save $7,364 in fees.