NOT LISTED FOR SALE

4218 W Puetz Rd Franklin, WI 53132

Estimated Value: $445,000 - $1,507,918

5 Beds
4.5 Baths
6,007 Sq Ft
$199/Sq Ft Est. Value

Last Sold February 19, 2021

Last sale price $1,000,000 $166 Per Sq Ft

Est. 19% increase in value since last sale

Current estimated payment $7,197/month

125 Days on Market

Highlights

  • Waterfront
  • 3.5 Acre Lot
  • Wooded Lot
  • Oak Creek West Middle School Rated A-
  • Pond
  • Main Floor Bedroom

About This Home

As of February 2021

Custom Private Retreat on 3.5 acres! This 5 BDRM, 4.5 BA home set on a serene wooded lot w/ private trails and Pond! Covered front porch w/swing. Amazing attention to detail in this masterpiece. Hickory hand scraped flooring, crown moldings, french doors leading to amazing patios & pristine landscaping! Chef style gourmet kitchen w/granite counters, top-of-the line appliances, wall ovens, huge walk-in pantry! First floor offers Library/Den with Built in bookcase and Guest suite w/ private bath. Crown moldings, garden rm, mud rm, incredible stone FP in Great Room w/french door & loads of windows! Huge master suite w/sitting rm, GFP & beautiful master bath. 2nd floor laundry. Lower lvl has rec room, wet bar, exercise area, game area, stairs to garage. 5th Bedroom suite.

Last Agent to Sell the Property

Lien Team Real Estate Group

First Weber Inc - Brookfield License #47394-90 Listed on: 09/02/2020

First Weber Inc - Brookfield

Last Buyer's Agent

Andrew Uhl

RE/MAX Liberty License #52305-90

RE/MAX Liberty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $22,971

Year Built

  • Built in 2006

Lot Details

  • 3.5 Acre Lot
  • Waterfront
  • Wooded Lot

Parking

  • 4.5 Car Attached Garage
  • Heated Garage
  • Tandem Garage
  • Garage Door Opener

Home Design

  • Brick Exterior Construction
  • Wood Siding
  • Stone Siding
  • Aluminum Trim
  • Stucco

Interior Spaces

  • 6,007 Sq Ft Home
  • 2-Story Property

Kitchen

  • Range
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Main Floor Bedroom
  • Primary Bedroom Upstairs
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • Bathtub Includes Tile Surround
  • Primary Bathroom includes a Walk-In Shower

Laundry

  • Dryer
  • Washer

Basement

  • Basement Fills Entire Space Under The House
  • Block Basement Construction

Outdoor Features

  • Pond
  • Patio

Schools

  • Cedar Hills Elementary School
  • Oak Creek West Middle School
  • Oak Creek High School

Utilities

  • Multiple cooling system units
  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • Radiant Heating System
  • Well Required

Listing and Financial Details

  • Exclusions: Living room drapes, Sellers personal property.

Home Details

Home Type

Single Family

Est. Annual Taxes

$22,971

Year Built

Built in 2006

Lot Details

0

Parking

4

Listing Details

  • Prop. Type: Single-Family
  • Inclusions: Refrigerator, Cooktop, Microwave, Counter Steamer, Washer, Dryer, Basement Refrigerator, Water Softener is owned, Iron Filter, R/O filtration system, Playset, Front porch swing.
  • New Construction: No
  • Year Built: 2006
  • Cleared Acreage: Over 2 acres to 5 acres
  • Architecture: Contemporary, Other
  • Full Street Address: 4218 W Puetz Rd
  • Type 5 Heat Fuel: Natural Gas
  • Kitchen Level: Main
  • Lot Acreage: 3.5
  • Municipality Type: City
  • Other Rm1 Level: Main
  • Other Rm1 Name: Mud Room
  • Other Rm2 Name: Loft
  • Property Water Features: Waterfrontage on Lot, Pond
  • Lot Description Waterfront: Yes
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dishwasher, Dryer, Microwave, Other, Range/Oven, Range, Refrigerator, Washer
  • Has Basement: 8'+ Ceiling, Block, Full
  • Interior Amenities: Water Softener, Expandable Attic, Pantry, Walk-in closet(s), Wood or Sim.Wood Floors
  • Bathroom Description: Tub Only, Ceramic Tile, Master Bedroom Bath: Tub/No Shower, Master Bedroom Bath: Walk-In Shower, Master Bedroom Bath
  • Room Bedroom2 Level: Upper
  • Bedroom 3 Level: Upper
  • Bedroom 4 Level: Main
  • Room Bedroom5 Level: Lower
  • Den Office Level: Main
  • Dining Room Dining Room Level: Main
  • Living Room Level: Main
  • Master Bedroom Master Bedroom Level: Upper
  • Master Bedroom Master Bedroom Width: 15
  • Second Floor Total Sq Ft: 6007.00

