34654 Greentrees Road
Description
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...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!
- Listed by Maynard Neal • Brokerage DRE #6505416419 • NERG Real Estate ExpertsP: (248)-687-9308 C: (248)-687-9308 nergexperts@gmail.com
Property Details for 34654 Greentrees Road
Location
Sold By Home Pride Realty
Building Information for 34654 Greentrees Road
Payment Calculator
$1,795 per month
30 year fixed, 6.55% Interest
$1,525
$270
$0
Know your buying power with a preapproval and custom rate in minutes
1Property Information for 34654 Greentrees Road
- Directions: S/MORAVIAN AND E/SCHOENHERR
- Latitude: 42.55144434
- Longitude: -82.98044421
- Cross Street: Warren Con
- MLS Area Major: Sterling Heights (50012)
- Parcel Number: 1036128003
- Tax Amount Summer: $3,119.00
- Tax Amount Winter: $122.00
- Tax Annual Amount: $3,241.00
- Tax Assessed Value: $75,396.00
- Tax Legal Description: M 169 $KINGSLEY SUBDIVISION LOT 169
- Association: No
- High School District: Warren Con
- Garage Spaces: 2.0
- Attached Garage: Yes
- Garage: Yes
- Parking Features: Two Car Garage, Attached
- Frontage Length: 60.0
- Lot Size Acres: 0.17
- Lot Size Area: 0.17
- Lot Size Dimensions: 60.00 x 120.00
- Lot Size Units: Acres
- Road Frontage Feet: 60
- Road Frontage Type: Paved
- State Equalized Value: 112900.0
- Living Area: 2336.0
- Building Area Total: 2620.0
- Above Grade Finished Area: 1436.0
- Below Grade Finished Area: 900.0
- Below Grade Total Area: 1184.0
- Class Name: Residential
- Living Area Source: Public Records
- New Construction: No
- Year Built: 1970
- Construction Materials: Brick
- Entry Location: Ground Level
- Foundation Details: Basement, Brick Mortar
- Levels: One
- Roof: Asphalt
- Stories Total: 1
- Sewer: Public Sewer
- Water Source: Public
- Bathrooms Total Notational: 1.1
- Appliances: Dishwasher, Disposal, Dryer, Free Standing Electric Range, Microwave, Washer
- Basement: Finished
- Has Basement: Yes
- Bathrooms Full: 1
- Bathrooms Half: 1
- Bathrooms Total Integer: 2
- Bedrooms Total: 3
- Cooling: Ceiling Fans, Central Air
- Has Cooling: Yes
- Fireplace Features: Family Room
- Fireplace: Yes
- Heating: Forced Air, Natural Gas
- Has Heating: Yes
- Interior Features: Programmable Thermostat
- Rooms Total: 7
- Security Features: Smoke Detectors
- Water Heater Fuel: Natural Gas
- Patio And Porch Features: Patio
- Pool Private: No
- Room Description: Carpet
- Room Dimensions: 12x12
- Room Length: 12.0
- Room Width: 12.0
- Room Flooring: Carpet
- Room Level: Entry
- Room Type: Bedroom 2
- Room Dimensions: 12x20
- Room Length: 12.0
- Room Width: 20.0
- Room Level: Entry
- Room Type: Family Room
- Room Dimensions: 6x8
- Room Length: 12.0
- Room Width: 12.0
- Room Flooring: Wood
- Room Level: Entry
- Room Type: Bathroom 1
- Room Dimensions: 10x19
- Room Length: 9.0
- Room Width: 12.0
- Room Flooring: Carpet
- Room Level: Entry
- Room Type: Kitchen
- Room Description: Wood
- Room Dimensions: 12x12
- Room Length: 12.0
- Room Width: 12.0
- Room Level: Entry
- Room Type: Bedroom 1
- Room Description: Wood
- Room Dimensions: 11x16
- Room Length: 6.0
- Room Width: 8.0
- Room Level: Entry
- Room Type: Living Room
- Room Description: Carpet
- Room Dimensions: 9x12
- Room Length: 10.0
- Room Width: 19.0
- Room Flooring: Laminate
- Room Level: Entry
- Room Type: Bedroom 3
- Room Dimensions: 6x8
- Room Length: 11.0
- Room Width: 16.0
- Room Flooring: Wood
- Room Level: Entry
- Room Type: Living Room
- Room Length: 11.0
- Room Width: 19.0
- Room Flooring: Carpet
- Room Level: Entry
- Room Type: Family Room
- Public GLR Website: Yes
- Existing Lease: No
- Pets Allowed: Cats Ok, Dogs Ok
- Rent Spree: No
Property History for 34654 Greentrees Road
| Date | Event & Source | Price | Appreciation |
|---|---|---|---|
| Oct 11, 2024 | Sold MiRealSource #60333536 | $300,000 | — |
| Oct 11, 2024 | Sold Realcomp #20240060691 | $300,000 | — |
| Oct 4, 2024 | Sold (Public Record) Public Record #1548386007 | $300,000 | +7.6% / yr |
| Aug 30, 2024 | Contract Signed Realcomp #20240060691 | — | |
| Aug 29, 2024 | Contract Signed MiRealSource #60333536 | — | |
| Aug 23, 2024 | Listed (Active) Realcomp #20240060691 | $300,000 | — |
| Aug 21, 2024 | Listed (Active) MiRealSource #60333536 | $300,000 | — |
| Sep 20, 2012 | Sold (Public Record) Public Record #343520087 | $123,900 | — |
| Sep 20, 2012 | Sold Realcomp #212084137 | $123,900 | — |
| Aug 17, 2012 | Contract Signed Realcomp #212084137 | — | |
| Aug 13, 2012 | Listed (Active) Realcomp #212084137 | $123,900 | — |
| Mar 31, 2011 | Temporarily Off Market Realcomp #58031021689 | $124,900 | — |
| Mar 31, 2011 | Temporarily Off Market Realcomp #210136219 | $124,900 | — |
| Feb 28, 2011 | Listed (Active) Realcomp #58031021689 | $127,900 | — |
| Feb 28, 2011 | Listed (Active) Realcomp #210136219 | $127,900 | — |
| Nov 30, 2010 | Temporarily Off Market Realcomp #210101831 | $127,900 | — |
| Aug 31, 2010 | Permanently Off Market Realcomp #58031005365 | $139,900 | — |
| Aug 31, 2010 | Listed (Active) Realcomp #210101831 | $127,900 | — |
| Aug 14, 2010 | Temporarily Off Market Realcomp #210057423 | $139,900 | — |
| May 14, 2010 | Listed (Active) Realcomp #210057423 | $147,900 | — |
| May 14, 2010 | Listed (Active) Realcomp #58031005365 | $147,900 | — |
| Date | Event & Source | Price |
|---|---|---|
| 10/11/2024 | Sold MiRealSource #60333536 | $300,000 |
| 10/11/2024 | Sold Realcomp #20240060691 | $300,000 |
| 10/04/2024 | Sold (Public Record) Public Record #1548386007 | $300,000 +7.6% / yr |
| 08/30/2024 | Contract Signed Realcomp #20240060691 | — |
| 08/29/2024 | Contract Signed MiRealSource #60333536 | — |
| 08/23/2024 | Listed (Active) Realcomp #20240060691 | $300,000 |
| 08/21/2024 | Listed (Active) MiRealSource #60333536 | $300,000 |
| 09/20/2012 | Sold (Public Record) Public Record #343520087 | $123,900 |
| 09/20/2012 | Sold Realcomp #212084137 | $123,900 |
| 08/17/2012 | Contract Signed Realcomp #212084137 | — |
| 08/13/2012 | Listed (Active) Realcomp #212084137 | $123,900 |
| 03/31/2011 | Temporarily Off Market Realcomp #58031021689 | $124,900 |
| 03/31/2011 | Temporarily Off Market Realcomp #210136219 | $124,900 |
| 02/28/2011 | Listed (Active) Realcomp #58031021689 | $127,900 |
| 02/28/2011 | Listed (Active) Realcomp #210136219 | $127,900 |
| 11/30/2010 | Temporarily Off Market Realcomp #210101831 | $127,900 |
| 08/31/2010 | Permanently Off Market Realcomp #58031005365 | $139,900 |
| 08/31/2010 | Listed (Active) Realcomp #210101831 | $127,900 |
| 08/14/2010 | Temporarily Off Market Realcomp #210057423 | $139,900 |
| 05/14/2010 | Listed (Active) Realcomp #210057423 | $147,900 |
| 05/14/2010 | Listed (Active) Realcomp #58031005365 | $147,900 |
For completeness, we often displays two records for one sale: the MLS record and the public record.
Public Records for 34654 Greentrees Road
Schools near 34654 Greentrees Road
Rating | School | Type | Grades | Distance |
|---|---|---|---|---|
| Public - | PK to 5 | |||
| Public - | 6 to 8 | |||
| Public - | 9 to 12 | |||
| Public - | 10 to 12 |
Rating | School | Distance |
|---|---|---|
Black Elementary School PublicPK to 5 | ||
Carleton Middle School Public6 to 8 | ||
Cousino Senior High School Public9 to 12 | ||
Career Preparation Center Public10 to 12 |
School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.
Similar Homes
New listings in 48312
$354,999
- 3
- Bedrooms
- 2
- Bathrooms
- 2,036
- Square Feet
- 0.17
- Acres
$239,900
- 2
- Bedrooms
- 2
- Bathrooms
- 1,560
- Square Feet
$329,900
- 3
- Bedrooms
- 2
- Bathrooms
- 2,308
- Square Feet
- 0.21
- Acres
$183,000
- 3
- Bedrooms
- 2
- Bathrooms
- 1,800
- Square Feet
- Unavailable
- Acres
Nearby home values
| Address | Sold price | Beds | Baths | Sqft | Lot (Sqft) |
|---|---|---|---|---|---|
This home: 34654 Greentrees Road, Sterling Heights, MI 48312 | $300,000 | 3 | 2 | 2,336 | 7,405 |
$285,000 | 3 | 2 | 2,436 | 6,969 | |
$207,000 | 4 | 1.5 | 1,789 | 7,187 | |
$129,500 | 3 | 2 | 1,550 | – | |
$219,000 | 3 | 2 | 1,436 | 8,276 | |
– | – | 1 | 1,323 | 7,187 | |
– | – | 1 | 1,323 | 7,187 | |
$240,000 | 3 | 2 | 1,823 | 7,405 | |
– | 3 | 2 | 1,323 | 7,187 | |
$345,000 | – | – | 6,242 | 75,489 | |
$220,000 | 3 | 3 | 2,423 | 8,276 | |
$269,000 | 3 | 2 | 2,482 | 6,969 | |
– | – | 1 | 1,323 | 11,326 | |
$295,000 | – | 1.5 | 1,323 | 12,981 | |
– | – | 1 | 1,107 | 8,233 | |
$212,000 | 3 | 1 | 2,323 | 10,018 |
Explore Nearby Homes
- Clinton Homes for Sale
- Clinton Township - Macomb County Homes for Sale
- Fairway Greens Homes for Sale
- Northeast Warren Homes for Sale
- Plumbrook Village Homes for Sale
- Northwest Warren Homes for Sale
- Meadowview Village Homes for Sale
- Arden Park Homes for Sale
- Brookside Villas Homes for Sale
- East Hampton Homes for Sale
- Fraser Gardens Homes for Sale
- Garwood Estates Homes for Sale
- Heritage Village Homes for Sale
- Downtown Warren Homes for Sale
- Ryan Road Estates Homes for Sale
- Clinton Township Homes for Sale
- Sterling Heights Homes for Sale
- Warren Homes for Sale
- Fraser Homes for Sale
- Roseville Homes for Sale
- Troy Homes for Sale
- Madison Heights Homes for Sale
- Utica Homes for Sale
- Center Line Homes for Sale
- Macomb Homes for Sale
- St. Clair Shores Homes for Sale
- Mount Clemens Homes for Sale
- Royal Oak Homes for Sale
- Clawson Homes for Sale
- Eastpointe Homes for Sale
- 48313 Homes for Sale
- 48088 Homes for Sale
- 48310 Homes for Sale
- 48036 Homes for Sale
- 48038 Homes for Sale
- 48035 Homes for Sale
- 48093 Homes for Sale
- 48026 Homes for Sale
- 48092 Homes for Sale
- 48314 Homes for Sale
- 48066 Homes for Sale
- 48071 Homes for Sale
- 48083 Homes for Sale
- 48085 Homes for Sale
- 48317 Homes for Sale
No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.
Listing Courtesy of NERG Real Estate Experts
IDX provided courtesy of Realcomp II Ltd. via Compass and its related brokerages. Copyright 2026 Realcomp II Ltd. Shareholders. IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. The data relating to real estate properties on this website was last updated on 08/03/2025 10:00 PM PST
