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":1408584,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6789019","MLSAGENTID":"NST506008863","MLSOFFICEID":"NST253015","ADDRESS":"518 Lovell Avenue","ACRES":0.03,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":2.0,"BEDROOMS":2,"CITY":"Roseville","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":239900.0,"LASTPRICEDATE":"2025-09-15T18:20:03.74","LATITUDE":45.010744,"LENDEROWNED":"No","LISTDATE":"2025-09-15T05:00:00","LISTPRICE":239900.0,"LIVINGAREA":1127.0,"LONGITUDE":-93.122377,"MODIFICATIONTIMESTAMP":"2025-09-15T18:29:03.819","OFFICE_OFFICENAME":"LPT Realty, LLC","PHOTOCOUNT":19,"POSTALCODE":"55113","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Beautifully 2 bedroom & 2 bath townhome in a prime location! Main level features new LVP flooring, open\nkitchen with breakfast bar, and a cozy gas fireplace. Upstairs offers two spacious bedrooms, full bath,\nwalk-in closet in primary, and in-unit laundry. This home is part of a well-cared-for community with\nrecent improvements include a new roof in 2022 and driveway seal coating in 2024. Set in a peaceful\nneighborhood, close to Central Park and Muriel Sahlin Arboretum, ideal for outdoor walks and picnics.\nShopping, dining, and quick freeway access are all nearby, you wouln't want to miss this great\nopportunity!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"623-Roseville","SCHOOLDISTRICTPHONE":"651-635-1600","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-15T18:20:03.74","LASTSTATUS":"Active","STREETNAME":"Lovell","STREETNUMBER":"518","STREETSUFFIX":"Avenue","STYLE":"Townhouse Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1992,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-15T18:20:03.741","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","SOURCE":"MG_NST"}
{"ListingKey":"NST7802704","LotSizeArea":"0.03","NST_AgeOfProperty":"33","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","Appliances":"Dishwasher,Disposal,Dryer,Gas Water Heater,Microwave,Range,Refrigerator,Washer","NST_AssessmentPending":"No","AssociationFeeIncludes":"Hazard Insurance,Lawn Care,Maintenance Grounds,Professional Mgmt,Trash,Sewer,Snow Removal","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"350","AssociationName":"Advantage Townhome Management","AssociationPhone":"651-429-2223","PropertyAttachedYN":"True","Basement":"None","BasementYN":"False","NST_BathDesc":"Main Floor 1/2 Bath,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"2","City":"Roseville","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Eat In Kitchen,Kitchen/Dining Room","Directions":"HWY 36, North on Dale St, East on Lovell Ave W, South on 4th driveway to property.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Brick/Stone,Vinyl Siding","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"522","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Asphalt,Garage Door Opener","NST_GarageDimensions":"21x9","NST_GarageSquareFeet":"189","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-09-15T18:17:57Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-15","Latitude":"45.010744","NST_LenderOwned":"No","ListAgentKey":"NST98262","ListAgentMlsId":"NST506008863","ListingContractDate":"2025-09-15T05:00:00Z","ListOfficeKey":"NST1001758","ListOfficeName":"LPT Realty, LLC","ListOfficeMlsId":"NST253015","ListPrice":"239900","LivingArea":"1127","Longitude":"-93.122377","LotSizeDimensions":"0","LotSizeSquareFeet":"1306.8","LotSizeUnits":"Acres","ListingId":"NST6789019","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"122923320096","GarageSpaces":"1","PhotosCount":"19","PostalCity":"Saint Paul","PostalCode":"55113","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Beautifully 2 bedroom & 2 bath townhome in a prime location! Main level features new LVP flooring, open\nkitchen with breakfast bar, and a cozy gas fireplace. Upstairs offers two spacious bedrooms, full bath,\nwalk-in closet in primary, and in-unit laundry. This home is part of a well-cared-for community with\nrecent improvements include a new roof in 2022 and driveway seal coating in 2024. Set in a peaceful\nneighborhood, close to Central Park and Muriel Sahlin Arboretum, ideal for outdoor walks and picnics.\nShopping, dining, and quick freeway access are all nearby, you wouln't want to miss this great\nopportunity!","PublicSurveyRange":"23","PublicSurveySection":"12","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","NST_Restrictions":"Mandatory Owners Assoc","Roof":"Age 8 Years or Less","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2","NST_AboveGradeSqFtTotal":"1127.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"0.0000","BuildingAreaTotal":"1127","HighSchoolDistrict":"Roseville","NST_SchoolDistrictNumber":"623","NST_SchoolDistrictPhone":"651-635-1600","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1127","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Lovell","StreetNumber":"518","StreetNumberNumeric":"518","StreetSuffix":"Avenue","PropertySubType":"Townhouse Side x Side","SubdivisionName":"Condo 229 Concordia Meadows","NST_TaxWithAssessments":"2992.0000","TaxYear":"2025","TaxAnnualAmount":"2992","UnitNumber":"2","WaterSource":"City Water/Connected","YearBuilt":"1992","ZoningDescription":"Residential-Multi-Family","ModificationTimestamp":"2025-09-15T18:29:03.819Z","PhotosChangeTimestamp":"2025-09-15T18:20:03.741Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7802704\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/6b180de8-6f8b-4416-a1c0-df5168da12a3.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.2Z\",\"MediaKey\":\"68c858c74104712eba734298\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/4bfb1ebe-59a2-4d2c-92ee-8bb0f7da8a63.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.208Z\",\"MediaKey\":\"68c858c74104712eba734299\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/036ad8b8-30e9-474f-91a9-be1baa6344fb.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.189Z\",\"MediaKey\":\"68c858c74104712eba73429a\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/61ff31fd-2ea4-4ebd-95bd-ff491038a9b1.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.188Z\",\"MediaKey\":\"68c858c74104712eba73429b\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/821a3ce5-4990-4e01-bde3-b30c032e41c0.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.185Z\",\"MediaKey\":\"68c858c74104712eba73429c\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/efe9cfa9-906d-45d5-a6e9-f1257869c921.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.187Z\",\"MediaKey\":\"68c858c74104712eba73429d\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/5e0b4943-294d-4e10-a697-b71b3a80320b.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.191Z\",\"MediaKey\":\"68c858c74104712eba73429e\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/0eb53eaf-0492-4f57-b7c1-d7d52f185051.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.169Z\",\"MediaKey\":\"68c858c74104712eba73429f\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/b7f857d6-f45e-4609-991e-12de075a407d.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.169Z\",\"MediaKey\":\"68c858c74104712eba7342a0\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/7bab3f5e-521b-404a-9815-4c005b2abbc8.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.209Z\",\"MediaKey\":\"68c858c74104712eba7342a1\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/d0f77473-c1e2-4383-b7c8-48ef51375552.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.169Z\",\"MediaKey\":\"68c858c74104712eba7342a2\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/3a82845f-d557-4eb1-b16c-fd5156913797.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.179Z\",\"MediaKey\":\"68c858c74104712eba7342a3\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/60f5001a-a8ad-4d9a-90d3-99a5481a2acb.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.177Z\",\"MediaKey\":\"68c858c74104712eba7342a4\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/a8ccc361-811a-4399-97a4-d3868fa7ee4e.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.169Z\",\"MediaKey\":\"68c858c74104712eba7342a5\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/a83b5c07-f7d3-4f26-a357-266f2f2599ed.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.224Z\",\"MediaKey\":\"68c858c74104712eba7342a6\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":16,\"MediaObjectID\":\"16\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/bd473227-c0c4-4a79-a072-755c007cfd87.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.197Z\",\"MediaKey\":\"68c858c74104712eba7342a7\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":17,\"MediaObjectID\":\"17\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/2165c744-e906-466f-bc62-ca4238bb9006.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.207Z\",\"MediaKey\":\"68c858c74104712eba7342a8\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":18,\"MediaObjectID\":\"18\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/262669ef-bb66-47c1-913c-639582e720c8.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.209Z\",\"MediaKey\":\"68c858c74104712eba7342a9\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":19,\"MediaObjectID\":\"19\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/440c7159-f0bd-4251-8445-d8ab6c4c6e82.jpeg\",\"MediaModificationTimestamp\":\"2025-09-15T18:19:51.198Z\",\"MediaKey\":\"68c858c74104712eba7342aa\"}]","Rooms":"[{\"RoomKey\":\"NST115615292\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x13\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115615293\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x8\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115615294\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x9\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115615295\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"17x13\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115615296\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"16x11\",\"NST_RoomSortOrder\":\"5\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","CustomVTourURL":""}