- 1-800-632-4576 MONDAY - FRIDAY 7AM - 5PM
- Nearby Store Grand Rapids
- Login / Register
Locations
[{"latitude":"42.3497092","longitude":"-83.0337148","branchName":"Detroit","branchId":"222","branchCode":"DETR","locality":"Detroit, MI 48207","street":"2158 Gratiot Avenue","phone":"313-481-1060","faxNum":"248-926-7927","workHour":"Mon–Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Detroit","state":"MI","zip":"48207","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":222,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":222,"fieldName":"Shipper_Number","customFieldvalue":"00003V8V53"}],"serviceManager":""},{"latitude":"42.8754098","longitude":"-85.6819969","branchName":"Grand Rapids","branchId":"1","branchCode":"GRPD","locality":"Grand Rapids, MI 49548","street":"4901 Clay Avenue, SW","phone":"616-241-5414","faxNum":"616-","workHour":"Mon–Fri 6 am–5:30 pm, Sat 7 am–12 pm, Sun Closed","note":"","email":"","distance":0.0,"city":"Grand Rapids","state":"MI","zip":"49548","country":"US","tollFreeNum":"855-839-8011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":1,"fieldName":"INFUSION_SHOWROOM"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":1,"fieldName":"Express Pickup Description","customFieldvalue":"Your order will be waiting at our ETNA Express, automated checkout location, within 45 minutes. ETNA Express is located at Dock 1, to the right of Returns, and the left of the counter area. When you enter, immediately to your left is the Checkout Tablet. Follow the directions there to locate your product, sign for it, and go. For assistance with loading or other issues, call 616-867-5309."},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":1,"fieldName":"Shipper_Number","customFieldvalue":"459330"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":1,"fieldName":"Express Pick Up?","customFieldvalue":"Y"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":1,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/staticpage_Images/etnas_1st.jpg"}],"warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/staticpage_Images/etnas_1st.jpg","serviceManager":""},{"latitude":"42.267068","longitude":"-85.527018","branchName":"Kalamazoo","branchId":"2","branchCode":"KZOO","locality":"Kalamazoo, MI 49048","street":"5231 East ML Avenue","phone":"269-349-8388","faxNum":"269-349-3371","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Kalamazoo","state":"MI","zip":"49048","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":2,"fieldName":"Express Pick Up?","customFieldvalue":"Y"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":2,"fieldName":"Shipper_Number","customFieldvalue":"00008Y04R2"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":2,"fieldName":"Express Pickup Description","customFieldvalue":"Your order will be ready in 45 minutes or less, at the ETNA Express station. No need to wait in line. When you come in the store, go to the left, near the entrance to the warehouse, where you will see the ETNA Express tablet. Find your order on the tablet, pick it up off the shelf, sign for it and go! Note that large orders and large items may not be ready in the 45 minute window."},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":2,"fieldName":"INFUSION_SHOWROOM"}],"serviceManager":""},{"latitude":"44.73305","longitude":"-85.611571","branchName":"Traverse City","branchId":"3","branchCode":"TCTY","locality":"Traverse City, MI 49686","street":"1969 West South Airport Rd.","phone":"231-947-1300","faxNum":"231-947-3555","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Traverse City","state":"MI","zip":"49686","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":3,"fieldName":"INFUSION_SHOWROOM"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":3,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":3,"fieldName":"Shipper_Number","customFieldvalue":"0000X49383"}],"serviceManager":""},{"latitude":"42.323311","longitude":"-85.241078","branchName":"Battle Creek","branchId":"4","branchCode":"BCRK","locality":"Springfield, MI 49037","street":"1004 Upton Ave","phone":"269-962-1140","faxNum":"269-962-1170","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Springfield","state":"MI","zip":"49037","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":4,"fieldName":"Express Pick Up?","customFieldvalue":"Y"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":4,"fieldName":"Shipper_Number","customFieldvalue":"00008V9V06"}],"serviceManager":""},{"latitude":"42.797145","longitude":"-84.735251","branchName":"Grand Ledge","branchId":"5","branchCode":"GLDG","locality":"Grand Ledge, MI 48837","street":"10801 Grand River Hwy.","phone":"517-622-8696","faxNum":"517-622-8334","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Grand Ledge","state":"MI","zip":"48837","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":5,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":5,"fieldName":"INFUSION_SHOWROOM"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":5,"fieldName":"Shipper_Number","customFieldvalue":"00004221TT"}],"serviceManager":""},{"latitude":"42.514232","longitude":"-83.519654","branchName":"Wixom","branchId":"6","branchCode":"WIXM","locality":"Wixom, MI 48393","street":"29949 Beck Rd.","phone":"248-624-5000","faxNum":"248-624-9563","workHour":"Mon-Fri 6am-5pm, Sat 7am-12pm, Sun Closed","note":"","email":"","distance":0.0,"city":"Wixom","state":"MI","zip":"48393","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":6,"fieldName":"Shipper_Number","customFieldvalue":"698344"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":6,"fieldName":"INFUSION_SHOWROOM"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":6,"fieldName":"Express Pickup Description","customFieldvalue":"Your order will be waiting at our ETNA Express automated checkout location within 45 minutes. ETNA Express is located at the end of the loading docks – the location previously known as the pre-pull counter. When you enter to your right is the Checkout Tablet. Follow the directions there to locate your product, sign for it, and go. For assistance with loading or other issues, call 248-624-5000."},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":6,"fieldName":"Express Pick Up?","customFieldvalue":"Y"}],"serviceManager":""},{"latitude":"42.642556","longitude":"-82.833219","branchName":"Chesterfield","branchId":"7","branchCode":"CFLD","locality":"Chesterfield, MI 48047","street":"46555 Continental Dr.","phone":"586-949-2481","faxNum":"586-949-3480","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Chesterfield","state":"MI","zip":"48047","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":7,"fieldName":"Shipper_Number","customFieldvalue":"0000519R7Y"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":7,"fieldName":"Express Pick Up?","customFieldvalue":"N"}],"serviceManager":""},{"latitude":"43.582767","longitude":"-84.747435","branchName":"Mt. Pleasant","branchId":"8","branchCode":"MTPL","locality":"Mt. Pleasant, MI 48858","street":"3709 S. Isabella Rd.","phone":"989-772-5100","faxNum":"989-772-5133","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Mt. Pleasant","state":"MI","zip":"48858","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":8,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":8,"fieldName":"Shipper_Number","customFieldvalue":"0000114FE3"}],"serviceManager":""},{"latitude":"41.662716","longitude":"-86.270508","branchName":"South Bend","branchId":"9","branchCode":"SBND","locality":"South Bend, IN 46619","street":"1212 S. Walnut St.","phone":"574-287-0132","faxNum":"574-287-0131","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"South Bend","state":"IN","zip":"46619","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":9,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":9,"fieldName":"Shipper_Number","customFieldvalue":"0000A7Y581"}],"serviceManager":""},{"latitude":"43.009922","longitude":"-83.662394","branchName":"Flint","branchId":"10","branchCode":"FLNT","locality":"Flint, MI 48503","street":"2395 Lapeer Rd.","phone":"810-232-4760","faxNum":"810-232-4973","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Flint","state":"MI","zip":"48503","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":10,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":10,"fieldName":"Shipper_Number","customFieldvalue":"0000A578W0"}],"serviceManager":""},{"latitude":"43.186963","longitude":"-86.226507","branchName":"Muskegon","branchId":"11","branchCode":"MUSK","locality":"Muskegon, MI 49444","street":"3658 Airline Rd.","phone":"231-733-2640","faxNum":"231-733-0821","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Muskegon","state":"MI","zip":"49444","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":11,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":11,"fieldName":"Shipper_Number","customFieldvalue":"00008R93F7"}],"serviceManager":""},{"latitude":"41.624644","longitude":"-83.66054","branchName":"Toledo","branchId":"12","branchCode":"TOLD","locality":"Toledo, OH 43615","street":"5020 Angola Rd.","phone":"419-385-3500","faxNum":"419-385-3521","workHour":"Mon-Fri 7am-4pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Toledo","state":"OH","zip":"43615","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":12,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":12,"fieldName":"Shipper_Number","customFieldvalue":"0000885AX2"}],"serviceManager":""},{"latitude":"42.799639","longitude":"-86.074454","branchName":"Holland","branchId":"13","branchCode":"HOLL","locality":"Holland, MI 49423","street":"783 Chicago Dr.","phone":"616-396-1717","faxNum":"616-396-0852","workHour":"Mon-Fri 6am-5pm, Sat 7am-12pm, Sun Closed","note":"","email":"","distance":0.0,"city":"Holland","state":"MI","zip":"49423","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":13,"fieldName":"Shipper_Number","customFieldvalue":"000051522E"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":13,"fieldName":"INFUSION_SHOWROOM"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":13,"fieldName":"Express Pick Up?","customFieldvalue":"Y"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":13,"fieldName":"Express Pickup Description","customFieldvalue":"Your order will be waiting at our ETNA Express, automated checkout location, within 45 minutes. ETNA Express is located on the opposite side of the building from the counter entrance. When you enter, immediately to your right is the Checkout Tablet. Follow the directions there to locate your product, sign for it, and go. For assistance with loading or other issues, call 616-886-2314."}],"serviceManager":""},{"latitude":"43.447506","longitude":"-83.895103","branchName":"Saginaw","branchId":"14","branchCode":"SAGN","locality":"Saginaw, MI 48601","street":"1416 N. Outer Dr.","phone":"989-753-5893","faxNum":"989-753-8390","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Saginaw","state":"MI","zip":"48601","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":14,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":14,"fieldName":"Shipper_Number","customFieldvalue":"0000W2610W"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":14,"fieldName":"Express Pickup Description","customFieldvalue":"Your order will be ready for pickup at the ETNA Express station. This station is located inside the last warehouse door on the left (EAST most entrance, by the back of the building). Look for the ETNA Express sign on the door. Immediately to the right of the door, inside, is a tablet. Find your order on the tablet, sign for your order, grab it from the shelf beside the stand and go!"}],"serviceManager":""},{"latitude":"42.228404","longitude":"-84.393393","branchName":"Jackson","branchId":"15","branchCode":"JACK","locality":"Jackson, MI 49203","street":"411 E. Mansion St.","phone":"517-787-6043","faxNum":"517-787-6151","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Jackson","state":"MI","zip":"49203","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":15,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":15,"fieldName":"Shipper_Number","customFieldvalue":"00002W3580"}],"serviceManager":""},{"latitude":"46.473954","longitude":"-84.3539","branchName":"Sault Ste. Marie","branchId":"16","branchCode":"SSTM","locality":"Sault Ste. Marie, MI 49783","street":"515 W. 3 Mile Rd.","phone":"906-632-3019","faxNum":"906-632-1512","workHour":"Mon-Fri 7:30am-4:30pm, Sat \u0026 Sun Closed","note":"","email":"","distance":0.0,"city":"Sault Ste. Marie","state":"MI","zip":"49783","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":16,"fieldName":"Shipper_Number","customFieldvalue":"0000E64Y31"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":16,"fieldName":"Express Pick Up?","customFieldvalue":"Y"}],"serviceManager":""},{"latitude":"46.564411","longitude":"-87.413777","branchName":"Marquette","branchId":"17","branchCode":"MARQ","locality":"Marquette, MI 49855","street":"1922 Enterprise St.","phone":"906-273-2331","faxNum":"906-273-2326","workHour":"Mon-Fri 6:30am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Marquette","state":"MI","zip":"49855","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":17,"fieldName":"Shipper_Number","customFieldvalue":"000019203X"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":17,"fieldName":"Express Pick Up?","customFieldvalue":"Y"}],"serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Oklahoma City","branchId":"282","branchCode":"UTSO","locality":"Oklahoma City, OK 73127","street":"9636 West Reno","phone":"(866) 580-1818","faxNum":"","workHour":"","note":"","email":"","distance":0.0,"city":"Oklahoma City","state":"OK","zip":"73127","country":"US","tollFreeNum":"(866) 580-1818","serviceManager":""},{"latitude":"43.1545211","longitude":"-88.0041315","branchName":"Milwaukee","branchId":"262","branchCode":"MILW","locality":"Milwaukee, WI 53223","street":"7301 West Calumet Road","phone":"414-973-2220","faxNum":"","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Milwaukee","state":"WI","zip":"53223","country":"US","tollFreeNum":"","serviceManager":""}]
database
$googleSpreadSheetUrl
[{"latitude":"42.3497092","longitude":"-83.0337148","branchName":"Detroit","branchId":"222","branchCode":"DETR","locality":"Detroit, MI 48207","street":"2158 Gratiot Avenue","phone":"313-481-1060","faxNum":"248-926-7927","workHour":"Mon–Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Detroit","state":"MI","zip":"48207","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":222,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":222,"fieldName":"Shipper_Number","customFieldvalue":"00003V8V53"}],"serviceManager":""},{"latitude":"42.8754098","longitude":"-85.6819969","branchName":"Grand Rapids","branchId":"1","branchCode":"GRPD","locality":"Grand Rapids, MI 49548","street":"4901 Clay Avenue, SW","phone":"616-241-5414","faxNum":"616-","workHour":"Mon–Fri 6 am–5:30 pm, Sat 7 am–12 pm, Sun Closed","note":"","email":"","distance":0.0,"city":"Grand Rapids","state":"MI","zip":"49548","country":"US","tollFreeNum":"855-839-8011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":1,"fieldName":"INFUSION_SHOWROOM"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":1,"fieldName":"Express Pickup Description","customFieldvalue":"Your order will be waiting at our ETNA Express, automated checkout location, within 45 minutes. ETNA Express is located at Dock 1, to the right of Returns, and the left of the counter area. When you enter, immediately to your left is the Checkout Tablet. Follow the directions there to locate your product, sign for it, and go. For assistance with loading or other issues, call 616-867-5309."},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":1,"fieldName":"Shipper_Number","customFieldvalue":"459330"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":1,"fieldName":"Express Pick Up?","customFieldvalue":"Y"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":1,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/staticpage_Images/etnas_1st.jpg"}],"warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/staticpage_Images/etnas_1st.jpg","serviceManager":""},{"latitude":"42.267068","longitude":"-85.527018","branchName":"Kalamazoo","branchId":"2","branchCode":"KZOO","locality":"Kalamazoo, MI 49048","street":"5231 East ML Avenue","phone":"269-349-8388","faxNum":"269-349-3371","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Kalamazoo","state":"MI","zip":"49048","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":2,"fieldName":"Express Pick Up?","customFieldvalue":"Y"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":2,"fieldName":"Shipper_Number","customFieldvalue":"00008Y04R2"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":2,"fieldName":"Express Pickup Description","customFieldvalue":"Your order will be ready in 45 minutes or less, at the ETNA Express station. No need to wait in line. When you come in the store, go to the left, near the entrance to the warehouse, where you will see the ETNA Express tablet. Find your order on the tablet, pick it up off the shelf, sign for it and go! Note that large orders and large items may not be ready in the 45 minute window."},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":2,"fieldName":"INFUSION_SHOWROOM"}],"serviceManager":""},{"latitude":"44.73305","longitude":"-85.611571","branchName":"Traverse City","branchId":"3","branchCode":"TCTY","locality":"Traverse City, MI 49686","street":"1969 West South Airport Rd.","phone":"231-947-1300","faxNum":"231-947-3555","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Traverse City","state":"MI","zip":"49686","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":3,"fieldName":"INFUSION_SHOWROOM"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":3,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":3,"fieldName":"Shipper_Number","customFieldvalue":"0000X49383"}],"serviceManager":""},{"latitude":"42.323311","longitude":"-85.241078","branchName":"Battle Creek","branchId":"4","branchCode":"BCRK","locality":"Springfield, MI 49037","street":"1004 Upton Ave","phone":"269-962-1140","faxNum":"269-962-1170","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Springfield","state":"MI","zip":"49037","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":4,"fieldName":"Express Pick Up?","customFieldvalue":"Y"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":4,"fieldName":"Shipper_Number","customFieldvalue":"00008V9V06"}],"serviceManager":""},{"latitude":"42.797145","longitude":"-84.735251","branchName":"Grand Ledge","branchId":"5","branchCode":"GLDG","locality":"Grand Ledge, MI 48837","street":"10801 Grand River Hwy.","phone":"517-622-8696","faxNum":"517-622-8334","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Grand Ledge","state":"MI","zip":"48837","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":5,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":5,"fieldName":"INFUSION_SHOWROOM"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":5,"fieldName":"Shipper_Number","customFieldvalue":"00004221TT"}],"serviceManager":""},{"latitude":"42.514232","longitude":"-83.519654","branchName":"Wixom","branchId":"6","branchCode":"WIXM","locality":"Wixom, MI 48393","street":"29949 Beck Rd.","phone":"248-624-5000","faxNum":"248-624-9563","workHour":"Mon-Fri 6am-5pm, Sat 7am-12pm, Sun Closed","note":"","email":"","distance":0.0,"city":"Wixom","state":"MI","zip":"48393","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":6,"fieldName":"Shipper_Number","customFieldvalue":"698344"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":6,"fieldName":"INFUSION_SHOWROOM"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":6,"fieldName":"Express Pickup Description","customFieldvalue":"Your order will be waiting at our ETNA Express automated checkout location within 45 minutes. ETNA Express is located at the end of the loading docks – the location previously known as the pre-pull counter. When you enter to your right is the Checkout Tablet. Follow the directions there to locate your product, sign for it, and go. For assistance with loading or other issues, call 248-624-5000."},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":6,"fieldName":"Express Pick Up?","customFieldvalue":"Y"}],"serviceManager":""},{"latitude":"42.642556","longitude":"-82.833219","branchName":"Chesterfield","branchId":"7","branchCode":"CFLD","locality":"Chesterfield, MI 48047","street":"46555 Continental Dr.","phone":"586-949-2481","faxNum":"586-949-3480","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Chesterfield","state":"MI","zip":"48047","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":7,"fieldName":"Shipper_Number","customFieldvalue":"0000519R7Y"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":7,"fieldName":"Express Pick Up?","customFieldvalue":"N"}],"serviceManager":""},{"latitude":"43.582767","longitude":"-84.747435","branchName":"Mt. Pleasant","branchId":"8","branchCode":"MTPL","locality":"Mt. Pleasant, MI 48858","street":"3709 S. Isabella Rd.","phone":"989-772-5100","faxNum":"989-772-5133","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Mt. Pleasant","state":"MI","zip":"48858","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":8,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":8,"fieldName":"Shipper_Number","customFieldvalue":"0000114FE3"}],"serviceManager":""},{"latitude":"41.662716","longitude":"-86.270508","branchName":"South Bend","branchId":"9","branchCode":"SBND","locality":"South Bend, IN 46619","street":"1212 S. Walnut St.","phone":"574-287-0132","faxNum":"574-287-0131","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"South Bend","state":"IN","zip":"46619","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":9,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":9,"fieldName":"Shipper_Number","customFieldvalue":"0000A7Y581"}],"serviceManager":""},{"latitude":"43.009922","longitude":"-83.662394","branchName":"Flint","branchId":"10","branchCode":"FLNT","locality":"Flint, MI 48503","street":"2395 Lapeer Rd.","phone":"810-232-4760","faxNum":"810-232-4973","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Flint","state":"MI","zip":"48503","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":10,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":10,"fieldName":"Shipper_Number","customFieldvalue":"0000A578W0"}],"serviceManager":""},{"latitude":"43.186963","longitude":"-86.226507","branchName":"Muskegon","branchId":"11","branchCode":"MUSK","locality":"Muskegon, MI 49444","street":"3658 Airline Rd.","phone":"231-733-2640","faxNum":"231-733-0821","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Muskegon","state":"MI","zip":"49444","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":11,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":11,"fieldName":"Shipper_Number","customFieldvalue":"00008R93F7"}],"serviceManager":""},{"latitude":"41.624644","longitude":"-83.66054","branchName":"Toledo","branchId":"12","branchCode":"TOLD","locality":"Toledo, OH 43615","street":"5020 Angola Rd.","phone":"419-385-3500","faxNum":"419-385-3521","workHour":"Mon-Fri 7am-4pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Toledo","state":"OH","zip":"43615","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":12,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":12,"fieldName":"Shipper_Number","customFieldvalue":"0000885AX2"}],"serviceManager":""},{"latitude":"42.799639","longitude":"-86.074454","branchName":"Holland","branchId":"13","branchCode":"HOLL","locality":"Holland, MI 49423","street":"783 Chicago Dr.","phone":"616-396-1717","faxNum":"616-396-0852","workHour":"Mon-Fri 6am-5pm, Sat 7am-12pm, Sun Closed","note":"","email":"","distance":0.0,"city":"Holland","state":"MI","zip":"49423","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":13,"fieldName":"Shipper_Number","customFieldvalue":"000051522E"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":13,"fieldName":"INFUSION_SHOWROOM"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":13,"fieldName":"Express Pick Up?","customFieldvalue":"Y"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":13,"fieldName":"Express Pickup Description","customFieldvalue":"Your order will be waiting at our ETNA Express, automated checkout location, within 45 minutes. ETNA Express is located on the opposite side of the building from the counter entrance. When you enter, immediately to your right is the Checkout Tablet. Follow the directions there to locate your product, sign for it, and go. For assistance with loading or other issues, call 616-886-2314."}],"serviceManager":""},{"latitude":"43.447506","longitude":"-83.895103","branchName":"Saginaw","branchId":"14","branchCode":"SAGN","locality":"Saginaw, MI 48601","street":"1416 N. Outer Dr.","phone":"989-753-5893","faxNum":"989-753-8390","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Saginaw","state":"MI","zip":"48601","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":14,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":14,"fieldName":"Shipper_Number","customFieldvalue":"0000W2610W"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":14,"fieldName":"Express Pickup Description","customFieldvalue":"Your order will be ready for pickup at the ETNA Express station. This station is located inside the last warehouse door on the left (EAST most entrance, by the back of the building). Look for the ETNA Express sign on the door. Immediately to the right of the door, inside, is a tablet. Find your order on the tablet, sign for your order, grab it from the shelf beside the stand and go!"}],"serviceManager":""},{"latitude":"42.228404","longitude":"-84.393393","branchName":"Jackson","branchId":"15","branchCode":"JACK","locality":"Jackson, MI 49203","street":"411 E. Mansion St.","phone":"517-787-6043","faxNum":"517-787-6151","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Jackson","state":"MI","zip":"49203","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":15,"fieldName":"Express Pick Up?","customFieldvalue":"N"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":15,"fieldName":"Shipper_Number","customFieldvalue":"00002W3580"}],"serviceManager":""},{"latitude":"46.473954","longitude":"-84.3539","branchName":"Sault Ste. Marie","branchId":"16","branchCode":"SSTM","locality":"Sault Ste. Marie, MI 49783","street":"515 W. 3 Mile Rd.","phone":"906-632-3019","faxNum":"906-632-1512","workHour":"Mon-Fri 7:30am-4:30pm, Sat \u0026 Sun Closed","note":"","email":"","distance":0.0,"city":"Sault Ste. Marie","state":"MI","zip":"49783","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":16,"fieldName":"Shipper_Number","customFieldvalue":"0000E64Y31"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":16,"fieldName":"Express Pick Up?","customFieldvalue":"Y"}],"serviceManager":""},{"latitude":"46.564411","longitude":"-87.413777","branchName":"Marquette","branchId":"17","branchCode":"MARQ","locality":"Marquette, MI 49855","street":"1922 Enterprise St.","phone":"906-273-2331","faxNum":"906-273-2326","workHour":"Mon-Fri 6:30am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Marquette","state":"MI","zip":"49855","country":"US","tollFreeNum":"8558398011","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":17,"fieldName":"Shipper_Number","customFieldvalue":"000019203X"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":17,"fieldName":"Express Pick Up?","customFieldvalue":"Y"}],"serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Oklahoma City","branchId":"282","branchCode":"UTSO","locality":"Oklahoma City, OK 73127","street":"9636 West Reno","phone":"(866) 580-1818","faxNum":"","workHour":"","note":"","email":"","distance":0.0,"city":"Oklahoma City","state":"OK","zip":"73127","country":"US","tollFreeNum":"(866) 580-1818","serviceManager":""},{"latitude":"43.1545211","longitude":"-88.0041315","branchName":"Milwaukee","branchId":"262","branchCode":"MILW","locality":"Milwaukee, WI 53223","street":"7301 West Calumet Road","phone":"414-973-2220","faxNum":"","workHour":"Mon-Fri 7am-5pm, Sat-Sun Closed","note":"","email":"","distance":0.0,"city":"Milwaukee","state":"WI","zip":"53223","country":"US","tollFreeNum":"","serviceManager":""}]
database
$googleSpreadSheetUrl