$749,900
PENDING

1904 N Ham Lake Dr NE Andover, MN 55304

Estimated payment $4,494/month

Total Views 17,483
4 Beds
3 Baths
3,452 Sq Ft
$217 Price per Sq Ft

Highlights

  • 150 Feet of Waterfront
  • Lake View
  • 3 Fireplaces
  • McKinley Elementary School Rated A-
  • Recreation Room
  • No HOA

About This Home

Discover the perfect blend of luxury and tranquility in this stunning 4-bedroom, 3-bathroom home nestled on the shores of beautiful Ham Lake. Ham Lake is a fully recreational lake great for fishing and boating. Boasting 150 feet of pristine waterfront, this exceptional property offers panoramic lake views, thoughtfully designed living spaces, newly painted interior, and multiple outdoor areas for relaxation and entertaining. Step into the welcoming foyer and flow effortlessly into the formal dining room, where a dramatic floor-to-ceiling stone fireplace sets the tone for cozy gatherings. Enjoy walk-out access to the expansive main-level deck—ideal for hosting or simply enjoying the peaceful lakefront views. The chef’s kitchen is a dream, featuring stainless steel appliances, a large granite center island, ample storage, and an informal dining area with walk-out deck access. Also on the main level is a spacious bedroom, full bathroom, and a well-equipped laundry room with additional pantry space. The upper level serves as a private homeowner’s retreat. Relax in the cozy living room with a second floor-to-ceiling stone fireplace, plush carpet, and walk-out access to a private upper deck. The generous owner’s suite also features plush carpet, a 3/4 en-suite bathroom, walk-in closet, and its own private deck access overlooking the sparkling waters of Ham Lake. The lower level offers even more versatile space, including a large family room with a wood-burning stove, walk-out access to the patio, two additional bedrooms, a 3/4 bathroom, and a sunroom currently home to a hot tub. A spacious basement-level rec room with another floor-to-ceiling stone fireplace and abundant storage completes the interior. Outside, you'll find a beautifully designed two-level deck, a meticulously crafted tiered patio with a built-in fire pit, and plenty of space for entertaining that leads down to the spacious dock. A large 17x12 storage shed offers convenience and functionality for all boating equipment and water toys. This stunning Ham Lake retreat is not one you will want to miss!

Listing Agent

John Schuster

Coldwell Banker Realty Brokerage Phone: 612-900-3333 Listed on: 04/15/2025

Coldwell Banker Realty

Co-Listing Agent

Andy Baker

JPW Realty Brokerage Phone: 612-900-3333

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,280

Year Built

  • Built in 1964

Lot Details

  • 0.43 Acre Lot
  • Lot Dimensions are 150x139x190x196
  • 150 Feet of Waterfront
  • Lake Front

Parking

  • 2 Car Garage

Home Design

  • Split Level Home
  • Flex
  • Pitched Roof

Interior Spaces

  • 3 Fireplaces
  • Wood Burning Fireplace
  • Stone Fireplace
  • Brick Fireplace
  • Entrance Foyer
  • Family Room
  • Living Room
  • Dining Room
  • Recreation Room
  • Storage Room
  • Lake Views
  • Finished Basement

Kitchen

  • Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • The kitchen features windows

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Dryer
  • Washer

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Private Water Source
  • Well

Community Details

  • No Home Owners Association
  • North Shore Subdivision

Listing and Financial Details

  • Assessor Parcel Number 163223320016

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,280

Year Built

Built in 1964

Lot Details

0

Parking

2

Listing Details

  • Type: Residential
  • Property Subtype 1: Single Family Residence
  • Cooling System: Central Air
  • Garage Spaces: 2
  • Accessibility Features: None
  • Fireplaces: 3
  • Water Source: Private, Well
  • Year Built: 1964
  • Above Grade Finished Sq Ft: 1869
  • Water Body Name: Ham
  • Unit Levels: Four or More Level Split
  • New Construction: No
  • FractionalOwnershipYN: No
  • Rental License?: No
  • Attribution Contact: 612-900-3333
  • Attribution Contact: 612-900-3333
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Basement: Finished
  • Appliances: Dishwasher, Dryer, Humidifier, Gas Water Heater, Microwave, Range, Refrigerator, Stainless Steel Appliances, Washer, Water Softener Owned
  • Fireplace Features: Brick, Stone, Wood Burning, Wood Burning Stove
  • Living Area: 3452
  • Fireplace: Yes
  • Below Grade Finished Sq Ft: 1583
  • Basement YN: Yes
  • Dining Room Type: Kitchen, Dining Room, Informal Dining Room, Laundry, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Living Room, Family Room, Sun Room, Foyer, Recreation Room, Storage, Flex Room

