{"Id":1376488,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6747338","MLSAGENTID":"NST506560824","MLSOFFICEID":"NST27103","ADDRESS":"504 3rd Avenue SE","ACRES":0.14,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Other","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Pipestone","CONTINGENCY":"None","COUNTY":"Pipestone","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Slate","FORECLOSURE":"No","LASTPRICE":75000.0,"LASTPRICEDATE":"2025-08-12T02:00:03.547","LATITUDE":43.99593,"LENDEROWNED":"No","LISTDATE":"2025-06-30T05:00:00","LISTPRICE":65000.0,"LIVINGAREA":1258.0,"LONGITUDE":-96.315539,"MODIFICATIONTIMESTAMP":"2025-08-12T02:00:03.548","OFFICE_OFFICENAME":"Real Estate Retrievers-Luverne","PHOTOCOUNT":11,"POSTALCODE":"56164","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Investor opportunity on a great corner lot! This 3 bedroom, 2 bathroom home features main floor laundry and a partially finished upstairs offering a clean slate for customization. With solid bones and loads of potential, it's the perfect project to add value and make your mark. Schedule with your favorite agent today to preview the potential this home has!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2689-Pipestone Area Schools","SCHOOLDISTRICTPHONE":"507-825-5861","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-06-30T18:48:03.77","LASTSTATUS":"Active","STREETDIRSUFFIX":"SE","STREETNAME":"3rd","STREETNUMBER":"504","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1913,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-07-02T02:56:03.993","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Home\"},{\"Order\":2,\"Remarks\":\"Living Room\"},{\"Order\":3,\"Remarks\":\"Dining Room\"},{\"Order\":4,\"Remarks\":\"Main Floor Primary Bed\"},{\"Order\":5,\"Remarks\":\"Main Floor Bathroom\"},{\"Order\":6,\"Remarks\":\"2nd Main Floor Bedroom\"},{\"Order\":7,\"Remarks\":\"Kitchen\"},{\"Order\":8,\"Remarks\":\"Upstairs Bedroom\"},{\"Order\":9,\"Remarks\":\"Upstairs Bedroom\"},{\"Order\":10,\"Remarks\":\"Upstairs Hallway\"},{\"Order\":11,\"Remarks\":\"Upstairs Bathroom\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11","SOURCE":"MG_NST"}
{"ListingKey":"NST7766360","LotSizeArea":"0.14","NST_AgeOfProperty":"112","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Block,Other","BasementYN":"True","NST_BathDesc":"Main Floor 3/4 Bath","BathroomsOneQuarter":"0","BathroomsFull":"0","BathroomsHalf":"0","BathroomsThreeQuarter":"2","BathroomsTotalInteger":"2","BedroomsTotal":"3","City":"Pipestone","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Wall Unit(s)","CountyOrParish":"Pipestone","NST_DPResource":"Y","DaysOnMarket":"42","CumulativeDaysOnMarket":"42","NST_DiningRoomDescription":"Living/Dining Room","Directions":"Across the railroad tracks on the corner of 5th ST SE and 3rd AVE SE","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Fuses","ConstructionMaterials":"Slate","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"754","NST_FractionalOwnershipYN":"No","NST_Fuel":"Electric","ParkingFeatures":"Attached Garage","NST_GarageSquareFeet":"264","AccessibilityFeatures":"Wheelchair Ramp(s)","Heating":"Forced Air","OriginalEntryTimestamp":"2025-06-30T18:44:30Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-11","Latitude":"43.99593","NST_LenderOwned":"No","ListAgentKey":"NST519601","ListAgentMlsId":"NST506560824","ListingContractDate":"2025-06-30T05:00:00Z","ListOfficeKey":"NST27103","ListOfficeName":"Real Estate Retrievers-Luverne","ListOfficeMlsId":"NST27103","ListPrice":"65000","LivingArea":"1258","LockBoxType":"Combo","Longitude":"-96.315539","LotSizeDimensions":"60x100","LotSizeSquareFeet":"5967.72","LotSizeUnits":"Acres","ListingId":"NST6747338","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"WCAR","ParcelNumber":"186454370","GarageSpaces":"1","PhotosCount":"11","PostalCity":"Pipestone","PostalCode":"56164","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Investor opportunity on a great corner lot! This 3 bedroom, 2 bathroom home features main floor laundry and a partially finished upstairs offering a clean slate for customization. With solid bones and loads of potential, it's the perfect project to add value and make your mark. Schedule with your favorite agent today to preview the potential this home has!","PublicSurveyRange":"46","PublicSurveyTownship":"106","NST_RentalLicenseYN":"No","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bathroom","NST_AboveGradeSqFtTotal":"1258.0000","NST_BelowGradeSqFtTotal":"754.0000","NST_MainLevelFinishedArea":"994.0000","BuildingAreaTotal":"2012","HighSchoolDistrict":"Pipestone Area Schools","NST_SchoolDistrictNumber":"2689","NST_SchoolDistrictPhone":"507-825-5861","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1258","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One and One Half","StreetDirSuffix":"SE","StreetName":"3rd","StreetNumber":"504","StreetNumberNumeric":"504","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Nichols Add","NST_TaxWithAssessments":"2328.0000","TaxYear":"2025","TaxAnnualAmount":"2328","WaterSource":"City Water/Connected","YearBuilt":"1913","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-08-12T02:00:03.548Z","PhotosChangeTimestamp":"2025-07-02T02:56:03.993Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7766360\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Home\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766360/ac545b52-979d-4aad-ac02-ae681f24ed45.jpeg\",\"MediaModificationTimestamp\":\"2025-07-02T02:55:33.652Z\",\"MediaKey\":\"68649fa52654b34edf9b3282\"},{\"ResourceRecordKey\":\"NST7766360\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Living Room\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766360/47ac3369-e1cd-49cb-8ca2-e95778de174f.jpeg\",\"MediaModificationTimestamp\":\"2025-07-02T02:55:33.676Z\",\"MediaKey\":\"68649fa52654b34edf9b3283\"},{\"ResourceRecordKey\":\"NST7766360\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Dining Room\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766360/33cd18c2-ec7f-42eb-92b0-3148fa12c78b.jpeg\",\"MediaModificationTimestamp\":\"2025-07-02T02:55:33.698Z\",\"MediaKey\":\"68649fa52654b34edf9b3284\"},{\"ResourceRecordKey\":\"NST7766360\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Main Floor Primary Bed\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766360/d360e296-b149-4b18-823e-370a9fcbd795.jpeg\",\"MediaModificationTimestamp\":\"2025-07-02T02:55:33.709Z\",\"MediaKey\":\"68649fa52654b34edf9b3285\"},{\"ResourceRecordKey\":\"NST7766360\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Main Floor Bathroom\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766360/1dffa2de-2e1f-4673-862b-b7c4e84aa4e8.jpeg\",\"MediaModificationTimestamp\":\"2025-07-01T02:38:20.497Z\",\"MediaKey\":\"68634a1c250eb11114cce654\"},{\"ResourceRecordKey\":\"NST7766360\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"2nd Main Floor Bedroom\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766360/11ff6903-a285-477d-8f8c-a0a492243cad.jpeg\",\"MediaModificationTimestamp\":\"2025-07-02T02:55:33.68Z\",\"MediaKey\":\"68649fa52654b34edf9b3286\"},{\"ResourceRecordKey\":\"NST7766360\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Kitchen\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766360/7bd9ef84-3501-4f9b-959d-79297bb6cfcd.jpeg\",\"MediaModificationTimestamp\":\"2025-07-01T02:38:20.514Z\",\"MediaKey\":\"68634a1c250eb11114cce656\"},{\"ResourceRecordKey\":\"NST7766360\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Upstairs Bedroom\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766360/23bd5aac-c22e-4421-ad99-abcbb72013fc.jpeg\",\"MediaModificationTimestamp\":\"2025-07-02T02:55:33.68Z\",\"MediaKey\":\"68649fa52654b34edf9b3287\"},{\"ResourceRecordKey\":\"NST7766360\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Upstairs Bedroom\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766360/c24f748e-f6f6-49d8-ad4a-ba46db555c12.jpeg\",\"MediaModificationTimestamp\":\"2025-07-01T02:38:20.529Z\",\"MediaKey\":\"68634a1c250eb11114cce658\"},{\"ResourceRecordKey\":\"NST7766360\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"Upstairs Hallway\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766360/71a735ae-3b4f-4500-bee0-905689fb7e71.jpeg\",\"MediaModificationTimestamp\":\"2025-07-01T02:38:20.497Z\",\"MediaKey\":\"68634a1c250eb11114cce659\"},{\"ResourceRecordKey\":\"NST7766360\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"Upstairs Bathroom\",\"ImageWidth\":1673,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1673x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766360/a71553a8-f2ac-4c54-88e6-1c632089f6b3.jpeg\",\"MediaModificationTimestamp\":\"2025-07-01T02:38:20.486Z\",\"MediaKey\":\"68634a1c250eb11114cce65a\"}]","Rooms":"[{\"RoomKey\":\"NST115371778\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115371779\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115371780\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115371781\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115371782\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115371783\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Second\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115371784\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115371785\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":\"8\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Home\"},{\"Order\":2,\"Remarks\":\"Living Room\"},{\"Order\":3,\"Remarks\":\"Dining Room\"},{\"Order\":4,\"Remarks\":\"Main Floor Primary Bed\"},{\"Order\":5,\"Remarks\":\"Main Floor Bathroom\"},{\"Order\":6,\"Remarks\":\"2nd Main Floor Bedroom\"},{\"Order\":7,\"Remarks\":\"Kitchen\"},{\"Order\":8,\"Remarks\":\"Upstairs Bedroom\"},{\"Order\":9,\"Remarks\":\"Upstairs Bedroom\"},{\"Order\":10,\"Remarks\":\"Upstairs Hallway\"},{\"Order\":11,\"Remarks\":\"Upstairs Bathroom\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11","CustomVTourURL":""}