404 Hilton RD # 104 Rd, Ferndale, MI 48220

Off market jul 2021 for $220K

$263,188

•

1,369

sq ft

404 Hilton RD # 104 Rd, Ferndale, MI 48220

About this home

Location, location, location! Be in the mix of it all with this stunning loft over looking the hilton cooridor in Ferndale. This tastefully decorated and designed condo features tons of natural light, vaulted ceiling great room that has an easy walkout to the second floor balcony. Open floor plan with a large kitchen, newer cabinets, private bath for each room and new carpet throughout. Spacious carpeted master suite with an en-suite the bath and walk-in closet. Large two car garage with fresh paint throughout! Be apart of the new Hilton Cooridor growth just steps away from Amazons newest development center!

CondoProperty Type

2006Year Built

$192Est. Price/Sq.Ft.

2 car garageParking

Listed by Paul Loos • KW Professionals

Bought with Pamela Stout • Real Estate One-Troy

Redfin checked: a few seconds ago

•Source:REALCOMP #2210036925

Listing provided courtesy of Realcomp MLS

Redfin Estimate

$263,188

$43K since sold in July 2021$13K since September

Recently sold homes
Estimate history
Homes for sale

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

SOLD JUL 13, 2026
$397,000
A
2 beds2 baths1,500 sq ft
211 E E 9 Mile Road Rd #313, Ferndale, MI 48220
SOLD JUL 13, 2026
$397,000
B
2 beds2 baths1,500 sq ft
211 E E 9 Mile Road Rd #313, Ferndale, MI 48220 1968
SOLD JUL 24, 2026
$318,500
C
2 beds2.5 baths1,364 sq ft
1513 Anne Dr, Royal Oak, MI 48067 4537
SOLD AUG 26, 2026
$335,000
D
2 beds2 baths1,450 sq ft
1250 DIAMOND Ct Unit E, Royal Oak, MI 48067 3743
SOLD SEP 11, 2026
$375,000
E
2 beds2 baths1,459 sq ft
1240 S Diamond Ct Unit C, Royal Oak, MI 48067 3158
SOLD AUG 31, 2026
$350,000
F
2 beds2 baths1,154 sq ft
101 Curry Ave #620, Royal Oak, MI 48067

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

Earn from this home

Sell

$87,996

Est. take-home

List your home with Redfin and save $2,632

Rent

$2,254/mo

Redfin rental estimate

List your home for rent

Market trends in 48220, MI

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

99.9%

0.4% MoM

Median sale price

$270K

$5K MoM

Avg. days on market

23d

2 days MoM

Recently sold homes

167

7 MoM

New listings for sale

NEW 31 HRS AGO
$284,900
3 beds2 baths1,168 sq ft
235 Flowerdale Street St, Ferndale, MI 48220 1875
(248) 457-4572
$210,000
2 beds1 bath1,174 sq ft
1493 Browning St, Ferndale, MI 48220 1101
(248) 238-8211
$219,900
2 beds1 bath1,060 sq ft
2289 Hamata St, Ferndale, MI 48220 1549
(586) 330-9755
LISTED BY REDFIN
$269,000
3 beds2 baths938 sq ft
2140 Brickley St, Ferndale, MI 48220
$208,000
2 beds1 bath1,407 sq ft
830 Channing St, Ferndale, MI 48220 3513
(248) 453-7454
$225,000
3 beds1 bath1,154 sq ft
3245 Kenwood St, Ferndale, MI 48220 1130
(734) 459-4700
$260,000
3 beds2 baths1,610 sq ft
3275 Kenwood St, Ferndale, MI 48220 1132
(248) 733-5811
$345,000
3 beds2 baths1,900 sq ft
1665 W Troy St, Ferndale, MI 48220 3158
(248) 733-5811
$159,000
3 beds1 bath1,716 sq ft
20785 Mendota Ave, Ferndale, MI 48220 2155
(248) 813-4900
$249,000
4 beds2 baths1,579 sq ft
455 E Lewiston Ave, Ferndale, MI 48220 1379
(248) 644-6700
See all

Provided by Redfin

Sale history for 404 Hilton RD # 104 Rd

Public record

Public record
Zoning

Beds

—

Baths

—

Stories

—

Lot width

—

Lot depth

—

Lot size

—

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Condo/Co-op

County

Oakland County

APN

2535356004

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jun 12, 2025.

MXD-2

Corridor Mixed Use District

To accommodate commercial and other uses along the City’s major transportation corridors often served by transit and to promote development that is comfortably accessible via all modes of transportation, including bicycles, and walking. Commercial uses in the MXD-2 District may be somewhat larger in scale and more intense than the MXD-1 District. While the ground floors along streets are intended for commercial uses, the upper stories are designed to accommodate residential and or office uses. This district discourages undesirable strip commercial development and the concentration of larger scale, auto-oriented uses such as drive-thru facilities.

Permitted uses

Include but are not limited to:

Bank
Day care facility
Laundromat
General retail
Retail-Grocery
Restaurant
Tavern / bar / nightclub / micro-Brewery
Hotel / motel
Mixed use building
Office

Property details

Parking

Parking/Garage Information
# of Parking Spaces Total: 2
Has Garage
Has Attached Garage
# of Garage Spaces: 2
Parking Features: Attached

Interior

Bathroom Information
# of Full Bathrooms: 2

Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Forced Air, Natural Gas

Interior Features
Appliances: Gas Water Heater, Dishwasher, Disposal, Dryer, Free-Standing Electric Oven, Free-Standing Refrigerator, Microwave, Washer
Flooring: Carpet, Laminate

Room Information
# of Rooms Total: 6

Exterior

Exterior Features
Exterior Features: Balcony
Patio And Porch Features: Covered, Porch
Roof: Asphalt

