Google street view image for 47404 FREDERICK Rd, Shelby Township, MI 48317 2808

Off market mar 2023 for $305K

$329,280

Est. refi paymentEst. refi $1,166/mo

•

1,404

sq ft

47404 FREDERICK Rd, Shelby Township, MI 48317 2808

About this home

Come check out this beautiful three bedroom Shelby Twp. ranch with a master suite! With three bedrooms, two full bathrooms, finished basement, and 2.5 car detached garage, this home has it all! This open concept home has a gorgeous new kitchen including white shaker cabinets with 36" uppers, soft close doors/drawers, step-crown molding, quartz countertops, white marble subway style backsplash, huge island with center stove and range hood, pantry, and brand new appliances included with the sale! The master suite bathroom has a 72" double sink vanity with marble top, huge custom tile shower with spray jets and body wand, and all new fixtures. The large walk-in closet has custom shelving and recessed lighting. The secondary bath has a new tub, white subway surround with custom recessed niche, and casablanca patterned tile floor. It also has a new vanity, toilet, and fixtures. New recessed lighting installed throughout the home, as well as premium Luxury Vinyl Plank flooring just installed throughout the entire main floor. The living room contains a custom stacked stone accent wall with 60" linear fireplace and floating shelves. Newer windows, mechanicals, and roof make this a move in ready house with immediate occupancy!!!

Single-familyProperty Type

1941Year Built

0.27 acresLot Size

$235Est. Price/Sq.Ft.

2 car garageParking

Listed by Scott Lucas • RE/MAX First

•586-792-8000 (broker)

Bought with Michele Youngblood • Next Level Realty Rochester

•248-764-0374 (broker)

•ebroesamle@gmail.com (broker)

Redfin checked: 2 minutes ago

•Source:MiRealSource-MiMLS #60191183

Redfin Estimate

$329,280

$24K since sold in March 2023$13K since September

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 22.3% higher than the average sale price ($269K) of 6 comparable homes.

SOLD OCT 8, 2026
$265,000
A
3 beds2 baths2,528 sq ft
3003 Longview Ave, Rochester Hills, MI 48307 5573
SOLD JUN 30, 2026
$225,000
B
3 beds2 baths1,517 sq ft
2640 Melvin Ave, Rochester Hills, MI 48307 4850
SOLD DEC 5, 2025
$290,000
C
3 beds2 baths1,650 sq ft
47595 Frederick Rd, Shelby Township, MI 48317 2811
SOLD BY REDFIN SEP 15, 2026
$261,000
D
3 beds1 bath1,154 sq ft
47473 Woodall Rd, Shelby Township, MI 48317
SOLD AUG 13, 2026
$288,000
E
3 beds2 baths1,631 sq ft
48023 Rex St, Shelby Township, MI 48317 2247
SOLD JUN 3, 2026
$287,000
F
3 beds2 baths1,590 sq ft
3024 Longview Ave, Rochester Hills, MI 48307 5567

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

Earn from this home

Sell

$80,295

Est. take-home

List your home with Redfin and save $3,293

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$2,259/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 47404 FREDERICK Rd

Date

Event

Price

MiRealSource-MiMLS #60191183

Mar 24, 2023

Sold

$305,000

$217/sq ft

Feb 19, 2023

Pending

—

Feb 16, 2023

Listed

$289,900

$206/sq ft

REALCOMP #20230011221

Mar 24, 2023

Sold

$305,000

$217/sq ft

Feb 19, 2023

Pending

—

Feb 16, 2023

Listed

$289,900

$206/sq ft

Public Records

Dec 5, 2003

Sold

$168,000

$120/sq ft

MiRealSource-MiMLS #426505

Apr 23, 1996

Sold

$115,000

$82/sq ft

Mar 18, 1996

Listing Removed

—

Jan 25, 1996

Listed

$119,900

$85/sq ft

Public Records

Nov 9, 1992

Sold

$89,000

$63/sq ft

Tax history for 47404 FREDERICK Rd

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Public record
Zoning

Beds

Baths

Stories

Lot width

—

Lot depth

—

Lot size

0.27 Acres

Year renovated

—

Sq. Ft.

1,404

Year built

1941

Style

Single Family Residential

County

Macomb County

APN

