34654 GREENTREES Rd, Sterling Heights, MI 48312 5515

Off Market Oct 2024 for $300K

$318,472

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

•

1,436

sq ft

34654 GREENTREES Rd, Sterling Heights, MI 48312 5515

About this home

Charming Three-Bedroom Brick Home in Sterling Heights Nestled in the highly sought-after neighborhood near 15 Mile and Moravian, this solid brick home perfectly blends classic charm with modern convenience. Boasting three spacious bedrooms and one and a half baths, this property is ideal for families or anyone looking to enjoy all that Sterling Heights has to offer. Step inside to discover beautiful hardwood floors throughout, complemented by an open-concept kitchen that flows effortlessly into the family roomâ€”perfect for entertaining. The family room features cathedral ceilings and a natural fireplace, adding warmth and character to the space. The full-size basement offers endless possibilities, whether you envision additional living space, a home office, or a recreational area. Outside, a beautifully manicured yard awaits, complete with a lovely patio for outdoor dining and relaxation. The property also includes a large shed and a brick privacy wall, enhancing both functionality and seclusion. Located in a tranquil yet convenient area, this home offers easy access to local amenities, making it a rare find in todayâ€™s market. Please note that the sale of this home will require probate approval. Donâ€™t miss out on this opportunityâ€”schedule your showing today!

Single-familyProperty Type

1970Year Built

7,405 sq ftLot Size

$222Est. Price/Sq.Ft.

2 car garageParking

Listed by Maynard Neal • NERG Real Estate Experts

•586-983-8686 (broker)

•nergexperts@gmail.com (broker)

Bought with Mohammed Uddin • Home Pride Realty

•313-826-7029 (broker)

Redfin checked: 2 minutes ago

•Source:MiRealSource-MiMLS #60333536

Redfin Estimate

$318,472

$18K since sold in October 2024$0 since July

Recently sold homes
Estimate history
Homes for sale

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

SOLD JUL 31, 2026
$335,000
A
3 beds1.5 baths1,518 sq ft
14490 Edshire Dr, Sterling Heights, MI 48312
SOLD APR 29, 2026
$263,500
B
3 beds1.5 baths1,107 sq ft
34371 Peppermil Ct, Sterling Heights, MI 48312 5651
SOLD FEB 17, 2026
$300,000
C
3 beds1.5 baths1,466 sq ft
14599 Joanise Dr, Sterling Heights, MI 48312 4363
SOLD JUL 8, 2026
$273,500
D
3 beds1.5 baths1,455 sq ft
35427 Cathedral Dr, Sterling Heights, MI 48312
SOLD MAR 6, 2026
$300,000
E
3 beds2 baths2,147 sq ft
34617 Greentrees Rd, Sterling Heights, MI 48312
SOLD JUN 24, 2026
$314,900
F
3 beds1.5 baths1,436 sq ft
34391 Brookshire Dr, Sterling Heights, MI 48312

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

Earn from this home

Sell

$66,107

Est. take-home

List your home with Redfin and save $3,185

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$2,391/mo

Redfin rental estimate

List your home for rent

Market trends in 48312, MI

Last updated July 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

100.0%

+0.6% MoM

Median sale price

$317K

$428 MoM

Avg. days on market

16d

1 days MoM

Recently sold homes

122

9 MoM

New listings for sale

