Welcome to Ripple Run, an exquisitely restored historic property that embodies the concept of retreat and multipurpose paradise. This property is a haven for those seeking a private sanctuary, entrepreneurs and nature lovers alike. The main house is a custom-built 5000 sq ft 4 bedroom 3.5 bath masterpiece completed in 2023. The open floor plan seamlessly connects indoor and outdoor spaces, with a state-of-the-art chef’s kitchen, double sided fireplace and wrap around porch. Outside, the landscape is made up of a harmonious blend of creekside serenity and wooded exploration areas. Separate from the main house and detached 3-car garage, a multi-use pole building and meticulously renovated early 1900’s bank barn, each with utilities, offer an array of potential uses.
Single-familyProperty Type
2023Year Built
28 acresLot Size
$427Est. Price/Sq.Ft.
1 car garageParking
Listed by • KELLER WILLIAMS REALTY
Bought with Marianne Hall• HOWARD HANNA REAL ESTATE SERVICES
Welcome to Ripple Run, an exquisitely restored historic property that embodies the concept of retreat and multipurpose paradise. This property is a haven for those seeking a private sanctuary, entrepreneurs and nature lovers alike. The main house is a custom-built 5000 sq ft 4 bedroom 3.5 bath masterpiece completed in 2023. The open floor plan seamlessly connects indoor and outdoor spaces, with a state-of-the-art chef’s kitchen, double sided fireplace and wrap around porch. Outside, the landscape is made up of a harmonious blend of creekside serenity and wooded exploration areas. Separate from the main house and detached 3-car garage, a multi-use pole building and meticulously renovated early 1900’s bank barn, each with utilities, offer an array of potential uses. Seller financing available.
West Penn MLS #1610195
Jul 18, 2023
Price Changed
$2,950,000
$590/sq ft
Jul 12, 2023
Price Changed
$3,100,000
$620/sq ft
Jun 26, 2023
Price Changed
$3,250,000
$650/sq ft
Jun 13, 2023
Listed
$3,450,000
$690/sq ft
West Penn MLS #1595484
Jul 18, 2023
Price Changed
$2,950,000
$590/sq ft
Jul 12, 2023
Price Changed
$3,100,000
$620/sq ft
Jun 19, 2023
Price Changed
$3,250,000
$650/sq ft
Jun 2, 2023
Price Changed
$3,450,000
$690/sq ft
May 27, 2023
Price Changed
$3,500,000
$700/sq ft
May 10, 2023
Price Changed
$3,600,000
$720/sq ft
Mar 9, 2023
Listed
$4,250,000
$850/sq ft
+45
Ripple Run Farm, a stunningly renovated & restored heritage farmstead on 28-acres of prime land. This one-of-a-kind farmhouse has been transformed and renovated w/ careful craftsmanship, woodworking & high-end finishes. The property also includes a new 3-car garage, Bank Barn, guest house w/ garage & an upper pole barn w/ water, electric & gas-perfect for stable/dog kennel. Enter through the bespoke black iron gate w/ an active creek, fields to the left & incredible mature hardwoods to the right. The main home boasts hand burnt wood porch posts, handsome stonework & a 100' wrap around porch. Interiorly you'll love the hickory floors, 22-ft ceilings in the great room & double-sided stone fireplace. A state-of-the-art chef's kitchen & auxiliary kitchen boast cabinetry handmade on site & top-of-the-line appliances, including a La Cornue stove. Upstairs is the magnificent primary bedroom suite to one side w/ 3 auxiliary bedrooms & laundry to the other. A 3rd flr offers a beamed open bonus space
Public Records
Jan 4, 2022
Sold
$322,500
$65/sq ft
West Penn MLS #815640
Mar 23, 2010
Listed
$324,900
$65/sq ft
Public Records
Aug 9, 2001
Sold
$345,500
$69/sq ft
Public Records
May 22, 1996
Sold
$202,520
$41/sq ft
Year
Property tax
Land + Additions
Assessment*
2026
$4,369 (+3.6%)
$118,800 + $33,100
$151,900
2025
$4,217 (−30.9%)
$118,800 + $33,100
$151,900
2024
$6,103
$118,800 + $118,100
$236,900
2023
$6,103 (+2.4%)
$118,800 + $118,100
$236,900
2022
$5,961
$118,800 + $118,100
$236,900
2021
$5,961
$118,800 + $118,100
$236,900
2020
$5,961 (+2.8%)
$118,800 + $118,100
$236,900
2019
$5,798 (+1.9%)
$118,800 + $118,100
$236,900
2018
$5,691
$118,800 + $118,100
$236,900
2017
$5,690 (+3.5%)
$118,800 + $118,100
$236,900
2015
$5,498
$118,800 + $118,100
$236,900
Tax history for 2457 Rochester Rd
Year
Property tax
Land + Additions
Assessment*
2026
$4,369 (+3.6%)
$118,800 + $33,100
$151,900
2025
$4,217 (−30.9%)
$118,800 + $33,100
$151,900
2024
$6,103
$118,800 + $118,100
$236,900
2023
$6,103 (+2.4%)
$118,800 + $118,100
$236,900
2022
$5,961
$118,800 + $118,100
$236,900
2021
$5,961
$118,800 + $118,100
$236,900
2020
$5,961 (+2.8%)
$118,800 + $118,100
$236,900
2019
$5,798 (+1.9%)
$118,800 + $118,100
$236,900
2018
$5,691
$118,800 + $118,100
$236,900
2017
$5,690 (+3.5%)
$118,800 + $118,100
$236,900
2015
$5,498
$118,800 + $118,100
$236,900
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
7.1 Acres
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Other
County
Allegheny County
APN
1066D00106000000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 20, 2026.
Property details
Parking
Garage/Carport Information
Has Garage
Parking
Features: Common, Detached, Garage, Garage Door Opener
Interior
Virtual Tour
Bathroom Information
# of Full Bathrooms: 3
# of Half Bathrooms: 1
Room Information
Has Basement
Basement Information: Walk-Up Access
Fireplace Information
Has Fireplace
# of Fireplaces: 3
Features: Gas, Wood Burning
Equipment
Appliances: Some Gas Appliances, Convection Oven, Dishwasher, Disposal, Microwave, Refrigerator, Stove, Trash Compactor
Interior Features
Window Features: Multi Pane
Flooring: Ceramic Tile, Hardwood
Other Features: Kitchen Island, Pantry
Exterior
Building Information
Stories: 3
New Construction
Roof Details: Asphalt
Construction Details: Frame, Stone
Lot Information
Lot Size Area: 28
Lot Size Acres: 28
Lot Size Dimensions: 28
Waterfront Features: Water Access
Property Information
New Construction
Financial
Assessments and Fees
Assessed Value: $410,900
Tax Information
Annual Tax Amount: $10,427
Utilities
Utility Information
Sewer: Septic Tank
Water Source: Well
Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Forced Air, Gas
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: 7.1 acres
Style: Other
Year Built: —
Year Renovated: —
County: Allegheny County
APN: 1066D00106000000
Home facts updated by county records on Oct 20, 2026
Around this home
Schools
K - 12
Preschool & daycare
Franklin El School
Public K-5 • Assigned • 1.3mi
10/10
Ingomar Middle School
Public 6-8 • Assigned • 2.6mi
8/10
North Allegheny Senior High School
Public 9-12 • Assigned • 3.4mi
10/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
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 97° 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
Sewickley, PA • 15143
Average low and high temperatures (°F)
30
16
38
23
57
36
66
46
68
50
81
62
84
66
81
59
78
54
64
43
51
36
40
26
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
Try the sun simulator tool to see how light moves across the property at different times of day and year.
Provided by Shadowmap
Estimated sale price
$2.03M – $2.46M
Reach more buyers when you sell with Redfin. Save up to $21,369 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.