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 • Brokerage DRE #6503288502 • Real Estate One-Troy
    P: (248)-703-8297 C: (248)-703-8297 win_win_2000@yahoo.com
  2. Listed by Xu Jiang • Brokerage DRE #6503288502 • Real Estate One-Troy
    P: (248)-813-4900 C: (248)-434-7736 reaganforever6@gmail.com

Property Details for 654 Glasgow Court

Subdivision Name
BARCLAY OCCPN 461
Architectural Style
Colonial
Waterfront
No
LISTING CLOSED: 02/18/2020 12:00 AM

Property Details for 654 Glasgow Court

StatusSold
MLS #219118803
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 CtFloorGroundLevelStories-Residences-Pet PolicyAllowedPet Policy DetailsYesYear Built1990

Payment Calculator

$1,586 per month

30 year fixed, 6.55% Interest

Principal and Interest

$1,067

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
  • Directions: BARCLAY CIRCLE EAST OFF ROCHESTER ROAD - LEFT ON ASHLEY - LEFT ON GLASGOW CT.
  • Latitude: 42.643026
  • Longitude: -83.122842
  • Cross Street: N of AUBURN ROAD/E of ROCHESTER ROAD
  • MLS Area Major: Rochester Hills (63151)
Taxes and HOA
  • Association Fee: $270.00
  • Association Phone: 2483779933
  • Parcel Number: 1526326196
  • Tax Amount Summer: $1,599.00
  • Tax Amount Winter: $1,380.00
  • Tax Annual Amount: $2,979.00
  • Tax Assessed Value: $60,410.00
  • Tax Legal Description: T3N, R11E, SEC 26 OAKLAND COUNTY CONDOMINIUM PLAN NO 461 BARCLAY UNIT 217, BLDG 44 L 9505 P 651 7-9-90 FR 182
  • Association Fee Frequency: Monthly
  • Association Fee Includes: Insurance, Maintenance Grounds, Maintenance Structure, Snow Removal, Trash, Water
  • Association Contact: LANDARC, INC.
  • Association: Yes
School Information
  • High School District: Rochester
Parking
  • Garage Spaces: 2.0
  • Attached Garage: Yes
  • Garage: Yes
  • Parking Features: Two Car Garage, Attached, Direct Access, Electricityin Garage, Garage Door Opener
Virtual Tour
  • Virtual Tour URL Unbranded: X
Property
Lot Information
  • Lot Features: Sprinklers
  • Road Frontage Type: Paved, Private Road
  • Road Responsibility: Private Maintained Road
Property and Assessments
  • State Equalized Value: 89280.0
  • Living Area: 1816.0
  • Building Area Total: 2112.0
  • Above Grade Finished Area: 1416.0
  • Below Grade Finished Area: 400.0
  • Above Grade Finished Area Units: Square Feet
  • Below Grade Finished Area Units: Square Feet
  • Below Grade Total Area: 696.0
  • Below Grade Total Area Units: Square Feet
  • Class Name: Residential
  • Living Area Source: Public Records
  • Living Area Units: Square Feet
  • Property Condition: Platted Sub
  • Year Built: 1990
Building Features
  • Construction Materials: Vinyl Siding
  • Entry Location: Ground Level
  • Foundation Details: Basement, Poured, Sump Pump
  • Levels: Two
  • Year Remodeled: 2019
  • Stories Total: 2
Utilities
  • Sewer: Public Sewer
  • Utilities: Cable Available
  • Water Source: Public
Interior and Exterior Features
Interior Features
  • Bathrooms Total Notational: 2.1
  • Appliances: Dishwasher, Disposal, Dryer, Free Standing Electric Range, Free Standing Refrigerator, Microwave, Washer
  • Basement: Finished
  • Has Basement: Yes
  • Bathrooms Full: 2
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 3
  • Bedrooms Total: 2
  • Cooling: Ceiling Fans, Central Air
  • Has Cooling: Yes
  • Fireplace Features: Gas, Great Room
  • Fireplace: Yes
  • Flooring: Carpet, Ceramic Tile, Concrete, Laminate
  • Heating: Forced Air, Natural Gas
  • Has Heating: Yes
  • Interior Features: Wet Bar
  • Rooms Total: 7
  • Water Heater Fuel: Natural Gas
