$1,499,500

2746 154th Ln NE Ham Lake, MN 55304

Estimated payment $8,843/month

Total Views 3,254
4 Beds
4.5 Baths
4,873 Sq Ft
$308 Price per Sq Ft

Highlights

  • Deck
  • Family Room with Fireplace
  • Game Room
  • McKinley Elementary School Rated A-
  • No HOA
  • Sport Court

About This Home

Experience luxury living in this Haven Homes custom-built Ham Lake property, set on nearly two acres with peaceful wetland views. With four bedrooms, five bathrooms, and an eight car garage—including a full-size RV stall—this property offers the space and features to fit any lifestyle.Inside, you’re immediately greeted with high-end finishes throughout, including a custom chef’s kitchen with a walk-in butler’s pantry featuring an additional oven, dishwasher, and ample storage, a stylish formal dining area, and a comfortable living room with panoramic views of the property. A charming porch with fireplace and adjacent beverage bar adds to the entertaining attributes of this stunning home. Upstairs, the primary suite wows, designed for comfort with a soaking tub and large walk-in closet (don't miss the champagne fridge!). Two more bedrooms, both with walk-in closets and private en suite bathrooms, as well as a spacious laundry room take this upper floor to the next level. Looking for room to grow? The home’s design allows for a future upper-level bedroom addition above the second and third garage stalls. Downstairs, an entertainer’s dream – a generous family room with three TV's and gaming area sit adjacent to the wet bar with custom tile, the ideal locale to watch your favorite events. Floor-to-ceiling windows bathe the lower level in natural light. Need to shoot some hoops? No problem – practice your moves in the half-court exercise room/ sport court for year-round fun.Outside you'll find a deck off the porch, patio off the walkout level and a firepit for those inviting fall evenings along with ample space to play and be active. Enjoy the privacy of a quiet, natural setting without sacrificing access to top-tier convenience. Located within the highly regarded Blaine High School district, this home delivers both luxury and practicality in a prime location. Truly a must-see.

Listing Agent

Arthur Hays

Lakes Sotheby's International Realty Listed on: 04/23/2025

Lakes Sotheby's International Realty

Co-Listing Agent

Bergen Baker

Lakes Sotheby's International Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10,619

Year Built

  • Built in 2023

Lot Details

  • 1.79 Acre Lot
  • Lot Dimensions are 308x369x165x406
  • Cul-De-Sac
  • Irregular Lot

Parking

  • 8 Car Attached Garage
  • Heated Garage
  • Insulated Garage
  • Garage Door Opener

Interior Spaces

  • 2-Story Property
  • Wet Bar
  • Electric Fireplace
  • Entrance Foyer
  • Family Room with Fireplace
  • 2 Fireplaces
  • Living Room with Fireplace
  • Dining Room
  • Game Room
  • Utility Room Floor Drain
  • Home Gym

Kitchen

  • Built-In Double Oven
  • Range
  • Microwave
  • Freezer
  • Dishwasher
  • Wine Cooler
  • Stainless Steel Appliances
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet

Laundry

  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Basement Window Egress

Outdoor Features

  • Sport Court
  • Deck
  • Patio
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Boiler Heating System
  • Water Filtration System
  • Well
  • Septic System

Community Details

  • No Home Owners Association
  • Harmony Estates 2Nd Add Subdivision

Listing and Financial Details

  • Assessor Parcel Number 223223230022

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,619

Year Built

Built in 2023

Lot Details

0

Parking

8

Listing Details

  • Type: Residential
  • Property Subtype 1: Single Family Residence
  • Cooling System: Central Air
  • Garage Spaces: 8
  • Accessibility Features: None
  • Fireplaces: 2
  • Water Source: Well
  • Year Built: 2023
  • Above Grade Finished Sq Ft: 3105
  • Unit Levels: Two
  • New Construction: No
  • FractionalOwnershipYN: No
  • Rental License?: No
  • Special Features: 4098
  • Property Sub Type: Detached

Interior Features

  • Basement: Egress Window(s), Finished, Full, Walkout
  • Appliances: Chandelier, Dishwasher, Disposal, Double Oven, Dryer, Exhaust Fan, Freezer, Gas Water Heater, Water Filtration System, Microwave, Range, Refrigerator, Stainless Steel Appliances, Wall Oven, Washer, Water Softener Owned, Wine Cooler
  • Fireplace Features: Electric, Family Room, Gas, Living Room, Other
  • Living Area: 4873
  • Fireplace: Yes
  • Below Grade Finished Sq Ft: 1768
  • Basement YN: Yes
  • Dining Room Type: Porch, Foyer, Dining Room, Living Room, Kitchen, Informal Dining Room, Mud Room, Bar/Wet Bar Room, Deck, Bedroom 1, Bedroom 2, Bedroom 3, Primary Bathroom, Walk In Closet, Bathroom, Bedroom 4, Family Room, Game Room, Exercise Room, Athletic Court, Patio

Beds/Baths

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

Exterior Features

  • Roof: Age 8 Years or Less, Asphalt
  • PatioPorchType: Composite Decking,Deck,Front Porch,Patio,Rear Porch,Screened

Garage/Parking

  • Parking Features: Attached Garage, Asphalt, Floor Drain, Garage Door Opener, Heated Garage, Insulated Garage
  • Garage Square Feet: 2308

Utilities

  • Heating: Boiler, Forced Air, Fireplace(s)
  • Sewer: Septic System Compliant - Yes
  • Fuel: Natural Gas

Condo/Co-op/Association

  • Association: No
  • Amenities Unit: Ceiling Fan(s),Deck,Exercise Room,Hardwood Floors,Kitchen Center Island,Primary Bedroom Walk-In Closet,Patio,Porch,Panoramic View,In-Ground Sprinkler,Tile Floors,Vaulted Ceiling(s),Wet Bar,Walk-In Closet

Schools

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

Lot Info

  • PropertyAttachedYN: No
  • Lot Size: 308x369x165x406
  • Lot Size Sq Ft: 77972.4
  • Land Lease: No
  • Lot Features: Irregular Lot, Some Trees
  • Additional Parcels: No
  • Zoning Description: Residential-Single Family
  • AssessmentPending: Yes
  • Yearly/Seasonal: Yearly

Building Info

  • Construction Materials: Brick/Stone, Engineered Wood

Tax Info

  • Tax Year: 2025
  • Assessor Parcel Number: 223223230022
  • Tax Annual Amount: 10619
  • TaxWithAssessments: 10687.8200

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

Property History

Date Event Price Change Sq Ft Price
06/04/2025 06/04/25 Price Changed $1,499,500 -3.3% $308 / Sq Ft
05/28/2025 05/28/25 For Sale $1,550,000 0.0% $318 / Sq Ft
05/21/2025 05/21/25 Off Market $1,550,000 -- --
05/08/2025 05/08/25 For Sale $1,550,000 0.0% $318 / Sq Ft
05/05/2025 05/05/25 Off Market $1,550,000 -- --
04/25/2025 04/25/25 For Sale $1,550,000 -- $318 / Sq Ft
Source: NorthstarMLS

Purchase History

Date Type Sale Price Title Company
Deed $1,358,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $875,000 New Conventional
Source: Public Records

Similar Homes in the area

  • 16419 Kiska St NE, Andover, MN 55304

    $1,799,999

    • 6 Beds
    • 6 Baths
    • 6,371 Sq Ft
    • 16419 Kiska St NE
    • Andover, MN

    Discover gorgeous home built by Parent Builders Inc, where no detail is overlooked and every finish is of the highest quality! Nestled on 4.45 acres of serene land overlooking a private pond. Step through the grand eight-foot double French doors into an expansive living space featuring ten-foot ceilings and stunning solid wood floors. The chef’s kitchen is a true showstopper, featuring high end

    April Manchik Lakes Sotheby's International

    Section Image
  • 2304 169th Ave NE, Ham Lake, MN 55304

    $1,155,000

    • 4 Beds
    • 4 Baths
    • 3,757 Sq Ft
    • 2304 169th Ave NE
    • Ham Lake, MN

    Welcome to 2304 169th Ave NE in Ham Lake—a rare opportunity to bring your business, toys, and lifestyle together on 12.3 private acres. Perfectly suited for those needing space to work, play, and unwind, this property offers exceptional flexibility, privacy, and potential for future growth.At the heart of the property is a massive 60’x36’ climate-controlled red iron outbuilding. Designed to meet

    John Schuster Coldwell Banker Realty

    Section Image
  • 14030 Kenyon St NE, Ham Lake, MN 55304

    $1,400,000

    • 5 Beds
    • 5 Baths
    • 5,220 Sq Ft
    • 14030 Kenyon St NE
    • Ham Lake, MN

    Luxury and comfort converge in this extraordinary one-story estate by Parent Custom Homes, offering breathtaking views, a heated driveway, and an impressive 8-car garage. The main level boasts a stunning great room and exquisite walnut wood flooring, while the gourmet kitchen is equipped with top-of-the-line appliances. The primary suite features heated floors, a lavish soaker tub, double shower,

    Kenneth Hatfield RE/MAX Professionals

    Section Image
  • 2374 Swedish Dr NE, Ham Lake, MN 55304

    $1,498,800

    • 4 Beds
    • 4 Baths
    • 4,573 Sq Ft
    • 2374 Swedish Dr NE
    • Ham Lake, MN

    Experience the rare fusion of elegance and innovation in this custom-crafted TJB masterpiece, set on 4 wooded acres in the heart of Ham Lake. With nearly 4,600 sq ft of precision design, this 4 bed / 4 bath home showcases a full golf simulator, indoor sport court, and oversized 4-car garage.Inside, enjoy hand-finished white oak floors, enameled custom cabinetry, and oversized Andersen windows

    Lori Howard Keller Williams Premier Realty

    Section Image
  • 14217 Packard St NE, Andover, MN 55304

    $1,650,000

    • 5 Beds
    • 4.5 Baths
    • 5,826 Sq Ft
    • 14217 Packard St NE
    • Andover, MN

    Impeccably maintained by its original owners, this custom home offers refined design, everyday comfort, and uninterrupted views of the protected Carlos Avery Wildlife Area. Set in a secluded neighborhood near everyday conveniences, the home is filled with natural light and nearly every bedroom features an en suite bath. The main level is ideal for entertaining with a chef’s kitchen, large island,

    Lindsay Bacigalupo Engel & Volkers Minneapolis Downtown

    Section Image

Source: NorthstarMLS

MLS Number: 6698807

NorthstarMLS