NOT LISTED FOR SALE

Estimated Value: $1,334,901 - $1,535,000

6 Beds
4.5 Baths
2,779 Sq Ft
$507/Sq Ft Est. Value

Sale Details

Date Sold: July 29, 2025

Last sale price $1,390,000 $500 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $9,047 / mo

3 Days on Market

Highlights

  • 133 Feet of Waterfront
  • Contemporary Architecture
  • Bar Fridge
  • Deck
  • Stainless Steel Appliances
  • 2 Car Attached Garage

About This Home

As of July 2025

All Sports Middle Straits Lake –Located at the quiet end of the street, this rare lakefront property offers over 130 feet of shoreline and nearly 5,000 square feet of finished living space. With southern exposure and large windows throughout, the home is filled with natural light and views from sunrise to sunset. The landscaping was professionally designed to blend into the natural surroundings. A cascading waterfall flows toward the lake, framed by native plants and a natural stone path leading to the shoreline. Out back enjoy two maintenance-free Trex decks (2016) which offer great space to gather or relax. The generous lake frontage provides room for swimming, fishing, kayaking & time with family and friends. The neighborhood has miles of quiet, winding streets, perfect for walking or biking. The home is set up for hosting, with a circular driveway allowing easy access & plenty of parking. A beautiful aluminum front entry door makes a strong first impression. Seller updates include James Hardie siding and entry doors (2019), new windows (2015), roof (2018), gutters (2014)& a full sprinkler system (2016). Inside are new interior doors and four updated bathrooms. The walkout lower level was fully redesigned for entertaining. It includes heated floors, a full bar with walnut slab countertops, and two spacious bedrooms with a full bath, ideal for guests. There is also a dedicated wine room. Outdoors, the brick paver patio includes a built-in pizza oven and offers space to gather with friends, read a book, watch the birds, or relax in the sun, all while enjoying an incredible view of the lake. A small fenced-in area off the back garage provides space for pets. Additional features include heated floors in both the lower level & the primary bedroom. This home delivers lakefront living with the major investments already complete and room to personalize. Located within the award-winning Walled Lake School District.

Last Agent to Sell the Property

Tracy Johnson

Five Star Real Estate-Commerce License #6501374486 Listed on: 06/21/2025

Last Buyer's Agent

Chris Benedict

@properties Christie's Int'l RE Northville License #6501370968

@properties Christie's Int'l RE Northville

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1981

Lot Details

  • 22,651 Sq Ft Lot
  • Lot Dimensions are 139.36x185.65
  • 133 Feet of Waterfront

HOA Fees

  • $23 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Home Design

  • Contemporary Architecture
  • Poured Concrete
  • Asphalt Roof
  • Concrete Siding
  • Stone Siding

Interior Spaces

  • 2,779 Sq Ft Home
  • 1.5-Story Property
  • Bar Fridge
  • Ceiling Fan
  • Gas Fireplace
  • Living Room with Fireplace
  • Finished Basement

Kitchen

  • Built-In Gas Oven
  • Electric Cooktop
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Disposal

Bedrooms and Bathrooms

  • 6 Bedrooms

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Deck
  • Patio

Location

  • Ground Level

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater

Listing and Financial Details

  • Assessor Parcel Number 1818276013
  • Seller Concessions Offered

Community Details

Overview

  • Robb Szybitsy Association, Phone Number (248) 403-4016
  • Lakewood Estates Subdivision

Amenities

  • Laundry Facilities

Recreation

  • Water Sports

Home Details

Home Type

Single Family

Est. Annual Taxes

$18,069

Year Built

Built in 1981

Lot Details

0.52 Acres

HOA Fees

$23 per month

Listing Details

  • Property Type: Residential
  • Architecture Style: Contemporary
  • Architecture Level: 1 1/2 Story
  • Year Built: 1981
  • State Equalized Value: 545650.0000
  • Entry Location: Ground Level w/Steps
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Living Room
  • Total Bedrooms: 6
  • Total Bathrooms: 4.10
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Finished
  • Kitchen Appliances: Built-In Gas Oven, Dishwasher, Disposal, Dryer, Electric Cooktop, Free-Standing Refrigerator, Microwave, Stainless Steel Appliance(s), Washer, Bar Fridge
  • Total Sq Ft: 2779

