Redfin is joining Rocket

Discover how we're simplifying your journey home.

$625,000

2728 174th Ave NE Ham Lake, MN 55304

5 beds
3 full, 1 partial
3,706 sqft
$169 / sqft
House

Property details

About 2728 174th Ave NE

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!

Highlights

Home typeSingle Family Residence
HeatingForced Air
StatusActive
CoolingCentral Air
Size3,706 sqft
BasementYes
Year built2003
ParkingAttached Garage, Asphalt
MLS #6724956
Attached garage3 spaces
FireplaceGas, Living Room

Summary

  • Partial Bathrooms: 1
  • Full Bathrooms: 3
  • Appliances: Dishwasher, Dryer, Microwave, Range, Refrigerator, Stainless Steel Appliances, Washer, Water Softener
  • Basement: Yes
  • Fireplace: Gas, Living Room
  • Total Bedroom Count: 5
  • Garage Space: 3 spaces
  • Attached Garage: Yes
  • Parking: Attached Garage, Asphalt
  • Heating: Forced Air
  • Cooling: Central Air
  • List Price: $625,000
  • Price/SqFt: $168
  • HOA Amount: $0
  • Annual Tax Amount: $4,584
  • Tax Year: 2024
  • Lot: Irregular Lot, Few Trees
  • Directions: Hwy 65 to Crosstown Blvd, East 1 mile to Xylite (cty rd 68) north (L) to 174th East (R) to home on right
  • Year Built: 2003
  • Living Area: 3,706 SqFt
  • MLS Number: 6724956
  • MLS Name: NORTHSTAR
  • Office Name: eXp Realty

IDX Broker Reciprocity Copyright © 2025 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved.

By searching, you agree to the EULA Terms Agreement.

The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Regional Multiple Listing Service of Minnesota, Inc. Real estate listings held by brokerage firms other than this broker are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Some or all of the property listings above may have been submitted to the Regional Multiple Listing Service (RMLS) by the listing broker for distribution to cooperating brokers through Broker reciprocity. Attribution of the listing broker may be found on the detail page for all properties. The broker providing these data believes them to be correct, but advises interested parties to confirm them before relying on them in a purchase decision.

Any use of search facilities of data on this site, other than by a consumer looking to purchase real estate, is prohibited. No part of this search utility may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise. Home sale information is not an appraisal, competitive or comparative market analysis, CMA or home valuation.

DMCA Notice
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 7/5/2025, 3:37:27 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.

Price information

Property sales

DateEventPrice
Aug 02, 2005
Home Sold
$380,000

Tax history

YearAssessmentProperty Tax
2024$538,100$4,584

History based on county public records data.

Nearby schools

7

McKinley Elementary School

Public District KG-5

1.9 mi

1740 Constance Blvd NE

6

Cedar Creek Elementary School

Public District KG-5

5.2 mi

21108 Polk St NE

4

East Bethel Elementary School

Public District KG-5

5.3 mi

21210 Polk St NE

School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.

All data from GreatSchools

Neighborhood

The neighbors living near this home have an average income of $93,651. Most Ham Lake, MN residents have annual incomes between $35k-100k. Residents typically live in married, no kids family. Most residents in this area have post secondary degree education.

How much money do the neighbors make?

15%
<35k
40%
35k-100k
40%
100k-200k
5%
200k+

What level of education do the neighbors have?

High School Diploma
Post Secondary Degree
Masters Degree

What types of families live nearby?

24%
Single, No Kids
6%
Single, with Kids
36%
Married, No Kids
34%
Married, with Kids

Are the neighbors home owners or renters?

Home Owners
Renters

How old are people in this area?

16%
<11 yrs old
10%
12-17 yrs old
15%
18-34 yrs old
51%
35-64 yrs old
8%
65+ yrs old

What do the neighbors do for fun?

  • Skiing/snowboardingSkiing/snowboarding
  • PGA/LPGAPGA/LPGA
  • College FootballCollege Football

Where do the neighbors shop?

  • BJs Wholesale ClubBJs Wholesale Club
  • Stein MartStein Mart
  • Best BuyBest Buy

Where do the neighbors go to eat?

  • PaneraPanera
  • Cracker BarrelCracker Barrel
  • Texas RoadhouseTexas Roadhouse

What do the neighbors drive?

  • InfinitiInfiniti
  • LexusLexus
  • RamRam

What do the neighbors listen to?

  • Adult HitsAdult Hits
  • OldiesOldies
  • Contemporary ChristianContemporary Christian
All data provided by Home Junction and Claritas

Similar homes for sale

Frequently asked questions

About 2728 174th Ave NE

The listing price of 2728 174th Ave NE property is $625,000.

The property 2728 174th Ave NE is a house located in Ham Lake, Minnesota, 55304.

Active Listing: 2728 174th Ave NE is For Sale (Active/New) which means the seller is accepting offers.

The nearby schools for 2728 174th Ave NE are: McKinley Elementary School (GreatSchools Rating 7/10), Cedar Creek Elementary School (GreatSchools Rating 6/10), East Bethel Elementary School (GreatSchools Rating 4/10), Star of the North Academy Charter S (GreatSchools Rating 4/10), Davinci Academy (GreatSchools Rating 7/10), Oak View Middle School (GreatSchools Rating 7/10), Andover High School (GreatSchools Rating 7/10), Blaine High School (GreatSchools Rating 6/10), Pines School - Rjc (GreatSchools Rating 1/10).

According to the records, the last property tax for 2024 is $4,584 (source: MLS/based on county public records data).

The last sale was on August 2, 2005 for $380,000 (source: MLS/tax record).

The property at 2728 174th Ave NE has 5 bedrooms and 3 full and 1 half bathrooms.

The property 2728 174th Ave NE is 3,706 SqFt (source: MLS/tax record).

The year of construction for 2728 174th Ave NE is 2003.

This home is located at 2728 174th Ave NE in Ham Lake, MN and zip code 55304. This 3,706 square foot home was built in 2003. Features: 5 bedrooms, 4 bathrooms. It has been listed on Rocket Homes since June 6, 2025 and is currently priced at $625,000.

Ham Lake, MN housing market in June 2025 saw over 10 listings sold above listed price, more than 4 sold at listed price and over 3 sold below. Between May and June 2025, Ham Lake, MN real estate market has seen increase in the number of listings by 23.5%. In June 2025 median list price was $550,000 and the average listing age was 48 days.

From Rocket Homes Real Estate and based on county public records data.

More resources