MLS# 7057345 - 17858 Hamburg Avenue Lakeville, MN 55044
$STITLE$
$SCONTENT$
$STITLE$
$SCONTENT$$LABEL$
$SCONTENT$
Financing
Sale price ($) Down payment (%) Interest Rate (%) Term (years) |
||||||||||||
Property Location
Coldwell Banker Realty is the brokerage office representing the seller for this listing.
Copyright 2020, 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. RE/MAX First Choice is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of RE/MAX First Choice, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
{"Id":548147,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7057345","MLSAGENTID":"NST505002075","MLSCOAGENTID":"NST505004929","MLSOFFICEID":"NST3260","ADDRESS":"17858 Hamburg Avenue","ACRES":0.103,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":3.0,"BEDROOMS":3.0,"CITY":"Lakeville","CONTINGENCY":"None","COUNTY":"Dakota","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":600000.0,"LASTPRICEDATE":"2026-04-27T20:33:06.15","LATITUDE":44.691945,"LENDEROWNED":"No","LISTDATE":"2026-04-27T05:00:00","LISTPRICE":600000.0,"LIVINGAREA":2296.0,"LONGITUDE":-93.225427,"LOTDESCRIPTION":"Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-04-27T20:33:06.15","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":37,"POSTALCODE":"55044","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Spotless & spacious walkout rambler-style home built in 2022 with quality materials, granite counters, CA Closet Company throughout, custom cabinetry, stainless appliances, gas fireplace with stone surround, cement board siding and stone exterior. 2 bedrooms and 2 bathrooms on main floor with one bedroom and one bath on lower level. You and your guests can enjoy the friendly 6'x19' \"rocking chair\" front porch or the 14'x15' composite deck with stairs down to the grassy backyard. The sunlight-filled walkout lower level features a generous 665 sq ft family room, a finished 10'x11' bonus/craft room, the third bedroom and bathroom, 900 sq ft of unfinished space for a workshop or storage, and a 12' x 12' concrete patio outside. Modest monthly HOA fees of $225.00 covers lawn maintenance & irrigation, snow removal, and sanitation. Conveniently located to restaurants, grocery stores, shopping, and miles of paved trails near Dodd Blvd & Cedar Avenue.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"194-Lakeville","SCHOOLDISTRICTPHONE":"9522322000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-04-27T20:33:06.15","LASTSTATUS":"Active","STREETNAME":"Hamburg","STREETNUMBER":"17858","STREETSUFFIX":"Avenue","STYLE":"(TH) Detached","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2021,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-04-27T20:33:06.15","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Beautiful curb appeal at 17858 Hamburg Ave\"},{\"Order\":2,\"Remarks\":\"Space for relaxing\"},{\"Order\":3,\"Remarks\":\"Bright foyer showing neutral paint throughout\"},{\"Order\":4,\"Remarks\":\"Entryway hall\"},{\"Order\":5,\"Remarks\":\"Back hall with garage and laundry access. Large closet as well.\"},{\"Order\":6,\"Remarks\":\"Laundry room also leads to primary bedroom\"},{\"Order\":7,\"Remarks\":\"First floor bedroom currently being used as an office\"},{\"Order\":8,\"Remarks\":\"Main level full bath\"},{\"Order\":9,\"Remarks\":\"Breakfast bar - room for stools\"},{\"Order\":10,\"Remarks\":\"Kitchen window above sink\"},{\"Order\":11,\"Remarks\":\"Huge granite island\"},{\"Order\":12,\"Remarks\":\"Stainless steel appliances\"},{\"Order\":13,\"Remarks\":\"Wall of windows keep it bright\"},{\"Order\":14,\"Remarks\":\"Open floor plan\"},{\"Order\":15,\"Remarks\":\"Gas fireplace makes it perfect for relaxing\"},{\"Order\":16,\"Remarks\":\"Dining room\"},{\"Order\":17,\"Remarks\":\"Easy access to kitchen from dining room\"},{\"Order\":18,\"Remarks\":\"Spacious living space\"},{\"Order\":19,\"Remarks\":\"Dining room with slider to deck\"},{\"Order\":20,\"Remarks\":\"Vaulted ceilings in primary bedroom\"},{\"Order\":21,\"Remarks\":\"Walk-thru closet and en-suite bathroom\"},{\"Order\":22,\"Remarks\":\"Large primary bathroom with dual sinks\"},{\"Order\":23,\"Remarks\":\"Lower level family room\"},{\"Order\":24,\"Remarks\":\"Plenty of room in lower level\"},{\"Order\":25,\"Remarks\":\"31-B31A4115.jpg\"},{\"Order\":26,\"Remarks\":\"Lower level walk-out to patio\"},{\"Order\":27,\"Remarks\":\"Lower level bedroom\"},{\"Order\":28,\"Remarks\":\"Lower level crafting/ flex space\"},{\"Order\":29,\"Remarks\":\"Lower level full bath\"},{\"Order\":30,\"Remarks\":\"Room for playing and entertaining in backyard\"},{\"Order\":31,\"Remarks\":\"Composite decking - maintenance free!\"},{\"Order\":32,\"Remarks\":\"Great porch and walk out patio\"},{\"Order\":33,\"Remarks\":\"HUGE unfinished lower level space\"},{\"Order\":34,\"Remarks\":\"Lower level floorplan\"},{\"Order\":35,\"Remarks\":\"Full house floorplan\"},{\"Order\":36,\"Remarks\":\"Main level floorplan\"},{\"Order\":37,\"Remarks\":\"Google Map\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37","SOURCE":"MG_NST"}
{"ListingKey":"NST7887066","NST_AboveGradeSqFtTotal":"1631","AboveGradeFinishedArea":"1631","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Kitchen Center Island,Kitchen Window,Primary Bedroom Walk-In Closet,Main Floor Primary Bedroom,Patio,Paneled Doors,Security System,In-Ground Sprinkler,Tile Floors,Vaulted Ceiling(s),Washer/Dryer Hookup,Walk-In Closet","Appliances":"Air-To-Air Exchanger,Dishwasher,Dryer,Microwave,Refrigerator,Stainless Steel Appliances,Washer,Water Softener Owned","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"True","AssociationFee":"225","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Lawn Care,Sanitation,Snow Removal","AssociationName":"Summergate North Association","AssociationPhone":"6129999999","AttributionContact":"6124147100","NST_AttributionName":"Patricia Schmidt-Iverson","Basement":"Finished","BasementYN":"True","NST_BathDesc":"Basement,Double Sink,Bathroom Ensuite,Full Primary,Main Floor Full Bath","BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"1631","BelowGradeFinishedArea":"665","CumulativeDaysOnMarket":"0","City":"Lakeville","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Dakota","NST_DiningRoomDescription":"Breakfast Bar,Living/Dining Room","Directions":"Take Cedar Avenue S to 179th St W and turn right. Turn right onto Granby Ln. then left onto Graphite Lane. Then right onto Hamburg Ave. End at 17858 Hamburg Avenue.","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-04-27T20:32:06.167Z","DaysOnMarket":"0","Fencing":"Partial,Vinyl","FireplaceFeatures":"Gas,Living Room","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"1631","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"544","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Lakeville","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.691945","LaundryFeatures":"Gas Dryer Hookup,Laundry Room,Main Level,Washer Hookup","NST_LenderOwned":"No","Levels":"One","ListPrice":"600000","ListingContractDate":"2026-04-27T05:00:00Z","ListingId":"NST7057345","LivingArea":"2296","LockBoxType":"Supra","Longitude":"-93.225427","LotFeatures":"Tree Coverage - Light","LotSizeArea":"0.103","LotSizeDimensions":"50' x 90' x 50' x 90'","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1631","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-04-27T15:31:13Z","ParcelNumber":"227337010060","ParkingFeatures":"Attached Garage,Garage Door Opener","NST_PatioPorchType":"Composite Decking,Deck,Patio","PhotosCount":"37","PhotosChangeTimestamp":"2026-04-27T20:33:06.15Z","PostalCity":"Lakeville","PostalCode":"55044","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"(TH) Detached","PropertyType":"Residential","PublicRemarks":"Spotless & spacious walkout rambler-style home built in 2022 with quality materials, granite counters, CA Closet Company throughout, custom cabinetry, stainless appliances, gas fireplace with stone surround, cement board siding and stone exterior. 2 bedrooms and 2 bathrooms on main floor with one bedroom and one bath on lower level. You and your guests can enjoy the friendly 6'x19' \"rocking chair\" front porch or the 14'x15' composite deck with stairs down to the grassy backyard. The sunlight-filled walkout lower level features a generous 665 sq ft family room, a finished 10'x11' bonus/craft room, the third bedroom and bathroom, 900 sq ft of unfinished space for a workshop or storage, and a 12' x 12' concrete patio outside. Modest monthly HOA fees of $225.00 covers lawn maintenance & irrigation, snow removal, and sanitation. Conveniently located to restaurants, grocery stores, shopping, and miles of paved trails near Dodd Blvd & Cedar Avenue.","Roof":"Age 8 Years or Less","NST_SchoolDistrictNumber":"194","NST_SchoolDistrictPhone":"9522322000","Sewer":"City Sewer/Connected","NST_SingleFamilyTownhouseType":"Not Applicable","NST_SpecialSearch":"Main Floor Primary,Main Floor Laundry","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Hamburg","StreetNumber":"17858","StreetNumberNumeric":"17858","StreetSuffix":"Avenue","SubdivisionName":"Summers Creek","TaxAnnualAmount":"5976","NST_TaxWithAssessments":"5722","TaxYear":"2025","BuildingAreaTotal":"3262","Township":"Lakeville","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"2021","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST48418","CoListAgentMlsId":"NST505004929","CoListOfficeName":"Coldwell Banker Realty","ListAgentKey":"NST47983","ListAgentMlsId":"NST505002075","ListOfficeMlsId":"NST3260","ListOfficeName":"Coldwell Banker Realty","ListOfficeKey":"NST16219","ModificationTimestamp":"2026-04-27T20:33:06.15Z","OriginatingSystemName":"northstar","Media":"[{\"LongDescription\":\"Large primary bathroom with dual sinks\",\"Order\":22,\"MediaObjectID\":\"NST22\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/fed91167-9772-4e66-9665-9612bb422c2c.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.542Z\",\"MediaKey\":\"NST121716863\"},{\"LongDescription\":\"Google Map\",\"Order\":37,\"MediaObjectID\":\"NST37\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/51477254-a561-468e-8c23-b281ed8d1dfe.jpeg\",\"ImageWidth\":582,\"ImageHeight\":251,\"ImageSizeDescription\":\"582x251\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.48Z\",\"MediaKey\":\"NST121798350\"},{\"LongDescription\":\"Back hall with garage and laundry access. Large closet as well.\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/389b5147-8624-4426-b171-3dfe2cd8e1a9.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.501Z\",\"MediaKey\":\"NST121716880\"},{\"LongDescription\":\"Main level floorplan\",\"Order\":36,\"MediaObjectID\":\"NST36\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/d88e959a-f9c8-4711-ab98-c27c6a2158d8.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.49Z\",\"MediaKey\":\"NST121752135\"},{\"LongDescription\":\"Plenty of room in lower level\",\"Order\":24,\"MediaObjectID\":\"NST24\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/9398427a-321b-4b1f-9bb4-b4fd8e9566f6.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.508Z\",\"MediaKey\":\"NST121716858\"},{\"LongDescription\":\"Dining room with slider to deck\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/1dc0470e-e7ea-4cc3-9210-a7c61ef88c6b.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.498Z\",\"MediaKey\":\"NST121716867\"},{\"LongDescription\":\"Walk-thru closet and en-suite bathroom\",\"Order\":21,\"MediaObjectID\":\"NST21\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/57291c89-b05d-41ed-81bf-f59bd0196602.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.509Z\",\"MediaKey\":\"NST121716865\"},{\"LongDescription\":\"Lower level walk-out to patio\",\"Order\":26,\"MediaObjectID\":\"NST26\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/62b450fa-5cb8-4c6c-8865-ec5e0639dec2.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.497Z\",\"MediaKey\":\"NST121716856\"},{\"LongDescription\":\"Kitchen window above sink\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/e709758b-950f-4caf-80d6-a725bd04b378.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.496Z\",\"MediaKey\":\"NST121716876\"},{\"LongDescription\":\"Lower level crafting/ flex space\",\"Order\":28,\"MediaObjectID\":\"NST28\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/dc8fea8d-81cd-4275-a3b4-833245b0919f.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.503Z\",\"MediaKey\":\"NST121716854\"},{\"LongDescription\":\"Main level full bath\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/856ef8b5-93c8-4b6e-bfef-c85241ba4ee0.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.508Z\",\"MediaKey\":\"NST121716861\"},{\"LongDescription\":\"Lower level floorplan\",\"Order\":34,\"MediaObjectID\":\"NST34\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/de7e5ae0-2f13-479e-a963-ea4864cc88ad.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.48Z\",\"MediaKey\":\"NST121752137\"},{\"LongDescription\":\"Lower level full bath\",\"Order\":29,\"MediaObjectID\":\"NST29\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/fb6370e6-ac09-4796-b918-5b071f5f4dac.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.511Z\",\"MediaKey\":\"NST121716853\"},{\"LongDescription\":\"Laundry room also leads to primary bedroom\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/7a904d55-d320-47ed-b2b2-18bc0d21077b.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.492Z\",\"MediaKey\":\"NST121716878\"},{\"LongDescription\":\"31-B31A4115.jpg\",\"Order\":25,\"MediaObjectID\":\"NST25\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/fb21a272-0ecf-4a15-9c63-7d6cc470c1a2.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.498Z\",\"MediaKey\":\"NST121716857\"},{\"LongDescription\":\"Composite decking - maintenance free!\",\"Order\":31,\"MediaObjectID\":\"NST31\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/05158994-e518-493f-adcd-f21a8190893a.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.503Z\",\"MediaKey\":\"NST121716851\"},{\"LongDescription\":\"Lower level bedroom\",\"Order\":27,\"MediaObjectID\":\"NST27\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/b627c3df-44ef-42a2-af25-6431e3912cf8.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.492Z\",\"MediaKey\":\"NST121716855\"},{\"LongDescription\":\"Dining room\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/e396ec73-9703-4f32-ac01-d0b7bb703592.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.507Z\",\"MediaKey\":\"NST121716870\"},{\"LongDescription\":\"Gas fireplace makes it perfect for relaxing\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/52d891d9-2373-49ee-a756-cc2cff0ffe54.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.617Z\",\"MediaKey\":\"NST121716871\"},{\"LongDescription\":\"Huge granite island\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/0cdecaa2-8cd2-4641-9c30-6a9c34bb35ca.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.496Z\",\"MediaKey\":\"NST121716875\"},{\"LongDescription\":\"Stainless steel appliances\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/c2788686-720c-4692-846b-c20b73d185ff.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.499Z\",\"MediaKey\":\"NST121716874\"},{\"LongDescription\":\"First floor bedroom currently being used as an office\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/7fd68297-df56-452b-a013-23e607ed1cb8.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.483Z\",\"MediaKey\":\"NST121716852\"},{\"LongDescription\":\"Lower level family room\",\"Order\":23,\"MediaObjectID\":\"NST23\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/475b7217-3f34-43e4-ba9c-3d819c0c8b2f.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.528Z\",\"MediaKey\":\"NST121716859\"},{\"LongDescription\":\"Wall of windows keep it bright\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/5311c726-35f8-4de0-b1cf-0cfe64fcc6a3.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.557Z\",\"MediaKey\":\"NST121716873\"},{\"LongDescription\":\"Space for relaxing\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/80f33f67-bd64-4ec6-bf9e-81003509a470.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.523Z\",\"MediaKey\":\"NST121716885\"},{\"LongDescription\":\"HUGE unfinished lower level space\",\"Order\":33,\"MediaObjectID\":\"NST33\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/de0cc03c-9076-4017-9bff-e36383c76989.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.531Z\",\"MediaKey\":\"NST121716860\"},{\"LongDescription\":\"Beautiful curb appeal at 17858 Hamburg Ave\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/b05fb6d2-dfb2-4faa-9c78-51c25c845489.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.491Z\",\"MediaKey\":\"NST121716887\"},{\"LongDescription\":\"Full house floorplan\",\"Order\":35,\"MediaObjectID\":\"NST35\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/3e24c2d6-ca1a-4956-b7e3-f7308542f9c9.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.478Z\",\"MediaKey\":\"NST121752136\"},{\"LongDescription\":\"Room for playing and entertaining in backyard\",\"Order\":30,\"MediaObjectID\":\"NST30\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/e2a8f391-398f-4c6c-a1d4-b6b0ac7a89df.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.499Z\",\"MediaKey\":\"NST121716883\"},{\"LongDescription\":\"Bright foyer showing neutral paint throughout\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/97904bdd-02f8-49d6-a421-85bbed3cdd9e.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.481Z\",\"MediaKey\":\"NST121716882\"},{\"LongDescription\":\"Great porch and walk out patio\",\"Order\":32,\"MediaObjectID\":\"NST32\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/914b4916-60ef-43e9-96d5-f6ca873eba29.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.533Z\",\"MediaKey\":\"NST121716884\"},{\"LongDescription\":\"Entryway hall\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/9567894d-ee6e-4c5c-addc-355f14256156.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.48Z\",\"MediaKey\":\"NST121716881\"},{\"LongDescription\":\"Spacious living space\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/a9297107-8501-4f64-ba4c-f1677c10ad5a.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.491Z\",\"MediaKey\":\"NST121716868\"},{\"LongDescription\":\"Vaulted ceilings in primary bedroom\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/8567384a-d374-4bfb-a96a-fc64606d2b97.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.501Z\",\"MediaKey\":\"NST121716866\"},{\"LongDescription\":\"Open floor plan\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/7660f250-55b4-46d9-909e-2382295259bb.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.562Z\",\"MediaKey\":\"NST121716872\"},{\"LongDescription\":\"Breakfast bar - room for stools\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/dde5165c-52ee-4490-9380-c19b20a80916.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.556Z\",\"MediaKey\":\"NST121716877\"},{\"LongDescription\":\"Easy access to kitchen from dining room\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ResourceRecordKey\":\"NST7887066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887066/a3f7c47d-7be7-44aa-a402-889cc59fda66.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-27T20:32:15.563Z\",\"MediaKey\":\"NST121716869\"}]","Media__LongDescription":"Large primary bathroom with dual sinks","Media__Order":"22","Media__MediaObjectID":"NST22","Media__ResourceRecordKey":"NST7887066","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7887066/fed91167-9772-4e66-9665-9612bb422c2c.jpeg","Media__ImageWidth":"2080","Media__ImageHeight":"1386","Media__ImageSizeDescription":"2080x1386","Media__MediaModificationTimestamp":"4/27/2026 8:32:15 PM","Media__MediaKey":"NST121716863","Rooms":"[{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":13,\"RoomDimensions\":\"12' x 5'\",\"RoomKey\":\"NST116157388\",\"RoomType\":\"Bathroom\"},{\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":15,\"RoomDimensions\":\"8'10\\\" x 5'\",\"RoomKey\":\"NST116157390\",\"RoomType\":\"Bathroom\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":12,\"RoomDimensions\":\"14' x 15'\",\"RoomKey\":\"NST116157387\",\"RoomType\":\"Deck\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":7,\"RoomDimensions\":\"9' x 13'\",\"RoomKey\":\"NST116157382\",\"RoomType\":\"Dining Room\"},{\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":18,\"RoomDimensions\":\"26'10\\\" x 20'\",\"RoomKey\":\"NST116157393\",\"RoomType\":\"Family Room\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"13'9\\\" x 13'\",\"RoomKey\":\"NST116157377\",\"RoomType\":\"Bedroom\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"6' x 8.7'\",\"RoomKey\":\"NST116157376\",\"RoomType\":\"Foyer\"},{\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":16,\"RoomDimensions\":\"12' x 13'\",\"RoomKey\":\"NST116157391\",\"RoomType\":\"Hobby Room\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":5,\"RoomDimensions\":\"17' x 12'10\\\"\",\"RoomKey\":\"NST116157380\",\"RoomType\":\"Kitchen\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"15' x 6'\",\"RoomKey\":\"NST116157379\",\"RoomType\":\"Laundry\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":6,\"RoomDimensions\":\"17' x 13'\",\"RoomKey\":\"NST116157381\",\"RoomType\":\"Living Room\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":8,\"RoomDimensions\":\"5'7\\\" x 15'\",\"RoomKey\":\"NST116157383\",\"RoomType\":\"Primary Bathroom\"},{\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":19,\"RoomDimensions\":\"12' x 12'\",\"RoomKey\":\"NST116157394\",\"RoomType\":\"Patio\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":10,\"RoomDimensions\":\"4' x 6'\",\"RoomKey\":\"NST116157385\",\"RoomType\":\"Pantry (Walk-In)\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":11,\"RoomDimensions\":\"6' x 19'\",\"RoomKey\":\"NST116157386\",\"RoomType\":\"Porch\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"12' x 12'\",\"RoomKey\":\"NST116157378\",\"RoomType\":\"Bedroom 2\"},{\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":14,\"RoomDimensions\":\"12' x 9'\",\"RoomKey\":\"NST116157389\",\"RoomType\":\"Bedroom 3\"},{\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":17,\"RoomDimensions\":\"26' x 29'\",\"RoomKey\":\"NST116157392\",\"RoomType\":\"Unfinished\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":9,\"RoomDimensions\":\"6'9\\\" x 7'\",\"RoomKey\":\"NST116157384\",\"RoomType\":\"Walk-In Closet\"}]","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"13","Rooms__RoomDimensions":"12' x 5'","Rooms__RoomKey":"NST116157388","Rooms__RoomType":"Bathroom","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Beautiful curb appeal at 17858 Hamburg Ave\"},{\"Order\":2,\"Remarks\":\"Space for relaxing\"},{\"Order\":3,\"Remarks\":\"Bright foyer showing neutral paint throughout\"},{\"Order\":4,\"Remarks\":\"Entryway hall\"},{\"Order\":5,\"Remarks\":\"Back hall with garage and laundry access. Large closet as well.\"},{\"Order\":6,\"Remarks\":\"Laundry room also leads to primary bedroom\"},{\"Order\":7,\"Remarks\":\"First floor bedroom currently being used as an office\"},{\"Order\":8,\"Remarks\":\"Main level full bath\"},{\"Order\":9,\"Remarks\":\"Breakfast bar - room for stools\"},{\"Order\":10,\"Remarks\":\"Kitchen window above sink\"},{\"Order\":11,\"Remarks\":\"Huge granite island\"},{\"Order\":12,\"Remarks\":\"Stainless steel appliances\"},{\"Order\":13,\"Remarks\":\"Wall of windows keep it bright\"},{\"Order\":14,\"Remarks\":\"Open floor plan\"},{\"Order\":15,\"Remarks\":\"Gas fireplace makes it perfect for relaxing\"},{\"Order\":16,\"Remarks\":\"Dining room\"},{\"Order\":17,\"Remarks\":\"Easy access to kitchen from dining room\"},{\"Order\":18,\"Remarks\":\"Spacious living space\"},{\"Order\":19,\"Remarks\":\"Dining room with slider to deck\"},{\"Order\":20,\"Remarks\":\"Vaulted ceilings in primary bedroom\"},{\"Order\":21,\"Remarks\":\"Walk-thru closet and en-suite bathroom\"},{\"Order\":22,\"Remarks\":\"Large primary bathroom with dual sinks\"},{\"Order\":23,\"Remarks\":\"Lower level family room\"},{\"Order\":24,\"Remarks\":\"Plenty of room in lower level\"},{\"Order\":25,\"Remarks\":\"31-B31A4115.jpg\"},{\"Order\":26,\"Remarks\":\"Lower level walk-out to patio\"},{\"Order\":27,\"Remarks\":\"Lower level bedroom\"},{\"Order\":28,\"Remarks\":\"Lower level crafting/ flex space\"},{\"Order\":29,\"Remarks\":\"Lower level full bath\"},{\"Order\":30,\"Remarks\":\"Room for playing and entertaining in backyard\"},{\"Order\":31,\"Remarks\":\"Composite decking - maintenance free!\"},{\"Order\":32,\"Remarks\":\"Great porch and walk out patio\"},{\"Order\":33,\"Remarks\":\"HUGE unfinished lower level space\"},{\"Order\":34,\"Remarks\":\"Lower level floorplan\"},{\"Order\":35,\"Remarks\":\"Full house floorplan\"},{\"Order\":36,\"Remarks\":\"Main level floorplan\"},{\"Order\":37,\"Remarks\":\"Google Map\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37","CustomVTourURL":""}
