$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
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. LongvilleLakes.com is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of LongvilleLakes.com, 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. LongvilleLakes.com is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of LongvilleLakes.com, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":1436761,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6824554","MLSAGENTID":"NST798549702","MLSCOAGENTID":"NST90099065","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,"EXTERIOR":"Other,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":321000.0,"LASTPRICEDATE":"2025-12-05T20:50:04.437","LATITUDE":44.637124,"LENDEROWNED":"No","LISTDATE":"2025-12-05T06:00:00","LISTPRICE":321000.0,"LIVINGAREA":1859.0,"LONGITUDE":-93.136329,"MODIFICATIONTIMESTAMP":"2025-12-05T20:50:04.437","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":"192-Farmington","SCHOOLDISTRICTPHONE":"651-463-5000","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 Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1960,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2025-12-05T20:50:04.437","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","LotSizeArea":"0.48","NST_AgeOfProperty":"65","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Finished","BasementYN":"True","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","CarportSpaces":"0","City":"Farmington","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Dakota","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","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Other,Vinyl Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"1221","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached","NST_GarageSquareFeet":"384","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-12-05T16:20:37Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-12-05","Latitude":"44.637124","NST_LenderOwned":"No","ListAgentKey":"NST225984","ListAgentMlsId":"NST798549702","CoListAgentKey":"NST86971","CoListAgentMlsId":"NST90099065","ListingContractDate":"2025-12-05T06:00:00Z","ListOfficeKey":"NST26320","ListOfficeName":"Opendoor Brokerage, LLC","ListOfficeMlsId":"NST26320","ListPrice":"321000","LivingArea":"1859","Longitude":"-93.136329","LotSizeDimensions":"85 x 245","LotSizeSquareFeet":"20908.8","LotSizeUnits":"Acres","ListingId":"NST6824554","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"140320059021","GarageSpaces":"1","PhotosCount":"17","PostalCity":"Farmington","PostalCode":"55024","NST_PotentialShortSale":"No","NST_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","PublicSurveyRange":"19","PublicSurveySection":"32","PublicSurveyTownship":"114","NST_RentalLicenseYN":"No","NST_AboveGradeSqFtTotal":"1221.0000","NST_BelowGradeSqFtTotal":"874.0000","NST_MainLevelFinishedArea":"384.0000","BuildingAreaTotal":"2095","HighSchoolDistrict":"Farmington","NST_SchoolDistrictNumber":"192","NST_SchoolDistrictPhone":"651-463-5000","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1221","BelowGradeFinishedArea":"638","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Three Level Split","StreetName":"8th","StreetNumber":"509","StreetNumberNumeric":"509","StreetSuffix":"Street","PropertySubType":"Single Family Residence","NST_TaxWithAssessments":"3406.0000","TaxYear":"2025","TaxAnnualAmount":"3406","WaterSource":"City Water/Connected","YearBuilt":"1960","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-12-05T20:50:04.437Z","PhotosChangeTimestamp":"2025-12-05T20:50:04.437Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7833279\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"listing_0.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/7580d983-a175-4beb-9461-583bc43388b7.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.323Z\",\"MediaKey\":\"6933071a6e9a710b7895abc2\"},{\"ResourceRecordKey\":\"NST7833279\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"listing_4.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/42cbd7e0-3f1a-48b0-b1f1-b3479e1c936b.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.313Z\",\"MediaKey\":\"6933071a6e9a710b7895abc6\"},{\"ResourceRecordKey\":\"NST7833279\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/dc6dfc1a-4861-4a07-990e-24761baab7b6.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.332Z\",\"MediaKey\":\"6933071a6e9a710b7895abc3\"},{\"ResourceRecordKey\":\"NST7833279\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"listing_9.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/58b8bd37-7c0f-465c-b49a-13dc7785469a.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.322Z\",\"MediaKey\":\"6933071a6e9a710b7895abcb\"},{\"ResourceRecordKey\":\"NST7833279\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"listing_13.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/347b3fb4-ffa8-4f48-97a3-ddfd83e996b5.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.33Z\",\"MediaKey\":\"6933071a6e9a710b7895abcf\"},{\"ResourceRecordKey\":\"NST7833279\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"listing_7.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/4c5214cd-73bb-4636-9d7d-764818315522.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.362Z\",\"MediaKey\":\"6933071a6e9a710b7895abc9\"},{\"ResourceRecordKey\":\"NST7833279\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"listing_2.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/66863160-e697-4be3-93ff-1cb12328f1da.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.315Z\",\"MediaKey\":\"6933071a6e9a710b7895abc4\"},{\"ResourceRecordKey\":\"NST7833279\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/9b4a62d6-a49a-4a60-ace7-9cf8b28fcebd.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.319Z\",\"MediaKey\":\"6933071a6e9a710b7895abc5\"},{\"ResourceRecordKey\":\"NST7833279\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"listing_5.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/5bc7739e-acb5-487c-aa4b-30352ff1e500.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.323Z\",\"MediaKey\":\"6933071a6e9a710b7895abc7\"},{\"ResourceRecordKey\":\"NST7833279\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"listing_6.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/35a2ee68-b80a-475e-9884-6e4439ad2c86.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.342Z\",\"MediaKey\":\"6933071a6e9a710b7895abc8\"},{\"ResourceRecordKey\":\"NST7833279\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"listing_8.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1558,\"ImageSizeDescription\":\"2080x1558\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/98b67787-3f73-432e-bdc6-3c1f8f804f03.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.312Z\",\"MediaKey\":\"6933071a6e9a710b7895abca\"},{\"ResourceRecordKey\":\"NST7833279\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"listing_10.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/4fd75042-42ea-4277-88c5-b04413d2db97.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.314Z\",\"MediaKey\":\"6933071a6e9a710b7895abcc\"},{\"ResourceRecordKey\":\"NST7833279\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"listing_11.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/95d3c906-689c-421b-ab7d-34ed06db2202.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.312Z\",\"MediaKey\":\"6933071a6e9a710b7895abcd\"},{\"ResourceRecordKey\":\"NST7833279\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"listing_12.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/199060d3-676d-43f0-b1b6-3ca7c7e8fbed.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.323Z\",\"MediaKey\":\"6933071a6e9a710b7895abce\"},{\"ResourceRecordKey\":\"NST7833279\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"listing_14.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/bfef282f-15ae-429a-8c72-337aab30cb18.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.329Z\",\"MediaKey\":\"6933071a6e9a710b7895abd0\"},{\"ResourceRecordKey\":\"NST7833279\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"listing_15.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/877300ad-f0f6-4e03-af51-93aaf3a37c5a.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T16:23:54.347Z\",\"MediaKey\":\"6933071a6e9a710b7895abd1\"},{\"ResourceRecordKey\":\"NST7833279\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"25e4d137-3dbd-4a8d-a6e0-fec6f3997c13.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7833279/8300f5c8-b238-429b-bb62-cb78bae66e98.jpeg\",\"MediaModificationTimestamp\":\"2025-12-05T20:49:32.528Z\",\"MediaKey\":\"6933455c7594dd0e18674412\"}]","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":""}