{"Id":596904,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7119511","MLSAGENTID":"NST506014680","MLSCOAGENTID":"NST502049255","MLSOFFICEID":"NST8107","ADDRESS":"2557 Sherwood Road","ACRES":0.3,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Egress Window(s),Full,Partially Finished,Storage Space","BATHSTOTAL":1.0,"BEDROOMS":3.0,"CITY":"Mounds View","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":275000.0,"LASTPRICEDATE":"2026-08-07T15:01:08.05","LATITUDE":45.115559,"LENDEROWNED":"No","LISTDATE":"2026-08-07T05:00:00","LISTPRICE":275000.0,"LIVINGAREA":1440.0,"LONGITUDE":-93.209814,"MODIFICATIONTIMESTAMP":"2026-08-07T21:56:07.164","OFFICE_OFFICENAME":"Edina Realty, Inc.","PHOTOCOUNT":22,"POSTALCODE":"55112","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Well-maintained rambler in Mounds View School District. Features hardwood floors, a large privacy-fenced yard, and a two-tier deck with hot tub. Major updates include new windows (2018) and a new roof, facia, sofit and gutters (2019). The basement offers excellent potential for additional finished living space. Conveniently located near schools, local parks, trails, and recreation opportunities.\n\n- Bay window and sliding glass doors replaced - 2016\n - TV's and TV mounts will be removed. Drywall will be patched and painted\n - Extra appliances in basement and garage will be removed\n - Outdoor storage \"sheds\" on backside of the home and hot tub stay with the property","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt","SCHOOLDISTRICTNUMBER":"621-Mounds View","SCHOOLDISTRICTPHONE":"6516216001","SEWER":"City Sewer - In Street","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-07T15:01:08.05","LASTSTATUS":"Active","STREETNAME":"Sherwood","STREETNUMBER":"2557","STREETSUFFIX":"Road","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water - In Street","WATERFRONTPRESENT":false,"YEARBUILT":1963,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-08-07T15:00:06.703","PHOTOREMARKS":"[{\"Order\":10,\"Remarks\":\"Side entry\"},{\"Order\":12,\"Remarks\":\"Main level 1st bedroom\"},{\"Order\":13,\"Remarks\":\"Main level 2nd bedroom\"},{\"Order\":15,\"Remarks\":\"Main level 3/4 bedroom\"},{\"Order\":16,\"Remarks\":\"Basement 3rd bedroom\"},{\"Order\":17,\"Remarks\":\"Basement walk-in closet\"},{\"Order\":19,\"Remarks\":\"Basement storage/flex space\"},{\"Order\":20,\"Remarks\":\"Hot tub stays with the property\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22","SOURCE":"MG_NST"}
{"ListingKey":"NST7944280","NST_AboveGradeSqFtTotal":"1040","AboveGradeFinishedArea":"1040","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s),Deck,Hardwood Floors,Kitchen Window,Main Floor Primary Bedroom","Appliances":"Dryer,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Egress Window(s),Full,Partially Finished,Storage Space","BasementYN":"True","NST_BathDesc":"Main Floor 3/4 Bath","BathroomsFull":"0","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"1040","BelowGradeFinishedArea":"400","CumulativeDaysOnMarket":"0","City":"Mounds View","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","Directions":"From US 10 W turn right onto Long Lake Road and left onto Sherwood Road. Home will be on Left.","DocumentsCount":"0","DaysOnMarket":"0","ExteriorFeatures":"Stone,Wood","Fencing":"Privacy,Wood","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"1040","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"480","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Mounds View","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.115559","NST_LenderOwned":"No","Levels":"One","ListPrice":"275000","ListingContractDate":"2026-08-07T05:00:00Z","ListingId":"NST7119511","LivingArea":"1440","Longitude":"-93.209814","LotSizeArea":"0.3","LotSizeDimensions":"96x137","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1040","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-08-07T09:59:58Z","ParcelNumber":"063023140046","ParkingFeatures":"Detached Garage","NST_PatioPorchType":"Deck","PhotosCount":"22","PhotosChangeTimestamp":"2026-08-07T15:00:06.703Z","PostalCity":"Mounds View","PostalCode":"55112","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Well-maintained rambler in Mounds View School District. Features hardwood floors, a large privacy-fenced yard, and a two-tier deck with hot tub. Major updates include new windows (2018) and a new roof, facia, sofit and gutters (2019). The basement offers excellent potential for additional finished living space. Conveniently located near schools, local parks, trails, and recreation opportunities.\n\n- Bay window and sliding glass doors replaced - 2016\n - TV's and TV mounts will be removed. Drywall will be patched and painted\n - Extra appliances in basement and garage will be removed\n - Outdoor storage \"sheds\" on backside of the home and hot tub stay with the property","PublicSurveyRange":"23","PublicSurveySection":"06","PublicSurveyTownship":"30","Roof":"Age 8 Years or Less,Asphalt","NST_SchoolDistrictFullName":"621 - Mounds View","NST_SchoolDistrictNumber":"621","NST_SchoolDistrictPhone":"6516216001","Sewer":"City Sewer - In Street","NST_SpecialSearch":"Main Floor Primary,Main Floor Bedroom","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Sherwood","StreetNumber":"2557","StreetNumberNumeric":"2557","StreetSuffix":"Road","SubdivisionName":"Section 6 Town 30 Range 23","TaxAnnualAmount":"3922","NST_TaxWithAssessments":"3922","TaxYear":"2025","NST_TotalArea":"2080","BuildingAreaTotal":"2080","Township":"Mounds View","VideosCount":"0","WaterSource":"City Water - In Street","WaterfrontYN":"False","YearBuilt":"1963","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST217720","CoListAgentMlsId":"NST502049255","CoListOfficeName":"Edina Realty, Inc.","ListAgentKey":"NST108337","ListAgentMlsId":"NST506014680","ListOfficeMlsId":"NST8107","ListOfficeName":"Edina Realty, Inc.","ListOfficeKey":"NST16442","ModificationTimestamp":"2026-08-07T21:56:07.164Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/9b2da2c4-6e4c-4edb-a754-248a9a5e3a33.jpeg\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:44:25.079Z\",\"MediaKey\":\"NST124115024\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/9f854729-0055-41e9-9338-a56af6275ad8.jpeg\",\"LongDescription\":\"Side entry\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:47:14.505Z\",\"MediaKey\":\"NST124115019\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/40fd315f-0346-4bc2-9633-12a35c57622a.jpeg\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:44:25.091Z\",\"MediaKey\":\"NST124115028\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/1ca24a03-bb0a-4d75-83d2-9750abca42d5.jpeg\",\"LongDescription\":\"Main level 1st bedroom\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:48:09.818Z\",\"MediaKey\":\"NST124115029\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/25d9eaff-181b-4a6f-86f7-bfba4a84d628.jpeg\",\"LongDescription\":\"Main level 3/4 bedroom\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:48:09.821Z\",\"MediaKey\":\"NST124115012\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/fdee2f20-a1af-4fe0-a6cf-e035f5ec05e1.jpeg\",\"LongDescription\":\"Basement walk-in closet\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:48:09.862Z\",\"MediaKey\":\"NST124115010\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/1e63faa9-4e53-49d6-b7ab-3b6f907cb078.jpeg\",\"LongDescription\":\"Main level 2nd bedroom\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:48:09.876Z\",\"MediaKey\":\"NST124115013\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/76965acb-37cf-4894-ace8-a10af75f9538.jpeg\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:48:09.834Z\",\"MediaKey\":\"NST124115014\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/46311e27-632a-4008-acd0-0faef30a024f.jpeg\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:44:25.082Z\",\"MediaKey\":\"NST124115025\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/23c3c2de-a272-4ec3-8848-cea8dd96697b.jpeg\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:48:09.888Z\",\"MediaKey\":\"NST124115008\"},{\"Order\":19,\"MediaObjectID\":\"NST19\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/772d76ee-c551-4fb3-b224-b3868328851a.jpeg\",\"LongDescription\":\"Basement storage/flex space\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:48:09.844Z\",\"MediaKey\":\"NST124115009\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/921bbd0a-94df-49e3-ab8b-3d08506be0d4.jpeg\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:47:14.516Z\",\"MediaKey\":\"NST124115021\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/dee028d0-2617-468d-ada5-2c6705a55c20.jpeg\",\"LongDescription\":\"Basement 3rd bedroom\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:48:09.84Z\",\"MediaKey\":\"NST124115011\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/61509f75-7d7a-4aa5-8490-78b406666416.jpeg\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:44:25.117Z\",\"MediaKey\":\"NST124115033\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/27a5cd71-3ba3-45a1-bb44-bd6a80da104f.jpeg\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:44:25.114Z\",\"MediaKey\":\"NST124115031\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/43387e15-ce6d-45cc-abe6-00b06c9f64c1.jpeg\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:47:14.497Z\",\"MediaKey\":\"NST124115020\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/acb9ff0d-4c07-493e-9543-dac2f8562d56.jpeg\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:44:25.115Z\",\"MediaKey\":\"NST124115030\"},{\"Order\":22,\"MediaObjectID\":\"NST22\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/b9ceb1b7-7793-48a5-bb70-c677c7d3249b.jpeg\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:48:09.876Z\",\"MediaKey\":\"NST124115004\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/a5f8db50-5f2d-4fd0-ab0f-93996d0ed958.jpeg\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:48:09.812Z\",\"MediaKey\":\"NST124115017\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/83168440-c877-402d-b933-a97c887ec276.jpeg\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:47:14.496Z\",\"MediaKey\":\"NST124115022\"},{\"Order\":20,\"MediaObjectID\":\"NST20\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/be396303-0378-4f1c-b826-2fd59c842e62.jpeg\",\"LongDescription\":\"Hot tub stays with the property\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:58:12.545Z\",\"MediaKey\":\"NST124115006\"},{\"Order\":21,\"MediaObjectID\":\"NST21\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944280/42d38be3-0269-43b5-b9ba-a3f9f2abfc2d.jpeg\",\"ResourceRecordKey\":\"NST7944280\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaModificationTimestamp\":\"2026-08-07T14:48:09.845Z\",\"MediaKey\":\"NST124115003\"}]","Media__Order":"6","Media__MediaObjectID":"NST6","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7944280/9b2da2c4-6e4c-4edb-a754-248a9a5e3a33.jpeg","Media__ResourceRecordKey":"NST7944280","Media__ImageWidth":"1920","Media__ImageHeight":"1278","Media__ImageSizeDescription":"1920x1278","Media__MediaModificationTimestamp":"8/7/2026 2:44:25 PM","Media__MediaKey":"NST124115024","DocumentsChangeTimestamp":"2026-08-07T15:00:06.703Z","Rooms":"[{\"RoomDimensions\":\"13x12.5\",\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116538968\",\"RoomLevel\":\"Main\",\"RoomType\":\"Deck\"},{\"RoomDimensions\":\"7.5x9\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116538962\",\"RoomLevel\":\"Main\",\"RoomType\":\"Dining Room\"},{\"RoomDimensions\":\"15x12\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116538964\",\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom\"},{\"RoomDimensions\":\"8x9\",\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116538963\",\"RoomLevel\":\"Main\",\"RoomType\":\"Kitchen\"},{\"RoomDimensions\":\"38x24.5\",\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116538967\",\"RoomLevel\":\"Basement\",\"RoomType\":\"Laundry\"},{\"RoomDimensions\":\"11.5x11\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116538965\",\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom 2\"},{\"RoomDimensions\":\"14x11\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116538966\",\"RoomLevel\":\"Basement\",\"RoomType\":\"Bedroom 3\"}]","Rooms__RoomDimensions":"13x12.5","Rooms__NST_RoomSortOrder":"7","Rooms__RoomKey":"NST116538968","Rooms__RoomLevel":"Main","Rooms__RoomType":"Deck","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":10,\"Remarks\":\"Side entry\"},{\"Order\":12,\"Remarks\":\"Main level 1st bedroom\"},{\"Order\":13,\"Remarks\":\"Main level 2nd bedroom\"},{\"Order\":15,\"Remarks\":\"Main level 3/4 bedroom\"},{\"Order\":16,\"Remarks\":\"Basement 3rd bedroom\"},{\"Order\":17,\"Remarks\":\"Basement walk-in closet\"},{\"Order\":19,\"Remarks\":\"Basement storage/flex space\"},{\"Order\":20,\"Remarks\":\"Hot tub stays with the property\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22","CustomVTourURL":""}