1812 Burning Bush Court

1,730 Sq. Ft.
$166 / Sq. Ft.
1,730
Sq. Ft.
$166
per Sq. Ft.

Description

Fantastic opportunity in Rochester Hills Streamwood Estates! This 3 bed, 2.5 bath condo offers 1,730 sq ft with scenic views of the Clinton River from the ensuite balcony or ground floor deck. The kitchen features new cabinets and stone countertops. With a fresh coat paint and updated flooring, this can be your perfect home. Enjoy community pool, tennis courts, and walking trails in a beautiful tranquil setting.Fantastic opportunity in Rochester Hills Streamwood Estates! This 3 bed, 2.5 bath condo offers 1,730 sq ft with scenic views of the Clinton River from the ensuite balcony or ground floor deck. The kitchen features new cabinets and stone countertops. With a fresh coat paint and updated flooring, this can be your perfect home. Enjoy community pool, tennis courts, and walking trails in a beautiful tranquil setting.
  1. Listed by Robert McPherson • Brokerage DRE #6505362950 • Berkshire Hathaway HomeServices Kee Realty NB
    P: (248)-800-6559 C: (248)-800-6559 RMcpherson@keerealtor.com
  2. Listed by Christopher Waring • Brokerage DRE #6505362950 • Berkshire Hathaway HomeServices Kee Realty NB
    P: (586)-291-4675 C: (586)-291-4675 cwaring@keerealty.com

Property Details for 1812 Burning Bush Court

Architectural Style
Colonial
Subdivision Name
Streamwood Estates Occpn 178
View
Water
View
Yes
Waterfront Features
River Front, Waterfront
Waterfront
Yes
Zoning Description
Residential
LISTING UPDATED: 06/18/2026 10:32 AM

Property Details for 1812 Burning Bush Court

StatusClosed
MLS #50192376
Days on Market2
Pet PolicyAllowed
Taxes$2,993 / year
HOA Fees$413 / month
Condo/Co-op Fees-
Property TypeCondo
MLS TypeResidential / Condominium
Year Built1979
CountyOakland County

Location

Listing Courtesy of Berkshire Hathaway HomeServices Kee Realty NB

Sold By Berkshire Hathaway HomeServices Kee Realty NB

Add your commute

Building Information for 1812 Burning Bush Court

Building/Complex1812 Burning Bush CtFloor-Stories2Residences-Pet PolicyAllowedPet Policy DetailsPets Allowed,Cats OK,Dogs OK,Call,Breed RestrictionsYear Built1979

Payment Calculator

$2,091 per month

30 year fixed, 6.36% Interest

Principal and Interest

$1,428

Property Taxes

$249

HOA Dues

$413

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 1812 Burning Bush Court

Summary
Location and General Information
  • Cross Street: Hamlin Rd
  • Directions: Turn N Streamwood, Left Burning Bush
  • Latitude: 42.654708
  • Longitude: -83.168639
  • MLS Area Major: Rochester Hills (63151)
Taxes and HOA
  • Association Fee: $413.12
  • Association Fee Frequency: Monthly
  • Association Name: The Highlander Group
  • Association Phone: 2486817883
  • Association: Yes
  • Derived Association Fee Monthly: 413.12
  • Parcel Number: 15-21-351-150
  • Tax Annual Amount: $2,993.00
  • Tax Year: 2024
Parking
  • Attached Garage: Yes
  • Garage Spaces: 2.0
  • Garage: Yes
  • Parking Features: Attached, Garage Door Opener
Property
Lot Information
  • Lot Features: Cul-De-Sac, Wooded
  • Lot Size Acres: 55.02
  • Road Frontage Type: City Street
  • Road Responsibility: Public Maintained Road
Property and Assessments
  • Above Grade Finished Area: 1730.0
  • Building Area Total: 2580.0
  • Living Area: 1730.0
  • New Construction: No
  • Property Condition: Fixer
  • Property Sub Type: Condominium
  • Property Type: Residential
  • Raw Mls Bathrooms Total: 2.5
  • Raw Mls Documents Change Timestamp: 10-23-2025 01:05:32 PM
  • Raw Mls Documents Count: 4
  • Raw Mls Modification Timestamp: 11-21-2025 09:59:03 PM
  • Raw Mls Photos Change Timestamp: 10-23-2025 01:05:31 PM
  • Raw Mls Photos Count: 33
  • Raw Mls Property Sub Type: Condominium
  • Raw Mls Stories Total: 2.0
  • Year Built: 1979