Exterior Features

  • Roof Material: Asphalt
  • Waterfront Name: Middle Straits Lake
  • Waterfront: Yes
  • Foundation Details: Basement
  • Construction Materials: Concrete, Stone
  • Foundation Materials: Poured
  • Porch Type: Deck, Patio
  • Road Frontage Type: Paved
  • Water Frontage Feet: 133.00
  • Waterfront Description: Water Front

Garage/Parking

  • Garage Size: 2 Car
  • Garage Features: Attached
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Ceiling Fan(s), Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer (Sewer-Sanitary)
  • Water Heater Fuel: Natural Gas
  • Water Source: Public (Municipal)
  • Laundry Facilities: Yes

Condo/Co-op/Association

  • Association Fee Frequency: Annually
  • Phone: (248)403-4016
  • Association Fee: 275
  • Association Contact: Robb Szybitsy
  • Association Fee: Yes

Lot Info

  • Homestead: Yes
  • Lot Size Area: 0.52
  • Lot Dimensions: 139.36X185.65
  • Parcel Number: 1818276013

Tax Info

  • Tax Amount Summer: 10414.0000
  • Tax Amount Winter: 7655.0000
  • Total Tax: 18069.0000
  • Taxable Value: 535458.0000

Multi Family

  • Waterfront Features: All Sports Lake

MLS Schools

  • School District: Walled Lake

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 21, 2025
Closed on
Jul 29, 2025
Sold by
Neumann Udo and Neumann Anja G
Bought by
Lange Jay
Seller's Agent
Tracy Johnson
Five Star Real Estate-Commerce
Buyer's Agent
Chris Benedict
@properties Christie's Int'l RE Northville
List Price
$1,390,000
Sold Price
$1,390,000
Views
26
Current Estimated Value
$1,409,725

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$19,725
Avg. Annual Appreciation
1.82%
Original Mortgage
$1,112,000
Outstanding Balance
$1,111,054
Interest Rate
6.81%
Mortgage Type
New Conventional
Estimated Equity
$298,671

Purchase Details

Closed on
Dec 10, 2014
Sold by
Neumann Udo and Neumann Anja Gertrud
Bought by
Anja Neumann Revocable Trust

Purchase Details

Listed on
Apr 27, 2013
Closed on
Jun 26, 2013
Sold by
Liv Kennedy Joseph J and Liv Joseph J Kennedy Revocable
Bought by
Neumann Udo and Neumann Anja Gertrud
Seller's Agent
Rob Sprader
KW Showcase Realty
Buyer's Agent
Elaine Knuth
Century 21 Professionals Livonia
List Price
$655,000
Sold Price
$650,000
Premium/Discount to List
-$5,000
-0.76%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.20%

Purchase Details

Closed on
Dec 8, 2009
Sold by
Kennedy Joseph J and Kennedy Joyce A
Bought by
Liv Kennedy Joseph J and Liv Joseph J Kennedy Revocable
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
Lange Jay $1,390,000 Star Title Agency
Lange Jay $1,390,000 Star Title Agency
Anja Neumann Revocable Trust -- None Available
Neumann Udo $650,000 Multiple
Liv Kennedy Joseph J -- None Available
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open Lange Jay $1,112,000
Closed Lange Jay $1,112,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
07/29/2025 07/29/25 Sold $1,390,000 0.0% $500 / Sq Ft
06/24/2025 06/24/25 Pending -- -- --
06/21/2025 06/21/25 For Sale $1,390,000 +113.8% $500 / Sq Ft
06/27/2013 06/27/13 Sold $650,000 -0.8% $237 / Sq Ft View Prior Sale
06/27/2013 06/27/13 Pending -- -- --
04/27/2013 04/27/13 For Sale $655,000 -- $239 / Sq Ft
Source: Realcomp

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $18,069 $574,840 $221,010 $353,830
2024 $10,414 $545,650 $0 $0
2022 $9,818 $494,000 $200,920 $293,080
2021 $16,274 $475,040 $0 $0
2020 $9,741 $465,510 $200,920 $264,590
2018 $15,857 $446,860 $182,650 $264,210
2015 -- $508,850 $0 $0
2014 -- $457,060 $0 $0
2011 -- $375,000 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 20251009912

Realcomp

APN: 18-18-276-013

Your Personal Tour Guide

Ask me questions while you tour the home.