NEW 20 HRS AGO
$320,000
3 beds1.5 baths2,628 sq ft
37352 Mario Dr, Sterling Heights, MI 48312
(248) 266-0584
3D WALKTHROUGH
$360,000
5 beds2 baths1,854 sq ft
11955 Sorrento Blvd, Sterling Heights, MI 48312 1359
(888) 501-7085
$239,900
2 beds2 baths1,711 sq ft
14225 Shadywood Dr, Sterling Heights, MI 48312
(586) 949-0200
$299,000
3 beds1.5 baths2,236 sq ft
36424 Clifford Dr, Sterling Heights, MI 48312 3117
(248) 813-4900
$349,999
3 beds2.5 baths2,636 sq ft
13167 Kozak Dr, Sterling Heights, MI 48312 3242
(248) 422-6962
$287,900
4 beds1.5 baths2,480 sq ft
35356 Monza Ct St, Sterling Heights, MI 48312
(586) 489-0149
$265,000
2 beds2 baths2,268 sq ft
33925 Oakwood Dr, Sterling Heights, MI 48312 6907
(248) 851-4100
$549,000
4 beds3.5 baths4,233 sq ft
34827 Fontana Dr, Sterling Heights, MI 48312 5732
(248) 620-1000
3D WALKTHROUGH
$120,000
2 beds1.5 baths1,000 sq ft
34691 Kimberly Dr #51, Sterling Heights, MI 48312 5067
(248) 629-0791
3D WALKTHROUGH
$104,900
2 beds1 bath900 sq ft
8140 Crestview Dr, Sterling Heights, MI 48312 6074
(248) 422-6962
See all

Provided by Redfin

Sale history for 34654 GREENTREES Rd

Date

Event

Price

Public Records

Jan 2, 2025

Sold

$300,000

$209/sq ft

REALCOMP #20240060691

Oct 11, 2024

Sold

$300,000

$209/sq ft

Aug 30, 2024

Pending

—

Aug 23, 2024

Listed

$300,000

$209/sq ft

Aug 21, 2024

Coming Soon

$300,000

$209/sq ft

Charming Three-Bedroom Brick Home in Sterling Heights Nestled in the highly sought-after neighborhood near 15 Mile and Moravian, this solid brick home perfectly blends classic charm with modern convenience. Boasting three spacious bedrooms and one and a half baths, this property is ideal for families or anyone looking to enjoy all that Sterling Heights has to offer. Step inside to discover beautiful hardwood floors throughout, complemented by an open-concept kitchen that flows effortlessly into the family room—perfect for entertaining. The family room features cathedral ceilings and a natural fireplace, adding warmth and character to the space. The full-size basement offers endless possibilities, whether you envision additional living space, a home office, or a recreational area. Outside, a beautifully manicured yard awaits, complete with a lovely patio for outdoor dining and relaxation. The property also includes a large shed and a brick privacy wall, enhancing both functionality and seclusion. Located in a tranquil yet convenient area, this home offers easy access to local amenities, making it a rare find in today’s market. Please note that the sale of this home will require probate approval. Don’t miss out on this opportunity—schedule your showing today!

Greater Lansing AoR #60333536

Oct 11, 2024

Sold

$300,000

$209/sq ft

Oct 11, 2024

Sold

$300,000

$209/sq ft

Aug 30, 2024

Pending

—

Aug 23, 2024

Listed

$300,000

$209/sq ft

Aug 21, 2024

Coming Soon

$300,000

$209/sq ft

Aug 21, 2024

Listed

$300,000

$209/sq ft

Public Records

Oct 30, 2012

Sold

$123,900

$86/sq ft

MiRealSource-MiMLS #31115184

Sep 20, 2012

Sold

$123,900

$86/sq ft

Aug 17, 2012

Listing Removed

—

Aug 13, 2012

Listed

$123,900

$86/sq ft

REALCOMP #212084137

Sep 20, 2012

Sold

$123,900

$86/sq ft

Aug 13, 2012

Listed

$123,900

$86/sq ft

REALCOMP #210136219

Mar 14, 2011

Listing Removed

—

Dec 2, 2010

Listed

$124,900

$87/sq ft

MiRealSource-MiMLS #31021689

Mar 14, 2011

Listing Removed

—

Aug 31, 2010

Listed

$124,900

$87/sq ft

REALCOMP #210101831

Nov 30, 2010

Listing Removed

—

Aug 31, 2010

Listed

$127,900

$89/sq ft

MiRealSource-MiMLS #31005365

Aug 31, 2010

Listing Removed

—

May 14, 2010

Listed

$139,900

$97/sq ft

REALCOMP #210057423

Aug 14, 2010

Listing Removed

—

May 14, 2010

Listed

$139,900

$97/sq ft

Public Records

Aug 17, 2000

Sold

$165,000

$115/sq ft

Tax history for 34654 GREENTREES 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

1.5

Stories

