List of Showrooms in South Carolina

[
  {
    "name": "Charleston Hardware Co.",
    "address": "42**********",
    "phone": "********8626",
    "email": "Co*****@CH******",
    "lat": 32.845237,
    "lng": -80.00494,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "North Charleston",
    "star_count": 4.8,
    "rating_count": 60,
    "category_name": "Heritage preservations,Showrooms,Building restoration services,Antique stores,Hardware stores"
  },
  {
    "name": "Fritz Porter",
    "address": "20**********",
    "phone": "********4804",
    "email": "sh********@fr**********",
    "lat": 32.863789,
    "lng": -79.968856,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "North Charleston",
    "star_count": 4.6,
    "rating_count": 14,
    "category_name": "Interior designers,Fabric stores,Furniture stores,Home goods stores,Showrooms,Lamp shade suppliers"
  },
  {
    "name": "Athena Surfaces",
    "address": "21**********",
    "phone": "********0559",
    "email": "",
    "lat": 32.4434774,
    "lng": -80.6905661,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Beaufort",
    "star_count": 4.4,
    "rating_count": 5,
    "category_name": "Showrooms,Display home centers,Home improvement stores,Kitchen remodelers,Kitchen supply stores,Countertop stores,Bathroom remodelers"
  },
  {
    "name": "Bath and Bronze",
    "address": "12**********",
    "phone": "********5591",
    "email": "",
    "lat": 34.0865452,
    "lng": -81.1825454,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Irmo",
    "star_count": 5,
    "rating_count": 14,
    "category_name": "Interior designers,Kitchen supply stores,Appliance stores,Showrooms,Sauna stores,Bathroom supply stores,Appliance parts suppliers"
  },
  {
    "name": "TRD Floor Supplies Showroom",
    "address": "56**********",
    "phone": "********7887",
    "email": "",
    "lat": 32.8970453,
    "lng": -80.017209,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Hanahan",
    "star_count": 5,
    "rating_count": 16,
    "category_name": "Showrooms"
  },
  {
    "name": "Sims-Lohman - Charleston Kitchen Showroom & Distribution Facility (fomerly The Legacy Cabinet Company)",
    "address": "47**********",
    "phone": "********5901",
    "email": "",
    "lat": 32.877709,
    "lng": -80.0041706,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "North Charleston",
    "star_count": 5,
    "rating_count": 0,
    "category_name": "Showrooms"
  },
  {
    "name": "Gateway Supply",
    "address": "13**********",
    "phone": "********7160",
    "email": "in**@ga**********",
    "lat": 33.980175,
    "lng": -81.0252685,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Columbia",
    "star_count": 4.7,
    "rating_count": 0,
    "category_name": "Kitchen supply stores,Hardware stores,Plumbing supply stores,Air conditioning stores,Air conditioning system suppliers,Air compressor suppliers,Bathroom supply stores,Heating equipment suppliers,Showrooms"
  },
  {
    "name": "Gateway Supply",
    "address": "23**********",
    "phone": "********7993",
    "email": "in**@ga**********",
    "lat": 32.3189081,
    "lng": -80.9404573,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Hardeeville",
    "star_count": 4.6,
    "rating_count": 6,
    "category_name": "Heating equipment suppliers,Showrooms,Plumbing supply stores"
  },
  {
    "name": "Carpenter Hands LLC",
    "address": "37**********",
    "phone": "********5580",
    "email": "se**@ca**********",
    "lat": 34.5051995,
    "lng": -82.7215099,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Anderson",
    "star_count": 4.4,
    "rating_count": 0,
    "category_name": "Bathroom remodelers,Remodelers,Kitchen remodelers,Showrooms,Contractors"
  },
  {
    "name": "AVANTI TILE & STONE",
    "address": "30**********",
    "phone": "********9677",
    "email": "av**********@cs****",
    "lat": 35.0736001,
    "lng": -80.9348847,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Fort Mill",
    "star_count": 4.7,
    "rating_count": 0,
    "category_name": "Remodelers,Kitchen remodelers,Tile contractors,Contractors,Flooring contractors,Countertop contractors,Showrooms,Bathroom remodelers,Wood and laminate flooring suppliers,Wood floor installation services"
  }
]