Skip main navigation
Closed
    • $600,000

    2728 174th Ave NE, Ham Lake, MN 55304

    5beds
    3,706sqft
    Single Family Residence
    Built in 2003
    1.12 Acres Lot
    $610,600 Zestimate®
    $162/sqft
    $3,114 Estimated rent

    Home value

    $610,600

    $562,000 - $666,000

    $3,114/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,114/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,114/mo

    Rent Zestimate®

    Refinance and save

    $3,762/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

    $3,762/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

    Breakfast barCozy gas fireplaceWide welcoming front porchCustom wood blindsLuxurious primary suiteEnsuite bathCustom built-ins
    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 executive-style office just off the entry. Floor-to-ceiling custom built-ins provide both beauty and function, creating the perfect work-from-home environment. The smartly planned kitchen boasts updated stainless steel appliances, abundant cabinetry, and a breakfast bar for casual meals or easy entertaining. The adjoining dining space flows seamlessly into the spacious 28x14 living room with a cozy gas fireplace and custom wood blinds, making it ideal for everyday living. Upstairs, four generously sized bedrooms include a luxurious primary suite with a walk-in closet, ensuite bath, and the convenience of second-floor laundry. The finished lower level is where the fun begins—a fully customized sports room that’s a fan’s dream. From engraved Minnesota Wild and Vikings countertops to a massive bar with refrigerator and kegerator, this space is designed for game-day magic. Enjoy pool, air hockey, darts, or cheer on your team from the theater-style family room with built-in speakers. Step outside to your own backyard retreat. A maintenance-free deck leads to a stamped concrete patio with a built-in firepit—perfect for summer cookouts, crisp fall evenings, and everything in between. The yard offers plenty of room for games and gatherings, making it an entertainer’s paradise. Located just minutes from shopping, dining, the National Sports Center, and major highways, this custom-built gem checks all the boxes. Come experience it for yourself! Sellers still accepting showings. This is contingent upon buyers accepting an offer on their house.

    Zillow last checked:

    Listing updated:

    Listed by:

    Lisa Malley 612-490-7024,

    eXp Realty

    Bought with:

    Nick Mansur

    Coldwell Banker Realty

    Source: NorthstarMLS as distributed by MLS GRID,MLS#: 6772255MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    Bedroom
    • Level: Upper
    • Area: 240 Square Feet
    • Dimensions: 16x15
    Bedroom 2
    • Level: Upper
    • Area: 187 Square Feet
    • Dimensions: 11x17
    Bedroom 3
    • Level: Upper
    • Area: 121 Square Feet
    • Dimensions: 11x11
    Bedroom 4
    • Level: Upper
    • Area: 120 Square Feet
    • Dimensions: 12x10
    Bedroom 5
    • Level: Lower
    • Area: 182 Square Feet
    • Dimensions: 13x14
    Other
    • Level: Lower
    • Area: 182 Square Feet
    • Dimensions: 14x13
    Dining room
    • Level: Main
    • Area: 169 Square Feet
    • Dimensions: 13x13
    Family room
    • Level: Lower
    • Area: 156 Square Feet
    • Dimensions: 13x12
    Game room
    • Level: Lower
    • Area: 156 Square Feet
    • Dimensions: 12x13
    Kitchen
    • Level: Main
    • Area: 420 Square Feet
    • Dimensions: 28x15
    Living room
    • Level: Main
    • Area: 392 Square Feet
    • Dimensions: 28x14
    Heating
    • Forced Air
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Dryer, Microwave, Range, Refrigerator, Stainless Steel Appliance(s), Washer, Water Softener Owned
    • Laundry: Electric Dryer Hookup, Laundry Room, Sink, Upper Level, Washer Hookup
    Features
    • Basement: Block,Daylight,Drain Tiled,Finished,Full
    • Number of fireplaces: 1
    • Fireplace features: Gas, Living Room
    Interior area
    • Total structure area: 3,706
    • Total interior livable area: 3,706 sqft
    • Finished area above ground: 2,471
    • Finished area below ground: 1,235

    Property

    Parking
    • Total spaces: 3
    • Parking features: Attached, Asphalt
    • Attached garage spaces: 3
    Accessibility
    • Accessibility features: None
    Features
    • Levels: Two
    • Stories: 2
    • Patio & porch: Composite Decking, Deck, Front Porch, Patio, Porch
    • Pool features: None
    • Fencing: None
    Lot
    • Size: 1.12 Acres
    • Dimensions: 118 x 323 x 197 x 306
    • Features: Irregular Lot, Tree Coverage - Light
    Details
    • Foundation area: 1248
    • Parcel number: 033223330013
    • Zoning description: Residential-Single Family

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Materials
    • Block
    • Roof: Age Over 8 Years,Composition
    Condition
    • New construction: No
    • Year built: 2003

    Utilities & green energy

    • Electric: Circuit Breakers
    • Gas: Natural Gas
    • Sewer: Private Sewer, Septic System Compliant - Yes
    • Water: City Water/Connected, Well

    Community & HOA

    Community
    • Subdivision: Woodland Bluffs 3rd Add
    HOA
    • Has HOA: No
    Location
    • Region: Ham Lake

    Financial & listing details

    • Price per square foot: $162/sqft
    • Tax assessed value: $559,200
    • Annual tax amount: $4,838
    • Date on market: 8/14/2025
    • Cumulative days on market: 120 days

    Price history

    DateEventPrice
    11/7/2025Sold$600,000$162/sqft
    Source: NorthstarMLS as distributed by MLS GRID #6772255 Report a problem
    10/4/2025Pending sale$600,000$162/sqft
    Source: NorthstarMLS as distributed by MLS GRID #6772255 Report a problem
    8/14/2025Listed for sale$600,000-2.4%$162/sqft
    Source: NorthstarMLS as distributed by MLS GRID #6772255 Report a problem
    8/14/2025Listing removed$615,000$166/sqft
    Source: NorthstarMLS as distributed by MLS GRID #6724956 Report a problem
    7/18/2025Price change$615,000-1.6%$166/sqft
    Source: NorthstarMLS as distributed by MLS GRID #6724956 Report a problem
    6/6/2025Listed for sale$625,000+138.3%$169/sqft
    Source: NorthstarMLS as distributed by MLS GRID #6724956 Report a problem
    8/13/2012Sold$262,250+24.9%$71/sqft
    Source: Lake Superior Area Realtors as distributed by MLS GRID #1921077 Report a problem
    6/14/2012Listed for sale$210,000-4.5%$57/sqft
    Source: Weichert, Realtors-Premier Report a problem
    3/13/2012Listing removed$220,000$59/sqft
    Source: Broker, e-Pro, RSA #3991921 Report a problem
    8/3/2011Price change$220,000-15.4%$59/sqft
    Source: Broker, e-Pro, RSA #3991921 Report a problem
    7/9/2011Price change$259,999-5.5%$70/sqft
    Source: Broker, e-Pro, RSA #3991921 Report a problem
    6/23/2011Price change$274,999+1.9%$74/sqft
    Source: Dona Properties #3991921 Report a problem
    6/3/2011Price change$269,999-1.8%$73/sqft
    Source: Dona Properties #3991921 Report a problem
    5/6/2011Price change$274,999-1.8%$74/sqft
    Source: Dona Properties #3991921 Report a problem
    4/22/2011Price change$279,999-6.7%$76/sqft
    Source: Dona Properties #3991921 Report a problem
    3/17/2011Price change$299,999-2.9%$81/sqft
    Source: RealEstateHomepages.com #3991921 Report a problem
    3/3/2011Price change$309,000-6.1%$83/sqft
    Source: RealEstateHomepages.com #3991921 Report a problem
    2/13/2011Price change$329,000-2.9%$89/sqft
    Source: RealEstateHomepages.com #3991921 Report a problem
    2/5/2011Price change$339,000-1.7%$91/sqft
    Source: RealEstateHomepages.com #3991921 Report a problem
    1/26/2011Listed for sale$345,000-1.4%$93/sqft
    Source: RealEstateHomepages.com #3991921 Report a problem
    12/24/2010Listing removed$349,999$94/sqft
    Source: RealEstateHomepages.com #3991921 Report a problem
    11/21/2010Listed for sale$349,999-7.9%$94/sqft
    Source: RealEstateHomepages.com #3991921 Report a problem
    8/2/2005Sold$380,000+13.1%$103/sqft
    Source: Public Record Report a problem
    8/26/2003Sold$335,944+63.3%$91/sqft
    Source: Public Record Report a problem
    2/28/2003Sold$205,700$56/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$4,838 +5.5%$559,200 +3.9%
    2024$4,584 +2.4%$538,100 +0.5%
    2023$4,477 +9.6%$535,200 +1.2%
    2022$4,084 +3.9%$528,700 +22.2%
    2021$3,930 +2.1%$432,500 +14%
    2019$3,850 -2.9%$379,400 +0.6%
    2018$3,967 +1503.9%$377,100 +7.4%
    2017$247 -92.5%$351,200 +18.1%
    2016$3,282 -2.2%$297,400
    2015$3,355 +5%$297,400 +19.6%
    2014$3,194 -1.7%$248,700
    2013$3,249 -4.1%--
    2012$3,388 -2%--
    2011$3,458 -3.3%--
    2010$3,576 -10.1%--
    2008$3,980 +16.1%--
    2007$3,428 +11.6%--
    2006$3,073 +5.9%--
    2005$2,901 +1472.4%--
    2004$184 +267.3%--
    2003$50 --
    Find assessor info on the county website

    Neighborhood: 55304

    Nearby homes

    Nearby schools

    GreatSchools rating
    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
    $610,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
    $610,600

    Nearby cities

    Nearby zip codes

    Other Ham Lake Topics

      Search
      Updates
      Favorites
      Plan
      Inbox