A TRADITION OF TRUST & SERVICE
$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Mortgage Calculator
Opendoor Brokerage, LLC 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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, 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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"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":""}