[{"latitude":"44.4510948","longitude":"-73.1310494","branchName":"Williston, VT","branchId":"708","branchCode":"17","locality":"Williston, VT 05495","street":"150 Krupp Drive","phone":"802-489-7040","faxNum":"802-419-8343","workHour":"7 AM - 5 PM","note":"","email":"gschoonejogen@sgtorrice.com","distance":0.0,"city":"Williston","state":"VT","zip":"05495","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":708,"fieldName":"WorkingHours","customFieldvalue":"0"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":708,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/Williston-Branch.png"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":708,"fieldName":"DISPLAY_SEQUENCE","customFieldvalue":"15"}],"warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/Williston-Branch.png","serviceManager":"George Schoonejogen","displaySequence":"15"},{"latitude":"42.5326","longitude":"-71.13949","branchName":"Wilmington, MA HQ","branchId":"688","branchCode":"2","locality":"Wilmington, MA 01887","street":"80 Industrial Way","phone":"978-657-7779","faxNum":"978-657-4044","workHour":"7 AM - 5 PM","note":"Monday - Friday","email":"bpomroy@sgtorrice.com","distance":0.0,"city":"Wilmington","state":"MA","zip":"01887","country":"US","tollFreeNum":"978-284-3309","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":688,"fieldName":"WorkingHours","customFieldvalue":"0"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":688,"fieldName":"DISPLAY_SEQUENCE","customFieldvalue":"1"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":688,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/wilmington-branch.png"}],"warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/wilmington-branch.png","serviceManager":"Brian Pomroy","displaySequence":"1"},{"latitude":"42.18208","longitude":"-71.07391","branchName":"Randolph, MA","branchId":"689","branchCode":"3","locality":"Randolph, MA 02368","street":"81 York Avenue","phone":"781-963-3766","faxNum":"781-986-6916","workHour":"7 AM - 5 PM","note":"Monday - Friday","email":"jmcgee@sgtorrice.com","distance":0.0,"city":"Randolph","state":"MA","zip":"02368","country":"US","tollFreeNum":"978-284-3309","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":689,"fieldName":"DISPLAY_SEQUENCE","customFieldvalue":"13"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":689,"fieldName":"WorkingHours","customFieldvalue":"0"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":689,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/randolph-branch.png"}],"warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/randolph-branch.png","serviceManager":"John McGee","displaySequence":"13"},{"latitude":"42.72879","longitude":"-71.43003","branchName":"Hudson, NH","branchId":"690","branchCode":"4","locality":"Hudson, NH 03051","street":"24 Flagstone Drive","phone":"800-335-4822","faxNum":"603-886-5814","workHour":"7 AM - 5 PM","note":"Monday - Friday","email":"jmurphy@sgtorrice.com","distance":0.0,"city":"Hudson","state":"NH","zip":"03051","country":"US","tollFreeNum":"978-284-3309","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":690,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/hudson-branch.png"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":690,"fieldName":"WorkingHours","customFieldvalue":"0"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":690,"fieldName":"DISPLAY_SEQUENCE","customFieldvalue":"4"}],"warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/hudson-branch.png","serviceManager":"John Murphy","displaySequence":"4"},{"latitude":"42.53263","longitude":"-71.13949","branchName":"Fabrication Shop","branchId":"691","branchCode":"5","locality":"Wilmington, MA 01887","street":"80 Industrial Way","phone":"978-888-8359","faxNum":"978-657-4044","workHour":"7 AM - 5 PM","note":"Monday - Friday","email":"bwillows@sgtorrice.com","distance":0.0,"city":"Wilmington","state":"MA","zip":"01887","country":"US","tollFreeNum":"978-284-3309","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":691,"fieldName":"DISPLAY_SEQUENCE","customFieldvalue":"3"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":691,"fieldName":"WorkingHours","customFieldvalue":"0"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":691,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/fabrication-shop-branch.png"}],"warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/fabrication-shop-branch.png","serviceManager":"Brad Willows","displaySequence":"3"},{"latitude":"42.5187","longitude":"-70.97264","branchName":"Peabody, MA","branchId":"692","branchCode":"6","locality":"Peabody, MA 01960","street":"One First Avenue Suite 3B","phone":"978-977-7900","faxNum":"978-977-9344","workHour":"7 AM - 5 PM","note":"Monday - Friday","email":"rrichardson@sgtorrice.com","distance":0.0,"city":"Peabody","state":"MA","zip":"01960","country":"US","tollFreeNum":"978-284-3309","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":692,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/peabody-branch.png"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":692,"fieldName":"DISPLAY_SEQUENCE","customFieldvalue":"10"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":692,"fieldName":"WorkingHours","customFieldvalue":"0"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":692,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/peabody-branch.png"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":692,"fieldName":"WorkingHours","customFieldvalue":"0"}],"warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/peabody-branch.png","serviceManager":"Rusty Richardson","displaySequence":"10"},{"latitude":"42.02413","longitude":"-71.24849","branchName":"Mansfield, MA","branchId":"693","branchCode":"7","locality":"Mansfield, MA 02048","street":"600 West Street","phone":"508-541-9014","faxNum":"508-541-9050","workHour":"7 AM - 5 PM","note":"Monday - Friday","email":"mmihalio@sgtorrice.com","distance":0.0,"city":"Mansfield","state":"MA","zip":"02048","country":"US","tollFreeNum":"978-284-3309","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":693,"fieldName":"WorkingHours","customFieldvalue":"0"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":693,"fieldName":"DISPLAY_SEQUENCE","customFieldvalue":"8"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":693,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/mansfield-branch.png"}],"warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/mansfield-branch.png","serviceManager":"Mike Mihalio","displaySequence":"8"},{"latitude":"41.663","longitude":"-70.27087","branchName":"Hyannis, MA","branchId":"694","branchCode":"8","locality":"Hyannis, MA 02601","street":"71 Bodick Road","phone":"508-790-8856","faxNum":"508-790-7024","workHour":"7 AM - 5 PM","note":"Monday - Friday","email":"jdavis@sgtorrice.com","distance":0.0,"city":"Hyannis","state":"MA","zip":"02601","country":"US","tollFreeNum":"978-284-3309","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":694,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/hyannis-branch.png"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":694,"fieldName":"DISPLAY_SEQUENCE","customFieldvalue":"5"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":694,"fieldName":"WorkingHours","customFieldvalue":"0"}],"warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/hyannis-branch.png","serviceManager":"John Davis","displaySequence":"5"},{"latitude":"43.03101","longitude":"-70.79299","branchName":"Portsmouth, NH","branchId":"695","branchCode":"9","locality":"Portsmouth, NH 03801","street":"115 Heritage Avenue Suite B","phone":"603-373-6951","faxNum":"603-373-6954","workHour":"7 AM - 5 PM","note":"Monday - Friday","email":"dwoodward@sgtorrice.com","distance":0.0,"city":"Portsmouth","state":"NH","zip":"03801","country":"US","tollFreeNum":"978-284-3309","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":695,"fieldName":"DISPLAY_SEQUENCE","customFieldvalue":"11"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":695,"fieldName":"WorkingHours","customFieldvalue":"0"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":695,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/portsmouth-branch.png"}],"warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/portsmouth-branch.png","serviceManager":"Dave Woodward","displaySequence":"11"},{"latitude":"42.33341","longitude":"-71.07555","branchName":"Boston, MA","branchId":"696","branchCode":"10","locality":"Boston, MA 02118","street":"30 Northampton Street Rear","phone":"857-233-4330","faxNum":"857-233-4459","workHour":"7 AM - 5 PM","note":"Monday - Friday","email":"mlemire@sgtorrice.com","distance":0.0,"city":"Boston","state":"MA","zip":"02118","country":"US","tollFreeNum":"978-284-3309","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":696,"fieldName":"AFTER_HOURS_CONTACT","customFieldvalue":"978-284-3309"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":696,"fieldName":"WorkingHours","customFieldvalue":"0"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":696,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/boston-branch.png"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":696,"fieldName":"DISPLAY_SEQUENCE","customFieldvalue":"2"}],"warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/boston-branch.png","serviceManager":"Michael Lemire","displaySequence":"2"},{"latitude":"41.79456","longitude":"-71.43836","branchName":"Providence, RI","branchId":"697","branchCode":"11","locality":"Providence, RI 02907","street":"300 Niantic Avenue","phone":"401-490-4425","faxNum":"401-490-4432","workHour":"7 AM - 5 PM","note":"Monday - Friday","email":"rstill@sgtorrice.com","distance":0.0,"city":"Providence","state":"RI","zip":"02907","country":"US","tollFreeNum":"978-284-3309","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":697,"fieldName":"WorkingHours","customFieldvalue":"0"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":697,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/providence-branch.png"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":697,"fieldName":"DISPLAY_SEQUENCE","customFieldvalue":"12"}],"warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/providence-branch.png","serviceManager":"Ryan Still","displaySequence":"12"},{"latitude":"42.35157","longitude":"-71.58301","branchName":"Marlborough, MA","branchId":"699","branchCode":"14","locality":"Marlborough, MA 01752","street":"164 Locke Drive","phone":"508-418-4345","faxNum":"508-418-4361","workHour":"7 AM - 5 PM","note":"Monday - Friday","email":"cbergeron@sgtorrice.com","distance":0.0,"city":"Marlborough","state":"MA","zip":"01752","country":"US","tollFreeNum":"978-284-3309","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":699,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/marlborough-branch.png"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":699,"fieldName":"WorkingHours","customFieldvalue":"0"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":699,"fieldName":"DISPLAY_SEQUENCE","customFieldvalue":"9"}],"warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/marlborough-branch.png","serviceManager":"Chris Bergeron","displaySequence":"9"},{"latitude":"43.64756","longitude":"-70.36389","branchName":"Westbrook, ME","branchId":"700","branchCode":"15","locality":"Westbrook, ME 04092","street":"5 Karen Drive","phone":"207-560-6870","faxNum":"207-253-1835","workHour":"7 AM - 5 PM","note":"Monday - Friday","email":"jdesantis@sgtorrice.com","distance":0.0,"city":"Westbrook","state":"ME","zip":"04092","country":"US","tollFreeNum":"207-800-5848","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":700,"fieldName":"DISPLAY_SEQUENCE","customFieldvalue":"14"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":700,"fieldName":"WorkingHours","customFieldvalue":"0"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":700,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/westbrook-branch.png"}],"warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/westbrook-branch.png","serviceManager":"Jared DeSantis","displaySequence":"14"},{"latitude":"42.95388","longitude":"-71.44273","branchName":"Manchester, NH","branchId":"701","branchCode":"16","locality":"Manchester, NH 03103","street":"2 Keller Street Unit 2","phone":"603-945-1490","faxNum":"603-218-6820","workHour":"7 AM - 5 PM","note":"Monday - Friday","email":"cstanley@sgtorrice.com","distance":0.0,"city":"Manchester","state":"NH","zip":"03103","country":"US","tollFreeNum":"978-284-3309","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":701,"fieldName":"DISPLAY_SEQUENCE","customFieldvalue":"7"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":701,"fieldName":"WorkingHours","customFieldvalue":"0"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":701,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/manchester-branch.png"}],"warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/Branch_images/manchester-branch.png","serviceManager":"Chad Stanley","displaySequence":"7"},{"latitude":"0","longitude":"0","branchName":"Central Distribution Warehouse","branchId":"728","branchCode":"CDW","locality":"Wilmintgon, MA 01887","street":"80 Industrial Way","phone":"","faxNum":"","workHour":"","note":"","email":"","distance":0.0,"city":"Wilmintgon","state":"MA","zip":"01887","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":728,"fieldName":"DISPLAY_SEQUENCE","customFieldvalue":"17"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":728,"fieldName":"WorkingHours","customFieldvalue":"0"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":728,"fieldName":"AFTER_HOURS_CONTACT","customFieldvalue":" (978) 284-3309"}],"serviceManager":"","displaySequence":"17"}]
database