NOT LISTED FOR SALE

Estimated Value: $655,000 - $1,976,428

6 Beds
6 Baths
4,200 Sq Ft
$324/Sq Ft Est. Value

Last Sold December 15, 2023

Last sale price $1,750,000 $417 Per Sq Ft

Est. 22% decrease in value since last sale

Current estimated payment $8,344/month

63 Days on Market

Highlights

  • New Construction
  • Heated Floors
  • Recreation Room
  • Rooftop Deck
  • Family Room with Fireplace
  • 2-minute walk to Snowberry Park

About This Home

As of December 2023

Incredible new construction home! This is a truly beautiful home from Tullamore Dev and is built with amzng crftsmnshp and attention to detail. With a very thoughtful open floor-plan this house will impress you on every level. Featuring custom stone exterior, 6 bedrooms and 4.2 baths, the home is equipped with smart technology allowing for remote access to heating/cooling & security. A fabulous chefs kitchen with Subzero, Wolf & Bosch Appliances, additional prep sink and 2nd dishwasher, and a beverage center. Three fireplaces, two inside and one outdoor. Stunning spa like master bath, with steam shower, heated floors, and wonderful standalone soaking tub. Wonderful and bright lower level with heated floors, full wet bar, a sauna and rare (6th) bedroom/office! This home has incredible outdoor space - a patio with custom fireplace off the family room, fully built out garage roof deck. Heated front limestone stairs. Late fall delivery. Photos of previous build from developer

Last Agent to Sell the Property

Kevin Bigoness

Baird & Warner License #475158125 Listed on: 06/22/2023

Baird & Warner

Last Buyer's Agent

Izabela Sloma

Compass License #475132816

Compass

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $14,602

Year Built

  • Built in 2023 | New Construction

Lot Details

  • Lot Dimensions are 24x125

Parking

  • 2 Car Detached Garage
  • Garage Door Opener
  • Parking Included in Price

Interior Spaces

  • 4,200 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Vaulted Ceiling
  • Wood Burning Fireplace
  • Gas Log Fireplace
  • Mud Room
  • Family Room with Fireplace
  • 2 Fireplaces
  • Living Room with Fireplace
  • Recreation Room

Flooring

  • Wood
  • Heated Floors

Bedrooms and Bathrooms

  • 6 Bedrooms
  • 6 Potential Bedrooms
  • Dual Sinks
  • Soaking Tub
  • Steam Shower
  • Shower Body Spray
  • Separate Shower

Finished Basement

  • English Basement
  • Basement Fills Entire Space Under The House
  • Finished Basement Bathroom

Outdoor Features

  • Rooftop Deck
  • Brick Porch or Patio

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • Radiant Heating System
  • 200+ Amp Service
  • Lake Michigan Water

Home Details

Home Type

Single Family

Est. Annual Taxes

$14,602

Year Built

Built in 2023 | New Construction

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Property Type: Detached Single
  • Type Detached: 2 Stories
  • Ownership: Fee Simple
  • New Construction: Yes
  • Property Sub-Type: 2 Stories
  • Year Built: 2023
  • Age: NEW Under Construction
  • Built Before 1978 (Y/N): No
  • Disability Access and/or Equipped: No
  • General Information: None
  • Rebuilt (Y/N): No
  • Rehab (Y/N): No
  • New Construction Y/N: Yes
  • ResoPropertyType: Residential
  • Special Features: NewHome
  • Property Sub Type: Detached

Interior Features

  • Basement: Full, English
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Total Bathrooms: 6
  • Total Bedrooms: 6
  • Fireplace Features: Wood Burning, Gas Log, Gas Starter
  • Fireplaces: 2
  • Interior Amenities: Vaulted/Cathedral Ceilings, Bar-Wet, Hardwood Floors, Heated Floors
  • LivingArea: 4200
  • Room Type: Bedroom 5, Bedroom 6, Mud Room, Recreation Room
  • Estimated Total Finished Sq Ft: 0
  • Basement Description: Finished
  • Bathroom Amenities: Separate Shower,Steam Shower,Double Sink,Full Body Spray Shower,Soaking Tub
  • Basement Bathrooms: Yes
  • Below Grade Bedrooms: 0
  • Fireplace Location: Family Room,Living Room,Other
  • Total Sq Ft: 0

