Skip main navigation
Active
  • Price cut: $10K (7/18)
    $615,000

    2728 174th Ave NE, Ham Lake, MN 55304

    5beds
    3,706sqft
    : 
    Single Family Residence
    Built in 2003
    1.12 Acres Lot
    $614,300 Zestimate®
    $166/sqft
    $-- HOA

    What's special

    Breakfast barCozy gas fireplaceWide front porchCustom wood blindsLuxurious primary suiteCustom built-insUpdated stainless steel appliances
    Welcome to Woodland Bluffs in Ham Lake—where comfort, character, and entertainment come together! If your dream includes sipping a morning coffee on a wide front porch or unwinding with a mocktail or cocktail while soaking in the evening calm, this beautiful home delivers—and so much more. Step up to the expansive front porch and into a thoughtfully designed home, starting with an executive-style office just off the entry, featuring stunning floor-to-ceiling custom built-ins. The smartly laid-out kitchen offers updated stainless steel appliances, abundant cabinetry, and a breakfast bar with plenty of seating—perfect for casual meals or hosting. The informal dining area flows effortlessly into a spacious 28x14 living room anchored by a cozy gas fireplace and adorned with custom wood blinds throughout. Upstairs, you'll find four generously sized bedrooms, including a luxurious primary suite with a large walk-in closet, ensuite bathroom, and convenient second-floor laundry. The finished lower level is a sports fan’s dream come true. Custom countertops engraved with Minnesota Wild and Vikings logos set the tone, accompanied by a massive bar with a refrigerator and kegerator. Whether it's pool, air hockey, darts, or game-day on the big screen, this ultimate “sports cave” is built for year-round fun. The theater-style family room with built-in speakers makes movie nights a hit. Step outside and continue the entertaining with a maintenance-free deck, stamped concrete patio, and built-in firepit. There's ample space for yard games and outdoor gatherings. Located just 10–15 minutes from shopping, restaurants, the National Sports Center in Blaine, and with easy access to major highways—this home checks all the boxes. Come see for yourself what makes this custom-built gem a must-see!
    61 days
    on Zillow
    |
    801
    |
    45
    |

    Zillow last checked: 7 hours ago

    Listing updated: July 25, 2025 at 01:44pm

    Listed by:

    Lisa Malley 612-490-7024,

    eXp Realty

    Source: NorthstarMLS as distributed by MLS GRID,MLS#: 6724956MLS Logo
    Travel times

    Tour with a buyer's agent

    We'll find a local expert to take you on a private tour of 2728 174th Ave NE.

    Next available tour time:Today at 11am

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    Rooms
    • Room types: Dining Room, Living Room, Kitchen, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bar/Wet Bar Room, Family Room, Bedroom 5, Game Room
    Bedroom 1
    • 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
    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
    Video & virtual tour

    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, Wooded
    Details
    • Foundation area: 1248
    • Parcel number: 033223330013
    • Zoning description: Residential-Single Family

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Materials
    • Brick/Stone, Vinyl Siding, Block
    • Roof: Age Over 8 Years,Composition
    Condition
    • Age of Property: 22
    • 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: $166/sqft
    • Tax assessed value: $538,100
    • Annual tax amount: $4,838
    • Date on market: 6/6/2025
    • Loading
    • Loading