1500 Streamwood Court

1,200 Sq. Ft.
$188 / Sq. Ft.
1,200
Sq. Ft.
$188
per Sq. Ft.

Description

Enjoy scenic river views from your bedroom balcony and back deck within the forest. This move-in ready, end unit condo is the perfect blend of nature and city, tucked away next to the Clinton River and near beautiful walking trails, yet close to shopping and restaurants. Enjoy brand new double pane windows and door walls (installed 2023), new gutters (2023) and a new air conditioning unit (2021), as well as award-winning Rochester Community Schools and friendly neighbors. Welcome home!Enjoy scenic river views from your bedroom balcony and back deck within the forest. This move-in ready, end unit condo is the perfect blend of nature and city, tucked away next to the Clinton River and near beautiful walking trails, yet close to shopping and restaurants. Enjoy brand new double pane windows and door walls (installed 2023), new gutters (2023) and a new air conditioning unit (2021), as well as award-winning Rochester Community Schools and friendly neighbors. Welcome home!
  1. Listed by Christina Podzikowski • KW Metro
    P: (248)-421-1399 C: (248)-421-1399 christinapodzikowski@atpropertiesremi.com

Property Details for 1500 Streamwood Court

Architectural Style
Colonial, End Unit
Subdivision Name
CRESTWOOD VILLAGE OF ROCHESTER HILLS OCCPN 1237
View
Water
Has View
Yes
Waterfront Features
River Front
Has Waterfront
Yes
LISTING CLOSED: 04/30/2024 12:00 AM

Property Details for 1500 Streamwood Court

StatusClosed
MLS #60294006
Days on Market4
Pet PolicyAllowed
Taxes$2,527 / year
HOA Fees$300 / month
Condo/Co-op Fees-
Property TypeCondo
MLS TypeResidential / Condominium
Year Built1986
CountyOakland County

Location

Listing Courtesy of KW Metro

Sold By KW Metro

Add your commute

Building Information for 1500 Streamwood Court

Building/Complex1500 Streamwood CtFloor-Stories2Residences-Pet PolicyAllowedPet Policy DetailsPets Allowed,CallYear Built1986

Payment Calculator

$1,654 per month

30 year fixed, 6.55% Interest

Principal and Interest

$1,144

Property Taxes

$211

HOA Dues

$300

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 1500 Streamwood Court

Summary
Location and General Information
  • Cross Street: NE of Hamlin & Crooks
  • Directions: From Hamlin, turn North on Streamwood Drive. Follow to Streamwood Court. Turn left.
  • Latitude: 42.656451
  • Longitude: -83.164583
  • MLS Area Major: Rochester Hills (63151)
  • Water Body Name: Clinton River
Taxes and HOA
  • Association Fee: $300.00
  • Association Fee Frequency: Monthly
  • Association Fee Includes: Maintenance Grounds, Snow Removal, Trash
  • Association Phone: 2486528221
  • Association: Yes
  • Association Fee Monthly: $300.00
  • Parcel Number: 1521327026
  • Tax Annual Amount: $2,527.00
Parking
  • Garage: No
  • Parking Features: Paved
Property
Lot Information
  • Lot Features: Wooded
Property and Assessments
  • Above Grade Finished Area: 1200.0
  • Building Area Total: 1200.0
  • Living Area: 1200.0
  • Property Sub Type: Condominium
  • Property Type: Residential
  • Year Built: 1986
Building Features
  • Construction Materials: Brick
  • Foundation Details: Slab
  • Total Stories: 2
Utilities
  • Sewer: Public Sewer
  • Water Source: Public
Interior and Exterior Features
Exterior Features
  • Association Amenities: Laundry
  • Exterior Features: Balcony
  • Patio And Porch Features: Deck, Terrace
Interior Features
  • Appliances: Dishwasher, Dryer, Microwave, Refrigerator, Washer, Range, Oven
  • Has Basement: No
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Total Bathrooms: 2
  • Total Bedrooms: 2
  • Cooling: Central Air
  • Has Cooling: Yes
  • Fireplace Features: Family Room, Electric
  • Has Fireplace: Yes
  • Heating: Forced Air, Natural Gas
  • Has Heating: Yes
  • Total Rooms: 8

Property History for 1500 Streamwood Court

DateEvent & SourcePriceAppreciation
Apr 30, 2024

Sold (Public Record)

Public Record #1532342286

$225,000

+9.0% / yr

Apr 30, 2024

Sold

MiRealSource #60294006

$225,000
Mar 17, 2024

Contract Signed

MiRealSource #60294006

DateEvent & SourcePrice
04/30/2024

Sold (Public Record)

Public Record #1532342286

$225,000

+9.0% / yr

04/30/2024

Sold

MiRealSource #60294006

$225,000
03/17/2024

Contract Signed

MiRealSource #60294006

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

Public Records for 1500 Streamwood Court

Taxable ValueLand-Additions-Total-
Tax Record2022$2,461 ($205 / month)
Home Facts
Beds2Baths1.5Total Finished SqFt1,200 SqFtAbove Grade Finished SqFt1,200 SqFtStories2StyleCondominiumYear Built1986ZoningKICountyOAKLANDAPN70-15-21-327-026

Schools near 1500 Streamwood Court

This home is within Rochester Community School District.
Rating
School
Type
Grades
Distance
Public - PK to 5
Public - 6 to 12
Public - 7 to 12
Public - 9 to 12
Rating
School
Distance
University Hills Elementary School
PublicPK to 5

West Middle School
Public6 to 12

Rochester High School
Public7 to 12

John M Schultz Educational Campus
Public9 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

Nearby home values

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 KW Metro

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.