This home's estimate is 30.3% lower than the average sale price ($268K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
47405 Frederick, Shelby Charter Twp, MI 48317
About this home
Great buy in Shelby for a home w/ many updates, such as a brand new kitch w/ maple cabinets & built in appliances. Living room w/ natural fireplace, 1.5 updated baths, dining room, and a contemporary color scheme. The house is in need of some repairs & the buyer will assume responsibility for the septic system. Bank owned, sold as is, addendums to be signed upon acceptance. Room sizes are approximate. Some water damage & broken pipes.

Redfin Estimate
Market trends in 48317, MI
Last updated October 2026
Buyer's Market
Seller's Market
Seller's market
- OPEN TODAY, 12:30PM TO 4PM
See all
Provided by Redfin
Sale history for 47405 Frederick
$31/sq ft
$38/sq ft
As the MLS and public records start to fill up, we'll list the details here.
Public record
- Public record
- Zoning
R-1-C
One-Family Residential District
The One-Family districts are established to provide principally for one-family dwellings at varying densities. The specific interest of these districts is to encourage the construction and continued use of one-family dwellings and to prohibit the use of the land which would substantially interfere with the development of one -family dwellings and to discourage any land use which, because of its character and size, would create requirements and costs for public services substantially in excess of those at the specified densities and to discourage any land use which would generate excessive traffic on local streets.Include but are not limited to:
- Agriculture
- Housing-Single unit
- Cemetery
Property details
Parking
- Parking/Garage Information
- Has Garage
- # of Parking Spaces in Garage: 2
- Garage Type: Attached Garage
Interior
- Interior Features
- # of Rooms (Total): 7
- Rooms: PrimaryBdrm Lavatory
- Appliances: Dishwasher, Disposal, Microwave, Range/Oven, Refrigerator
- Has Fireplace
- Fireplace Features: Livingroom Fireplace
- Bedroom Information
- Bedroom 1 Level: Entry
- Bedroom 1 Dimensions: 10 x 15
- Bedroom 2 Level: Entry
- Bedroom 2 Dimensions: 11 x 8
- Bedroom 3 Level: Entry
- Bedroom 3 Dimensions: W=8
- Bathroom Information
- # of Lavatories: 1
- # of Bathrooms (Full): 1
- # of Baths/Lavatories (Total): 2
- Dining/Kitchen Information
- Kitchen Level: Entry
- Kitchen Dimension: 10 x 13
- Dining Room Level: Entry
- Dining Room Dimension: 10 x 13
- Library/Den/Living Room Information
- Living Room Level: Entry
- Living Room Dimensions: 15 x 19
- Laundry/Basement Information
- Laundry Room Level: Entry
- Laundry Room Dimensions: 6 x 7
Exterior
- Exterior Features
- Exterior Features: Deck, Fenced Yard
- Foundation Type: Crawl
- Property Information
- Property Type: Residential
- Structure Style: 1 Story
- Year Built: 1950
- Lot Information
- Lot Size: 40,140
- Land Information
- Acreage: 0.14
- Roads: Paved Street
Financial
- Tax/Assessments Information
- Total Tax Year: 2007
- Total Tax Amount: $3,936
- Summer Tax Year: 2007
- Summer Tax Amount: $1,737
- Winter Tax Year: 2007
- Winter Tax Amount: $2,199
Utilities
- Utility Information
- Heat/Fuel Type: Natural Gas
- Water: Public Water
- Heating System: Forced Air, Hot Water
- Sewer Septic: Septic
Location
- Unit 5 Information
- Living Room Dimensions: L=1316
- School Information
- School District: Utica Community Schools
- School District: Utica Community Schools
- Location Details
- Municipality: Shelby Twp
- Mail City: Update
- Subdivision: SUNSET FARMS
- Municipality: Shelby Twp
- Area (Municipality): Shelby Twp (50007)
Public facts
- Beds: —
- Baths: —
- Sq. Ft.: —
- Stories: —
- Lot Size: —
- Style: Single Family Residential
- Year Built: —
- Year Renovated: —
- County: Macomb County
- APN: —
Other
- Listing Information
- Originating MLS: MiRealSource
- Originating MLS: MI Real Source
Around this home
Schools
- K - 12
- Preschool & daycare
Public PreK-6 • Assigned • 2.6mi
Public 7-9 • Assigned • 2.0mi
Public 9-12 • Assigned • 1.4mi
Lifestyle
Provided by Walk Score and Local Logic
Sun exposure
In this area, properties receive around 9.3 hours in June and 2.5 hours in December, placing it below the U.S. average for solar exposure.
Sell confidently with a local market expert in Shelby Charter Twp. 3 minutes to get started.
Nearby similar homes




New listings for sale in 48317








Home values near 47405 Frederick
| Address | Redfin Estimate |
|---|---|
3 Beds | 1 Baths | 2067 Sq. Ft. | $295,418 |
3 Beds | 1.5 Baths | 1140 Sq. Ft. | $286,545 |
3 Beds | 2 Baths | 1200 Sq. Ft. | $264,460 |
3 Beds | 1 Baths | 1000 Sq. Ft. | $192,627 |
3 Beds | 1 Baths | 992 Sq. Ft. | $275,623 |
- Beds | 1 Baths | 1539 Sq. Ft. | $285,398 |
2 Beds | 1 Baths | 900 Sq. Ft. | $202,997 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 1.5 Baths | 1504 Sq. Ft. | $276,296 |
3 Beds | 1 Baths | 1600 Sq. Ft. | $251,674 |
3 Beds | 1 Baths | 702 Sq. Ft. | $198,060 |
3 Beds | 1 Baths | 1050 Sq. Ft. | $238,466 |
2 Beds | 1 Baths | 1119 Sq. Ft. | $193,543 |
2 Beds | 2 Baths | 1261 Sq. Ft. | $385,025 |
3 Beds | 2 Baths | 2856 Sq. Ft. | $315,122 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 2 Baths | 2400 Sq. Ft. | $322,458 |
3 Beds | 1.5 Baths | 2400 Sq. Ft. | $272,501 |
3 Beds | 1 Baths | 1395 Sq. Ft. | $235,769 |
2 Beds | 2 Baths | 1261 Sq. Ft. | $382,696 |
3 Beds | 2 Baths | 1200 Sq. Ft. | $260,004 |
3 Beds | 1.5 Baths | 922 Sq. Ft. | $251,919 |
4 Beds | 2 Baths | 1450 Sq. Ft. | $297,338 |
More real estate resources
- Zip Codes
- Cities
- Minor Civil Divisions
- Popular Searches
| 48313 homes for sale | |||
| 48314 homes for sale | |||
| 48315 homes for sale | |||
| 48317 homes for sale |
| Detroit homes for sale | |||
| Royal Oak homes for sale | |||
| Troy homes for sale |
| Shelby Township homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.
Do not sell or share my personal information.
REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.
California DRE #01521930
Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures
New Mexico Real Estate Licenses
TREC: Info About Brokerage Services, Consumer Protection Notice
All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.
Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.
If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.
REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.







































United States
Canada