[{"latitude":"0","longitude":"0","branchName":"Allied Controls Inc.","branchId":"788","branchCode":"8625","locality":"Apopka, FL 32703","street":"1706 East Semoran Blvd., Suite # 128","phone":"407-788-0050","faxNum":"","workHour":"","note":"","email":"mike@alliedcontrols.com","distance":0.0,"city":"Apopka","state":"FL","zip":"32703","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":788,"fieldName":"DISTRIBUTOR_URL","customFieldvalue":"https://www.alliedcontrols.com"}],"serviceManager":""},{"latitude":"0","longitude":"0","branchName":"M\u0026M Controls","branchId":"829","branchCode":"M\u0026M Controls","locality":"Richmond, VA 23230","street":"3102 W Clay Street","phone":"804-752-3423","faxNum":"","workHour":"","note":"","email":"bbromseth@aierco.com","distance":0.0,"city":"Richmond","state":"VA","zip":"23230","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"ACR SUPPLY","branchId":"848","branchCode":"ACR SUPPLY","locality":"Durham, NC 27713","street":"4040 S Alston Avenue","phone":"3362179207","faxNum":"","workHour":"","note":"","email":"Rodney Smith","distance":0.0,"city":"Durham","state":"NC","zip":"27713","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"HUGHES-PETERS","branchId":"861","branchCode":"N/A","locality":"Waukesha, WI 53189","street":"105 Wilmont Drive","phone":"2815651181","faxNum":"","workHour":"","note":"","email":"jmetzger@hughespeters.com","distance":0.0,"city":"Waukesha","state":"WI","zip":"53189","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"INTERNATIONAL SYSTEMS OF AMERICA","branchId":"862","branchCode":"N/A","locality":"Independence, OH 44131","street":"6155 Rockside Rd. Suite 400","phone":"2164337200","faxNum":"","workHour":"","note":"","email":"mkrieger@protegis.com","distance":0.0,"city":"Independence","state":"OH","zip":"44131","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"IRR SUPPLY CENTERS INC","branchId":"863","branchCode":"N/A","locality":"North Tonawanda, NY 14120","street":"908 Niagara Falls Blvd.","phone":"7166921600","faxNum":"","workHour":"","note":"","email":"ray.lip@irrsupply.com","distance":0.0,"city":"North Tonawanda","state":"NY","zip":"14120","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Jorban-Riscoe Associates, Inc.","branchId":"864","branchCode":"N/A","locality":"Lenexa, KS 66215","street":"9808 Alden Rd.","phone":"9134381244","faxNum":"","workHour":"","note":"","email":"mainoffice@jorban-riscoe.com","distance":0.0,"city":"Lenexa","state":"KS","zip":"66215","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"MCGUIRE \u0026 CO FALMOUTH, MAINE","branchId":"865","branchCode":"N/A","locality":"Falmouth, ME 04105","street":"27 Gray Rd.","phone":"2077973323","faxNum":"","workHour":"","note":"","email":"info@mcguirecontrols.com","distance":0.0,"city":"Falmouth","state":"ME","zip":"04105","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Wholesale Controls International- Montgomery","branchId":"888","branchCode":"N/A","locality":"Montgomery, AL 36117","street":"880 Plantation Way","phone":"334.356.8687","faxNum":"334.356.8617","workHour":"","note":"","email":"","distance":0.0,"city":"Montgomery","state":"AL","zip":"36117","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Wholesale Controls International- Huntsville","branchId":"889","branchCode":"N/A","locality":"Huntsville, AL 35816","street":"1110 Retail Dr. NW","phone":"256.489.0490","faxNum":"205.327.7286","workHour":"","note":"","email":"","distance":0.0,"city":"Huntsville","state":"AL","zip":"35816","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Wholesale Controls International- Pensacola","branchId":"890","branchCode":"N/A","locality":"Pensacola, FL 32505","street":"4811 N.Palafox St.","phone":"850.316.2259","faxNum":"205.664.4725","workHour":"","note":"","email":"","distance":0.0,"city":"Pensacola","state":"FL","zip":"32505","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Wholesale Controls International- Hoover","branchId":"891","branchCode":"N/A","locality":"Hoover, AL 35244","street":"300 Riverchase Parkway E.","phone":"205-664-4723","faxNum":"205-664-4725","workHour":"","note":"","email":"","distance":0.0,"city":"Hoover","state":"AL","zip":"35244","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"M\u0026M Controls","branchId":"828","branchCode":"M\u0026M Controls","locality":"Alexandria, VA 22312","street":"5712-G General Washington Drive","phone":"703-776-1980","faxNum":"","workHour":"","note":"","email":"jbush@aireco.com","distance":0.0,"city":"Alexandria","state":"VA","zip":"22312","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Allied Controls Inc.","branchId":"849","branchCode":"Allied Controls Inc.","locality":"Apopka, FL 32703","street":"1706 East Semoran Blvd. Suite 128","phone":"4077880050","faxNum":"","workHour":"","note":"","email":"mike@alliedcontrols.com","distance":0.0,"city":"Apopka","state":"FL","zip":"32703","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Auer Steel","branchId":"850","branchCode":"N/A","locality":"Milwaukee, WI 53209","street":"2935 W Silver Spring Dr","phone":"4144631234","faxNum":"","workHour":"","note":"","email":"jon.williams@auersteel.com","distance":0.0,"city":"Milwaukee","state":"WI","zip":"53209","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Building Controls \u0026 Solutions","branchId":"851","branchCode":"N/A","locality":"Farmers Branch, TX 75234","street":"2241 Valwood Parkway Suite 200","phone":"2142906900","faxNum":"","workHour":"","note":"","email":"bob.barnebey@building-controls.com","distance":0.0,"city":"Farmers Branch","state":"TX","zip":"75234","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"C.D. Jones","branchId":"852","branchCode":"N/A","locality":"North Kansas City, MO 64116","street":"621 East 14th Avenue","phone":"8004442761","faxNum":"","workHour":"","note":"","email":"bcaudill@cdjones.com","distance":0.0,"city":"North Kansas City","state":"MO","zip":"64116","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"CIS Industries","branchId":"853","branchCode":"N/A","locality":"Jefferson, LA 70121","street":"4931 Bloomfiled Street","phone":"5047345001","faxNum":"","workHour":"","note":"","email":"raymond@cisindustries.com","distance":0.0,"city":"Jefferson","state":"LA","zip":"70121","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Commercial Building Controls Supply","branchId":"854","branchCode":"N/A","locality":"Schaumburg, IL 60173","street":"1157 Tower Road","phone":"8475192227","faxNum":"","workHour":"","note":"","email":"ruger@cbcsupply.com","distance":0.0,"city":"Schaumburg","state":"IL","zip":"60173","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Control Tech Supply","branchId":"855","branchCode":"N/A","locality":"Dallas, TX 75229","street":"11258 Goodnight Lane Suite 101","phone":"9722436884","faxNum":"","workHour":"","note":"","email":"chad@ct-supply.com","distance":0.0,"city":"Dallas","state":"TX","zip":"75229","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"ENCON","branchId":"856","branchCode":"N/A","locality":"Ocean Township, NJ 07712","street":"3433 Sunset Ave.","phone":"7329221305","faxNum":"","workHour":"","note":"","email":"abae@enconmech.com","distance":0.0,"city":"Ocean Township","state":"NJ","zip":"07712","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Ener-Tech Quality Controls inc.","branchId":"857","branchCode":"N/A","locality":"Nashville, TN 37210","street":"722 Massman Drive","phone":"6152695643","faxNum":"","workHour":"","note":"","email":"chip@ener-technidustries.com","distance":0.0,"city":"Nashville","state":"TN","zip":"37210","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"ENCON SERVICES \u0026 SUPPLY, INC.","branchId":"858","branchCode":"N/A","locality":"Delmar, NY 12054","street":"5 Becker Terrace","phone":"5184399412","faxNum":"","workHour":"","note":"","email":"dmusella@albany.twcbc.com","distance":0.0,"city":"Delmar","state":"NY","zip":"12054","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"FIGLIA AND SONS","branchId":"859","branchCode":"N/A","locality":"New York, NY 10009","street":"746 East 9th Street","phone":"2126860094","faxNum":"","workHour":"","note":"","email":"richiep@figliasons.com","distance":0.0,"city":"New York","state":"NY","zip":"10009","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"FIRST SUPPLY GROUP","branchId":"860","branchCode":"N/A","locality":"Green Bay, WI 54304","street":"3014 Holmbren Way","phone":"9203379004","faxNum":"","workHour":"","note":"","email":"kgrulke@1supply.com","distance":0.0,"city":"Green Bay","state":"WI","zip":"54304","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Allied Refrigeration","branchId":"868","branchCode":"N/A","locality":"Signal Hill, CA 90755","street":"2300 E 28th Street","phone":"562-595-5302","faxNum":"","workHour":"","note":"","email":"r.gregg@alliedrefrigeration.com","distance":0.0,"city":"Signal Hill","state":"CA","zip":"90755","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"American Refrigeration Supplies, Inc","branchId":"869","branchCode":"N/A","locality":"Phoenix, AZ 85040","street":"2632 E Chambers Street","phone":"602-243-2792","faxNum":"","workHour":"","note":"","email":"jconiglio@arsnet.com","distance":0.0,"city":"Phoenix","state":"AZ","zip":"85040","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Mechtronics Controls LLC","branchId":"870","branchCode":"N/A","locality":"Carlsbad, CA 92008","street":"2195 Faraday Avenue, Ste. G","phone":"877-632-4876","faxNum":"","workHour":"","note":"","email":"sales@hvacusa.com","distance":0.0,"city":"Carlsbad","state":"CA","zip":"92008","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"O\u0027Conner Company Inc.","branchId":"871","branchCode":"N/A","locality":"Urbandale, IA 50323","street":"4455 121st Street","phone":"(515) 252-7171","faxNum":"","workHour":"","note":"","email":"bmitchell@oconnor-hvac.com","distance":0.0,"city":"Urbandale","state":"IA","zip":"50323","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"PYRO-MATIC, INC.","branchId":"872","branchCode":"N/A","locality":"Wauwatosa, WI 53226","street":"11901 W. Dearborn Ave","phone":"414-453-1171","faxNum":"","workHour":"","note":"","email":"","distance":0.0,"city":"Wauwatosa","state":"WI","zip":"53226","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Quest Controls","branchId":"873","branchCode":"N/A","locality":"Palmetto, FL 34221","street":"208 9th Street Drive West","phone":"(800) 373-6331","faxNum":"","workHour":"","note":"","email":"raura@questcontrols.com","distance":0.0,"city":"Palmetto","state":"FL","zip":"34221","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Refrigeration Supplies Distributor (RSD)","branchId":"874","branchCode":"N/A","locality":"Lake Forest, CA 92630","street":"26021 Atlantic Ocean Dr.","phone":"949-380-1000","faxNum":"","workHour":"","note":"","email":"acox@rsd.net","distance":0.0,"city":"Lake Forest","state":"CA","zip":"92630","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Russell Sigler Inc","branchId":"875","branchCode":"N/A","locality":"Tolleson, AZ 85353","street":"Russell Sigler Inc","phone":"623-227-2456","faxNum":"","workHour":"","note":"","email":"","distance":0.0,"city":"Tolleson","state":"AZ","zip":"85353","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"STANDARD ELECTRIC COMPANY","branchId":"876","branchCode":"N/A","locality":"Indianapolis, IN 46256","street":"9900 Westpoint Drive, Suite 142","phone":"317-773-0400","faxNum":"","workHour":"","note":"","email":"haight@standardelectricsupply.com","distance":0.0,"city":"Indianapolis","state":"IN","zip":"46256","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"STICKFORT ELECTRIC CO","branchId":"877","branchCode":"N/A","locality":"Cedar Falls, IA 50613","street":"201 E. 22nd St","phone":"319-266-5438","faxNum":"","workHour":"","note":"","email":"brad@stickfortelectric.com","distance":0.0,"city":"Cedar Falls","state":"IA","zip":"50613","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"SWH SUPPLY COMPANY-11208","branchId":"878","branchCode":"N/A","locality":"Cincinnati, OH 45216","street":"5917 Fishwick","phone":"513-641-4422","faxNum":"","workHour":"","note":"","email":"doug@swhsupply.com","distance":0.0,"city":"Cincinnati","state":"OH","zip":"45216","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"THERMCO INC","branchId":"879","branchCode":"N/A","locality":"Clifton, NJ 07012","street":"228 Scoles Ave","phone":"973-777-6700","faxNum":"","workHour":"","note":"","email":"tom@thermcoreps.com","distance":0.0,"city":"Clifton","state":"NJ","zip":"07012","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":879,"fieldName":" WAREHOUSE_URL","customFieldvalue":" "}],"serviceManager":""},{"latitude":"0","longitude":"0","branchName":"Unlimited Controls and Instrumentation","branchId":"880","branchCode":"N/A","locality":"San Diego, CA 92111","street":"7263 Engineer Road, Ste C","phone":"858-383-6569","faxNum":"","workHour":"","note":"","email":"sales@ulcontrols.com","distance":0.0,"city":"San Diego","state":"CA","zip":"92111","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"US Air Conditioning Distributors","branchId":"881","branchCode":"N/A","locality":"City of Industry, CA 91748","street":"16900 Chestnut Street","phone":"800-937-7222","faxNum":"","workHour":"","note":"","email":"","distance":0.0,"city":"City of Industry","state":"CA","zip":"91748","country":"US","tollFreeNum":"","serviceManager":""},{"latitude":"0","longitude":"0","branchName":"APEX CONTROLS","branchId":"782","branchCode":"5540","locality":"West Chester, PA 19382","street":"24 Hagerty Boulevard, Suite 6","phone":"310-344-9156","faxNum":"","workHour":"","note":"","email":"sales@apexcontrols.com","distance":0.0,"city":"West Chester","state":"PA","zip":"19382","country":"US","tollFreeNum":"","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":782,"fieldName":"DISTRIBUTOR_URL","customFieldvalue":"https://www.arizonaclimatesupply.com/"}],"serviceManager":""}]

database

$googleSpreadSheetUrl