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 REMAX Classic 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 17, 2026 2:12 AM 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
Listing information is provided by Participants of the MichRIC MLS. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed. ©: MichRIC MLS. Last Update September 17, 2026 4:03 AM UTC