Beautifully maintained four-bedroom, 3.5-bath home located in the highly sought-after Stony Creek Ridge subdivision, within the award-winning Rochester school district. This spacious residence features a desirable walk-out finished basement, offering additional living and entertaining space with easy access to the outdoors. The home boasts an open and inviting floor plan, generous bedrooms, and plenty of natural light throughout. Enjoy the benefits of a vibrant community with access to a neighborhood pool and clubhouse.Perfect for relaxing and socializing during the warmer months. A perfect blend of comfort, convenience, and location - this home is ideal for modern family living.
Pending
$742,000
247 Glenmoor Dr, Rochester, MI 48307
4beds
4,062sqft
Est.:
Single Family Residence
Built in 1997
10,018.8 Square Feet Lot
$753,400 Zestimate®
$183/sqft
$77/mo HOA
What's special
- 26 days |
- 2,272 |
- 79 |
Zillow last checked:
Listing updated:
Listed by:
Josephine A Gunn 248-376-2610,
Keller Williams Paint Creek 248-609-8000
Source: Realcomp II,MLS#: 20261015244
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Level: Second
- Area: 210
- Dimensions: 15 X 14
Bedroom
- Level: Second
- Area: 143
- Dimensions: 11 X 13
Bedroom
- Level: Second
- Area: 154
- Dimensions: 11 X 14
Bedroom
- Level: Second
- Area: 144
- Dimensions: 12 X 12
Primary bathroom
- Level: Second
- Area: 135
- Dimensions: 15 X 9
Other
- Level: Second
- Area: 49
- Dimensions: 7 X 7
Other
- Level: Basement
- Area: 54
- Dimensions: 9 X 6
Other
- Level: Entry
- Area: 49
- Dimensions: 7 X 7
Dining room
- Level: Entry
- Area: 143
- Dimensions: 11 X 13
Family room
- Level: Entry
- Area: 270
- Dimensions: 15 X 18
Kitchen
- Level: Entry
- Area: 168
- Dimensions: 12 X 14
Laundry
- Level: Entry
- Area: 56
- Dimensions: 8 X 7
Library
- Level: Entry
- Area: 140
- Dimensions: 10 X 14
Sitting room
- Level: Entry
- Area: 154
- Dimensions: 11 X 14
Heating
- ENERGYSTAR Qualified Furnace Equipment, Forced Air, Natural Gas
Cooling
- Ceiling Fans, Central Air
Appliances
- Included: Dishwasher, Disposal, Dryer, Free Standing Gas Range, Free Standing Refrigerator, Range Hood, Washer
Features
- Basement: Finished,Full,Walk Out Access
- Has fireplace: Yes
- Fireplace features: Basement, Family Room, Gas
Interior area
- Total interior livable area: 4,062 sqft
- Finished area above ground: 2,800
- Finished area below ground: 1,262
Property
Parking
- Total spaces: 2.5
- Parking features: Twoand Half Car Garage, Attached
- Attached garage spaces: 2.5
Features
- Levels: Three
- Stories: 3
- Entry location: GroundLevelwSteps
- Pool features: Community, In Ground, Outdoor Pool
Lot
- Size: 10,018.8 Square Feet
- Dimensions: 64 x 120 x 95 x 132
Details
- Parcel number: 1512427006
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial,Traditional
- Property subtype: Single Family Residence
Materials
- Brick, Wood Siding
- Foundation: Basement, Poured
Condition
- New construction: No
- Year built: 1997
Utilities & green energy
- Sewer: Public Sewer, Sewer At Street
- Water: Waterat Street
Community & HOA
Community
- Subdivision: STONY CREEK RIDGE 1
HOA
- Has HOA: Yes
- HOA fee: $925 annually
- HOA phone: 248-224-4475
Location
- Region: Rochester
Financial & listing details
- Price per square foot: $183/sqft
- Tax assessed value: $213,300
- Annual tax amount: $6,966
- Date on market: 3/20/2026
- Cumulative days on market: 26 days
- Listing agreement: Exclusive Agency
- Listing terms: Cash,Conventional,FHA,Va Loan
Estimated market value
$753,400
$716,000 - $791,000
$4,117/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 3/26/2026 | Pending sale | $742,000$183/sqft |
Source: | ||
| 3/20/2026 | Listed for sale | $742,000+153.1%$183/sqft |
Source: | ||
| 7/30/1997 | Sold | $293,145$72/sqft |
Source: Public Record Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $6,465 +5% | $277,320 +11.9% |
| 2023 | $6,157 +6.4% | $247,740 +8% |
| 2022 | $5,785 -4.1% | $229,450 +1.4% |
| 2021 | $6,034 | $226,220 +3.8% |
| 2020 | -- | $217,840 +2.6% |
| 2019 | $5,972 +2.1% | $212,310 +2.5% |
| 2018 | $5,847 +3.3% | $207,050 +0.6% |
| 2017 | $5,661 | $205,810 +2.6% |
| 2016 | $5,661 | $200,500 +5.3% |
| 2015 | -- | $190,360 +7.3% |
| 2014 | -- | $177,330 +15.8% |
| 2011 | -- | $153,110 +0.1% |
| 2010 | $5,382 -8.3% | $153,000 -12.3% |
| 2009 | $5,868 +14.7% | $174,410 -53.5% |
| 2005 | $5,114 | $375,050 +83.4% |
| 2003 | -- | $204,490 +11.3% |
| 2002 | -- | $183,730 +14% |
| 2001 | $5,797 +4.8% | $161,130 +3.2% |
| 2000 | $5,531 | $156,140 |
Find assessor info on the county website
Monthly payment
Est. payment
$4,502/mo
Principal & interest
$3596
Property taxes
$829
HOA Fees
$77
More affordability tools
Climate risks
Neighborhood: 48307
Nearby schools
GreatSchools rating
- 8/10North Hill Elementary SchoolGrades: PK-5Distance: 1.8 mi
- 9/10Stoney Creek High SchoolGrades: 6-12Distance: 1.5 mi
- 8/10Hart Middle SchoolGrades: PK,6-12Distance: 1.7 mi
A local agent can set up tours, give advice and negotiate with sellers.
- Michigan
- Oakland County
- Rochester
- 48307
- 247 Glenmoor Dr






