$10,000 Closing Credit¹
#1689325, Mary Brettell, Listing office: Howard Hanna Real Estate Services
Property details
About 904 Champlain Pl
Tucked away on 5.54 ultra-private acres in Treesdale, this timeless estate offers unmatched seclusion and luxury. Mature trees surround a resort-style outdoor space featuring a saltwater pool, hot tub, and a covered entertaining area with heaters, retractable screens, and a full outdoor kitchen—perfect for seamless indoor-outdoor living. Inside, this 6-bed, 7-bath showplace includes an updated gourmet kitchen, a finished third level with flexible space, and a fully remodeled lower level. The custom, temperature-controlled wine room is a true centerpiece, joined by a wellness room, hobby room, stylish bar, and walk-up access with a stacked washer/dryer for pool essentials. A richly paneled grand study offers a fireplace, backyard views, and outdoor access. The reimagined primary suite serves as a luxurious retreat with spa-like finishes. Through the trees, the green of Hole 13 on the Grove Course at Treesdale quietly reveals a scenic, serene backdrop. Privacy and tranquility await!
Highlights
Home typeSingle Family Residence
HeatingForced Air, Natural Gas
StatusActive
CoolingCentral Air
BasementYes
Lot size5.54 Acres
Year built1999
ParkingAttached, Garage, Garage Door Opener
MLS #1699594
Attached garageYes
Summary
- Partial Bathrooms: 2
- Full Bathrooms: 5
- Appliances: Other, Convection Oven, Cooktop, Dishwasher, Disposal, Microwave, Refrigerator
- Basement: Yes
- Flooring Type: Ceramic Tile, Hardwood
- Interior: Kitchen Island, Pantry, Window Treatments
- Total Bedroom Count: 6
- Attached Garage: Yes
- Parking: Attached, Garage, Garage Door Opener
- Architectural Style: Colonial, Three Story
- Heating: Forced Air, Natural Gas
- Cooling: Central Air
- List Price: $2,900,000
- Directions: 228 E Right Warrandale Rd Left Treesdale Drive Left Four Lakes Drive Left Champlain Place
- Year Built: 1999
- Stories: 3
- Lot Size: 5.54 Acres
- MLS Number: 1699594
- MLS Name: WESTPENN
- Office Name: Berkshire Hathaway The Preferred Realty
- Office Phone: (724) 776-3686
- Listing Agent: Kim Maier
The multiple listing information is provided by West Penn Multi-List, Inc. Information deemed reliable, but not guaranteed. IDX info provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All properties are subject to prior sale, change, or withdrawal. Listings displaying the IDX logo belong to brokers other than this broker. Neither the listing broker(s) nor this broker or the MLS shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless.
Copyright © 2025 West Penn Multi-List, Inc. All Rights Reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 6/25/2025, 3:45:28 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹
$2,900,000
904 Champlain Pl
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
We're sorry, we currently don't have tax history data for this listing.
Nearby schools
5
Mars Area Elementary School
Public District 2-4
1.7 mi
•549 Route 228
5
Mars Area Centennial School
Public District 5-6
2.5 mi
•100 Winfield Manor Dr
5
Eden Hall Upper Elementary School
Public District 4-6
3.3 mi
•3900 Bakerstown Rd
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $120,789. Typical income of Adams Twp, PA residents is between $100k-200k annually. Most families are married, with kids. Residents of this area typically have post secondary degree education.
How much money do the neighbors make?
10%
<35k
28%
35k-100k
38%
100k-200k
24%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
Doctorate
What types of families live nearby?
32%
Single, No Kids
5%
Single, with Kids
29%
Married, No Kids
34%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
20%
<11 yrs old
10%
12-17 yrs old
16%
18-34 yrs old
46%
35-64 yrs old
8%
65+ yrs old
What do the neighbors do for fun?
Skiing/snowboarding
PGA/LPGA
College Football
Where do the neighbors shop?
BJs Wholesale Club
Stein Mart
Express/Express For Men
Where do the neighbors go to eat?
Panera
Cracker Barrel
Bob Evans
What do the neighbors drive?
Infiniti
Lexus
Lincoln
What do the neighbors listen to?
Adult Hits
Oldies
News/Talk/Information
All data provided by Home Junction and Claritas
Similar homes for sale
Backup offers
$10,000 Closing Credit¹
#1704106, Lorraine Easton, Listing office: Re/Max Real Estate Solutions
6 days on RocketTour
$10,000 Closing Credit¹
#1706880, Kathleen Barge, Listing office: Piatt Sotheby'S International Realty
Backup offers
$4,036 Closing Credit¹
#1705312, Samantha Young, Listing office: Howard Hanna Real Estate Services
2 days on Rocket
$2,553 Closing Credit¹
#1707309, Amanda Tihey, Listing office: Keller Williams Exclusive
Frequently asked questions
About 904 Champlain Pl
The listing price of 904 Champlain Pl property is $2,900,000.
The property 904 Champlain Pl is a house located in Adams Twp, Pennsylvania, 15044.
Active Listing: 904 Champlain Pl is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 904 Champlain Pl are: Mars Area Elementary School (GreatSchools Rating 5/10), Mars Area Centennial School (GreatSchools Rating 5/10), Eden Hall Upper Elementary School (GreatSchools Rating 5/10), Pine-Richland Middle School (GreatSchools Rating 7/10), Mars Area Middle School (GreatSchools Rating 5/10), Marshall Middle School (GreatSchools Rating 6/10), Pine-Richland High School (GreatSchools Rating 9/10), Mars Area High School (GreatSchools Rating 8/10), North Allegheny High School (GreatSchools Rating 9/10).
The property at 904 Champlain Pl has 6 bedrooms and 5 full and 2 half bathrooms.
The year of construction for 904 Champlain Pl is 1999.
This home is located at 904 Champlain Pl in Adams Twp, PA and zip code 15044. Features: 6 bedrooms, 7 bathrooms. It has been listed on Rocket Homes since May 9, 2025 and is currently priced at $2,900,000.
Over 2 listings were sold over their listed price in May 2025 in Adams Twp, PA. In the same period over 16 listings were sold below the listed price and 1 listings were sold for the listed price. The number of homes for sale in Adams Twp, PA increased by 9% between April and May 2025. In May 2025 median list price was $550,000 and the average listing age was 39 days.
From Rocket Homes Real Estate and based on county public records data.