Bay Lake Realty
Bruce Johnson
Broker/Owner
Bay Lake Realty is Licensed in the State of Minnesota
15929 Wakeman Rd.
Deerwood, MN 56444
Cell Phone: 218-838-1111
E-mail: bruce@baylakerealty.com
{"Id":503072,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6824554","MLSAGENTID":"NST798549702","MLSCOAGENTID":"NST506008353","MLSOFFICEID":"NST26320","ADDRESS":"509 8th Street","ACRES":0.48,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Farmington","CONTINGENCY":"None","COUNTY":"Dakota","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":321000.0,"LASTPRICEDATE":"2026-01-15T03:37:05.453","LATITUDE":44.637124,"LENDEROWNED":"No","LISTDATE":"2025-12-05T06:00:00","LISTPRICE":315000.0,"LIVINGAREA":1859.0,"LONGITUDE":-93.136329,"MODIFICATIONTIMESTAMP":"2026-01-15T03:37:05.452","OFFICE_OFFICENAME":"Opendoor Brokerage, LLC","PHOTOCOUNT":17,"POSTALCODE":"55024","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to this beautiful home that boasts a neutral color paint scheme, creating a calming and inviting atmosphere. The kitchen is a chef's dream, equipped with all stainless steel appliances that add a modern touch. The fresh interior paint throughout the house gives it a clean and updated feel. The property also features a fenced-in backyard, perfect for privacy and outdoor activities. This home is a perfect blend of style and comfort, making it a must-see property. Don't miss out on this gem! Included 100-Day Home Warranty with buyer activation","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"934-Farmington","SCHOOLDISTRICTPHONE":"6514635000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-12-05T20:50:04.437","LASTSTATUS":"Active","STREETNAME":"8th","STREETNUMBER":"509","STREETSUFFIX":"Street","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1960,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-01-04T23:36:05.282","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"listing_0.jpg\"},{\"Order\":2,\"Remarks\":\"listing_4.jpg\"},{\"Order\":4,\"Remarks\":\"listing_9.jpg\"},{\"Order\":5,\"Remarks\":\"listing_13.jpg\"},{\"Order\":6,\"Remarks\":\"listing_7.jpg\"},{\"Order\":7,\"Remarks\":\"listing_2.jpg\"},{\"Order\":9,\"Remarks\":\"listing_5.jpg\"},{\"Order\":10,\"Remarks\":\"listing_6.jpg\"},{\"Order\":11,\"Remarks\":\"listing_8.jpg\"},{\"Order\":12,\"Remarks\":\"listing_10.jpg\"},{\"Order\":13,\"Remarks\":\"listing_11.jpg\"},{\"Order\":14,\"Remarks\":\"listing_12.jpg\"},{\"Order\":15,\"Remarks\":\"listing_14.jpg\"},{\"Order\":16,\"Remarks\":\"listing_15.jpg\"},{\"Order\":17,\"Remarks\":\"25e4d137-3dbd-4a8d-a6e0-fec6f3997c13.jpeg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","SOURCE":"MG_NST"}
{"ListingKey":"NST7833279","AssociationYN":"False","AssociationFee":"0","Basement":"Finished","CarportSpaces":"0","City":"Farmington","Contingency":"None","Directions":"Head northwest on 8th St toward Hickory St\nTurn left onto Hickory St\nTurn right onto MN-3 N\nTurn right at the 2nd cross street onto Spruce St\nTurn right at the 1st cross street onto 8th St","FireplaceYN":"False","NST_Fuel":"Natural Gas","Latitude":"44.637124","ListPrice":"315000","LivingArea":"1859","Longitude":"-93.136329","LotSizeDimensions":"85 x 245","LotSizeUnits":"Acres","ParcelNumber":"140320059021","PostalCity":"Farmington","PostalCode":"55024","PublicRemarks":"Welcome to this beautiful home that boasts a neutral color paint scheme, creating a calming and inviting atmosphere. The kitchen is a chef's dream, equipped with all stainless steel appliances that add a modern touch. The fresh interior paint throughout the house gives it a clean and updated feel. The property also features a fenced-in backyard, perfect for privacy and outdoor activities. This home is a perfect blend of style and comfort, making it a must-see property. Don't miss out on this gem! Included 100-Day Home Warranty with buyer activation","PublicSurveyRange":"19","PublicSurveySection":"32","PublicSurveyTownship":"114","NST_SchoolDistrictPhone":"6514635000","Sewer":"City Sewer/Connected","StateOrProvince":"MN","StreetName":"8th","StreetNumber":"509","StreetNumberNumeric":"509","StreetSuffix":"Street","TaxYear":"2025","YearBuilt":"1960","NST_AboveGradeSqFtTotal":"1221","AboveGradeFinishedArea":"1221","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","BasementYN":"True","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"874","BelowGradeFinishedArea":"638","CumulativeDaysOnMarket":"0","NewConstructionYN":"False","Cooling":"Central Air","CountyOrParish":"Dakota","NST_DPResource":"Yes","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-01-04T23:35:05.22Z","DaysOnMarket":"0","FireplacesTotal":"0","FoundationArea":"1221","NST_FractionalOwnershipYN":"No","NST_GarageSquareFeet":"384","GarageSpaces":"1","Heating":"Forced Air","HighSchoolDistrict":"Farmington","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","NST_LenderOwned":"No","Levels":"Three Level Split","ListingContractDate":"2025-12-05T06:00:00Z","ListingId":"NST6824554","LotSizeArea":"0.48","NST_MainLevelFinishedArea":"384","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2025-12-05T10:20:37Z","NST_SchoolDistrictNumber":"934","ParkingFeatures":"Detached Garage","PhotosCount":"17","PhotosChangeTimestamp":"2026-01-04T23:36:05.282Z","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","StandardStatus":"Active","TaxAnnualAmount":"3406","NST_TaxWithAssessments":"3406","Township":"Farmington","VideosCount":"0","WaterSource":"City Water/Connected","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST97067","CoListAgentMlsId":"NST506008353","CoListOfficeName":"Opendoor Brokerage, LLC","ListAgentKey":"NST225984","ListAgentMlsId":"NST798549702","ListOfficeMlsId":"NST26320","ListOfficeName":"Opendoor Brokerage, LLC","ListOfficeKey":"NST26320","ModificationTimestamp":"2026-01-15T03:37:05.452Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/7580d983-a175-4beb-9461-583bc43388b7.jpeg\",\"LongDescription\":\"listing_0.jpg\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.323Z\",\"MediaKey\":\"NST119852162\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/e3a26c7c-9637-4c7a-9eff-26ef6d9b4e14.jpeg\",\"LongDescription\":\"25e4d137-3dbd-4a8d-a6e0-fec6f3997c13.jpeg\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-01-04T23:35:06.786Z\",\"MediaKey\":\"NST119857203\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/42cbd7e0-3f1a-48b0-b1f1-b3479e1c936b.jpeg\",\"LongDescription\":\"listing_4.jpg\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.313Z\",\"MediaKey\":\"NST119852158\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/4ee598c7-1323-41f2-886b-6224a93e9a1d.jpeg\",\"LongDescription\":\"listing_9.jpg\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-01-04T23:35:06.777Z\",\"MediaKey\":\"NST119852153\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/34dd7141-e34c-458d-91b2-27c04384cf39.jpeg\",\"LongDescription\":\"listing_2.jpg\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-01-04T23:35:06.773Z\",\"MediaKey\":\"NST119852160\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/9ac190f6-3678-4d20-ac75-22c717a8908d.jpeg\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-01-04T23:35:06.824Z\",\"MediaKey\":\"NST119852161\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/9a094c52-2dd0-4ac9-b638-ea99f6757e35.jpeg\",\"LongDescription\":\"listing_6.jpg\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-04T23:35:06.757Z\",\"MediaKey\":\"NST119852156\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/fb60f3a0-877d-45ef-9d87-8a06e09eb11b.jpeg\",\"LongDescription\":\"listing_10.jpg\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-01-04T23:35:06.766Z\",\"MediaKey\":\"NST119852152\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/37fb60de-4e77-4456-86c7-8ef46cc11f19.jpeg\",\"LongDescription\":\"listing_14.jpg\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-04T23:35:06.77Z\",\"MediaKey\":\"NST119852148\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/6bf8623f-bc23-4751-a50e-466941fadeed.jpeg\",\"LongDescription\":\"listing_7.jpg\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-01-04T23:35:06.767Z\",\"MediaKey\":\"NST119852155\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/6ffbff0e-b6bf-4f14-b5b8-63e3bf2edaab.jpeg\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-04T23:35:06.762Z\",\"MediaKey\":\"NST119852159\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/5dbbaea3-fcb7-460a-8ffe-0bad1891425f.jpeg\",\"LongDescription\":\"listing_13.jpg\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-04T23:35:06.761Z\",\"MediaKey\":\"NST119852149\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/9740caac-47f0-455a-bf29-78ce4638c6f1.jpeg\",\"LongDescription\":\"listing_5.jpg\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-01-04T23:35:06.775Z\",\"MediaKey\":\"NST119852157\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/c3b8e666-4a27-4641-a118-06cbea998324.jpeg\",\"LongDescription\":\"listing_8.jpg\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1558,\"ImageSizeDescription\":\"2080x1558\",\"MediaModificationTimestamp\":\"2026-01-04T23:35:06.764Z\",\"MediaKey\":\"NST119852154\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/43d53669-e8cf-43c2-bb09-4a25d88d826a.jpeg\",\"LongDescription\":\"listing_12.jpg\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-01-04T23:35:06.794Z\",\"MediaKey\":\"NST119852150\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/4683130f-6d22-467a-ba55-5f7525fbd3ce.jpeg\",\"LongDescription\":\"listing_11.jpg\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-01-04T23:35:06.769Z\",\"MediaKey\":\"NST119852151\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/312d9dc7-7ccd-4f35-8ff0-fde3480d920d.jpeg\",\"LongDescription\":\"listing_15.jpg\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ResourceRecordKey\":\"NST7833279\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-01-04T23:35:06.857Z\",\"MediaKey\":\"NST119852147\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7833279/7580d983-a175-4beb-9461-583bc43388b7.jpeg","Media__LongDescription":"listing_0.jpg","Media__Order":"1","Media__MediaObjectID":"NST1","Media__ResourceRecordKey":"NST7833279","Media__ImageWidth":"2080","Media__ImageHeight":"1560","Media__ImageSizeDescription":"2080x1560","Media__MediaModificationTimestamp":"12/5/2025 4:23:54 PM","Media__MediaKey":"NST119852162","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"listing_0.jpg\"},{\"Order\":2,\"Remarks\":\"listing_4.jpg\"},{\"Order\":4,\"Remarks\":\"listing_9.jpg\"},{\"Order\":5,\"Remarks\":\"listing_13.jpg\"},{\"Order\":6,\"Remarks\":\"listing_7.jpg\"},{\"Order\":7,\"Remarks\":\"listing_2.jpg\"},{\"Order\":9,\"Remarks\":\"listing_5.jpg\"},{\"Order\":10,\"Remarks\":\"listing_6.jpg\"},{\"Order\":11,\"Remarks\":\"listing_8.jpg\"},{\"Order\":12,\"Remarks\":\"listing_10.jpg\"},{\"Order\":13,\"Remarks\":\"listing_11.jpg\"},{\"Order\":14,\"Remarks\":\"listing_12.jpg\"},{\"Order\":15,\"Remarks\":\"listing_14.jpg\"},{\"Order\":16,\"Remarks\":\"listing_15.jpg\"},{\"Order\":17,\"Remarks\":\"25e4d137-3dbd-4a8d-a6e0-fec6f3997c13.jpeg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","CustomVTourURL":""}