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":572364,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7092648","MLSAGENTID":"NST502016202","MLSOFFICEID":"NST27334","ADDRESS":"2800 Hamline Avenue N","ACRES":9.569,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":1.0,"BEDROOMS":2.0,"CITY":"Roseville","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Concrete","FORECLOSURE":"No","LASTPRICE":162500.0,"LASTPRICEDATE":"2026-06-14T04:52:07.807","LATITUDE":45.026168,"LENDEROWNED":"No","LISTDATE":"2026-06-14T05:00:00","LISTPRICE":162500.0,"LIVINGAREA":907.0,"LONGITUDE":-93.156103,"MODIFICATIONTIMESTAMP":"2026-06-14T09:19:07.683","OFFICE_OFFICENAME":"TruHomes Realty LLC","PHOTOCOUNT":14,"POSTALCODE":"55113","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Condo in Roseville! modern and inviting ambiance. Enjoy the plush feel of newer carpet underfoot, complemented by all-newer light fixtures and ceiling fans that add style and functionality. The bathroom features a sleek newer vanity and faucet. The kitchen shines with stainless steel appliances, . Step outside to your private, covered patio with a serene view, perfect for relaxing or entertaining. Additional perks include an underground heated parking stall and access to fantastic amenities. This well-maintained and professionally managed property ensures peace of mind, with HOA dues covering gas, water, sewer, and sanitation. Don't miss this move-in-ready in a prime location!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt,Flat","SCHOOLDISTRICTNUMBER":"623-Roseville","SCHOOLDISTRICTPHONE":"6516351600","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-06-14T04:52:07.807","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Hamline","STREETNUMBER":"2800","STREETSUFFIX":"Avenue","STYLE":"(CC) Low Rise (3- Levels)","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1969,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-06-14T04:57:06.041","PHOTOREMARKS":"[{\"Order\":2,\"Remarks\":\"IMG_4064.jpeg\"},{\"Order\":18,\"Remarks\":\"IMG_4089.jpeg\"},{\"Order\":19,\"Remarks\":\"IMG_4088.jpeg\"},{\"Order\":20,\"Remarks\":\"IMG_4086.jpeg\"},{\"Order\":21,\"Remarks\":\"IMG_4085.jpeg\"},{\"Order\":22,\"Remarks\":\"IMG_4084.jpeg\"},{\"Order\":23,\"Remarks\":\"IMG_4082.jpeg\"},{\"Order\":24,\"Remarks\":\"IMG_4081.jpeg\"},{\"Order\":25,\"Remarks\":\"IMG_4066.jpeg\"},{\"Order\":26,\"Remarks\":\"IMG_4065.jpeg\"},{\"Order\":27,\"Remarks\":\"IMG_4063.jpeg\"},{\"Order\":28,\"Remarks\":\"IMG_4062.jpeg\"},{\"Order\":29,\"Remarks\":\"IMG_4061.jpeg\"},{\"Order\":30,\"Remarks\":\"IMG_4060.jpeg\"}]","PHOTOORDER":"2,18,19,20,21,22,23,24,25,26,27,28,29,30","SOURCE":"MG_NST"}
{"ListingKey":"NST7917926","NST_AboveGradeSqFtTotal":"907","AboveGradeFinishedArea":"907","AccessibilityFeatures":"Accessible Elevator Installed","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Balcony,Exercise Room,Sauna","Appliances":"Dishwasher,Microwave,Range,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"True","AssociationAmenities":"Coin-op Laundry Owned,Elevator(s),Lobby Entrance,Sauna,Security Building","AssociationFee":"590","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Building Exterior,Controlled Access,Gas,Hazard Insurance,Lawn Care,Maintenance Grounds,Parking,Professional Mgmt,Sanitation,Security Staff,Security System,Shared Amenities,Snow Removal,Water","AssociationName":"Compass Management","AssociationPhone":"6128884710","Basement":"None","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Roseville","ConstructionMaterials":"Concrete","NewConstructionYN":"False","Contingency":"None","Cooling":"Window Unit(s)","CountyOrParish":"Ramsey","CultivatedArea":"0","NST_DPResource":"Yes","NST_DiningRoomDescription":"Informal Dining Room,Living/Dining Room","Directions":"Hwy 36 N to Hamline Ave","DocumentsCount":"0","DaysOnMarket":"0","ExteriorFeatures":"Stone","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"907","FoundationDetails":"Block","NST_FoundationDimensions":"907","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"0","NST_GarageDimensions":"0","NST_GarageDoorHeight":"0","NST_GarageDoorWidth":"0","GarageSpaces":"1","Heating":"Baseboard,Boiler","HighSchoolDistrict":"Roseville","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.026168","LaundryFeatures":"Laundry Room","NST_LenderOwned":"No","Levels":"More Than 2 Stories","ListPrice":"162500","ListingContractDate":"2026-06-14T05:00:00Z","ListingId":"NST7092648","LivingArea":"907","LockBoxType":"Combo","Longitude":"-93.156103","LotSizeArea":"9.569","LotSizeDimensions":"0","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"907","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-06-13T23:44:39Z","ParcelNumber":"032923420181","ParkingFeatures":"Heated Garage,Secured,Underground","PastureArea":"0.019","NST_PatioPorchType":"Patio","PhotosCount":"14","PhotosChangeTimestamp":"2026-06-14T04:57:06.041Z","PoolFeatures":"Heated,Indoor","PostalCity":"Saint Paul","PostalCode":"55113","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(CC) Low Rise (3- Levels)","PropertyType":"Residential","PublicRemarks":"Condo in Roseville! modern and inviting ambiance. Enjoy the plush feel of newer carpet underfoot, complemented by all-newer light fixtures and ceiling fans that add style and functionality. The bathroom features a sleek newer vanity and faucet. The kitchen shines with stainless steel appliances, . Step outside to your private, covered patio with a serene view, perfect for relaxing or entertaining. Additional perks include an underground heated parking stall and access to fantastic amenities. This well-maintained and professionally managed property ensures peace of mind, with HOA dues covering gas, water, sewer, and sanitation. Don't miss this move-in-ready in a prime location!","PublicSurveyRange":"23","PublicSurveySection":"03","PublicSurveyTownship":"29","Roof":"Asphalt,Flat","NST_SchoolDistrictFullName":"623 - Roseville","NST_SchoolDistrictNumber":"623","NST_SchoolDistrictPhone":"6516351600","Sewer":"City Sewer/Connected","NST_SharedRooms":"Amusement/Party Room,Exercise Room","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Hamline","StreetNumber":"2800","StreetNumberNumeric":"2800","StreetSuffix":"Avenue","SubdivisionName":"Apt Own No41 Hamline House","TaxAnnualAmount":"2308","NST_TaxWithAssessments":"2308","TaxYear":"2025","NST_TotalArea":"907","BuildingAreaTotal":"907","Township":"Roseville","UnitNumber":"248","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","WoodedArea":"0","YearBuilt":"1969","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST45567","ListAgentMlsId":"NST502016202","ListOfficeMlsId":"NST27334","ListOfficeName":"TruHomes Realty LLC","ListOfficeKey":"NST27334","ModificationTimestamp":"2026-06-14T09:19:07.683Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7917926\",\"Order\":30,\"MediaObjectID\":\"NST30\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917926/6d6df786-7c5b-4445-af94-f050d2abfdd6.jpeg\",\"LongDescription\":\"IMG_4060.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-06-14T04:56:03.577Z\",\"MediaKey\":\"NST122949008\"},{\"ResourceRecordKey\":\"NST7917926\",\"Order\":29,\"MediaObjectID\":\"NST29\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917926/23ad95d9-dbb1-4cf6-86c5-4fc29cd8fe5a.jpeg\",\"LongDescription\":\"IMG_4061.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-06-14T04:51:03.518Z\",\"MediaKey\":\"NST122949009\"},{\"ResourceRecordKey\":\"NST7917926\",\"Order\":25,\"MediaObjectID\":\"NST25\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917926/2d32691d-1474-4f5d-97cd-5b01021884fa.jpeg\",\"LongDescription\":\"IMG_4066.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-06-14T04:55:03.873Z\",\"MediaKey\":\"NST122949014\"},{\"ResourceRecordKey\":\"NST7917926\",\"Order\":27,\"MediaObjectID\":\"NST27\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917926/cb72c24f-2250-48ef-bb5e-dac01a183a16.jpeg\",\"LongDescription\":\"IMG_4063.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-06-14T04:52:03.504Z\",\"MediaKey\":\"NST122949011\"},{\"ResourceRecordKey\":\"NST7917926\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917926/d2c5a8d1-5607-4a6a-8266-78d47c056296.jpeg\",\"LongDescription\":\"IMG_4089.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-06-14T04:57:03.77Z\",\"MediaKey\":\"NST122949021\"},{\"ResourceRecordKey\":\"NST7917926\",\"Order\":21,\"MediaObjectID\":\"NST21\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917926/7da7b1f6-32ac-41d8-9961-3a95c563d056.jpeg\",\"LongDescription\":\"IMG_4085.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-06-14T04:55:03.859Z\",\"MediaKey\":\"NST122949018\"},{\"ResourceRecordKey\":\"NST7917926\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917926/83e62b81-1fc1-4961-b0a9-edef5855d9f8.jpeg\",\"LongDescription\":\"IMG_4088.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-06-14T04:57:03.813Z\",\"MediaKey\":\"NST122949020\"},{\"ResourceRecordKey\":\"NST7917926\",\"Order\":23,\"MediaObjectID\":\"NST23\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917926/85994cc0-f2ef-452d-9069-ab16614d67b7.jpeg\",\"LongDescription\":\"IMG_4082.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-06-14T04:54:03.54Z\",\"MediaKey\":\"NST122949016\"},{\"ResourceRecordKey\":\"NST7917926\",\"Order\":22,\"MediaObjectID\":\"NST22\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917926/a477439d-077c-455e-8076-79c331c5cb9b.jpeg\",\"LongDescription\":\"IMG_4084.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-06-14T04:55:03.874Z\",\"MediaKey\":\"NST122949017\"},{\"ResourceRecordKey\":\"NST7917926\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917926/faf0c02f-73ac-4acb-95f3-1495c9f58c7a.jpeg\",\"LongDescription\":\"IMG_4064.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-06-14T04:54:03.479Z\",\"MediaKey\":\"NST122949012\"},{\"ResourceRecordKey\":\"NST7917926\",\"Order\":26,\"MediaObjectID\":\"NST26\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917926/0a3efe0a-2a49-4621-bd14-2ca14775c825.jpeg\",\"LongDescription\":\"IMG_4065.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-06-14T04:55:03.856Z\",\"MediaKey\":\"NST122949013\"},{\"ResourceRecordKey\":\"NST7917926\",\"Order\":24,\"MediaObjectID\":\"NST24\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917926/76250e94-6854-49b4-811b-52f3e99f1367.jpeg\",\"LongDescription\":\"IMG_4081.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-06-14T04:55:03.86Z\",\"MediaKey\":\"NST122949015\"},{\"ResourceRecordKey\":\"NST7917926\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917926/e583522a-4e34-4019-af56-055c13cb3288.jpeg\",\"LongDescription\":\"IMG_4086.jpeg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaModificationTimestamp\":\"2026-06-14T04:55:03.856Z\",\"MediaKey\":\"NST122949019\"},{\"ResourceRecordKey\":\"NST7917926\",\"Order\":28,\"MediaObjectID\":\"NST28\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917926/c3f7a5bd-8304-443e-b6f4-b116d2c1af41.jpeg\",\"LongDescription\":\"IMG_4062.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-06-14T04:56:03.56Z\",\"MediaKey\":\"NST122949010\"}]","Media__ResourceRecordKey":"NST7917926","Media__Order":"30","Media__MediaObjectID":"NST30","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7917926/6d6df786-7c5b-4445-af94-f050d2abfdd6.jpeg","Media__LongDescription":"IMG_4060.jpeg","Media__ImageWidth":"480","Media__ImageHeight":"640","Media__ImageSizeDescription":"480x640","Media__MediaModificationTimestamp":"6/14/2026 4:56:03 AM","Media__MediaKey":"NST122949008","DocumentsChangeTimestamp":"2026-06-14T04:45:05.942Z","Rooms":"[{\"RoomLevel\":\"Main\",\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116351599\",\"RoomDimensions\":\"15x10\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116351601\",\"RoomDimensions\":\"17x11\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116351600\",\"RoomDimensions\":\"15x10\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116351598\",\"RoomDimensions\":\"13x12\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116351602\",\"RoomDimensions\":\"15x11\"}]","Rooms__RoomLevel":"Main","Rooms__RoomType":"Dining Room","Rooms__NST_RoomSortOrder":"2","Rooms__RoomKey":"NST116351599","Rooms__RoomDimensions":"15x10","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":2,\"Remarks\":\"IMG_4064.jpeg\"},{\"Order\":18,\"Remarks\":\"IMG_4089.jpeg\"},{\"Order\":19,\"Remarks\":\"IMG_4088.jpeg\"},{\"Order\":20,\"Remarks\":\"IMG_4086.jpeg\"},{\"Order\":21,\"Remarks\":\"IMG_4085.jpeg\"},{\"Order\":22,\"Remarks\":\"IMG_4084.jpeg\"},{\"Order\":23,\"Remarks\":\"IMG_4082.jpeg\"},{\"Order\":24,\"Remarks\":\"IMG_4081.jpeg\"},{\"Order\":25,\"Remarks\":\"IMG_4066.jpeg\"},{\"Order\":26,\"Remarks\":\"IMG_4065.jpeg\"},{\"Order\":27,\"Remarks\":\"IMG_4063.jpeg\"},{\"Order\":28,\"Remarks\":\"IMG_4062.jpeg\"},{\"Order\":29,\"Remarks\":\"IMG_4061.jpeg\"},{\"Order\":30,\"Remarks\":\"IMG_4060.jpeg\"}]","PhotoOrder":"2,18,19,20,21,22,23,24,25,26,27,28,29,30","CustomVTourURL":""}