Lot width

60 ft.

Lot depth

120 ft.

Lot size

7,405 Sq. Ft.

Year renovated

—

Sq. Ft.

1,436

Year built

1970

Style

Single Family Residential

County

Macomb County

APN

10-10-36-128-003

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Aug 12, 2026.

R-60

One Family Residential District

The one family districts are established to provide an environment suitable for families who typically have children. The districts are principally for one family dwellings at varying densities. The specific intent 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. The city also discourages any land use which, because of its character and size, would create requirements and costs for public services substantially in excess of those needed for the one family densities of that zoning district. The city also discourages any land use which would be incompatible or generate excessive traffic on local streets.

Permitted uses

Include but are not limited to:

Agriculture
Livestock production
Housing-Single unit
Office
Fire house
Library
Museum / gallery
Police station
Recreation
Park & open space

Property details

Parking

Parking/Garage Information
Has Garage
# of Parking Spaces in Garage: 2
Garage Type: Attached Garage

Interior

Interior Features
Has Fireplace
# of Rooms (Total): 9
Appliances: Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Washer
Has Fireplace
Fireplace Features: Family Room Fireplace

Bedroom Information
Bedroom 1 Level: Entry
Bedroom 1 Dimensions: 12 x 12
Bedroom 1 Floor Covering: Wood
Bedroom 1 Floor Covering: Wood
Bedroom 2 Level: Entry
Bedroom 2 Dimensions: 12 x 12
Bedroom 2 Floor Covering: Carpet
Bedroom 3 Level: Entry
Bedroom 3 Dimensions: W=12
Bedroom 3 Floor Covering: Carpet

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

Bathroom 1 Information
Lavatory 1 Width: 8
Lavatory 1 Length: 6
Lavatory 1 Level: Entry
Bathroom 1 Level: Entry

Dining/Kitchen Information
Kitchen Floor Covering: Laminate
Kitchen Level: Entry
Kitchen Dimension: 10 x 19

Family/Great Room Information
Family Room Level: Entry
Family Room Dimensions: 12 x 20

Library/Den/Living Room Information
Living Room Floor Covering: Wood
Living Room Level: Entry
Living Room Dimensions: 11 x 16

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

Exterior

Exterior Features
Exterior Construction: Brick
Exterior Features: Patio
Foundation Type: Basement

Property Information
Pet Restrictions: Dogs Allowed, Cats Allowed
Property Type: Residential
Structure Style: 1 Story
Year Built: 1970
Below Grade Sq. Ft.: 1184
Below Grade Sq. Ft. (Finished): 900

Land Information
Land Contract: No
Acreage: 0.17
Roads: Paved Street
Frontage: 60

Financial

Tax/Assessments Information
Taxable Value: $75,396
Total Tax Amount: $3,241
Summer Tax Amount: $3,119
Winter Tax Amount: $122

Utilities

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

Location

Unit 5 Information
Living Room Dimensions: L=2336

School Information
School District: Warren Consolidated Schools
School District: Warren Consolidated Schools

Address Information
Street Designation: Road

Location Details
Directions: S/MORAVIAN AND E/SCHOENHERR
Municipality Type: City
Municipality: Sterling Heights
Mail City: Sterling Heights
Subdivision: KINGSLEY
Municipality: Sterling Heights
Area (Municipality): Sterling Heights (50012)

Public facts

Beds: —
Baths: 1.5
Sq. Ft.: 1,436
Stories: 1.0
Lot Size: 7,405 square feet
Style: Single Family Residential
Year Built: 1970
Year Renovated: —
County: Macomb County
APN: 10-10-36-128-003

Home facts updated by county records on Aug 12, 2026

Other

Listing Information
Originating MLS: RealComp
No

Around this home

Schools

Black Elementary School

Public PreK-5 • Assigned • 0.6mi

5/10

Carleton Middle School

Public 6-8 • Assigned • 2.1mi

5/10

Cousino Senior High School

Public 9-12 • Assigned • 2.8mi

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

3/10 Heat Factor

7 days above 96° 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, 5 days in 30 years

Provided by First Street

Historical weather

