{"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-16T02:41:04.997","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-16T02:41:04.997","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-16T02:41:04.997Z","PhotosChangeTimestamp":"2025-09-16T02:41:04.997Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7802704\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/479d1743-0452-4693-b3a0-b18b051055c3.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.963Z\",\"MediaKey\":\"68c8ce262383646b2a99678e\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/2c8c72a7-92a5-4702-a9d6-422f0b55898f.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.95Z\",\"MediaKey\":\"68c8ce262383646b2a99678f\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/33589c4a-cf1a-4d4d-bfd1-2533e7803a26.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:38.16Z\",\"MediaKey\":\"68c8ce262383646b2a996790\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/bbc4c175-1c4a-4bc2-abd6-e7cd5398cbbd.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.922Z\",\"MediaKey\":\"68c8ce262383646b2a996791\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/c2ff392f-319c-4ccc-9fd9-18dc3b015e02.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.935Z\",\"MediaKey\":\"68c8ce262383646b2a996792\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/6af5da27-86d9-49b4-8803-efa81965f0c0.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.931Z\",\"MediaKey\":\"68c8ce262383646b2a996793\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/27481e3c-5c7b-43ce-89fd-b001ecf488a9.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.941Z\",\"MediaKey\":\"68c8ce262383646b2a996794\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/155a1006-806a-4d2d-ac88-5201011f4b2a.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.96Z\",\"MediaKey\":\"68c8ce262383646b2a996795\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/34888ec6-24c6-454e-ac3a-2faba037a326.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.939Z\",\"MediaKey\":\"68c8ce262383646b2a996796\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/9e2238ae-4801-484d-8a9c-0c478ae0d983.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.931Z\",\"MediaKey\":\"68c8ce262383646b2a996797\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/02b2112b-7d17-43b4-aebb-bc0f3c259f5c.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.93Z\",\"MediaKey\":\"68c8ce262383646b2a996798\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/1b2acd61-56e0-46f9-80e3-422a4b43e790.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.922Z\",\"MediaKey\":\"68c8ce262383646b2a996799\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/d030285f-0c50-4ae1-941d-ad32fa8c61e9.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.93Z\",\"MediaKey\":\"68c8ce262383646b2a99679a\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/b29bf9ee-7be9-412e-8738-b31cc2847c3b.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.93Z\",\"MediaKey\":\"68c8ce262383646b2a99679b\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/8ccbd365-65e5-4fb7-92bd-f1dc54c8171b.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.941Z\",\"MediaKey\":\"68c8ce262383646b2a99679c\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":16,\"MediaObjectID\":\"16\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/c8b65441-a5a4-4592-863a-61cf1c2cf7d5.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.965Z\",\"MediaKey\":\"68c8ce262383646b2a99679d\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":17,\"MediaObjectID\":\"17\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/6e6e2e45-b85b-48fa-bcf5-b250f10f6529.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.953Z\",\"MediaKey\":\"68c8ce262383646b2a99679e\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":18,\"MediaObjectID\":\"18\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/06a5ca42-57da-4e08-b7dc-0e10ddcdaa01.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.97Z\",\"MediaKey\":\"68c8ce262383646b2a99679f\"},{\"ResourceRecordKey\":\"NST7802704\",\"Order\":19,\"MediaObjectID\":\"19\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802704/cb20c3f2-9e24-4d54-8392-7406192d8e98.jpeg\",\"MediaModificationTimestamp\":\"2025-09-16T02:40:37.954Z\",\"MediaKey\":\"68c8ce262383646b2a9967a0\"}]","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":""}