List of Showrooms in Michigan

[
  {
    "name": "Investment Classics, LLC.",
    "address": "Ne**********",
    "phone": "********6000",
    "email": "ro*@in**********",
    "lat": 42.6602325,
    "lng": -86.1647754,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": null,
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Showrooms"
  },
  {
    "name": "Investment Classics, LLC.",
    "address": "35**********",
    "phone": "********6000",
    "email": "ro*@in**********",
    "lat": 42.676512,
    "lng": -86.1870557,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": null,
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Showrooms"
  },
  {
    "name": "Premier Kitchen & Bath Gallery",
    "address": "10**********",
    "phone": "********8585",
    "email": "",
    "lat": 43.6550135,
    "lng": -84.2154052,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": "Midland",
    "star_count": 5,
    "rating_count": 8,
    "category_name": "Bathroom remodelers,Cabinet stores,Showrooms,Interior designers,Kitchen remodelers,Plumbing supply stores,Countertop stores"
  },
  {
    "name": "Michigan Dutch Barns",
    "address": "67**********",
    "phone": "********0040",
    "email": "",
    "lat": 42.889375,
    "lng": -85.0750931,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Showrooms"
  },
  {
    "name": "H.J. Oldenkamp Co.",
    "address": "48**********",
    "phone": "********0600",
    "email": "in**@ol**********",
    "lat": 42.534943,
    "lng": -83.1816617,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": "Detroit",
    "star_count": 4.1,
    "rating_count": 43,
    "category_name": "Kitchen remodelers,Countertop stores,Building materials suppliers,Bathroom remodelers,Cabinet stores,Showrooms"
  },
  {
    "name": "LC Powersports & Marine",
    "address": "21**********",
    "phone": "********6196",
    "email": "in**@lc**********",
    "lat": 44.3071919,
    "lng": -85.2159132,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": null,
    "star_count": 4.5,
    "rating_count": 52,
    "category_name": "Boat accessories suppliers,Boat storage facilities,Marinas,Outdoor clothing and equipment shops,Snowmobile dealers,Showrooms,Powersports vehicle dealers"
  },
  {
    "name": "Blue Water Cabinetry & Design",
    "address": "48**********",
    "phone": "********2293",
    "email": "in**@bl**********",
    "lat": 43.164093,
    "lng": -86.1948089,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": "Fruitport",
    "star_count": 4.6,
    "rating_count": 22,
    "category_name": "Cabinet stores,Showrooms,Countertop stores,Kitchen supply stores"
  },
  {
    "name": "Studio G Inc.",
    "address": "14**********",
    "phone": "********3740",
    "email": "ma*******@st**********",
    "lat": 43.0734532,
    "lng": -86.1590007,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": "Spring Lake",
    "star_count": 4.1,
    "rating_count": 40,
    "category_name": "Glass shops,Showrooms,Glass & mirror shops"
  },
  {
    "name": "Mattress Firm Kalamazoo",
    "address": "56**********",
    "phone": "********6255",
    "email": "",
    "lat": 42.2954665,
    "lng": -85.6593892,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": null,
    "star_count": 4.8,
    "rating_count": 286,
    "category_name": "Children's furniture stores,Mattress stores,Bed shops,Showrooms"
  },
  {
    "name": "Mattress Firm Portage",
    "address": "61**********",
    "phone": "********0471",
    "email": "",
    "lat": 42.227817,
    "lng": -85.5890292,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": "Portage",
    "star_count": 4.8,
    "rating_count": 371,
    "category_name": "Children's furniture stores,Mattress stores,Bed shops,Showrooms"
  }
]