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":534505,"ORGTABLE":"RAW_Property","MLSCLASS":"RNT","MLSNUMBER":"NST7022052","MLSAGENTID":"NST506018808","MLSOFFICEID":"NST9990","ADDRESS":"246 Sidney Street E","ACRES":0.112,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Unfinished","BATHSTOTAL":2.0,"BEDROOMS":3.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":2700.0,"LASTPRICEDATE":"2026-03-29T16:59:05.04","LATITUDE":44.923717,"LENDEROWNED":"No","LISTDATE":"2026-02-16T06:00:00","LISTPRICE":2700.0,"LIVINGAREA":1400.0,"LONGITUDE":-93.07541,"MODIFICATIONTIMESTAMP":"2026-03-29T16:59:05.041","NEIGHBORHOOD":"104","OFFICE_OFFICENAME":"Northstar Real Estate Associates","PHOTOCOUNT":14,"POSTALCODE":"55107","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Come check out this charming 3-bedroom, 1.5-bath home offers comfortable living with plenty of space to relax and entertain. Enjoy a functional layout filled with natural light, plus the added convenience of a half bath for guests on the main floor and a beautiful 3 seasons enclosed front porch. A great opportunity in a prime Saint Paul location—schedule your showing today! Section 8 allowed!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-03-29T16:59:05.04","LASTSTATUS":"Active","STREETNAME":"Sidney Street E","STREETNUMBER":"246","STYLE":"Single Family","TRANSACTIONTYPE":"For Rent","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1889,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-02-16T20:17:05.071","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"FullSizeRender (6).jpg\"},{\"Order\":2,\"Remarks\":\"FullSizeRender (7).jpg\"},{\"Order\":3,\"Remarks\":\"FullSizeRender (8).jpg\"},{\"Order\":4,\"Remarks\":\"FullSizeRender (3).jpg\"},{\"Order\":5,\"Remarks\":\"FullSizeRender.jpg\"},{\"Order\":6,\"Remarks\":\"FullSizeRender (1).jpg\"},{\"Order\":7,\"Remarks\":\"FullSizeRender (2).jpg\"},{\"Order\":8,\"Remarks\":\"FullSizeRender.heic.JPEG\"},{\"Order\":9,\"Remarks\":\"FullSizeRender (4).jpg\"},{\"Order\":10,\"Remarks\":\"FullSizeRender (5).jpg\"},{\"Order\":11,\"Remarks\":\"FullSizeRender (12).jpg\"},{\"Order\":12,\"Remarks\":\"FullSizeRender (11).jpg\"},{\"Order\":13,\"Remarks\":\"FullSizeRender (9).jpg\"},{\"Order\":14,\"Remarks\":\"FullSizeRender (13).jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","SOURCE":"MG_NST"}
{"ListingKey":"NST7854180","NST_AboveGradeSqFtTotal":"1400","AboveGradeFinishedArea":"1400","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"Yes","Appliances":"Dishwasher,Refrigerator,Stainless Steel Appliances","NST_ApplicationFee":"50","LivingAreaUnits":"Square Feet","AssociationYN":"False","AssociationFee":"0","AvailabilityDate":"2026-02-16T06:00:00Z","NST_BackgroundCheckReq":"Y","Basement":"Daylight/Lookout Windows,Unfinished","BasementYN":"True","NST_BathDesc":"Main Floor 1/2 Bath,Upper Level Full Bath","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"25","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","Directions":"Robert Street to Sidney Street, East to home.","DocumentsCount":"0","DaysOnMarket":"25","FireplaceYN":"False","FireplacesTotal":"0","NST_ForSaleMLNumber":"7021944","FoundationArea":"700","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","Furnished":"Unfurnished","NST_GarageSquareFeet":"440","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.923717","LaundryFeatures":"In Basement","NST_LeasePrice":"2700","NST_LenderOwned":"No","Levels":"Two","ListingContractDate":"2026-02-16T06:00:00Z","ListingId":"NST7022052","LivingArea":"1400","Longitude":"-93.07541","LotSizeArea":"0.112","LotSizeDimensions":"40x123","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"840","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"104","OriginalEntryTimestamp":"2026-02-16T13:44:56Z","OwnerPays":"None","ParcelNumber":"0082822420154","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Detached Garage","PhotosCount":"14","PhotosChangeTimestamp":"2026-02-16T20:17:05.071Z","PostalCity":"Saint Paul","PostalCode":"55107","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential Lease","PublicRemarks":"Come check out this charming 3-bedroom, 1.5-bath home offers comfortable living with plenty of space to relax and entertain. Enjoy a functional layout filled with natural light, plus the added convenience of a half bath for guests on the main floor and a beautiful 3 seasons enclosed front porch. A great opportunity in a prime Saint Paul location—schedule your showing today! Section 8 allowed!","PublicSurveyRange":"22","PublicSurveySection":"08","PublicSurveyTownship":"28","NST_RentSpreeYN":"N","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Y","NST_SchoolDistrictPhone":"6517678100","NST_SecurityDeposit":"2750","Sewer":"City Sewer/Connected","NST_SmokingPermitted":"N","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Sidney Street E","StreetNumber":"246","StreetNumberNumeric":"246","SubdivisionName":"Lawton & Meyers Re B25 Woodbu","TenantPays":"All Utilities","BuildingAreaTotal":"1400","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1889","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST504612","ListAgentMlsId":"NST506018808","ListOfficeMlsId":"NST9990","ListOfficeName":"Northstar Real Estate Associates","ListOfficeKey":"NST15562","ModificationTimestamp":"2026-03-29T16:59:05.041Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7854180\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854180/3cac22fc-9ba4-4334-8089-f256c33ea10b.jpeg\",\"LongDescription\":\"FullSizeRender.heic.JPEG\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaModificationTimestamp\":\"2026-02-16T20:16:08.293Z\",\"MediaKey\":\"NST120518940\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7854180\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854180/8f42343a-97d7-45b2-9902-153cb6f8e07c.jpeg\",\"LongDescription\":\"FullSizeRender (1).jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-02-16T20:16:08.447Z\",\"MediaKey\":\"NST120518875\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7854180\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854180/28f184b7-dae4-4a8a-8a70-f1fd2b0ec4e4.jpeg\",\"LongDescription\":\"FullSizeRender (11).jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-02-16T20:07:08.772Z\",\"MediaKey\":\"NST120518966\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7854180\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854180/10a61e8e-48c8-4bf7-a748-745393f09afa.jpeg\",\"LongDescription\":\"FullSizeRender (8).jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-02-16T20:05:10.358Z\",\"MediaKey\":\"NST120518881\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7854180\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854180/c2644d0f-255a-4d07-9c14-ecbb98e35901.jpeg\",\"LongDescription\":\"FullSizeRender (13).jpg\",\"ImageWidth\":1120,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1120x2080\",\"MediaModificationTimestamp\":\"2026-02-16T20:07:08.775Z\",\"MediaKey\":\"NST120518883\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7854180\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854180/8cd6a12c-3c5f-47c6-8493-04c5b6956963.jpeg\",\"LongDescription\":\"FullSizeRender (9).jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-02-16T20:07:08.792Z\",\"MediaKey\":\"NST120518968\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7854180\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854180/2fd4df92-3aff-4197-ae95-a03f85f94674.jpeg\",\"LongDescription\":\"FullSizeRender (4).jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-02-16T20:16:08.33Z\",\"MediaKey\":\"NST120518878\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7854180\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854180/a36d72f2-1514-44c7-80c4-25cdcf8fc84a.jpeg\",\"LongDescription\":\"FullSizeRender (12).jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-02-16T20:07:08.715Z\",\"MediaKey\":\"NST120518882\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7854180\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854180/bebb148f-5933-445d-b304-b4bb9ff2955e.jpeg\",\"LongDescription\":\"FullSizeRender.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-02-16T20:05:10.36Z\",\"MediaKey\":\"NST120518874\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7854180\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854180/950e9257-c940-45a8-ac12-a433735399dc.jpeg\",\"LongDescription\":\"FullSizeRender (5).jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-02-16T20:07:08.862Z\",\"MediaKey\":\"NST120518939\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7854180\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854180/ec1a9908-69da-4a02-bfcf-b9ef0404fc88.jpeg\",\"LongDescription\":\"FullSizeRender (7).jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-02-16T20:05:10.478Z\",\"MediaKey\":\"NST120518880\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7854180\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854180/50875a75-1726-437d-b0d0-2a396b61eb71.jpeg\",\"LongDescription\":\"FullSizeRender (2).jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-02-16T20:16:08.316Z\",\"MediaKey\":\"NST120518876\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7854180\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854180/54fb4b6d-2ca4-467b-a83f-c18c3df2e34a.jpeg\",\"LongDescription\":\"FullSizeRender (6).jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-02-16T20:05:10.441Z\",\"MediaKey\":\"NST120518879\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7854180\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854180/9fad54a3-e1fe-40eb-98c8-cb1ba2d5d2fe.jpeg\",\"LongDescription\":\"FullSizeRender (3).jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-02-16T20:05:10.372Z\",\"MediaKey\":\"NST120518877\"}]","Media__Order":"8","Media__MediaObjectID":"NST8","Media__ResourceRecordKey":"NST7854180","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7854180/3cac22fc-9ba4-4334-8089-f256c33ea10b.jpeg","Media__LongDescription":"FullSizeRender.heic.JPEG","Media__ImageWidth":"1600","Media__ImageHeight":"1200","Media__ImageSizeDescription":"1600x1200","Media__MediaModificationTimestamp":"2/16/2026 8:16:08 PM","Media__MediaKey":"NST120518940","DocumentsChangeTimestamp":"2026-02-16T19:45:06.363Z","Rooms":"[{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"20x12\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Dining Room\",\"RoomKey\":\"NST115937568\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Bedroom\",\"RoomKey\":\"NST115937570\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Kitchen\",\"RoomKey\":\"NST115937569\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16x12\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\",\"RoomKey\":\"NST115937567\"},{\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"9x8\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Bedroom 2\",\"RoomKey\":\"NST115937571\"},{\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"10x10\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom 3\",\"RoomKey\":\"NST115937572\"}]","Rooms__RoomLevel":"Main","Rooms__RoomDimensions":"20x12","Rooms__NST_RoomSortOrder":"2","Rooms__RoomType":"Dining Room","Rooms__RoomKey":"NST115937568","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"FullSizeRender (6).jpg\"},{\"Order\":2,\"Remarks\":\"FullSizeRender (7).jpg\"},{\"Order\":3,\"Remarks\":\"FullSizeRender (8).jpg\"},{\"Order\":4,\"Remarks\":\"FullSizeRender (3).jpg\"},{\"Order\":5,\"Remarks\":\"FullSizeRender.jpg\"},{\"Order\":6,\"Remarks\":\"FullSizeRender (1).jpg\"},{\"Order\":7,\"Remarks\":\"FullSizeRender (2).jpg\"},{\"Order\":8,\"Remarks\":\"FullSizeRender.heic.JPEG\"},{\"Order\":9,\"Remarks\":\"FullSizeRender (4).jpg\"},{\"Order\":10,\"Remarks\":\"FullSizeRender (5).jpg\"},{\"Order\":11,\"Remarks\":\"FullSizeRender (12).jpg\"},{\"Order\":12,\"Remarks\":\"FullSizeRender (11).jpg\"},{\"Order\":13,\"Remarks\":\"FullSizeRender (9).jpg\"},{\"Order\":14,\"Remarks\":\"FullSizeRender (13).jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","CustomVTourURL":""}