Step inside your private ground-level entrance, pull into your attached direct-access 1-car garage out of the Michigan winter, and head upstairs to effortless, elevated living in coveted Warwick Village. Vaulted cathedral ceilings instantly draw the eye up, filling the massive open great room with airy natural light and setting the stage for cozy evenings anchored by the gas fireplace. The bright, open-concept flow connects directly to a spacious dining area and an updated kitchen designed for hosting, complete with crisp white shaker cabinetry, clean subway tile, marble-look countertops, a raised breakfast bar for morning coffee, and a full suite of stainless steel appliances. Unwind in the expansive primary retreat, featuring a soaring vaulted ceiling, dedicated walk-in closet, private ensuite bath with premium granite, and direct doorwall access out to your covered private balcony. It is the perfect peaceful perch for a quiet evening drink or fresh morning air overlooking mature trees and manicured community greenspace. The versatile second bedroom easily adapts to an executive home office, guest suite, or personal workout sanctuary right next to the second full bath. Living here feels like a year-round resort getaway with Warwick Village clubhouse privileges, a fully equipped fitness center, an outdoor in-ground pool, and scenic neighborhood walking paths right outside your door. The low-maintenance $250 monthly association fee takes care of water, sewer, trash, exterior structure maintenance, snow removal, and grounds care, letting you lock up and go without the weekend chores. Serviced by Utica Community Schools and located just off Garfield and 21 Mile for quick access to local dining and shopping. Complete with a dedicated in-unit laundry room with wash tub, extra storage, and an interactive 3D Matterport virtual tour!
CondoProperty Type
2004Year Built
$153Price/Sq.Ft.
$250/moHOA Dues
1 car garageParking
Listed by William Whitehouse• Berkshire Hathaway HomeServices Kee Realty Bham
•248-646-6200 (broker)
•john@keerealty.com (broker)
Listed by Kathleen Whitehouse• Berkshire Hathaway HomeServices Kee Realty Bham
Make a winning offer with the help of a local agent
Around this home
Schools
K - 12
Preschool & daycare
Graebner Elementary School
Public PreK-6 • Assigned • 2.7mi
7/10
Bemis Junior High School
Public 7-8 • Assigned • 3.0mi
7/10
Henry Ford II High School
Public 9-12 • Assigned • 3.5mi
8/10
Provided by GreatSchools
About
Macomb
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
46087 Rhodes Dr · $249,777
SALE-TO-LIST
97.7%
Most homes are selling 2% below list price.
LIST PRICE
$249,777
Median sale price in this area is $234,786. (6% lower than this home)
PRICE DROP
0 price drops
26% 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
Cable and DSL available
Bedrooms
2 bedrooms, both on the entry level
Bathrooms
2 full bathrooms, both on the entry level
Kitchen
Dishwasher
Disposal
Range/oven
Refrigerator
Laundry & utility
Entry-level laundry room
Washer
Dryer
Flooring
Carpet in the bedrooms, dining room, and living room
Ceramic tile in the kitchen and bathrooms
Vinyl in the laundry room
Heating & cooling
Forced-air heating
Central air conditioning
Exterior features
Balcony
Deck
Inground pool
Porch
Home design
Condominium
Second-floor unit
Parking
Attached one-car garage with electric service and a door opener
One additional parking space
Construction
Built in 2004
Brick and vinyl siding
Slab foundation
Utilities
Public water
Natural gas
Gas water heater
HOA & community
Monthly association fee of $250
Association fee includes lawn maintenance, snow removal, trash removal, water and sewer, clubhouse access, and exterior maintenance
Community amenities include a clubhouse, exercise room, laundry facility, and private entry
Electricity and solar
View estimated energy costs and solar savings for this home
UTICA SCHOOLS- Spacious Condo:Two Bedrooms, Two Full Baths, Master Bedroom Has Full Bath! Great Rm with Gas Fireplace & Dining Rm, Kitchen Appliances Included: Stove, Microwave, Refrigerator and Dishwasher. Bedrooms Have Walk-in Closets, Large Laundry Rm / Mud Rm - includes Washer and Dryer! TWO Doorwalls Leads to Balcony, One Car Attached Garage! Alarm Security System & Intercom System! Clubhouse with Pool, Association Fee covers Water & Outside Maintenance, PRIVATE ENTRY, Well Maintained Grounds - Great Location - Convenient to Shopping, Restaurants, Churches, and Parks!
REALCOMP #58031337182
Feb 1, 2018
Sold
$135,000
$83/sq ft
Dec 21, 2017
Listed
$139,000
$85/sq ft
MiRealSource-MiMLS #543203
May 10, 2007
Listing Removed
—
Jan 29, 2007
Listed
$150,000
$92/sq ft
REALCOMP #27017905
May 14, 2007
Listing Removed
—
Jan 29, 2007
Listed
$150,000
$92/sq ft
REALCOMP #26142269
Dec 14, 2006
Listing Removed
—
Aug 12, 2006
Listed
$159,900
$98/sq ft
MiRealSource-MiMLS #543200
Dec 14, 2006
Listing Removed
—
Jun 14, 2006
Listed
$150,000
$92/sq ft
As the MLS and public records start to fill up, we'll list the details here.
Public record
Public record
Zoning
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Finished Sq. Ft.
—
Unfinished Sq. Ft.
—
Total Sq. Ft.
—
Year built
—
Style
Condo/Co-op
County
Macomb County
APN
0831426290
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Mar 18, 2026.
R-2
Residential Multiple-Family Medium Density District
The purpose of this district is to provide for various types of low rise multiple-family residential dwellings and medium high residential densities but under specific population density controls. The requirements of this district are intended to recognize that various forms of site development are desirable in order to provide a wide range of choice of living environments but at the same time to regulate such developments in order to prevent congestion on the public streets, reduce hazards to life and property, provide desirable light and air and to provide for adequate open spaces and basic amenities. It is intended that these districts will generally be located in or near the centers of intensive urban activity along paved major streets within such centers and will be served by public water and sanitary sewer system and other appropriate urban facilities and services including fire protection service.
Permitted uses
Include but are not limited to:
Housing-Multiple units
Climate risks
9/10 Flood Factor
Estimated 80%+ chance of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
3/10 Heat Factor
7 days above 96° expected this year, 15 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
3/10 Air Factor
3 unhealthy days expected this year, 5 days in 30 years
Provided by First Street
Historical weather
Macomb, MI • 48044 4080
Average low and high temperatures (°F)
29
16
34
19
51
32
60
41
67
47
81
60
86
66
79
60
76
54
65
45
50
37
36
24
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
96/ 100
Exceptional sunlight
Sunscore
This home receives average direct sun exposure in Macomb. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
11.4 hrs
6.6 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 46087 Rhodes Dr
There isn’t enough information to generate an accurate estimate at this time. Learn More
More resources
Rental earnings
Est. $1,698 per month, based on comparable rentals