Beds/Baths

  • Full Bathrooms: 1
  • Total Bedrooms: 4
  • Three Quarter Bathrooms: 2

Exterior Features

  • Roof: Age Over 8 Years, Asphalt, Pitched
  • View: Panoramic, South
  • Other Structures: Storage Shed
  • PatioPorchType: Covered,Deck,Patio
  • Lake Acres: 224
  • LakeChain: N
  • Waterfront Frontage: 150

Garage/Parking

  • Parking Features: Detached, Concrete
  • Garage Square Feet: 552

Utilities

  • Heating: Forced Air
  • Sewer: Holding Tank, Mound Septic, Private Sewer
  • Fuel: Natural Gas

Condo/Co-op/Association

  • Association: No
  • Amenities Unit: Ceiling Fan(s),Deck,Dock,Intercom System,Kitchen Center Island,Kitchen Window,Primary Bedroom Walk-In Closet,Patio,Panoramic View,Sun Room,Tile Floors,Vaulted Ceiling(s),Washer/Dryer Hookup,Walk-In Closet

Schools

  • Junior High Dist: Anoka-Hennepin
  • SchoolDistrictNumber: 11
  • SchoolDistrictPhone: 763-506-1000

Lot Info

  • Waterfront YN: Yes
  • PropertyAttachedYN: No
  • Lot Size: 150x139x190x196
  • Lot Size Sq Ft: 18730.8
  • Land Lease: No
  • Additional Parcels: No
  • Zoning Description: Residential-Single Family
  • AssessmentPending: No
  • Yearly/Seasonal: Yearly

Building Info

  • Construction Materials: Brick/Stone, Stucco, Vinyl Siding

Tax Info

  • Tax Year: 2025
  • Assessor Parcel Number: 163223320016
  • Tax Annual Amount: 5280
  • TaxWithAssessments: 5280.0000

Multi Family

  • WaterfrontFeatures: Dock, Lake Front, Lake View

Map

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

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 $5,280 $586,400 $215,600 $370,800
2024 $5,280 $584,700 $215,600 $369,100
2023 $13,391 $548,200 $215,600 $332,600
2022 $8,738 $540,000 $192,600 $347,400
2021 $8,757 $458,500 $175,600 $282,900
2020 $8,833 $445,400 $175,600 $269,800
2019 $8,348 $435,900 $175,600 $260,300
2018 $3,803 $376,700 $0 $0
2017 $3,404 $348,000 $0 $0
2016 $3,575 $315,200 $0 $0
2015 $3,496 $315,200 $135,100 $180,100
2014 -- $274,400 $112,700 $161,700
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/21/2025 08/21/25 Pending -- -- --
07/28/2025 07/28/25 Price Changed $749,900 -1.3% $217 / Sq Ft
06/03/2025 06/03/25 Price Changed $759,500 -2.0% $220 / Sq Ft
05/14/2025 05/14/25 Price Changed $774,900 -3.1% $224 / Sq Ft
04/15/2025 04/15/25 For Sale $799,900 -- $232 / Sq Ft
Source: NorthstarMLS

Purchase History

Date Type Sale Price Title Company
Warranty Deed $300,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Closed $252,050 New Conventional
Closed $295,000 New Conventional
Closed $70,000 Credit Line Revolving
Source: Public Records

