654 Glasgow Court

1,816 Sq. Ft.
$116 / Sq. Ft.
1,816
Sq. Ft.
$116
per Sq. Ft.

Description

This elegant updated condo is nestled in a prime location with views of the golf course/pond and trail. Freshly painted inside. New flooring throughout first floor. New carpet on second floor. Remodeled Bathrooms. Two-story Great Room with gas fireplace. Formal Dining Room with door wall leading to deck providing great views. Granite Kitchen with new stove, dishwasher. Upstairs Loft (14x13) can be Office/Den. Two Master Suites on second floor each with separate full Bathroom. Main Master Bedroom...This elegant updated condo is nestled in a prime location with views of the golf course/pond and trail. Freshly painted inside. New flooring throughout first floor. New carpet on second floor. Remodeled Bathrooms. Two-story Great Room with gas fireplace. Formal Dining Room with door wall leading to deck providing great views. Granite Kitchen with new stove, dishwasher. Upstairs Loft (14x13) can be Office/Den. Two Master Suites on second floor each with separate full Bathroom. Main Master Bedroom has large walk-in closet and door wall to Balcony and pond view. Finished Basement with built-in oak entertainment enter, wet bar and wine rack. 2-car attached Garage. New furnace (2019) HWH (2016). Immediate occupancy.
  1. Listed by Lisa Shih • Real Estate One-Troy
    P: (248)-703-8297 win_win_2000@yahoo.com
  2. Listed by Xu Jiang • Real Estate One-Troy
    P: (248)-813-4900 C: (248)-434-7736 reaganforever6@gmail.com

Property Details for 654 Glasgow Court

Architectural Style
Colonial
Subdivision Name
BARCLAY OCCPN 461
Waterfront
No
LISTING UPDATED: 06/18/2026 10:28 AM

Property Details for 654 Glasgow Court

StatusClosed
MLS #40003629
Days on Market41
Pet PolicyAllowed
Taxes$2,979 / year
HOA Fees$270 / month
Condo/Co-op Fees-
Property TypeCondo
MLS TypeResidential / Condominium
Year Built1990
CountyOakland County

Location

Listing Courtesy of Real Estate One-Troy

Sold By Max Broock, REALTORS®-Rochester

Add your commute

Building Information for 654 Glasgow Court

Building/Complex654 Glasgow CtFloor-Stories2Residences-Pet PolicyAllowedPet Policy DetailsPets AllowedYear Built1990

Payment Calculator

$1,565 per month

30 year fixed, 6.36% Interest

Principal and Interest

$1,046

Property Taxes

$248

HOA Dues

$270

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 654 Glasgow Court

Summary
Location and General Information
  • Cross Street: AUBURN ROAD
  • Directions: BARCLAY CIRCLE EAST OFF ROCHESTER ROAD - LEFT ON ASHLEY - LEFT ON GLASGOW CT.
  • Latitude: 42.644623
  • Longitude: -83.122398
  • MLS Area Major: Rochester Hills (63151)
Taxes and HOA
  • Association Fee: $270.00
  • Association Fee Frequency: Monthly
  • Association Fee Includes: Maintenance Grounds, Snow Removal, Water, Maintenance Structure, Trash
  • Association Phone: 2483779933
  • Association: Yes
  • Derived Association Fee Monthly: 270.0
  • Parcel Number: 1526326196
  • Tax Annual Amount: $2,979.00
Parking
  • Attached Garage: Yes
  • Garage Spaces: 2.0
  • Garage: Yes
  • Parking Features: Attached, Paved, Garage Door Opener, Direct Access
Property
Lot Information
  • Road Frontage Type: Private Road
  • Road Responsibility: Private Maintained Road
Property and Assessments
  • Above Grade Finished Area: 1416.0
  • Below Grade Finished Area: 400.0
  • Building Area Total: 2112.0
  • Custom 2: Yes
  • Living Area: 1816.0
  • Property Sub Type: Condominium
  • Property Type: Residential
  • Raw Mls Bathrooms Total: 2.5
  • Raw Mls Modification Timestamp: 07-26-2022 12:14:24 AM
  • Raw Mls Photos Change Timestamp: 08-03-2024 12:11:32 AM
  • Raw Mls Photos Count: 30
  • Raw Mls Property Sub Type: Condominium
  • Raw Mls Stories Total: 2.0
  • Year Built: 1990
Building Features
  • Construction Materials: Vinyl Siding
  • Stories Total: 2
Utilities
  • Utilities: Cable Available
Interior and Exterior Features
Exterior Features
  • Association Amenities: Clubhouse
  • Exterior Features: Tennis Court(s), Balcony
  • Patio And Porch Features: Patio
  • Pool Private: Yes
Interior Features
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Washer, Range, Oven, Gas Water Heater
  • Basement: Finished
  • Basement: Yes
  • Bathrooms Full: 2
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 3
  • Bedrooms Total: 2
  • Cooling: Ceiling Fan(s), Central Air
  • Cooling: Yes
  • Fireplace Features: Gas, Great Room
  • Fireplace: Yes
  • Heating: Forced Air, Natural Gas
  • Heating: Yes
  • Interior Features: Bar
  • Rooms Total: 10
  • Water Heater: Gas
Rental
Rent Information
  • Pets Allowed: Yes
  • Pets Allowed: Yes

Property History for 654 Glasgow Court

DateEvent & SourcePriceAppreciation
Feb 18, 2020

Sold

MiRealSource #40003629

$210,000
Feb 17, 2020

Sold (Public Record)

Public Record #665324946

$210,000

+5.5% / yr

Jan 5, 2020

Contract Signed

MiRealSource #40003629

DateEvent & SourcePrice
02/18/2020

Sold

MiRealSource #40003629

$210,000
02/17/2020

Sold (Public Record)

Public Record #665324946

$210,000

+5.5% / yr

01/05/2020

Contract Signed

MiRealSource #40003629

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

Public Records for 654 Glasgow Court

Taxable ValueLand-Additions-Total-
Tax Record2022$5,110 ($426 / month)
Home Facts
Beds2Baths2.5Total Finished SqFt1,416 SqFtAbove Grade Finished SqFt1,416 SqFtStories2Lot Size87,120 SqFtStyleCondominiumYear Built1990ZoningKICountyOAKLANDAPN70-15-26-326-196Fireplace TypeHas Fireplace

Schools near 654 Glasgow 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
Hampton Elementary School
PublicPK to 5

Reuther 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

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 Real Estate One-Troy

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.