Off Market1097d on market
47841 Frederick Rd
Shelby Township, MI, 48317 • 48317 • Macomb County
$306,000
$214/sqft
3Beds
3Baths
1,428Sqft
0.38 acLot
1944Built
Property DNA
Ranch Style
Built 1944 · 82 years of history
S/P SUNSET FARMS # 01
48317
Outdoor Living
Porch
1-Car Garage
One Car Garage · Attached
This home is getting attention
Listed 1097 days ago · 6 views
Market activity
Demand and pricing signals for this listing
6 views
People checking out this listing
1097 days on market
Established listing
$214/sqft
Price per square foot
Selling Soon Prediction
ModerateThis home ranks in the top 49% of listings most likely to go under contract soon, based on market activity and demand signals.
Likelihood score
Want the full market analysis?
Get the detailed selling prediction score, comparable sales data, and price trend forecast for this property.
Free · Delivered to your inbox in minutes
About this home
Single Family · Built 1944
This beautiful home in Shelby township is completely move in ready, it’s just waiting for your finishing touch! This fully remodeled home has three bedrooms including a master, two and a half bathrooms, new flooring throughout, recessed lightning, and a beautiful brand new kitchen complete with stunning quartz countertops! With an attached garage with a mud room and a wood burning fireplace to keep you cozy in these coming winter months! Sellers are offering a $15,000.00 rate buy down with an offer at 250k
Standout features identified
Our analysis highlights new flooring throughout, fully remodeled home, and mud room as key attractions of this home.
Estimated monthly payment
Based on current rates
$1,919/month
Principal & Interest$1,511
Property Tax$306
Insurance$102
Down payment20% ($61,200)
3%50%
Est. 6.28% rate · 30yr fixed · $244,800 loan
Full calculator →At a glance
Key facts and listing details
TypeSingle Family Residence
Year Built1944
HeatingForced Air, Natural Gas
Parking1 Garage space
Lot0.38 Acres
Property
Home typeSingle Family
Sub-typeSingle Family Residence
StyleRanch
Year built1944
Stories1
Systems
HeatingForced Air, Natural Gas
ConstructionVinyl Siding
Water / SewerPublic / Septic Tank
Parking & Outdoor
ParkingOne Car Garage, Attached
Garage1 spaces
Lot0.38 Acres
Location & Tax
Neighborhood48317
Annual tax$1,723
Parcel230729302022
Bathrooms & Fees
Full baths3
Features & details
5 categories of property features
Interior Features
Heating
Forced Air
Natural Gas
Exterior Features
Parking
One Car Garage
Attached
Construction
Vinyl Siding
Patio & Porch
Porch
Pool Features
None
Listing insights
Market data and value estimates
StatusOff Market
Days on market1097
Est. value$306,000
Est. rent$2,321/mo
Tax rate1.32%
Price/sqft$214
On marketSep 1, 2022
PostedOct 31, 2024
Last sold$250,000
MLS updatedMar 12, 2024
Tour days6
Views6
How are the schools in Shelby Township?
3 schools rated nearby
Location
Shelby Township, MI, 48317
Price history
28 events
DateEventPrice$/sqftSource
Apr 5, 2023Sold$250,000$175Realcomp II
Apr 5, 2023Pending Sale$250,000$175Realcomp II
Mar 3, 2023Price Change$250,000$175Realcomp II
Feb 27, 2023Listed For Sale$230,000$161Realcomp II
Feb 19, 2023Pending Sale$230,000$161Realcomp II
Feb 16, 2023Listed For Sale$230,000$161Realcomp II
Feb 14, 2023Pending Sale$230,000$161Realcomp II
Feb 1, 2023Listed For Sale$230,000$161Realcomp II
Jan 17, 2023Listing Removed——Realcomp II
Jan 2, 2023Price Change$234,900$164Realcomp II
Nov 10, 2022Listed For Sale$250,000$175Realcomp II
Oct 24, 2022Pending Sale$250,000$175Realcomp II
Oct 4, 2022Price Change$250,000$175Realcomp II
Sep 1, 2022Listed For Sale$254,999$179Realcomp II
Aug 30, 2022Listing Removed——Realcomp II
Aug 19, 2022Price Change$269,899$189Realcomp II
Aug 4, 2022Price Change$269,900$189Realcomp II
Jul 29, 2022Price Change$274,500$192Realcomp II
Jul 23, 2022Price Change$284,800$199Realcomp II
Jul 13, 2022Price Change$284,900$200Realcomp II
Jul 10, 2022Price Change$289,900$203Realcomp II
Jul 5, 2022Price Change$299,990$210Realcomp II
Jul 2, 2022Listed For Sale$299,900$210Realcomp II
Mar 10, 2022Sold$126,500$89Public Record
Jan 24, 2022Pending Sale$144,900$101Realcomp II
Jan 11, 2022Price Change$144,900$101Realcomp II
Jan 4, 2022Listed For Sale$159,900$112Realcomp II
Mar 14, 2012Sold$55,000$39Public Record
Sold$250,000
Apr 5, 2023•$175/sqft•Realcomp II
Pending Sale$250,000
Apr 5, 2023•$175/sqft•Realcomp II
Price Change$250,000
Mar 3, 2023•$175/sqft•Realcomp II
Listed For Sale$230,000
Feb 27, 2023•$161/sqft•Realcomp II
Pending Sale$230,000
Feb 19, 2023•$161/sqft•Realcomp II
Listed For Sale$230,000
Feb 16, 2023•$161/sqft•Realcomp II
Pending Sale$230,000
Feb 14, 2023•$161/sqft•Realcomp II
Listed For Sale$230,000
Feb 1, 2023•$161/sqft•Realcomp II
Listing Removed—
Jan 17, 2023•Realcomp II
Price Change$234,900
Jan 2, 2023•$164/sqft•Realcomp II
Listed For Sale$250,000
Nov 10, 2022•$175/sqft•Realcomp II
Pending Sale$250,000
Oct 24, 2022•$175/sqft•Realcomp II
Price Change$250,000
Oct 4, 2022•$175/sqft•Realcomp II
Listed For Sale$254,999
Sep 1, 2022•$179/sqft•Realcomp II
Listing Removed—
Aug 30, 2022•Realcomp II
Price Change$269,899
Aug 19, 2022•$189/sqft•Realcomp II
Price Change$269,900
Aug 4, 2022•$189/sqft•Realcomp II
Price Change$274,500
Jul 29, 2022•$192/sqft•Realcomp II
Price Change$284,800
Jul 23, 2022•$199/sqft•Realcomp II
Price Change$284,900
Jul 13, 2022•$200/sqft•Realcomp II
Price Change$289,900
Jul 10, 2022•$203/sqft•Realcomp II
Price Change$299,990
Jul 5, 2022•$210/sqft•Realcomp II
Listed For Sale$299,900
Jul 2, 2022•$210/sqft•Realcomp II
Sold$126,500
Mar 10, 2022•$89/sqft•Public Record
Pending Sale$144,900
Jan 24, 2022•$101/sqft•Realcomp II
Price Change$144,900
Jan 11, 2022•$101/sqft•Realcomp II
Listed For Sale$159,900
Jan 4, 2022•$112/sqft•Realcomp II
Sold$55,000
Mar 14, 2012•$39/sqft•Public Record
Tax history
16 years of records
YearTax paidAssessed value
Apr 7, 2025$3,479$129,600
Apr 7, 2024$3,211$113,100
Apr 7, 2023$2,847$104,400
Apr 7, 2022$1,723$97,200
Apr 7, 2021$1,711$92,900
Apr 7, 2020$1,711$90,800
Apr 7, 2019$1,577$78,700
Apr 7, 2018$1,584$73,600
Apr 7, 2017$1,497$65,450
Apr 7, 2016$1,497$65,450
Apr 7, 2015$1,497$58,000
Apr 7, 2013$2,522$49,550
Apr 7, 2012——
Apr 7, 2009——
Apr 7, 2001$1,015$36,610
Apr 7, 2000$980$35,480
Nearby homes
Neighborhood details
Local context around this listing
Shelby Township, MI • Macomb County
Nearby cities
ChesterfieldClinton TownshipEastpointeMacombRosevilleSaint Clair ShoresShelby TownshipSterling Heights
Nearby zip codes
48315483164831748318
Similar homes
IDX provided courtesy of Realcomp II Ltd. via Zillow, Inc and MLS 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 as recently as 2026-02-06 15:35:30 PST Listing Information presented by local MLS brokerage: Zillow, Inc., REALTOR®- Lauren Buttazzoni - (313) 479-2702
No obligation · Same-day response