Property Attributes
- ID#20261046166
- TypeSingle Family
- Listing Status Active
- CountyOAKLAND
- CityFranklin Village
- AreaFranklin Vlg
- NeighborhoodSTONEOAKS
- Zip48025
- StyleColonial
- Year Built2013
- Taxes$ 27968
- Price$ 2,495,000
- Bedrooms3
- Full Bathrooms2
- Half Bathrooms1
- Sqr Footage8094
- Lot Size0.81 Acres
Data Source:
RealComp
Property Description
Timeless custom-appointed Prairie-style ranch with walkout lower level, masterfully designed by acclaimed architect Glenda Meads—winner of the Detroit Home Design Award for Contemporary Architecture—and nestled on beautifully landscaped grounds featuring a spectacular saltwater pool with cascading waterfall, elegant covered loggia, and expansive green space that creates the perfect balance of resort-style luxury and everyday livability. Designed for both grand entertaining and private enjoyment, this architectural showpiece seamlessly blends sophisticated design with modern comfort. A dramatic open floor plan is highlighted by soaring ceilings, walls of glass, and refined finishes throughout. The luxurious first-floor primary suite offers the convenience of main-level living, while the upper level features two additional bedrooms, a versatile loft, and a Jack-and-Jill bath. Every space has been thoughtfully designed to maximize natural light and showcase the home's exceptional craftsmanship. Premium features include radiant heated floors throughout, smart home automation controls, full reverse osmosis water filtration, dual tankless water heaters, and newer air conditioning systems. The extraordinary outdoor setting offers a true private retreat with a resort-caliber saltwater pool, waterfall feature, covered loggia, and abundant lawn space for recreation and relaxation. The expansive walk-up lower level is already plumbed for a full kitchen and bath, offering endless possibilities for future living and entertaining space. Rarely does a residence combine architectural significance, luxury amenities, advanced technology, and exceptional outdoor living so effortlessly. A remarkable offering where timeless Prairie-inspired design and modern elegance create an unparalleled lifestyle experience.
| Price History | |
|---|---|
| 6/24/2026 | Listed $2,495,000 |
General Features
| Sewer | PublicSewer |
|---|---|
| Heating | ForcedAir, NaturalGas |
| Cooling | CentralAir |
| Possession | AtClose |
| Roof | Asphalt |
| Garage Spaces | 4.0 |
| Architectural Style | Colonial |
| Pool Features | InGround, OutdoorPool |
| Construction Materials | Brick |
| Exclusions | Exclusion(s) Exist |
| Year Built | 2013 |
| Levels | Two |
| Property Subtype | SingleFamilyResidence |
| County | Oakland |
| New Construction | No |
| Property Type | Residential |
| HOA | No |
| Attached Garage | Yes |
| Subdivision Name | STONEOAKS |
| Garage Y/N | Yes |
| Total Rooms | 10 |
| Full Baths | 2 |
| Status | Active |
| Directions | South of Thirteen Mile and East of Franklin |
| City | FranklinVillage_Oakland |
| Disclosures | ExclusionsExist, TaxesHomesteadExempt |
| Entry Location | GroundLevelwSteps |
| Senior Community Y/N | No |
| High School District | Birmingham |
| MLS Area | Area02241FranklinVlg |
| Lot Size Units | Acres |
| Carport Y/N | No |
| Land Lease Y/N | No |
| Tax Annual Amount | 27968.0 |
| Home Warranty Y/N | No |
| Lease Renewal Y/N | No |
| Additional Parcels Y/N | No |
| Lease Considered Y/N | No |
| Rent Control Y/N | No |
| Standard Status | Active |
| Occupancy Type | Vacant |
| Tax Assessed Value | 793820 |
| Expected Active Date | 2026-06-26 |
| MobileHomeRemainsYN | No |
| PostalCity | Franklin_Oakland |
| Legal Description | T1N, R10E, SEC 7 STONEOAKS LOT 25 |
Interior Features
| Basement | Finished, WalkUpAccess |
|---|---|
| Fireplace Features | Basement, DiningRoom, FamilyRoom, LivingRoom, MasterBedroom |
| Basement (Y/N) | Yes |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Fireplace Y/N | Yes |
| Above Grade Finished Area | 4536.0 |
| Half Baths | 1 |
| Total Bedrooms | 3 |
| Below Grade Finished Area | 3558.0 |
| WaterHeaterFuel | NaturalGas |
| LivingAreaSource | PriorListing |
| Above Grade Finished Area Unit Type | SquareFeet |
| Total Baths | 3 |
Exterior Features
| Exterior Amenities | Barbecue |
|---|---|
| Parking Features | FourCarGarage, Attached |
| Water Source | Well |
| Foundation Details | Basement, Poured |
| Spa | No |
| Lot Dimensions | 130X269.67 |
| Lot Size Acres | 0.81 |
| Waterfront Y/N | No |
| Road Frontage Type | Paved |
| Crops Included Y/N | No |
| Horse Y/N | No |
| Irrigation Water Rights Y/N | No |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
IDX provided courtesy of Realcomp II Ltd., via Taylor Office and The Originating MLS(found above), © 2026 Realcomp II Ltd. Shareholders. Shareholders. The information being provided is 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.
Data is updated as of September 16, 2026 9:57 PM UTC Information deemed reliable but not guaranteed.
The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of Realcomp Ltd