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":1413564,"ORGTABLE":"RAW_Property","MLSCLASS":"RNT","MLSNUMBER":"NST6795006","MLSAGENTID":"NST502046910","MLSOFFICEID":"NST5676","ADDRESS":"817 Kansas Avenue","ACRES":0.21,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":1.0,"BEDROOMS":2,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Wood Siding","FORECLOSURE":"No","LASTPRICE":1650.0,"LASTPRICEDATE":"2025-09-25T21:31:03.9","LATITUDE":44.921497,"LENDEROWNED":"No","LISTDATE":"2025-09-25T05:00:00","LISTPRICE":1650.0,"LIVINGAREA":950.0,"LONGITUDE":-93.067197,"MODIFICATIONTIMESTAMP":"2025-09-25T21:57:03.773","NEIGHBORHOOD":"West Side","OFFICE_OFFICENAME":"RE/MAX Results","PHOTOCOUNT":9,"POSTALCODE":"55107","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Nice 2 bedroom apartment new paint, new hardwood floors with deck off living room. Washer and dryer in unit. Large eat in kitchen and a garage for your convenience. NO Pets please!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer - In Street","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-25T21:31:03.9","LASTSTATUS":"Active","STREETNAME":"Kansas","STREETNUMBER":"817","STREETSUFFIX":"Avenue","STYLE":"Duplex Up and Down","TRANSACTIONTYPE":"For Rent","WATER":"City Water - In Street","WATERFRONTPRESENT":false,"YEARBUILT":1966,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-25T21:56:03.896","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_1142.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_1128.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_1129.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_1140.jpeg\"},{\"Order\":5,\"Remarks\":\"IMG_1138.jpeg\"},{\"Order\":6,\"Remarks\":\"IMG_1135.jpeg\"},{\"Order\":7,\"Remarks\":\"IMG_1130.jpeg\"},{\"Order\":8,\"Remarks\":\"IMG_1133.jpeg\"},{\"Order\":9,\"Remarks\":\"IMG_1141.jpeg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9","SOURCE":"MG_NST"}
{"ListingKey":"NST7807798","LotSizeArea":"0.21","NST_AgeOfProperty":"59","NST_AgentOwner":"Yes","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Deck,Hardwood Floors,Kitchen Window,Main Floor Primary Bedroom","Appliances":"Dryer,Range,Refrigerator,Stainless Steel Appliances,Washer","NST_ApplicationFee":"50.0000","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"True","AvailabilityDate":"2025-09-25T05:00:00Z","NST_BackgroundCheckReq":"Yes","Basement":"None","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"2","City":"Saint Paul","PropertyType":"Residential Lease","NST_ConstructionMaterialsDesc":"Block","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Eat In Kitchen","Directions":"52 to Concord, SE to Stickney, S to Winona, wind around Belvidere, West to Kansas","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Wood Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"950","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","Furnished":"Unfurnished","ParkingFeatures":"Detached,Asphalt","NST_GarageSquareFeet":"340","AccessibilityFeatures":"None","Heating":"Baseboard","OriginalEntryTimestamp":"2025-09-25T21:29:56Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-25","Latitude":"44.921497","NST_LeasePrice":"1650.0000","NST_LenderOwned":"No","ListAgentKey":"NST107556","ListAgentMlsId":"NST502046910","ListingContractDate":"2025-09-25T05:00:00Z","ListOfficeKey":"NST16593","ListOfficeName":"RE/MAX Results","ListOfficeMlsId":"NST5676","LivingArea":"950","LockBoxType":"Combo","Longitude":"-93.067197","LotSizeDimensions":"123x73","LotSizeUnits":"Acres","ListingId":"NST6795006","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","LeaseTerm":"12 Months","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"West Side","NST_OfficeBoard":"MAAR","OwnerPays":"Trash Collection,Water","ParcelNumber":"082822440057","GarageSpaces":"1","NST_PatioPorchType":"Deck","PhotosCount":"9","PostalCity":"Saint Paul","PostalCode":"55107","NST_PrePaidRent":"No","NST_PresentUse":"Yearly","PublicRemarks":"Nice 2 bedroom apartment new paint, new hardwood floors with deck off living room. Washer and dryer in unit. Large eat in kitchen and a garage for your convenience. NO Pets please!","PublicSurveyRange":"22","PublicSurveySection":"08","PublicSurveyTownship":"28","ListPrice":"1650","NST_RentalLicenseYN":"No","Roof":"Age 8 Years or Less","RoomType":"Living Room,Kitchen,Bedroom 1,Bedroom 2,Laundry","NST_AboveGradeSqFtTotal":"950.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"950.0000","BuildingAreaTotal":"950","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","NST_SecurityDeposit":"2000.0000","Sewer":"City Sewer - In Street","NST_SmokingPermitted":"No","AboveGradeFinishedArea":"950","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"Kansas","StreetNumber":"817","StreetNumberNumeric":"817","StreetSuffix":"Avenue","PropertySubType":"Duplex Up and Down","TenantPays":"Heat","WaterSource":"City Water - In Street","YearBuilt":"1966","ZoningDescription":"Residential-Multi-Family","ModificationTimestamp":"2025-09-25T21:57:03.773Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7807798\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"IMG_1142.jpeg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807798/8d7f55c5-f101-45c8-9798-350c634b9169.jpeg\",\"MediaModificationTimestamp\":\"2025-09-25T21:53:30.21Z\",\"MediaKey\":\"68d5b9dabfd2e20e3f779a37\"},{\"ResourceRecordKey\":\"NST7807798\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"IMG_1128.jpeg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807798/f752d03b-b802-4eb3-9544-66857930706b.jpeg\",\"MediaModificationTimestamp\":\"2025-09-25T21:53:30.207Z\",\"MediaKey\":\"68d5b9dabfd2e20e3f779a38\"},{\"ResourceRecordKey\":\"NST7807798\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"IMG_1129.jpeg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807798/9f7d4470-59e8-4f31-a31b-6d0ddd093f9c.jpeg\",\"MediaModificationTimestamp\":\"2025-09-25T21:53:30.216Z\",\"MediaKey\":\"68d5b9dabfd2e20e3f779a39\"},{\"ResourceRecordKey\":\"NST7807798\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"IMG_1140.jpeg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807798/c3dc30a2-c3d8-40a4-8ea8-267634a2d7af.jpeg\",\"MediaModificationTimestamp\":\"2025-09-25T21:53:30.187Z\",\"MediaKey\":\"68d5b9dabfd2e20e3f779a3b\"},{\"ResourceRecordKey\":\"NST7807798\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"IMG_1138.jpeg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807798/586ac6e4-1adb-4ce5-8621-effdfb1f5663.jpeg\",\"MediaModificationTimestamp\":\"2025-09-25T21:53:30.206Z\",\"MediaKey\":\"68d5b9dabfd2e20e3f779a3e\"},{\"ResourceRecordKey\":\"NST7807798\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"IMG_1135.jpeg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807798/ec29831b-45cc-4d84-8d5e-4ff1304611c5.jpeg\",\"MediaModificationTimestamp\":\"2025-09-25T21:53:30.189Z\",\"MediaKey\":\"68d5b9dabfd2e20e3f779a3d\"},{\"ResourceRecordKey\":\"NST7807798\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"IMG_1130.jpeg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807798/bd934d00-6fe3-4b7d-a371-6119c04acb4e.jpeg\",\"MediaModificationTimestamp\":\"2025-09-25T21:53:30.193Z\",\"MediaKey\":\"68d5b9dabfd2e20e3f779a3a\"},{\"ResourceRecordKey\":\"NST7807798\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"IMG_1133.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807798/44e34c4d-03ea-486a-b7f9-f389f5490353.jpeg\",\"MediaModificationTimestamp\":\"2025-09-25T21:53:30.212Z\",\"MediaKey\":\"68d5b9dabfd2e20e3f779a3c\"},{\"ResourceRecordKey\":\"NST7807798\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"IMG_1141.jpeg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807798/9459dc29-fc49-4f97-a38c-bfe45f405727.jpeg\",\"MediaModificationTimestamp\":\"2025-09-25T21:53:30.212Z\",\"MediaKey\":\"68d5b9dabfd2e20e3f779a40\"}]","PhotosChangeTimestamp":"2025-09-25T21:56:03.896Z","Rooms":"[{\"RoomKey\":\"NST115648853\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115648854\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115648855\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115648901\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115648902\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"5\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_1142.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_1128.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_1129.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_1140.jpeg\"},{\"Order\":5,\"Remarks\":\"IMG_1138.jpeg\"},{\"Order\":6,\"Remarks\":\"IMG_1135.jpeg\"},{\"Order\":7,\"Remarks\":\"IMG_1130.jpeg\"},{\"Order\":8,\"Remarks\":\"IMG_1133.jpeg\"},{\"Order\":9,\"Remarks\":\"IMG_1141.jpeg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9","CustomVTourURL":""}