Pool Information
Pool Features: None

Building Information
Entry Location: GroundLevel
Above Grade Finished Area: 1,369
Above Grade Finished Area Units: Square Feet
Construction Materials: Block
Foundation Details: Block, Slab

Property Features
Pets Allowed: Yes

Property Information
Property Type: Residential
Property Sub Type: Condominium
Raw Mls Property Sub Type: Condominium

Lot Information
Road Surface Type: Paved

Financial

Tax Information
Tax Annual Amount: $4,406

Utilities

Utility Information
Water Source: Public
Sewer: Public Sewer

Location

HOA Information
Has Homeowners Association
Association Amenities: Maintenance Grounds
Association Fee: $202
Association Fee Frequency: Monthly
Derived Association Fee (Monthly): $202
Association Fee Includes: Maintenance Grounds

Schools Information
High School District: Ferndale

Location Information
Directions: ON Hilton
Subdivision Name: WEBSTER PLACE CONDO OCCPN 1892
Cross Street: S of Nine Mile/E of Hilton

Public facts

Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Condo/Co-op
Year Built: —
Year Renovated: —
County: Oakland County
APN: 2535356004

Home facts updated by county records on Jun 12, 2025

Around this home

Schools

Ferndale Lower Elementary Campus

Public K-3 • Assigned • 2.4mi

Ferndale Middle School

Public 6-8 • Assigned • 1.4mi

6/10

Ferndale High School

Public 9-12 • Assigned • 1.5mi

7/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, 14 days in 30 years

2/10 Wind Factor

Minor risk of severe winds over next 30 years

4/10 Air Factor

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

Provided by First Street

Historical weather

Ferndale, MI • 48220

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

$251,000 – $303,000

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

Need the cash from your home fast? Sell to .

Nearby similar homes

$125,000

1 bed1 bath740 sq ft

25749 Woodward Ave #106, Royal Oak, MI 48067

$46,000

2 beds1 bath1,776 sq ft

3713 Oakman Blvd #7, Detroit, MI 48204 1186

(313) 877-9020

$129,900

2 beds1 bath993 sq ft

24149 Wedgewood Cir, Warren, MI 48091 5874

(248) 305-1900

$249,900

2 beds1.5 baths1,642 sq ft

2723 Grayson St, Ferndale, MI 48220 1005

(248) 855-1940

OPEN TODAY, 2PM TO 4PM

$462,500

2 beds2 baths1,488 sq ft

211 E 9 Mile Rd #307, Ferndale, MI 48220 1968

(248) 644-6700

NEW CONSTRUCTION

$1,199,000

3 beds3.5 baths5,038 sq ft

110 Austin Ave #204, Royal Oak, MI 48067

(248) 733-5811

New listings for sale in 48220 1875

NEW 31 HRS AGO

$284,900

3 beds2 baths1,168 sq ft

235 Flowerdale Street St, Ferndale, MI 48220 1875

(248) 457-4572

$210,000

2 beds1 bath1,174 sq ft

1493 Browning St, Ferndale, MI 48220 1101

(248) 238-8211

$219,900

2 beds1 bath1,060 sq ft

2289 Hamata St, Ferndale, MI 48220 1549

(586) 330-9755

LISTED BY REDFIN3D WALKTHROUGH

$269,000

3 beds2 baths938 sq ft

2140 Brickley St, Ferndale, MI 48220

$208,000

2 beds1 bath1,407 sq ft

830 Channing St, Ferndale, MI 48220 3513

(248) 453-7454

$225,000

3 beds1 bath1,154 sq ft

3245 Kenwood St, Ferndale, MI 48220 1130

(734) 459-4700

$260,000

3 beds2 baths1,610 sq ft

3275 Kenwood St, Ferndale, MI 48220 1132

(248) 733-5811

$345,000

3 beds2 baths1,900 sq ft

1665 W Troy St, Ferndale, MI 48220 3158

(248) 733-5811

$159,000

3 beds1 bath1,716 sq ft

20785 Mendota Ave, Ferndale, MI 48220 2155

(248) 813-4900

Home values near 404 Hilton RD # 104 Rd

Data from public records.

Address	Redfin Estimate
410 Hilton Road, Ferndale, MI 2 Beds \| 2 Baths \| 1381 Sq. Ft.	$290,826
424 Hilton Road Unit 108, Ferndale, MI 2 Beds \| 2 Baths \| 1369 Sq. Ft.	$279,345

Address	Redfin Estimate
450 Hilton Road Unit 114, Ferndale, MI 2 Beds \| 2 Baths \| 1369 Sq. Ft.	$268,096
410 Hilton Road Unit 106, Ferndale, MI 2 Beds \| 2 Baths \| 1369 Sq. Ft.	$276,254

Address	Redfin Estimate
444 Hilton Road Unit 112, Ferndale, MI 2 Beds \| 2 Baths \| 1369 Sq. Ft.	$270,016
404 Hilton Road Unit 104, Ferndale, MI 2 Beds \| 2 Baths \| 1369 Sq. Ft.	$266,021

Property information provided by REALCOMP when last listed in 2021. This data may not match . Learn more.

More real estate resources

Minor Civil Divisions
Neighborhoods
Zip Codes
Cities
Popular Searches

Shelby Township 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.

48067 homes for sale
48030 homes for sale
48220 homes for sale
48221 homes for sale
48237 homes for sale

Houses for rent in Ferndale	Agents near me	Livonia, MI homes for sale	Ferndale Housing Market
Houses for sale near me	Detroit, MI homes for sale	Novi, MI homes for sale
Land for sale near me	Ann Arbor, MI homes for sale	Royal Oak, MI homes for sale
Open Houses near me	Grand Rapids, MI homes for sale	Ferndale 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