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":1423248,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6806832","MLSAGENTID":"NST506094338","MLSOFFICEID":"NST10071","ADDRESS":"1501 Sherburne Avenue","ACRES":0.11,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full,Partially Finished","BATHSTOTAL":2.0,"BEDROOMS":4,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Metal Siding","FORECLOSURE":"No","LASTPRICE":299900.0,"LASTPRICEDATE":"2025-10-20T17:32:03.747","LATITUDE":44.956846,"LENDEROWNED":"No","LISTDATE":"2025-10-20T05:00:00","LISTPRICE":299900.0,"LIVINGAREA":1576.0,"LONGITUDE":-93.164053,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Some Trees","MODIFICATIONTIMESTAMP":"2025-10-21T18:55:04.805","NEIGHBORHOOD":"Hamline-Midway","OFFICE_OFFICENAME":"Keller Williams Integrity Realty","PHOTOCOUNT":16,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Step into this beautifully updated home, freshly renovated with brand-new flooring and a crisp coat of\npaint throughout. The spacious, light-filled living room offers the perfect setting for relaxing or\nentertaining. A dedicated dining room is conveniently located just off the kitchen, making meal times a\nbreeze.\n\nThe main floor also features a handy half bath for guests. Enjoy peace of mind with updated replacement windows throughout the home, ensuring energy efficiency and comfort year-round.\n\nStep outside to a charming rear porch and a fully fenced backyard — ideal for relaxing, gardening, or\nentertaining in privacy. Off street parking in the rear of the home. Located just a short walk from\nAllianz Field and the light rail, this home offers unbeatable access to shopping, dining, entertainment,\nand easy commuting.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-10-20T17:32:03.747","LASTSTATUS":"Active","STREETNAME":"Sherburne","STREETNUMBER":"1501","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1910,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2025-10-20T18:29:03.49","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Exterior Front.jpg\"},{\"Order\":2,\"Remarks\":\"Living Room.jpg\"},{\"Order\":3,\"Remarks\":\"Living Room.jpg\"},{\"Order\":4,\"Remarks\":\"Living Room.jpg\"},{\"Order\":5,\"Remarks\":\"Dining Room.jpg\"},{\"Order\":6,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":7,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":8,\"Remarks\":\"2nd Floor Primary Bedroom.jpg\"},{\"Order\":9,\"Remarks\":\"2nd Floor Primary Bedroom.jpg\"},{\"Order\":10,\"Remarks\":\"2nd Floor Primary Bathroom.jpg\"},{\"Order\":11,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":12,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":13,\"Remarks\":\"2nd Floor Office.jpg\"},{\"Order\":14,\"Remarks\":\"Lower Level Unfinished.jpg\"},{\"Order\":15,\"Remarks\":\"Backyard.jpg\"},{\"Order\":16,\"Remarks\":\"Exterior Rear.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","SOURCE":"MG_NST"}
{"ListingKey":"NST7817969","LotSizeArea":"0.11","NST_AgeOfProperty":"115","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Kitchen Window,Natural Woodwork,Porch,Washer/Dryer Hookup","Appliances":"Range,Refrigerator","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Full,Partially Finished","BasementYN":"True","NST_BathDesc":"Main Floor 1/2 Bath,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"4","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Informal Dining Room,Kitchen/Dining Room","Directions":"94 to Snelling north to Sherburne east to home","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Metal Siding","Fencing":"Privacy,Wood","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"872","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Natural Gas","ParkingFeatures":"Concrete","NST_GarageSquareFeet":"0","AccessibilityFeatures":"None","Heating":"Boiler,Hot Water,Radiator(s)","OriginalEntryTimestamp":"2025-10-20T17:29:49Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-10-21","Latitude":"44.956846","NST_LenderOwned":"No","ListAgentKey":"NST53356","ListAgentMlsId":"NST506094338","ListingContractDate":"2025-10-20T05:00:00Z","ListOfficeKey":"NST16710","ListOfficeName":"Keller Williams Integrity Realty","ListOfficeMlsId":"NST10071","ListPrice":"299900","LivingArea":"1576","Longitude":"-93.164053","LotFeatures":"Public Transit (w/in 6 blks),Some Trees","LotSizeDimensions":"40x124","LotSizeSquareFeet":"4922.28","LotSizeUnits":"Acres","ListingId":"NST6806832","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Hamline-Midway","NST_OfficeBoard":"SPAAR","ParcelNumber":"342923230116","GarageSpaces":"0","NST_ParkingOpen":"2","NST_PatioPorchType":"Rear Porch","PhotosCount":"16","PostalCity":"Saint Paul","PostalCode":"55104","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Step into this beautifully updated home, freshly renovated with brand-new flooring and a crisp coat of\npaint throughout. The spacious, light-filled living room offers the perfect setting for relaxing or\nentertaining. A dedicated dining room is conveniently located just off the kitchen, making meal times a\nbreeze.\n\nThe main floor also features a handy half bath for guests. Enjoy peace of mind with updated replacement windows throughout the home, ensuring energy efficiency and comfort year-round.\n\nStep outside to a charming rear porch and a fully fenced backyard — ideal for relaxing, gardening, or\nentertaining in privacy. Off street parking in the rear of the home. Located just a short walk from\nAllianz Field and the light rail, this home offers unbeatable access to shopping, dining, entertainment,\nand easy commuting.","PublicSurveyRange":"23","PublicSurveySection":"34","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","Roof":"Asphalt,Pitched","RoomType":"Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Kitchen,Living Room,Dining Room,Foyer","NST_AboveGradeSqFtTotal":"1376.0000","NST_BelowGradeSqFtTotal":"872.0000","NST_MainLevelFinishedArea":"872.0000","BuildingAreaTotal":"2248","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"Main Floor Laundry","AboveGradeFinishedArea":"1376","BelowGradeFinishedArea":"200","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Sherburne","StreetNumber":"1501","StreetNumberNumeric":"1501","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Lyman D Bairds Add","NST_TaxWithAssessments":"4148.0000","TaxYear":"2025","TaxAnnualAmount":"3932","WaterSource":"City Water/Connected","YearBuilt":"1910","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-10-21T18:55:04.805Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7817969\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Exterior Front.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817969/35316870-f193-4d0f-9771-f9658ea0aa75.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T17:45:32.484Z\",\"MediaKey\":\"68f6753c7156b81d2e8c0585\"},{\"ResourceRecordKey\":\"NST7817969\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Living Room.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817969/4e6f6e8f-7dc8-441c-8191-305371aded5f.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T17:45:32.473Z\",\"MediaKey\":\"68f6753c7156b81d2e8c0586\"},{\"ResourceRecordKey\":\"NST7817969\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Living Room.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817969/9bf19833-cf2b-423b-b57e-cecdad6176f1.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T17:45:32.473Z\",\"MediaKey\":\"68f6753c7156b81d2e8c0587\"},{\"ResourceRecordKey\":\"NST7817969\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Living Room.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817969/37f731a6-61d7-4d49-bf2b-3fc94c5be4fa.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T17:51:14.712Z\",\"MediaKey\":\"68f67692c00105734c07a4df\"},{\"ResourceRecordKey\":\"NST7817969\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Dining Room.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817969/32411cb8-32e8-4974-b19b-f9cd8da607c3.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T17:51:14.696Z\",\"MediaKey\":\"68f67692c00105734c07a4e0\"},{\"ResourceRecordKey\":\"NST7817969\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Kitchen.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817969/ab56dda7-79f4-43a3-b23e-08f5eda8a99c.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T17:51:14.702Z\",\"MediaKey\":\"68f67692c00105734c07a4e1\"},{\"ResourceRecordKey\":\"NST7817969\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Kitchen.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817969/5d61068f-2809-40e5-b8bc-7cfb7af05f27.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T17:52:29.507Z\",\"MediaKey\":\"68f676dd695ef37fcd030a9d\"},{\"ResourceRecordKey\":\"NST7817969\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"2nd Floor Primary Bedroom.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817969/3f4b2db7-d8c1-4405-a7ca-11824b58f280.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T17:52:29.511Z\",\"MediaKey\":\"68f676dd695ef37fcd030a9e\"},{\"ResourceRecordKey\":\"NST7817969\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"2nd Floor Primary Bedroom.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817969/05b89cef-052a-45d1-b8c0-48302df558b0.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T17:59:21.836Z\",\"MediaKey\":\"68f678797156b81d2e8c06e7\"},{\"ResourceRecordKey\":\"NST7817969\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"2nd Floor Primary Bathroom.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817969/45d959c4-a278-48fe-ad84-975cee7fee6b.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T17:59:21.831Z\",\"MediaKey\":\"68f678797156b81d2e8c06e8\"},{\"ResourceRecordKey\":\"NST7817969\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"2nd Floor Bedroom.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817969/57a30717-d0e7-47e5-a7a3-70ed2bf8f228.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T17:59:21.835Z\",\"MediaKey\":\"68f678797156b81d2e8c06e9\"},{\"ResourceRecordKey\":\"NST7817969\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"2nd Floor Bedroom.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817969/4e1c2ca6-7605-4e52-9724-9d646f6c3886.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T18:00:22.648Z\",\"MediaKey\":\"68f678b67156b81d2e8c0720\"},{\"ResourceRecordKey\":\"NST7817969\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"2nd Floor Office.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817969/f9f74718-9084-4917-98cb-3dd70c05385b.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T18:00:22.59Z\",\"MediaKey\":\"68f678b67156b81d2e8c0721\"},{\"ResourceRecordKey\":\"NST7817969\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"Lower Level Unfinished.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817969/b44ab696-27cf-4a00-b421-2913b94698e8.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T18:00:22.612Z\",\"MediaKey\":\"68f678b67156b81d2e8c0722\"},{\"ResourceRecordKey\":\"NST7817969\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"Backyard.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817969/ec7c8178-3b27-47e9-8426-05b51fb6fdda.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T18:27:19.495Z\",\"MediaKey\":\"68f67f078028067f6bcf2883\"},{\"ResourceRecordKey\":\"NST7817969\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"Exterior Rear.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817969/94e29878-9ebc-4985-bcf5-743b9631cc9c.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T18:27:19.516Z\",\"MediaKey\":\"68f67f078028067f6bcf2884\"}]","PhotosChangeTimestamp":"2025-10-20T18:29:03.49Z","Rooms":"[{\"RoomKey\":\"NST115715990\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115715991\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115715992\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13x8\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115715993\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13x7\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115715994\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115715995\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"20x19\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115715996\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x11\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115715997\",\"RoomType\":\"Foyer\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"4x6\",\"NST_RoomSortOrder\":\"8\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Exterior Front.jpg\"},{\"Order\":2,\"Remarks\":\"Living Room.jpg\"},{\"Order\":3,\"Remarks\":\"Living Room.jpg\"},{\"Order\":4,\"Remarks\":\"Living Room.jpg\"},{\"Order\":5,\"Remarks\":\"Dining Room.jpg\"},{\"Order\":6,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":7,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":8,\"Remarks\":\"2nd Floor Primary Bedroom.jpg\"},{\"Order\":9,\"Remarks\":\"2nd Floor Primary Bedroom.jpg\"},{\"Order\":10,\"Remarks\":\"2nd Floor Primary Bathroom.jpg\"},{\"Order\":11,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":12,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":13,\"Remarks\":\"2nd Floor Office.jpg\"},{\"Order\":14,\"Remarks\":\"Lower Level Unfinished.jpg\"},{\"Order\":15,\"Remarks\":\"Backyard.jpg\"},{\"Order\":16,\"Remarks\":\"Exterior Rear.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","CustomVTourURL":""}