Building Features
  • Construction Materials: Brick, Wood Siding
  • Stories Total: 2
Utilities
  • Sewer: Public Sewer
  • Water Source: Public
Interior and Exterior Features
Exterior Features
  • Association Amenities: Clubhouse, Tennis Court(s), Landscaping
  • Exterior Features: Tennis Court(s)
  • Patio And Porch Features: Deck, Porch, Terrace
  • Pool Features: Outdoor Pool
  • Pool Private: Yes
Interior Features
  • Appliances: Dishwasher, Dryer, Microwave, Refrigerator, Washer, Range, Oven, Gas Water Heater
  • Basement: Unfinished, Interior Entry
  • Basement: Yes
  • Bathrooms Full: 2
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 3
  • Bedrooms Total: 3
  • Cooling: Central Air
  • Cooling: Yes
  • Fireplace Features: Living Room, Master Bedroom
  • Fireplaces Total: 1
  • Fireplace: Yes
  • Heating: Forced Air, Natural Gas
  • Heating: Yes
  • Interior Features: Eat-in Kitchen, Walk-In Closet(s)
  • Laundry Features: Main Level
  • Water Heater: Gas
Room Information
Room 1
  • Room Dimensions: 11x10
  • Room Length: 11.0
  • Room Level: Second
  • Room Type: Bedroom 2
  • Room Width: 10.0
Room 2
  • Room Dimensions: 5x6
  • Room Length: 5.0
  • Room Level: First
  • Room Width: 6.0
Room 3
  • Room Description: Carpet
  • Room Dimensions: 13x14
  • Room Length: 13.0
  • Room Level: First
  • Room Type: Dining Room
  • Room Width: 14.0
Room 4
  • Room Dimensions: 6x7
  • Room Length: 6.0
  • Room Level: First
  • Room Type: Laundry
  • Room Width: 7.0
Room 5
  • Room Dimensions: 15x18
  • Room Length: 15.0
  • Room Level: Second
  • Room Type: Bedroom 1
  • Room Width: 18.0
Room 6
  • Room Dimensions: 11x10
  • Room Length: 11.0
  • Room Level: First
  • Room Type: Kitchen
  • Room Width: 10.0
Room 7
  • Room Description: Carpet
  • Room Dimensions: 13x14
  • Room Length: 13.0
  • Room Level: First
  • Room Type: Living Room
  • Room Width: 14.0
Room 8
  • Room Dimensions: 5x6
  • Room Length: 5.0
  • Room Level: First
  • Room Type: Bathroom 1
  • Room Width: 6.0
Room 9
  • Room Dimensions: 11x10
  • Room Length: 11.0
  • Room Level: Second
  • Room Type: Bedroom 3
  • Room Width: 10.0
Room 10
  • Room Dimensions: 11x5
  • Room Length: 11.0
  • Room Type: Bedroom 4
  • Room Width: 5.0
Rental
Rent Information
  • Pets Allowed: Yes, Cats OK, Dogs OK, Call, Breed Restrictions
  • Pets Allowed: Yes

Property History for 1812 Burning Bush Court

DateEvent & SourcePriceAppreciation
Nov 21, 2025

Sold (Public Record)

Public Record #1922005397

$286,585—
Nov 21, 2025

Sold

MiRealSource #50192376

$286,585—
Oct 25, 2025

Contract Signed

MiRealSource #50192376

—
DateEvent & SourcePrice
11/21/2025

Sold (Public Record)

Public Record #1922005397

$286,585
11/21/2025

Sold

MiRealSource #50192376

$286,585
10/25/2025

Contract Signed

MiRealSource #50192376

—

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 1812 Burning Bush Court

Taxable ValueLand-Additions-Total-
Tax Record2022$2,672 ($223 / month)
Home Facts
Beds3Baths2.5Total Finished SqFt1,730 SqFtAbove Grade Finished SqFt1,730 SqFtStories2Lot Size87,120 SqFtStyleCondominiumYear Built1979ZoningKICountyOAKLANDAPN70-15-21-351-150Fireplace TypeHas Fireplace

Schools near 1812 Burning Bush Court

This home is within Avondale School District.
Rating
School
Type
Grades
Distance
Public - K to 5
Public - 6 to 8
Public - 9 to 12
Public - 12
Rating
School
Distance
Deerfield Elementary School
PublicK to 5

Avondale Middle School
Public6 to 8

Avondale High School
Public9 to 12

Avondale Learning Center
Public12

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

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. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of Berkshire Hathaway HomeServices Kee Realty NB

Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Copyright 2026 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc.