List of Showrooms in Michigan

[
  {
    "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": "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": "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.2,
    "rating_count": 56,
    "category_name": "Kitchen remodelers,Countertop stores,Building materials suppliers,Bathroom remodelers,Showrooms,Cabinet stores"
  },
  {
    "name": "Advance Plumbing & Heating Supply Co",
    "address": "19**********",
    "phone": "********7474",
    "email": "Sa***@ad**********",
    "lat": 42.5405369,
    "lng": -83.4639955,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": "Detroit",
    "star_count": 4.5,
    "rating_count": 95,
    "category_name": "Showrooms,Bathroom supply stores,Heating equipment suppliers,Plumbing supply stores,Kitchen supply stores,Wholesalers"
  },
  {
    "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.4,
    "rating_count": 58,
    "category_name": "Outdoor clothing and equipment shops,Snowmobile dealers,Boat storage facilities,Marinas,Boat accessories suppliers,Powersports vehicle dealers,Showrooms"
  },
  {
    "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.5,
    "rating_count": 21,
    "category_name": "Building materials suppliers,Showrooms,Cabinet stores,Countertop stores,Kitchen supply stores,Home improvement stores,Interior designers"
  },
  {
    "name": "R. A. Townsend Company",
    "address": "28**********",
    "phone": "********7000",
    "email": "in**@ra**********",
    "lat": 43.4648939,
    "lng": -83.9722133,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": "Saginaw",
    "star_count": 4.9,
    "rating_count": 12,
    "category_name": "Bathroom supply stores,Showrooms,Plumbing supply stores"
  },
  {
    "name": "Italcasa Furniture & Interior Design",
    "address": "32**********",
    "phone": "********4608",
    "email": "sh**@it*********",
    "lat": 42.5316518,
    "lng": -83.1987972,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": "Detroit",
    "star_count": 5,
    "rating_count": 92,
    "category_name": "Office furniture stores,Furniture rental services,Showrooms,Exterior shops,Outdoor furniture stores,Kitchen furniture stores,Furniture Rental Stores,Furniture accessories,Bedroom furniture stores,Interior designers,Furniture stores,Lighting wholesalers,Lighting stores"
  },
  {
    "name": "Italcasa Furniture & Interior Design - Michigan Design Center",
    "address": "17**********",
    "phone": "********4608",
    "email": "sh**@it*********",
    "lat": 42.5518897,
    "lng": -83.177461,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": "Detroit",
    "star_count": 5,
    "rating_count": 37,
    "category_name": "Interior designers,Architects,Home goods stores,Lighting wholesalers,Lighting stores,Furniture stores,Furniture rental services,Showrooms,Office furniture stores,Furniture Rental Stores,Furniture accessories,Bedroom furniture stores"
  }
]