Exterior Features

  • Exclusions: Living room drapes, Sellers personal property.
  • Exterior Features: Patio
  • Exterior Building Type: 2 Story
  • Exterior: Aluminum/Steel, Aluminum, Aluminum Trim, Stone, Brick/Stone, Stucco/Slate, (C) Stucco, Wood

Garage/Parking

  • Parking Features:Workshop in Garage: Opener Included, Heated, Tandem, Attached, 4 Car
  • Garage Spaces: 4.5

Utilities

  • Water Waste: Municipal Sewer, Well

Schools

  • School District: Oak Creek-Franklin
  • Elementary School: Cedar Hills
  • Middle School: Oak Creek West
  • High School: Oak Creek
  • Elementary School: Cedar Hills
  • High School: Oak Creek
  • Junior High Dist: Oak Creek-Franklin

Lot Info

  • Zoning: RES
  • Acreage Range: 1 to 4.99
  • Lot Description: Wooded

Tax Info

  • Tax Year: 2019
  • Total Taxes: 22971.2

MLS Schools

  • Middle School: Oak Creek West

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 2, 2020
Closed on
Feb 13, 2021
Sold by
Hernandez Lyndon V and Hernandez Margaret J
Bought by
Khalek Mohamad
Seller's Agent
Lien Team Real Estate Group
First Weber Inc - Brookfield
Buyer's Agent
Andrew Uhl
RE/MAX Liberty
List Price
$1,000,000
Sold Price
$1,000,000
Current Estimated Value
$1,192,980

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$192,980
Avg. Annual Appreciation
3.89%
Original Mortgage
$800,000
Outstanding Balance
$714,893
Interest Rate
2.65%
Mortgage Type
New Conventional
Estimated Equity
$478,087

Purchase Details

Closed on
Sep 20, 2004
Sold by
Hernandez Lyndon V and Hernandez Margaret J
Bought by
Hernandez Lyndon V and Hernandez Margaret J

Purchase Details

Closed on
Jul 12, 2002
Sold by
Yuenger Shirley M
Bought by
Hernandez Lyndon V and Hernandez Margaret J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$127,920
Interest Rate
6.8%
Mortgage Type
Balloon
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
Khalek Mohamad $1,000,000 None Available
Hernandez Lyndon V -- --
Hernandez Lyndon V $159,900 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Khalek Mohamad $800,000
Previous Owner Hernandez Lyndon V $127,920
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/19/2021 02/19/21 Sold $1,000,000 0.0% $166 / Sq Ft
01/05/2021 01/05/21 Pending -- -- --
09/02/2020 09/02/20 For Sale $1,000,000 -- $166 / Sq Ft
Source: Metro MLS

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 $10,459 -- -- --
2023 $17,340 $1,078,000 $117,900 $960,100
2022 $17,242 $1,104,100 $117,900 $986,200
2021 $20,718 $1,254,900 $110,000 $1,144,900
2020 $24,759 $0 $0 $0
2019 $25,192 $1,130,100 $110,000 $1,020,100
2018 $20,699 $0 $0 $0
2017 $23,114 $1,025,300 $110,000 $915,300
2015 -- $908,600 $102,000 $806,600
2013 -- $908,600 $102,000 $806,600
Source: Public Records

Agents Affiliated with this Home

  • Lien Team Real Estate Group

    Seller's Agent in 2021

    Lien Team Real Estate Group

    First Weber Inc - Brookfield

    (414) 807-4800

    10 in this area

    376 Total Sales

    Lien Team Real Estate Group
    Section Image
  • Andrew Uhl

    Buyer's Agent in 2021

    Andrew Uhl

    RE/MAX

    (262) 336-9000

    30 in this area

    312 Total Sales

    Andrew Uhl
    Section Image
See All Agents

Map

Source: Metro MLS

MLS Number: 1707914

Metro MLS

APN: 833-9986-003

Wisconsin Milwaukee County Franklin 53132

4218 W Puetz Rd, Franklin, WI

This home is located at 4218 W Puetz Rd, Franklin, WI 53132 since 02 September 2020 and is currently estimated at $1,192,980, approximately $198 per square foot. This property was built in 2006. 4218 W Puetz Rd is a home located in Milwaukee County with nearby schools including Cedar Hills Elementary School, Oak Creek West Middle School, and Oak Creek High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Metro MLS IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

IDX listing data provided by Multiple Listing Service, Inc. Information is supplied by seller and other third parties and has not been verified.

Copyright 2025 – Multiple Listing Service, Inc. – All Rights Reserved.

Nearby Homes