






















Description
- Listed by Caron Koteles Riha • Brokerage DRE #6503346359 • Real Estate One-RochesterP: (248)-379-6651 C: (248)-379-6651 Caron@CaronKoteles.com
- Listed by Lauren Koteles • Brokerage DRE #00547705 • Max Broock, REALTORS®-RochesterP: (248)-953-6671 C: (248)-953-6671 lauren@caronkoteles.com
Property Details for 54795 Shelby Road, Unit 87
Property Details for 54795 Shelby Road, Unit 87
| Status | Active |
|---|---|
| MLS # | 20261049503 |
| Days on Market | 1 |
| Pet Policy | - |
| Taxes | $1,940 / year |
| HOA Fees | $225 / month |
| Condo/Co-op Fees | - |
| Property Type | Condo |
| MLS Type | Residential / Condominium |
| Year Built | 1972 |
| County | Macomb County |
Location
Building Information for 54795 Shelby Road, Unit 87
Payment Calculator
$1,109 per month
30 year fixed, 6.36% Interest
$723
$162
$225
Property Information for 54795 Shelby Road, Unit 87
- Carrier Route: C011
- Directions: Park in uncovered spaces all the way to the right, or carport 87. Go to building 5B. Up the stairs and second door on the left is unit 87.
- Latitude: 42.69497382
- Longitude: -83.07012525
- Township: Macomb Shelby Twp
- Cross Street: 25 Mile / Shelby Road
- MLS Area Major: Shelby Twp (50007)
- Association Fee: $225.00
- Parcel Number: 0708102091
- Tax Amount Summer: $1,147.00
- Tax Amount Winter: $793.00
- Tax Annual Amount: $1,940.00
- Tax Assessed Value: $63,200.00
- Tax Legal Description: L 87 VISTA LAKES CONDOMINIUM, MACOMB COUNTY CONDOMINIUM SUBDIVISION PLAN NO 54 BLDG 5 APT 87 MASTER DEED, L2361, P193 TO 233 INCL. LIBER 2361 PAGES 193-234
- Association Fee Frequency: Monthly
- Association Fee Includes: Maintenance Grounds, Maintenance Structure, Sewer, Snow Removal, Trash, Water
- Association Contact: 248-650-3419; vistalakesboard@gmail.com
- Association: Yes
- High School District: Utica
- Attached Garage: No
- Garage: No
- Parking Features: Parking Lot, No Garage, Carport
- Virtual Tour URL Branded: https://app.cloudpano.com/tours/p2apaJbhnR
- Virtual Tour URL Unbranded: https://app.cloudpano.com/tours/p2apaJbhnR?mls=1
- Lot Size Units: Acres
- Road Frontage Type: Paved, Private Road
- Road Responsibility: Private Maintained Road
- State Equalized Value: 63200.0
- Living Area: 850.0
- Building Area Total: 850.0
- Above Grade Finished Area: 850.0
- Above Grade Finished Area Units: Square Feet
- Class Name: Residential
- Living Area Source: Public Records
- New Construction: No
- Year Built: 1972
- Construction Materials: Brick
- Entry Location: Upper Levelw Steps
- Foundation Details: Basement, Block
- Levels: One Story Up
- Roof: Asphalt
- Electric: Circuit Breakers
- Sewer: Public Sewer
- Utilities: Cable Available
- Water Source: Public
- Bathrooms Total Notational: 1.0
- Appliances: Dishwasher, Dryer, Free Standing Gas Range, Free Standing Refrigerator, Microwave, Stainless Steel Appliances, Washer
- Basement: Common, Unfinished
- Has Basement: Yes
- Bathrooms Full: 1
- Bathrooms Total Integer: 1
- Bedrooms Total: 2
- Cooling: Ceiling Fans, Central Air
- Has Cooling: Yes
- Fireplace: No
- Heating: Forced Air, Natural Gas
- Has Heating: Yes
- Laundry Features: In Unit, Laundry Room
- Rooms Total: 7
- Water Heater Fuel: Natural Gas
- Association Amenities: Clubhouse, Laundry
- Community Features: Clubhouse, Sidewalks, Tennis Courts
- Exterior Features: Balcony
- Fencing: Fencingnot Allowed
- Room Dimensions: 7 X 9
- Room Length: 7.0
- Room Width: 9.0
- Room Flooring: Luxury Vinyl
- Room Level: Second
- Room Type: Bedroom 1
- Room Dimensions: 15 X 11
- Room Length: 15.0
- Room Width: 11.0
- Room Flooring: Luxury Vinyl
- Room Level: Second
- Room Type: Bedroom 2
- Room Description: Ceramic
- Room Dimensions: 11 X 10
- Room Length: 11.0
- Room Width: 10.0
- Room Flooring: Luxury Vinyl
- Room Level: Second
- Room Type: Bathroom 1
- Room Dimensions: 12 X 10
- Room Length: 12.0
- Room Width: 10.0
- Room Flooring: Luxury Vinyl
- Room Level: Second
- Room Type: Living Room
- Room Dimensions: 11 X 7
- Room Length: 11.0
- Room Width: 7.0
- Room Flooring: Luxury Vinyl
- Room Level: Second
- Room Type: Kitchen
- Room Dimensions: 10 X 5
- Room Length: 10.0
- Room Width: 5.0
- Room Flooring: Ceramic Tile
- Room Level: Second
- Room Type: Dining Room
- Room Description: Linoleum
- Room Dimensions: 7 X 7
- Room Length: 7.0
- Room Width: 7.0
- Room Flooring: Linoleum
- Room Level: Second
- Room Type: Laundry
- Room Dimensions: 9 X 6
- Room Length: 9.0
- Room Width: 6.0
- Room Flooring: Concrete
- Room Level: Basement
- Room Type: Other
- Public GLR Website: Yes
- Existing Lease: No
- Pets Allowed: Breed Restrictions, Call, Cats Ok
Property History for 54795 Shelby Road, Unit 87
| Date | Event & Source | Price | Appreciation |
|---|---|---|---|
| Jul 1, 2026 | Listed (Active) Realcomp #20261049503 | $145,000 | — |
| Jul 1, 2026 | Listed (Active) MiRealSource #61007429 | $145,000 | — |
| Date | Event & Source | Price |
|---|---|---|
| 07/01/2026 | Listed (Active) Realcomp #20261049503 | $145,000 |
| 07/01/2026 | Listed (Active) MiRealSource #61007429 | $145,000 |
For completeness, we often displays two records for one sale: the MLS record and the public record.
Public Records for 54795 Shelby Road, Unit 87
Schools near 54795 Shelby Road, Unit 87
Rating | School | Type | Grades | Distance |
|---|---|---|---|---|
| Public - | PK to 6 | |||
| Public - | 7 to 9 | |||
| Public - | 10 to 12 | |||
| Public - | 9 to 12 |
Rating | School | Distance |
|---|---|---|
Switzer Elementary School PublicPK to 6 | ||
Malow Junior High School Public7 to 9 | ||
Eisenhower High School Public10 to 12 | ||
Joan C. Sergent Instructional Resource Center Public9 to 12 |
School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.
Similar Homes
Explore Nearby Homes
- Forest Park Homes for Sale
- Oakland Township - Oakland County Homes for Sale
- Park Place South Homes for Sale
- Rochester Hills Homes for Sale
- Shelby Homes for Sale
- Shelby Town Center Homes for Sale
- Shelby Township - Macomb County Homes for Sale
- Washington Township - Macomb County Homes for Sale
- Winkler Mill Homes for Sale
- Fox Creek Homes for Sale
- Pheasant Creek Homes for Sale
- Cross Creek Village Homes for Sale
- Parkdale Forest Homes for Sale
- Shelby Woods North Homes for Sale
- Central Park Manor Homes for Sale
- Washington Homes for Sale
- Rochester Homes for Sale
- Oakland Homes for Sale
- Utica Homes for Sale
- Macomb Homes for Sale
- Sterling Heights Homes for Sale
- Troy Homes for Sale
- Ray Homes for Sale
- Romeo Homes for Sale
- Auburn Hills Homes for Sale
- Mount Clemens Homes for Sale
- Fraser Homes for Sale
- Lake Orion Homes for Sale
- Clawson Homes for Sale
- Warren Homes for Sale
- 48315 Homes for Sale
- 48094 Homes for Sale
- 48306 Homes for Sale
- 48317 Homes for Sale
- 48307 Homes for Sale
- 48042 Homes for Sale
- 48044 Homes for Sale
- 48314 Homes for Sale
- 48085 Homes for Sale
- 48313 Homes for Sale
- 48096 Homes for Sale
- 48095 Homes for Sale
- 48309 Homes for Sale
- 48363 Homes for Sale
- 48038 Homes for Sale
No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.
Listing Courtesy of Real Estate One-Rochester; Max Broock, REALTORS®-Rochester
IDX provided courtesy of Realcomp II Ltd. via Compass and its related brokerages. Copyright 2026 Realcomp II Ltd. Shareholders. IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. The data relating to real estate properties on this website was last updated on 07/02/2026 01:15 PM PST
























1