Property Attributes
- ID#20261068206
- TypeSingle Family
- Listing Status Active
- CountyOAKLAND
- CityBloomfield Charter Township
- AreaBloomfield Twp
- NeighborhoodSLY FARMS
- Zip48301
- StyleColonial
- Year Built2026
- Taxes$ 6063
- Price$ 2,499,990
- Bedrooms5
- Full Bathrooms5
- Half Bathrooms1
- Sqr Footage7000
- Lot Size0.83 Acres
Data Source:
RealComp
Property Description
Join us for an Open House this Sunday 9/27 from 1pm-3pm!! A stunning expression of modern luxury, design, and elevated living with a fresh certificate of occupancy. This newly constructed residence offers over 7,000 square feet of meticulously crafted living space, blending high-end finishes with thoughtful functionality throughout. From the moment you enter, you're greeted by a dramatic two-story foyer featuring a striking elongated chandelier that sets the tone for the sophistication found throughout the home. The main level boasts 10-foot ceilings, while the upper level offers 9-foot ceilings with 8-foot door ways throughout creating a bright, open, and airy feel enhanced by oversized architectural windows that flood the space with natural light. A sleek, open-ended staircase adds a bold architectural statement, complementing the home’s modern aesthetic. The chef’s kitchen is a true centerpiece — designed for both entertaining and everyday living. It features a single-slab quartz island, 66" refrigerator, 36" professional-grade range, and a vented commercial-style hood, all accented by designer lighting and premium finishes. Each bedroom includes its own private en suite, offering comfort and privacy for family and guests alike. The primary suite is a true retreat, complete with a dedicated makeup vanity and an expansive walk-in closet featuring custom shelving, a center island, and built-in seating. The finished lower level is designed for entertaining, offering daylight windows and a kitchenette, perfect for gatherings or extended living space. Additional premium features include: • Heated bathroom floor in primary en suite • 24 kW whole-home generator • Tankless hot water heater • Smart garage door openers • Smart door locks for modern convenience Outdoor living is just as thoughtfully designed, featuring an oversized brick paver patio ideal for entertaining and just steps from the lake.
| Price History | |
|---|---|
| 8/25/2026 | Listed $2,599,990 |
| 9/24/2026 | 4$2,499,990 |
General Features
| Sewer | PublicSewer |
|---|---|
| Heating | ForcedAir, NaturalGas |
| Cooling | CeilingFans, CentralAir |
| Possession | AtClose |
| Appliances | BuiltInGasRange, Dishwasher, Disposal, ExhaustFan, FreeStandingRefrigerator, GasCooktop, StainlessSteelAppliances |
| Garage Spaces | 4.0 |
| Patio/Porch Features | Patio |
| Architectural Style | Colonial |
| Pool Features | None |
| Construction Materials | Brick |
| Exclusions | Exclusion(s) Do Not Exist |
| Year Built | 2026 |
| Levels | Two |
| Property Subtype | SingleFamilyResidence |
| County | Oakland |
| New Construction | No |
| Property Type | Residential |
| HOA | No |
| Attached Garage | Yes |
| Subdivision Name | SLY FARMS |
| Garage Y/N | Yes |
| Total Rooms | 12 |
| Full Baths | 5 |
| Status | Active |
| Directions | South of Walnut Lake Rd, West off Franklin Rd onto Niagara |
| City | BloomfieldCharterTownship_Oakland |
| Disclosures | ExclusionsDoNotExist, NoRestrictions, TaxesHomesteadExempt |
| Entry Location | GroundLevelwSteps |
| Senior Community Y/N | No |
| High School District | BloomfieldHills |
| MLS Area | Area02193BloomfieldTwp |
| Lot Size Units | Acres |
| Carport Y/N | No |
| Land Lease Y/N | No |
| Tax Annual Amount | 6063.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 | 114690 |
| Expected Active Date | 2026-08-25 |
| MobileHomeRemainsYN | No |
| PostalCity | BloomfieldHills_Oakland |
| Legal Description | T2N, R10E, SEC 30 SLY FARMS LOT 8 |
Interior Features
| Interior Amenities | EntranceFoyer, ENERGYSTARQualifiedDoors, JettedTub |
|---|---|
| Basement | Finished |
| Fireplace Features | LivingRoom |
| Basement (Y/N) | Yes |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Fireplace Y/N | Yes |
| Above Grade Finished Area | 5000.0 |
| Half Baths | 1 |
| Laundry Features | LaundryRoom |
| Total Bedrooms | 5 |
| Below Grade Finished Area | 2000.0 |
| WaterHeaterFuel | Tankless |
| LivingAreaSource | Builder |
| Above Grade Finished Area Unit Type | SquareFeet |
| Total Baths | 6 |
Exterior Features
| Exterior Amenities | Lighting |
|---|---|
| Parking Features | FourCarGarage, Attached |
| Water Source | Public |
| Foundation Details | Basement, Poured |
| Spa | No |
| Lot Dimensions | 150X240 |
| Lot Size Acres | 0.83 |
| 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 REMAX First 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 25, 2026 12:45 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
Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource.
The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Copyright 2026 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary