3 days on Rocket
#6759995, Listing office: Bullseye Properties & Realty
$644,900 List price
883 174th Ave NE Ham Lake, MN 55304
4 beds
1 full, 1 partial
2,416 sqft
$267 / sqft
House
Property details
About 883 174th Ave NE
Introducing The North Brook — a beautifully designed to-be-built 2-story home nestled on a spacious lot in Ham Lake and within the highly rated Andover Schools. This spacious layout offers 4 bedrooms and 3 baths, with all bedrooms located upstairs for maximum privacy. The primary suite features a walk-in tile shower, double sinks, and a generous walk-in closet. The main level boasts an open-concept design filled with natural light. The kitchen is completed with granite countertops, a large center island, and seamless flow into the dining and living areas. Enjoy cozy evenings by the stone-surround fireplace or step outside and explore the nearby parks and trails. Additional highlights include an upstairs laundry room, an unfinished basement offering room to grow, and an oversized 4-car garage—plenty of space for hobbies, storage, or a workshop. Now is your chance to select finishes and personalize the space to suit your style and make it your own. Don’t miss the opportunity to create your dream home in an established, scenic community. Schedule a tour of the lot or a consultation to explore build options.
Highlights
Home typeSingle Family Residence
HeatingForced Air, Fireplace(s)
StatusActive
CoolingCentral Air
Size2,416 sqft
BasementYes
Year builtNew Const., 2025
ParkingAttached Garage, Asphalt
MLS #6746262
Attached garage4 spaces
FireplaceGas
Summary
- Partial Bathrooms: 1
- Full Bathrooms: 1
- Appliances: Dishwasher, Gas Water Heater, Microwave, Range, Refrigerator
- Basement: Yes
- Fireplace: Gas
- Total Bedroom Count: 4
- Garage Space: 4 spaces
- Attached Garage: Yes
- Parking: Attached Garage, Asphalt
- Heating: Forced Air, Fireplace(s)
- Cooling: Central Air
- List Price: $644,900
- Price/SqFt: $266
- HOA Amount: $0
- Annual Tax Amount: $827
- Tax Year: 2024
- Directions: Hwy 65 to Crosstown Blvd. West to Polk St. NE S. to 174th Ave NE property on right
- Year Built: 2025
- Living Area: 2,416 SqFt
- MLS Number: 6746262
- MLS Name: NORTHSTAR
- Office Name: Keller Williams Classic Realty
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/26/2025, 3:37:28 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2024 | $118,900 | $827 |
History based on county public records data.
Nearby schools
7
McKinley Elementary School
Public District KG-5
1.9 mi
•1740 Constance Blvd NE
9
Rum River Elementary School
Public District KG-5
3.9 mi
•16950 Verdin St NW
9
Andover Elementary School
Public District KG-5
4.3 mi
•14950 Hanson Blvd NW
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $65,300. Most Ham Lake, MN residents have annual incomes between $35k-100k. Residents typically live in single, no kids family. Typical level of education for residents in this area is post secondary degree.
How much money do the neighbors make?
16%
<35k
56%
35k-100k
22%
100k-200k
6%
200k+
What level of education do the neighbors have?
No High School
High School Diploma
Post Secondary Degree
Masters Degree
What types of families live nearby?
33%
Single, No Kids
12%
Single, with Kids
33%
Married, No Kids
22%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
15%
<11 yrs old
9%
12-17 yrs old
18%
18-34 yrs old
48%
35-64 yrs old
10%
65+ yrs old
What do the neighbors do for fun?
NASCAR
Soccer
PGA/LPGA
Where do the neighbors shop?
Dick's Sporting Goods
Old Navy
Stein Mart
Where do the neighbors go to eat?
Arbys
Jimmy Johns
Bob Evans
What do the neighbors drive?
GMC
Lincoln
Chevrolet
What do the neighbors listen to?
Adult Hits
New Country
News/Talk/Information
All data provided by Home Junction and Claritas
Similar homes for sale
Tour
#6746356, Listing office: Keller Williams Classic Realty
5 days on Rocket
#6746323, Listing office: Keller Williams Classic Realty
#6729914, Listing office: Keller Williams Classic Rlty NW
#6697720, Listing office: Keller Williams Classic Realty
#6755219, Listing office: eXp Realty
3 hours on Rocket
#6761013, Listing office: Minnesota Home Venture, Inc.
Tour
#6722949, Listing office: Keller Williams Classic Realty
#6739576, Listing office: Real Estate Masters, Ltd.
Frequently asked questions
About 883 174th Ave NE
The listing price of 883 174th Ave NE property is $644,900.
The property 883 174th Ave NE is a house located in Ham Lake, Minnesota, 55304.
Active Listing: 883 174th Ave NE is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 883 174th Ave NE are: McKinley Elementary School (GreatSchools Rating 7/10), Rum River Elementary School (GreatSchools Rating 9/10), Andover Elementary School (GreatSchools Rating 9/10), Star of the North Academy Charter S (GreatSchools Rating 4/10), Oak View Middle School (GreatSchools Rating 7/10), Davinci Academy (GreatSchools Rating 7/10), Andover High School (GreatSchools Rating 7/10), Blaine High School (GreatSchools Rating 6/10), Anoka High School (GreatSchools Rating 6/10).
According to the records, the last property tax for 2024 is $827 (source: MLS/based on county public records data).
The property at 883 174th Ave NE has 4 bedrooms and 1 full and 1 half bathrooms.
The property 883 174th Ave NE is 2,416 SqFt (source: MLS/tax record).
The year of construction for 883 174th Ave NE is 2025.
This home is located at 883 174th Ave NE in Ham Lake, MN and zip code 55304. This 2,416 square foot home was built in 2025. Features: 4 bedrooms, 3 bathrooms. It has been listed on Rocket Homes since July 24, 2025 and is currently priced at $644,900.
In June 2025 more than 10 listings in Ham Lake, MN were sold above the asking price. During the same period more than 4 listings were sold at asking price, while more than 3 were sold below. The inventory of homes for sale in Ham Lake, MN between May and June 2025 increased by 23.5%. In June 2025, listings were on the market for 48 days. During the same period, the median list price in this real estate market was $550,000.
From Rocket Homes Real Estate and based on county public records data.