Off market dec 2003 for $166K

$271,418

•

1,200

sq ft

47210 Frederick, Shelby Twp, MI 48317

About this home

Single-familyProperty Type

1997Year Built

$226Est. Price/Sq.Ft.

Listed by Jeff Todd • Century 21 Town & Country-Rochester

•248-652-8000 (broker)

•johngoings@topproducer.com (broker)

Bought with Jeff Todd • Century 21 Town & Country-Rochester

•248-652-8000 (broker)

•johngoings@topproducer.com (broker)

Redfin checked: a minute ago

•Source:MiRealSource-MiMLS #562591

Redfin Estimate

$271,418

$105K since sold in December 2003$4,000 since September

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 11.9% lower than the average sale price ($308K) of 6 comparable homes.

SOLD FEB 18, 2026
$397,000
A
3 beds2 baths1,797 sq ft
2470 Durham Rd, Shelby Township, MI 48317 2725
SOLD AUG 6, 2026
$390,000
B
3 beds2 baths1,450 sq ft
46362 Springhill Dr, Shelby Township, MI 48317 4056
SOLD JUL 21, 2026
$315,000
C
3 beds2 baths1,008 sq ft
2830 Hessel Ave, Rochester Hills, MI 48307 4830
SOLD BY REDFIN SEP 15, 2026
$261,000
D
3 beds1 bath1,154 sq ft
47473 Woodall Rd, Shelby Township, MI 48317
SOLD AUG 24, 2026
$235,000
E
3 beds1 bath1,023 sq ft
47473 Greenview Rd, Shelby Township, MI 48317
SOLD OCT 9, 2026
$250,000
F
3 beds1 bath980 sq ft
2444 Howe St, Shelby Township, MI 48317 3656

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$206,754

Est. take-home

List your home with Redfin and save $2,714

Rent

$2,268/mo

Redfin rental estimate

List your home for rent

Market trends in 48317, MI

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

99.9%

0.1% MoM

Median sale price

$302K

$2K MoM

Avg. days on market

22d

2 days MoM

Recently sold homes

1 MoM

New listings for sale

COMING SOON
$300,000
3 beds1.5 baths2,503 sq ft
8422 21 Mile Rd, Shelby Township, MI 48317
(269) 600-4397
$55,000
1 bed1 bath610 sq ft
11497 Pinewood Dr, Utica, MI 48317
(248) 218-2604
$245,000
2 beds2 baths1,342 sq ft
11351 N Woods Dr, Shelby Township, MI 48317 1853
(248) 629-0791
$499,900
3 beds2.5 baths3,492 sq ft
48540 Lindon Ct, Shelby Township, MI 48317
(810) 636-9172
$255,000
3 beds2 baths2,119 sq ft
45062 Custer Ave, Utica, MI 48317 5700
(586) 776-4242
$219,900
3 beds1.5 baths2,482 sq ft
48280 Rex St, Shelby Township, MI 48317 2250
(586) 799-8000
3D WALKTHROUGH
$339,000
3 beds2 baths2,462 sq ft
46746 Schimmel Ct, Shelby Township, MI 48317 3879
(248) 288-3500
$269,900
2 beds1 bath1,137 sq ft
7324 Powers Ct, Shelby Township, MI 48317 2435
(810) 630-6652
$94,000
3 beds1.5 baths1,600 sq ft
45168 Kensington St, Utica, MI 48317
(586) 792-8000
$79,000
2 beds1.5 baths1,450 sq ft
45186 Kensington St, Utica, MI 48317
(248) 813-4900
See all

Provided by Redfin

Sale history for 47210 Frederick

Date

Event

Price

MiRealSource-MiMLS #562591

Dec 3, 2003

Sold

$166,500

$139/sq ft

Nov 3, 2003

Listing Removed

—

Aug 22, 2003

Listed

$169,900

$142/sq ft

MiRealSource-MiMLS #522228

Jul 13, 2001

Sold

$147,500

$123/sq ft

Jun 14, 2001

Listing Removed

—

May 31, 2001

Listed

$149,900

$125/sq ft

Public record

Public record
Zoning

Beds

—

Baths

—

Stories

—

Lot width

—

Lot depth

—

Lot size

—

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Single Family Residential

County

Macomb County

APN

729353054

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Sep 25, 2023.

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.

Permitted uses

Include but are not limited to:

Agriculture
Housing-Single unit
Cemetery

Property details

Interior

Interior Features
# of Rooms (Total): 5
Rooms: First Floor Mstr Bedroom
Appliances: Dishwasher, Disposal, Range/Oven, Refrigerator

Bedroom Information
Bedroom 1 Level: Entry
Bedroom 1 Dimensions: 15 x 12
Bedroom 2 Level: Entry
Bedroom 2 Dimensions: 10 x 10
Bedroom 3 Level: Entry
Bedroom 3 Dimensions: W=10

Bathroom Information
# of Bathrooms (Full): 2
# of Baths/Lavatories (Total): 2

Dining/Kitchen Information
Kitchen Level: Entry
Kitchen Dimension: 15 x 12

Library/Den/Living Room Information
Living Room Level: Entry
Living Room Dimensions: 18 x 14

Laundry/Basement Information
Basement : Has Basement

Exterior

Exterior Features
Exterior Construction: Vinyl Siding, Vinyl Trim
Exterior Features: Deck, Fenced Yard, Patio
Foundation Type: Basement

Property Information
Out Buildings: Shed
Property Type: Residential
Structure Style: 1 Story
Year Built: 1997

