[{"latitude":"42.90738","longitude":"-77.29537","branchName":"Canandaigua","branchId":"548","branchCode":"MY_3","locality":"Canandaigua, NY 14424","street":"2567 Rochester Road","phone":"(585) 394-6710","faxNum":"","workHour":"Mon-Fri 7:00 AM - 5:00 PM \u003cbr\u003eSaturday 8:00 AM - 2:00 PM \u003cbr\u003eSunday Closed","note":"","email":"[email protected]","distance":0.0,"city":"Canandaigua","state":"NY","zip":"14424","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":548,"fieldName":"DC_NUMBER"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":548,"fieldName":"SHIPTO_ACCOUNT_NUMBER","customFieldvalue":"169490"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":548,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/3_Canandaigua.jpg"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":548,"fieldName":"HEPS_BRANCH_ID","customFieldvalue":"03"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":548,"fieldName":"ERP_WAREHOUSE_ID","customFieldvalue":"03"}],"warehouseImage":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/3_Canandaigua.jpg","serviceManager":"Mike Geldorf"},{"latitude":"42.88221156154791","longitude":"-76.93381749982831","branchName":"Waterloo","branchId":"549","branchCode":"MY_2","locality":"Waterloo, NY 13165","street":"0446 Waterloo-Geneva Road","phone":"(315) 789-4970","faxNum":"315-781-1861","workHour":"Mon-Fri 7:00 AM - 5:00 PM \u003cbr\u003eSaturday 8:00 AM - 2:00 PM \u003cbr\u003eSunday Closed","note":"","email":"[email protected]","distance":0.0,"city":"Waterloo","state":"NY","zip":"13165","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":549,"fieldName":"HEPS_BRANCH_ID","customFieldvalue":"02"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":549,"fieldName":"SHIPTO_ACCOUNT_NUMBER","customFieldvalue":"169490"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":549,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/2_Waterloo.jpg"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":549,"fieldName":"ERP_WAREHOUSE_ID","customFieldvalue":"02"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":549,"fieldName":"DC_NUMBER"}],"warehouseImage":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/2_Waterloo.jpg","serviceManager":"Tom Amitrano"},{"latitude":"42.14444","longitude":"-76.83042","branchName":"Elmira","branchId":"551","branchCode":"MY_4","locality":"Elmira, NY 14903","street":"2400 Corning Road","phone":"(607) 739-0427","faxNum":"","workHour":"Mon-Fri 7:00 AM - 5:00 PM \u003cbr\u003eSaturday 8:00 AM - 2:00 PM \u003cbr\u003eSunday Closed","note":"","email":"[email protected]","distance":0.0,"city":"Elmira","state":"NY","zip":"14903","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":551,"fieldName":"ERP_WAREHOUSE_ID","customFieldvalue":"04"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":551,"fieldName":"SHIPTO_ACCOUNT_NUMBER","customFieldvalue":"169490"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":551,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/4_ELMIRA.jpg"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":551,"fieldName":"DC_NUMBER"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":551,"fieldName":"HEPS_BRANCH_ID","customFieldvalue":"04"}],"warehouseImage":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/4_ELMIRA.jpg","serviceManager":"Eric Butterfield"},{"latitude":"42.66196","longitude":"-77.04863","branchName":"Penn Yan","branchId":"553","branchCode":"MY_5","locality":"Penn Yan, NY 14527","street":"225 East Elm Street","phone":"(315) 536-5072","faxNum":"","workHour":"Mon-Fri 7:00 AM - 5:00 PM \u003cbr\u003eSaturday 8:00 AM - 2:00 PM \u003cbr\u003eSunday Closed","note":"","email":"[email protected]","distance":0.0,"city":"Penn Yan","state":"NY","zip":"14527","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":553,"fieldName":"SHIPTO_ACCOUNT_NUMBER","customFieldvalue":"169490"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":553,"fieldName":"DC_NUMBER"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":553,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/5_Penn-Yan.jpg"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":553,"fieldName":"ERP_WAREHOUSE_ID","customFieldvalue":"05"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":553,"fieldName":"HEPS_BRANCH_ID","customFieldvalue":"05"}],"warehouseImage":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/5_Penn-Yan.jpg","serviceManager":"Scott Bowes"},{"latitude":"42.11677","longitude":"-77.94214","branchName":"Wellsville","branchId":"568","branchCode":"MY_6","locality":"Wellsville, NY 14895","street":"6 West Dyke Street","phone":"(585) 593-6119","faxNum":"","workHour":"Mon-Fri 7:00 AM - 5:00 PM \u003cbr\u003eSaturday 8:00 AM - 2:00 PM \u003cbr\u003eSunday Closed","note":"","email":"[email protected]","distance":0.0,"city":"Wellsville","state":"NY","zip":"14895","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":568,"fieldName":"DC_NUMBER"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":568,"fieldName":"HEPS_BRANCH_ID","customFieldvalue":"06"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":568,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/6_Wellsville.jpg"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":568,"fieldName":"ERP_WAREHOUSE_ID","customFieldvalue":"06"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":568,"fieldName":"SHIPTO_ACCOUNT_NUMBER","customFieldvalue":"169490"}],"warehouseImage":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/6_Wellsville.jpg","serviceManager":"Brandon Reed"},{"latitude":"42.33357","longitude":"-77.68012","branchName":"Hornell","branchId":"648","branchCode":"MY_8","locality":"Hornell, NY 14843","street":"1080 West Main Street","phone":"(607) 324-2254","faxNum":"","workHour":"Mon-Fri 7:00 AM - 5:00 PM \u003cbr\u003eSaturday 8:00 AM - 2:00 PM \u003cbr\u003eSunday Closed","note":"","email":"[email protected]","distance":0.0,"city":"Hornell","state":"NY","zip":"14843","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":648,"fieldName":"DC_NUMBER"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":648,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/8_Hornell.jpg"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":648,"fieldName":"HEPS_BRANCH_ID","customFieldvalue":"08"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":648,"fieldName":"ERP_WAREHOUSE_ID","customFieldvalue":"08"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":648,"fieldName":"SHIPTO_ACCOUNT_NUMBER","customFieldvalue":"169490"}],"warehouseImage":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/8_Hornell.jpg","serviceManager":"Lanny Herrick"},{"latitude":"42.56497","longitude":"-76.22276","branchName":"Cortland","branchId":"649","branchCode":"MY_9","locality":"Cortland, NY 13045","street":"797 Route 13","phone":"(607) 756-8871","faxNum":"","workHour":"Mon-Fri 7:00 AM - 5:00 PM \u003cbr\u003eSaturday 8:00 AM - 2:00 PM \u003cbr\u003eSunday Closed","note":"","email":"[email protected]","distance":0.0,"city":"Cortland","state":"NY","zip":"13045","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":649,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/9_Cortland.jpg"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":649,"fieldName":"HEPS_BRANCH_ID","customFieldvalue":"09"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":649,"fieldName":"DC_NUMBER"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":649,"fieldName":"ERP_WAREHOUSE_ID","customFieldvalue":"09"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":649,"fieldName":"SHIPTO_ACCOUNT_NUMBER","customFieldvalue":"169490"}],"warehouseImage":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/9_Cortland.jpg","serviceManager":"James Foster / Chris Smith"},{"latitude":"43.04812","longitude":"-77.06964","branchName":"Newark","branchId":"650","branchCode":"MY_A","locality":"Newark, NY 14513","street":"6592 Route 31 East","phone":"(315) 331-6710","faxNum":"","workHour":"Mon-Fri 7:00 AM - 5:00 PM \u003cbr\u003eSaturday 8:00 AM - 2:00 PM \u003cbr\u003eSunday Closed","note":"","email":"[email protected]","distance":0.0,"city":"Newark","state":"NY","zip":"14513","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":650,"fieldName":"DC_NUMBER"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":650,"fieldName":"SHIPTO_ACCOUNT_NUMBER","customFieldvalue":"169490"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":650,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/10_Newark.jpg"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":650,"fieldName":"ERP_WAREHOUSE_ID","customFieldvalue":"10"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":650,"fieldName":"HEPS_BRANCH_ID","customFieldvalue":"10"}],"warehouseImage":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/10_Newark.jpg","serviceManager":"Dan Quagliata"},{"latitude":"42.46849","longitude":"-76.40758","branchName":"Ithaca","branchId":"651","branchCode":"MY_B","locality":"Ithaca, NY 14850","street":"12 Utility Drive","phone":"(607) 347-4177","faxNum":"","workHour":"Mon-Fri 7:00 AM - 5:00 PM \u003cbr\u003eSaturday 8:00 AM - 2:00 PM \u003cbr\u003eSunday Closed","note":"","email":"[email protected]","distance":0.0,"city":"Ithaca","state":"NY","zip":"14850","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":651,"fieldName":"ERP_WAREHOUSE_ID","customFieldvalue":"11"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":651,"fieldName":"SHIPTO_ACCOUNT_NUMBER","customFieldvalue":"169490"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":651,"fieldName":"HEPS_BRANCH_ID","customFieldvalue":"11"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":651,"fieldName":"DC_NUMBER"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":651,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/11_Ithaca.jpg"}],"warehouseImage":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/11_Ithaca.jpg","serviceManager":"Clair Haus"},{"latitude":"42.96081","longitude":"-76.54078","branchName":"Auburn","branchId":"652","branchCode":"MY_C","locality":"Auburn, NY 13021","street":"341 Grant Avenue","phone":"(315) 252-8392","faxNum":"","workHour":"Mon-Fri 7:00 AM - 5:00 PM \u003cbr\u003eSaturday 8:00 AM - 2:00 PM \u003cbr\u003eSunday Closed","note":"","email":"[email protected]","distance":0.0,"city":"Auburn","state":"NY","zip":"13021","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":652,"fieldName":"DC_NUMBER"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":652,"fieldName":"HEPS_BRANCH_ID","customFieldvalue":"12"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":652,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/12_AUBURN.jpg"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":652,"fieldName":"SHIPTO_ACCOUNT_NUMBER","customFieldvalue":"169490"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":652,"fieldName":"ERP_WAREHOUSE_ID","customFieldvalue":"12"}],"warehouseImage":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/12_AUBURN.jpg","serviceManager":"Richard Tracy"},{"latitude":"41.99656","longitude":"-76.53126","branchName":"Sayre","branchId":"653","branchCode":"MY_D","locality":"Sayre, PA 18840","street":"507 North Keystone Avenue","phone":"(570) 888-5714","faxNum":"","workHour":"Mon-Fri 7:00 AM - 5:00 PM \u003cbr\u003eSaturday 8:00 AM - 2:00 PM \u003cbr\u003eSunday Closed","note":"","email":"[email protected]","distance":0.0,"city":"Sayre","state":"PA","zip":"18840","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":653,"fieldName":"HEPS_BRANCH_ID","customFieldvalue":"13"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":653,"fieldName":"DC_NUMBER"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":653,"fieldName":"ERP_WAREHOUSE_ID","customFieldvalue":"13"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":653,"fieldName":"SHIPTO_ACCOUNT_NUMBER","customFieldvalue":"169490"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":653,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/13_Sayre.jpg"}],"warehouseImage":"/ASSETS/WEB_THEMES/ORGILL_TEMPLATES/images/13_Sayre.jpg","serviceManager":"Mike Peet"}]

database