{"Id":617222,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7138152","MLSAGENTID":"NST502023702","MLSCOAGENTID":"NST506019146","MLSOFFICEID":"NST26011","ADDRESS":"1197 Burke Avenue W","ACRES":0.232,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Unfinished","BATHSTOTAL":1.0,"BEDROOMS":2.0,"CITY":"Roseville","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":349999.0,"LASTPRICEDATE":"2026-09-25T13:35:07.8","LATITUDE":45.005708,"LENDEROWNED":"No","LISTDATE":"2026-09-25T05:00:00","LISTPRICE":349999.0,"LIVINGAREA":1152.0,"LONGITUDE":-93.150617,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-09-25T14:02:07.304","OFFICE_OFFICENAME":"JPW Realty","OUTBUILDINGS":"Storage Shed","PHOTOCOUNT":16,"POSTALCODE":"55113","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Buying your first home shouldn't mean inheriting someone else's to-do list, this homes behind-the-scenes work is already done: a new roof, gutters, and fascia (2023), foundation repair with a wall seal and sump pump system (2026), professional asbestos remediation, a cleaned water main, and a newer water heater and AC. Inside, you'll find a fully renovated kitchen, refinished hardwood floors, fresh paint and updated light fixtures throughout. This one will go fast!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"623-Roseville","SCHOOLDISTRICTPHONE":"6516351600","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-09-25T13:35:07.8","LASTSTATUS":"Active","STREETDIRSUFFIX":"W","STREETNAME":"Burke","STREETNUMBER":"1197","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1949,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-09-25T14:02:07.304","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","SOURCE":"MG_NST"}
{"ListingKey":"NST7964281","NST_AboveGradeSqFtTotal":"1152","AboveGradeFinishedArea":"1152","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s),Hardwood Floors,Kitchen Center Island,Kitchen Window,Patio,Vaulted Ceiling(s)","Appliances":"Dishwasher,Disposal,Dryer,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","Basement":"Unfinished","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"952","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Roseville","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Eat In Kitchen","Directions":"MN36 E exit toward Hamline Ave, left on Commerce St, right on Hamline Ave N, left on County B Rd W, right on Fernwood St, left on Burke Ave and the home will be on the left.","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-09-25T13:35:07.801Z","DaysOnMarket":"0","ExteriorFeatures":"Wood","Fencing":"Wood","FireplaceFeatures":"Living Room,Stone,Wood Burning","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"952","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"240","NST_GarageDimensions":"20x12","GarageSpaces":"1","Heating":"Forced Air","HighSchoolDistrict":"Roseville","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.005708","LaundryFeatures":"In Basement","NST_LenderOwned":"No","Levels":"One","ListPrice":"349999","ListingContractDate":"2026-09-25T05:00:00Z","ListingId":"NST7138152","LivingArea":"1152","Longitude":"-93.150617","LotFeatures":"Public Transit (w/in 6 blks),Tree Coverage - Light","LotSizeArea":"0.232","LotSizeDimensions":"78x130","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1152","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-09-25T08:34:24Z","OtherStructures":"Storage Shed","ParcelNumber":"152923110016","ParkingFeatures":"Attached Garage","PhotosCount":"16","PhotosChangeTimestamp":"2026-09-25T14:02:07.304Z","PostalCity":"Roseville","PostalCode":"55113","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Buying your first home shouldn't mean inheriting someone else's to-do list, this homes behind-the-scenes work is already done: a new roof, gutters, and fascia (2023), foundation repair with a wall seal and sump pump system (2026), professional asbestos remediation, a cleaned water main, and a newer water heater and AC. Inside, you'll find a fully renovated kitchen, refinished hardwood floors, fresh paint and updated light fixtures throughout. This one will go fast!","PublicSurveyRange":"23","PublicSurveySection":"15","PublicSurveyTownship":"29","RoadFrontageType":"City Street,Curbs,Paved Streets","NST_SchoolDistrictFullName":"623 - Roseville","NST_SchoolDistrictNumber":"623","NST_SchoolDistrictPhone":"6516351600","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"W","StreetName":"Burke","StreetNumber":"1197","StreetNumberNumeric":"1197","StreetSuffix":"Avenue","SubdivisionName":"Kellers Mayflower Park","TaxAnnualAmount":"5224","NST_TaxWithAssessments":"5224","TaxYear":"2026","NST_TotalArea":"2104","BuildingAreaTotal":"2104","Township":"Roseville","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1949","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST506054","CoListAgentMlsId":"NST506019146","CoListOfficeName":"JPW Realty","ListAgentKey":"NST62160","ListAgentMlsId":"NST502023702","ListOfficeMlsId":"NST26011","ListOfficeName":"JPW Realty","ListOfficeKey":"NST26011","ModificationTimestamp":"2026-09-25T14:02:07.304Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7964281\",\"MediaURL\":\"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/ae55d131-19cf-4b1e-aba3-5f0a7fc84894.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-09-25T14:01:11.208Z\",\"MediaKey\":\"NST125085853\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7964281\",\"MediaURL\":\"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/dca16a35-9176-4dd5-886b-8154bb40dac9.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-09-25T13:55:09.985Z\",\"MediaKey\":\"NST125085862\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7964281\",\"MediaURL\":\"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/ef83d1de-c00a-429f-9e1c-d9d53ee4a55a.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-09-25T13:55:09.974Z\",\"MediaKey\":\"NST125085861\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7964281\",\"MediaURL\":\"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/adb42025-816e-4750-aeb7-08daa9cdff94.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-09-25T13:55:10.007Z\",\"MediaKey\":\"NST125085866\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7964281\",\"MediaURL\":\"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/30487ebd-dfd0-4daa-ac48-28bdb15e10ff.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-09-25T14:01:11.251Z\",\"MediaKey\":\"NST125085854\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7964281\",\"MediaURL\":\"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/0a2a7fea-723f-4ab0-b498-e99b35882e1b.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-09-25T14:01:11.231Z\",\"MediaKey\":\"NST125085857\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7964281\",\"MediaURL\":\"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/eac8196f-de53-40c8-9f7b-274d85760853.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-09-25T14:01:11.239Z\",\"MediaKey\":\"NST125085856\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7964281\",\"MediaURL\":\"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/6dbd40fe-f3ff-487b-83db-ecdeec8b030a.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-09-25T13:55:10.003Z\",\"MediaKey\":\"NST125085859\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7964281\",\"MediaURL\":\"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/e40f0460-40e8-4815-bd60-ce29abf586a2.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-09-25T13:23:06.241Z\",\"MediaKey\":\"NST125085841\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7964281\",\"MediaURL\":\"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/f0918c46-be71-4d4c-b9e4-17f80509d4b2.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-09-25T13:55:10.009Z\",\"MediaKey\":\"NST125085867\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7964281\",\"MediaURL\":\"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/ed37023f-2442-4555-84a2-82d1d575cdde.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-09-25T13:55:10.01Z\",\"MediaKey\":\"NST125085869\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7964281\",\"MediaURL\":\"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/106c5214-63e5-486a-8938-547886758bb4.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-09-25T13:55:10.009Z\",\"MediaKey\":\"NST125085870\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7964281\",\"MediaURL\":\"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/3320fc98-baea-4bd0-a633-91ebb843ca7e.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-09-25T14:01:11.273Z\",\"MediaKey\":\"NST125085921\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"ResourceRecordKey\":\"NST7964281\",\"MediaURL\":\"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/3ac3710a-bdfd-4341-9664-d77692046f26.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-09-25T14:01:11.256Z\",\"MediaKey\":\"NST125085917\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7964281\",\"MediaURL\":\"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/86d410a5-5aee-4fdd-a4f3-c1fe152c259d.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-09-25T14:01:11.266Z\",\"MediaKey\":\"NST125085920\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7964281\",\"MediaURL\":\"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/496bb8a6-6d36-4222-a2e5-af5900542e2e.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaModificationTimestamp\":\"2026-09-25T14:01:11.251Z\",\"MediaKey\":\"NST125086621\"}]","Media__Order":"13","Media__MediaObjectID":"NST13","Media__ResourceRecordKey":"NST7964281","Media__MediaURL":"https://media.mlsgrid.com/token=ef1LSH94x0okTC8lH3ApLKGgegFJSbUipZq4NRazLXs&expires=1790348924&id=5d6fc86794c5224544394849/images/NST7964281/ae55d131-19cf-4b1e-aba3-5f0a7fc84894.jpeg","Media__ImageWidth":"2048","Media__ImageHeight":"1366","Media__ImageSizeDescription":"2048x1366","Media__MediaModificationTimestamp":"9/25/2026 2:01:11 PM","Media__MediaKey":"NST125085853","Rooms":"[{\"RoomDimensions\":\"15x10\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116699229\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"14x12\",\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116699228\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"19x14\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116699227\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"20x10\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116699231\",\"RoomType\":\"Mud Room\",\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"14x10\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116699230\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\"}]","Rooms__RoomDimensions":"15x10","Rooms__NST_RoomSortOrder":"3","Rooms__RoomKey":"NST116699229","Rooms__RoomType":"Bedroom","Rooms__RoomLevel":"Main","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","CustomVTourURL":""}