{"Id":1407575,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6785572","MLSAGENTID":"NST503500136","MLSOFFICEID":"NST26875","ADDRESS":"406 2nd Avenue SE","ACRES":0.23,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Daylight/Lookout Windows,Full","BATHSTOTAL":3.0,"BEDROOMS":3,"CITY":"Pine Island","CONTINGENCY":"None","COUNTY":"Goodhue","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Steel Siding","FORECLOSURE":"No","LASTPRICE":389900.0,"LASTPRICEDATE":"2025-11-19T21:42:03.67","LATITUDE":44.198903,"LENDEROWNED":"No","LISTDATE":"2025-09-10T05:00:00","LISTPRICE":379900.0,"LIVINGAREA":2249.0,"LONGITUDE":-92.644168,"MODIFICATIONTIMESTAMP":"2025-11-19T21:42:03.669","OFFICE_OFFICENAME":"Progressive Real Estate","PHOTOCOUNT":17,"POSTALCODE":"55963","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Upscale renovation! Country kitchen w/ granite Island, dual wall ovens, hand built cabinetry, natural stone backsplash & floors. If that's not enough the updates to the upper level include a large Master w/ walk-in closet and luxurious Ensuite with 6' freestanding MTI soaking tub with separate tile shower. Add to this a heated 26ft deep attached garage, (bring the full sized trucks!) as well as a climate controlled detached shop wrapped in a fenced yard, mature landscaping, a 45ft RV parking stall w/ 110v and just steps from the school, the pool, and the Douglas trail makes this the perfect opportunity to make this wonderful community your home.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"255-Pine Island","SCHOOLDISTRICTPHONE":"507-356-4849","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-12T12:57:04.963","LASTSTATUS":"Active","STREETDIRSUFFIX":"SE","STREETNAME":"2nd","STREETNUMBER":"406","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1940,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-11-19T21:22:03.795","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"5008360332363067708.jpeg\"},{\"Order\":2,\"Remarks\":\"1399460566744619472.jpeg\"},{\"Order\":3,\"Remarks\":\"Formal dining room\"},{\"Order\":4,\"Remarks\":\"9116171489672952870.jpeg\"},{\"Order\":5,\"Remarks\":\"906487469154930850.jpeg\"},{\"Order\":6,\"Remarks\":\"IMG_4246.jpeg\"},{\"Order\":7,\"Remarks\":\"2072089854444638972.jpeg\"},{\"Order\":8,\"Remarks\":\"Master Bedroom\"},{\"Order\":9,\"Remarks\":\"Bathroom 2nd Floor\"},{\"Order\":10,\"Remarks\":\"2nd bedroom\"},{\"Order\":11,\"Remarks\":\"3rd bedroom\"},{\"Order\":12,\"Remarks\":\"Kids play set\"},{\"Order\":13,\"Remarks\":\"Deep garage off the alley\"},{\"Order\":14,\"Remarks\":\"Parking Off the Alley\"},{\"Order\":15,\"Remarks\":\"RV Parking area\"},{\"Order\":16,\"Remarks\":\"IMG_6150.jpeg\"},{\"Order\":17,\"Remarks\":\"2683562922806872752.jpeg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","SOURCE":"MG_NST"}
{"ListingKey":"NST7799666","LotSizeArea":"0.23","NST_AgeOfProperty":"85","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Deck,Hardwood Floors,Kitchen Center Island,Primary Bedroom Walk-In Closet,Natural Woodwork,Paneled Doors,Porch,Sun Room,Walk-In Closet","Appliances":"Dishwasher,Disposal,Dryer,Range,Refrigerator,Washer","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Block,Daylight/Lookout Windows,Full","BasementYN":"True","NST_BathDesc":"3/4 Basement,Main Floor 1/2 Bath,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"3","City":"Pine Island","PropertyType":"Residential","NST_ConstructionMaterialsDesc":"Frame","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Goodhue","NST_DPResource":"Y","DaysOnMarket":"70","CumulativeDaysOnMarket":"70","NST_DiningRoomDescription":"Separate/Formal Dining Room","Directions":"S Main St S 4 blocks to 4th St SW, Rt on 2nd Ave SE home on Rt.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Steel Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"768","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Detached","NST_GarageSquareFeet":"1594","AccessibilityFeatures":"None","Heating":"Hot Water","OriginalEntryTimestamp":"2025-09-12T12:55:48Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-11-19","Latitude":"44.198903","NST_LenderOwned":"No","ListAgentKey":"NST36319","ListAgentMlsId":"NST503500136","ListingContractDate":"2025-09-10T05:00:00Z","ListOfficeKey":"NST26875","ListOfficeName":"Progressive Real Estate","ListOfficeMlsId":"NST26875","ListPrice":"379900","LivingArea":"2249","NST_LockBoxSource":"SEMR","Longitude":"-92.644168","LotSizeDimensions":"83x123","LotSizeSquareFeet":"10018.8","LotSizeUnits":"Acres","ListingId":"NST6785572","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SEMR","ParcelNumber":"681002030","GarageSpaces":"6","PhotosCount":"17","PostalCity":"Pine Island","PostalCode":"55963","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Upscale renovation! Country kitchen w/ granite Island, dual wall ovens, hand built cabinetry, natural stone backsplash & floors. If that's not enough the updates to the upper level include a large Master w/ walk-in closet and luxurious Ensuite with 6' freestanding MTI soaking tub with separate tile shower. Add to this a heated 26ft deep attached garage, (bring the full sized trucks!) as well as a climate controlled detached shop wrapped in a fenced yard, mature landscaping, a 45ft RV parking stall w/ 110v and just steps from the school, the pool, and the Douglas trail makes this the perfect opportunity to make this wonderful community your home.","NST_RentalLicenseYN":"No","RoomType":"Living Room,Dining Room,Family Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Den,Sun Room,Bathroom","NST_AboveGradeSqFtTotal":"1649.0000","NST_BelowGradeSqFtTotal":"768.0000","NST_MainLevelFinishedArea":"881.0000","BuildingAreaTotal":"2417","HighSchoolDistrict":"Pine Island","NST_SchoolDistrictNumber":"255","NST_SchoolDistrictPhone":"507-356-4849","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1649","BelowGradeFinishedArea":"600","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetDirSuffix":"SE","StreetName":"2nd","StreetNumber":"406","StreetNumberNumeric":"406","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"City/Pine Island","NST_TaxWithAssessments":"5766.0000","TaxYear":"2025","TaxAnnualAmount":"5766","WaterSource":"City Water/Connected","YearBuilt":"1940","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-11-19T21:42:03.669Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7799666\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"5008360332363067708.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/c08a7633-2060-424d-b837-b7314456f078.jpeg\",\"MediaModificationTimestamp\":\"2025-11-19T21:20:30.815Z\",\"MediaKey\":\"691e349e72ec814c94a7b43e\"},{\"ResourceRecordKey\":\"NST7799666\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"1399460566744619472.jpeg\",\"ImageWidth\":1542,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1542x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/7f9a8331-bcfc-4aa4-b47b-4f75f3bee9a4.jpeg\",\"MediaModificationTimestamp\":\"2025-10-28T13:50:25.789Z\",\"MediaKey\":\"6900ca21106de35951010c8a\"},{\"ResourceRecordKey\":\"NST7799666\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Formal dining room\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/f23b095d-fdd9-4c14-9769-b54b94c36eb4.jpeg\",\"MediaModificationTimestamp\":\"2025-10-28T13:50:25.792Z\",\"MediaKey\":\"6900ca21106de35951010c8d\"},{\"ResourceRecordKey\":\"NST7799666\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"9116171489672952870.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1542,\"ImageSizeDescription\":\"2048x1542\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/6b16a3ca-8878-4acf-bfe2-165f5c78c76c.jpeg\",\"MediaModificationTimestamp\":\"2025-11-19T21:21:29.873Z\",\"MediaKey\":\"691e34d98c397564f50514c5\"},{\"ResourceRecordKey\":\"NST7799666\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"906487469154930850.jpeg\",\"ImageWidth\":2047,\"ImageHeight\":1535,\"ImageSizeDescription\":\"2047x1535\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/6094675b-1de4-4cd7-ac4a-526eff62f09b.jpeg\",\"MediaModificationTimestamp\":\"2025-11-19T21:21:29.865Z\",\"MediaKey\":\"691e34d98c397564f50514c6\"},{\"ResourceRecordKey\":\"NST7799666\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"IMG_4246.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/0bc71fb2-b706-4d22-9489-aa40b3319772.jpeg\",\"MediaModificationTimestamp\":\"2025-11-19T21:21:29.859Z\",\"MediaKey\":\"691e34d98c397564f50514c7\"},{\"ResourceRecordKey\":\"NST7799666\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"2072089854444638972.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/bff19164-035d-42d9-a289-7b1b123c103a.jpeg\",\"MediaModificationTimestamp\":\"2025-11-19T21:21:29.884Z\",\"MediaKey\":\"691e34d98c397564f50514c8\"},{\"ResourceRecordKey\":\"NST7799666\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Master Bedroom\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/cc14cbe8-8584-493b-ad45-a2c238568cae.jpeg\",\"MediaModificationTimestamp\":\"2025-11-19T21:21:29.853Z\",\"MediaKey\":\"691e34d98c397564f50514c9\"},{\"ResourceRecordKey\":\"NST7799666\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Bathroom 2nd Floor\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/283de8ca-9e59-49b4-b9f8-d9fad7e661dd.jpeg\",\"MediaModificationTimestamp\":\"2025-11-19T21:21:29.857Z\",\"MediaKey\":\"691e34d98c397564f50514ca\"},{\"ResourceRecordKey\":\"NST7799666\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"2nd bedroom\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/95a36449-802b-4bd9-ae8f-716ab5638231.jpeg\",\"MediaModificationTimestamp\":\"2025-11-19T21:21:29.85Z\",\"MediaKey\":\"691e34d98c397564f50514cb\"},{\"ResourceRecordKey\":\"NST7799666\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"3rd bedroom\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/ba062c3a-213b-4f16-8852-122e656872c5.jpeg\",\"MediaModificationTimestamp\":\"2025-11-19T21:21:29.889Z\",\"MediaKey\":\"691e34d98c397564f50514cc\"},{\"ResourceRecordKey\":\"NST7799666\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"Kids play set\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/20282f5a-2d00-4cc2-b549-606eee873a1e.jpeg\",\"MediaModificationTimestamp\":\"2025-11-19T21:21:29.859Z\",\"MediaKey\":\"691e34d98c397564f50514cd\"},{\"ResourceRecordKey\":\"NST7799666\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"Deep garage off the alley\",\"ImageWidth\":2048,\"ImageHeight\":1542,\"ImageSizeDescription\":\"2048x1542\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/072b5fe6-f8b5-4b9b-b11a-778c493b3ca7.jpeg\",\"MediaModificationTimestamp\":\"2025-11-19T21:21:29.892Z\",\"MediaKey\":\"691e34d98c397564f50514ce\"},{\"ResourceRecordKey\":\"NST7799666\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"Parking Off the Alley\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/447a037b-35c3-4148-8367-51fb0831ded6.jpeg\",\"MediaModificationTimestamp\":\"2025-11-19T21:21:29.88Z\",\"MediaKey\":\"691e34d98c397564f50514cf\"},{\"ResourceRecordKey\":\"NST7799666\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"RV Parking area\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/17d4074d-8a2b-433c-bcee-c7b04c11db1b.jpeg\",\"MediaModificationTimestamp\":\"2025-11-19T21:21:29.866Z\",\"MediaKey\":\"691e34d98c397564f50514d0\"},{\"ResourceRecordKey\":\"NST7799666\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"IMG_6150.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/0b277525-a7f1-4cf5-ba47-b81c20b85e90.jpeg\",\"MediaModificationTimestamp\":\"2025-11-19T21:21:29.887Z\",\"MediaKey\":\"691e34d98c397564f50514d1\"},{\"ResourceRecordKey\":\"NST7799666\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"2683562922806872752.jpeg\",\"ImageWidth\":1542,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1542x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799666/fbf13540-74c0-4d6b-9332-8cf8cc920f84.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T02:37:49.917Z\",\"MediaKey\":\"68d74dfd3a98f5613446c677\"}]","PhotosChangeTimestamp":"2025-11-19T21:22:03.795Z","Rooms":"[{\"RoomKey\":\"NST115594469\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115594470\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115594471\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Basement\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115594472\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115594473\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115594474\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115594475\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115594476\",\"RoomType\":\"Den\",\"RoomLevel\":\"Basement\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115594477\",\"RoomType\":\"Sun Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115735548\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Basement\",\"NST_RoomSortOrder\":\"10\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"5008360332363067708.jpeg\"},{\"Order\":2,\"Remarks\":\"1399460566744619472.jpeg\"},{\"Order\":3,\"Remarks\":\"Formal dining room\"},{\"Order\":4,\"Remarks\":\"9116171489672952870.jpeg\"},{\"Order\":5,\"Remarks\":\"906487469154930850.jpeg\"},{\"Order\":6,\"Remarks\":\"IMG_4246.jpeg\"},{\"Order\":7,\"Remarks\":\"2072089854444638972.jpeg\"},{\"Order\":8,\"Remarks\":\"Master Bedroom\"},{\"Order\":9,\"Remarks\":\"Bathroom 2nd Floor\"},{\"Order\":10,\"Remarks\":\"2nd bedroom\"},{\"Order\":11,\"Remarks\":\"3rd bedroom\"},{\"Order\":12,\"Remarks\":\"Kids play set\"},{\"Order\":13,\"Remarks\":\"Deep garage off the alley\"},{\"Order\":14,\"Remarks\":\"Parking Off the Alley\"},{\"Order\":15,\"Remarks\":\"RV Parking area\"},{\"Order\":16,\"Remarks\":\"IMG_6150.jpeg\"},{\"Order\":17,\"Remarks\":\"2683562922806872752.jpeg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","CustomVTourURL":""}