Welcome to this stunning like-new custom-built home in the desirable Brookside Farms neighborhood of Upper St. Clair. Sitting on just under an acre of private land, this home offers the perfect blend of modern luxury and timeless charm. Step onto the sprawling covered front porch, ideal for relaxing and enjoying the peaceful surroundings. A private driveway leads to this beautifully redesigned home featuring an open-concept layout, gorgeous hardwood floors, and a chef’s dream kitchen with brand-new cabinets, countertops, and appliances. The first-floor owner’s suite is a true retreat, while the second floor boasts three additional oversized bedrooms and a luxurious spa-like bath complete with a rainforest shower and soaking tub. The finished game room offers versatility—it can be a fifth bedroom, in-law suite, or entertainment space. No detail has been overlooked in this complete top-to-bottom renovation. Don’t miss your chance to own this one-of-a-kind masterpiece in Upper St. Clair!
Single-familyProperty Type
1920Year Built
0.76 acresLot Size
$231Est. Price/Sq.Ft.
4 spacesParking
Listed by • EXP REALTY LLC
Bought with April Bartley• HOWARD HANNA REAL ESTATE SERVICES
Stunning Farmhouse on 3/4 acre in Beautiful Brookside Farms! Impeccably restored 4 bedroom 3.5 baths including first floor master ensuite with his/hers closets, fireplace, balcony, cathedral ceilings, luxurious bathroom with soaking tub, double sinks and spacious shower. The three bedrooms upstairs are all large along with laundry and a designer bathroom that won't disappoint! The open concept kitchen and dining room has refinished original hardwood floors, light maple cabinets, quartzite countertops, designer GE appliances. The living room has original fireplace, built in shelves, and hardwood floors. The rear mudroom has Amish built benches, coat rack and storage. Enjoy the huge front porch and mature Lanscaping of this historic property. The Game room has Luxury plank flooring, fireplace and wet bar. Large second room can be used for storage, office, or additional entertaining area. This private, serene home with 4 garages in a great location, totally redone won't last!
WPMLS #1628316
Oct 28, 2023
Rental Removed
$4,500
$1/sq ft
Oct 21, 2023
Listed for Rent
$4,500
$1/sq ft
West Penn MLS #1616781
Oct 27, 2023
Delisted
—
Oct 11, 2023
Price Changed
$839,000
$230/sq ft
Sep 21, 2023
Price Changed
$869,900
$239/sq ft
Aug 19, 2023
Price Changed
$895,000
$245/sq ft
Jul 31, 2023
Listed
$910,000
$250/sq ft
+32
Move-in ready Brookside Farms 1920s quality restoration by local design-build contractor. Step back in time with today's luxuries, from the covered front porch to the lush ¾ acre landscaped lot. A stunning kitchen awaits with maple cabinets, quartz tops, & designer GE Café appliances. Enjoy the restored hardwood floors & space of the mud room leading to the private yard. The expansive living room boasts a FP surrounded by built-in shelving. Stunning 1st flr master suite with a cathedral ceiling, private balcony overlooking mature landscaping, his/her w/ i closets & FP. Incredible ensuite bath boasts a shower system & double sinks with quartz tops. 2nd floor includes 3 bedrooms, laundry & a spa like bathroom complete with apron pedestal tub & shower system. The basement provides plenty of space for entertaining in the game room w/ fireplace, 6' wet bar, full bath, future wine cellar, large utility room, 2 car integral+2 car attached garages. USC schools, super convenient location
West Penn MLS #1609460
Jul 25, 2023
Delisted
—
Jun 19, 2023
Price Changed
$925,000
$254/sq ft
Jun 7, 2023
Listed
$975,000
$267/sq ft
West Penn MLS #1593617
Mar 28, 2023
Delisted
—
Feb 19, 2023
Listed
$975,000
$267/sq ft
Public Records
Aug 31, 2022
Sold
$250,000
$69/sq ft
Public Records
Sep 11, 2008
Sold
$265,000
$73/sq ft
West Penn MLS #653095
Mar 30, 2007
Sold
$265,000
$73/sq ft
Jan 2, 2007
Listed
$275,000
$75/sq ft
West Penn MLS #530798
Sep 27, 2004
Listed
$249,900
$69/sq ft
Public Records
Sep 18, 1984
Sold
$84,900
$23/sq ft
Year
Property tax
Land + Additions
Assessment*
2026
$8,355 (−6.2%)
$57,600 + $142,400
$200,000
2025
$8,907 (+7.0%)
$57,600 + $160,400
$218,000
2024
$8,326 (+2.9%)
$57,600 + $160,400
$218,000
2023
$8,093 (+11.7%)
$57,600 + $160,400
$218,000
2022
$7,247 (+2.2%)
$57,600 + $142,400
$200,000
2021
$7,091 (+1.5%)
$57,600 + $142,400
$200,000
2020
$6,988 (+1.5%)
$57,600 + $142,400
$200,000
2019
$6,884 (+2.1%)
$57,600 + $142,400
$200,000
2018
$6,743 (+2.5%)
$57,600 + $142,400
$200,000
2017
$6,578 (+5.8%)
$57,600 + $142,400
$200,000
2015
$6,220
$57,600 + $142,400
$200,000
Tax history for 3252 Comanche Rd
Year
Property tax
Land + Additions
Assessment*
2026
$8,355 (−6.2%)
$57,600 + $142,400
$200,000
2025
$8,907 (+7.0%)
$57,600 + $160,400
$218,000
2024
$8,326 (+2.9%)
$57,600 + $160,400
$218,000
2023
$8,093 (+11.7%)
$57,600 + $160,400
$218,000
2022
$7,247 (+2.2%)
$57,600 + $142,400
$200,000
2021
$7,091 (+1.5%)
$57,600 + $142,400
$200,000
2020
$6,988 (+1.5%)
$57,600 + $142,400
$200,000
2019
$6,884 (+2.1%)
$57,600 + $142,400
$200,000
2018
$6,743 (+2.5%)
$57,600 + $142,400
$200,000
2017
$6,578 (+5.8%)
$57,600 + $142,400
$200,000
2015
$6,220
$57,600 + $142,400
$200,000
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Beds
4
Baths
2
Stories
2
Lot width
—
Lot depth
—
Lot size
0.74 Acres
Year renovated
—
Sq. Ft.
2,366
Year built
1920
Style
Single Family Residential
County
Allegheny County
APN
0477B00007000000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 20, 2026.
Property details
Parking
Garage/Carport Information
Has Garage
Has Attached Garage
Parking
Features: Built In, Detached, Garage, Garage Door Opener
# of Parking (Total): 4
Interior
Virtual Tour
Bathroom Information
# of Full Bathrooms: 3
# of Half Bathrooms: 1
Room Information
# of Rooms (Total): 11
Has Basement
Basement Information: Finished, Walk-Out Access
Room 1 Information
Entry/Foyer
Level: Main
Room 2 Information
Laundry
Level: Upper
Room 3 Information
Bonus Room
Level: Lower
Dimensions: 13x10
Room 4 Information
Game Room
Level: Lower
Dimensions: 14x10
Room 5 Information
Bedroom 4
Level: Upper
Dimensions: 14x11
Room 6 Information
Bedroom 3
Level: Upper
Dimensions: 14x10
Room 7 Information
Bedroom 2
Level: Upper
Dimensions: 14x10
Room 8 Information
Primary Bedroom
Level: Main
Dimensions: 18x16
Room 9 Information
Kitchen
Level: Main
Dimensions: 12x23
Room 10 Information
Dining Room
Level: Main
Dimensions: open
Room 11 Information
Living Room
Level: Main
Dimensions: 23x14
Fireplace Information
Has Fireplace
# of Fireplaces: 3
Features: Gas
Equipment
Appliances: Some Gas Appliances, Dishwasher, Disposal, Refrigerator, Stove
Interior Features
Flooring: Ceramic Tile, Hardwood
Other Features: Wet Bar, Kitchen Island, Pantry
Exterior
Building Information
Stories: 2
Roof Details: Asphalt
Construction Details: Cedar, Frame
Lot Information
Lot Size Area: 0.76
Lot Size Acres: 0.76
Lot Size Dimensions: 0.7415
Property Information
Resale
Financial
Assessments and Fees
Assessed Value: $218,000
Tax Information
Annual Tax Amount: $8,093
Utilities
Utility Information
Sewer: Public Sewer
Water Source: Public
Heating & Cooling
Has Cooling
Cooling: Central Air, Electric
Has Heating
Heating: Forced Air, Gas
Location
Community Information
Community Features: Public Transportation
Public facts
Beds: 4
Baths: 2.0
Sq. Ft.: 2,366
Stories: 2.0
Lot Size: 0.74 acres
Style: Single Family Residential
Year Built: 1920
Year Renovated: —
County: Allegheny County
APN: 0477B00007000000
Home facts updated by county records on Jul 20, 2026
Around this home
Schools
Eisenhower El School
Public K-4 • Assigned • 1.0mi
10/10
Fort Couch Middle School
Public 7-8 • Assigned • 1.3mi
9/10
Upper Saint Clair High School
Public 9-12 • Assigned • 0.6mi
9/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 96° expected this year, 17 days in 30 years
2/10 Wind Factor
0% chance of strong winds in next 30 years
2/10 Air Factor
1 unhealthy days expected this year, 2 days in 30 years
Provided by First Street
Historical weather
Pittsburgh, PA • 15241
Average low and high temperatures (°F)
31
17
40
24
59
37
68
46
70
51
82
62
86
69
83
62
79
58
67
45
53
37
42
27
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 8 hours in
June and 2.2 hours in December, placing it below the
U.S. average for solar exposure.
8 hrs
2.2 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$801,000 – $970,000
Reach more buyers when you sell with Redfin. Save up to $8,426 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.