28817 GREEN CASTLE Rd, Farmington Hills, MI 48334 5147

Off market dec 2017 for $146K

$254,226

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

•

1,266

sq ft

28817 GREEN CASTLE Rd, Farmington Hills, MI 48334 5147

About this home

Single-familyProperty Type

1956Year Built

0.39 acresLot Size

$201Est. Price/Sq.Ft.

1 car garageParking

Listed by Dennis Weese • National Realty Centers, Inc

•248-971-1010 (broker)

•clarkston@nrc.email (broker)

Bought with Scott Rutterbush • RE/MAX Encore

•248-620-1000 (broker)

•support@remaxencore.com (broker)

Redfin checked: 2 minutes ago

•Source:MiRealSource-MiMLS #21375806

Redfin Estimate

$254,226

$108K since sold in December 2017$1,000 since September

Recently sold homes
Estimate history
Homes for sale

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

SOLD MAY 1, 2026
$300,000
A
3 beds1.5 baths1,477 sq ft
28423 Cumberland Dr, Farmington Hills, MI 48334
SOLD APR 6, 2026
$295,900
B
3 beds1 bath1,450 sq ft
28045 W GREENMEADOW Cir, Farmington Hills, MI 48334 5159
SOLD JUN 3, 2026
$300,000
C
3 beds2 baths1,877 sq ft
28438 San Marino Dr, Southfield, MI 48034 5674
BOUGHT WITH REDFIN JUN 16, 2026
$420,000
D
3 beds2 baths2,031 sq ft
28631 Cumberland Dr, Farmington Hills, MI 48334 5127
SOLD JUL 20, 2026
$305,000
E
3 beds2 baths1,525 sq ft
29601 Gilchrest St, Farmington Hills, MI 48334 1615
SOLD NOV 24, 2025
$361,000
F
3 beds1.5 baths1,649 sq ft
28670 INKSTER Rd, Southfield, MI 48034 1519

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

Earn from this home

Sell

$142,549

Est. take-home

List your home with Redfin and save $2,542

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$2,502/mo

Redfin rental estimate

List your home for rent

Market trends in 48334, MI

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

98.3%

0.5% MoM

Median sale price

$380K

$2K MoM

Avg. days on market

22d

0 days MoM

Recently sold homes

7 MoM

New listings for sale

NEW 20 HRS AGO
$534,900
4 beds2.5 baths3,402 sq ft
32089 Olde Franklin Dr, Farmington Hills, MI 48334 1735
(586) 799-4700
OPEN SAT, 1PM TO 2PM
$549,900
3 beds2.5 baths3,016 sq ft
27869 Old Colony St, Farmington Hills, MI 48334 3242
(734) 464-6400
OPEN SUN, 12PM TO 2PM
$375,000
4 beds2 baths2,878 sq ft
28839 Bannockburn St, Farmington Hills, MI 48334 2705
(248) 851-4100
OPEN SAT, 11AM TO 1PM
$515,000
3 beds3.5 baths3,816 sq ft
31888 Bristol Ln, Farmington Hills, MI 48334 2921
(734) 459-4700
3D WALKTHROUGH
$170,000
2 beds2 baths691 sq ft
32013 W Twelve Mile Rd, Farmington Hills, MI 48334 3652
(888) 501-7085
$538,700
5 beds3.5 baths4,089 sq ft
29621 Fernhill Dr, Farmington Hills, MI 48334 2025
(248) 729-7777
$150,000
2 beds1 bath922 sq ft
27971 Rollcrest Rd #9, Farmington Hills, MI 48334 4062
(734) 259-7949
$770,000
3 beds2.5 baths3,400 sq ft
28219 Westbrook Ct, Farmington Hills, MI 48334 4105
(248) 562-4000
$155,000
2 beds2 baths2,352 sq ft
30042 W 12 Mile Rd #50, Farmington Hills, MI 48334 3923
(248) 770-8116
$94,000
1 bed1 bath784 sq ft
30445 W Fourteen Mile Rd #55, Farmington Hills, MI 48334
(248) 851-8700
See all

Provided by Redfin

Sale history for 28817 GREEN CASTLE Rd

Date

Event

Price

MiRealSource-MiMLS #21375806

Dec 11, 2017

Sold

$146,000

$115/sq ft

Nov 6, 2017

Pending

—

Oct 4, 2017

Listed

$159,900

$126/sq ft

REALCOMP #217089824

Dec 11, 2017

Sold

$146,000

