$6,530 Closing Credit¹
#6635091, Listing Office: Real Broker, LLC
$6,649
closing credit¹
851 174th Ave NE Ham Lake, MN 55304
$559,900 List price
$6,649
Closing credit¹
3 beds
1 full
1,628 sqft
$344 / sqft
House
Property details
About 851 174th Ave NE
Welcome home to "The Concord" rambler built by TH Construction featuring 3 spacious bedrooms and 2 full bathrooms, designed with both style and functionality in mind. The large kitchen is a true highlight, complete with custom cabinets, sleek granite countertops, and plenty of counter space, making it perfect for preparing meals or entertaining guests. The open layout flows seamlessly into the living and dining areas, creating an inviting atmosphere throughout the home. The master suite is a peaceful retreat with a stunning walk-in tile shower! The two additional bedrooms are generously sized and versatile, ideal for family, guests, or a home office. The home also features beautiful finishes, natural light, and abundance of storage. The basement is unfinished but with potential for a 4th and 5th bedroom, a 3rd bathroom, and a large sized family room. With it's thoughtful layout and modern amenities, this rambler is the perfect blend of comfort, style, and convenience. Andover School District. Don't miss out on this incredible opportunity! Make it home today!
Highlights
Home typeSingle Family Residence
HeatingForced Air
StatusActive
CoolingCentral Air
Size1,628 sqft
BasementYes
Year builtNew Const., 2025
ParkingAttached Garage, Asphalt
MLS #6637153
Attached garage3 spaces
Summary
- MLS Number: 6637153
- MLS Name: NORTHSTAR
- Office Name: T.H. 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: 2/10/2025, 11:22:51 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹
$559,900
851 174th Ave NE
$6,649
closing credit¹
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
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.2 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. The majority of Ham Lake, MN residents have income between $35k-100k annually. 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
$7,243 Closing Credit¹
#6628836, Listing Office: T.H. Realty
$7,599 Closing Credit¹
#6637172, Listing Office: T.H. Realty
$7,599 Closing Credit¹
#6637763, Listing Office: Realty Group, LLC
$5,058 Closing Credit¹
#6641849, Listing Office: Golden Homes Realty LLC
Frequently asked questions
About 851 174th Ave NE
This home is located at 851 174th Ave NE in Ham Lake, MN and zip code 55304. This 1,628 square foot home was built in 2025. Features: 3 bedrooms, 2 bathrooms. It has been listed on Rocket Homes since December 10, 2024 and is currently priced at $559,900.
In January 2025, from all listings sold in Ham Lake, MN there were more than 2 sold above asking price, over 5 sold below and more than 3 were sold right at the asked price. Between December and January 2025, Ham Lake, MN real estate market has seen increase in the number of listings by 10.9%. In January 2025 median list price was $550,000 and the average listing age was 59 days.
From Rocket Homes Real Estate and based on county public records data.