Bay Lake Realty
Bruce Johnson
Broker/Owner
Bay Lake Realty is Licensed in the State of Minnesota
15929 Wakeman Rd.
Deerwood, MN 56444
Cell Phone: 218-838-1111
E-mail: bruce@baylakerealty.com
{"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-15T10:08:08.242","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-15T03:00:04.736","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","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","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-15","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-15T10:08:08.242Z","PhotosChangeTimestamp":"2025-08-15T03:00:04.736Z","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/b01399d6-0bd8-4a8c-a091-044efd5cf690.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.607Z\",\"MediaKey\":\"689ea2af7491057f2980b444\"},{\"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/9c274a98-0c99-4373-8103-828cc4e55998.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.531Z\",\"MediaKey\":\"689ea2af7491057f2980b445\"},{\"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/5afb5907-bf5c-4e1f-83a0-d5d85c8cdc06.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.583Z\",\"MediaKey\":\"689ea2af7491057f2980b446\"},{\"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/a89d5fe3-b038-4c94-a931-196c1c546db8.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.606Z\",\"MediaKey\":\"689ea2af7491057f2980b447\"},{\"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/18b6ef27-71bc-442a-b864-2acf9ed9751e.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.585Z\",\"MediaKey\":\"689ea2af7491057f2980b448\"},{\"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/6a6e7622-8206-424e-9481-4ce07bf90e8a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.574Z\",\"MediaKey\":\"689ea2af7491057f2980b449\"},{\"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/8a015438-1039-4d10-9803-69a5a7e121d3.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.554Z\",\"MediaKey\":\"689ea2af7491057f2980b44a\"},{\"ResourceRecordKey\":\"NST7787643\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"8_Nordy.jpeg\",\"ImageWidth\":2045,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2045x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7787643/025bfae6-91bf-4721-962b-51af333af4f4.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.574Z\",\"MediaKey\":\"689ea2af7491057f2980b44b\"},{\"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/325053a8-48b0-4f35-8276-e6b61b269b2f.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.576Z\",\"MediaKey\":\"689ea2af7491057f2980b44c\"},{\"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/2f25015b-c965-4d36-8fd5-603b8cc3f441.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.571Z\",\"MediaKey\":\"689ea2af7491057f2980b44d\"},{\"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/ff91ed40-e265-4d55-af0f-495b7b74233d.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.555Z\",\"MediaKey\":\"689ea2af7491057f2980b44e\"},{\"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/c290eea5-5fa9-41eb-85d9-c961b828e046.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.606Z\",\"MediaKey\":\"689ea2af7491057f2980b44f\"},{\"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/a2521fe7-9c66-4ff9-a9a3-21d7ee7dd0be.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.594Z\",\"MediaKey\":\"689ea2af7491057f2980b450\"},{\"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/6259888e-d3e8-4bff-b9c0-ebf19364b8eb.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.584Z\",\"MediaKey\":\"689ea2af7491057f2980b451\"},{\"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/cd5f4dcc-5c8b-4450-9a4e-9cd6407ff432.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.518Z\",\"MediaKey\":\"689ea2af7491057f2980b452\"},{\"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/45555e3a-cacc-4dd3-b5e7-a8bdee8a9a04.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.522Z\",\"MediaKey\":\"689ea2af7491057f2980b453\"},{\"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/239d6da2-1540-4b73-9e50-874bf8190394.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.522Z\",\"MediaKey\":\"689ea2af7491057f2980b454\"},{\"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/7d4503ef-5375-4157-8dbc-2dd3ad0ecf4d.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T02:59:59.517Z\",\"MediaKey\":\"689ea2af7491057f2980b455\"}]","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":""}