Similar Homes in Andover, MN

  • 141 145th Ln NE, Andover, MN 55304

    $849,900

    • 6 Beds
    • 4.5 Baths
    • 4,952 Sq Ft
    • 141 145th Ln NE
    • Andover, MN

    Nestled on a scenic 1.53-acre cul-de-sac lot, this exceptional estate offers nearly 5,000 sq ft of beautifully updated living space designed for comfort, functionality, and effortless indoor-outdoor living. Step outside to your private backyard retreat with a brand-new 35x16' in-ground pool complete with slide, retractable cover, and hot tub hookup—ideal for summer enjoyment. A 4-car attached

    Jon Perkins RE/MAX Results

    Section Image
  • 16331 Crosstown Blvd NW, Andover, MN 55304

    $699,900

    • 5 Beds
    • 3.5 Baths
    • 3,888 Sq Ft
    • 16331 Crosstown Blvd NW
    • Andover, MN

    Executive rambler on nearly 2 acres in the desirable Andover School District! A charming front porch welcomes you in, while the secluded backyard offers a peaceful escape with a covered porch, large deck, and views of woods and nature. Enjoy abundant garage space with an attached 3-car garage featuring overhead storage, a detached 3-car garage, plus two additional sheds. Inside, you'll find

    Joel Friday Keller Williams Classic Realty

    Section Image
  • 14444 Flintwood St NW, Andover, MN 55304

    $574,900

    • 5 Beds
    • 3.5 Baths
    • 3,594 Sq Ft
    • 14444 Flintwood St NW
    • Andover, MN

    This stunning two-story home in Andover with custom cabinetry throughout offers a perfect blend of space and comfort. The main level features a den, spacious living room with a cozy gas fireplace, and a large kitchen with a gas cooktop, double ovens, and walk-in pantry. A convenient half bath and oversized laundry room complete this level, with direct access to the impressive heated 3-car garage

    Michelle A. Anderson RE/MAX Results

    Section Image
  • 4060 Bunker Lake Blvd NE, Andover, MN 55304

    $585,000

    • 4 Beds
    • 2 Baths
    • 2,462 Sq Ft
    • 4060 Bunker Lake Blvd NE
    • Andover, MN

    Nestled in a private and serene setting, this custom-built, single-level home offers the perfect blend of comfort and functionality. Featuring 4 spacious bedrooms and 2 full bathrooms, it sits on a generous 2.48-acre lot with stunning outdoor amenities.Enjoy the outdoors with a relaxing hot tub, a cozy fire pit area, and an expansive deck—ideal for entertaining or unwinding. A massive

    Tracy Shalander LPT Realty, LLC

    Section Image
  • 956 160th Ln NE, Andover, MN 55304

    $724,900

    • 3 Beds
    • 4 Baths
    • 4,192 Sq Ft
    • 956 160th Ln NE
    • Andover, MN

    Wow! What an opportunity! Home, shops and land all wrapped up in one! The rambler has a main floor with a primary bedroom with awesome views of nature. Large closet and bath attached. It is an open concept great room, with fireplace, and windows galore. 4 season porch that walk outs to the huge deck and an office with built ins round this floor off. Lower level has 2 more bedrooms, with walk in

    Regina Finkelstein RE/MAX Results

    Section Image
  • 2020 Crosstown Blvd NE, Andover, MN 55304

    $570,000

    • 4 Beds
    • 2 Baths
    • 3,164 Sq Ft
    • 2020 Crosstown Blvd NE
    • Andover, MN

    Welcome to a unique house in the country but close to the cities. the best of both worlds. Spacious 3164 sq ft house on 4.4 acres with a private pond deep enough to stock fish. A split level with 2 bedrooms up and 2 bedrooms down, 2 baths 2 fireplaces, 2 living rooms, Great room, office and indoor hot tub and sauna. Vaulted and 10 foot ceilings make each room seem even bigger. Additions added in

    Jonathan Minerick homecoin.com

    Section Image
  • 2349 175th Ln NE, Andover, MN 55304

    $699,500

    • 5 Beds
    • 3 Baths
    • 3,233 Sq Ft
    • 2349 175th Ln NE
    • Andover, MN

    Your quiet and blissful sanctuary home awaits, offering you the perfect blend of comfort, functionality, and modern design with acreage ownership while located on a cul de sac, on a dead end road and on a wetland preserve that will never be built on any further! Inside, you’ll find a host of high-end enhancements including a dual-zone HVAC system, central vacuum, and a state-of-the-art Kinetico

    Kenneth Hatfield RE/MAX Professionals

    Section Image
  • 2728 174th Ave NE, Andover, MN 55304

    $600,000

    • 5 Beds
    • 3.5 Baths
    • 3,706 Sq Ft
    • 2728 174th Ave NE
    • Andover, MN

    Welcome to Woodland Bluffs in Ham Lake—where comfort, character, and entertainment meet in perfect harmony!If your vision of home includes sipping morning coffee on a wide, welcoming front porch or unwinding with a mocktail or cocktail as the sun sets, this property delivers—and so much more.Step inside to find a thoughtfully designed floor plan starting with a true

    Lisa Malley eXp Realty

    Section Image
  • 3309 171st Ave NE, Andover, MN 55304

    $699,900

    • 3 Beds
    • 2 Baths
    • 1,582 Sq Ft
    • 3309 171st Ave NE
    • Andover, MN

    Completed new build in February of this year. Beautiful rambler Plan built by Premier Custom Homes on a 2.4 acre lot. High quality finishes and since has installed sprinkler system, sod, Mulch around perimeter and a whole house water treatment system. Features 3 bedrooms and laundry on the main level. Insulated and heated 26x32 garage with 8' tall doors, third stall door is 9' wide for easier

    Lawrence Whitney RE/MAX Results

    Section Image

Source: NorthstarMLS

MLS Number: 6699254

NorthstarMLS

APN: 16-32-23-32-0016