Skip main navigation
Off market
  • $808,600

    15938 Madison St NE, Ham Lake, MN 55304

    6beds
    3,170sqft
    SingleFamily
    Built in 2001
    3.09 Acres Lot
    $808,600 Zestimate®
    $255/sqft
    $3,520 Estimated rent

    Home value

    $808,600

    $768,000 - $857,000

    $3,520/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,520/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $3,520/mo

    Rent Zestimate®

    Refinance and save

    $4,987/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $4,987/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Immaculate 2 story home w/underground pool & ~2,000 sqft pool/guest house in aone-of-a-kind setting w/stunning views! Landscaped 3-acre oasis w/beautifulflowers, stamped concrete walkways, stream to pond, fire-pits & wildlifeviews! 3-season porch & large deck! Open/spacious layout! Updated kitchenboasts Oak cabinets and stainless steel appliances. Massive finished, walkoutbasement! This 6 bed/4 bath dream house is your opportunity to experienceprivacy and space while only 30 minutes from Mpls/St.Paul! You do not want tomiss this one!

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 6
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    Heating
    • Forced air
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Dryer, Freezer, Garbage disposal
    Features
    • Flooring: Tile, Hardwood
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 3,170 sqft

    Property

    Parking
    • Total spaces: 4
    • Parking features: Garage - Attached
    Features
    • Exterior features: Stone, Vinyl, Brick, Metal
    • Has spa: Yes
    • Has view: Yes
    • View description: Water
    • Has water view: Yes
    • Water view: Water
    Lot
    • Size: 3.09 Acres
    • Topography: Level, Rolling, Walkout
    Details
    • Parcel number: 183223420007
    • Zoning: Residential-Single

    Construction

    Type & style
    • Home type: SingleFamily
    Materials
    • Frame
    • Foundation: Concrete Block
    • Roof: Asphalt
    Condition
    • Year built: 2001

    Utilities & green energy

    • Sewer: Private

    Community & neighborhood

    Location
    • Region: Ham Lake

    Other

    Other facts
    • BathDesc: Full Master, Main Floor 1/2 Bath, 3/4 Basement, Whirlpool, Upper Level Full Bath, Basement
    • Fuel: Natural Gas
    • Fence: Privacy, Chain Link
    • SpecialSearch: 3 BR on One Level, Main Floor Laundry
    • FrontageFeet: Paved Streets, City, Curbs, Cul De Sac
    • PresentUse: Yearly
    • RoomFloor1: Main
    • Sewer: Private
    • Topography: Level, Rolling, Walkout
    • Water: Well
    • Zoning: Residential-Single
    • SoilType: Loam, Sand
    • SecondUnit: Existing In-Law w/Kitchen, Existing In-Law w/Bath
    • Style: (SF) Modified Two Story
    • OutBuildings: Guest House

    Price history

    DateEventPrice
    12/16/2019Sold$597,000-8.1%$188/sqft
    Source: NorthstarMLS as distributed by MLS GRID #5320302 Report a problem
    11/18/2019Pending sale$649,900$205/sqft
    Source: Keller Williams Integrity Realty Lakes #5320302 Report a problem
    10/11/2019Listed for sale$649,900+4%$205/sqft
    Source: Keller Williams Integrity Realty Lakes #5320302 Report a problem
    3/30/2017Sold$625,000-3.8%$197/sqft
    Source: NorthstarMLS as distributed by MLS GRID #4775161 Report a problem
    3/19/2017Pending sale$649,900$205/sqft
    Source: RE/MAX Advantage Plus #4775161 Report a problem
    8/10/2016Price change$649,900-7%$205/sqft
    Source: Keller Williams - Coon Rapids #4669855 Report a problem
    7/9/2016Price change$699,000-6.8%$221/sqft
    Source: Keller Williams - Coon Rapids #4669855 Report a problem
    6/9/2016Price change$749,900-11.8%$237/sqft
    Source: Keller Williams - Coon Rapids #4669855 Report a problem
    4/1/2016Price change$850,000-5.6%$268/sqft
    Source: Keller Williams - Coon Rapids #4669855 Report a problem
    3/4/2016Listed for sale$900,000$284/sqft
    Source: Keller Williams Classic Realty #4669855 Report a problem
    1/12/2016Listing removed$900,000$284/sqft
    Source: Keller Williams - Coon Rapids #4669855 Report a problem
    1/6/2016Listed for sale$900,000+111%$284/sqft
    Source: Keller Williams Classic Realty #4669855 Report a problem
    10/31/2002Sold$426,500+433.8%$135/sqft
    Source: Public Record Report a problem
    4/9/2001Sold$79,900$25/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$6,318 +17.4%$677,500 -0.3%
    2024$5,381 +1%$679,800 +10.4%
    2023$5,330 +9.6%$615,700 0%
    2022$4,861 +1.2%$615,800 +20.2%
    2021$4,804 -18.1%$512,500 -9.1%
    2019$5,869 +5.9%$563,800 +8.4%
    2018$5,541 -2.3%$520,300 +1.8%
    2017$5,672 +6%$511,300 +6.8%
    2016$5,350 -3.5%$478,800
    2015$5,545 +3.7%$478,800 +14.7%
    2014$5,346 -7.3%$417,600
    2013$5,770 +0.5%--
    2012$5,743 +4.8%--
    2011$5,482 -2.4%--
    2010$5,618 +5%--
    2008$5,348 +15.2%--
    2007$4,643 +2%--
    2006$4,552 +12.7%--
    2005$4,038 +6.6%--
    2004$3,787 +47.1%--
    2003$2,574 +8129%--
    2002$31 --

    Find assessor info on the county website

    Neighborhood: 55304

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • District: Anoka-Hennepin

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $808,600
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $808,600