23-07-29-307-043

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Aug 13, 2026.

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

Parking

Parking/Garage Information
Has Garage
# of Parking Spaces in Garage: 2.5
Garage Type: Detached Garage

Interior

Interior Features
# of Rooms (Total): 5

Bedroom Information
Bedroom 1 Level: Entry
Bedroom 1 Dimensions: 15 x 13
Bedroom 1 Floor Covering: Vinyl
Bedroom 1 Floor Covering: Vinyl
Bedroom 2 Level: Entry
Bedroom 2 Dimensions: 13 x 12
Bedroom 2 Floor Covering: Vinyl
Bedroom 3 Level: Entry
Bedroom 3 Dimensions: W=12
Bedroom 3 Floor Covering: Vinyl

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

Bathroom 1 Information
Bathroom 1 Floor Covering: Ceramic
Bathroom 1 Level: Entry
Bathroom 1 Length: 8
Bathroom 1 Width: 5

Laundry/Basement Information
Basement : Has Basement
Basement Type: Finished

Exterior

Exterior Features
Exterior Construction: Vinyl Siding
Exterior Features: Porch
Foundation Type: Basement

Property Information
Property Type: Residential
Structure Style: 1 Story
Year Built: 1941
Below Grade Sq. Ft.: 996
Below Grade Sq. Ft. (Finished): 996

Land Information
Land Contract: No
Acreage: 0.27
Roads: Paved Street
Frontage: 80

Financial

Tax/Assessments Information
Taxable Value: $56,903
Total Tax Amount: $1,723
Summer Tax Amount: $1,030
Winter Tax Amount: $693

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=2400

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

Address Information
Street Designation: Road

Location Details
Directions: N on Ryan from Auburn Rd, turn right onto Howe St. Home is NE corner of Howe/Frederick.
Municipality Type: Township
Municipality: Shelby Twp
Mail City: Shelby Twp
Subdivision: S/P SUNSET FARMS
Municipality: Shelby Twp
Area (Municipality): Shelby Twp (50007)

Public facts

Beds: 3
Baths: 2.0
Sq. Ft.: 1,404
Stories: 1.0
Lot Size: 0.27 acres
Style: Single Family Residential
Year Built: 1941
Year Renovated: —
County: Macomb County
APN: 23-07-29-307-043

Home facts updated by county records on Aug 13, 2026

Other

Listing Information
Originating MLS: RealComp
No

Around this home

Schools

Roberts Elementary School

Public PreK-6 • Assigned • 2.6mi

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 Township, MI • 48317 2808

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

$313,000 – $379,000

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

Need the cash from your home fast? Sell to .

Nearby similar homes

$319,900

4 beds2 baths2,156 sq ft

3255 Hessel Ave, Rochester Hills, MI 48307

(586) 532-5500

$458,000

3 beds2.5 baths2,944 sq ft

49720 E Central Park, Shelby Twp, MI 48317

(586) 598-1400

$219,900

3 beds1.5 baths2,482 sq ft

48280 Rex St, Shelby Township, MI 48317 2250

(586) 799-8000

$550,000

4 beds2.5 baths2,546 sq ft

49385 Central Park Park E, Shelby Twp, MI 48317

$260,000

3 beds1 bath2,210 sq ft

47051 Burton Dr, Shelby Township, MI 48317 3301

(248) 733-5811

$313,000

3 beds2 baths1,467 sq ft

45440 Wakefield St, Shelby Township, MI 48317

(586) 949-0200

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 47404 FREDERICK Rd

Data from public records.

Address	Redfin Estimate
47405 Frederick Rd, Shelby Charter Twp, MI 3 Beds \| 1.5 Baths \| 1316 Sq. Ft.	$190,528
47454 Frederick Rd, Shelby Township, MI 3 Beds \| 1.5 Baths \| 1140 Sq. Ft.	$293,238

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

Address	Redfin Estimate
47194 Frederick Rd, Shelby Township, MI 3 Beds \| 1.5 Baths \| 1504 Sq. Ft.	$281,594
47210 Frederick Rd, Shelby Township, MI 3 Beds \| 1.5 Baths \| 1200 Sq. Ft.	$278,364

Property information provided by MiRealSource-MiMLS when last listed in 2023. 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