Property Attributes
- ID#20261051501
- TypeSingle Family
- Listing Status Active
- CountyMACOMB
- CitySterling Heights
- AreaSterling Heights
- NeighborhoodFRANCESCA
- Zip48312
- StyleColonial
- Year Built1974
- Taxes$ 11341
- Price$ 375,000
- Bedrooms4
- Full Bathrooms2
- Half Bathrooms0
- Sqr Footage3708
- Lot Size0.17 Acres
Data Source:
RealComp
Property Description
Welcome to one of the area's most unique homes! This 4-bedroom residence offers a blend of comfort, entertainment, and one-of-a-kind features you won't find elsewhere. Inside, you'll find spacious living areas, contemporary finishes, and a stunning built-in aquarium connecting the kitchen and family room. One of the four bedrooms is currently configured as a dedicated sauna and wellness space but can easily serve as a traditional bedroom. The finished basement features a distinctive indoor koi pond, creating a relaxing atmosphere perfect for entertaining or unwinding. Outside, the backyard includes an in-ground pool with the potential to be restored into a private summer retreat. Whether you're looking for a memorable primary residence, an entertainer's dream, or a property with unique character, this home offers endless possibilities and must be seen in person to be fully appreciated.
| Price History | |
|---|---|
| 7/17/2026 | Listed $375,000 |
General Features
| Sewer | PublicSewer |
|---|---|
| Heating | ForcedAir, NaturalGas |
| Cooling | CeilingFans, CentralAir |
| Possession | AtClose |
| Appliances | Dishwasher, DoubleOven, Dryer, FreeStandingRefrigerator, Microwave, Washer |
| Garage Spaces | 2.0 |
| Patio/Porch Features | Patio, Porch |
| Architectural Style | Colonial |
| Pool Features | InGround |
| Construction Materials | Brick, Other |
| Year Built | 1974 |
| Levels | Two |
| Property Subtype | SingleFamilyResidence |
| County | Macomb |
| New Construction | No |
| Property Type | Residential |
| HOA | No |
| Attached Garage | No |
| Subdivision Name | FRANCESCA |
| Garage Y/N | Yes |
| Total Rooms | 10 |
| Full Baths | 2 |
| Status | Active |
| Directions | N of Canterbury Dr, E of Dodge Park Rd |
| City | SterlingHeightsCity_Macomb |
| Disclosures | TaxesNotHomesteadExempt |
| Entry Location | GroundLevel |
| Senior Community Y/N | No |
| High School District | Utica |
| MLS Area | Area03101SterlingHeights |
| Lot Size Units | Acres |
| Carport Y/N | No |
| Land Lease Y/N | No |
| Tax Annual Amount | 11341.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 | 197240 |
| Expected Active Date | 2026-07-24 |
| MobileHomeRemainsYN | No |
| PostalCity | SterlingHeights_Macomb |
| Legal Description | M 23 $ FRANCESCA SUB'N LOT 23 |
Interior Features
| Interior Amenities | SpaHottub |
|---|---|
| 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 | 2700.0 |
| Laundry Features | LaundryRoom |
| Total Bedrooms | 4 |
| Below Grade Finished Area | 1008.0 |
| WaterHeaterFuel | NaturalGas |
| LivingAreaSource | PriorListing |
| Above Grade Finished Area Unit Type | SquareFeet |
| Total Baths | 2 |
Exterior Features
| Exterior Amenities | Lighting |
|---|---|
| Fencing | BackYard, Fenced |
| Parking Features | TwoCarGarage, Detached |
| Water Source | Public |
| Foundation Details | Basement, Poured |
| Spa | No |
| Lot Dimensions | 60X123 |
| Lot Size Acres | 0.17 |
| 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 National Realty Centers 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 21, 2026 9:27 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