It's in the top 10% of views. Tour it before it's gone!
Tomorrow:
About this home
Welcome to this unique, one-of-a kind property offering more than 20 PRIVATE ACRES and a rare INDOOR SALTWATER POOL! Two Parcels, Parcel #1 includes home + 5.6 acres, Parcel #2 includes 15 acres, pole barn, additional garage and a tree farm. This exceptional custom-built home offers the perfect blend of city convenience and country living. With just over 6,100 sq. ft. of living space, this remarkable home features 5 bedrooms, 4 full baths, 1 half bath, a heated 3-car attached garage, an expansive finished basement, and an indoor pool with new heater and hydraulic cover. The grand two-story foyer opens to an impressive great room with 20-foot ceilings, architectural pillars, and abundant natural light. An elevator provides access to all three levels and the basement. The spacious kitchen features a large island, built-in appliances, dining area, separate pantry, and mudroom. The four-season sunroom captures views of the surrounding nature. A family room, dining/flex room, office, and half bath complete the main level. A winding staircase leads to the second level, where the primary suite serves as a private retreat with a balcony overlooking the acreage, a jacuzzi room, dual-sink vanity, separate shower, and wardrobe room. A second bedroom features an ensuite bath, while two additional bedrooms share a Jack-and-Jill bathroom. The third-floor loft with skylight windows offers flexible living space for a fifth bedroom or home office. The finished basement provides over 2,000 sq. ft. and includes a kitchenette and full bath. Additional features include a central sound system, zoned heating and cooling, exceptional insulation, all-brick exterior, site drainage, and underground electrical. This extraordinary estate combines luxury amenities, custom craftsmanship, and a breathtaking natural setting to create a truly rare and remarkable property. No association. Zoned Residential/Agricultural. HOME WITH 5+ ACRES CAN BE PURCHASED SEPARATELY, SEE MLS #20261045268 FOR DETAILS.
Macomb, located between Hall Road (M-59) and 23 Mile Road, is a suburban and residential Sterling Heights neighborhood with broad arterial corridors and newer subdivision streetscapes. The neighborhood’s energy concentrates around the Hall Road and Schoenherr Road intersection, where big retail plazas, casual eateries, and steady traffic set the pace. Housing reads as late-20th-century ranches and colonials alongside newer builds, with wide driveways and tidy setbacks. For local culture, the Sterling Heights Public Library and the Sterling Heights Nature Center act as community anchors. Dodge Park adds riverfront paths and event lawns that shape weekend routines. The layout favors errands by car, with pockets of green space breaking up the commercial strips.
Provided by Walk Score and Local Logic
Market insights
54720 Foss Rd · $1,790,000
DAYS ON MARKET
1 days
The average home goes pending in 23 days.
SALE-TO-LIST
99.3%
Most homes are selling 1% below list price.
LIST PRICE
$1,790,000
Median sale price in this area is $301,511. (83% lower than this home)
PRICE DROP
0 price drops
24% of homes in this area have had a price drop in the past month.
Property details
Interior
Exterior
Finance
Kitchen
Bathroom
Bedroom
Living
Dining
Interior features
Elevator/Lift
Spa/Jetted Tub
Indoor Pool
Sound System
Wet bar
Fireplace (basement, great room, master bedroom)
Has fireplace
Total of 22 rooms
Bedrooms
Primary bedroom on the second level (19 x 24)
Second bedroom on the second level (14 x 13)
Third bedroom on the second level (approx. 12 wide)
Fourth bedroom on the second level (14 x 12)
Fifth bedroom on the third level (19 x 17)
Bathrooms
Four full bathrooms
One additional lavatory (total 5 baths/lavatories)
At least one lavatory at entry level
Bathrooms located on second level and basement
Kitchen
Kitchen at entry level (15 x 18)
Breakfast nook at entry level (13 x 13)
Dining room at entry level (17 x 14)
Dishwasher
Disposal
Microwave
Refrigerator
Gas range/stove not specified
Laundry & utility
Laundry room at entry level (9 x 13)
Washer
Dryer
Heating & cooling
Central air conditioning
Ceiling fans
Forced air heating
Radiant heating
Zoned heating
Exterior features
Brick exterior
Exterior balcony
Inground pool
Patio
Porch
Pole barn
Shed
Second garage
Paved street access
640 feet frontage
Has pool
Home design
Residential property
More than 2 stories
Built in 1996
Parking
Attached heated garage with electric
Additional garage(s) (second garage and outbuilding garage)
Three garage parking spaces
Construction
Brick construction
Basement foundation
Finished basement (below grade finished area noted)
Utilities
Public water
Septic system
Natural gas for heat
Gas water heater
Electricity and solar
View estimated energy costs and solar savings for this home
Welcome to this unique, one-of-a kind property offering more than 20 PRIVATE ACRES and a rare INDOOR SALTWATER POOL! Two Parcels, Parcel #1 includes home + 5.6 acres, Parcel #2 includes 15 acres, pole barn, additional garage and a tree farm. This exceptional custom-built home offers the perfect blend of city convenience and country living. With just over 6,100 sq. ft. of living space, this remarkable home features 5 bedrooms, 4 full baths, 1 half bath, a heated 3-car attached garage, an expansive finished basement, and an indoor pool with new heater and hydraulic cover. The grand two-story foyer opens to an impressive great room with 20-foot ceilings, architectural pillars, and abundant natural light. An elevator provides access to all three levels and the basement. The spacious kitchen features a large island, built-in appliances, dining area, separate pantry, and mudroom. The four-season sunroom captures views of the surrounding nature. A family room, dining/flex room, office, and half bath complete the main level. A winding staircase leads to the second level, where the primary suite serves as a private retreat with a balcony overlooking the acreage, a jacuzzi room, dual-sink vanity, separate shower, and wardrobe room. A second bedroom features an ensuite bath, while two additional bedrooms share a Jack-and-Jill bathroom. The third-floor loft with skylight windows offers flexible living space for a fifth bedroom or home office. The finished basement provides over 2,000 sq. ft. and includes a kitchenette and full bath. Additional features include a central sound system, zoned heating and cooling, exceptional insulation, all-brick exterior, site drainage, and underground electrical. This extraordinary estate combines luxury amenities, custom craftsmanship, and a breathtaking natural setting to create a truly rare and remarkable property. No association. Zoned Residential/Agricultural. HOME WITH 5+ ACRES CAN BE PURCHASED SEPARATELY, SEE MLS #20261045268 FOR DETAILS.
REALCOMP #20261045268
Aug 9, 2026
Listed
$1,400,000
$168/sq ft
MiRealSource-MiMLS #61018271
Aug 9, 2026
Listed
$1,400,000
$168/sq ft
Aug 5, 2026
Coming Soon
$1,400,000
$168/sq ft
+64
Welcome to this exceptional custom-built estate nestled on more than 5 private acres, offering the perfect blend of city convenience and country living. With just over 6,100 sq. ft. of living space, this remarkable home features 5 bedrooms, 4 full baths, 1 half bath, a heated 3-car attached garage, an expansive finished basement, and a rare indoor saltwater pool with a new heater and hydraulic cover. The grand two-story foyer opens to an impressive great room with soaring 20-foot ceilings, architectural pillars, and an abundance of natural light. An elevator provides convenient access to all three levels and the basement. The spacious kitchen features a large island, built-in appliances, dining area, separate pantry, and mudroom. One of the home's standout spaces is the four-season sunroom, offering beautiful views of the surrounding nature. A family room, dining/flex room, office, and half bath complete the main level. A winding staircase leads to the second level, where the primary suite serves as a private retreat with its own balcony overlooking the scenic acreage, a jacuzzi room, dual-sink vanity, separate shower, and wardrobe room. A second bedroom features a private ensuite bath, while two additional bedrooms share a Jack-and-Jill bathroom. The third-floor loft with skylight windows offers flexible living space for a fifth and even sixth bedroom, family room, or home office. The finished basement provides over 2,000 sq. ft. and includes a kitchenette and full bath. Additional features include a central sound system, zoned heating and cooling, exceptional insulation, an all-brick exterior, site drainage, and underground electrical. This extraordinary estate combines luxury amenities, thoughtful custom craftsmanship, and a breathtaking natural setting to create a truly one-of-a kind property. A list of amenities with disclosures. No association. Zoned Residential/Agricultural. Adjacent 15 acres with pole barn and 2-1/2-car garage is also available for purchase.
Year
Property tax
Land + Additions
Assessment*
2025
$12,828 (+2.6%)
2024
$12,500
Public record
Public record
Zoning
Beds
—
Baths
3.5
Stories
—
Lot width
296 ft.
Lot depth
791 ft.
Lot size
5.38 Acres
Year renovated
—
Finished Sq. Ft.
6,158
Unfinished Sq. Ft.
—
Total Sq. Ft.
6,158
Year built
1996
Style
Single Family Residential
County
Macomb County
APN
20-08-10-200-032
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 13, 2026.
AG
Agricultural District
The purpose of this district is to 1 provide open land areas for future orderly growth of urban development, continued agricultural use and residential activities of a rural character that are presently without public water and sewage facilities and are likely to remain without such services for an extended period of time and 2 to protect and stabilize the essential characteristics of these areas in order to promote and encourage suitable environments for low density family life, until such time as it may be in the public interest to promote development of a greater intensity requiring higher levels of public services and utilities. The following regulations shall apply to all Residential Agricultural Districts.
Permitted uses
Include but are not limited to:
Agriculture
Equestrian facility
Greenhouse / nursery
Livestock production
Housing-Single unit
Historical weather
Macomb, MI • 48042 2508
Average low and high temperatures (°F)
28
15
34
18
51
31
60
40
67
47
81
59
85
65
79
59
77
54
66
44
49
36
36
24
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
90/ 100
Exceptional sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.5 hrs
5.6 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 54720 Foss Rd
$1,790,735
$735 over list price of $1.79M
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $560K to $705K.