OPEN HOUSE - Sunday Mar 8, 12-2 PM Absolutely gorgeous, fully updated ranch on an inland lake!!! 3 bed, 2.5 bath completely remodeled, move-in ready home! Fish in the summer & swim in the beautiful lake! Skating in the winter months as well! Fully finished basement, 2025 updates: New 20 x 30 Stamped concrete patio, New retention wall w steps to lake, New sprinkler system, exterior paint, both fireplace remodels, new trim & recessed lights, New elec panel and wiring to weatherhead. 2024: New roof w 50 year warranty, New flooring & trim, New interior doors,New entry buffet w Granite. 2022: New bay window. 2021: New Black Stainless appliances in kitchen. Patio cabana stays for the ultimate in luxury living! Annual subdivision parties to welcome you into your new neighborhood! Schedule your showing today!
Pending
$569,000
5100 Stellar Rd, Shelby Township, MI 48316
3beds
3,679sqft
Est.:
Single Family Residence
Built in 1965
0.38 Acres Lot
$572,300 Zestimate®
$155/sqft
$29/mo HOA
What's special
- 21 days |
- 1,622 |
- 63 |
Zillow last checked: 7 hours ago
Listing updated: March 09, 2026 at 07:05pm
Listed by:
Danielle Roberts 586-530-8337,
Oak and Stone Real Estate 248-266-0584
Source: MiRealSource,MLS#: 50200912
Originating MLS: MiRealSource
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Rooms
- Room types: Entry, Family Room, Bedroom, Laundry, Master Bedroom, Living Room, Utility/Laundry Room, Workshop, Master Bathroom, Office, First Flr Lavatory, Bathroom, Breakfast Nook/Room, Dining Room
Primary bedroom
- Level: First
Bedroom 1
- Features: Carpet
- Level: Entry
- Area: 168
- Dimensions: 14 x 12
Bedroom 2
- Features: Carpet
- Level: Entry
- Area: 132
- Dimensions: 12 x 11
Bedroom 3
- Features: Laminate
- Level: Entry
- Area: 132
- Dimensions: 12 x 11
Bathroom 1
- Features: Laminate
- Level: Entry
- Area: 52
- Dimensions: 13 x 4
Bathroom 2
- Features: Ceramic
- Level: Entry
- Area: 77
- Dimensions: 11 x 7
Dining room
- Features: Laminate
- Level: Entry
- Area: 126
- Dimensions: 14 x 9
Family room
- Features: Carpet
- Level: Entry
- Area: 286
- Dimensions: 22 x 13
Kitchen
- Features: Laminate
- Level: Entry
- Area: 143
- Dimensions: 13 x 11
Living room
- Features: Carpet
- Level: Entry
- Area: 315
- Dimensions: 21 x 15
Heating
- Forced Air, Natural Gas
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Dishwasher, Dryer, Range/Oven, Refrigerator, Washer, Gas Water Heater
- Laundry: First Floor Laundry, Laundry Room, Entry
Features
- Sump Pump, Eat-in Kitchen
- Flooring: Ceramic Tile, Laminate, Carpet
- Windows: Bay Window(s)
- Basement: Block,Finished,Full
- Number of fireplaces: 2
- Fireplace features: Family Room, Living Room
Interior area
- Total structure area: 4,200
- Total interior livable area: 3,679 sqft
- Finished area above ground: 2,100
- Finished area below ground: 1,579
Property
Parking
- Total spaces: 2.5
- Parking features: Covered, Garage, Attached, Carport, Electric in Garage, Garage Door Opener
- Attached garage spaces: 2.5
- Has carport: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Patio, Porch
- Exterior features: Lawn Sprinkler
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Lake Front, Seawall, Waterfront
- Body of water: Lake
- Frontage type: Road
- Frontage length: 134
Lot
- Size: 0.38 Acres
- Dimensions: 71+63 x 196 x 52 x 187
Details
- Parcel number: 230708253005
- Special conditions: Private
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Brick, Wood Siding
- Foundation: Basement
Condition
- New construction: No
- Year built: 1965
Utilities & green energy
- Sewer: Septic Tank
- Water: Public
- Utilities for property: Cable/Internet Avail.
Community & HOA
Community
- Subdivision: Twilight Sub
HOA
- Has HOA: Yes
- HOA fee: $350 annually
- HOA name: Twilight Lake Assoc
- HOA phone: 586-339-4980
Location
- Region: Shelby Township
Financial & listing details
- Price per square foot: $155/sqft
- Tax assessed value: $382,000
- Annual tax amount: $5,266
- Date on market: 3/6/2026
- Cumulative days on market: 21 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional,FHA,VA Loan
- Road surface type: Paved
Estimated market value
$572,300
$544,000 - $601,000
$2,971/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 3/10/2026 | Pending sale | $569,000$155/sqft |
Source: | ||
| 3/8/2026 | Listed for sale | $569,000+86.6%$155/sqft |
Source: | ||
| 3/13/2020 | Sold | $305,000-1.6%$83/sqft |
Source: | ||
| 2/4/2020 | Pending sale | $310,000$84/sqft |
Source: RE/MAX Suburban, Inc. #50002493 Report a problem | ||
| 1/25/2020 | Price change | $310,000-4.6%$84/sqft |
Source: RE/MAX Suburban, Inc. #50002493 Report a problem | ||
| 1/8/2020 | Price change | $324,900-3%$88/sqft |
Source: RE/MAX Suburban, Inc. #50002493 Report a problem | ||
| 12/28/2019 | Listed for sale | $334,900+15.3%$91/sqft |
Source: RE/MAX Suburban, Inc. #50002493 Report a problem | ||
| 10/18/2004 | Sold | $290,500$79/sqft |
Source: | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $5,266 +4.4% | $191,000 +4.9% |
| 2024 | $5,044 +5.5% | $182,100 +8.7% |
| 2023 | $4,783 +3.1% | $167,500 +6.8% |
| 2022 | $4,638 +43.2% | $156,800 +9% |
| 2021 | $3,238 | $143,800 +2.3% |
| 2020 | $3,238 +10.1% | $140,500 +12.4% |
| 2019 | $2,940 +3.1% | $125,000 +5.2% |
| 2018 | $2,852 +2.2% | $118,800 +4.2% |
| 2017 | $2,791 | $114,050 |
| 2016 | $2,791 | $114,050 +4.3% |
| 2015 | $2,791 | $109,400 |
| 2012 | -- | -- |
| 2009 | -- | -- |
| 2001 | $2,570 +3.5% | $92,740 +3.2% |
| 2000 | $2,483 | $89,870 |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$3,510/mo
Principal & interest
$2855
Property taxes
$626
HOA Fees
$29
More affordability tools
Climate risks
Neighborhood: 48316
Nearby schools
GreatSchools rating
- 6/10Switzer Elementary SchoolGrades: PK-6Distance: 0.7 mi
- 6/10Malow Junior High SchoolGrades: 7-9Distance: 0.6 mi
- 9/10Eisenhower High SchoolGrades: 10-12Distance: 0.7 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.
Local experts in 48316
- Michigan
- Macomb County
- Shelby Township
- 48316
- 5100 Stellar Rd






