687 W Bluff Court
Rochester Hills, MI 48307
- 3 beds
- 4 baths
- 2,038 sqft
- ~12 acre lot
- $208 per sqft
- 2003 build
- – on site
More homes
Welcome to this charming two story condo in the heart of Rochester Hills! This MOVE-IN READY condo offers a two-story open-concept floor plan, vaulted ceiling Great-room with all stone facade gas fireplace, A first floor primary bedroom suite featuring two-full size walk-in closets and a grand-master bathroom- Hardwood flooring throughout. The kitchen features ceramic tiling, premium cabinetry w/ granite stoned counter-tops and stainless steel appliances. The upper second level of the home offers a very large and spacious bedroom, full bath, with an additional ''loft-area'' overlooking great room....... Step your way down to The FULL-finished WALKOUT basement offering a Second living quarter with a full bedroom, full bathroom, Second kitchen too, a workout room, and large storage area.. This condo is centrally located nearby M59 and I-75 access. Nestled within the award winning Rochester-School district!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Apr 17, 2025
•
MLS# 24015841 —
The Building
-
Year Built:2003
-
New Construction:false
-
Construction Materials:Vinyl Siding
-
Architectural Style:Colonial
-
Foundation Details:None
-
Building Features:None
-
Window Features:Skylight(s), Insulated Windows, Bay/Bow
-
Patio And Porch Features:None
-
Accessibility Features:No
-
Direction Faces:None
-
Roof:None
-
Stories:2
-
Entry Type:Private
-
Basement:No
-
Basement:Walk Out, Full
-
Basement:Yes
-
Basement Finished SqFt:1169.0
-
Building Area Total:2038.0
-
Unit Number:44
-
Exterior Material -Vinyl Siding:true
-
Roofing -Shingle:true
-
Roofing -Asphalt:true
-
Below Grade Finished Area:1169.0
Interior
-
Rooms Total:2
-
Interior Features:Ceiling Fans, Ceramic Floor, Garage Door Opener, Wood Floor
-
Total Fireplaces:1.0
-
Fireplaces Total:1
-
Fireplace:true
-
Fireplace Features:Family
Room Dimensions
-
Living Area:3207.0
-
Main Level SqFt:2038.0
-
Basement SqFt:1169.0
Location
-
Directions:Between Rochester Rd. & Dequindre Rd. / South of Tienken Rd.
-
Cross Street:E. Tienken Rd & Letica Dr.
-
Latitude:42.696733
-
Longitude:-83.120883
The Property
-
Parcel Number:15-02-452-044
-
Property Type:Residential
-
Property Subtype:Condominium
-
Property Attached:No
-
Lot Size SqFt:542755.0
-
Lot Size Acres:12.46
-
Lot Size Area:12.46
-
Lot Size Units:Acres
-
Topography:None
-
Waterfront:false
-
View:None
-
View:No
-
Exterior Features:Balcony, Porch(es), Gazebo, Deck(s)
-
Fencing:None
-
Inclusions:None
-
Zoning:None
-
Current Use:None
-
Possible Use:None
-
Frontage Type:None
-
Water Access:No
-
Waterfront:No
-
Road Surface Type:Paved
-
Road Frontage Type:Private Road
Listing Agent
- Contact info:
- Agent phone:
- (248) 835-2303
- Office phone:
- (248) 835-2303
Taxes
-
Tax Year:2022
-
Tax Year:2022.0
-
Tax Legal Description:T3N, R11E, SEC 2 OAKLAND COUNTY CONDOMINIUM PLAN NO 1458 MILL STREAM VILLAGE UNIT 44 L26486 P670 9-9-02 FR 451-001
-
Tax Annual Amount:7453.0
-
Tax Assessed Value:154680
-
Taxable Value:154680.0
-
Annual Property Taxes:7453.0
Beds
-
Bedrooms Total:3
-
Main Bedrooms:1
-
Main Level Bedrooms:1
-
Basement Bedrooms:1
Baths
-
Total Baths:4
-
Total Baths:3.5
-
Partial Baths:None
-
Full Baths:1
-
Full Baths:3
-
Full Baths:1
-
Full Baths:1
-
Half Baths:1
-
Three Quarter Baths:None
-
Half Baths:1
-
Quarter Baths:None
The Listing
Heating & Cooling
-
Cooling:Central Air
-
Cooling:true
-
Heating:true
-
Heating:Forced Air, Natural Gas
-
Heat Type -Forced Air:true
-
Heat Source -Natural Gas:true
Utilities
-
Electric:None
-
Dishwasher:true
-
Central Air:true
-
Sewer:Public Sewer
-
Sewer -Publictrue
-
Water Source:Public
-
Water Public:true
-
Water Heater -Natural Gas:true
Appliances
-
Appliances:Dryer, Washer, Disposal, Cook Top, Dishwasher, Microwave, Refrigerator
-
Refrigerator:true
-
Disposal:true
-
Cook Top:true
-
Microwave:true
-
Washer:true
-
Dryer:true
-
Laundry Features:Laundry Room
Schools
-
Elementary School District:None
-
Middle Or Junior School District:None
-
High School District:Rochester
The Community
-
Subdivision:Mill Stream Village
-
Senior Community:No
-
Pool Private:No
-
Spa Features:None
-
Pets:Yes
-
Association:true%
-
Association Fee:425.0
-
Association Fee Includes:Trash, Snow Removal, Lawn/Yard Care
-
Association Fee Frequency:Monthly
-
Association Fee Including Trash:true
-
Association Fee Including Lawn Yard Care:true
-
Association Fee Including Snow Removal:true
Parking
-
Garage:true
-
Garage:true
-
Garage:Yes
-
Garage Attached:true
-
Attached Garage:true
-
Garage Spaces:2.0
-
Carport Spaces:None
-
Parking Total:None
-
Parking Features:Attached, Paved
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.