$115/sq ft

Nov 6, 2017

Pending

—

Oct 4, 2017

Listed

$159,900

$126/sq ft

MiRealSource-MiMLS #21354170

Oct 4, 2017

Listing Removed

—

Aug 11, 2017

Listed

$169,900

$134/sq ft

REALCOMP #217071803

Oct 4, 2017

Listing Removed

—

Aug 11, 2017

Listed

$169,900

$134/sq ft

REALCOMP #29095044

Sep 21, 2009

Sold

$85,000

$67/sq ft

Jul 16, 2009

Listed

$88,770

$70/sq ft

REALCOMP #29047851

Jul 16, 2009

Listing Removed

—

Apr 7, 2009

Listed

$109,888

$87/sq ft

REALCOMP #28206501

Apr 6, 2009

Listing Removed

—

Dec 30, 2008

Listed

$109,899

$87/sq ft

REALCOMP #28146778

Dec 30, 2008

Listing Removed

—

Aug 29, 2008

Listed

$125,000

$99/sq ft

Tax history for 28817 GREEN CASTLE 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

120 ft.

Lot depth

140 ft.

Lot size

0.39 Acres

Year renovated

—

Sq. Ft.

1,266

Year built

1956

Style

Single Family Residential

County

Oakland County

APN

222313126007

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Aug 12, 2026.

RA-2

One Family Residential District

The one-family residential districts are designed to be the most restrictive of the residential districts. The intent is to provide for an environment of predominantly low-density, one-family detached dwellings along with other residentially related facilities which serve the residents in the district.

Permitted uses

Include but are not limited to:

Agriculture
Religious facility
Day care facility
Housing-Single unit
Public service
Educational/school
Library
Recreation
Housing-Mobile home park
Park & open space

Property details

Parking

Parking/Garage Information
Has Garage
# of Parking Spaces in Garage: 1
Garage Type: Detached Garage, Electric In Garage, Gar Door Opener

Interior

Interior Features
Has Fireplace
# of Rooms (Total): 6
Interior Features: Cable/Internet Avail.
Appliances: Dishwasher, Dryer, Microwave, Range/Oven, Refrigerator, Washer
Has Fireplace
Fireplace Features: Gas Fireplace, Livingroom Fireplace

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

Exterior

Exterior Features
Exterior Construction: Brick
Exterior Features: Patio, Porch
Foundation Type: Crawl

Property Information
Property Type: Residential
Structure Style: 1 Story
Year Built: 1956

Lot Information
Lot Size: 120,140

Land Information
Land Contract: No
Acreage: 0.39
Roads: Paved Street
Frontage: 120

Financial

Tax/Assessments Information
Total Tax Amount: $2,526
Summer Tax Amount: $1,998
Winter Tax Amount: $528
Has Assessments
Assessments Amount: $66.17

Utilities

Utility Information
Heat/Fuel Type: Natural Gas
Water Heater: Gas
Water: Private Well
Cooling System: Ceiling Fan(S), Central A/C
Heating System: Forced Air

Location

Unit 5 Information
Living Room Dimensions: L=1266

School Information
School District: Farmington Public School Distric
School District: Farmington Public School Distric

Address Information
Street Designation: Road

Location Details
Directions: 12 Mile to Green Castle Rd, S to home
Municipality Type: City
Municipality: Farmington Hills
Mail City: Farmington Hills
Subdivision: GREENCASTLE
Municipality: Farmington Hills
Area (Municipality): Farmington Hills (63231)

Public facts

Beds: 4
Baths: 1.0
Sq. Ft.: 1,266
Stories: 1.0
Lot Size: 0.39 acres
Style: Single Family Residential
Year Built: 1956
Year Renovated: —
County: Oakland County
APN: 222313126007

Home facts updated by county records on Aug 12, 2026

Other

Listing Information
Originating MLS: RealComp
No

Around this home

Schools

Wood Creek Elementary School

Public K-5 • Assigned • 0.4mi

6/10

Warner Upper Elementary School

Public 6-8 • Assigned • 2.2mi

7/10

North Farmington High School

Public 9-12 • Assigned • 2.5mi

8/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

2/10 Wind Factor

Minor risk of severe winds over next 30 years

3/10 Air Factor

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

Provided by First Street

Historical weather

Farmington Hills, MI • 48334 5147

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.6 hours in June and 2.6 hours in December, placing it below the U.S. average for solar exposure.

9.6 hrs

2.6 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$242,000 – $293,000

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