Sterling Heights, MI • 48312 5515

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

9.1 hrs

2.4 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$303,000 – $367,000

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

Need the cash from your home fast? Sell to .

Nearby similar homes

NEW 7 HRS AGO

$269,900

3 beds1.5 baths2,360 sq ft

14706 Murthum Ave, Warren, MI 48088 6234

(586) 262-4775

$359,000

4 beds1.5 baths2,431 sq ft

35347 Alta Vista Dr, Sterling Heights, MI 48312 4401

(833) 264-6832

$299,000

3 beds1.5 baths2,236 sq ft

36424 Clifford Dr, Sterling Heights, MI 48312 3117

(248) 813-4900

NEW CONSTRUCTION

$950,000

4 beds2.5 baths5,550 sq ft

13000 Plumbrook Rd, Sterling Heights, MI 48312 1648

(248) 422-6962

$309,900

3 beds2 baths2,670 sq ft

33810 Brookshire Dr, Sterling Heights, MI 48312 6510

(586) 488-2450

$479,900

4 beds2.5 baths3,616 sq ft

33868 Monterra Ln, Sterling Heights, MI 48312 5787

(248) 238-8808

New listings for sale in 48312

NEW 20 HRS AGO

$320,000

3 beds1.5 baths2,628 sq ft

37352 Mario Dr, Sterling Heights, MI 48312

(248) 266-0584

3D WALKTHROUGH

$360,000

5 beds2 baths1,854 sq ft

11955 Sorrento Blvd, Sterling Heights, MI 48312 1359

(888) 501-7085

$239,900

2 beds2 baths1,711 sq ft

14225 Shadywood Dr, Sterling Heights, MI 48312

(586) 949-0200

$299,000

3 beds1.5 baths2,236 sq ft

36424 Clifford Dr, Sterling Heights, MI 48312 3117

(248) 813-4900

$349,999

3 beds2.5 baths2,636 sq ft

13167 Kozak Dr, Sterling Heights, MI 48312 3242

(248) 422-6962

$287,900

4 beds1.5 baths2,480 sq ft

35356 Monza Ct St, Sterling Heights, MI 48312

(586) 489-0149

$265,000

2 beds2 baths2,268 sq ft

33925 Oakwood Dr, Sterling Heights, MI 48312 6907

(248) 851-4100

$549,000

4 beds3.5 baths4,233 sq ft

34827 Fontana Dr, Sterling Heights, MI 48312 5732

(248) 620-1000

3D WALKTHROUGH

$120,000

2 beds1.5 baths1,000 sq ft

34691 Kimberly Dr #51, Sterling Heights, MI 48312 5067

(248) 629-0791

Home values near 34654 GREENTREES Rd

Data from public records.

Address	Redfin Estimate
34642 Greentrees Rd, Sterling Heights, MI 3 Beds \| 1.5 Baths \| 1436 Sq. Ft.	$321,193
34666 Greentrees Rd, Sterling Heights, MI 4 Beds \| 1.5 Baths \| 1789 Sq. Ft.	$341,240

Address	Redfin Estimate
34590 Greentrees Rd, Sterling Heights, MI 3 Beds \| 1 Baths \| 1323 Sq. Ft.	$317,913
34558 Greentrees Rd, Sterling Heights, MI - Beds \| 1.5 Baths \| 1449 Sq. Ft.	$315,564

Address	Redfin Estimate
34678 Greentrees Rd, Sterling Heights, MI 3 Beds \| 1.5 Baths \| 1436 Sq. Ft.	$291,903
34641 Greentrees Rd, Sterling Heights, MI 3 Beds \| 2 Baths \| 1323 Sq. Ft.	$313,288

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

More real estate resources

Cities
Neighborhoods
Zip Codes
Minor Civil Divisions
Popular Searches

Detroit homes for sale
Royal Oak homes for sale
Troy 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.

Seville Terrace Condominium homes for sale
Clifton by the Sea homes for sale
Clinton homes for sale
Sterling Woods Condominiums homes for sale

48038 homes for sale
48310 homes for sale
48312 homes for sale
48313 homes for sale
48317 homes for sale

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