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":554780,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7065389","MLSAGENTID":"NST502037589","MLSCOAGENTID":"NST506009225","MLSOFFICEID":"NST7855","ADDRESS":"407 Osceola Avenue S","ACRES":0.2376,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full,Storage Space,Unfinished","BATHSTOTAL":3.0,"BEDROOMS":4.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Stone","FORECLOSURE":"No","LASTPRICE":399900.0,"LASTPRICEDATE":"2026-05-09T11:16:06.663","LATITUDE":44.928873,"LENDEROWNED":"No","LISTDATE":"2026-05-09T05:00:00","LISTPRICE":399900.0,"LIVINGAREA":1792.0,"LONGITUDE":-93.128572,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-05-09T19:01:08.504","NEIGHBORHOOD":"103","OFFICE_OFFICENAME":"RE/MAX Results","OUTBUILDINGS":"Garage(s),Storage Shed","PHOTOCOUNT":1,"POSTALCODE":"55102","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Exceptional St. Paul two-story, lovingly owned by the same family for 57 years. A spacious, sun-filled front porch welcomes you—perfect for relaxing on quiet days. Inside, you’ll find beautiful original woodwork, a cozy fireplace with a new chimney liner, and gorgeous hardwood floors that add warmth and character throughout. The spacious dining room is ideal for family gatherings and entertaining.\nThe great kitchen features a new cooktop stove, stainless steel appliances, and charming original maple cabinets—blending modern convenience with timeless character.\nSituated on a rare double lot with a fully fenced yard, this property offers both space and privacy. The upper level features four bedrooms, including a unique fourth bedroom with walkout access to a private porch—perfect for a peaceful retreat or morning coffee.\nAdditional highlights include a double garage, a great storage shed, inground sprinkler and quick close possible. A wonderful opportunity to own a well-cared-for home full of charm, history, and potential","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-05-09T11:16:06.663","LASTSTATUS":"Active","STREETDIRSUFFIX":"S","STREETNAME":"Osceola","STREETNUMBER":"407","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1923,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-05-09T11:16:06.664","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"front.jpg\"}]","PHOTOORDER":"1","SOURCE":"MG_NST"}
{"ListingKey":"NST7894067","NST_AboveGradeSqFtTotal":"1792","AboveGradeFinishedArea":"1792","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","Appliances":"Cooktop,Dishwasher,Dryer,Exhaust Fan,Water Filtration System,Range,Refrigerator,Stainless Steel Appliances,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Full,Storage Space,Unfinished","BasementYN":"True","NST_BathDesc":"1/2 Basement,Basement,Upper Level Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"1","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"856","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","ConstructionMaterials":"Stone","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Separate/Formal Dining Room","Directions":"St. Claire to Osceola, turn right to 407","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-05-09T11:16:06.664Z","DaysOnMarket":"0","Electric":"Circuit Breakers","Fencing":"Privacy","FireplaceFeatures":"Brick,Living Room,Wood Burning","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"856","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"484","GarageSpaces":"2","Heating":"Boiler","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.928873","LaundryFeatures":"In Basement","NST_LenderOwned":"No","Levels":"Two","ListPrice":"399900","ListingContractDate":"2026-05-09T05:00:00Z","ListingId":"NST7065389","LivingArea":"1792","LockBoxType":"Combo","Longitude":"-93.128572","LotFeatures":"Public Transit (w/in 6 blks),Tree Coverage - Light","LotSizeArea":"10350","LotSizeDimensions":"90x115","LotSizeUnits":"Square Feet","NST_MainLevelFinishedArea":"936","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"103","OriginalEntryTimestamp":"2026-05-09T06:15:54Z","OtherStructures":"Garage(s),Storage Shed","ParcelNumber":"112823140182","ParkingFeatures":"Detached Garage","NST_PatioPorchType":"Front Porch,Other","PhotosCount":"1","PostalCity":"Saint Paul","PostalCode":"55102","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Exceptional St. Paul two-story, lovingly owned by the same family for 57 years. A spacious, sun-filled front porch welcomes you—perfect for relaxing on quiet days. Inside, you’ll find beautiful original woodwork, a cozy fireplace with a new chimney liner, and gorgeous hardwood floors that add warmth and character throughout. The spacious dining room is ideal for family gatherings and entertaining.\nThe great kitchen features a new cooktop stove, stainless steel appliances, and charming original maple cabinets—blending modern convenience with timeless character.\nSituated on a rare double lot with a fully fenced yard, this property offers both space and privacy. The upper level features four bedrooms, including a unique fourth bedroom with walkout access to a private porch—perfect for a peaceful retreat or morning coffee.\nAdditional highlights include a double garage, a great storage shed, inground sprinkler and quick close possible. A wonderful opportunity to own a well-cared-for home full of charm, history, and potential","PublicSurveyRange":"23","PublicSurveySection":"11","PublicSurveyTownship":"28","RoadFrontageType":"City Street","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"S","StreetName":"Osceola","StreetNumber":"407","StreetNumberNumeric":"407","StreetSuffix":"Avenue","SubdivisionName":"A Vance Browns Sub","TaxAnnualAmount":"5866","NST_TaxWithAssessments":"5866","TaxYear":"2025","BuildingAreaTotal":"2648","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1923","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST99103","CoListAgentMlsId":"NST506009225","CoListOfficeName":"RE/MAX Results","ListAgentKey":"NST87628","ListAgentMlsId":"NST502037589","ListOfficeMlsId":"NST7855","ListOfficeName":"RE/MAX Results","ListOfficeKey":"NST17994","ModificationTimestamp":"2026-05-09T19:01:08.504Z","PhotosChangeTimestamp":"2026-05-09T11:16:06.664Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7894067/cceeb8f8-c2b7-4878-9fce-422c10ef93f3.jpeg\",\"LongDescription\":\"front.jpg\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7894067\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaModificationTimestamp\":\"2026-05-09T11:16:03.637Z\",\"MediaKey\":\"NST122106058\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7894067/cceeb8f8-c2b7-4878-9fce-422c10ef93f3.jpeg","Media__LongDescription":"front.jpg","Media__Order":"1","Media__MediaObjectID":"NST1","Media__ResourceRecordKey":"NST7894067","Media__ImageWidth":"640","Media__ImageHeight":"480","Media__ImageSizeDescription":"640x480","Media__MediaModificationTimestamp":"5/9/2026 11:16:03 AM","Media__MediaKey":"NST122106058","Rooms":"[{\"RoomLevel\":\"Main\",\"RoomType\":\"Dining Room\",\"RoomDimensions\":\"13x13\",\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116202073\"},{\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom\",\"RoomDimensions\":\"10x11\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116202075\"},{\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom 4\",\"RoomDimensions\":\"10x9\",\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116202078\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Kitchen\",\"RoomDimensions\":\"13x9\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116202074\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Living Room\",\"RoomDimensions\":\"26x13\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116202072\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Porch\",\"RoomDimensions\":\"10x8\",\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116202079\"},{\"RoomLevel\":\"Upper\",\"RoomType\":\"Porch\",\"RoomDimensions\":\"11x6\",\"NST_RoomSortOrder\":9,\"RoomKey\":\"NST116202080\"},{\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom 2\",\"RoomDimensions\":\"11x13\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116202076\"},{\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom 3\",\"RoomDimensions\":\"10x12\",\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116202077\"}]","Rooms__RoomLevel":"Main","Rooms__RoomType":"Dining Room","Rooms__RoomDimensions":"13x13","Rooms__NST_RoomSortOrder":"2","Rooms__RoomKey":"NST116202073","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"front.jpg\"}]","PhotoOrder":"1","CustomVTourURL":""}