Need the cash from your home fast? Sell to .

Nearby similar homes

OPEN SAT, 11AM TO 1PM

$515,000

3 beds3.5 baths3,816 sq ft

31888 Bristol Ln, Farmington Hills, MI 48334 2921

(734) 459-4700

NEW CONSTRUCTION

$779,900

4 beds2.5 baths3,804 sq ft

28341 Alycekay St, Farmington Hills, MI 48334 3831

(888) 501-7085

$589,900

4 beds3 baths3,786 sq ft

29204 Summerwood Rd, Farmington Hills, MI 48334

3D WALKTHROUGH

$819,000

4 beds4.5 baths3,907 sq ft

27593 Old Colony St, Farmington Hills, MI 48334 3236

(248) 277-4226

$400,000

4 beds2 baths2,008 sq ft

29799 Linden St, Farmington Hills, MI 48336 3438

(248) 548-9100

$369,900

3 beds2 baths2,104 sq ft

29255 Utley Rd, Farmington Hills, MI 48334 4177

(586) 262-4775

New listings for sale in 48334 1735

NEW 20 HRS AGO

$534,900

4 beds2.5 baths3,402 sq ft

32089 Olde Franklin Dr, Farmington Hills, MI 48334 1735

(586) 799-4700

OPEN SAT, 1PM TO 2PMVIDEO TOUR

$549,900

3 beds2.5 baths3,016 sq ft

27869 Old Colony St, Farmington Hills, MI 48334 3242

(734) 464-6400

OPEN SUN, 12PM TO 2PMVIDEO TOUR

$375,000

4 beds2 baths2,878 sq ft

28839 Bannockburn St, Farmington Hills, MI 48334 2705

(248) 851-4100

OPEN SAT, 11AM TO 1PM

$515,000

3 beds3.5 baths3,816 sq ft

31888 Bristol Ln, Farmington Hills, MI 48334 2921

(734) 459-4700

3D WALKTHROUGH

$170,000

2 beds2 baths691 sq ft

32013 W Twelve Mile Rd, Farmington Hills, MI 48334 3652

(888) 501-7085

$538,700

5 beds3.5 baths4,089 sq ft

29621 Fernhill Dr, Farmington Hills, MI 48334 2025

(248) 729-7777

$150,000

2 beds1 bath922 sq ft

27971 Rollcrest Rd #9, Farmington Hills, MI 48334 4062

(734) 259-7949

$770,000

3 beds2.5 baths3,400 sq ft

28219 Westbrook Ct, Farmington Hills, MI 48334 4105

(248) 562-4000

$155,000

2 beds2 baths2,352 sq ft

30042 W 12 Mile Rd #50, Farmington Hills, MI 48334 3923

(248) 770-8116

Home values near 28817 GREEN CASTLE Rd

Data from public records.

Address	Redfin Estimate
28666 Green Castle Rd, Farmington Hills, MI 3 Beds \| 1.5 Baths \| 1453 Sq. Ft.	$299,531
28725 Green Castle Rd, Farmington Hills, MI 3 Beds \| 1.5 Baths \| 1395 Sq. Ft.	$321,965

Address	Redfin Estimate
28961 Green Castle Rd, Farmington Hills, MI 3 Beds \| 2 Baths \| 1948 Sq. Ft.	$327,636
28865 Green Castle Rd, Farmington Hills, MI 4 Beds \| 1 Baths \| 1385 Sq. Ft.	$265,127

Address	Redfin Estimate
28911 Green Castle Rd, Farmington Hills, MI 4 Beds \| 2.5 Baths \| 2262 Sq. Ft.	$392,260
28777 Green Castle Rd, Farmington Hills, MI 3 Beds \| 1.5 Baths \| 1464 Sq. Ft.	$294,606

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

More real estate resources

Zip Codes
Minor Civil Divisions
Cities
Neighborhoods
Popular Searches

48335 homes for sale
48336 homes for sale
48322 homes for sale
48331 homes for sale
48334 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.

Meadowbrook Hills homes for sale
Route 102 homes for sale
West Bloomfield homes for sale
Franklin Hills homes for sale
Downtown Farmington homes for sale

Houses for rent in Farmington Hills	Agents near me	Livonia, MI homes for sale	Farmington Hills 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	Farmington Hills Property Records
Condos for sale near me	Troy, MI homes for sale	MI New Listings

Detroit homes for sale
Troy homes for sale
Ann Arbor homes for sale