{"Id":1395753,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6771797","MLSAGENTID":"NST502054618","MLSOFFICEID":"NST41150","ADDRESS":"1806 Sherwood Avenue","ACRES":0.23,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full","BATHSTOTAL":1.0,"BEDROOMS":4,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Wood Siding","FORECLOSURE":"No","LASTPRICE":209900.0,"LASTPRICEDATE":"2025-08-14T16:18:03.89","LATITUDE":44.983561,"LENDEROWNED":"No","LISTDATE":"2025-08-14T05:00:00","LISTPRICE":209900.0,"LIVINGAREA":1242.0,"LONGITUDE":-93.023947,"MODIFICATIONTIMESTAMP":"2025-08-14T16:18:03.889","NEIGHBORHOOD":"Greater East Side","OFFICE_OFFICENAME":"HOMESTEAD ROAD","PHOTOCOUNT":18,"POSTALCODE":"55119","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Opportunity awaits in this 4 bedroom, 1 bath home with a 2 stall garage and a fully fenced yard. Whether you're an investor looking to expand your portfolio or a DIY enthusiast ready to bring your vision to life, this property offers great potential. With ample living space and solid bones, it's a fantastic canvas for updates and personalization. Located in a convenient area, this home is perfect for those looking to build equity through renovation or create a customized living space.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-14T16:18:03.89","LASTSTATUS":"Active","STREETNAME":"Sherwood","STREETNUMBER":"1806","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1917,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-08-14T16:18:03.889","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1_Nordy (6).jpeg\"},{\"Order\":2,\"Remarks\":\"23_Nordy (26).jpeg\"},{\"Order\":3,\"Remarks\":\"19_Nordy (17).jpeg\"},{\"Order\":4,\"Remarks\":\"18_Nordy (12).jpeg\"},{\"Order\":5,\"Remarks\":\"21_Nordy (23).jpeg\"},{\"Order\":6,\"Remarks\":\"16_Nordy (5).jpeg\"},{\"Order\":7,\"Remarks\":\"6_Nordy (3).jpeg\"},{\"Order\":8,\"Remarks\":\"8_Nordy.jpeg\"},{\"Order\":9,\"Remarks\":\"9_Nordy (1).jpeg\"},{\"Order\":10,\"Remarks\":\"11_Nordy (13).jpeg\"},{\"Order\":11,\"Remarks\":\"20_Nordy (20).jpeg\"},{\"Order\":12,\"Remarks\":\"4_Nordy (10).jpeg\"},{\"Order\":13,\"Remarks\":\"28_Nordy (27).jpeg\"},{\"Order\":14,\"Remarks\":\"24_Nordy (22).jpeg\"},{\"Order\":15,\"Remarks\":\"1st_floor_1806_sherwood_avenue_saint_paul_without_dim.jpg\"},{\"Order\":16,\"Remarks\":\"2nd_floor_1806_sherwood_avenue_saint_paul_without_dim.jpg\"},{\"Order\":17,\"Remarks\":\"3rd_floor_1806_sherwood_avenue_saint_paul_without_dim.jpg\"},{\"Order\":18,\"Remarks\":\"all_floors_1806_sherwood_avenue_saint_paul_without_dim.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}
{"ListingKey":"NST7787643","LotSizeArea":"0.23","NST_AgeOfProperty":"108","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Full","BasementYN":"True","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"4","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","Directions":"White Bear to Sherwood East to home","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Wood Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"705","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached","NST_GarageSquareFeet":"400","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-08-14T16:15:35Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-14","Latitude":"44.983561","NST_LenderOwned":"No","ListAgentKey":"NST520774","ListAgentMlsId":"NST502054618","ListingContractDate":"2025-08-14T05:00:00Z","ListOfficeKey":"NST21187","ListOfficeName":"HOMESTEAD ROAD","ListOfficeMlsId":"NST41150","ListPrice":"209900","LivingArea":"1242","Longitude":"-93.023947","LotSizeDimensions":"80'x126'x80'x126'","LotSizeSquareFeet":"10062.36","LotSizeUnits":"Acres","ListingId":"NST6771797","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Greater East Side","NST_OfficeBoard":"MAAR","ParcelNumber":"232922320077","GarageSpaces":"2","PhotosCount":"18","PostalCity":"Saint Paul","PostalCode":"55119","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Opportunity awaits in this 4 bedroom, 1 bath home with a 2 stall garage and a fully fenced yard. Whether you're an investor looking to expand your portfolio or a DIY enthusiast ready to bring your vision to life, this property offers great potential. With ample living space and solid bones, it's a fantastic canvas for updates and personalization. Located in a convenient area, this home is perfect for those looking to build equity through renovation or create a customized living space.","PublicSurveyRange":"22","PublicSurveySection":"23","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bathroom","NST_AboveGradeSqFtTotal":"1242.0000","NST_BelowGradeSqFtTotal":"599.0000","NST_MainLevelFinishedArea":"705.0000","BuildingAreaTotal":"1841","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level","AboveGradeFinishedArea":"1242","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Sherwood","StreetNumber":"1806","StreetNumberNumeric":"1806","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Hayden Heights","NST_TaxWithAssessments":"3648.0000","TaxYear":"2025","TaxAnnualAmount":"3648","WaterSource":"City Water/Connected","YearBuilt":"1917","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-08-14T16:18:03.889Z","PhotosChangeTimestamp":"2025-08-14T16:18:03.889Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7787643\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"1_Nordy (6).jpeg\",\"ImageWidth\":2046,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2046x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/f05f680f-234c-4d0f-9cc4-3ff41716bb15.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.51Z\",\"MediaKey\":\"689e0c2418eaa74b07a10268\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"23_Nordy (26).jpeg\",\"ImageWidth\":2046,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2046x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/246207b0-ad18-44c3-946d-8b58f273f4db.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.413Z\",\"MediaKey\":\"689e0c2418eaa74b07a10269\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"19_Nordy (17).jpeg\",\"ImageWidth\":2046,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2046x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/4696c8e6-39d4-43ba-8c63-cef375bd6c1a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.473Z\",\"MediaKey\":\"689e0c2418eaa74b07a1026a\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"18_Nordy (12).jpeg\",\"ImageWidth\":2045,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2045x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/85f6c234-33c6-4e34-906d-ee0cb5cf501b.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.412Z\",\"MediaKey\":\"689e0c2418eaa74b07a1026b\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"21_Nordy (23).jpeg\",\"ImageWidth\":2046,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2046x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/d5a5669d-e69c-4824-a05f-bf61751d4d75.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.46Z\",\"MediaKey\":\"689e0c2418eaa74b07a1026c\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"16_Nordy (5).jpeg\",\"ImageWidth\":2046,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2046x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/cec6643b-00ca-4460-95b1-feafa5b3791d.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.46Z\",\"MediaKey\":\"689e0c2418eaa74b07a1026d\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"6_Nordy (3).jpeg\",\"ImageWidth\":2045,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2045x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/7aca208d-7421-4bdd-9b3d-961e851aa3b5.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.437Z\",\"MediaKey\":\"689e0c2418eaa74b07a1026e\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"8_Nordy.jpeg\",\"ImageWidth\":2045,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2045x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/219d55c4-c24c-469b-8af7-7c91d7c61c42.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.462Z\",\"MediaKey\":\"689e0c2418eaa74b07a1026f\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"9_Nordy (1).jpeg\",\"ImageWidth\":2045,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2045x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/96f1d358-b8f1-4bed-82b7-673509ac2acd.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.437Z\",\"MediaKey\":\"689e0c2418eaa74b07a10270\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"11_Nordy (13).jpeg\",\"ImageWidth\":2046,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2046x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/90df544c-81d1-4e12-a29c-6dbafb093c61.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.448Z\",\"MediaKey\":\"689e0c2418eaa74b07a10271\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"20_Nordy (20).jpeg\",\"ImageWidth\":2046,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2046x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/0b6ac16e-897f-40bb-a2c1-ee96bb041e70.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.498Z\",\"MediaKey\":\"689e0c2418eaa74b07a10272\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"4_Nordy (10).jpeg\",\"ImageWidth\":2046,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2046x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/d4ea0677-5d94-48ea-8ffc-bfe66f10a877.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.412Z\",\"MediaKey\":\"689e0c2418eaa74b07a10273\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"28_Nordy (27).jpeg\",\"ImageWidth\":2046,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2046x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/049665bf-432f-4b00-ab2c-c8f14714f186.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.433Z\",\"MediaKey\":\"689e0c2418eaa74b07a10274\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"24_Nordy (22).jpeg\",\"ImageWidth\":2046,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2046x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/0e27ecd0-c919-4e17-bfd1-705f945fe2b5.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.53Z\",\"MediaKey\":\"689e0c2418eaa74b07a10275\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"1st_floor_1806_sherwood_avenue_saint_paul_without_dim.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/9d70f6b7-e245-465b-bd75-85a9e2b8f0a7.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.433Z\",\"MediaKey\":\"689e0c2418eaa74b07a10276\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"2nd_floor_1806_sherwood_avenue_saint_paul_without_dim.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/f9eb5eb3-0b0a-4669-8660-51bad1100b83.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.432Z\",\"MediaKey\":\"689e0c2418eaa74b07a10277\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"3rd_floor_1806_sherwood_avenue_saint_paul_without_dim.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/7f18962d-123f-42f4-ae9d-a144ec90c848.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.43Z\",\"MediaKey\":\"689e0c2418eaa74b07a10278\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":18,\"MediaObjectID\":\"18\",\"LongDescription\":\"all_floors_1806_sherwood_avenue_saint_paul_without_dim.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/48abe13e-308f-40bf-b324-f6543531ac47.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T16:17:40.413Z\",\"MediaKey\":\"689e0c2418eaa74b07a10279\"}]","Rooms":"[{\"RoomKey\":\"NST115514544\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115514545\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115514546\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115514547\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115514548\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115514549\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115514550\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":\"7\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1_Nordy (6).jpeg\"},{\"Order\":2,\"Remarks\":\"23_Nordy (26).jpeg\"},{\"Order\":3,\"Remarks\":\"19_Nordy (17).jpeg\"},{\"Order\":4,\"Remarks\":\"18_Nordy (12).jpeg\"},{\"Order\":5,\"Remarks\":\"21_Nordy (23).jpeg\"},{\"Order\":6,\"Remarks\":\"16_Nordy (5).jpeg\"},{\"Order\":7,\"Remarks\":\"6_Nordy (3).jpeg\"},{\"Order\":8,\"Remarks\":\"8_Nordy.jpeg\"},{\"Order\":9,\"Remarks\":\"9_Nordy (1).jpeg\"},{\"Order\":10,\"Remarks\":\"11_Nordy (13).jpeg\"},{\"Order\":11,\"Remarks\":\"20_Nordy (20).jpeg\"},{\"Order\":12,\"Remarks\":\"4_Nordy (10).jpeg\"},{\"Order\":13,\"Remarks\":\"28_Nordy (27).jpeg\"},{\"Order\":14,\"Remarks\":\"24_Nordy (22).jpeg\"},{\"Order\":15,\"Remarks\":\"1st_floor_1806_sherwood_avenue_saint_paul_without_dim.jpg\"},{\"Order\":16,\"Remarks\":\"2nd_floor_1806_sherwood_avenue_saint_paul_without_dim.jpg\"},{\"Order\":17,\"Remarks\":\"3rd_floor_1806_sherwood_avenue_saint_paul_without_dim.jpg\"},{\"Order\":18,\"Remarks\":\"all_floors_1806_sherwood_avenue_saint_paul_without_dim.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","CustomVTourURL":""}