Exterior Features
  • Association Amenities: Clubhouse
  • Community Features: Clubhouse, Tennis Courts
  • Exterior Features: Balcony, Grounds Maintenance, Lighting, Private Entrance, Tennis Courts
  • Patio And Porch Features: Patio
  • Pool Features: Community
  • Pool Private: Yes
Room Information
Room 1
  • Room Dimensions: 13 x 12
  • Room Length: 13.0
  • Room Width: 12.0
  • Room Flooring: Carpet
  • Room Length Width Units: Feet
  • Room Level: Second
  • Room Type: Primary Bedroom
Room 2
  • Room Dimensions: 6 x 6
  • Room Length: 6.0
  • Room Width: 6.0
  • Room Flooring: Laminate
  • Room Length Width Units: Feet
  • Room Level: Entry
  • Room Type: Bath Lav
Room 3
  • Room Dimensions: 12 x 10
  • Room Length: 12.0
  • Room Width: 10.0
  • Room Flooring: Carpet
  • Room Length Width Units: Feet
  • Room Level: Second
  • Room Type: Bedroom
Room 4
  • Room Dimensions: 9 x 6
  • Room Length: 9.0
  • Room Width: 6.0
  • Room Flooring: Concrete
  • Room Length Width Units: Feet
  • Room Level: Basement
  • Room Type: Laundry
Room 5
  • Room Dimensions: 13 x 11
  • Room Length: 13.0
  • Room Width: 11.0
  • Room Flooring: Laminate
  • Room Length Width Units: Feet
  • Room Level: Entry
  • Room Type: Kitchen
Room 6
  • Room Dimensions: 14 x 13
  • Room Length: 14.0
  • Room Width: 13.0
  • Room Flooring: Carpet
  • Room Length Width Units: Feet
  • Room Level: Second
  • Room Type: Loft
Room 7
  • Room Dimensions: 10 x 5
  • Room Length: 10.0
  • Room Width: 5.0
  • Room Flooring: Ceramic Tile
  • Room Length Width Units: Feet
  • Room Level: Second
  • Room Type: Primary Bathroom
Room 8
  • Room Dimensions: 11 x 10
  • Room Length: 11.0
  • Room Width: 10.0
  • Room Flooring: Laminate
  • Room Length Width Units: Feet
  • Room Level: Entry
  • Room Type: Dining Room
Room 9
  • Room Dimensions: 10 x 6
  • Room Length: 10.0
  • Room Width: 6.0
  • Room Flooring: Ceramic Tile
  • Room Length Width Units: Feet
  • Room Level: Second
  • Room Type: Bath Full
Room 10
  • Room Dimensions: 17 x 13
  • Room Length: 17.0
  • Room Width: 13.0
  • Room Flooring: Laminate
  • Room Length Width Units: Feet
  • Room Level: Entry
  • Room Type: Great Room
Agent
Sale and Listings
  • Public GLR Website: Yes
Rental
Rent Information
  • Existing Lease: No
  • Pets Allowed: Yes

Property History for 654 Glasgow Court

DateEvent & SourcePriceAppreciation
Feb 18, 2020

Sold

MiRealSource #40003629

$210,000
Feb 18, 2020

Sold

Realcomp #219118803

$210,000
Feb 17, 2020

Sold (Public Record)

Public Record #665324946

$210,000

+5.5% / yr

DateEvent & SourcePrice
02/18/2020

Sold

MiRealSource #40003629

$210,000
02/18/2020

Sold

Realcomp #219118803

$210,000
02/17/2020

Sold (Public Record)

Public Record #665324946

$210,000

+5.5% / yr

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

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.

Listing Courtesy of Real Estate One-Troy

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 09/09/2023 09:38 AM PST