Exterior Features

  • ExteriorFeatures: Patio, Roof Deck, Brick Paver Patio
  • Waterfront: No
  • Exterior Building Type: Frame,Stone

Garage/Parking

  • Garage Spaces: 2
  • ParkingTotal: 2
  • Garage Details: Garage Door Opener(s)
  • Garage On-Site: Yes
  • Garage Ownership: Owned
  • Garage Type: Detached
  • Parking: Garage

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air
  • Electric: 200+ Amp Service
  • Heating: Natural Gas, Radiant
  • Water Source: Lake Michigan

Condo/Co-op/Association

  • Association Fee Frequency: Not Applicable
  • Master Association Fee Frequency: Not Required

Fee Information

  • Association Fee Includes: None

Lot Info

  • Lot Dimensions: 24X125
  • Lot Size: Less Than .25 Acre
  • Special Assessments: N

Rental Info

  • Board Number: 8
  • Is Parking Included in Price: Yes

Tax Info

  • Tax Year: 2021
  • Tax Exemptions: None

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 22, 2023
Closed on
Dec 7, 2023
Sold by
John Downes Construction Inc
Bought by
Lehrman Michael and Lehrman Megan
Seller's Agent
Kevin Bigoness
Baird & Warner
Buyer's Agent
Izabela Sloma
Compass
List Price
$1,750,000
Sold Price
$1,750,000
Views
31
Current Estimated Value
$1,361,607

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$388,393
Avg. Annual Appreciation
-12.56%
Original Mortgage
$1,200,000
Outstanding Balance
$1,108,033
Interest Rate
5.88%
Mortgage Type
New Conventional
Estimated Equity
$253,574

Purchase Details

Closed on
Oct 10, 2022
Sold by
Guerra Glenn
Bought by
John Dones Construction Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$386,250
Interest Rate
5.66%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 23, 2003
Sold by
Guzman Joseph and Guzman Amy
Bought by
Guerra Glenn

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$260,000
Interest Rate
5.31%
Mortgage Type
Commercial

Purchase Details

Closed on
Dec 10, 1997
Sold by
Mcdonough Michael J and Mcdonough Jodi D
Bought by
Guzman Joseph and Guzman Amy Martell

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$149,150
Interest Rate
7.32%
Mortgage Type
Commercial

Purchase Details

Closed on
Oct 10, 1996
Sold by
Judkins Franz Joseph and Moran Gail
Bought by
Mcdonough Michael J and Mcdonough Jodi D

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$128,250
Interest Rate
8.44%
Mortgage Type
Commercial
Source: Public Records

Range of Values:

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

Date Buyer Sale Price Title Company
Lehrman Michael $1,750,000 Chicago Title Insurance Compan
John Dones Construction Inc $515,000 None Listed On Document
Guerra Glenn $325,000 Cti
Guzman Joseph $157,000 --
Mcdonough Michael J $135,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Lehrman Michael $1,200,000
Previous Owner John Dones Construction Inc $386,250
Previous Owner Guerra Glenn $260,000
Previous Owner Guzman Joseph $149,150
Previous Owner Mcdonough Michael J $128,250
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
12/15/2023 12/15/23 Sold $1,750,000 0.0% $417 / Sq Ft
08/25/2023 08/25/23 Pending -- -- --
06/22/2023 06/22/23 For Sale $1,750,000 -- $417 / Sq Ft
Source: Midwest Real Estate Data (MRED)

Tax History Compared to Growth

Source: Public Records

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
2024 $14,602 $162,500 $22,171 $140,329
2023 $13,489 $69,000 $17,856 $51,144
2022 $13,489 $69,000 $17,856 $51,144
2021 $13,206 $69,000 $17,856 $51,144
2020 $8,507 $41,288 $10,118 $31,170
2019 $8,632 $46,392 $10,118 $36,274
2018 $8,485 $46,392 $10,118 $36,274
2017 $6,923 $35,535 $8,928 $26,607
2016 $6,617 $35,535 $8,928 $26,607
2015 $6,031 $35,535 $8,928 $26,607
2014 $5,663 $33,093 $7,440 $25,653
2013 $5,541 $33,093 $7,440 $25,653
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: 11767247

Midwest Real Estate Data (MRED)

APN: 17-07-209-041-0000