Immaculate Lakefront Executive Home is situated on a spacious lot in the prestigious Northshore Village community offering exclusive access to a private beach and playground. Quiet Cul-de-sac street ideally located between the vibrant towns of Brighton and Howell, residents enjoy quick access to major highways and top-rated schools with endless outdoor recreation opportunities only a few minutes away. Your favorite lake and watersports activities are directly out the back door with a private shared dock that is maintained by an association so you enjoy all of the lake-living benefits without any of the maintenance hassles. This custom-built luxury home featuring two laundry rooms boasts over 5500 sq ft of meticulously designed space with 5 bedrooms and 4.5 bathrooms, the convenience of a first-floor primary suite, a stunning two-story great room, spacious Chef's kitchen with walk-in pantry and cozy hearth room plus a separate dining room and stately Library/den. Highlights of the professionally finished walk-out basement include an artisan crafted bar integrated into a huge entertainment area with dance floor, plus a large bedroom/fitness studio and full bathroom that all combine to provide over 1700 sq ft of upscale finished living space. The unique single car garage in the walkout lower level provides enormous storage potential with easy access to your all-sports lake toys. New roof, updated HVAC, and fresh paint combined with the expansive views of East (Big) Crooked Lake make this move-in ready gem a MUST SEE!!
Single-familyProperty Type
2007Year Built
0.49 acresLot Size
$243Est. Price/Sq.Ft.
3 car garageParking
Listed by Dean Tengel• GTM Realty
Bought with Kirsten Soulliere• KW Realty Livingston
Immaculate Lakefront Executive Home is situated on a spacious lot in the prestigious Northshore Village community offering exclusive access to a private beach and playground. Quiet Cul-de-sac street ideally located between the vibrant towns of Brighton and Howell, residents enjoy quick access to major highways and top-rated schools with endless outdoor recreation opportunities only a few minutes away. Your favorite lake and watersports activities are directly out the back door with a private shared dock that is maintained by an association so you enjoy all of the lake-living benefits without any of the maintenance hassles. This custom-built luxury home featuring two laundry rooms boasts over 5500 sq ft of meticulously designed space with 5 bedrooms and 4.5 bathrooms, the convenience of a first-floor primary suite, a stunning two-story great room, spacious Chef's kitchen with walk-in pantry and cozy hearth room plus a separate dining room and stately Library/den. Highlights of the professionally finished walk-out basement include an artisan crafted bar integrated into a huge entertainment area with dance floor, plus a large bedroom/fitness studio and full bathroom that all combine to provide over 1700 sq ft of upscale finished living space. The unique single car garage in the walkout lower level provides enormous storage potential with easy access to your all-sports lake toys. New roof, updated HVAC, and fresh paint combined with the expansive views of East (Big) Crooked Lake make this move-in ready gem a MUST SEE!!
Public Records
Aug 24, 2006
Sold
$258,000
$46/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$6,419 (+3.0%)
2024
$6,230 (+7.1%)
2023
$5,816 (+5.1%)
2022
$5,535 (+2.6%)
2021
$5,395 (−1.2%)
2020
$5,463 (+1.5%)
2019
$5,383 (+5.3%)
2018
$5,114 (+1.5%)
2017
$5,040 (+0.6%)
2016
$5,010 (+5.2%)
2015
$4,762 (−0.3%)
2014
$4,777
Tax history for 3158 Aspen Ridge Ct
Year
Property tax
Land + Additions
Assessment*
2025
$6,419 (+3.0%)
2024
$6,230 (+7.1%)
2023
$5,816 (+5.1%)
2022
$5,535 (+2.6%)
2021
$5,395 (−1.2%)
2020
$5,463 (+1.5%)
2019
$5,383 (+5.3%)
2018
$5,114 (+1.5%)
2017
$5,040 (+0.6%)
2016
$5,010 (+5.2%)
2015
$4,762 (−0.3%)
2014
$4,777
*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
3.5
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Sq. Ft.
3,859
Year built
2007
Style
Condo/Co-op
County
Livingston County
APN
4711-22-102-139
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jun 22, 2026.
Property details
Parking
Parking/Garage Information
Has Garage
Has Attached Garage
# of Garage Spaces: 3
Parking Features: Attached, Garage Faces Side
Interior
Bathroom Information
# of Full Bathrooms: 4
# of Half Bathrooms: 1
Heating & Cooling
Has Cooling
Cooling: Ceiling Fan(s), Central Air
Has Heating
Heating: Forced Air, Natural Gas
Interior Features
Interior Features: High Speed Internet
Appliances: Gas Water Heater, Built-In Gas Oven, Dishwasher, Disposal, Dryer, Free-Standing Refrigerator, Gas Cooktop, Microwave, Range Hood, Washer
Has Fireplace
Fireplace Features: Gas, Great Room
Room Information
# of Rooms Total: 15
Laundry Features: Laundry Room
Has Basement
Basement Details: Finished, Full, Walk-Out Access
Exterior
Exterior Features
Patio And Porch Features: Patio, Porch
Roof: Asphalt
Pool Information
Pool Features: None
Building Information
Entry Location: GroundLevel
Above Grade Finished Area: 3,859
Below Grade Finished Area: 1,722
Levels: Two
Construction Materials: Brick, Wood Siding
Property Features
On Waterfront
Waterfront Features: Lake Front, Waterfront
Has View
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: SingleFamilyResidence
Lot Information
Water Body Name: East Crooked Lake
Road Surface Type: Paved
Lot Size : 0.49
Lot Size Dimensions: Irregular
Lot Size Area: 0.49
Lot Size Units: Acres
Lot Size Acres: 0.49
Financial
Tax Information
Tax Annual Amount: $6,002
Utilities
Utility Information
Water Source: Public
Utilities: Underground Utilities
Sewer: Public Sewer
Location
HOA Information
Has Homeowners Association
Association Fee: $1,350
Association Fee Frequency: Annually
Derived Association Fee (Monthly): $112.50
Schools Information
High School District: Howell
Location Information
Directions: Latson Road to East on Crooked Lake Rd, South (2nd Northshore sub entrance) on Edgewood Shores Drive then Right on to Aspen Ridge Court
Cross Street: Crooked Lake/ Latson
Public facts
Beds: 3
Baths: 3.5
Sq. Ft.: 3,859
Stories: —
Lot Size: —
Style: Condo/Co-op
Year Built: 2007
Year Renovated: —
County: Livingston County
APN: 4711-22-102-139
Home facts updated by county records on Jun 22, 2026
Other
Listing Information
List AOR: RealcompIILtd
Around this home
Schools
Three Fires Elementary
Public K-5 • Assigned • 1.2mi
7/10
Parker Middle School
Public K-8 • Assigned • 4.2mi
6/10
Howell High School
Public 9-12 • Assigned • 6.6mi
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
2/10 Air Factor
1 unhealthy days expected this year, 2 days in 30 years
Provided by First Street
Historical weather
Howell, MI • 48843
Average low and high temperatures (°F)
27
15
34
18
51
31
60
40
67
48
79
60
83
65
79
59
76
55
65
44
48
36
35
23
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.7 hours in
June and 2.6 hours in December, placing it below the
U.S. average for solar exposure.
9.7 hrs
2.6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$1.29M – $1.56M
Reach more buyers when you sell with Redfin. Save up to $13,568 in fees.3 minutes to get started.