RARE LAKEFRONT RANCH CONDO! TUCKED AWAY IN A CUL DE SAC, THIS CONDOMINIUM OFFERS PRIVACY AND GORGEOUS LAKE VIEWS! KITCHEN FEATURES GRANITE COUNTERTOPS & BACKSPLASH AND A BREAKFAST NOOK. FORMAL DINING ROOM AND LIVING ROOM HAVE BEAUTIFUL VIEWS OF SIMPSON LAKE THROUGH THE FOUR DOORWALLS. THE FAMILY ROOM OFFERS MORE ENTERTAINING OR LIVING SPACE. UPDATED BATHROOMS AND SPACIOUS PRIMARY SUITE THAT HAS A HUGE WALK-IN CLOSET. OFFICE OFF OF LAUNDRY ROOM. ONE YEAR HOME WARRANTY OFFERED.
CondoProperty Type
1973Year Built
$201Est. Price/Sq.Ft.
2 car garageParking
Listed by Carl Cohen• KW Domain
Listed by Crystal Kizy• KW Domain
Bought with Darlene Kujanek• Berkshire Hathaway HomeServices Kee Realty
Welcome to this outstanding hard to find updated lakefront ranch. This condo is located on a culdesac and backs to Simpson lake. The back is all door walls showing off the exquisite view of the lake. Updated kitchen and bathrooms! Office area off of laundry room. Dining room and living room are adjoining for easy entertaining! Separate den for privacy. You don't want to miss this one!!! All showings must be physically accompanied by a licensed real estate agent. More pics coming soon! All measurements are approximate. Buyers/buyer's agent to verify all info including condo info and taxes. Must wear mask and gloves Offers due 7/14 by 4:00pm.
Public Records
Jan 13, 2003
Sold
$295,000
$130/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$6,272 (−19.7%)
2024
$7,809 (+5.0%)
2023
$7,435 (+2.4%)
2022
$7,261 (+4.5%)
2021
$6,948 (+15.3%)
2020
$6,026 (+78.8%)
2019
$3,370 (+1.2%)
2018
$3,331 (+0.9%)
2017
$3,301 (−0.7%)
2016
$3,324 (−0.3%)
2015
$3,333 (+0.8%)
2014
$3,305
Tax history for 5117 Simpson Lake Rd
Year
Property tax
Land + Additions
Assessment*
2025
$6,272 (−19.7%)
2024
$7,809 (+5.0%)
2023
$7,435 (+2.4%)
2022
$7,261 (+4.5%)
2021
$6,948 (+15.3%)
2020
$6,026 (+78.8%)
2019
$3,370 (+1.2%)
2018
$3,331 (+0.9%)
2017
$3,301 (−0.7%)
2016
$3,324 (−0.3%)
2015
$3,333 (+0.8%)
2014
$3,305
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Beds
3
Baths
2.5
Stories
1
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Sq. Ft.
2,277
Year built
1973
Style
Condo/Co-op
County
Oakland County
APN
X -18-23-451-055
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 13, 2026.
Property details
Parking
Parking/Garage Information
Has Garage
Has Attached Garage
# of Garage Spaces: 2
Parking Features: Attached, Driveway
Interior
Bathroom Information
# of Full Bathrooms: 2
Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Forced Air, Natural Gas
Interior Features
Appliances: Built-In Electric Oven, Dishwasher, Disposal, Dryer, Electric Cooktop, Free-Standing Refrigerator, Microwave, Washer
Room Information
# of Rooms Total: 10
Exterior
Exterior Features
Exterior Features: Lighting
Patio And Porch Features: Patio, Porch
Building Information
Entry Location: GroundLevelwSteps
Above Grade Finished Area: 2,277
Levels: One
Construction Materials: Brick, Vinyl Siding
Has Home Warranty
Foundation Details: Slab
Property Features
On Waterfront
Waterfront Features: Lake Front, Waterfront
Pets Allowed: Call
Property Information
Property Type: Residential
Property Sub Type: Condominium
Raw Mls Property Sub Type: Condominium
Lot Information
Water Body Name: SIMPSON LAKE
Road Surface Type: Paved
Lot Size Units: Acres
Financial
Tax Information
Tax Annual Amount: $7,609
Utilities
Utility Information
Water Source: Public
Sewer: Public Sewer
Location
HOA Information
Has Homeowners Association
Association Fee: $515
Association Fee Frequency: Monthly
Derived Association Fee (Monthly): $515
Association Fee Includes: Maintenance Grounds, Snow Removal, Trash
Schools Information
High School District: WestBloomfield
Location Information
Directions: SIMPSON LAKE RD IS N OF WALNUT LAKE RD, W OF MIDDLEBELT RD
Subdivision Name: WEST BLOOMFIELD FAIRWAYS OCCPN 129
Cross Street: N OF WALNUT LAKE RD, W OF MIDDLEBELT RD
Public facts
Beds: 3
Baths: 2.5
Sq. Ft.: 2,277
Stories: 1.0
Lot Size: —
Style: Condo/Co-op
Year Built: 1973
Year Renovated: —
County: Oakland County
APN: X -18-23-451-055
Home facts updated by county records on Aug 13, 2026
Other
Listing Information
List AOR: RealcompIILtd
Around this home
Schools
Doherty Elementary School
Public PreK-5 • Assigned • 0.7mi
6/10
Abbott Middle School
Public 6-8 • Assigned • 2.4mi
6/10
West Bloomfield High School
Public 9-12 • Assigned • 0.5mi
7/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
2/10 Heat Factor
7 days above 96° expected this year, 15 days in 30 years
2/10 Wind Factor
Minor risk of severe winds over next 30 years
3/10 Air Factor
2 unhealthy days expected this year, 4 days in 30 years
Provided by First Street
Historical weather
West Bloomfield, MI • 48323
Average low and high temperatures (°F)
27
14
34
18
51
31
60
40
67
48
80
60
85
66
79
60
76
54
65
45
49
36
35
23
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.6 hours in
June and 2.6 hours in December, placing it below the
U.S. average for solar exposure.
9.6 hrs
2.6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$434,000 – $526,000
Reach more buyers when you sell with Redfin. Save up to $4,567 in fees.3 minutes to get started.