{"Id":1423697,"ORGTABLE":"RAW_Property","MLSCLASS":"COM","MLSNUMBER":"NST6804262","MLSAGENTID":"NST506093371","MLSOFFICEID":"NST9990","ADDRESS":"2345 County Road H2","ACRES":0.38,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Full,Concrete,Partially Finished,Storage Space","CITY":"Mounds View","CONTINGENCY":"None","COUNTY":"Ramsey","CURRENTUSE":"Commercial,Food Service,Other,Residential,Retail,Bar/Tavern","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Wood Siding","FORECLOSURE":"No","LASTPRICE":499999.0,"LASTPRICEDATE":"2025-10-21T18:37:03.777","LATITUDE":45.10103816,"LENDEROWNED":"No","LISTDATE":"2025-10-14T05:00:00","LISTPRICE":499999.0,"LIVINGAREA":5932.0,"LONGITUDE":-93.20061358,"LOTDESCRIPTION":"Corner Lot,Irregular Lot,Some Trees","MODIFICATIONTIMESTAMP":"2025-10-21T18:39:04.511","OFFICE_OFFICENAME":"Northstar Real Estate Associates","PHOTOCOUNT":17,"POSTALCODE":"55112","POTENTIALSHORTSALE":"No","PUBLICREMARKS":"Bring your own ideas & make it shine again! (Renewal license for 2026 submitted )Fire incident in August of 2025 in Liquor site. (Check the City ) Take advantage of this Prime Location - (Selling AS IS) . Bring your own Ideas and make it shine again. (Liquor , shopping Center , Restaurant)\n\nRenewal Liquor license in process for 2026. (Valid for 2025)","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Asphalt","SALEINCLUDES":"Building,Business","SCHOOLDISTRICTNUMBER":"621-Mounds View","SCHOOLDISTRICTPHONE":"651-621-6001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-10-21T18:37:03.777","LASTSTATUS":"Active","STREETNAME":"County Road H2","STREETNUMBER":"2345","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1952,"ZONING":"Business/Commercial,Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-10-21T18:36:03.796","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_2629.jpg\"},{\"Order\":2,\"Remarks\":\"IMG_2630.jpg\"},{\"Order\":3,\"Remarks\":\"IMG_2631.jpg\"},{\"Order\":4,\"Remarks\":\"IMG_4580.jpg\"},{\"Order\":5,\"Remarks\":\"IMG_4581.JPG\"},{\"Order\":6,\"Remarks\":\"IMG_4582.jpg\"},{\"Order\":7,\"Remarks\":\"IMG_6177.jpg\"},{\"Order\":8,\"Remarks\":\"IMG_6178.jpg\"},{\"Order\":9,\"Remarks\":\"IMG_6179.jpg\"},{\"Order\":10,\"Remarks\":\"IMG_6180.jpg\"},{\"Order\":11,\"Remarks\":\"IMG_6181.jpg\"},{\"Order\":12,\"Remarks\":\"IMG_6182.jpg\"},{\"Order\":13,\"Remarks\":\"IMG_6183.jpg\"},{\"Order\":14,\"Remarks\":\"IMG_6184.jpg\"},{\"Order\":15,\"Remarks\":\"IMG_6457.jpg\"},{\"Order\":16,\"Remarks\":\"IMG_6458.jpg\"},{\"Order\":17,\"Remarks\":\"IMG_6460.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","SOURCE":"MG_NST"}
{"ListingKey":"NST7815716","LotSizeArea":"0.38","NST_AgeOfProperty":"73","NST_AgentOwner":"Yes","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","AssociationAmenities":"Security","NST_AmenitiesUnit":"Ceiling Fan(s),Hardwood Floors,Security System,Tile Floors,Washer/Dryer Hookup","Appliances":"Cooktop,Dishwasher,Dryer,Electric Water Heater,Exhaust Fan,Freezer,Microwave,Range,Washer","NST_AssessmentPending":"No","Basement":"Full,Concrete,Partially Finished,Storage Space","BasementYN":"True","CarportSpaces":"0","City":"Mounds View","PropertyType":"Commercial Sale","Contingency":"None","Cooling":"Central Air,Wall Unit(s),Window Unit(s)","CountyOrParish":"Ramsey","CurrentUse":"Commercial,Food Service,Other,Residential,Retail,Bar/Tavern","Directions":"I35E N to I-694 W/US-10 W to Mounds View Blvd in Arden Hills, take the County 10 exit from US-10 W, follow Mounds View Blvd to County\nRd H2 in Mounds View.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ElectricExpense":"6000","FuelExpense":"6000","InsuranceExpense":"8000","TrashExpense":"2500","WaterSewerExpense":"3000","ConstructionMaterials":"Brick/Stone,Wood Siding","NST_ForeclosureStatus":"No","FoundationArea":"4762","NST_FractionalOwnershipYN":"No","RoadFrontageType":"County Road,Cul De Sac,Curbs,Paved Streets,Highway","NST_Fuel":"Electric,Natural Gas","ParkingFeatures":"Attached Garage,Asphalt,Paved","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-10-21T18:34:01Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-10-21","Latitude":"45.101038157","NST_LenderOwned":"No","ListAgentKey":"NST54051","ListAgentMlsId":"NST506093371","ListingContractDate":"2025-10-14T05:00:00Z","ListOfficeKey":"NST15562","ListOfficeName":"Northstar Real Estate Associates","ListOfficeMlsId":"NST9990","ListPrice":"499999","LockBoxType":"Combo","Longitude":"-93.2006135799","LotFeatures":"Corner Lot,Irregular Lot,Some Trees","LotSizeDimensions":"163x74x86x57x169","LotSizeUnits":"Square Feet","ListingId":"NST6804262","SourceSystemName":"RMLS","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","NST_OwnerOccupied":"Yes","OwnerPays":"All Utilities","ParcelNumber":"083023240021","GarageSpaces":"2","NST_ParkingOpen":"18","PhotosCount":"17","PostalCity":"Mounds View","PostalCode":"55112","NST_PotentialShortSale":"No","PublicRemarks":"Bring your own ideas & make it shine again! (Renewal license for 2026 submitted )Fire incident in August of 2025 in Liquor site. (Check the City ) Take advantage of this Prime Location - (Selling AS IS) . Bring your own Ideas and make it shine again. (Liquor , shopping Center , Restaurant)\n\nRenewal Liquor license in process for 2026. (Valid for 2025)","PublicSurveyRange":"23","PublicSurveySection":"08","PublicSurveyTownship":"30","NST_RangeNum":"One","NST_RefrigeratorNum":"One","NST_RentalLicenseYN":"No","Roof":"Age Over 8 Years,Asphalt","Inclusions":"Building,Business","HighSchoolDistrict":"Mounds View","NST_SchoolDistrictNumber":"621","NST_SchoolDistrictPhone":"651-621-6001","Sewer":"City Sewer/Connected","BuildingAreaTotal":"5932","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"County Road H2","StreetNumber":"2345","StreetNumberNumeric":"2345","SubdivisionName":"Pinewood Terrace 2","NST_TaxWithAssessments":"13504.0000","TaxYear":"2025","TaxAnnualAmount":"13504","TenantPays":"All Utilities,Gas,Other","NumberOfUnitsTotal":"2","Utilities":"Heating Separate","WaterSource":"City Water/Connected","YearBuilt":"1952","ZoningDescription":"Business/Commercial,Residential-Multi-Family","ModificationTimestamp":"2025-10-21T18:39:04.511Z","PhotosChangeTimestamp":"2025-10-21T18:36:03.796Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7815716\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"IMG_2629.jpg\",\"ImageWidth\":1440,\"ImageHeight\":817,\"ImageSizeDescription\":\"1440x817\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/f41ad794-d2f1-4856-aaaa-925e22369147.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.598Z\",\"MediaKey\":\"68f7d291c78ba62e7744e749\"},{\"ResourceRecordKey\":\"NST7815716\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"IMG_2630.jpg\",\"ImageWidth\":1440,\"ImageHeight\":1078,\"ImageSizeDescription\":\"1440x1078\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/9aad92c6-6b2a-42c9-a533-abcdaf2b24c7.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.598Z\",\"MediaKey\":\"68f7d291c78ba62e7744e74a\"},{\"ResourceRecordKey\":\"NST7815716\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"IMG_2631.jpg\",\"ImageWidth\":1440,\"ImageHeight\":907,\"ImageSizeDescription\":\"1440x907\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/87c3c0f1-c509-44f1-b3a8-06321d50df1e.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.618Z\",\"MediaKey\":\"68f7d291c78ba62e7744e74b\"},{\"ResourceRecordKey\":\"NST7815716\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"IMG_4580.jpg\",\"ImageWidth\":1440,\"ImageHeight\":1078,\"ImageSizeDescription\":\"1440x1078\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/fe985f98-103c-481d-b6ff-30a4bee61493.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.597Z\",\"MediaKey\":\"68f7d291c78ba62e7744e74c\"},{\"ResourceRecordKey\":\"NST7815716\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"IMG_4581.JPG\",\"ImageWidth\":1440,\"ImageHeight\":1078,\"ImageSizeDescription\":\"1440x1078\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/7499b805-83ef-4265-b09a-596cc352b2fe.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.651Z\",\"MediaKey\":\"68f7d291c78ba62e7744e74d\"},{\"ResourceRecordKey\":\"NST7815716\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"IMG_4582.jpg\",\"ImageWidth\":1440,\"ImageHeight\":1078,\"ImageSizeDescription\":\"1440x1078\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/65a605e3-99ea-4c0a-bf32-2c657270dd89.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.598Z\",\"MediaKey\":\"68f7d291c78ba62e7744e74e\"},{\"ResourceRecordKey\":\"NST7815716\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"IMG_6177.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/1fc1ffa5-64d8-4288-8fc0-2393cefdd004.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.598Z\",\"MediaKey\":\"68f7d291c78ba62e7744e74f\"},{\"ResourceRecordKey\":\"NST7815716\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"IMG_6178.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/92d97f18-b59c-4c0e-a14e-f915112b7cc4.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.623Z\",\"MediaKey\":\"68f7d291c78ba62e7744e750\"},{\"ResourceRecordKey\":\"NST7815716\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"IMG_6179.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/03185a60-56c0-4873-8df0-e374bcc9629f.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.573Z\",\"MediaKey\":\"68f7d291c78ba62e7744e751\"},{\"ResourceRecordKey\":\"NST7815716\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"IMG_6180.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/0814afa3-849c-4488-b946-fe4b6e5625a4.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.571Z\",\"MediaKey\":\"68f7d291c78ba62e7744e752\"},{\"ResourceRecordKey\":\"NST7815716\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"IMG_6181.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/ea43305f-1841-4eed-a540-65bcd7a26e47.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.697Z\",\"MediaKey\":\"68f7d291c78ba62e7744e753\"},{\"ResourceRecordKey\":\"NST7815716\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"IMG_6182.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/046da24b-615a-49e2-999d-e82e57dd89d1.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.573Z\",\"MediaKey\":\"68f7d291c78ba62e7744e754\"},{\"ResourceRecordKey\":\"NST7815716\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"IMG_6183.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/52db2630-571e-4f9e-aa87-26e74d0b61c4.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.598Z\",\"MediaKey\":\"68f7d291c78ba62e7744e755\"},{\"ResourceRecordKey\":\"NST7815716\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"IMG_6184.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/57b22b7e-d5a6-41b0-aff1-bae9d61eb92c.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.598Z\",\"MediaKey\":\"68f7d291c78ba62e7744e756\"},{\"ResourceRecordKey\":\"NST7815716\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"IMG_6457.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/96ffc4f2-49e2-42f8-bb46-8aec24fb4bbb.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.618Z\",\"MediaKey\":\"68f7d291c78ba62e7744e757\"},{\"ResourceRecordKey\":\"NST7815716\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"IMG_6458.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/d1e2d351-7b15-400d-ad39-9a148f17ec8f.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.606Z\",\"MediaKey\":\"68f7d291c78ba62e7744e758\"},{\"ResourceRecordKey\":\"NST7815716\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"IMG_6460.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815716/3fdfb439-f6bb-4a7c-9574-56b5602d9ab9.jpeg\",\"MediaModificationTimestamp\":\"2025-10-21T18:36:01.606Z\",\"MediaKey\":\"68f7d291c78ba62e7744e759\"}]","UnitTypes":"[{\"UnitTypeBedsTotal\":5,\"NST_UnitBathFull\":\"1\",\"NST_UnitBathHalf\":\"1\",\"UnitTypeKey\":\"NST19706\",\"UnitTypeActualRent\":3000,\"UnitTypeBathsTotal\":2,\"NST_UnitID\":\"1\",\"NST_UnitIsLeased\":\"0\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_2629.jpg\"},{\"Order\":2,\"Remarks\":\"IMG_2630.jpg\"},{\"Order\":3,\"Remarks\":\"IMG_2631.jpg\"},{\"Order\":4,\"Remarks\":\"IMG_4580.jpg\"},{\"Order\":5,\"Remarks\":\"IMG_4581.JPG\"},{\"Order\":6,\"Remarks\":\"IMG_4582.jpg\"},{\"Order\":7,\"Remarks\":\"IMG_6177.jpg\"},{\"Order\":8,\"Remarks\":\"IMG_6178.jpg\"},{\"Order\":9,\"Remarks\":\"IMG_6179.jpg\"},{\"Order\":10,\"Remarks\":\"IMG_6180.jpg\"},{\"Order\":11,\"Remarks\":\"IMG_6181.jpg\"},{\"Order\":12,\"Remarks\":\"IMG_6182.jpg\"},{\"Order\":13,\"Remarks\":\"IMG_6183.jpg\"},{\"Order\":14,\"Remarks\":\"IMG_6184.jpg\"},{\"Order\":15,\"Remarks\":\"IMG_6457.jpg\"},{\"Order\":16,\"Remarks\":\"IMG_6458.jpg\"},{\"Order\":17,\"Remarks\":\"IMG_6460.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","CustomVTourURL":""}