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":1406801,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6786687","MLSAGENTID":"NST506090763","MLSOFFICEID":"NST8113","ADDRESS":"1665 Sherburne Avenue","ACRES":0.11,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Block,Full,Storage/Locker","CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Stucco","FORECLOSURE":"No","LASTPRICE":500000.0,"LASTPRICEDATE":"2025-09-10T20:19:03.503","LATITUDE":44.956738,"LENDEROWNED":"No","LISTDATE":"2025-09-10T05:00:00","LISTPRICE":500000.0,"LIVINGAREA":2176.0,"LONGITUDE":-93.170616,"MODIFICATIONTIMESTAMP":"2025-09-11T02:09:04.239","NEIGHBORHOOD":"Hamline-Midway","OFFICE_OFFICENAME":"Edina Realty, Inc.","PHOTOCOUNT":11,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-10T20:19:03.503","LASTSTATUS":"Active","STREETNAME":"Sherburne","STREETNUMBER":"1665","STREETSUFFIX":"Avenue","STYLE":"Quadruplex","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1924,"HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-11T02:09:04.239","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1665 Sherburne Ave\"},{\"Order\":2,\"Remarks\":\"Backyard with small patio\"},{\"Order\":3,\"Remarks\":\"Updated kitchens with solid surface counters and tile backsplash\"},{\"Order\":4,\"Remarks\":\"Functional galley kithens\"},{\"Order\":5,\"Remarks\":\"Nicely appointed updated bathrooms\"},{\"Order\":6,\"Remarks\":\"Full tile showers with glassblock\"},{\"Order\":7,\"Remarks\":\"Cozy living room with south facing windows\"},{\"Order\":8,\"Remarks\":\"Bedrooms with double closets\"},{\"Order\":10,\"Remarks\":\"Basement storage\"},{\"Order\":11,\"Remarks\":\"Common laundry in basement\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11","SOURCE":"MG_NST"}
{"ListingKey":"NST7800657","LotSizeArea":"0.11","NST_AgeOfProperty":"101","NST_AgentOwner":"Yes","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","NST_AssessmentPending":"No","Basement":"Block,Full,Storage/Locker","BasementYN":"True","City":"Saint Paul","PropertyType":"Residential Income","NewConstructionYN":"False","Contingency":"None","CountyOrParish":"Ramsey","Directions":"Snelling Ave to Sherburne Ave, west to home","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ManagerExpense":"0","ElectricExpense":"0","FuelExpense":"0","InsuranceExpense":"0","MaintenanceExpense":"0","OtherExpense":"0","OperatingExpense":"0","TrashExpense":"0","WaterSewerExpense":"0","NST_Expenses":"3650.0000","ConstructionMaterials":"Stucco","Fencing":"Chain Link","NST_ForeclosureStatus":"No","FoundationArea":"1088","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Electric,Natural Gas","ParkingFeatures":"Detached","NST_GarageSquareFeet":"440","GrossIncome":"54720","AccessibilityFeatures":"None","Heating":"Boiler,Radiator(s)","NST_IncomeMiscAnn":"0.0000","NST_IncomeMiscMon":"0.0000","OriginalEntryTimestamp":"2025-09-10T20:16:04Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-10","Latitude":"44.956738","NST_LenderOwned":"No","ListAgentKey":"NST49823","ListAgentMlsId":"NST506090763","ListingContractDate":"2025-09-10T05:00:00Z","ListOfficeKey":"NST16445","ListOfficeName":"Edina Realty, Inc.","ListOfficeMlsId":"NST8113","ListPrice":"500000","LivingArea":"2176","Longitude":"-93.170616","LotSizeDimensions":"40x140","LotSizeUnits":"Acres","ListingId":"NST6786687","SourceSystemName":"RMLS","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Hamline-Midway","NST_OfficeBoard":"SPAAR","NST_OwnerOccupied":"No","OwnerPays":"Trash Collection","ParcelNumber":"332923140164","GarageSpaces":"2","PhotosCount":"11","PostalCity":"Saint Paul","PostalCode":"55104","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicSurveyRange":"23","PublicSurveySection":"33","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","NST_AboveGradeSqFtTotal":"2176.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"1088.0000","BuildingAreaTotal":"2176","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"2176","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Sherburne","StreetNumber":"1665","StreetNumberNumeric":"1665","StreetSuffix":"Avenue","PropertySubType":"Quadruplex","SubdivisionName":"Brightwood Park","NST_TaxWithAssessments":"8120.0000","TaxYear":"2025","TaxAnnualAmount":"8120","NumberOfUnitsTotal":"4","WaterSource":"City Water/Connected","YearBuilt":"1924","ModificationTimestamp":"2025-09-11T02:09:04.239Z","PhotosChangeTimestamp":"2025-09-11T02:09:04.239Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7800657\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"1665 Sherburne Ave\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800657/15225df7-ef19-49dc-8dba-8dad83443d99.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T20:17:57.699Z\",\"MediaKey\":\"68c1dcf5bbe6ad71cb1ba595\"},{\"ResourceRecordKey\":\"NST7800657\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Backyard with small patio\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800657/d6d743a7-da58-4381-885d-83bb911d7f03.jpeg\",\"MediaModificationTimestamp\":\"2025-09-11T02:07:17.685Z\",\"MediaKey\":\"68c22ed57c1b5f351fda4f68\"},{\"ResourceRecordKey\":\"NST7800657\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Updated kitchens with solid surface counters and tile backsplash\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800657/f684c780-a34d-41f6-969b-000aa362de5c.jpeg\",\"MediaModificationTimestamp\":\"2025-09-11T02:07:17.657Z\",\"MediaKey\":\"68c22ed57c1b5f351fda4f69\"},{\"ResourceRecordKey\":\"NST7800657\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Functional galley kithens\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800657/28a242f1-461a-4010-af3c-f66fc72c2879.jpeg\",\"MediaModificationTimestamp\":\"2025-09-11T02:07:17.702Z\",\"MediaKey\":\"68c22ed57c1b5f351fda4f6a\"},{\"ResourceRecordKey\":\"NST7800657\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Nicely appointed updated bathrooms\",\"ImageWidth\":1388,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1388x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800657/b5f36c4b-71ac-4e65-88c3-a6c4faec4d4b.jpeg\",\"MediaModificationTimestamp\":\"2025-09-11T02:07:17.657Z\",\"MediaKey\":\"68c22ed57c1b5f351fda4f6b\"},{\"ResourceRecordKey\":\"NST7800657\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Full tile showers with glassblock\",\"ImageWidth\":1388,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1388x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800657/4eab8eb1-dbc4-4754-ba7b-6262b5d61063.jpeg\",\"MediaModificationTimestamp\":\"2025-09-11T02:07:17.657Z\",\"MediaKey\":\"68c22ed57c1b5f351fda4f6c\"},{\"ResourceRecordKey\":\"NST7800657\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Cozy living room with south facing windows\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800657/2c6deeef-da44-4d99-8d0c-7e23c5478c1d.jpeg\",\"MediaModificationTimestamp\":\"2025-09-11T02:07:17.702Z\",\"MediaKey\":\"68c22ed57c1b5f351fda4f6d\"},{\"ResourceRecordKey\":\"NST7800657\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Bedrooms with double closets\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800657/deb2bb72-3572-4a84-8fb0-010486d7ec32.jpeg\",\"MediaModificationTimestamp\":\"2025-09-11T02:07:17.647Z\",\"MediaKey\":\"68c22ed57c1b5f351fda4f6e\"},{\"ResourceRecordKey\":\"NST7800657\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800657/847fb963-d9e1-4a94-a9b2-f8bfb7a5d512.jpeg\",\"MediaModificationTimestamp\":\"2025-09-11T02:07:17.693Z\",\"MediaKey\":\"68c22ed57c1b5f351fda4f6f\"},{\"ResourceRecordKey\":\"NST7800657\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"Basement storage\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800657/a7825245-84a0-473d-8400-31cde0bc0f27.jpeg\",\"MediaModificationTimestamp\":\"2025-09-11T02:07:17.674Z\",\"MediaKey\":\"68c22ed57c1b5f351fda4f70\"},{\"ResourceRecordKey\":\"NST7800657\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"Common laundry in basement\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800657/0f341f60-a483-4a74-9f6d-d37f0e498f64.jpeg\",\"MediaModificationTimestamp\":\"2025-09-11T02:07:17.674Z\",\"MediaKey\":\"68c22ed57c1b5f351fda4f71\"}]","UnitTypes":"[{\"UnitTypeKey\":\"NST155837\",\"UnitTypeTotalRent\":13680,\"NST_UnitBath3Qtr\":\"1\",\"NST_UnitBathFull\":\"0\",\"NST_UnitBathHalf\":\"0\",\"NST_UnitBathQtr\":\"0\",\"UnitTypeBathsTotal\":1,\"UnitTypeBedsTotal\":1,\"NST_MonthlyExpenses\":\"0.00\",\"NST_UnitFireplaceNum\":\"0\",\"NST_UnitID\":\"1\",\"UnitTypeActualRent\":1140,\"UnitTypeUnitsTotal\":4,\"NST_UnitParking\":\"1\",\"NST_UnitRoomsTotal\":\"4\",\"NST_UnitSqFt\":\"400\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1665 Sherburne Ave\"},{\"Order\":2,\"Remarks\":\"Backyard with small patio\"},{\"Order\":3,\"Remarks\":\"Updated kitchens with solid surface counters and tile backsplash\"},{\"Order\":4,\"Remarks\":\"Functional galley kithens\"},{\"Order\":5,\"Remarks\":\"Nicely appointed updated bathrooms\"},{\"Order\":6,\"Remarks\":\"Full tile showers with glassblock\"},{\"Order\":7,\"Remarks\":\"Cozy living room with south facing windows\"},{\"Order\":8,\"Remarks\":\"Bedrooms with double closets\"},{\"Order\":10,\"Remarks\":\"Basement storage\"},{\"Order\":11,\"Remarks\":\"Common laundry in basement\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11","CustomVTourURL":""}