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":1386349,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6760057","MLSAGENTID":"NST506000564","MLSOFFICEID":"NST8230","ADDRESS":"2800 Hamline Avenue N","ACRES":0.0,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Other","BATHSTOTAL":1.0,"BEDROOMS":1,"CITY":"Roseville","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Other","FORECLOSURE":"No","LASTPRICE":119900.0,"LASTPRICEDATE":"2025-09-14T18:42:03.397","LATITUDE":45.026168,"LENDEROWNED":"No","LISTDATE":"2025-07-23T05:00:00","LISTPRICE":104000.0,"LIVINGAREA":695.0,"LONGITUDE":-93.156103,"MODIFICATIONTIMESTAMP":"2025-09-14T18:42:03.398","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":18,"POSTALCODE":"55113","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Great South Facing 2nd Floor Unit That is convenient to Elevator and Access Points. New Carpet, Study Area, Fantastic Covered Deck Area. Fantastic Indoor Pool, Community Room, Exercise Room and Work Shop. Underground Heated Garage. Wonderful Wooded Views From this Condo. Close to Central Park and Shopping.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"623-Roseville","SCHOOLDISTRICTPHONE":"651-635-1600","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-07-23T17:22:04.037","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Hamline","STREETNUMBER":"2800","STREETSUFFIX":"Avenue","STYLE":"Low Rise","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1969,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-07-31T01:51:03.546","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front entrance\"},{\"Order\":2,\"Remarks\":\"Spacious Living room Virtually staged\"},{\"Order\":4,\"Remarks\":\"Bedroom Virtually staged\"},{\"Order\":5,\"Remarks\":\"kit 2 20250718_132444.jpg\"},{\"Order\":6,\"Remarks\":\"LR 1 dwsk20250718_131918.jpg\"},{\"Order\":7,\"Remarks\":\"Deck\"},{\"Order\":8,\"Remarks\":\"Deck\"},{\"Order\":16,\"Remarks\":\"2800 Hamline public room20250726_125604.jpg\"},{\"Order\":17,\"Remarks\":\"2800 Hamline work 20250726_130031.jpg\"},{\"Order\":18,\"Remarks\":\"2800 outside 20250726_125849 (1).jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}
{"ListingKey":"NST7777463","LotSizeArea":"0","NST_AgeOfProperty":"56","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","AssociationAmenities":"Coin-op Laundry Leased,Laundry,Elevator(s),Security","NST_AmenitiesUnit":"Balcony,Deck,Main Floor Primary Bedroom,Panoramic View,Tile Floors","Appliances":"Dishwasher,Disposal,Microwave,Range,Refrigerator","NST_AssessmentPending":"Unknown","AssociationFeeIncludes":"Maintenance Structure,Hazard Insurance,Heating,Lawn Care,Maintenance Grounds,Professional Mgmt,Trash,Security,Sewer,Snow Removal","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"508","AssociationName":"Compass Management Group","AssociationPhone":"612-888-4706","PropertyAttachedYN":"True","NST_AttributionContact":"651-387-1314","NST_AttributionName":"Richard D. Kotoski","Basement":"Other","BasementYN":"False","NST_BathDesc":"Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"1","City":"Roseville","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Wall Unit(s)","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"53","CumulativeDaysOnMarket":"53","Directions":"Hwy 36, North on Hamline, complex on the East side of Hamline","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Other","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"695","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Underground","NST_GarageSquareFeet":"0","AccessibilityFeatures":"Accessible Elevator Installed","Heating":"Baseboard","OriginalEntryTimestamp":"2025-07-23T17:17:54Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-14","Latitude":"45.026168","NST_LenderOwned":"No","ListAgentKey":"NST47084","ListAgentMlsId":"NST506000564","ListingContractDate":"2025-07-23T05:00:00Z","ListOfficeKey":"NST16459","ListOfficeName":"Coldwell Banker Realty","ListOfficeMlsId":"NST8230","ListPrice":"104000","LivingArea":"695","LockBoxType":"Combo","Longitude":"-93.156103","LotSizeDimensions":"Common","LotSizeSquareFeet":"0","LotSizeUnits":"Acres","ListingId":"NST6760057","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"032923420158","GarageSpaces":"1","NST_PatioPorchType":"Covered","PhotosCount":"18","PoolFeatures":"Heated,Indoor","PostalCity":"Roseville","PostalCode":"55113","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Great South Facing 2nd Floor Unit That is convenient to Elevator and Access Points. New Carpet, Study Area, Fantastic Covered Deck Area. Fantastic Indoor Pool, Community Room, Exercise Room and Work Shop. Underground Heated Garage. Wonderful Wooded Views From this Condo. Close to Central Park and Shopping.","PublicSurveyRange":"23","PublicSurveySection":"03","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","NST_Restrictions":"Other","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Deck","NST_AboveGradeSqFtTotal":"695.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"695.0000","BuildingAreaTotal":"695","HighSchoolDistrict":"Roseville","NST_SchoolDistrictNumber":"623","NST_SchoolDistrictPhone":"651-635-1600","Sewer":"City Sewer/Connected","NST_SharedRooms":"Amusement/Party Room,Community Room","NST_SpecialSearch":"All Living Facilities on One Level,Main Floor Bedroom","AboveGradeFinishedArea":"695","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"N","StreetName":"Hamline","StreetNumber":"2800","StreetNumberNumeric":"2800","StreetSuffix":"Avenue","PropertySubType":"Low Rise","SubdivisionName":"Hamline House","NST_TaxWithAssessments":"1652.0000","TaxYear":"2025","TaxAnnualAmount":"1652","UnitNumber":"225","WaterSource":"City Water/Connected","YearBuilt":"1969","ZoningDescription":"Residential-Multi-Family","ModificationTimestamp":"2025-09-14T18:42:03.398Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7777463\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Front entrance\",\"ImageWidth\":1080,\"ImageHeight\":771,\"ImageSizeDescription\":\"1080x771\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/af7a4745-ee3a-40e4-b506-3ca4ffd524a9.jpeg\",\"MediaModificationTimestamp\":\"2025-07-23T19:40:03.024Z\",\"MediaKey\":\"68813a935de071742225dab5\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Spacious Living room Virtually staged\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/4df9971a-efb5-4c03-9bcb-3e8c0e2802c9.jpeg\",\"MediaModificationTimestamp\":\"2025-07-23T19:37:01.155Z\",\"MediaKey\":\"688139ddbdc51b3bfcc6f792\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/974f70f4-f138-46dc-a700-09728fa0b17c.jpeg\",\"MediaModificationTimestamp\":\"2025-07-25T19:09:08.61Z\",\"MediaKey\":\"6883d6541dd4614d2df74b9d\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Bedroom Virtually staged\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/4025a485-4bab-4d9a-a079-6b36fa0a0e49.jpeg\",\"MediaModificationTimestamp\":\"2025-07-23T19:37:01.174Z\",\"MediaKey\":\"688139ddbdc51b3bfcc6f793\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"kit 2 20250718_132444.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/e4b95c80-59eb-466f-adc1-ebdea9ae151a.jpeg\",\"MediaModificationTimestamp\":\"2025-07-25T19:18:50.823Z\",\"MediaKey\":\"6883d89a2a15fa0d8cf71b05\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"LR 1 dwsk20250718_131918.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/b6f4eb68-9331-48e8-944d-a8490e18162b.jpeg\",\"MediaModificationTimestamp\":\"2025-07-25T19:18:50.852Z\",\"MediaKey\":\"6883d89a2a15fa0d8cf71b06\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Deck\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/9e3168e7-dc02-44b5-8872-a9ec140e1b18.jpeg\",\"MediaModificationTimestamp\":\"2025-07-25T19:09:08.705Z\",\"MediaKey\":\"6883d6541dd4614d2df74ba0\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Deck\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/357fe1a7-ffd5-4e7e-ae12-237138ee94f5.jpeg\",\"MediaModificationTimestamp\":\"2025-07-25T19:09:08.675Z\",\"MediaKey\":\"6883d6541dd4614d2df74ba1\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/d65d03a9-045f-47ad-83cc-0e515ffa938e.jpeg\",\"MediaModificationTimestamp\":\"2025-07-25T19:18:50.826Z\",\"MediaKey\":\"6883d89a2a15fa0d8cf71b07\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/1f2cc3d8-799a-43dd-b496-c67c6c125abb.jpeg\",\"MediaModificationTimestamp\":\"2025-07-25T19:18:50.839Z\",\"MediaKey\":\"6883d89a2a15fa0d8cf71b08\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/525432d3-d5f3-435b-9646-19c467223482.jpeg\",\"MediaModificationTimestamp\":\"2025-07-25T19:18:50.874Z\",\"MediaKey\":\"6883d89a2a15fa0d8cf71b09\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/5ffc8552-3174-4e8c-a37c-8e48b30f393d.jpeg\",\"MediaModificationTimestamp\":\"2025-07-25T19:18:50.88Z\",\"MediaKey\":\"6883d89a2a15fa0d8cf71b0a\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/196d6a39-d48f-4a76-9298-4e3e03756ecd.jpeg\",\"MediaModificationTimestamp\":\"2025-07-25T19:18:50.938Z\",\"MediaKey\":\"6883d89a2a15fa0d8cf71b0b\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/c1f23d21-d56f-4704-a425-fc2305e668b7.jpeg\",\"MediaModificationTimestamp\":\"2025-07-25T19:18:50.87Z\",\"MediaKey\":\"6883d89a2a15fa0d8cf71b0c\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":960,\"ImageHeight\":662,\"ImageSizeDescription\":\"960x662\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/8d74d741-474e-4b93-a46c-34561943e178.jpeg\",\"MediaModificationTimestamp\":\"2025-07-26T02:59:38.962Z\",\"MediaKey\":\"6884449ad2393a1ac7fe2324\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"2800 Hamline public room20250726_125604.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/b95e1549-c3f4-4b21-8fab-69df61bc5bfa.jpeg\",\"MediaModificationTimestamp\":\"2025-07-31T01:50:21.28Z\",\"MediaKey\":\"688acbddcf562209f02e982f\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"2800 Hamline work 20250726_130031.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/574b55a5-e724-4ef0-8d9c-1b3c2f0d6528.jpeg\",\"MediaModificationTimestamp\":\"2025-07-31T01:50:21.317Z\",\"MediaKey\":\"688acbddcf562209f02e9830\"},{\"ResourceRecordKey\":\"NST7777463\",\"Order\":18,\"MediaObjectID\":\"18\",\"LongDescription\":\"2800 outside 20250726_125849 (1).jpg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777463/e45f1c57-8db4-4983-a319-f252859f4d78.jpeg\",\"MediaModificationTimestamp\":\"2025-07-31T01:50:21.327Z\",\"MediaKey\":\"688acbddcf562209f02e9831\"}]","PhotosChangeTimestamp":"2025-07-31T01:51:03.546Z","Rooms":"[{\"RoomKey\":\"NST115447145\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"19x13\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115447146\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"7x7\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115447147\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9x8\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115447148\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x12\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115447149\",\"RoomType\":\"Deck\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x8\",\"NST_RoomSortOrder\":\"5\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front entrance\"},{\"Order\":2,\"Remarks\":\"Spacious Living room Virtually staged\"},{\"Order\":4,\"Remarks\":\"Bedroom Virtually staged\"},{\"Order\":5,\"Remarks\":\"kit 2 20250718_132444.jpg\"},{\"Order\":6,\"Remarks\":\"LR 1 dwsk20250718_131918.jpg\"},{\"Order\":7,\"Remarks\":\"Deck\"},{\"Order\":8,\"Remarks\":\"Deck\"},{\"Order\":16,\"Remarks\":\"2800 Hamline public room20250726_125604.jpg\"},{\"Order\":17,\"Remarks\":\"2800 Hamline work 20250726_130031.jpg\"},{\"Order\":18,\"Remarks\":\"2800 outside 20250726_125849 (1).jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","CustomVTourURL":""}