Lot Information
Lot Size: 6,060,147,147

Land Information
Roads: Paved Street
Frontage: 60

Financial

Tax/Assessments Information
Total Tax Amount: $2,264
Summer Tax Amount: $742
Winter Tax Amount: $1,522

Utilities

Utility Information
Heat/Fuel Type: Natural Gas
Water: Public Water
Cooling System: Central A/C
Heating System: Forced Air
Sewer Septic: Septic

Location

Unit 5 Information
Living Room Dimensions: L=1200

School Information
School District: Utica Community Schools
School District: Utica Community Schools

Location Details
Municipality: Shelby Twp
Mail City: Update
Township: Shelby Township
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: 729353054

Home facts updated by county records on Sep 25, 2023

Other

Listing Information
Originating MLS: MiRealSource
Originating MLS: MI Real Source

Around this home

Schools

Roberts Elementary School

Public PreK-6 • Assigned • 2.7mi

7/10

Eppler Junior High School

Public 7-9 • Assigned • 1.9mi

6/10

Utica High School

Public 9-12 • Assigned • 1.4mi

9/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

2/10 Heat Factor

7 days above 97° expected this year, 15 days in 30 years

1/10 Wind Factor

Minimal risk of severe winds over next 30 years

3/10 Air Factor

3 unhealthy days expected this year, 4 days in 30 years

Provided by First Street

Historical weather

Shelby Twp, MI • 48317

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

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.

9.3 hrs

2.5 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$258,000 – $313,000

Reach more buyers when you sell with Redfin. Save up to $2,714 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

$256,000

3 beds1 bath1,053 sq ft

47630 Winthrop St, Shelby Township, MI 48317-2969

(586) 783-7888

$219,900

3 beds1.5 baths2,482 sq ft

48280 Rex St, Shelby Township, MI 48317 2250

(586) 799-8000

$489,000

3 beds2.5 baths3,154 sq ft

47260 Dequindre Rd, Shelby Township, MI 48317 8317

(586) 229-1500

$319,900

4 beds2 baths2,156 sq ft

3255 Hessel Ave, Rochester Hills, MI 48307

(586) 532-5500

$699,900

4 beds3.5 baths4,390 sq ft

1781 S Shore Dr, Rochester Hills, MI 48307 4345

(248) 415-5514

$450,000

4 beds2 baths2,452 sq ft

50290 Mile End Dr, Shelby Township, MI 48317

New listings for sale in 48317

COMING SOON

$300,000

3 beds1.5 baths2,503 sq ft

8422 21 Mile Rd, Shelby Township, MI 48317

(269) 600-4397

$55,000

1 bed1 bath610 sq ft

11497 Pinewood Dr, Utica, MI 48317

(248) 218-2604

$245,000

2 beds2 baths1,342 sq ft

11351 N Woods Dr, Shelby Township, MI 48317 1853

(248) 629-0791

$499,900

3 beds2.5 baths3,492 sq ft

48540 Lindon Ct, Shelby Township, MI 48317

(810) 636-9172

$255,000

3 beds2 baths2,119 sq ft

45062 Custer Ave, Utica, MI 48317 5700

(586) 776-4242

$219,900

3 beds1.5 baths2,482 sq ft

48280 Rex St, Shelby Township, MI 48317 2250

(586) 799-8000

3D WALKTHROUGH

$339,000

3 beds2 baths2,462 sq ft

46746 Schimmel Ct, Shelby Township, MI 48317 3879

(248) 288-3500

$269,900

2 beds1 bath1,137 sq ft

7324 Powers Ct, Shelby Township, MI 48317 2435

(810) 630-6652

$94,000

3 beds1.5 baths1,600 sq ft

45168 Kensington St, Utica, MI 48317

(586) 792-8000

Home values near 47210 Frederick

Data from public records.

Address	Redfin Estimate
47405 Frederick Rd, Shelby Charter Twp, MI 3 Beds \| 1.5 Baths \| 1316 Sq. Ft.	$190,528
47194 Frederick Rd, Shelby Township, MI 3 Beds \| 1.5 Baths \| 1504 Sq. Ft.	$281,594

Address	Redfin Estimate
47150 Frederick Rd, Shelby Township, MI 3 Beds \| 1 Baths \| 980 Sq. Ft.	$234,058
47404 Frederick Rd, Shelby Township, MI 3 Beds \| 2 Baths \| 1404 Sq. Ft.	$329,280

Address	Redfin Estimate
47231 Frederick Rd, Shelby Township, MI 3 Beds \| 1 Baths \| 2067 Sq. Ft.	$304,671
47230 Frederick Rd, Shelby Township, MI 3 Beds \| 1 Baths \| 1100 Sq. Ft.	$256,391

Property information provided by MiRealSource-MiMLS when last listed in 2003. This data may not match . Learn more.

More real estate resources

Zip Codes
Minor Civil Divisions
Cities
Popular Searches

48313 homes for sale
48314 homes for sale
48315 homes for sale
48317 homes for sale

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

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.

GreatSchools Ratings provided by GreatSchools.org.

Houses for rent in Utica	Agents near me	Livonia, MI homes for sale	Utica Housing Market
Houses for sale near me	Detroit, MI homes for sale	Royal Oak, MI homes for sale
Land for sale near me	Ann Arbor, MI homes for sale	Novi, MI homes for sale
Open Houses near me	Grand Rapids, MI homes for sale	Utica Property Records
Condos for sale near me	Troy, MI homes for sale	MI New Listings

Detroit homes for sale
Royal Oak homes for sale
Troy homes for sale