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":507567,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7004501","MLSAGENTID":"NST506021048","MLSOFFICEID":"NST26348","ADDRESS":"1428 Sherburne Avenue","ACRES":0.091,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full","BATHSTOTAL":2.0,"BEDROOMS":5,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":249000.0,"LASTPRICEDATE":"2026-01-04T17:39:05.867","LATITUDE":44.956376,"LENDEROWNED":"No","LISTDATE":"2026-01-04T06:00:00","LISTPRICE":249000.0,"LIVINGAREA":1630.0,"LONGITUDE":-93.160634,"MODIFICATIONTIMESTAMP":"2026-01-06T15:22:06.19","NEIGHBORHOOD":"93","OFFICE_OFFICENAME":"Partners Realty Inc.","PHOTOCOUNT":11,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Large 2 story home located in prime Hamline Midway area. Steps to light rail, shopping and multiple parks and Universities. Large kitchen with main floor bedroom and bathroom. . Hardwood floors on main level. Large front porch. Room for expansion in the basement.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-01-04T17:39:05.867","LASTSTATUS":"Active","STREETNAME":"Sherburne","STREETNUMBER":"1428","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1913,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-01-06T15:22:06.19","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1428. Kitchen.jpg\"},{\"Order\":2,\"Remarks\":\"Kitchen 2.jpg\"},{\"Order\":3,\"Remarks\":\"living 2.jpg\"},{\"Order\":4,\"Remarks\":\"livingroom.jpg\"},{\"Order\":5,\"Remarks\":\"Bath2.jpg\"},{\"Order\":6,\"Remarks\":\"Bath 1.jpg\"},{\"Order\":7,\"Remarks\":\"Stair.jpg\"},{\"Order\":8,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":9,\"Remarks\":\"basement.jpg\"},{\"Order\":10,\"Remarks\":\"Back of house.jpg\"},{\"Order\":11,\"Remarks\":\"front house.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11","SOURCE":"MG_NST"}
{"ListingKey":"NST7839130","NST_AboveGradeSqFtTotal":"826","AboveGradeFinishedArea":"810","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Full","BasementYN":"True","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"5","NST_BelowGradeSqFtTotal":"820","BelowGradeFinishedArea":"820","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"UNIVERSITY AVE TO ALBERT, N ONE BLOCK TO SHERBURNE","DocumentsCount":"0","DaysOnMarket":"0","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"826","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","GarageSpaces":"0","Heating":"Baseboard","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.956376","NST_LenderOwned":"No","Levels":"Two","ListPrice":"249000","ListingContractDate":"2026-01-04T06:00:00Z","ListingId":"NST7004501","LivingArea":"1630","LockBoxType":"Combo","Longitude":"-93.160634","LotSizeArea":"0.091","LotSizeDimensions":"40x100","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"810","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"93","OriginalEntryTimestamp":"2026-01-04T11:38:35Z","ParcelNumber":"342923240207","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"On-Street Parking Only","PhotosCount":"11","PhotosChangeTimestamp":"2026-01-06T15:22:06.19Z","PostalCity":"Saint Paul","PostalCode":"55104","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","PublicRemarks":"Large 2 story home located in prime Hamline Midway area. Steps to light rail, shopping and multiple parks and Universities. Large kitchen with main floor bedroom and bathroom. . Hardwood floors on main level. Large front porch. Room for expansion in the basement.","PublicSurveyRange":"23","PublicSurveySection":"34","PublicSurveyTownship":"29","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Sherburne","StreetNumber":"1428","StreetNumberNumeric":"1428","StreetSuffix":"Avenue","SubdivisionName":"Syndicate 5 Add","TaxAnnualAmount":"4890","NST_TaxWithAssessments":"4890","TaxYear":"2025","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1913","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST520685","ListAgentMlsId":"NST506021048","ListOfficeMlsId":"NST26348","ListOfficeName":"Partners Realty Inc.","ListOfficeKey":"NST26348","ModificationTimestamp":"2026-01-06T15:22:06.19Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7839130\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839130/d91eff11-9fe8-4c6b-980f-b2c9edb8d47c.jpeg\",\"LongDescription\":\"Stair.jpg\",\"ImageWidth\":1280,\"ImageHeight\":1707,\"ImageSizeDescription\":\"1280x1707\",\"MediaModificationTimestamp\":\"2026-01-04T18:11:07.899Z\",\"MediaKey\":\"NST120029295\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7839130\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839130/be2963fc-34cc-461c-90cc-c5c970c503d4.jpeg\",\"LongDescription\":\"livingroom.jpg\",\"ImageWidth\":1280,\"ImageHeight\":1707,\"ImageSizeDescription\":\"1280x1707\",\"MediaModificationTimestamp\":\"2026-01-04T18:11:07.922Z\",\"MediaKey\":\"NST120029296\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7839130\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839130/39b0f5fb-e953-4de7-b93b-d0f517121300.jpeg\",\"LongDescription\":\"Bath2.jpg\",\"ImageWidth\":1280,\"ImageHeight\":1707,\"ImageSizeDescription\":\"1280x1707\",\"MediaModificationTimestamp\":\"2026-01-04T18:11:07.926Z\",\"MediaKey\":\"NST120029293\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7839130\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839130/5aead5bb-8627-4a32-b155-96bdd51c1995.jpeg\",\"LongDescription\":\"front house.jpg\",\"ImageWidth\":1280,\"ImageHeight\":1707,\"ImageSizeDescription\":\"1280x1707\",\"MediaModificationTimestamp\":\"2026-01-06T15:21:56.284Z\",\"MediaKey\":\"NST120029417\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7839130\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839130/b2b6008a-6b9b-477d-8500-6df72f07447b.jpeg\",\"LongDescription\":\"basement.jpg\",\"ImageWidth\":1280,\"ImageHeight\":1707,\"ImageSizeDescription\":\"1280x1707\",\"MediaModificationTimestamp\":\"2026-01-06T15:21:56.286Z\",\"MediaKey\":\"NST120029419\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7839130\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839130/2fe7465f-2672-483e-ab44-4e5969bfec8a.jpeg\",\"LongDescription\":\"Kitchen 2.jpg\",\"ImageWidth\":1280,\"ImageHeight\":1707,\"ImageSizeDescription\":\"1280x1707\",\"MediaModificationTimestamp\":\"2026-01-04T18:11:07.91Z\",\"MediaKey\":\"NST120029291\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7839130\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839130/df5c0a72-0d5c-41b1-b6ec-1688fa4d268c.jpeg\",\"LongDescription\":\"Back of house.jpg\",\"ImageWidth\":1280,\"ImageHeight\":1707,\"ImageSizeDescription\":\"1280x1707\",\"MediaModificationTimestamp\":\"2026-01-06T15:21:56.344Z\",\"MediaKey\":\"NST120029418\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7839130\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839130/25f6cfc6-01a8-49c9-abf2-d9ba68407c6b.jpeg\",\"LongDescription\":\"1428. Kitchen.jpg\",\"ImageWidth\":1280,\"ImageHeight\":1707,\"ImageSizeDescription\":\"1280x1707\",\"MediaModificationTimestamp\":\"2026-01-04T18:11:07.916Z\",\"MediaKey\":\"NST120029298\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7839130\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839130/b69b1bc4-ed54-4ce8-8739-051da8973633.jpeg\",\"LongDescription\":\"Bedroom.jpg\",\"ImageWidth\":1280,\"ImageHeight\":1707,\"ImageSizeDescription\":\"1280x1707\",\"MediaModificationTimestamp\":\"2026-01-04T18:11:07.943Z\",\"MediaKey\":\"NST120029294\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7839130\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839130/85f4fba7-c14d-4c82-af1b-d8777194498c.jpeg\",\"LongDescription\":\"Bath 1.jpg\",\"ImageWidth\":1280,\"ImageHeight\":1707,\"ImageSizeDescription\":\"1280x1707\",\"MediaModificationTimestamp\":\"2026-01-04T18:11:07.921Z\",\"MediaKey\":\"NST120029292\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7839130\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839130/5026056c-c142-454f-95e9-867129acefb6.jpeg\",\"LongDescription\":\"living 2.jpg\",\"ImageWidth\":1280,\"ImageHeight\":1707,\"ImageSizeDescription\":\"1280x1707\",\"MediaModificationTimestamp\":\"2026-01-04T18:11:07.908Z\",\"MediaKey\":\"NST120029297\"}]","Media__Order":"7","Media__MediaObjectID":"NST7","Media__ResourceRecordKey":"NST7839130","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7839130/d91eff11-9fe8-4c6b-980f-b2c9edb8d47c.jpeg","Media__LongDescription":"Stair.jpg","Media__ImageWidth":"1280","Media__ImageHeight":"1707","Media__ImageSizeDescription":"1280x1707","Media__MediaModificationTimestamp":"1/4/2026 6:11:07 PM","Media__MediaKey":"NST120029295","DocumentsChangeTimestamp":"2026-01-04T17:39:05.868Z","Rooms":"[{\"RoomKey\":\"NST115846782\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x13\"},{\"RoomKey\":\"NST115846784\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x11\"},{\"RoomKey\":\"NST115846787\",\"NST_RoomSortOrder\":7,\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x9\"},{\"RoomKey\":\"NST115846783\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"17x11\"},{\"RoomKey\":\"NST115846781\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x12\"},{\"RoomKey\":\"NST115846785\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x11\"},{\"RoomKey\":\"NST115846786\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x11\"}]","Rooms__RoomKey":"NST115846782","Rooms__NST_RoomSortOrder":"2","Rooms__RoomType":"Dining Room","Rooms__RoomLevel":"Main","Rooms__RoomDimensions":"13x13","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1428. Kitchen.jpg\"},{\"Order\":2,\"Remarks\":\"Kitchen 2.jpg\"},{\"Order\":3,\"Remarks\":\"living 2.jpg\"},{\"Order\":4,\"Remarks\":\"livingroom.jpg\"},{\"Order\":5,\"Remarks\":\"Bath2.jpg\"},{\"Order\":6,\"Remarks\":\"Bath 1.jpg\"},{\"Order\":7,\"Remarks\":\"Stair.jpg\"},{\"Order\":8,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":9,\"Remarks\":\"basement.jpg\"},{\"Order\":10,\"Remarks\":\"Back of house.jpg\"},{\"Order\":11,\"Remarks\":\"front house.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11","CustomVTourURL":""}