{"Id":562188,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7075709","MLSAGENTID":"NST502050814","MLSOFFICEID":"NST4198","ADDRESS":"17846 Hamburg Avenue","ACRES":0.115,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Walkout","BATHSTOTAL":3.0,"BEDROOMS":3.0,"CITY":"Lakeville","CONTINGENCY":"None","COUNTY":"Dakota","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":554990.0,"LASTPRICEDATE":"2026-05-24T17:37:05.933","LATITUDE":44.691691,"LENDEROWNED":"No","LISTDATE":"2026-05-24T05:00:00","LISTPRICE":554990.0,"LIVINGAREA":1853.0,"LONGITUDE":-93.224344,"LOTDESCRIPTION":"Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-05-24T17:37:05.932","OFFICE_OFFICENAME":"Brandl/Anderson Realty","PHOTOCOUNT":3,"POSTALCODE":"55044","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"The Kenwood Floorplan - available to be built in Summers Creek!\nNew construction opportunity to customize the features and finishes throughout your next home. Enjoy maintenance free living in The Summers Creek Community. landscaping, irrigation, and (front) gutters included for all homes. \n\nThe Summers Creek Model home is located at 17912 Greenwich Way, and open daily from 12:00pm-6:00pm. Please call or visit our website for information on the Camden Model and available floorplans!\n\nPrices, square footage and availability are subject to change without notice.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt","SCHOOLDISTRICTNUMBER":"194-Lakeville","SCHOOLDISTRICTPHONE":"9522322000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-05-24T17:37:05.933","LASTSTATUS":"Active","STREETNAME":"Hamburg","STREETNUMBER":"17846","STREETSUFFIX":"Avenue","STYLE":"(TH) Detached","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2026,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-05-24T17:36:08.309","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Elevation A\"},{\"Order\":2,\"Remarks\":\"Floorplan & Dimensions\"},{\"Order\":3,\"Remarks\":\"Exterior Elevation Options\"}]","PHOTOORDER":"1,2,3","SOURCE":"MG_NST"}
{"ListingKey":"NST7903091","NST_AboveGradeSqFtTotal":"1853","AboveGradeFinishedArea":"1853","AccessibilityFeatures":"Other","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Cable,Primary Bedroom Walk-In Closet,Main Floor Primary Bedroom,In-Ground Sprinkler,Washer/Dryer Hookup","Appliances":"Air-To-Air Exchanger,Chandelier,Dishwasher,Disposal,Exhaust Fan,Humidifier,Gas Water Heater,Microwave,Range,Refrigerator,Stainless Steel Appliances","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"True","AssociationAmenities":"None","AssociationFee":"225","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Lawn Care,Sanitation,Snow Removal","AssociationName":"Summergate Companies","AssociationPhone":"9528983461","AvailabilityDate":"2026-12-31T06:00:00Z","Basement":"Walkout","BasementYN":"True","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"2","BathroomsTotalInteger":"3","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"1853","BelowGradeFinishedArea":"0","NST_BuilderLicense":"604388","BuilderName":"BRANDL ANDERSON HOMES INC","CumulativeDaysOnMarket":"0","City":"Lakeville","NST_CommunityName":"Summers Creek","NST_CompletionDate":"2026-12-31","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Dakota","Directions":"From Cedar Ave, turn West onto 179th Street W., South onto Hamburg Ave, and take the next right turn (North) onto Hamburg Avenue. \nHomesite is located on right-hand (South) side of Hamburg Avenue.","DocumentsCount":"0","DaysOnMarket":"0","Electric":"200+ Amp Service","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"1853","NST_FractionalOwnershipYN":"No","NST_Fuel":"Electric,Natural Gas","NST_GarageSquareFeet":"440","NST_GarageDimensions":"22x20","NST_GarageDoorHeight":"7","NST_GarageDoorWidth":"16","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Lakeville","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.691691","LaundryFeatures":"Electric Dryer Hookup,Main Level,Washer Hookup","NST_LenderOwned":"No","Levels":"One","ListPrice":"554990","ListingContractDate":"2026-05-24T05:00:00Z","ListingId":"NST7075709","LivingArea":"1853","LockBoxType":"Combo","Longitude":"-93.224344","LotFeatures":"Tree Coverage - Light","LotSizeArea":"0.115","LotSizeDimensions":"50x90x50x90","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1853","NST_ManufacturedHome":"N","NST_ModelHours":"Daily 12-6pm","NST_ModelLocation":"17912 Greenwich Way","NST_OccupancyDate":"2026-12-31","OriginalEntryTimestamp":"2026-05-24T12:35:08Z","ParcelNumber":"227337107020","ParkingFeatures":"Attached Garage","PhotosCount":"3","PhotosChangeTimestamp":"2026-05-24T17:36:08.309Z","PostalCity":"Lakeville","PostalCode":"55044","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"(TH) Detached","PropertyType":"Residential","PublicRemarks":"The Kenwood Floorplan - available to be built in Summers Creek!\nNew construction opportunity to customize the features and finishes throughout your next home. Enjoy maintenance free living in The Summers Creek Community. landscaping, irrigation, and (front) gutters included for all homes. \n\nThe Summers Creek Model home is located at 17912 Greenwich Way, and open daily from 12:00pm-6:00pm. Please call or visit our website for information on the Camden Model and available floorplans!\n\nPrices, square footage and availability are subject to change without notice.","Roof":"Age 8 Years or Less,Asphalt","NST_SchoolDistrictNumber":"194","NST_SchoolDistrictPhone":"9522322000","Sewer":"City Sewer/Connected","NST_SingleFamilySubType":"Ranch-Style Home","NST_SingleFamilyTownhouseType":"Not Applicable","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Hamburg","StreetNumber":"17846","StreetNumberNumeric":"17846","StreetSuffix":"Avenue","SubdivisionName":"Summers Creek 2nd Add","TaxAnnualAmount":"1364","NST_TaxWithAssessments":"1364","TaxYear":"2026","BuildingAreaTotal":"3706","Township":"Lakeville","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"2026","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST228435","ListAgentMlsId":"NST502050814","ListOfficeMlsId":"NST4198","ListOfficeName":"Brandl/Anderson Realty","ListOfficeKey":"NST16018","ModificationTimestamp":"2026-05-24T17:37:05.932Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"Elevation A\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7903091/6ba81319-ed75-4ca7-801d-4441e8040951.jpeg\",\"ResourceRecordKey\":\"NST7903091\",\"ImageWidth\":506,\"ImageHeight\":306,\"ImageSizeDescription\":\"506x306\",\"MediaModificationTimestamp\":\"2026-05-24T17:36:03.829Z\",\"MediaKey\":\"NST122459942\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"Floorplan & Dimensions\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7903091/0ab8f95e-6691-4ac9-94d1-207f90cf8397.jpeg\",\"ResourceRecordKey\":\"NST7903091\",\"ImageWidth\":1123,\"ImageHeight\":809,\"ImageSizeDescription\":\"1123x809\",\"MediaModificationTimestamp\":\"2026-05-24T17:36:03.818Z\",\"MediaKey\":\"NST122459943\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"Exterior Elevation Options\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7903091/1f2b9c56-39c8-402b-80da-a8c4c4a86d7f.jpeg\",\"ResourceRecordKey\":\"NST7903091\",\"ImageWidth\":1106,\"ImageHeight\":743,\"ImageSizeDescription\":\"1106x743\",\"MediaModificationTimestamp\":\"2026-05-24T17:36:03.87Z\",\"MediaKey\":\"NST122459941\"}]","Media__Order":"1","Media__MediaObjectID":"NST1","Media__LongDescription":"Elevation A","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7903091/6ba81319-ed75-4ca7-801d-4441e8040951.jpeg","Media__ResourceRecordKey":"NST7903091","Media__ImageWidth":"506","Media__ImageHeight":"306","Media__ImageSizeDescription":"506x306","Media__MediaModificationTimestamp":"5/24/2026 5:36:03 PM","Media__MediaKey":"NST122459942","DocumentsChangeTimestamp":"2026-05-24T17:36:08.309Z","Rooms":"[{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116246276\",\"RoomType\":\"Bathroom\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116246273\",\"RoomType\":\"Bedroom\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116246279\",\"RoomType\":\"Great Room\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116246277\",\"RoomType\":\"Kitchen\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116246280\",\"RoomType\":\"Laundry\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116246274\",\"RoomType\":\"Primary Bathroom\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":9,\"RoomKey\":\"NST116246281\",\"RoomType\":\"Mud Room\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116246278\",\"RoomType\":\"Pantry (Walk-In)\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116246275\",\"RoomType\":\"Bedroom 2\"},{\"RoomLevel\":\"Basement\",\"NST_RoomSortOrder\":14,\"RoomKey\":\"NST116246286\",\"RoomType\":\"Storage\"},{\"RoomLevel\":\"Basement\",\"NST_RoomSortOrder\":13,\"RoomKey\":\"NST116246285\",\"RoomType\":\"Utility Room\"}]","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"4","Rooms__RoomKey":"NST116246276","Rooms__RoomType":"Bathroom","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Elevation A\"},{\"Order\":2,\"Remarks\":\"Floorplan & Dimensions\"},{\"Order\":3,\"Remarks\":\"Exterior Elevation Options\"}]","PhotoOrder":"1,2,3","CustomVTourURL":""}