Beautiful upper unit Ranch condo. Brand new carpeting throughout, sharp quartz counters with 9" stainless-steel sink in Kitchen with all appliances included. 5 filter purified water system at kitchen sink and refrigerator. Newer full-size walk-in shower enclosure, two nice sized bedrooms, spacious balcony overlooking community pond. In-unit laundry, common basement for additional storage. Community clubhouse available to rent for events. Cats allowed, prime location near Stony Creek Metropark, and unit is backed by the Macomb Orchard Trail. One assigned carport spot (#65), and generous unassigned visitor parking. Additional storage space on premises available for boats, campers, and RV's.
Pending
Price cut: $6.9K (6/22)
$148,000
54749 Shelby Rd #65/4, Utica, MI 48316
2beds
865sqft
Condominium, Apartment
Built in 1972
-- sqft lot
$-- Zestimate®
$171/sqft
$225/mo HOA
What's special
Sharp quartz countersGenerous unassigned visitor parkingBrand new carpeting throughoutIn-unit laundryTwo nice sized bedroomsAll appliances included
- 42 days |
- 644 |
- 23 |
Likely to sell faster than
Zillow last checked:
Listing updated:
Listed by:
Mario Como 586-774-2300,
Berkshire Hathaway HomeServices Kee Realty SCS 586-774-2300
Source: MiRealSource,MLS#: 50207793
Originating MLS: MiRealSource
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 1
- Full bathrooms: 1
Rooms
- Room types: Living Room, Dining "L"
Bedroom 1
- Features: Carpet
- Level: Upper
- Area: 156
- Dimensions: 13 x 12
Bedroom 2
- Features: Carpet
- Level: Upper
- Area: 132
- Dimensions: 12 x 11
Bathroom 1
- Level: Upper
Kitchen
- Level: Upper
Living room
- Features: Carpet
- Level: Upper
Heating
- Forced Air, Natural Gas
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Dishwasher, Dryer, Range/Oven, Refrigerator, Washer, Gas Water Heater
Features
- Flooring: Carpet
- Basement: Common
- Has fireplace: No
Interior area
- Total structure area: 865
- Total interior livable area: 865 sqft
- Finished area above ground: 865
- Finished area below ground: 0
Property
Parking
- Total spaces: 1
- Parking features: 1 Space, Covered, Carport
- Has carport: Yes
Features
- Exterior features: Balcony
- Waterfront features: Pond
Lot
- Size: 6.76 Acres
Details
- Parcel number: 230708102069
- Special conditions: Private
Construction
Type & style
- Home type: Condo
- Architectural style: Ranch
- Property subtype: Condominium, Apartment
- Attached to another structure: Yes
Materials
- Brick
- Foundation: Basement
Condition
- New construction: No
- Year built: 1972
Utilities & green energy
- Sewer: Public Sanitary
- Water: Public
Community & HOA
Community
- Subdivision: Vista Lakes
HOA
- Has HOA: Yes
- Amenities included: Clubhouse, Maintenance Grounds
- Services included: Club House Included, HOA, Maintenance Grounds, Snow Removal, Water
- HOA fee: $225 monthly
- HOA name: Vista Lakes
- HOA phone: 248-650-3419
Location
- Region: Utica
Financial & listing details
- Price per square foot: $171/sqft
- Annual tax amount: $650
- Date on market: 5/15/2026
- Cumulative days on market: 43 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 6/24/2026 | Pending sale | $148,000$171/sqft |
Source: | ||
| 6/22/2026 | Price change | $148,000-4.5%$171/sqft |
Source: | ||
| 5/15/2026 | Listed for sale | $154,900$179/sqft |
Source: | ||
Public tax history
Tax history is unavailable.
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 48316
Nearby schools
GreatSchools rating
- 8/10Switzer Elementary SchoolGrades: PK-6Distance: 0.7 mi
- 7/10Malow Junior High SchoolGrades: 7-9Distance: 1 mi
- 9/10Eisenhower High SchoolGrades: 10-12Distance: 1.1 mi
Schools provided by the listing agent
- District: Utica Community Schools
Source: MiRealSource. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
- Michigan
- Macomb County
- Shelby Township
- 48316
- 54749 Shelby Rd Unit 65/4









