$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Keller Williams Classic Realty is the brokerage office representing the seller for this listing.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
The data relating to real estate for sale on this 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 are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Sandy Smith | Kurilla Real Estate, Ltd. is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Sandy Smith | Kurilla Real Estate, Ltd., a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
The data relating to real estate for sale on this 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 are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Sandy Smith | Kurilla Real Estate, Ltd. is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Sandy Smith | Kurilla Real Estate, Ltd., a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":1385387,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6746323","MLSAGENTID":"NST506011705","MLSCOAGENTID":"NST506018473","MLSOFFICEID":"NST1865","ADDRESS":"851 174th Avenue NE","ACRES":1.05,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Drain Tiled,Full,Unfinished","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Ham Lake","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":579900.0,"LASTPRICEDATE":"2025-07-21T19:01:04.99","LATITUDE":45.287267,"LENDEROWNED":"No","LISTDATE":"2025-07-21T05:00:00","LISTPRICE":579900.0,"LIVINGAREA":1628.0,"LONGITUDE":-93.24897,"MODIFICATIONTIMESTAMP":"2025-07-22T02:27:04.531","OFFICE_OFFICENAME":"Keller Williams Classic Realty","PHOTOCOUNT":17,"POSTALCODE":"55304","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"To-Be-Built Concord Rambler by TH Construction of Anoka\n\nWelcome to your future home in beautiful Ham Lake.\n\nNestled just minutes from local parks, trails, and outdoor recreation, this to-be-built 3-bedroom, 2-bath Concord rambler by TH Construction of Anoka offers modern comfort, timeless finishes, and a functional layout, all within the Anoka-Hennepin School District.\nStep inside to discover an open layout filled with natural light, where the heart of the home—the kitchen—shines with custom cabinetry, granite countertops, and ample prep space.\n\nThe spacious primary suite offers a walk-in tile shower and generous closet space. Two additional bedrooms, a full bath, and abundant storage add to the home’s ease of living.\n\nThe unfinished basement provides endless possibilities—whether you envision a cozy family room, home gym, or extra bedrooms, the potential is yours to shape.\n\nThis is your chance to build a brand-new home tailored to your lifestyle in a welcoming community.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Architectural Shingle","SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"763-506-1000","SEWER":"Mound Septic,Tank with Drainage Field","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-07-21T19:01:04.99","LASTSTATUS":"Active","STREETDIRSUFFIX":"NE","STREETNAME":"174th","STREETNUMBER":"851","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"Well","WATERFRONTPRESENT":false,"YEARBUILT":2025,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-07-22T02:27:04.531","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"ACFrOgCpKEDAuAkk8HH3mM3ksEJsIB6zi2Ay__rTHii24Z6B2IrYBlOMGlynQcHo34u-kR1V8plcJuIvXls7hlyAS9jorB8NrvwO2xpjpxkOlVrXeOJDZcsT8xic-Qw_Wwsi5q_XZ5cuDqWEH0xX.pdf.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","SOURCE":"MG_NST"}
{"ListingKey":"NST7765486","LotSizeArea":"1.05","NST_AgeOfProperty":"0","NST_AgentOwner":"Yes","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Ceiling Fan(s),Primary Bedroom Walk-In Closet,Washer/Dryer Hookup,Walk-In Closet","Appliances":"Air-To-Air Exchanger,Dishwasher,Exhaust Fan,Gas Water Heater,Microwave,Range,Refrigerator","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Daylight/Lookout Windows,Drain Tiled,Full,Unfinished","BasementYN":"True","NST_BathDesc":"3/4 Primary,Basement,Double Sink,Bathroom Ensuite,Private Primary,Main Floor 3/4 Bath,Main Floor Full Bath,Rough In,Walk-In Shower Stall","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BuilderLicense":"170552","BuilderName":"T H CONSTRUCTION OF ANOKA INC","City":"Ham Lake","PropertyType":"Residential","NST_ConstructionMaterialsDesc":"Frame","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DiningRoomDescription":"Kitchen/Dining Room","Directions":"Head West on Crosstown Blvd. from Highway 65. South on Polk St. to 174th Ave Property is on the Right side","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"200+ Amp Service","ConstructionMaterials":"Brick/Stone,Vinyl Siding","Fencing":"None","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","NST_FoundationDimensions":"52x36","FoundationArea":"1628","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Asphalt","NST_GarageDimensions":"32x24","NST_GarageDoorHeight":"8","NST_GarageDoorWidth":"16","NST_GarageSquareFeet":"698","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-07-21T18:59:45Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-07-21","Latitude":"45.287267","NST_LenderOwned":"No","ListAgentKey":"NST102037","ListAgentMlsId":"NST506011705","CoListAgentKey":"NST277190","CoListAgentMlsId":"NST506018473","ListingContractDate":"2025-07-21T05:00:00Z","ListOfficeKey":"NST14003","ListOfficeName":"Keller Williams Classic Realty","ListOfficeMlsId":"NST1865","ListPrice":"579900","LivingArea":"1628","LockBoxType":"Combo","Longitude":"-93.24897","LotSizeDimensions":"200x215x200x235","LotSizeSquareFeet":"45868.68","LotSizeUnits":"Acres","ListingId":"NST6746323","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"063223440028","GarageSpaces":"3","PhotosCount":"17","PostalCity":"Andover","PostalCode":"55304","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"To-Be-Built Concord Rambler by TH Construction of Anoka\n\nWelcome to your future home in beautiful Ham Lake.\n\nNestled just minutes from local parks, trails, and outdoor recreation, this to-be-built 3-bedroom, 2-bath Concord rambler by TH Construction of Anoka offers modern comfort, timeless finishes, and a functional layout, all within the Anoka-Hennepin School District.\nStep inside to discover an open layout filled with natural light, where the heart of the home—the kitchen—shines with custom cabinetry, granite countertops, and ample prep space.\n\nThe spacious primary suite offers a walk-in tile shower and generous closet space. Two additional bedrooms, a full bath, and abundant storage add to the home’s ease of living.\n\nThe unfinished basement provides endless possibilities—whether you envision a cozy family room, home gym, or extra bedrooms, the potential is yours to shape.\n\nThis is your chance to build a brand-new home tailored to your lifestyle in a welcoming community.","PublicSurveyRange":"23","PublicSurveySection":"06","PublicSurveyTownship":"32","NST_RentalLicenseYN":"No","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Architectural Shingle","RoomType":"Living Room,Kitchen,Dining Room,Bedroom 1,Bedroom 2,Bedroom 3","NST_AboveGradeSqFtTotal":"1628.0000","NST_BelowGradeSqFtTotal":"1628.0000","NST_MainLevelFinishedArea":"1628.0000","BuildingAreaTotal":"3256","HighSchoolDistrict":"Anoka-Hennepin","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"763-506-1000","Sewer":"Mound Septic,Tank with Drainage Field","NST_SpecialSearch":"3 BR on One Level,Main Floor Primary,Main Floor Bedroom,Main Floor Laundry,Primary Bdr Suite","AboveGradeFinishedArea":"1628","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"NE","StreetName":"174th","StreetNumber":"851","StreetNumberNumeric":"851","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Crosstown Rolling Acres 3rd Add","NST_TaxWithAssessments":"1238.0000","TaxYear":"2025","TaxAnnualAmount":"1238","WaterSource":"Well","YearBuilt":"2025","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-07-22T02:27:04.531Z","PhotosChangeTimestamp":"2025-07-22T02:27:04.531Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7765486\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"ACFrOgCpKEDAuAkk8HH3mM3ksEJsIB6zi2Ay__rTHii24Z6B2IrYBlOMGlynQcHo34u-kR1V8plcJuIvXls7hlyAS9jorB8NrvwO2xpjpxkOlVrXeOJDZcsT8xic-Qw_Wwsi5q_XZ5cuDqWEH0xX.pdf.jpg\",\"ImageWidth\":1545,\"ImageHeight\":2000,\"ImageSizeDescription\":\"1545x2000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/8c5b2f27-d028-4b23-8e18-226fedfe2d4f.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.694Z\",\"MediaKey\":\"687ef6e93460190e96692896\"},{\"ResourceRecordKey\":\"NST7765486\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":2038,\"ImageHeight\":1359,\"ImageSizeDescription\":\"2038x1359\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/c256f327-14c0-4ca9-b0a8-f4e003488333.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.637Z\",\"MediaKey\":\"687ef6e93460190e96692897\"},{\"ResourceRecordKey\":\"NST7765486\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/91a25af1-ea73-4d52-a230-854d515cb639.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.659Z\",\"MediaKey\":\"687ef6e93460190e96692898\"},{\"ResourceRecordKey\":\"NST7765486\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/178e04dc-3981-4c4a-a731-8d6b720c9775.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.664Z\",\"MediaKey\":\"687ef6e93460190e96692899\"},{\"ResourceRecordKey\":\"NST7765486\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/8b47b0c4-1b95-4c2f-9184-2805392c1a14.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.678Z\",\"MediaKey\":\"687ef6e93460190e9669289a\"},{\"ResourceRecordKey\":\"NST7765486\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/c9e3b391-bf2c-4fa0-bdd3-19e12ba2d372.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.693Z\",\"MediaKey\":\"687ef6e93460190e9669289b\"},{\"ResourceRecordKey\":\"NST7765486\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/7f9e9514-cd7e-4c2c-9c82-13b560234ea6.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.667Z\",\"MediaKey\":\"687ef6e93460190e9669289c\"},{\"ResourceRecordKey\":\"NST7765486\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/c69789d3-d321-4ba4-ac38-d9c37db6a3ba.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.629Z\",\"MediaKey\":\"687ef6e93460190e9669289d\"},{\"ResourceRecordKey\":\"NST7765486\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/64c3ad9d-ce09-41d8-a62f-7551a072477b.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.679Z\",\"MediaKey\":\"687ef6e93460190e9669289e\"},{\"ResourceRecordKey\":\"NST7765486\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/b6129b11-0cf3-411e-ad61-b1e9d8bb87be.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.705Z\",\"MediaKey\":\"687ef6e93460190e9669289f\"},{\"ResourceRecordKey\":\"NST7765486\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/2aabf044-4f3f-404e-abc6-973ae66318f5.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.718Z\",\"MediaKey\":\"687ef6e93460190e966928a0\"},{\"ResourceRecordKey\":\"NST7765486\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/1d0294a4-c673-4a44-a3e2-fc8132591a2a.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.619Z\",\"MediaKey\":\"687ef6e93460190e966928a1\"},{\"ResourceRecordKey\":\"NST7765486\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/b197b085-c1b0-4ff9-b00b-7a99826b9c0a.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.722Z\",\"MediaKey\":\"687ef6e93460190e966928a2\"},{\"ResourceRecordKey\":\"NST7765486\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/d4bb41e0-f7e1-4fb3-b3dd-5da2f31fe252.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.712Z\",\"MediaKey\":\"687ef6e93460190e966928a3\"},{\"ResourceRecordKey\":\"NST7765486\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/c79a7ce6-98c6-4aef-8525-57cedfb095c6.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.66Z\",\"MediaKey\":\"687ef6e93460190e966928a4\"},{\"ResourceRecordKey\":\"NST7765486\",\"Order\":16,\"MediaObjectID\":\"16\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/9c582d2e-951b-4fe8-970e-fb44d3e0ffdd.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.673Z\",\"MediaKey\":\"687ef6e93460190e966928a5\"},{\"ResourceRecordKey\":\"NST7765486\",\"Order\":17,\"MediaObjectID\":\"17\",\"ImageWidth\":2038,\"ImageHeight\":1359,\"ImageSizeDescription\":\"2038x1359\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7765486/f97e1c82-ee57-47eb-ad75-489877f2ce62.jpeg\",\"MediaModificationTimestamp\":\"2025-07-22T02:26:49.645Z\",\"MediaKey\":\"687ef6e93460190e966928a6\"}]","Rooms":"[{\"RoomKey\":\"NST115437896\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16x15\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115437897\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x12\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115437898\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x8\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115437899\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x13\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115437900\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115437901\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"6\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"ACFrOgCpKEDAuAkk8HH3mM3ksEJsIB6zi2Ay__rTHii24Z6B2IrYBlOMGlynQcHo34u-kR1V8plcJuIvXls7hlyAS9jorB8NrvwO2xpjpxkOlVrXeOJDZcsT8xic-Qw_Wwsi5q_XZ5cuDqWEH0xX.pdf.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","CustomVTourURL":""}