You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
{ "sample": { "is_sample": "TRUE", "limit_total": 400 }, "api": { "title": "Nationwide Insurance Agents 1", "point": { "title": "Main", "desc": "Main access point of this API. " } }, "input": {}, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/insurance_agent_of_nationwide_1/main/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/insurance_agent_of_nationwide_1/main/list/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/insurance_agent_of_nationwide_1/main/list/4/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/insurance_agent_of_nationwide_1/main/list/6/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 5, "limit": 20, "limit_total": 400, "time": 0.006320000000000000096866958898544908151961863040924072265625 }, "stats": { "raw_rows": 20, "rows": 20, "rows_total": 3249, "pages_total": 163 }, "struct": { "stem": { "0": "state", "1": "city" }, "leaf": "city.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "81": { "city.id": 81, "city.ts": "2017-08-15 02:34:15", "city.title": "Winfield", "city.city_x_agent_id": { "589": { "city_x_agent.id": 589, "agent.id": 170, "agent.ts": "2017-09-05 05:26:56", "agent.title": "THE TURNER AGENCY INC", "agent.pull_right": "16.78 mi", "agent.phone_number": "(205) 932-5223", "agent.street_address": "202 TEMPLE AVE N", "agent.address_locality": "Fayette, AL 35555-2307" }, "587": { "city_x_agent.id": 587, "agent.id": 171, "agent.ts": "2017-09-05 05:26:56", "agent.title": "James Odum Jr", "agent.pull_right": "0.23 mi", "agent.phone_number": "(205) 487-4545", "agent.street_address": "754 US Highway 43", "agent.address_locality": "Winfield, AL 35594" }, "591": { "city_x_agent.id": 591, "agent.id": 172, "agent.ts": "2017-09-05 05:26:56", "agent.title": "THE TURNER AGENCY INC", "agent.pull_right": "21.07 mi", "agent.phone_number": "(205) 695-9116", "agent.street_address": "121 2ND AVE NE", "agent.address_locality": "Vernon, AL 35592" }, "592": { "city_x_agent.id": 592, "agent.id": 220, "agent.ts": "2017-09-05 05:26:56", "agent.title": "YOUR INSURANCE CENTERS INC", "agent.pull_right": "23.41 mi", "agent.phone_number": "(205) 486-7575", "agent.street_address": "2012 9TH AVE", "agent.address_locality": "Haleyville, AL 35565-1423" }, "588": { "city_x_agent.id": 588, "agent.id": 221, "agent.ts": "2017-09-05 05:26:56", "agent.title": "David Hall", "agent.pull_right": "17.81 mi", "agent.phone_number": "(205) 921-9215", "agent.street_address": "138 1st St NW", "agent.address_locality": "Hamilton, AL 35570-0939" }, "590": { "city_x_agent.id": 590, "agent.id": 223, "agent.ts": "2017-09-05 05:26:56", "agent.title": "YOUR INSURANCE CENTERS INC", "agent.pull_right": "18.00 mi", "agent.phone_number": "(205) 921-2141", "agent.street_address": "400 BEXAR AVE W", "agent.address_locality": "Hamilton, AL 35570-5522" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "82": { "city.id": 82, "city.ts": "2017-08-15 02:34:15", "city.title": "Woodland", "city.city_x_agent_id": { "595": { "city_x_agent.id": 595, "agent.id": 32, "agent.ts": "2017-09-05 05:27:08", "agent.title": "FIRST CAPITAL INS AGENCY INC", "agent.pull_right": "20.52 mi", "agent.phone_number": "(256) 396-2131", "agent.street_address": "575 E COLLEGE ST", "agent.address_locality": "Lineville, AL 36266-4521" }, "594": { "city_x_agent.id": 594, "agent.id": 276, "agent.ts": "2017-09-05 05:27:08", "agent.title": "TRI COUNTY INSURANCE", "agent.pull_right": "15.61 mi", "agent.phone_number": "(334) 863-2206", "agent.street_address": "3164 HIGHWAY 431 STE 5", "agent.address_locality": "Roanoke, AL 36274-1702" }, "593": { "city_x_agent.id": 593, "agent.id": 300, "agent.ts": "2017-09-05 05:27:08", "agent.title": "Pamela Skidmore", "agent.pull_right": "0.79 mi", "agent.phone_number": "(256) 449-2671", "agent.street_address": "23431 Highway 48", "agent.address_locality": "Woodland, AL 36280-7719" }, "596": { "city_x_agent.id": 596, "agent.id": 596, "agent.ts": "2017-09-05 06:36:43", "agent.title": "CARROLL REALTY & INS CO INC", "agent.pull_right": "0.32 mi", "agent.phone_number": "(770) 832-2461", "agent.street_address": "100 COLLEGE ST", "agent.address_locality": "Carrollton, GA 30117-3137" }, "597": { "city_x_agent.id": 597, "agent.id": 597, "agent.ts": "2017-09-05 06:36:43", "agent.title": "J SMITH LANIER & COMPANY", "agent.pull_right": "1.63 mi", "agent.phone_number": "(770) 683-1000", "agent.street_address": "1330 N PARK ST", "agent.address_locality": "Carrollton, GA 30117-2262" }, "598": { "city_x_agent.id": 598, "agent.id": 598, "agent.ts": "2017-09-05 06:36:43", "agent.title": "INS ASSOCIATES OF CARROLLTON", "agent.pull_right": "1.47 mi", "agent.phone_number": "(770) 838-4664", "agent.street_address": "103 PARK PLACE WAY", "agent.address_locality": "Carrollton, GA 30117-1960" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "83": { "city.id": 83, "city.ts": "2017-09-05 22:37:37", "city.title": "28170 N Alma School Pkwy", "city.city_x_agent_id": { "599": { "city_x_agent.id": 599, "agent.id": 599, "agent.ts": "2017-09-05 05:31:23", "agent.title": "Maximos Soliman", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 315-0400", "agent.street_address": "16420 N 92nd St Ste 105", "agent.address_locality": "Scottsdale, AZ 85260" }, "600": { "city_x_agent.id": 600, "agent.id": 600, "agent.ts": "2017-09-05 05:28:31", "agent.title": "WESTERN AG-INS AGENCY INC", "agent.pull_right": "8.76 mi", "agent.phone_number": "(480) 550-1507", "agent.street_address": "STE 207", "agent.address_locality": "28170 N Alma School Pkwy, AZ 85262" }, "601": { "city_x_agent.id": 601, "agent.id": 601, "agent.ts": "2017-09-05 05:28:31", "agent.title": "WESTERN AG-INS AGENCY INC", "agent.pull_right": "8.76 mi", "agent.phone_number": "(480) 550-1507", "agent.street_address": "28170 N ALMA SCHOOL PKWY STE 207", "agent.address_locality": "Scottsdale, AZ 85262-8053" }, "602": { "city_x_agent.id": 602, "agent.id": 602, "agent.ts": "2017-09-05 05:28:31", "agent.title": "JVP INS AGENCY LLC", "agent.pull_right": "7.88 mi", "agent.phone_number": "(480) 473-3100", "agent.street_address": "10025 E DYNAMITE BLVD STE B135", "agent.address_locality": "Scottsdale, AZ 85262-3688" }, "603": { "city_x_agent.id": 603, "agent.id": 603, "agent.ts": "2017-09-05 05:28:09", "agent.title": "ARIZONA INS SPECIALISTS LLC", "agent.pull_right": "9.72 mi", "agent.phone_number": "(602) 717-4992", "agent.street_address": "30423 N 139TH ST", "agent.address_locality": "Scottsdale, AZ 85262-5988" }, "604": { "city_x_agent.id": 604, "agent.id": 604, "agent.ts": "2017-09-05 05:27:12", "agent.title": "BRIDGELIGHT INSURANCE", "agent.pull_right": "5.17 mi", "agent.phone_number": "(480) 999-3020", "agent.street_address": "20645 N PIMA RD STE 225", "agent.address_locality": "Scottsdale, AZ 85255-5681" }, "605": { "city_x_agent.id": 605, "agent.id": 605, "agent.ts": "2017-09-05 05:27:12", "agent.title": "LIGHTFOOT & ASSOCIATES LLC", "agent.pull_right": "5.45 mi", "agent.phone_number": "(720) 261-2249", "agent.street_address": "29306 N 153RD PL", "agent.address_locality": "Scottsdale, AZ 85262-6920" }, "606": { "city_x_agent.id": 606, "agent.id": 606, "agent.ts": "2017-09-05 05:27:12", "agent.title": "CREST INSURANCE GROUP", "agent.pull_right": "6.01 mi", "agent.phone_number": "(520) 881-5760", "agent.street_address": "8302 E BUTEO DR", "agent.address_locality": "Scottsdale, AZ 85255-3920" }, "607": { "city_x_agent.id": 607, "agent.id": 607, "agent.ts": "2017-09-05 05:27:12", "agent.title": "GREENE INS GROUP LLC", "agent.pull_right": "7.45 mi", "agent.phone_number": "(480) 657-2800", "agent.street_address": "17470 N PACESETTER WAY", "agent.address_locality": "Scottsdale, AZ 85255-5445" }, "608": { "city_x_agent.id": 608, "agent.id": 608, "agent.ts": "2017-09-05 05:29:15", "agent.title": "PRUTTING INS GROUP INC", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 502-4300", "agent.street_address": "8889 E BELL RD STE 201", "agent.address_locality": "Scottsdale, AZ 85260-1597" }, "29298": { "city_x_agent.id": 29298, "agent.id": 614, "agent.ts": "2017-09-05 05:28:31", "agent.title": "John Delbrocco", "agent.pull_right": "11.66 mi", "agent.phone_number": "(602) 863-1315", "agent.street_address": "20235 N Cave Creek Rd Ste 110", "agent.address_locality": "Phoenix, AZ 85024-0800" }, "29300": { "city_x_agent.id": 29300, "agent.id": 615, "agent.ts": "2017-09-05 05:30:33", "agent.title": "Maximos Soliman", "agent.pull_right": "7.95 mi", "agent.phone_number": "(602) 540-3673", "agent.street_address": "16841 N 31st Ave STE 146", "agent.address_locality": "Phoenix, AZ 85053" }, "29304": { "city_x_agent.id": 29304, "agent.id": 616, "agent.ts": "2017-09-05 05:31:43", "agent.title": "TJ Mazur", "agent.pull_right": "6.68 mi", "agent.phone_number": "(623) 776-8501", "agent.street_address": "7121 W Bell Rd Ste 30L", "agent.address_locality": "Glendale, AZ 85308-8559" }, "29305": { "city_x_agent.id": 29305, "agent.id": 618, "agent.ts": "2017-09-05 05:30:42", "agent.title": "Edgar Acosta", "agent.pull_right": "8.32 mi", "agent.phone_number": "(623) 302-0313", "agent.street_address": "7141 N 51st Ave Ste B", "agent.address_locality": "Glendale, AZ 85301" }, "29307": { "city_x_agent.id": 29307, "agent.id": 624, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Aaron Isakson", "agent.pull_right": "8.70 mi", "agent.phone_number": "(480) 888-0318", "agent.street_address": "1819 E Southern Ave Ste E-20", "agent.address_locality": "Mesa, AZ 85204" }, "29299": { "city_x_agent.id": 29299, "agent.id": 625, "agent.ts": "2017-09-05 05:29:15", "agent.title": "Aaron Isakson", "agent.pull_right": "0.37 mi", "agent.phone_number": "(480) 888-0318", "agent.street_address": "16930 E Palisades Blvd", "agent.address_locality": "Fountain Hills, AZ 85268" }, "29301": { "city_x_agent.id": 29301, "agent.id": 626, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "3.87 mi", "agent.phone_number": "(480) 945-3123", "agent.street_address": "2932 N 68th St Ste 4", "agent.address_locality": "Scottsdale, AZ 85251" }, "29306": { "city_x_agent.id": 29306, "agent.id": 628, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Peter Tadevossian", "agent.pull_right": "1.83 mi", "agent.phone_number": "(480) 719-7183", "agent.street_address": "1910 S Priest Dr", "agent.address_locality": "Tempe, AZ 85281" }, "29302": { "city_x_agent.id": 29302, "agent.id": 635, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Ryan J Larson", "agent.pull_right": "9.37 mi", "agent.phone_number": "(602) 393-1338", "agent.street_address": "1500 E Bethany Home Rd Ste 170", "agent.address_locality": "Phoenix, AZ 85014-2444" }, "29303": { "city_x_agent.id": 29303, "agent.id": 637, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "7.76 mi", "agent.phone_number": "(602) 493-4851", "agent.street_address": "2415 E Camelback Rd Ste 700", "agent.address_locality": "Phoenix, AZ 85016" }, "29278": { "city_x_agent.id": 29278, "agent.id": 651, "agent.ts": "2017-09-05 05:28:31", "agent.title": "TYROL INSURANCE AGENCY INC", "agent.pull_right": "1.79 mi", "agent.phone_number": "(480) 488-2113", "agent.street_address": "7206 E CAVE CREEK RD", "agent.address_locality": "Carefree, AZ 85377" }, "29280": { "city_x_agent.id": 29280, "agent.id": 652, "agent.ts": "2017-09-05 05:28:31", "agent.title": "EVERS INS SERVICES LLC", "agent.pull_right": "1.56 mi", "agent.phone_number": "(602) 741-7777", "agent.street_address": "7100 E CAVE CREEK RD BLDG 12 #124", "agent.address_locality": "Cave Creek, AZ 85331-4305" }, "29310": { "city_x_agent.id": 29310, "agent.id": 695, "agent.ts": "2017-09-05 05:29:15", "agent.title": "GARVEY HANSEN LLC", "agent.pull_right": "0.11 mi", "agent.phone_number": "(480) 836-1468", "agent.street_address": "13034 N VERDE RIVER DR STE 101", "agent.address_locality": "Fountain Hills, AZ 85268-8443" }, "29285": { "city_x_agent.id": 29285, "agent.id": 696, "agent.ts": "2017-09-05 05:29:15", "agent.title": "SHEPHERD INSURANCE LLC", "agent.pull_right": "8.61 mi", "agent.phone_number": "(480) 657-8872", "agent.street_address": "14411 N 98TH PL", "agent.address_locality": "Scottsdale, AZ 85260-3851" }, "29287": { "city_x_agent.id": 29287, "agent.id": 698, "agent.ts": "2017-09-05 05:29:15", "agent.title": "PRIORITY INS ASSOC LLC", "agent.pull_right": "8.75 mi", "agent.phone_number": "(480) 477-6500", "agent.street_address": "14354 N FRANK LLOYD WRIGHT BLV", "agent.address_locality": "Scottsdale, AZ 85260-8844" }, "29286": { "city_x_agent.id": 29286, "agent.id": 699, "agent.ts": "2017-09-05 05:29:15", "agent.title": "SEEK INSURANCE SERVICES LLC", "agent.pull_right": "8.75 mi", "agent.phone_number": "(480) 666-9889", "agent.street_address": "14362 N FRANK LLOYD WRIGHT BLV SUITE 2600", "agent.address_locality": "Scottsdale, AZ 85260-8846" }, "29311": { "city_x_agent.id": 29311, "agent.id": 700, "agent.ts": "2017-09-05 05:29:15", "agent.title": "BRIGHTWAY INSURANCE", "agent.pull_right": "9.87 mi", "agent.phone_number": "(888) 254-5014", "agent.street_address": "9393 N 90TH ST STE 110", "agent.address_locality": "Scottsdale, AZ 85258-5041" }, "29291": { "city_x_agent.id": 29291, "agent.id": 701, "agent.ts": "2017-09-05 05:29:15", "agent.title": "HILL INSURANCE SERVICES LLC", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 368-5222", "agent.street_address": "14301 N 87TH ST STE 115", "agent.address_locality": "Scottsdale, AZ 85260-3688" }, "29279": { "city_x_agent.id": 29279, "agent.id": 29289, "agent.ts": "2017-09-05 22:37:15", "agent.title": "CORPORATE INS SOLUTIONS LLC", "agent.pull_right": "7.57 mi", "agent.phone_number": "(480) 336-8740", "agent.street_address": "8585 E HARTFORD DR STE 600", "agent.address_locality": "Scottsdale, AZ 85255-5475" }, "29281": { "city_x_agent.id": 29281, "agent.id": 29291, "agent.ts": "2017-09-05 22:37:15", "agent.title": "THE AMBASSADOR GROUP INC", "agent.pull_right": "7.92 mi", "agent.phone_number": "(480) 776-6950", "agent.street_address": "7010 E CHAUNCEY LN STE 230", "agent.address_locality": "Phoenix, AZ 85054-3118" }, "29282": { "city_x_agent.id": 29282, "agent.id": 29292, "agent.ts": "2017-09-05 22:37:15", "agent.title": "VAN LEER-AMBASSADOR GRP INS", "agent.pull_right": "7.92 mi", "agent.phone_number": "(480) 776-6950", "agent.street_address": "7010 E CHAUNCEY LN STE 230", "agent.address_locality": "Phoenix, AZ 85054-3118" }, "29283": { "city_x_agent.id": 29283, "agent.id": 29293, "agent.ts": "2017-09-05 22:37:15", "agent.title": "AZCAL INSURANCE SVS AGENCY INC", "agent.pull_right": "8.59 mi", "agent.phone_number": "(480) 948-8008", "agent.street_address": "7689 E PARADISE LN STE 4", "agent.address_locality": "Scottsdale, AZ 85260-1691" }, "29284": { "city_x_agent.id": 29284, "agent.id": 29294, "agent.ts": "2017-09-05 22:37:15", "agent.title": "ALLIANCE INSURANCE PARTNERS", "agent.pull_right": "8.60 mi", "agent.phone_number": "(602) 427-4300", "agent.street_address": "16427 N SCOTTSDALE RD STE 410", "agent.address_locality": "Scottsdale, AZ 85254-7102" }, "29288": { "city_x_agent.id": 29288, "agent.id": 29298, "agent.ts": "2017-09-05 22:37:17", "agent.title": "WILLIS OF ARIZONA INC", "agent.pull_right": "8.84 mi", "agent.phone_number": "(602) 787-6000", "agent.street_address": "16220 N SCOTTSDALE RD STE 600", "agent.address_locality": "Scottsdale, AZ 85254" }, "29289": { "city_x_agent.id": 29289, "agent.id": 29299, "agent.ts": "2017-09-05 22:37:17", "agent.title": "WILLIS PERSONAL LINES INC", "agent.pull_right": "8.84 mi", "agent.phone_number": "(602) 787-6132", "agent.street_address": "16220 N SCOTTSDALE RD STE 600", "agent.address_locality": "Scottsdale, AZ 85254-1804" }, "29290": { "city_x_agent.id": 29290, "agent.id": 29300, "agent.ts": "2017-09-05 22:37:17", "agent.title": "THE CLEMENTS AGENCY LLC", "agent.pull_right": "9.02 mi", "agent.phone_number": "(480) 477-5245", "agent.street_address": "8350 E RAINTREE DR #235", "agent.address_locality": "Scottsdale, AZ 85260-2695" }, "29292": { "city_x_agent.id": 29292, "agent.id": 29302, "agent.ts": "2017-09-05 22:37:17", "agent.title": "PINNACLE PEAK INS GROUP INC", "agent.pull_right": "9.33 mi", "agent.phone_number": "(480) 424-4756", "agent.street_address": "8147 E EVANS RD STE B-07", "agent.address_locality": "Scottsdale, AZ 85260-3646" }, "29293": { "city_x_agent.id": 29293, "agent.id": 29303, "agent.ts": "2017-09-05 22:37:17", "agent.title": "SULLIVAN JAMES LLC", "agent.pull_right": "9.69 mi", "agent.phone_number": "(480) 382-7332", "agent.street_address": "7077 E MARILYN RD STE 13", "agent.address_locality": "Scottsdale, AZ 85254-2781" }, "29294": { "city_x_agent.id": 29294, "agent.id": 29304, "agent.ts": "2017-09-05 22:37:17", "agent.title": "GG INSURANCE SERVICES INC", "agent.pull_right": "9.74 mi", "agent.phone_number": "(480) 264-7226", "agent.street_address": "7600 E REDFIELD RD HNGR B # 14", "agent.address_locality": "Scottsdale, AZ 85260-3493" }, "29295": { "city_x_agent.id": 29295, "agent.id": 29305, "agent.ts": "2017-09-05 22:37:17", "agent.title": "GG INSURANCE SERVICES INC", "agent.pull_right": "9.74 mi", "agent.phone_number": "(480) 264-7226", "agent.street_address": "7600 E REDFIELD RD STE 145", "agent.address_locality": "Scottsdale, AZ 85260-3491" }, "29296": { "city_x_agent.id": 29296, "agent.id": 29306, "agent.ts": "2017-09-05 22:37:17", "agent.title": "INS CONCEPTS & RISK MGMT LLC", "agent.pull_right": "9.82 mi", "agent.phone_number": "(602) 368-8977", "agent.street_address": "7585 E REDFIELD RD STE 107", "agent.address_locality": "Scottsdale, AZ 85260-6937" }, "29297": { "city_x_agent.id": 29297, "agent.id": 29307, "agent.ts": "2017-09-05 22:37:17", "agent.title": "ACCURATE INS AGENCY LLC", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 447-2267", "agent.street_address": "20660 N 40TH ST UNIT 2027", "agent.address_locality": "Phoenix, AZ 85050-7314" }, "29308": { "city_x_agent.id": 29308, "agent.id": 29318, "agent.ts": "2017-09-05 22:37:34", "agent.title": "R P RYAN INSURANCE INC", "agent.pull_right": "10.63 mi", "agent.phone_number": "(602) 992-9700", "agent.street_address": "18501 N 40TH ST. SUITE 102", "agent.address_locality": "Phoenix, AZ 85032" }, "29309": { "city_x_agent.id": 29309, "agent.id": 29319, "agent.ts": "2017-09-05 22:37:34", "agent.title": "I INSURE INC", "agent.pull_right": "11.39 mi", "agent.phone_number": "(602) 882-5733", "agent.street_address": "5401 E THUNDERBIRD RD", "agent.address_locality": "Scottsdale, AZ 85254-3656" }, "29312": { "city_x_agent.id": 29312, "agent.id": 29322, "agent.ts": "2017-09-05 22:37:34", "agent.title": "BOWMAN & ASSOCIATES INSURANCE", "agent.pull_right": "12.33 mi", "agent.phone_number": "(602) 482-3300", "agent.street_address": "16042 N 32ND ST STE A", "agent.address_locality": "Phoenix, AZ 85032-3894" }, "29313": { "city_x_agent.id": 29313, "agent.id": 29323, "agent.ts": "2017-09-05 22:37:34", "agent.title": "LOW & JOHNSON INC", "agent.pull_right": "12.63 mi", "agent.phone_number": "(480) 596-0750", "agent.street_address": "5817 E LEITH LN", "agent.address_locality": "Scottsdale, AZ 85254-4851" }, "29314": { "city_x_agent.id": 29314, "agent.id": 29324, "agent.ts": "2017-09-05 22:37:34", "agent.title": "MICKELSON AGENCY LLC", "agent.pull_right": "12.79 mi", "agent.phone_number": "(602) 953-7676", "agent.street_address": "11811 N TATUM BLVD STE 3031", "agent.address_locality": "Phoenix, AZ 85028" }, "29315": { "city_x_agent.id": 29315, "agent.id": 29325, "agent.ts": "2017-09-05 22:37:34", "agent.title": "INS PROFESSIONALS NETWORK LLC", "agent.pull_right": "12.88 mi", "agent.phone_number": "(602) 234-0405", "agent.street_address": "PO BOX 30407", "agent.address_locality": "Phoenix, AZ 85046-0407" }, "29316": { "city_x_agent.id": 29316, "agent.id": 29326, "agent.ts": "2017-09-05 22:37:34", "agent.title": "PREMIER GROUP INSURANCE INC", "agent.pull_right": "12.89 mi", "agent.phone_number": "(480) 231-5329", "agent.street_address": "7702 E DOUBLETREE RANCH RD#300", "agent.address_locality": "Scottsdale, AZ 85258" }, "29317": { "city_x_agent.id": 29317, "agent.id": 29327, "agent.ts": "2017-09-05 22:37:34", "agent.title": "VIP INSURANCE SERVICES LLC", "agent.pull_right": "13.19 mi", "agent.phone_number": "(480) 696-6438", "agent.street_address": "9221 E. VIA DE VENTURE", "agent.address_locality": "Scottsdale, AZ 85258" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "84": { "city.id": 84, "city.ts": "2017-09-05 22:38:25", "city.title": "Anthem", "city.city_x_agent_id": { "617": { "city_x_agent.id": 617, "agent.id": 599, "agent.ts": "2017-09-05 05:31:23", "agent.title": "Maximos Soliman", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 315-0400", "agent.street_address": "16420 N 92nd St Ste 105", "agent.address_locality": "Scottsdale, AZ 85260" }, "29355": { "city_x_agent.id": 29355, "agent.id": 600, "agent.ts": "2017-09-05 05:28:31", "agent.title": "WESTERN AG-INS AGENCY INC", "agent.pull_right": "8.76 mi", "agent.phone_number": "(480) 550-1507", "agent.street_address": "STE 207", "agent.address_locality": "28170 N Alma School Pkwy, AZ 85262" }, "29354": { "city_x_agent.id": 29354, "agent.id": 601, "agent.ts": "2017-09-05 05:28:31", "agent.title": "WESTERN AG-INS AGENCY INC", "agent.pull_right": "8.76 mi", "agent.phone_number": "(480) 550-1507", "agent.street_address": "28170 N ALMA SCHOOL PKWY STE 207", "agent.address_locality": "Scottsdale, AZ 85262-8053" }, "29349": { "city_x_agent.id": 29349, "agent.id": 602, "agent.ts": "2017-09-05 05:28:31", "agent.title": "JVP INS AGENCY LLC", "agent.pull_right": "7.88 mi", "agent.phone_number": "(480) 473-3100", "agent.street_address": "10025 E DYNAMITE BLVD STE B135", "agent.address_locality": "Scottsdale, AZ 85262-3688" }, "29357": { "city_x_agent.id": 29357, "agent.id": 604, "agent.ts": "2017-09-05 05:27:12", "agent.title": "BRIDGELIGHT INSURANCE", "agent.pull_right": "5.17 mi", "agent.phone_number": "(480) 999-3020", "agent.street_address": "20645 N PIMA RD STE 225", "agent.address_locality": "Scottsdale, AZ 85255-5681" }, "29356": { "city_x_agent.id": 29356, "agent.id": 606, "agent.ts": "2017-09-05 05:27:12", "agent.title": "CREST INSURANCE GROUP", "agent.pull_right": "6.01 mi", "agent.phone_number": "(520) 881-5760", "agent.street_address": "8302 E BUTEO DR", "agent.address_locality": "Scottsdale, AZ 85255-3920" }, "29363": { "city_x_agent.id": 29363, "agent.id": 607, "agent.ts": "2017-09-05 05:27:12", "agent.title": "GREENE INS GROUP LLC", "agent.pull_right": "7.45 mi", "agent.phone_number": "(480) 657-2800", "agent.street_address": "17470 N PACESETTER WAY", "agent.address_locality": "Scottsdale, AZ 85255-5445" }, "609": { "city_x_agent.id": 609, "agent.id": 609, "agent.ts": "2017-09-05 05:28:31", "agent.title": "KEN RAGASA CUADERNO", "agent.pull_right": "9.97 mi", "agent.phone_number": "(623) 551-1660", "agent.street_address": "41122 N REPUBLIC WAY", "agent.address_locality": "Anthem, AZ 85086-1513" }, "610": { "city_x_agent.id": 610, "agent.id": 610, "agent.ts": "2017-09-05 05:27:23", "agent.title": "FIRSTMARK INSURANCE GROUP INC", "agent.pull_right": "0.90 mi", "agent.phone_number": "(206) 701-9214", "agent.street_address": "42104 N VENTURE DR STE C100", "agent.address_locality": "Anthem, AZ 85086-3856" }, "611": { "city_x_agent.id": 611, "agent.id": 611, "agent.ts": "2017-09-05 05:28:31", "agent.title": "PREMIER GROUP INSURANCE INC", "agent.pull_right": "9.60 mi", "agent.phone_number": "(623) 742-6891", "agent.street_address": "2907 W IRVINE RD", "agent.address_locality": "Phoenix, AZ 85086-8339" }, "612": { "city_x_agent.id": 612, "agent.id": 612, "agent.ts": "2017-09-05 05:27:23", "agent.title": "OXLEY INSURANCE GROUP LLC", "agent.pull_right": "2.73 mi", "agent.phone_number": "(623) 551-8671", "agent.street_address": "43704 N 50TH DR", "agent.address_locality": "Phoenix, AZ 85087-3089" }, "613": { "city_x_agent.id": 613, "agent.id": 613, "agent.ts": "2017-09-05 05:27:23", "agent.title": "CANYON LANDS INSURANCE 1 INC", "agent.pull_right": "7.95 mi", "agent.phone_number": "(623) 552-3248", "agent.street_address": "2051 W MADRE DEL ORO DR", "agent.address_locality": "Phoenix, AZ 85085-6712" }, "614": { "city_x_agent.id": 614, "agent.id": 614, "agent.ts": "2017-09-05 05:28:31", "agent.title": "John Delbrocco", "agent.pull_right": "11.66 mi", "agent.phone_number": "(602) 863-1315", "agent.street_address": "20235 N Cave Creek Rd Ste 110", "agent.address_locality": "Phoenix, AZ 85024-0800" }, "615": { "city_x_agent.id": 615, "agent.id": 615, "agent.ts": "2017-09-05 05:30:33", "agent.title": "Maximos Soliman", "agent.pull_right": "7.95 mi", "agent.phone_number": "(602) 540-3673", "agent.street_address": "16841 N 31st Ave STE 146", "agent.address_locality": "Phoenix, AZ 85053" }, "616": { "city_x_agent.id": 616, "agent.id": 616, "agent.ts": "2017-09-05 05:31:43", "agent.title": "TJ Mazur", "agent.pull_right": "6.68 mi", "agent.phone_number": "(623) 776-8501", "agent.street_address": "7121 W Bell Rd Ste 30L", "agent.address_locality": "Glendale, AZ 85308-8559" }, "618": { "city_x_agent.id": 618, "agent.id": 618, "agent.ts": "2017-09-05 05:30:42", "agent.title": "Edgar Acosta", "agent.pull_right": "8.32 mi", "agent.phone_number": "(623) 302-0313", "agent.street_address": "7141 N 51st Ave Ste B", "agent.address_locality": "Glendale, AZ 85301" }, "29328": { "city_x_agent.id": 29328, "agent.id": 635, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Ryan J Larson", "agent.pull_right": "9.37 mi", "agent.phone_number": "(602) 393-1338", "agent.street_address": "1500 E Bethany Home Rd Ste 170", "agent.address_locality": "Phoenix, AZ 85014-2444" }, "29329": { "city_x_agent.id": 29329, "agent.id": 637, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "7.76 mi", "agent.phone_number": "(602) 493-4851", "agent.street_address": "2415 E Camelback Rd Ste 700", "agent.address_locality": "Phoenix, AZ 85016" }, "29332": { "city_x_agent.id": 29332, "agent.id": 651, "agent.ts": "2017-09-05 05:28:31", "agent.title": "TYROL INSURANCE AGENCY INC", "agent.pull_right": "1.79 mi", "agent.phone_number": "(480) 488-2113", "agent.street_address": "7206 E CAVE CREEK RD", "agent.address_locality": "Carefree, AZ 85377" }, "29331": { "city_x_agent.id": 29331, "agent.id": 652, "agent.ts": "2017-09-05 05:28:31", "agent.title": "EVERS INS SERVICES LLC", "agent.pull_right": "1.56 mi", "agent.phone_number": "(602) 741-7777", "agent.street_address": "7100 E CAVE CREEK RD BLDG 12 #124", "agent.address_locality": "Cave Creek, AZ 85331-4305" }, "29351": { "city_x_agent.id": 29351, "agent.id": 720, "agent.ts": "2017-09-05 05:30:33", "agent.title": "HENDERSON ANDERSON INSURANCE", "agent.pull_right": "3.19 mi", "agent.phone_number": "(866) 241-9005", "agent.street_address": "6677 W THUNDERBIRD RD STE K182", "agent.address_locality": "Glendale, AZ 85306-3758" }, "29346": { "city_x_agent.id": 29346, "agent.id": 765, "agent.ts": "2017-09-05 05:31:43", "agent.title": "ENSIGN & ASSOC", "agent.pull_right": "5.41 mi", "agent.phone_number": "(623) 888-3041", "agent.street_address": "16165 N 83RD AVE STE 200", "agent.address_locality": "Peoria, AZ 85382-5816" }, "29344": { "city_x_agent.id": 29344, "agent.id": 767, "agent.ts": "2017-09-05 05:30:33", "agent.title": "ALL AMERICAN WESTERN INS INC", "agent.pull_right": "4.86 mi", "agent.phone_number": "(623) 773-9232", "agent.street_address": "6541 W BELL RD #1070", "agent.address_locality": "Glendale, AZ 85308" }, "29339": { "city_x_agent.id": 29339, "agent.id": 768, "agent.ts": "2017-09-05 05:30:33", "agent.title": "GLENDALE INSURANCE LLC", "agent.pull_right": "6.63 mi", "agent.phone_number": "(602) 843-1802", "agent.street_address": "19420 N 59 AVE BLDG B STE 245", "agent.address_locality": "Glendale, AZ 85308" }, "29362": { "city_x_agent.id": 29362, "agent.id": 826, "agent.ts": "2017-09-05 05:31:43", "agent.title": "A SUN COUNTRY INS AGENCY LLC", "agent.pull_right": "2.85 mi", "agent.phone_number": "(877) 862-9631", "agent.street_address": "14537 W GRAND AVE STE 140 # 59", "agent.address_locality": "Surprise, AZ 85374-8651" }, "29352": { "city_x_agent.id": 29352, "agent.id": 29291, "agent.ts": "2017-09-05 22:37:15", "agent.title": "THE AMBASSADOR GROUP INC", "agent.pull_right": "7.92 mi", "agent.phone_number": "(480) 776-6950", "agent.street_address": "7010 E CHAUNCEY LN STE 230", "agent.address_locality": "Phoenix, AZ 85054-3118" }, "29353": { "city_x_agent.id": 29353, "agent.id": 29292, "agent.ts": "2017-09-05 22:37:15", "agent.title": "VAN LEER-AMBASSADOR GRP INS", "agent.pull_right": "7.92 mi", "agent.phone_number": "(480) 776-6950", "agent.street_address": "7010 E CHAUNCEY LN STE 230", "agent.address_locality": "Phoenix, AZ 85054-3118" }, "29364": { "city_x_agent.id": 29364, "agent.id": 29293, "agent.ts": "2017-09-05 22:37:15", "agent.title": "AZCAL INSURANCE SVS AGENCY INC", "agent.pull_right": "8.59 mi", "agent.phone_number": "(480) 948-8008", "agent.street_address": "7689 E PARADISE LN STE 4", "agent.address_locality": "Scottsdale, AZ 85260-1691" }, "29358": { "city_x_agent.id": 29358, "agent.id": 29294, "agent.ts": "2017-09-05 22:37:15", "agent.title": "ALLIANCE INSURANCE PARTNERS", "agent.pull_right": "8.60 mi", "agent.phone_number": "(602) 427-4300", "agent.street_address": "16427 N SCOTTSDALE RD STE 410", "agent.address_locality": "Scottsdale, AZ 85254-7102" }, "29359": { "city_x_agent.id": 29359, "agent.id": 29298, "agent.ts": "2017-09-05 22:37:17", "agent.title": "WILLIS OF ARIZONA INC", "agent.pull_right": "8.84 mi", "agent.phone_number": "(602) 787-6000", "agent.street_address": "16220 N SCOTTSDALE RD STE 600", "agent.address_locality": "Scottsdale, AZ 85254" }, "29360": { "city_x_agent.id": 29360, "agent.id": 29299, "agent.ts": "2017-09-05 22:37:17", "agent.title": "WILLIS PERSONAL LINES INC", "agent.pull_right": "8.84 mi", "agent.phone_number": "(602) 787-6132", "agent.street_address": "16220 N SCOTTSDALE RD STE 600", "agent.address_locality": "Scottsdale, AZ 85254-1804" }, "29365": { "city_x_agent.id": 29365, "agent.id": 29303, "agent.ts": "2017-09-05 22:37:17", "agent.title": "SULLIVAN JAMES LLC", "agent.pull_right": "9.69 mi", "agent.phone_number": "(480) 382-7332", "agent.street_address": "7077 E MARILYN RD STE 13", "agent.address_locality": "Scottsdale, AZ 85254-2781" }, "29342": { "city_x_agent.id": 29342, "agent.id": 29307, "agent.ts": "2017-09-05 22:37:17", "agent.title": "ACCURATE INS AGENCY LLC", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 447-2267", "agent.street_address": "20660 N 40TH ST UNIT 2027", "agent.address_locality": "Phoenix, AZ 85050-7314" }, "29345": { "city_x_agent.id": 29345, "agent.id": 29318, "agent.ts": "2017-09-05 22:37:34", "agent.title": "R P RYAN INSURANCE INC", "agent.pull_right": "10.63 mi", "agent.phone_number": "(602) 992-9700", "agent.street_address": "18501 N 40TH ST. SUITE 102", "agent.address_locality": "Phoenix, AZ 85032" }, "29361": { "city_x_agent.id": 29361, "agent.id": 29319, "agent.ts": "2017-09-05 22:37:34", "agent.title": "I INSURE INC", "agent.pull_right": "11.39 mi", "agent.phone_number": "(602) 882-5733", "agent.street_address": "5401 E THUNDERBIRD RD", "agent.address_locality": "Scottsdale, AZ 85254-3656" }, "29348": { "city_x_agent.id": 29348, "agent.id": 29322, "agent.ts": "2017-09-05 22:37:34", "agent.title": "BOWMAN & ASSOCIATES INSURANCE", "agent.pull_right": "12.33 mi", "agent.phone_number": "(602) 482-3300", "agent.street_address": "16042 N 32ND ST STE A", "agent.address_locality": "Phoenix, AZ 85032-3894" }, "29367": { "city_x_agent.id": 29367, "agent.id": 29324, "agent.ts": "2017-09-05 22:37:34", "agent.title": "MICKELSON AGENCY LLC", "agent.pull_right": "12.79 mi", "agent.phone_number": "(602) 953-7676", "agent.street_address": "11811 N TATUM BLVD STE 3031", "agent.address_locality": "Phoenix, AZ 85028" }, "29350": { "city_x_agent.id": 29350, "agent.id": 29325, "agent.ts": "2017-09-05 22:37:34", "agent.title": "INS PROFESSIONALS NETWORK LLC", "agent.pull_right": "12.88 mi", "agent.phone_number": "(602) 234-0405", "agent.street_address": "PO BOX 30407", "agent.address_locality": "Phoenix, AZ 85046-0407" }, "29330": { "city_x_agent.id": 29330, "agent.id": 29340, "agent.ts": "2017-09-05 22:37:45", "agent.title": "HATCH INSURANCE AGENCY INC", "agent.pull_right": "11.28 mi", "agent.phone_number": "(602) 995-5692", "agent.street_address": "2222 W PARKSIDE LN STE 117", "agent.address_locality": "Phoenix, AZ 85027-1260" }, "29333": { "city_x_agent.id": 29333, "agent.id": 29343, "agent.ts": "2017-09-05 22:37:45", "agent.title": "BRIGHTWAY INSURANCE", "agent.pull_right": "12.25 mi", "agent.phone_number": "(623) 243-7450", "agent.street_address": "21620 N 19TH AVE STE A10", "agent.address_locality": "Phoenix, AZ 85027-2716" }, "29334": { "city_x_agent.id": 29334, "agent.id": 29344, "agent.ts": "2017-09-05 22:37:45", "agent.title": "SJS INSURANCE LLC", "agent.pull_right": "12.28 mi", "agent.phone_number": "(480) 525-7611", "agent.street_address": "21436 N 20TH AVE # 210", "agent.address_locality": "Phoenix, AZ 85027-2612" }, "29335": { "city_x_agent.id": 29335, "agent.id": 29345, "agent.ts": "2017-09-05 22:37:45", "agent.title": "WELLS FARGO INS SVCS USA INC", "agent.pull_right": "12.56 mi", "agent.phone_number": "(612) 215-3685", "agent.street_address": "2222 W ROSE GARDEN LN FL 2", "agent.address_locality": "Phoenix, AZ 85027-2644" }, "29336": { "city_x_agent.id": 29336, "agent.id": 29346, "agent.ts": "2017-09-05 22:37:45", "agent.title": "THE MAHONEY GROUP", "agent.pull_right": "13.08 mi", "agent.phone_number": "(480) 214-2743", "agent.street_address": "20333 N 19TH AVE STE 200", "agent.address_locality": "Phoenix, AZ 85027-3643" }, "29338": { "city_x_agent.id": 29338, "agent.id": 29348, "agent.ts": "2017-09-05 22:38:03", "agent.title": "ALPHA INSURANCE SERVICES, LLP", "agent.pull_right": "13.40 mi", "agent.phone_number": "(623) 581-5234", "agent.street_address": "2401 W BEHREND DR STE 69", "agent.address_locality": "Phoenix, AZ 85027-4145" }, "29340": { "city_x_agent.id": 29340, "agent.id": 29350, "agent.ts": "2017-09-05 22:38:03", "agent.title": "RICHARD FERREIRA INS AGCY LLC", "agent.pull_right": "14.02 mi", "agent.phone_number": "(520) 448-4498", "agent.street_address": "2550 W UNION HILLS DR STE 350", "agent.address_locality": "Phoenix, AZ 85027-5187" }, "29341": { "city_x_agent.id": 29341, "agent.id": 29351, "agent.ts": "2017-09-05 22:38:03", "agent.title": "BAILEY INS LTD", "agent.pull_right": "14.35 mi", "agent.phone_number": "(602) 866-2600", "agent.street_address": "717 W UNION HILLS DR STE 10", "agent.address_locality": "Phoenix, AZ 85027-5580" }, "29343": { "city_x_agent.id": 29343, "agent.id": 29353, "agent.ts": "2017-09-05 22:38:03", "agent.title": "CDS INSURANCE AGENCY LLC", "agent.pull_right": "15.50 mi", "agent.phone_number": "(602) 996-5000", "agent.street_address": "706 E BELL RD STE 211", "agent.address_locality": "Phoenix, AZ 85022-6658" }, "29366": { "city_x_agent.id": 29366, "agent.id": 29376, "agent.ts": "2017-09-05 22:38:16", "agent.title": "SEMINOFF & ASSOCIATES LLC", "agent.pull_right": "20.13 mi", "agent.phone_number": "(602) 957-0915", "agent.street_address": "1124 E VOGEL AVE", "agent.address_locality": "Phoenix, AZ 85020-2621" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "85": { "city.id": 85, "city.ts": "2017-09-05 22:39:07", "city.title": "Apache Junction", "city.city_x_agent_id": { "29378": { "city_x_agent.id": 29378, "agent.id": 599, "agent.ts": "2017-09-05 05:31:23", "agent.title": "Maximos Soliman", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 315-0400", "agent.street_address": "16420 N 92nd St Ste 105", "agent.address_locality": "Scottsdale, AZ 85260" }, "619": { "city_x_agent.id": 619, "agent.id": 619, "agent.ts": "2017-09-05 05:27:31", "agent.title": "JAMES CLARENCE DOWNS", "agent.pull_right": "0.46 mi", "agent.phone_number": "(480) 982-5540", "agent.street_address": "185 N APACHE TRL", "agent.address_locality": "Apache Junction, AZ 85120-3970" }, "620": { "city_x_agent.id": 620, "agent.id": 620, "agent.ts": "2017-09-05 05:27:31", "agent.title": "JUDY HOLDER INSURANCE, INC", "agent.pull_right": "1.08 mi", "agent.phone_number": "(480) 982-0273", "agent.street_address": "228 N IRONWOOD DR # 113", "agent.address_locality": "Apache Junction, AZ 85120-3819" }, "621": { "city_x_agent.id": 621, "agent.id": 621, "agent.ts": "2017-09-05 05:31:17", "agent.title": "COOK INSURANCE INC", "agent.pull_right": "17.49 mi", "agent.phone_number": "(480) 986-4400", "agent.street_address": "11512 E APACHE TRL", "agent.address_locality": "Apache Junction, AZ 85120-3523" }, "622": { "city_x_agent.id": 622, "agent.id": 622, "agent.ts": "2017-09-05 05:27:31", "agent.title": "KOHLHASE INS INC", "agent.pull_right": "8.27 mi", "agent.phone_number": "(480) 832-8370", "agent.street_address": "6550 E MAIN ST", "agent.address_locality": "Mesa, AZ 85205-9041" }, "623": { "city_x_agent.id": 623, "agent.id": 623, "agent.ts": "2017-09-05 05:29:15", "agent.title": "CANYON LANDS INSURANCE 1 INC", "agent.pull_right": "8.73 mi", "agent.phone_number": "(480) 288-5900", "agent.street_address": "3654 N POWER RD STE 146", "agent.address_locality": "Mesa, AZ 85215-9793" }, "624": { "city_x_agent.id": 624, "agent.id": 624, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Aaron Isakson", "agent.pull_right": "8.70 mi", "agent.phone_number": "(480) 888-0318", "agent.street_address": "1819 E Southern Ave Ste E-20", "agent.address_locality": "Mesa, AZ 85204" }, "625": { "city_x_agent.id": 625, "agent.id": 625, "agent.ts": "2017-09-05 05:29:15", "agent.title": "Aaron Isakson", "agent.pull_right": "0.37 mi", "agent.phone_number": "(480) 888-0318", "agent.street_address": "16930 E Palisades Blvd", "agent.address_locality": "Fountain Hills, AZ 85268" }, "626": { "city_x_agent.id": 626, "agent.id": 626, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "3.87 mi", "agent.phone_number": "(480) 945-3123", "agent.street_address": "2932 N 68th St Ste 4", "agent.address_locality": "Scottsdale, AZ 85251" }, "627": { "city_x_agent.id": 627, "agent.id": 627, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Carlos Enrique Oliveros", "agent.pull_right": "6.09 mi", "agent.phone_number": "(480) 270-2935", "agent.street_address": "8400 S Kyrene Rd Ste 230", "agent.address_locality": "Tempe, AZ 85284" }, "628": { "city_x_agent.id": 628, "agent.id": 628, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Peter Tadevossian", "agent.pull_right": "1.83 mi", "agent.phone_number": "(480) 719-7183", "agent.street_address": "1910 S Priest Dr", "agent.address_locality": "Tempe, AZ 85281" }, "29406": { "city_x_agent.id": 29406, "agent.id": 678, "agent.ts": "2017-09-05 05:29:26", "agent.title": "COLGROVE FINANCIAL LLC", "agent.pull_right": "3.76 mi", "agent.phone_number": "(480) 830-2595", "agent.street_address": "555 W CHANDLER BLVD STE 203", "agent.address_locality": "Chandler, AZ 85225-7540" }, "29407": { "city_x_agent.id": 29407, "agent.id": 679, "agent.ts": "2017-09-05 05:28:44", "agent.title": "SAN MARCOS INS GROUP LLC", "agent.pull_right": "0.55 mi", "agent.phone_number": "(480) 899-6633", "agent.street_address": "584 W CHANDLER BLVD", "agent.address_locality": "Chandler, AZ 85225-7531" }, "29415": { "city_x_agent.id": 29415, "agent.id": 680, "agent.ts": "2017-09-05 05:28:44", "agent.title": "JOHN MINARD INS SOUTHWEST LTD", "agent.pull_right": "2.81 mi", "agent.phone_number": "(480) 756-8439", "agent.street_address": "2727 W FRYE RD STE 200", "agent.address_locality": "Chandler, AZ 85224-4943" }, "29403": { "city_x_agent.id": 29403, "agent.id": 682, "agent.ts": "2017-09-05 05:29:26", "agent.title": "RIDE NOW INSURANCE LLC", "agent.pull_right": "3.44 mi", "agent.phone_number": "(888) 743-3669", "agent.street_address": "3333 N ARIZONA AVE", "agent.address_locality": "Chandler, AZ 85225-7106" }, "29402": { "city_x_agent.id": 29402, "agent.id": 683, "agent.ts": "2017-09-05 05:31:17", "agent.title": "FOOTHILLS INSURANCE AGENCY INC", "agent.pull_right": "15.10 mi", "agent.phone_number": "(480) 759-1970", "agent.street_address": "2450 S GILBERT RD STE 203", "agent.address_locality": "Chandler, AZ 85286-1595" }, "29399": { "city_x_agent.id": 29399, "agent.id": 695, "agent.ts": "2017-09-05 05:29:15", "agent.title": "GARVEY HANSEN LLC", "agent.pull_right": "0.11 mi", "agent.phone_number": "(480) 836-1468", "agent.street_address": "13034 N VERDE RIVER DR STE 101", "agent.address_locality": "Fountain Hills, AZ 85268-8443" }, "29398": { "city_x_agent.id": 29398, "agent.id": 705, "agent.ts": "2017-09-05 05:29:26", "agent.title": "LEGACY ONE INSURANCE", "agent.pull_right": "1.67 mi", "agent.phone_number": "(480) 212-1913", "agent.street_address": "725 W ELLIOT RD STE 101-5", "agent.address_locality": "Gilbert, AZ 85233-5301" }, "29392": { "city_x_agent.id": 29392, "agent.id": 706, "agent.ts": "2017-09-05 05:29:26", "agent.title": "ELITE INSURANCE GROUP LLC", "agent.pull_right": "1.73 mi", "agent.phone_number": "(480) 632-8245", "agent.street_address": "207 N GILBERT RD STE 1", "agent.address_locality": "Gilbert, AZ 85234-5812" }, "29393": { "city_x_agent.id": 29393, "agent.id": 707, "agent.ts": "2017-09-05 05:29:26", "agent.title": "GILBERT INSURANCE GROUP INC", "agent.pull_right": "1.88 mi", "agent.phone_number": "(480) 926-9030", "agent.street_address": "350 N GILBERT RD STE 202", "agent.address_locality": "Gilbert, AZ 85234-5770" }, "29389": { "city_x_agent.id": 29389, "agent.id": 708, "agent.ts": "2017-09-05 05:29:26", "agent.title": "SAN TAN INSURANCE SERVICES", "agent.pull_right": "2.22 mi", "agent.phone_number": "(480) 391-3883", "agent.street_address": "625 N GILBERT RD STE 107", "agent.address_locality": "Gilbert, AZ 85234" }, "29388": { "city_x_agent.id": 29388, "agent.id": 709, "agent.ts": "2017-09-05 05:29:26", "agent.title": "COMMERCIAL WEST INS AGENCY", "agent.pull_right": "2.64 mi", "agent.phone_number": "(480) 961-5400", "agent.street_address": "971 N GILBERT RD STE 20301", "agent.address_locality": "Gilbert, AZ 85234-3472" }, "29400": { "city_x_agent.id": 29400, "agent.id": 710, "agent.ts": "2017-09-05 05:29:26", "agent.title": "ALLIANCE INS AGCY OF AZ LLC", "agent.pull_right": "3.09 mi", "agent.phone_number": "(602) 271-9171", "agent.street_address": "1450 W GUADALUPE RD STE 117", "agent.address_locality": "Gilbert, AZ 85233-3056" }, "29401": { "city_x_agent.id": 29401, "agent.id": 742, "agent.ts": "2017-09-05 05:30:02", "agent.title": "PASSEY BOND CO INC", "agent.pull_right": "0.08 mi", "agent.phone_number": "(480) 969-2291", "agent.street_address": "28 N CENTER ST", "agent.address_locality": "Mesa, AZ 85201-7328" }, "29394": { "city_x_agent.id": 29394, "agent.id": 743, "agent.ts": "2017-09-05 05:30:02", "agent.title": "LEBARON & CARROLL LLC", "agent.pull_right": "2.35 mi", "agent.phone_number": "(480) 834-9315", "agent.street_address": "1350 E SOUTHERN AVE", "agent.address_locality": "Mesa, AZ 85204-5142" }, "29396": { "city_x_agent.id": 29396, "agent.id": 745, "agent.ts": "2017-09-05 05:30:02", "agent.title": "MASSEY GROUP LLC", "agent.pull_right": "2.35 mi", "agent.phone_number": "(480) 729-6088", "agent.street_address": "1350 E SOUTHERN AVE", "agent.address_locality": "Mesa, AZ 85204-5142" }, "29404": { "city_x_agent.id": 29404, "agent.id": 746, "agent.ts": "2017-09-05 05:30:02", "agent.title": "THE MAHONEY GROUP", "agent.pull_right": "2.65 mi", "agent.phone_number": "(480) 730-4920", "agent.street_address": "1835 S EXTENSION RD", "agent.address_locality": "Mesa, AZ 85210-5942" }, "29387": { "city_x_agent.id": 29387, "agent.id": 790, "agent.ts": "2017-09-05 05:31:17", "agent.title": "THE INS TEAM", "agent.pull_right": "6.98 mi", "agent.phone_number": "(480) 626-1860", "agent.street_address": "22246 S ELLSWORTH RD", "agent.address_locality": "Queen Creek, AZ 85142-8358" }, "29390": { "city_x_agent.id": 29390, "agent.id": 791, "agent.ts": "2017-09-05 05:31:17", "agent.title": "OVERLAND INSURANCE SERVICES", "agent.pull_right": "8.28 mi", "agent.phone_number": "(800) 677-4027", "agent.street_address": "18842 E VIA DEL ORO", "agent.address_locality": "Queen Creek, AZ 85142-4063" }, "29391": { "city_x_agent.id": 29391, "agent.id": 792, "agent.ts": "2017-09-05 05:31:17", "agent.title": "OVERLAND MANAGEMENT CORP", "agent.pull_right": "8.28 mi", "agent.phone_number": "(800) 677-4027", "agent.street_address": "18842 E VIA DEL ORO", "agent.address_locality": "Queen Creek, AZ 85142-4063" }, "29383": { "city_x_agent.id": 29383, "agent.id": 793, "agent.ts": "2017-09-05 05:31:17", "agent.title": "A ARIZONA INS AGENCY LLC", "agent.pull_right": "6.11 mi", "agent.phone_number": "(480) 677-2575", "agent.street_address": "1542 OCOTILLO RD", "agent.address_locality": "San Tan Valley, AZ 85140" }, "29397": { "city_x_agent.id": 29397, "agent.id": 794, "agent.ts": "2017-09-05 05:31:17", "agent.title": "PINNACLE INSURANCE GROUP LLP", "agent.pull_right": "9.37 mi", "agent.phone_number": "(480) 474-0334", "agent.street_address": "17933 E SANOQUE BLVD", "agent.address_locality": "Gilbert, AZ 85298-8973" }, "29384": { "city_x_agent.id": 29384, "agent.id": 795, "agent.ts": "2017-09-05 05:31:17", "agent.title": "PREMIER GROUP INSURANCE INC", "agent.pull_right": "11.54 mi", "agent.phone_number": "(480) 275-2555", "agent.street_address": "4365 E PECOS RD STE 140", "agent.address_locality": "Gilbert, AZ 85295-8053" }, "29405": { "city_x_agent.id": 29405, "agent.id": 796, "agent.ts": "2017-09-05 05:31:17", "agent.title": "BATCHSOFT LLC", "agent.pull_right": "13.57 mi", "agent.phone_number": "(480) 436-7077", "agent.street_address": "4058 S WHITE DR STE A1", "agent.address_locality": "Chandler, AZ 85249-5533" }, "29412": { "city_x_agent.id": 29412, "agent.id": 818, "agent.ts": "2017-09-05 05:31:23", "agent.title": "EATON PROVIDENT GROUP LLC", "agent.pull_right": "0.85 mi", "agent.phone_number": "(480) 941-4895", "agent.street_address": "3333 N HAYDEN RD", "agent.address_locality": "Scottsdale, AZ 85251-6626" }, "29414": { "city_x_agent.id": 29414, "agent.id": 819, "agent.ts": "2017-09-05 05:31:23", "agent.title": "BENNETT & PORTER INS SERVICES", "agent.pull_right": "0.90 mi", "agent.phone_number": "(480) 212-1150", "agent.street_address": "3200 N HAYDEN RD STE 310", "agent.address_locality": "Scottsdale, AZ 85251-6655" }, "29416": { "city_x_agent.id": 29416, "agent.id": 820, "agent.ts": "2017-09-05 05:31:23", "agent.title": "ROADRUNNER INS LLC", "agent.pull_right": "2.22 mi", "agent.phone_number": "(480) 625-4108", "agent.street_address": "5976 N 83RD ST", "agent.address_locality": "Scottsdale, AZ 85250-6215" }, "29411": { "city_x_agent.id": 29411, "agent.id": 843, "agent.ts": "2017-09-05 05:32:01", "agent.title": "ARIZONA INSURANCE AGENCY", "agent.pull_right": "1.96 mi", "agent.phone_number": "(480) 966-3400", "agent.street_address": "1713 E BROADWAY RD", "agent.address_locality": "Tempe, AZ 85282-1611" }, "29413": { "city_x_agent.id": 29413, "agent.id": 29327, "agent.ts": "2017-09-05 22:37:34", "agent.title": "VIP INSURANCE SERVICES LLC", "agent.pull_right": "13.19 mi", "agent.phone_number": "(480) 696-6438", "agent.street_address": "9221 E. VIA DE VENTURE", "agent.address_locality": "Scottsdale, AZ 85258" }, "29379": { "city_x_agent.id": 29379, "agent.id": 29389, "agent.ts": "2017-09-05 22:38:36", "agent.title": "FOX RELIABLE INS SERVICES", "agent.pull_right": "10.31 mi", "agent.phone_number": "(480) 807-7753", "agent.street_address": "4930 E MAIN ST STE 9", "agent.address_locality": "Mesa, AZ 85205-8005" }, "29380": { "city_x_agent.id": 29380, "agent.id": 29390, "agent.ts": "2017-09-05 22:38:36", "agent.title": "SOUTHWEST RISK MANAGEMENT LLC", "agent.pull_right": "10.66 mi", "agent.phone_number": "(480) 924-1200", "agent.street_address": "4801 E MCKELLIPS RD", "agent.address_locality": "Mesa, AZ 85215-2527" }, "29381": { "city_x_agent.id": 29381, "agent.id": 29391, "agent.ts": "2017-09-05 22:38:36", "agent.title": "WILSON INSURANCE INC", "agent.pull_right": "11.56 mi", "agent.phone_number": "(480) 964-2400", "agent.street_address": "3950 E BROADWAY RD STE 102", "agent.address_locality": "Mesa, AZ 85206-1031" }, "29382": { "city_x_agent.id": 29382, "agent.id": 29392, "agent.ts": "2017-09-05 22:38:36", "agent.title": "BREINHOLT INSURANCE GROUP LLC", "agent.pull_right": "11.74 mi", "agent.phone_number": "(480) 237-2050", "agent.street_address": "4115 E VALLEY AUTO DR STE 205", "agent.address_locality": "Mesa, AZ 85206-4612" }, "29385": { "city_x_agent.id": 29385, "agent.id": 29395, "agent.ts": "2017-09-05 22:38:36", "agent.title": "THE ARIZONA GROUP", "agent.pull_right": "12.73 mi", "agent.phone_number": "(480) 892-8755", "agent.street_address": "3325 E BASELINE RD", "agent.address_locality": "Gilbert, AZ 85234-2633" }, "29386": { "city_x_agent.id": 29386, "agent.id": 29396, "agent.ts": "2017-09-05 22:38:36", "agent.title": "STRONG TOWER INS GROUP INC", "agent.pull_right": "12.81 mi", "agent.phone_number": "(480) 926-9011", "agent.street_address": "3303 E BASELINE RD STE 101", "agent.address_locality": "Gilbert, AZ 85234-2739" }, "29408": { "city_x_agent.id": 29408, "agent.id": 29418, "agent.ts": "2017-09-05 22:39:01", "agent.title": "GBP RISK SOLUTIONS", "agent.pull_right": "19.57 mi", "agent.phone_number": "(480) 775-1811", "agent.street_address": "2222 S DOBSON RD STE 502", "agent.address_locality": "Mesa, AZ 85202-6493" }, "29410": { "city_x_agent.id": 29410, "agent.id": 29420, "agent.ts": "2017-09-05 22:39:01", "agent.title": "ALL VALLEY INSURANCE", "agent.pull_right": "19.61 mi", "agent.phone_number": "(480) 498-2278", "agent.street_address": "2266 S DOBSON RD STE 200", "agent.address_locality": "Mesa, AZ 85202-6412" }, "29417": { "city_x_agent.id": 29417, "agent.id": 29427, "agent.ts": "2017-09-05 22:39:01", "agent.title": "CANYON LANDS INSURANCE 1 INC", "agent.pull_right": "21.90 mi", "agent.phone_number": "(602) 953-6926", "agent.street_address": "8722 E VIA DE COMMERCIO STE 20", "agent.address_locality": "Scottsdale, AZ 85258-3434" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "86": { "city.id": 86, "city.ts": "2017-09-05 22:39:36", "city.title": "Avondale", "city.city_x_agent_id": { "29432": { "city_x_agent.id": 29432, "agent.id": 614, "agent.ts": "2017-09-05 05:28:31", "agent.title": "John Delbrocco", "agent.pull_right": "11.66 mi", "agent.phone_number": "(602) 863-1315", "agent.street_address": "20235 N Cave Creek Rd Ste 110", "agent.address_locality": "Phoenix, AZ 85024-0800" }, "636": { "city_x_agent.id": 636, "agent.id": 615, "agent.ts": "2017-09-05 05:30:33", "agent.title": "Maximos Soliman", "agent.pull_right": "7.95 mi", "agent.phone_number": "(602) 540-3673", "agent.street_address": "16841 N 31st Ave STE 146", "agent.address_locality": "Phoenix, AZ 85053" }, "634": { "city_x_agent.id": 634, "agent.id": 616, "agent.ts": "2017-09-05 05:31:43", "agent.title": "TJ Mazur", "agent.pull_right": "6.68 mi", "agent.phone_number": "(623) 776-8501", "agent.street_address": "7121 W Bell Rd Ste 30L", "agent.address_locality": "Glendale, AZ 85308-8559" }, "633": { "city_x_agent.id": 633, "agent.id": 618, "agent.ts": "2017-09-05 05:30:42", "agent.title": "Edgar Acosta", "agent.pull_right": "8.32 mi", "agent.phone_number": "(623) 302-0313", "agent.street_address": "7141 N 51st Ave Ste B", "agent.address_locality": "Glendale, AZ 85301" }, "29430": { "city_x_agent.id": 29430, "agent.id": 626, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "3.87 mi", "agent.phone_number": "(480) 945-3123", "agent.street_address": "2932 N 68th St Ste 4", "agent.address_locality": "Scottsdale, AZ 85251" }, "29431": { "city_x_agent.id": 29431, "agent.id": 627, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Carlos Enrique Oliveros", "agent.pull_right": "6.09 mi", "agent.phone_number": "(480) 270-2935", "agent.street_address": "8400 S Kyrene Rd Ste 230", "agent.address_locality": "Tempe, AZ 85284" }, "29429": { "city_x_agent.id": 29429, "agent.id": 628, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Peter Tadevossian", "agent.pull_right": "1.83 mi", "agent.phone_number": "(480) 719-7183", "agent.street_address": "1910 S Priest Dr", "agent.address_locality": "Tempe, AZ 85281" }, "629": { "city_x_agent.id": 629, "agent.id": 629, "agent.ts": "2017-09-05 05:27:49", "agent.title": "A1 INSURANCE LLC", "agent.pull_right": "17.42 mi", "agent.phone_number": "(602) 635-7411", "agent.street_address": "12409 W INDIAN SCHOOL RD C 302", "agent.address_locality": "Avondale, AZ 85392-9508" }, "630": { "city_x_agent.id": 630, "agent.id": 630, "agent.ts": "2017-09-05 05:27:49", "agent.title": "KENNY ONG FINANCIAL SERVICES", "agent.pull_right": "21.14 mi", "agent.phone_number": "(623) 907-8800", "agent.street_address": "8450 W MCDOWELL RD STE 105", "agent.address_locality": "Phoenix, AZ 85037-4150" }, "631": { "city_x_agent.id": 631, "agent.id": 631, "agent.ts": "2017-09-05 05:30:33", "agent.title": "COPPER MOUNTAIN INS SOLUTIONS", "agent.pull_right": "3.23 mi", "agent.phone_number": "(602) 412-3366", "agent.street_address": "6751 N SUNSET BLVD STE 320", "agent.address_locality": "Glendale, AZ 85305-3155" }, "632": { "city_x_agent.id": 632, "agent.id": 632, "agent.ts": "2017-09-05 05:30:42", "agent.title": "Miguel Torres", "agent.pull_right": "7.16 mi", "agent.phone_number": "(623) 873-1234", "agent.street_address": "5901 W Indian School Rd Ste 4", "agent.address_locality": "Phoenix, AZ 85033" }, "635": { "city_x_agent.id": 635, "agent.id": 635, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Ryan J Larson", "agent.pull_right": "9.37 mi", "agent.phone_number": "(602) 393-1338", "agent.street_address": "1500 E Bethany Home Rd Ste 170", "agent.address_locality": "Phoenix, AZ 85014-2444" }, "637": { "city_x_agent.id": 637, "agent.id": 637, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "7.76 mi", "agent.phone_number": "(602) 493-4851", "agent.street_address": "2415 E Camelback Rd Ste 700", "agent.address_locality": "Phoenix, AZ 85016" }, "638": { "city_x_agent.id": 638, "agent.id": 638, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Michelle Riachi", "agent.pull_right": "5.17 mi", "agent.phone_number": "(480) 438-8214", "agent.street_address": "9830 S 51st St Ste A127", "agent.address_locality": "Phoenix, AZ 85044" }, "29440": { "city_x_agent.id": 29440, "agent.id": 639, "agent.ts": "2017-09-05 05:27:49", "agent.title": "POWERS/LEAVITT INS AGENCY", "agent.pull_right": "0.03 mi", "agent.phone_number": "(623) 386-4452", "agent.street_address": "111 E MONROE AVE", "agent.address_locality": "Buckeye, AZ 85326-2707" }, "29433": { "city_x_agent.id": 29433, "agent.id": 642, "agent.ts": "2017-09-05 05:31:43", "agent.title": "SUNLIGHT INSURANCE GROUP LLC", "agent.pull_right": "4.30 mi", "agent.phone_number": "(623) 218-7667", "agent.street_address": "14979 W BLOOMFIELD RD", "agent.address_locality": "Surprise, AZ 85379-5913" }, "29438": { "city_x_agent.id": 29438, "agent.id": 644, "agent.ts": "2017-09-05 05:31:43", "agent.title": "WELLS INS AGENCY LLC", "agent.pull_right": "3.65 mi", "agent.phone_number": "(623) 556-6095", "agent.street_address": "15331 W BELL RD", "agent.address_locality": "Surprise, AZ 85374" }, "29434": { "city_x_agent.id": 29434, "agent.id": 645, "agent.ts": "2017-09-05 05:31:43", "agent.title": "MCPRIDE INS AGENCY LLC", "agent.pull_right": "3.20 mi", "agent.phone_number": "(623) 535-7007", "agent.street_address": "14985 W BELL RD STE 150", "agent.address_locality": "Surprise, AZ 85374-3233" }, "29435": { "city_x_agent.id": 29435, "agent.id": 646, "agent.ts": "2017-09-05 05:31:43", "agent.title": "WADE J DRAVES INS SVCS", "agent.pull_right": "3.20 mi", "agent.phone_number": "(623) 535-7007", "agent.street_address": "14985 W BELL RD STE 150", "agent.address_locality": "Surprise, AZ 85374-3233" }, "29436": { "city_x_agent.id": 29436, "agent.id": 648, "agent.ts": "2017-09-05 05:31:43", "agent.title": "IDEAL INSURANCE AGENCY INC", "agent.pull_right": "2.28 mi", "agent.phone_number": "(623) 933-8263", "agent.street_address": "14239 W BELL RD STE 205", "agent.address_locality": "Surprise, AZ 85374-2471" }, "29428": { "city_x_agent.id": 29428, "agent.id": 676, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Ernie Barten", "agent.pull_right": "7.74 mi", "agent.phone_number": "(480) 686-3099", "agent.street_address": "4425 E Agave Rd Ste 136", "agent.address_locality": "Phoenix, AZ 85044" }, "29439": { "city_x_agent.id": 29439, "agent.id": 720, "agent.ts": "2017-09-05 05:30:33", "agent.title": "HENDERSON ANDERSON INSURANCE", "agent.pull_right": "3.19 mi", "agent.phone_number": "(866) 241-9005", "agent.street_address": "6677 W THUNDERBIRD RD STE K182", "agent.address_locality": "Glendale, AZ 85306-3758" }, "29446": { "city_x_agent.id": 29446, "agent.id": 721, "agent.ts": "2017-09-05 05:29:29", "agent.title": "ADRAR INS AGENCY LLC", "agent.pull_right": "5.43 mi", "agent.phone_number": "(602) 570-0140", "agent.street_address": "4801 N 19TH AVE STE 4", "agent.address_locality": "Phoenix, AZ 85015-7423" }, "29445": { "city_x_agent.id": 29445, "agent.id": 722, "agent.ts": "2017-09-05 05:29:29", "agent.title": "ADVANTAGE INS PLLC", "agent.pull_right": "5.50 mi", "agent.phone_number": "(623) 505-7910", "agent.street_address": "4548 N 19TH AVE", "agent.address_locality": "Phoenix, AZ 85015-4117" }, "29441": { "city_x_agent.id": 29441, "agent.id": 765, "agent.ts": "2017-09-05 05:31:43", "agent.title": "ENSIGN & ASSOC", "agent.pull_right": "5.41 mi", "agent.phone_number": "(623) 888-3041", "agent.street_address": "16165 N 83RD AVE STE 200", "agent.address_locality": "Peoria, AZ 85382-5816" }, "29455": { "city_x_agent.id": 29455, "agent.id": 767, "agent.ts": "2017-09-05 05:30:33", "agent.title": "ALL AMERICAN WESTERN INS INC", "agent.pull_right": "4.86 mi", "agent.phone_number": "(623) 773-9232", "agent.street_address": "6541 W BELL RD #1070", "agent.address_locality": "Glendale, AZ 85308" }, "29460": { "city_x_agent.id": 29460, "agent.id": 768, "agent.ts": "2017-09-05 05:30:33", "agent.title": "GLENDALE INSURANCE LLC", "agent.pull_right": "6.63 mi", "agent.phone_number": "(602) 843-1802", "agent.street_address": "19420 N 59 AVE BLDG B STE 245", "agent.address_locality": "Glendale, AZ 85308" }, "29448": { "city_x_agent.id": 29448, "agent.id": 776, "agent.ts": "2017-09-05 05:30:42", "agent.title": "WELLS FARGO INS SVCS USA INC", "agent.pull_right": "0.03 mi", "agent.phone_number": "(602) 528-3000", "agent.street_address": "100 W WASHINGTON ST FL 4", "agent.address_locality": "Phoenix, AZ 85003-1802" }, "29449": { "city_x_agent.id": 29449, "agent.id": 777, "agent.ts": "2017-09-05 05:30:42", "agent.title": "FARMER WOODS GROUP", "agent.pull_right": "0.74 mi", "agent.phone_number": "(602) 264-0566", "agent.street_address": "919 N 1ST ST", "agent.address_locality": "Phoenix, AZ 85004-1902" }, "29450": { "city_x_agent.id": 29450, "agent.id": 778, "agent.ts": "2017-09-07 21:53:23", "agent.title": "COBIZ INSURANCE INC", "agent.pull_right": "2.00 mi", "agent.phone_number": "(602) 296-2300", "agent.street_address": "2600 N CENTRAL AVE STE 1950", "agent.address_locality": "Phoenix, AZ 85004" }, "29443": { "city_x_agent.id": 29443, "agent.id": 826, "agent.ts": "2017-09-05 05:31:43", "agent.title": "A SUN COUNTRY INS AGENCY LLC", "agent.pull_right": "2.85 mi", "agent.phone_number": "(877) 862-9631", "agent.street_address": "14537 W GRAND AVE STE 140 # 59", "agent.address_locality": "Surprise, AZ 85374-8651" }, "29444": { "city_x_agent.id": 29444, "agent.id": 29454, "agent.ts": "2017-09-05 22:39:18", "agent.title": "DANIELS NICOLSON INSURANCE", "agent.pull_right": "15.01 mi", "agent.phone_number": "(602) 277-0970", "agent.street_address": "4411 N 19TH AVE", "agent.address_locality": "Phoenix, AZ 85015-4115" }, "29447": { "city_x_agent.id": 29447, "agent.id": 29457, "agent.ts": "2017-09-05 22:39:18", "agent.title": "FORTRESS CAPITAL INS L L C", "agent.pull_right": "15.58 mi", "agent.phone_number": "(602) 233-3930", "agent.street_address": "2612 N 7TH AVE STE A", "agent.address_locality": "Phoenix, AZ 85006" }, "29452": { "city_x_agent.id": 29452, "agent.id": 29462, "agent.ts": "2017-09-05 22:39:20", "agent.title": "BROWN & BROWN INS OF AZ INC", "agent.pull_right": "16.08 mi", "agent.phone_number": "(602) 996-7600", "agent.street_address": "2800 N CENTRAL AVE STE 1600", "agent.address_locality": "Phoenix, AZ 85004-1047" }, "29454": { "city_x_agent.id": 29454, "agent.id": 29464, "agent.ts": "2017-09-05 22:39:20", "agent.title": "BROWN & BROWN INSURANCE OF AZ", "agent.pull_right": "16.08 mi", "agent.phone_number": "(602) 277-6672", "agent.street_address": "2800 N CENTRAL AVE STE 1600", "agent.address_locality": "Phoenix, AZ 85004-1047" }, "29456": { "city_x_agent.id": 29456, "agent.id": 29466, "agent.ts": "2017-09-05 22:39:20", "agent.title": "SOUTHWEST INS BROKERS LLC", "agent.pull_right": "16.99 mi", "agent.phone_number": "(602) 263-0777", "agent.street_address": "510 E CAMELBACK RD", "agent.address_locality": "Phoenix, AZ 85012-1616" }, "29457": { "city_x_agent.id": 29457, "agent.id": 29467, "agent.ts": "2017-09-05 22:39:20", "agent.title": "HESTER, HEITEL & ASSOCIATES", "agent.pull_right": "17.41 mi", "agent.phone_number": "(602) 230-7726", "agent.street_address": "6122 N 7TH ST", "agent.address_locality": "Phoenix, AZ 85014-1860" }, "29458": { "city_x_agent.id": 29458, "agent.id": 29468, "agent.ts": "2017-09-05 22:39:26", "agent.title": "T D INSURANCE", "agent.pull_right": "17.64 mi", "agent.phone_number": "(602) 254-3208", "agent.street_address": "1430 E INDIAN SCHOOL RD #240", "agent.address_locality": "Phoenix, AZ 85014-4976" }, "29459": { "city_x_agent.id": 29459, "agent.id": 29469, "agent.ts": "2017-09-05 22:39:26", "agent.title": "A A A ARIZONA INC", "agent.pull_right": "17.81 mi", "agent.phone_number": "(602) 650-2700", "agent.street_address": "742 E GLENDALE AVE STE 182", "agent.address_locality": "Phoenix, AZ 85020-5358" }, "29461": { "city_x_agent.id": 29461, "agent.id": 29471, "agent.ts": "2017-09-05 22:39:26", "agent.title": "ANCAP INSURANCE", "agent.pull_right": "18.30 mi", "agent.phone_number": "(602) 943-2586", "agent.street_address": "8802 N 4TH ST", "agent.address_locality": "Phoenix, AZ 85020-2902" }, "29462": { "city_x_agent.id": 29462, "agent.id": 29472, "agent.ts": "2017-09-05 22:39:26", "agent.title": "AVI PHX INSURANCE BROKERS LLC", "agent.pull_right": "18.77 mi", "agent.phone_number": "(602) 707-7707", "agent.street_address": "7220 N 16TH ST STE C", "agent.address_locality": "Phoenix, AZ 85020-5253" }, "29463": { "city_x_agent.id": 29463, "agent.id": 29473, "agent.ts": "2017-09-05 22:39:26", "agent.title": "SOUTHWEST BONDING & INS", "agent.pull_right": "18.87 mi", "agent.phone_number": "(602) 375-5200", "agent.street_address": "7315 N 16TH ST STE 100", "agent.address_locality": "Phoenix, AZ 85020-5271" }, "29464": { "city_x_agent.id": 29464, "agent.id": 29474, "agent.ts": "2017-09-05 22:39:26", "agent.title": "SUNSTATE INSURANCE AGENCY LLC", "agent.pull_right": "18.97 mi", "agent.phone_number": "(602) 650-2700", "agent.street_address": "2375 E CAMELBACK RD STE 500", "agent.address_locality": "Phoenix, AZ 85016-3489" }, "29465": { "city_x_agent.id": 29465, "agent.id": 29475, "agent.ts": "2017-09-05 22:39:26", "agent.title": "USI INSURANCE SERVICES LLC", "agent.pull_right": "18.97 mi", "agent.phone_number": "(855) 874-0780", "agent.street_address": "2375 E CAMELBACK RD STE 250", "agent.address_locality": "Phoenix, AZ 85016-3491" }, "29466": { "city_x_agent.id": 29466, "agent.id": 29476, "agent.ts": "2017-09-05 22:39:26", "agent.title": "GARLAND INS & FINANCIAL SERV LLC", "agent.pull_right": "19.08 mi", "agent.phone_number": "(602) 953-6915", "agent.street_address": "2415 E CAMELBACK RD STE 700", "agent.address_locality": "Phoenix, AZ 85016-4245" }, "29467": { "city_x_agent.id": 29467, "agent.id": 29477, "agent.ts": "2017-09-05 22:39:26", "agent.title": "INFINITY COMMERCIAL INS INC", "agent.pull_right": "19.08 mi", "agent.phone_number": "(602) 512-1319", "agent.street_address": "2415 E CAMELBACK RD STE 700", "agent.address_locality": "Phoenix, AZ 85016-4245" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "87": { "city.id": 87, "city.ts": "2017-09-05 22:39:41", "city.title": "Buckeye", "city.city_x_agent_id": { "641": { "city_x_agent.id": 641, "agent.id": 629, "agent.ts": "2017-09-05 05:27:49", "agent.title": "A1 INSURANCE LLC", "agent.pull_right": "17.42 mi", "agent.phone_number": "(602) 635-7411", "agent.street_address": "12409 W INDIAN SCHOOL RD C 302", "agent.address_locality": "Avondale, AZ 85392-9508" }, "643": { "city_x_agent.id": 643, "agent.id": 630, "agent.ts": "2017-09-05 05:27:49", "agent.title": "KENNY ONG FINANCIAL SERVICES", "agent.pull_right": "21.14 mi", "agent.phone_number": "(623) 907-8800", "agent.street_address": "8450 W MCDOWELL RD STE 105", "agent.address_locality": "Phoenix, AZ 85037-4150" }, "647": { "city_x_agent.id": 647, "agent.id": 631, "agent.ts": "2017-09-05 05:30:33", "agent.title": "COPPER MOUNTAIN INS SOLUTIONS", "agent.pull_right": "3.23 mi", "agent.phone_number": "(602) 412-3366", "agent.street_address": "6751 N SUNSET BLVD STE 320", "agent.address_locality": "Glendale, AZ 85305-3155" }, "640": { "city_x_agent.id": 640, "agent.id": 632, "agent.ts": "2017-09-05 05:30:42", "agent.title": "Miguel Torres", "agent.pull_right": "7.16 mi", "agent.phone_number": "(623) 873-1234", "agent.street_address": "5901 W Indian School Rd Ste 4", "agent.address_locality": "Phoenix, AZ 85033" }, "639": { "city_x_agent.id": 639, "agent.id": 639, "agent.ts": "2017-09-05 05:27:49", "agent.title": "POWERS/LEAVITT INS AGENCY", "agent.pull_right": "0.03 mi", "agent.phone_number": "(623) 386-4452", "agent.street_address": "111 E MONROE AVE", "agent.address_locality": "Buckeye, AZ 85326-2707" }, "642": { "city_x_agent.id": 642, "agent.id": 642, "agent.ts": "2017-09-05 05:31:43", "agent.title": "SUNLIGHT INSURANCE GROUP LLC", "agent.pull_right": "4.30 mi", "agent.phone_number": "(623) 218-7667", "agent.street_address": "14979 W BLOOMFIELD RD", "agent.address_locality": "Surprise, AZ 85379-5913" }, "644": { "city_x_agent.id": 644, "agent.id": 644, "agent.ts": "2017-09-05 05:31:43", "agent.title": "WELLS INS AGENCY LLC", "agent.pull_right": "3.65 mi", "agent.phone_number": "(623) 556-6095", "agent.street_address": "15331 W BELL RD", "agent.address_locality": "Surprise, AZ 85374" }, "645": { "city_x_agent.id": 645, "agent.id": 645, "agent.ts": "2017-09-05 05:31:43", "agent.title": "MCPRIDE INS AGENCY LLC", "agent.pull_right": "3.20 mi", "agent.phone_number": "(623) 535-7007", "agent.street_address": "14985 W BELL RD STE 150", "agent.address_locality": "Surprise, AZ 85374-3233" }, "646": { "city_x_agent.id": 646, "agent.id": 646, "agent.ts": "2017-09-05 05:31:43", "agent.title": "WADE J DRAVES INS SVCS", "agent.pull_right": "3.20 mi", "agent.phone_number": "(623) 535-7007", "agent.street_address": "14985 W BELL RD STE 150", "agent.address_locality": "Surprise, AZ 85374-3233" }, "648": { "city_x_agent.id": 648, "agent.id": 648, "agent.ts": "2017-09-05 05:31:43", "agent.title": "IDEAL INSURANCE AGENCY INC", "agent.pull_right": "2.28 mi", "agent.phone_number": "(623) 933-8263", "agent.street_address": "14239 W BELL RD STE 205", "agent.address_locality": "Surprise, AZ 85374-2471" }, "29479": { "city_x_agent.id": 29479, "agent.id": 826, "agent.ts": "2017-09-05 05:31:43", "agent.title": "A SUN COUNTRY INS AGENCY LLC", "agent.pull_right": "2.85 mi", "agent.phone_number": "(877) 862-9631", "agent.street_address": "14537 W GRAND AVE STE 140 # 59", "agent.address_locality": "Surprise, AZ 85374-8651" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "88": { "city.id": 88, "city.ts": "2017-08-15 02:34:18", "city.title": "Bullhead City", "city.city_x_agent_id": { "649": { "city_x_agent.id": 649, "agent.id": 649, "agent.ts": "2017-09-05 05:47:58", "agent.title": "WICKERSHAM INSURANCE AGENCY", "agent.pull_right": "18.76 mi", "agent.phone_number": "(928) 758-7999", "agent.street_address": "2160 HIGHWAY 95 STE 2", "agent.address_locality": "Bullhead City, AZ 86442-6075" }, "650": { "city_x_agent.id": 650, "agent.id": 650, "agent.ts": "2017-09-05 05:47:58", "agent.title": "Arthur Horn", "agent.pull_right": "0.48 mi", "agent.phone_number": "(760) 326-5335", "agent.street_address": "1410 W Broadway St Ste A", "agent.address_locality": "Needles, CA 92363" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "89": { "city.id": 89, "city.ts": "2017-09-05 22:40:17", "city.title": "Carefree", "city.city_x_agent_id": { "658": { "city_x_agent.id": 658, "agent.id": 599, "agent.ts": "2017-09-05 05:31:23", "agent.title": "Maximos Soliman", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 315-0400", "agent.street_address": "16420 N 92nd St Ste 105", "agent.address_locality": "Scottsdale, AZ 85260" }, "654": { "city_x_agent.id": 654, "agent.id": 600, "agent.ts": "2017-09-05 05:28:31", "agent.title": "WESTERN AG-INS AGENCY INC", "agent.pull_right": "8.76 mi", "agent.phone_number": "(480) 550-1507", "agent.street_address": "STE 207", "agent.address_locality": "28170 N Alma School Pkwy, AZ 85262" }, "655": { "city_x_agent.id": 655, "agent.id": 601, "agent.ts": "2017-09-05 05:28:31", "agent.title": "WESTERN AG-INS AGENCY INC", "agent.pull_right": "8.76 mi", "agent.phone_number": "(480) 550-1507", "agent.street_address": "28170 N ALMA SCHOOL PKWY STE 207", "agent.address_locality": "Scottsdale, AZ 85262-8053" }, "653": { "city_x_agent.id": 653, "agent.id": 602, "agent.ts": "2017-09-05 05:28:31", "agent.title": "JVP INS AGENCY LLC", "agent.pull_right": "7.88 mi", "agent.phone_number": "(480) 473-3100", "agent.street_address": "10025 E DYNAMITE BLVD STE B135", "agent.address_locality": "Scottsdale, AZ 85262-3688" }, "656": { "city_x_agent.id": 656, "agent.id": 603, "agent.ts": "2017-09-05 05:28:09", "agent.title": "ARIZONA INS SPECIALISTS LLC", "agent.pull_right": "9.72 mi", "agent.phone_number": "(602) 717-4992", "agent.street_address": "30423 N 139TH ST", "agent.address_locality": "Scottsdale, AZ 85262-5988" }, "29495": { "city_x_agent.id": 29495, "agent.id": 604, "agent.ts": "2017-09-05 05:27:12", "agent.title": "BRIDGELIGHT INSURANCE", "agent.pull_right": "5.17 mi", "agent.phone_number": "(480) 999-3020", "agent.street_address": "20645 N PIMA RD STE 225", "agent.address_locality": "Scottsdale, AZ 85255-5681" }, "29497": { "city_x_agent.id": 29497, "agent.id": 605, "agent.ts": "2017-09-05 05:27:12", "agent.title": "LIGHTFOOT & ASSOCIATES LLC", "agent.pull_right": "5.45 mi", "agent.phone_number": "(720) 261-2249", "agent.street_address": "29306 N 153RD PL", "agent.address_locality": "Scottsdale, AZ 85262-6920" }, "29496": { "city_x_agent.id": 29496, "agent.id": 606, "agent.ts": "2017-09-05 05:27:12", "agent.title": "CREST INSURANCE GROUP", "agent.pull_right": "6.01 mi", "agent.phone_number": "(520) 881-5760", "agent.street_address": "8302 E BUTEO DR", "agent.address_locality": "Scottsdale, AZ 85255-3920" }, "29504": { "city_x_agent.id": 29504, "agent.id": 607, "agent.ts": "2017-09-05 05:27:12", "agent.title": "GREENE INS GROUP LLC", "agent.pull_right": "7.45 mi", "agent.phone_number": "(480) 657-2800", "agent.street_address": "17470 N PACESETTER WAY", "agent.address_locality": "Scottsdale, AZ 85255-5445" }, "29508": { "city_x_agent.id": 29508, "agent.id": 608, "agent.ts": "2017-09-05 05:29:15", "agent.title": "PRUTTING INS GROUP INC", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 502-4300", "agent.street_address": "8889 E BELL RD STE 201", "agent.address_locality": "Scottsdale, AZ 85260-1597" }, "29501": { "city_x_agent.id": 29501, "agent.id": 609, "agent.ts": "2017-09-05 05:28:31", "agent.title": "KEN RAGASA CUADERNO", "agent.pull_right": "9.97 mi", "agent.phone_number": "(623) 551-1660", "agent.street_address": "41122 N REPUBLIC WAY", "agent.address_locality": "Anthem, AZ 85086-1513" }, "29507": { "city_x_agent.id": 29507, "agent.id": 610, "agent.ts": "2017-09-05 05:27:23", "agent.title": "FIRSTMARK INSURANCE GROUP INC", "agent.pull_right": "0.90 mi", "agent.phone_number": "(206) 701-9214", "agent.street_address": "42104 N VENTURE DR STE C100", "agent.address_locality": "Anthem, AZ 85086-3856" }, "29499": { "city_x_agent.id": 29499, "agent.id": 611, "agent.ts": "2017-09-05 05:28:31", "agent.title": "PREMIER GROUP INSURANCE INC", "agent.pull_right": "9.60 mi", "agent.phone_number": "(623) 742-6891", "agent.street_address": "2907 W IRVINE RD", "agent.address_locality": "Phoenix, AZ 85086-8339" }, "29524": { "city_x_agent.id": 29524, "agent.id": 612, "agent.ts": "2017-09-05 05:27:23", "agent.title": "OXLEY INSURANCE GROUP LLC", "agent.pull_right": "2.73 mi", "agent.phone_number": "(623) 551-8671", "agent.street_address": "43704 N 50TH DR", "agent.address_locality": "Phoenix, AZ 85087-3089" }, "29500": { "city_x_agent.id": 29500, "agent.id": 613, "agent.ts": "2017-09-05 05:27:23", "agent.title": "CANYON LANDS INSURANCE 1 INC", "agent.pull_right": "7.95 mi", "agent.phone_number": "(623) 552-3248", "agent.street_address": "2051 W MADRE DEL ORO DR", "agent.address_locality": "Phoenix, AZ 85085-6712" }, "657": { "city_x_agent.id": 657, "agent.id": 614, "agent.ts": "2017-09-05 05:28:31", "agent.title": "John Delbrocco", "agent.pull_right": "11.66 mi", "agent.phone_number": "(602) 863-1315", "agent.street_address": "20235 N Cave Creek Rd Ste 110", "agent.address_locality": "Phoenix, AZ 85024-0800" }, "659": { "city_x_agent.id": 659, "agent.id": 615, "agent.ts": "2017-09-05 05:30:33", "agent.title": "Maximos Soliman", "agent.pull_right": "7.95 mi", "agent.phone_number": "(602) 540-3673", "agent.street_address": "16841 N 31st Ave STE 146", "agent.address_locality": "Phoenix, AZ 85053" }, "29490": { "city_x_agent.id": 29490, "agent.id": 616, "agent.ts": "2017-09-05 05:31:43", "agent.title": "TJ Mazur", "agent.pull_right": "6.68 mi", "agent.phone_number": "(623) 776-8501", "agent.street_address": "7121 W Bell Rd Ste 30L", "agent.address_locality": "Glendale, AZ 85308-8559" }, "29494": { "city_x_agent.id": 29494, "agent.id": 618, "agent.ts": "2017-09-05 05:30:42", "agent.title": "Edgar Acosta", "agent.pull_right": "8.32 mi", "agent.phone_number": "(623) 302-0313", "agent.street_address": "7141 N 51st Ave Ste B", "agent.address_locality": "Glendale, AZ 85301" }, "660": { "city_x_agent.id": 660, "agent.id": 625, "agent.ts": "2017-09-05 05:29:15", "agent.title": "Aaron Isakson", "agent.pull_right": "0.37 mi", "agent.phone_number": "(480) 888-0318", "agent.street_address": "16930 E Palisades Blvd", "agent.address_locality": "Fountain Hills, AZ 85268" }, "29493": { "city_x_agent.id": 29493, "agent.id": 626, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "3.87 mi", "agent.phone_number": "(480) 945-3123", "agent.street_address": "2932 N 68th St Ste 4", "agent.address_locality": "Scottsdale, AZ 85251" }, "29491": { "city_x_agent.id": 29491, "agent.id": 635, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Ryan J Larson", "agent.pull_right": "9.37 mi", "agent.phone_number": "(602) 393-1338", "agent.street_address": "1500 E Bethany Home Rd Ste 170", "agent.address_locality": "Phoenix, AZ 85014-2444" }, "29492": { "city_x_agent.id": 29492, "agent.id": 637, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "7.76 mi", "agent.phone_number": "(602) 493-4851", "agent.street_address": "2415 E Camelback Rd Ste 700", "agent.address_locality": "Phoenix, AZ 85016" }, "651": { "city_x_agent.id": 651, "agent.id": 651, "agent.ts": "2017-09-05 05:28:31", "agent.title": "TYROL INSURANCE AGENCY INC", "agent.pull_right": "1.79 mi", "agent.phone_number": "(480) 488-2113", "agent.street_address": "7206 E CAVE CREEK RD", "agent.address_locality": "Carefree, AZ 85377" }, "652": { "city_x_agent.id": 652, "agent.id": 652, "agent.ts": "2017-09-05 05:28:31", "agent.title": "EVERS INS SERVICES LLC", "agent.pull_right": "1.56 mi", "agent.phone_number": "(602) 741-7777", "agent.street_address": "7100 E CAVE CREEK RD BLDG 12 #124", "agent.address_locality": "Cave Creek, AZ 85331-4305" }, "29527": { "city_x_agent.id": 29527, "agent.id": 696, "agent.ts": "2017-09-05 05:29:15", "agent.title": "SHEPHERD INSURANCE LLC", "agent.pull_right": "8.61 mi", "agent.phone_number": "(480) 657-8872", "agent.street_address": "14411 N 98TH PL", "agent.address_locality": "Scottsdale, AZ 85260-3851" }, "29526": { "city_x_agent.id": 29526, "agent.id": 698, "agent.ts": "2017-09-05 05:29:15", "agent.title": "PRIORITY INS ASSOC LLC", "agent.pull_right": "8.75 mi", "agent.phone_number": "(480) 477-6500", "agent.street_address": "14354 N FRANK LLOYD WRIGHT BLV", "agent.address_locality": "Scottsdale, AZ 85260-8844" }, "29525": { "city_x_agent.id": 29525, "agent.id": 699, "agent.ts": "2017-09-05 05:29:15", "agent.title": "SEEK INSURANCE SERVICES LLC", "agent.pull_right": "8.75 mi", "agent.phone_number": "(480) 666-9889", "agent.street_address": "14362 N FRANK LLOYD WRIGHT BLV SUITE 2600", "agent.address_locality": "Scottsdale, AZ 85260-8846" }, "29520": { "city_x_agent.id": 29520, "agent.id": 701, "agent.ts": "2017-09-05 05:29:15", "agent.title": "HILL INSURANCE SERVICES LLC", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 368-5222", "agent.street_address": "14301 N 87TH ST STE 115", "agent.address_locality": "Scottsdale, AZ 85260-3688" }, "29506": { "city_x_agent.id": 29506, "agent.id": 29289, "agent.ts": "2017-09-05 22:37:15", "agent.title": "CORPORATE INS SOLUTIONS LLC", "agent.pull_right": "7.57 mi", "agent.phone_number": "(480) 336-8740", "agent.street_address": "8585 E HARTFORD DR STE 600", "agent.address_locality": "Scottsdale, AZ 85255-5475" }, "29502": { "city_x_agent.id": 29502, "agent.id": 29291, "agent.ts": "2017-09-05 22:37:15", "agent.title": "THE AMBASSADOR GROUP INC", "agent.pull_right": "7.92 mi", "agent.phone_number": "(480) 776-6950", "agent.street_address": "7010 E CHAUNCEY LN STE 230", "agent.address_locality": "Phoenix, AZ 85054-3118" }, "29503": { "city_x_agent.id": 29503, "agent.id": 29292, "agent.ts": "2017-09-05 22:37:15", "agent.title": "VAN LEER-AMBASSADOR GRP INS", "agent.pull_right": "7.92 mi", "agent.phone_number": "(480) 776-6950", "agent.street_address": "7010 E CHAUNCEY LN STE 230", "agent.address_locality": "Phoenix, AZ 85054-3118" }, "29512": { "city_x_agent.id": 29512, "agent.id": 29293, "agent.ts": "2017-09-05 22:37:15", "agent.title": "AZCAL INSURANCE SVS AGENCY INC", "agent.pull_right": "8.59 mi", "agent.phone_number": "(480) 948-8008", "agent.street_address": "7689 E PARADISE LN STE 4", "agent.address_locality": "Scottsdale, AZ 85260-1691" }, "29509": { "city_x_agent.id": 29509, "agent.id": 29294, "agent.ts": "2017-09-05 22:37:15", "agent.title": "ALLIANCE INSURANCE PARTNERS", "agent.pull_right": "8.60 mi", "agent.phone_number": "(602) 427-4300", "agent.street_address": "16427 N SCOTTSDALE RD STE 410", "agent.address_locality": "Scottsdale, AZ 85254-7102" }, "29510": { "city_x_agent.id": 29510, "agent.id": 29298, "agent.ts": "2017-09-05 22:37:17", "agent.title": "WILLIS OF ARIZONA INC", "agent.pull_right": "8.84 mi", "agent.phone_number": "(602) 787-6000", "agent.street_address": "16220 N SCOTTSDALE RD STE 600", "agent.address_locality": "Scottsdale, AZ 85254" }, "29511": { "city_x_agent.id": 29511, "agent.id": 29299, "agent.ts": "2017-09-05 22:37:17", "agent.title": "WILLIS PERSONAL LINES INC", "agent.pull_right": "8.84 mi", "agent.phone_number": "(602) 787-6132", "agent.street_address": "16220 N SCOTTSDALE RD STE 600", "agent.address_locality": "Scottsdale, AZ 85254-1804" }, "29517": { "city_x_agent.id": 29517, "agent.id": 29300, "agent.ts": "2017-09-05 22:37:17", "agent.title": "THE CLEMENTS AGENCY LLC", "agent.pull_right": "9.02 mi", "agent.phone_number": "(480) 477-5245", "agent.street_address": "8350 E RAINTREE DR #235", "agent.address_locality": "Scottsdale, AZ 85260-2695" }, "29519": { "city_x_agent.id": 29519, "agent.id": 29302, "agent.ts": "2017-09-05 22:37:17", "agent.title": "PINNACLE PEAK INS GROUP INC", "agent.pull_right": "9.33 mi", "agent.phone_number": "(480) 424-4756", "agent.street_address": "8147 E EVANS RD STE B-07", "agent.address_locality": "Scottsdale, AZ 85260-3646" }, "29514": { "city_x_agent.id": 29514, "agent.id": 29303, "agent.ts": "2017-09-05 22:37:17", "agent.title": "SULLIVAN JAMES LLC", "agent.pull_right": "9.69 mi", "agent.phone_number": "(480) 382-7332", "agent.street_address": "7077 E MARILYN RD STE 13", "agent.address_locality": "Scottsdale, AZ 85254-2781" }, "29521": { "city_x_agent.id": 29521, "agent.id": 29304, "agent.ts": "2017-09-05 22:37:17", "agent.title": "GG INSURANCE SERVICES INC", "agent.pull_right": "9.74 mi", "agent.phone_number": "(480) 264-7226", "agent.street_address": "7600 E REDFIELD RD HNGR B # 14", "agent.address_locality": "Scottsdale, AZ 85260-3493" }, "29522": { "city_x_agent.id": 29522, "agent.id": 29305, "agent.ts": "2017-09-05 22:37:17", "agent.title": "GG INSURANCE SERVICES INC", "agent.pull_right": "9.74 mi", "agent.phone_number": "(480) 264-7226", "agent.street_address": "7600 E REDFIELD RD STE 145", "agent.address_locality": "Scottsdale, AZ 85260-3491" }, "29523": { "city_x_agent.id": 29523, "agent.id": 29306, "agent.ts": "2017-09-05 22:37:17", "agent.title": "INS CONCEPTS & RISK MGMT LLC", "agent.pull_right": "9.82 mi", "agent.phone_number": "(602) 368-8977", "agent.street_address": "7585 E REDFIELD RD STE 107", "agent.address_locality": "Scottsdale, AZ 85260-6937" }, "29498": { "city_x_agent.id": 29498, "agent.id": 29307, "agent.ts": "2017-09-05 22:37:17", "agent.title": "ACCURATE INS AGENCY LLC", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 447-2267", "agent.street_address": "20660 N 40TH ST UNIT 2027", "agent.address_locality": "Phoenix, AZ 85050-7314" }, "29505": { "city_x_agent.id": 29505, "agent.id": 29318, "agent.ts": "2017-09-05 22:37:34", "agent.title": "R P RYAN INSURANCE INC", "agent.pull_right": "10.63 mi", "agent.phone_number": "(602) 992-9700", "agent.street_address": "18501 N 40TH ST. SUITE 102", "agent.address_locality": "Phoenix, AZ 85032" }, "29516": { "city_x_agent.id": 29516, "agent.id": 29322, "agent.ts": "2017-09-05 22:37:34", "agent.title": "BOWMAN & ASSOCIATES INSURANCE", "agent.pull_right": "12.33 mi", "agent.phone_number": "(602) 482-3300", "agent.street_address": "16042 N 32ND ST STE A", "agent.address_locality": "Phoenix, AZ 85032-3894" }, "29513": { "city_x_agent.id": 29513, "agent.id": 29340, "agent.ts": "2017-09-05 22:37:45", "agent.title": "HATCH INSURANCE AGENCY INC", "agent.pull_right": "11.28 mi", "agent.phone_number": "(602) 995-5692", "agent.street_address": "2222 W PARKSIDE LN STE 117", "agent.address_locality": "Phoenix, AZ 85027-1260" }, "29515": { "city_x_agent.id": 29515, "agent.id": 29343, "agent.ts": "2017-09-05 22:37:45", "agent.title": "BRIGHTWAY INSURANCE", "agent.pull_right": "12.25 mi", "agent.phone_number": "(623) 243-7450", "agent.street_address": "21620 N 19TH AVE STE A10", "agent.address_locality": "Phoenix, AZ 85027-2716" }, "29518": { "city_x_agent.id": 29518, "agent.id": 29344, "agent.ts": "2017-09-05 22:37:45", "agent.title": "SJS INSURANCE LLC", "agent.pull_right": "12.28 mi", "agent.phone_number": "(480) 525-7611", "agent.street_address": "21436 N 20TH AVE # 210", "agent.address_locality": "Phoenix, AZ 85027-2612" }, "29528": { "city_x_agent.id": 29528, "agent.id": 29345, "agent.ts": "2017-09-05 22:37:45", "agent.title": "WELLS FARGO INS SVCS USA INC", "agent.pull_right": "12.56 mi", "agent.phone_number": "(612) 215-3685", "agent.street_address": "2222 W ROSE GARDEN LN FL 2", "agent.address_locality": "Phoenix, AZ 85027-2644" }, "29529": { "city_x_agent.id": 29529, "agent.id": 29346, "agent.ts": "2017-09-05 22:37:45", "agent.title": "THE MAHONEY GROUP", "agent.pull_right": "13.08 mi", "agent.phone_number": "(480) 214-2743", "agent.street_address": "20333 N 19TH AVE STE 200", "agent.address_locality": "Phoenix, AZ 85027-3643" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "90": { "city.id": 90, "city.ts": "2017-08-15 02:34:18", "city.title": "Casa Grande", "city.city_x_agent_id": { "661": { "city_x_agent.id": 661, "agent.id": 661, "agent.ts": "2017-09-05 05:28:20", "agent.title": "JANIE G RIVERA", "agent.pull_right": "0.70 mi", "agent.phone_number": "(520) 836-3141", "agent.street_address": "888 E JIMMIE KERR BLVD", "agent.address_locality": "Casa Grande, AZ 85122-4588" }, "662": { "city_x_agent.id": 662, "agent.id": 662, "agent.ts": "2017-09-05 05:28:20", "agent.title": "MAD STEGER LLC", "agent.pull_right": "1.07 mi", "agent.phone_number": "(520) 421-2420", "agent.street_address": "701 E COTTONWOOD LN STE A", "agent.address_locality": "Casa Grande, AZ 85122-2782" }, "663": { "city_x_agent.id": 663, "agent.id": 663, "agent.ts": "2017-09-05 05:28:20", "agent.title": "KIVA INS LLC", "agent.pull_right": "1.11 mi", "agent.phone_number": "(520) 421-9231", "agent.street_address": "973 E COTTONWOOD LN STE 110", "agent.address_locality": "Casa Grande, AZ 85122-2246" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "91": { "city.id": 91, "city.ts": "2017-09-05 22:40:54", "city.title": "Cave Creek", "city.city_x_agent_id": { "672": { "city_x_agent.id": 672, "agent.id": 599, "agent.ts": "2017-09-05 05:31:23", "agent.title": "Maximos Soliman", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 315-0400", "agent.street_address": "16420 N 92nd St Ste 105", "agent.address_locality": "Scottsdale, AZ 85260" }, "667": { "city_x_agent.id": 667, "agent.id": 600, "agent.ts": "2017-09-05 05:28:31", "agent.title": "WESTERN AG-INS AGENCY INC", "agent.pull_right": "8.76 mi", "agent.phone_number": "(480) 550-1507", "agent.street_address": "STE 207", "agent.address_locality": "28170 N Alma School Pkwy, AZ 85262" }, "668": { "city_x_agent.id": 668, "agent.id": 601, "agent.ts": "2017-09-05 05:28:31", "agent.title": "WESTERN AG-INS AGENCY INC", "agent.pull_right": "8.76 mi", "agent.phone_number": "(480) 550-1507", "agent.street_address": "28170 N ALMA SCHOOL PKWY STE 207", "agent.address_locality": "Scottsdale, AZ 85262-8053" }, "666": { "city_x_agent.id": 666, "agent.id": 602, "agent.ts": "2017-09-05 05:28:31", "agent.title": "JVP INS AGENCY LLC", "agent.pull_right": "7.88 mi", "agent.phone_number": "(480) 473-3100", "agent.street_address": "10025 E DYNAMITE BLVD STE B135", "agent.address_locality": "Scottsdale, AZ 85262-3688" }, "29551": { "city_x_agent.id": 29551, "agent.id": 603, "agent.ts": "2017-09-05 05:28:09", "agent.title": "ARIZONA INS SPECIALISTS LLC", "agent.pull_right": "9.72 mi", "agent.phone_number": "(602) 717-4992", "agent.street_address": "30423 N 139TH ST", "agent.address_locality": "Scottsdale, AZ 85262-5988" }, "29549": { "city_x_agent.id": 29549, "agent.id": 604, "agent.ts": "2017-09-05 05:27:12", "agent.title": "BRIDGELIGHT INSURANCE", "agent.pull_right": "5.17 mi", "agent.phone_number": "(480) 999-3020", "agent.street_address": "20645 N PIMA RD STE 225", "agent.address_locality": "Scottsdale, AZ 85255-5681" }, "29557": { "city_x_agent.id": 29557, "agent.id": 605, "agent.ts": "2017-09-05 05:27:12", "agent.title": "LIGHTFOOT & ASSOCIATES LLC", "agent.pull_right": "5.45 mi", "agent.phone_number": "(720) 261-2249", "agent.street_address": "29306 N 153RD PL", "agent.address_locality": "Scottsdale, AZ 85262-6920" }, "29550": { "city_x_agent.id": 29550, "agent.id": 606, "agent.ts": "2017-09-05 05:27:12", "agent.title": "CREST INSURANCE GROUP", "agent.pull_right": "6.01 mi", "agent.phone_number": "(520) 881-5760", "agent.street_address": "8302 E BUTEO DR", "agent.address_locality": "Scottsdale, AZ 85255-3920" }, "29558": { "city_x_agent.id": 29558, "agent.id": 607, "agent.ts": "2017-09-05 05:27:12", "agent.title": "GREENE INS GROUP LLC", "agent.pull_right": "7.45 mi", "agent.phone_number": "(480) 657-2800", "agent.street_address": "17470 N PACESETTER WAY", "agent.address_locality": "Scottsdale, AZ 85255-5445" }, "29566": { "city_x_agent.id": 29566, "agent.id": 608, "agent.ts": "2017-09-05 05:29:15", "agent.title": "PRUTTING INS GROUP INC", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 502-4300", "agent.street_address": "8889 E BELL RD STE 201", "agent.address_locality": "Scottsdale, AZ 85260-1597" }, "670": { "city_x_agent.id": 670, "agent.id": 609, "agent.ts": "2017-09-05 05:28:31", "agent.title": "KEN RAGASA CUADERNO", "agent.pull_right": "9.97 mi", "agent.phone_number": "(623) 551-1660", "agent.street_address": "41122 N REPUBLIC WAY", "agent.address_locality": "Anthem, AZ 85086-1513" }, "29548": { "city_x_agent.id": 29548, "agent.id": 610, "agent.ts": "2017-09-05 05:27:23", "agent.title": "FIRSTMARK INSURANCE GROUP INC", "agent.pull_right": "0.90 mi", "agent.phone_number": "(206) 701-9214", "agent.street_address": "42104 N VENTURE DR STE C100", "agent.address_locality": "Anthem, AZ 85086-3856" }, "669": { "city_x_agent.id": 669, "agent.id": 611, "agent.ts": "2017-09-05 05:28:31", "agent.title": "PREMIER GROUP INSURANCE INC", "agent.pull_right": "9.60 mi", "agent.phone_number": "(623) 742-6891", "agent.street_address": "2907 W IRVINE RD", "agent.address_locality": "Phoenix, AZ 85086-8339" }, "29556": { "city_x_agent.id": 29556, "agent.id": 612, "agent.ts": "2017-09-05 05:27:23", "agent.title": "OXLEY INSURANCE GROUP LLC", "agent.pull_right": "2.73 mi", "agent.phone_number": "(623) 551-8671", "agent.street_address": "43704 N 50TH DR", "agent.address_locality": "Phoenix, AZ 85087-3089" }, "29546": { "city_x_agent.id": 29546, "agent.id": 613, "agent.ts": "2017-09-05 05:27:23", "agent.title": "CANYON LANDS INSURANCE 1 INC", "agent.pull_right": "7.95 mi", "agent.phone_number": "(623) 552-3248", "agent.street_address": "2051 W MADRE DEL ORO DR", "agent.address_locality": "Phoenix, AZ 85085-6712" }, "671": { "city_x_agent.id": 671, "agent.id": 614, "agent.ts": "2017-09-05 05:28:31", "agent.title": "John Delbrocco", "agent.pull_right": "11.66 mi", "agent.phone_number": "(602) 863-1315", "agent.street_address": "20235 N Cave Creek Rd Ste 110", "agent.address_locality": "Phoenix, AZ 85024-0800" }, "673": { "city_x_agent.id": 673, "agent.id": 615, "agent.ts": "2017-09-05 05:30:33", "agent.title": "Maximos Soliman", "agent.pull_right": "7.95 mi", "agent.phone_number": "(602) 540-3673", "agent.street_address": "16841 N 31st Ave STE 146", "agent.address_locality": "Phoenix, AZ 85053" }, "29540": { "city_x_agent.id": 29540, "agent.id": 616, "agent.ts": "2017-09-05 05:31:43", "agent.title": "TJ Mazur", "agent.pull_right": "6.68 mi", "agent.phone_number": "(623) 776-8501", "agent.street_address": "7121 W Bell Rd Ste 30L", "agent.address_locality": "Glendale, AZ 85308-8559" }, "29544": { "city_x_agent.id": 29544, "agent.id": 618, "agent.ts": "2017-09-05 05:30:42", "agent.title": "Edgar Acosta", "agent.pull_right": "8.32 mi", "agent.phone_number": "(623) 302-0313", "agent.street_address": "7141 N 51st Ave Ste B", "agent.address_locality": "Glendale, AZ 85301" }, "29541": { "city_x_agent.id": 29541, "agent.id": 625, "agent.ts": "2017-09-05 05:29:15", "agent.title": "Aaron Isakson", "agent.pull_right": "0.37 mi", "agent.phone_number": "(480) 888-0318", "agent.street_address": "16930 E Palisades Blvd", "agent.address_locality": "Fountain Hills, AZ 85268" }, "29545": { "city_x_agent.id": 29545, "agent.id": 626, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "3.87 mi", "agent.phone_number": "(480) 945-3123", "agent.street_address": "2932 N 68th St Ste 4", "agent.address_locality": "Scottsdale, AZ 85251" }, "29542": { "city_x_agent.id": 29542, "agent.id": 635, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Ryan J Larson", "agent.pull_right": "9.37 mi", "agent.phone_number": "(602) 393-1338", "agent.street_address": "1500 E Bethany Home Rd Ste 170", "agent.address_locality": "Phoenix, AZ 85014-2444" }, "29543": { "city_x_agent.id": 29543, "agent.id": 637, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "7.76 mi", "agent.phone_number": "(602) 493-4851", "agent.street_address": "2415 E Camelback Rd Ste 700", "agent.address_locality": "Phoenix, AZ 85016" }, "665": { "city_x_agent.id": 665, "agent.id": 651, "agent.ts": "2017-09-05 05:28:31", "agent.title": "TYROL INSURANCE AGENCY INC", "agent.pull_right": "1.79 mi", "agent.phone_number": "(480) 488-2113", "agent.street_address": "7206 E CAVE CREEK RD", "agent.address_locality": "Carefree, AZ 85377" }, "664": { "city_x_agent.id": 664, "agent.id": 652, "agent.ts": "2017-09-05 05:28:31", "agent.title": "EVERS INS SERVICES LLC", "agent.pull_right": "1.56 mi", "agent.phone_number": "(602) 741-7777", "agent.street_address": "7100 E CAVE CREEK RD BLDG 12 #124", "agent.address_locality": "Cave Creek, AZ 85331-4305" }, "29562": { "city_x_agent.id": 29562, "agent.id": 29289, "agent.ts": "2017-09-05 22:37:15", "agent.title": "CORPORATE INS SOLUTIONS LLC", "agent.pull_right": "7.57 mi", "agent.phone_number": "(480) 336-8740", "agent.street_address": "8585 E HARTFORD DR STE 600", "agent.address_locality": "Scottsdale, AZ 85255-5475" }, "29553": { "city_x_agent.id": 29553, "agent.id": 29291, "agent.ts": "2017-09-05 22:37:15", "agent.title": "THE AMBASSADOR GROUP INC", "agent.pull_right": "7.92 mi", "agent.phone_number": "(480) 776-6950", "agent.street_address": "7010 E CHAUNCEY LN STE 230", "agent.address_locality": "Phoenix, AZ 85054-3118" }, "29554": { "city_x_agent.id": 29554, "agent.id": 29292, "agent.ts": "2017-09-05 22:37:15", "agent.title": "VAN LEER-AMBASSADOR GRP INS", "agent.pull_right": "7.92 mi", "agent.phone_number": "(480) 776-6950", "agent.street_address": "7010 E CHAUNCEY LN STE 230", "agent.address_locality": "Phoenix, AZ 85054-3118" }, "29569": { "city_x_agent.id": 29569, "agent.id": 29293, "agent.ts": "2017-09-05 22:37:15", "agent.title": "AZCAL INSURANCE SVS AGENCY INC", "agent.pull_right": "8.59 mi", "agent.phone_number": "(480) 948-8008", "agent.street_address": "7689 E PARADISE LN STE 4", "agent.address_locality": "Scottsdale, AZ 85260-1691" }, "29561": { "city_x_agent.id": 29561, "agent.id": 29294, "agent.ts": "2017-09-05 22:37:15", "agent.title": "ALLIANCE INSURANCE PARTNERS", "agent.pull_right": "8.60 mi", "agent.phone_number": "(602) 427-4300", "agent.street_address": "16427 N SCOTTSDALE RD STE 410", "agent.address_locality": "Scottsdale, AZ 85254-7102" }, "29563": { "city_x_agent.id": 29563, "agent.id": 29298, "agent.ts": "2017-09-05 22:37:17", "agent.title": "WILLIS OF ARIZONA INC", "agent.pull_right": "8.84 mi", "agent.phone_number": "(602) 787-6000", "agent.street_address": "16220 N SCOTTSDALE RD STE 600", "agent.address_locality": "Scottsdale, AZ 85254" }, "29564": { "city_x_agent.id": 29564, "agent.id": 29299, "agent.ts": "2017-09-05 22:37:17", "agent.title": "WILLIS PERSONAL LINES INC", "agent.pull_right": "8.84 mi", "agent.phone_number": "(602) 787-6132", "agent.street_address": "16220 N SCOTTSDALE RD STE 600", "agent.address_locality": "Scottsdale, AZ 85254-1804" }, "29576": { "city_x_agent.id": 29576, "agent.id": 29300, "agent.ts": "2017-09-05 22:37:17", "agent.title": "THE CLEMENTS AGENCY LLC", "agent.pull_right": "9.02 mi", "agent.phone_number": "(480) 477-5245", "agent.street_address": "8350 E RAINTREE DR #235", "agent.address_locality": "Scottsdale, AZ 85260-2695" }, "29577": { "city_x_agent.id": 29577, "agent.id": 29302, "agent.ts": "2017-09-05 22:37:17", "agent.title": "PINNACLE PEAK INS GROUP INC", "agent.pull_right": "9.33 mi", "agent.phone_number": "(480) 424-4756", "agent.street_address": "8147 E EVANS RD STE B-07", "agent.address_locality": "Scottsdale, AZ 85260-3646" }, "29574": { "city_x_agent.id": 29574, "agent.id": 29303, "agent.ts": "2017-09-05 22:37:17", "agent.title": "SULLIVAN JAMES LLC", "agent.pull_right": "9.69 mi", "agent.phone_number": "(480) 382-7332", "agent.street_address": "7077 E MARILYN RD STE 13", "agent.address_locality": "Scottsdale, AZ 85254-2781" }, "29578": { "city_x_agent.id": 29578, "agent.id": 29304, "agent.ts": "2017-09-05 22:37:17", "agent.title": "GG INSURANCE SERVICES INC", "agent.pull_right": "9.74 mi", "agent.phone_number": "(480) 264-7226", "agent.street_address": "7600 E REDFIELD RD HNGR B # 14", "agent.address_locality": "Scottsdale, AZ 85260-3493" }, "29579": { "city_x_agent.id": 29579, "agent.id": 29305, "agent.ts": "2017-09-05 22:37:17", "agent.title": "GG INSURANCE SERVICES INC", "agent.pull_right": "9.74 mi", "agent.phone_number": "(480) 264-7226", "agent.street_address": "7600 E REDFIELD RD STE 145", "agent.address_locality": "Scottsdale, AZ 85260-3491" }, "29547": { "city_x_agent.id": 29547, "agent.id": 29307, "agent.ts": "2017-09-05 22:37:17", "agent.title": "ACCURATE INS AGENCY LLC", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 447-2267", "agent.street_address": "20660 N 40TH ST UNIT 2027", "agent.address_locality": "Phoenix, AZ 85050-7314" }, "29552": { "city_x_agent.id": 29552, "agent.id": 29318, "agent.ts": "2017-09-05 22:37:34", "agent.title": "R P RYAN INSURANCE INC", "agent.pull_right": "10.63 mi", "agent.phone_number": "(602) 992-9700", "agent.street_address": "18501 N 40TH ST. SUITE 102", "agent.address_locality": "Phoenix, AZ 85032" }, "29570": { "city_x_agent.id": 29570, "agent.id": 29322, "agent.ts": "2017-09-05 22:37:34", "agent.title": "BOWMAN & ASSOCIATES INSURANCE", "agent.pull_right": "12.33 mi", "agent.phone_number": "(602) 482-3300", "agent.street_address": "16042 N 32ND ST STE A", "agent.address_locality": "Phoenix, AZ 85032-3894" }, "29575": { "city_x_agent.id": 29575, "agent.id": 29325, "agent.ts": "2017-09-05 22:37:34", "agent.title": "INS PROFESSIONALS NETWORK LLC", "agent.pull_right": "12.88 mi", "agent.phone_number": "(602) 234-0405", "agent.street_address": "PO BOX 30407", "agent.address_locality": "Phoenix, AZ 85046-0407" }, "29555": { "city_x_agent.id": 29555, "agent.id": 29340, "agent.ts": "2017-09-05 22:37:45", "agent.title": "HATCH INSURANCE AGENCY INC", "agent.pull_right": "11.28 mi", "agent.phone_number": "(602) 995-5692", "agent.street_address": "2222 W PARKSIDE LN STE 117", "agent.address_locality": "Phoenix, AZ 85027-1260" }, "29559": { "city_x_agent.id": 29559, "agent.id": 29343, "agent.ts": "2017-09-05 22:37:45", "agent.title": "BRIGHTWAY INSURANCE", "agent.pull_right": "12.25 mi", "agent.phone_number": "(623) 243-7450", "agent.street_address": "21620 N 19TH AVE STE A10", "agent.address_locality": "Phoenix, AZ 85027-2716" }, "29560": { "city_x_agent.id": 29560, "agent.id": 29344, "agent.ts": "2017-09-05 22:37:45", "agent.title": "SJS INSURANCE LLC", "agent.pull_right": "12.28 mi", "agent.phone_number": "(480) 525-7611", "agent.street_address": "21436 N 20TH AVE # 210", "agent.address_locality": "Phoenix, AZ 85027-2612" }, "29565": { "city_x_agent.id": 29565, "agent.id": 29345, "agent.ts": "2017-09-05 22:37:45", "agent.title": "WELLS FARGO INS SVCS USA INC", "agent.pull_right": "12.56 mi", "agent.phone_number": "(612) 215-3685", "agent.street_address": "2222 W ROSE GARDEN LN FL 2", "agent.address_locality": "Phoenix, AZ 85027-2644" }, "29567": { "city_x_agent.id": 29567, "agent.id": 29346, "agent.ts": "2017-09-05 22:37:45", "agent.title": "THE MAHONEY GROUP", "agent.pull_right": "13.08 mi", "agent.phone_number": "(480) 214-2743", "agent.street_address": "20333 N 19TH AVE STE 200", "agent.address_locality": "Phoenix, AZ 85027-3643" }, "29572": { "city_x_agent.id": 29572, "agent.id": 29348, "agent.ts": "2017-09-05 22:38:03", "agent.title": "ALPHA INSURANCE SERVICES, LLP", "agent.pull_right": "13.40 mi", "agent.phone_number": "(623) 581-5234", "agent.street_address": "2401 W BEHREND DR STE 69", "agent.address_locality": "Phoenix, AZ 85027-4145" }, "29571": { "city_x_agent.id": 29571, "agent.id": 29351, "agent.ts": "2017-09-05 22:38:03", "agent.title": "BAILEY INS LTD", "agent.pull_right": "14.35 mi", "agent.phone_number": "(602) 866-2600", "agent.street_address": "717 W UNION HILLS DR STE 10", "agent.address_locality": "Phoenix, AZ 85027-5580" }, "29573": { "city_x_agent.id": 29573, "agent.id": 29353, "agent.ts": "2017-09-05 22:38:03", "agent.title": "CDS INSURANCE AGENCY LLC", "agent.pull_right": "15.50 mi", "agent.phone_number": "(602) 996-5000", "agent.street_address": "706 E BELL RD STE 211", "agent.address_locality": "Phoenix, AZ 85022-6658" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "92": { "city.id": 92, "city.ts": "2017-09-05 22:41:21", "city.title": "Chandler", "city.city_x_agent_id": { "29619": { "city_x_agent.id": 29619, "agent.id": 599, "agent.ts": "2017-09-05 05:31:23", "agent.title": "Maximos Soliman", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 315-0400", "agent.street_address": "16420 N 92nd St Ste 105", "agent.address_locality": "Scottsdale, AZ 85260" }, "29624": { "city_x_agent.id": 29624, "agent.id": 622, "agent.ts": "2017-09-05 05:27:31", "agent.title": "KOHLHASE INS INC", "agent.pull_right": "8.27 mi", "agent.phone_number": "(480) 832-8370", "agent.street_address": "6550 E MAIN ST", "agent.address_locality": "Mesa, AZ 85205-9041" }, "675": { "city_x_agent.id": 675, "agent.id": 624, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Aaron Isakson", "agent.pull_right": "8.70 mi", "agent.phone_number": "(480) 888-0318", "agent.street_address": "1819 E Southern Ave Ste E-20", "agent.address_locality": "Mesa, AZ 85204" }, "29618": { "city_x_agent.id": 29618, "agent.id": 625, "agent.ts": "2017-09-05 05:29:15", "agent.title": "Aaron Isakson", "agent.pull_right": "0.37 mi", "agent.phone_number": "(480) 888-0318", "agent.street_address": "16930 E Palisades Blvd", "agent.address_locality": "Fountain Hills, AZ 85268" }, "29615": { "city_x_agent.id": 29615, "agent.id": 626, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "3.87 mi", "agent.phone_number": "(480) 945-3123", "agent.street_address": "2932 N 68th St Ste 4", "agent.address_locality": "Scottsdale, AZ 85251" }, "674": { "city_x_agent.id": 674, "agent.id": 627, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Carlos Enrique Oliveros", "agent.pull_right": "6.09 mi", "agent.phone_number": "(480) 270-2935", "agent.street_address": "8400 S Kyrene Rd Ste 230", "agent.address_locality": "Tempe, AZ 85284" }, "29614": { "city_x_agent.id": 29614, "agent.id": 628, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Peter Tadevossian", "agent.pull_right": "1.83 mi", "agent.phone_number": "(480) 719-7183", "agent.street_address": "1910 S Priest Dr", "agent.address_locality": "Tempe, AZ 85281" }, "29620": { "city_x_agent.id": 29620, "agent.id": 632, "agent.ts": "2017-09-05 05:30:42", "agent.title": "Miguel Torres", "agent.pull_right": "7.16 mi", "agent.phone_number": "(623) 873-1234", "agent.street_address": "5901 W Indian School Rd Ste 4", "agent.address_locality": "Phoenix, AZ 85033" }, "29617": { "city_x_agent.id": 29617, "agent.id": 635, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Ryan J Larson", "agent.pull_right": "9.37 mi", "agent.phone_number": "(602) 393-1338", "agent.street_address": "1500 E Bethany Home Rd Ste 170", "agent.address_locality": "Phoenix, AZ 85014-2444" }, "29616": { "city_x_agent.id": 29616, "agent.id": 637, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "7.76 mi", "agent.phone_number": "(602) 493-4851", "agent.street_address": "2415 E Camelback Rd Ste 700", "agent.address_locality": "Phoenix, AZ 85016" }, "677": { "city_x_agent.id": 677, "agent.id": 638, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Michelle Riachi", "agent.pull_right": "5.17 mi", "agent.phone_number": "(480) 438-8214", "agent.street_address": "9830 S 51st St Ste A127", "agent.address_locality": "Phoenix, AZ 85044" }, "676": { "city_x_agent.id": 676, "agent.id": 676, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Ernie Barten", "agent.pull_right": "7.74 mi", "agent.phone_number": "(480) 686-3099", "agent.street_address": "4425 E Agave Rd Ste 136", "agent.address_locality": "Phoenix, AZ 85044" }, "678": { "city_x_agent.id": 678, "agent.id": 678, "agent.ts": "2017-09-05 05:29:26", "agent.title": "COLGROVE FINANCIAL LLC", "agent.pull_right": "3.76 mi", "agent.phone_number": "(480) 830-2595", "agent.street_address": "555 W CHANDLER BLVD STE 203", "agent.address_locality": "Chandler, AZ 85225-7540" }, "679": { "city_x_agent.id": 679, "agent.id": 679, "agent.ts": "2017-09-05 05:28:44", "agent.title": "SAN MARCOS INS GROUP LLC", "agent.pull_right": "0.55 mi", "agent.phone_number": "(480) 899-6633", "agent.street_address": "584 W CHANDLER BLVD", "agent.address_locality": "Chandler, AZ 85225-7531" }, "680": { "city_x_agent.id": 680, "agent.id": 680, "agent.ts": "2017-09-05 05:28:44", "agent.title": "JOHN MINARD INS SOUTHWEST LTD", "agent.pull_right": "2.81 mi", "agent.phone_number": "(480) 756-8439", "agent.street_address": "2727 W FRYE RD STE 200", "agent.address_locality": "Chandler, AZ 85224-4943" }, "681": { "city_x_agent.id": 681, "agent.id": 681, "agent.ts": "2017-09-05 05:28:44", "agent.title": "CLEAR CHOICE INSURANCE LLC", "agent.pull_right": "3.25 mi", "agent.phone_number": "(480) 719-2812", "agent.street_address": "1490 S PRICE RD STE 206", "agent.address_locality": "Chandler, AZ 85286-6608" }, "682": { "city_x_agent.id": 682, "agent.id": 682, "agent.ts": "2017-09-05 05:29:26", "agent.title": "RIDE NOW INSURANCE LLC", "agent.pull_right": "3.44 mi", "agent.phone_number": "(888) 743-3669", "agent.street_address": "3333 N ARIZONA AVE", "agent.address_locality": "Chandler, AZ 85225-7106" }, "683": { "city_x_agent.id": 683, "agent.id": 683, "agent.ts": "2017-09-05 05:31:17", "agent.title": "FOOTHILLS INSURANCE AGENCY INC", "agent.pull_right": "15.10 mi", "agent.phone_number": "(480) 759-1970", "agent.street_address": "2450 S GILBERT RD STE 203", "agent.address_locality": "Chandler, AZ 85286-1595" }, "29590": { "city_x_agent.id": 29590, "agent.id": 705, "agent.ts": "2017-09-05 05:29:26", "agent.title": "LEGACY ONE INSURANCE", "agent.pull_right": "1.67 mi", "agent.phone_number": "(480) 212-1913", "agent.street_address": "725 W ELLIOT RD STE 101-5", "agent.address_locality": "Gilbert, AZ 85233-5301" }, "29592": { "city_x_agent.id": 29592, "agent.id": 706, "agent.ts": "2017-09-05 05:29:26", "agent.title": "ELITE INSURANCE GROUP LLC", "agent.pull_right": "1.73 mi", "agent.phone_number": "(480) 632-8245", "agent.street_address": "207 N GILBERT RD STE 1", "agent.address_locality": "Gilbert, AZ 85234-5812" }, "29593": { "city_x_agent.id": 29593, "agent.id": 707, "agent.ts": "2017-09-05 05:29:26", "agent.title": "GILBERT INSURANCE GROUP INC", "agent.pull_right": "1.88 mi", "agent.phone_number": "(480) 926-9030", "agent.street_address": "350 N GILBERT RD STE 202", "agent.address_locality": "Gilbert, AZ 85234-5770" }, "29594": { "city_x_agent.id": 29594, "agent.id": 708, "agent.ts": "2017-09-05 05:29:26", "agent.title": "SAN TAN INSURANCE SERVICES", "agent.pull_right": "2.22 mi", "agent.phone_number": "(480) 391-3883", "agent.street_address": "625 N GILBERT RD STE 107", "agent.address_locality": "Gilbert, AZ 85234" }, "29595": { "city_x_agent.id": 29595, "agent.id": 709, "agent.ts": "2017-09-05 05:29:26", "agent.title": "COMMERCIAL WEST INS AGENCY", "agent.pull_right": "2.64 mi", "agent.phone_number": "(480) 961-5400", "agent.street_address": "971 N GILBERT RD STE 20301", "agent.address_locality": "Gilbert, AZ 85234-3472" }, "29591": { "city_x_agent.id": 29591, "agent.id": 710, "agent.ts": "2017-09-05 05:29:26", "agent.title": "ALLIANCE INS AGCY OF AZ LLC", "agent.pull_right": "3.09 mi", "agent.phone_number": "(602) 271-9171", "agent.street_address": "1450 W GUADALUPE RD STE 117", "agent.address_locality": "Gilbert, AZ 85233-3056" }, "29608": { "city_x_agent.id": 29608, "agent.id": 742, "agent.ts": "2017-09-05 05:30:02", "agent.title": "PASSEY BOND CO INC", "agent.pull_right": "0.08 mi", "agent.phone_number": "(480) 969-2291", "agent.street_address": "28 N CENTER ST", "agent.address_locality": "Mesa, AZ 85201-7328" }, "29601": { "city_x_agent.id": 29601, "agent.id": 743, "agent.ts": "2017-09-05 05:30:02", "agent.title": "LEBARON & CARROLL LLC", "agent.pull_right": "2.35 mi", "agent.phone_number": "(480) 834-9315", "agent.street_address": "1350 E SOUTHERN AVE", "agent.address_locality": "Mesa, AZ 85204-5142" }, "29603": { "city_x_agent.id": 29603, "agent.id": 745, "agent.ts": "2017-09-05 05:30:02", "agent.title": "MASSEY GROUP LLC", "agent.pull_right": "2.35 mi", "agent.phone_number": "(480) 729-6088", "agent.street_address": "1350 E SOUTHERN AVE", "agent.address_locality": "Mesa, AZ 85204-5142" }, "29598": { "city_x_agent.id": 29598, "agent.id": 746, "agent.ts": "2017-09-05 05:30:02", "agent.title": "THE MAHONEY GROUP", "agent.pull_right": "2.65 mi", "agent.phone_number": "(480) 730-4920", "agent.street_address": "1835 S EXTENSION RD", "agent.address_locality": "Mesa, AZ 85210-5942" }, "29626": { "city_x_agent.id": 29626, "agent.id": 790, "agent.ts": "2017-09-05 05:31:17", "agent.title": "THE INS TEAM", "agent.pull_right": "6.98 mi", "agent.phone_number": "(480) 626-1860", "agent.street_address": "22246 S ELLSWORTH RD", "agent.address_locality": "Queen Creek, AZ 85142-8358" }, "29622": { "city_x_agent.id": 29622, "agent.id": 791, "agent.ts": "2017-09-05 05:31:17", "agent.title": "OVERLAND INSURANCE SERVICES", "agent.pull_right": "8.28 mi", "agent.phone_number": "(800) 677-4027", "agent.street_address": "18842 E VIA DEL ORO", "agent.address_locality": "Queen Creek, AZ 85142-4063" }, "29623": { "city_x_agent.id": 29623, "agent.id": 792, "agent.ts": "2017-09-05 05:31:17", "agent.title": "OVERLAND MANAGEMENT CORP", "agent.pull_right": "8.28 mi", "agent.phone_number": "(800) 677-4027", "agent.street_address": "18842 E VIA DEL ORO", "agent.address_locality": "Queen Creek, AZ 85142-4063" }, "29613": { "city_x_agent.id": 29613, "agent.id": 794, "agent.ts": "2017-09-05 05:31:17", "agent.title": "PINNACLE INSURANCE GROUP LLP", "agent.pull_right": "9.37 mi", "agent.phone_number": "(480) 474-0334", "agent.street_address": "17933 E SANOQUE BLVD", "agent.address_locality": "Gilbert, AZ 85298-8973" }, "29611": { "city_x_agent.id": 29611, "agent.id": 795, "agent.ts": "2017-09-05 05:31:17", "agent.title": "PREMIER GROUP INSURANCE INC", "agent.pull_right": "11.54 mi", "agent.phone_number": "(480) 275-2555", "agent.street_address": "4365 E PECOS RD STE 140", "agent.address_locality": "Gilbert, AZ 85295-8053" }, "29596": { "city_x_agent.id": 29596, "agent.id": 796, "agent.ts": "2017-09-05 05:31:17", "agent.title": "BATCHSOFT LLC", "agent.pull_right": "13.57 mi", "agent.phone_number": "(480) 436-7077", "agent.street_address": "4058 S WHITE DR STE A1", "agent.address_locality": "Chandler, AZ 85249-5533" }, "29629": { "city_x_agent.id": 29629, "agent.id": 818, "agent.ts": "2017-09-05 05:31:23", "agent.title": "EATON PROVIDENT GROUP LLC", "agent.pull_right": "0.85 mi", "agent.phone_number": "(480) 941-4895", "agent.street_address": "3333 N HAYDEN RD", "agent.address_locality": "Scottsdale, AZ 85251-6626" }, "29627": { "city_x_agent.id": 29627, "agent.id": 819, "agent.ts": "2017-09-05 05:31:23", "agent.title": "BENNETT & PORTER INS SERVICES", "agent.pull_right": "0.90 mi", "agent.phone_number": "(480) 212-1150", "agent.street_address": "3200 N HAYDEN RD STE 310", "agent.address_locality": "Scottsdale, AZ 85251-6655" }, "29610": { "city_x_agent.id": 29610, "agent.id": 843, "agent.ts": "2017-09-05 05:32:01", "agent.title": "ARIZONA INSURANCE AGENCY", "agent.pull_right": "1.96 mi", "agent.phone_number": "(480) 966-3400", "agent.street_address": "1713 E BROADWAY RD", "agent.address_locality": "Tempe, AZ 85282-1611" }, "29606": { "city_x_agent.id": 29606, "agent.id": 844, "agent.ts": "2017-09-05 05:32:01", "agent.title": "PREMIER GROUP INSURANCE INC", "agent.pull_right": "3.24 mi", "agent.phone_number": "(480) 535-5709", "agent.street_address": "600 E BASELINE RD STE B-3", "agent.address_locality": "Tempe, AZ 85283-1266" }, "29621": { "city_x_agent.id": 29621, "agent.id": 29389, "agent.ts": "2017-09-05 22:38:36", "agent.title": "FOX RELIABLE INS SERVICES", "agent.pull_right": "10.31 mi", "agent.phone_number": "(480) 807-7753", "agent.street_address": "4930 E MAIN ST STE 9", "agent.address_locality": "Mesa, AZ 85205-8005" }, "29625": { "city_x_agent.id": 29625, "agent.id": 29390, "agent.ts": "2017-09-05 22:38:36", "agent.title": "SOUTHWEST RISK MANAGEMENT LLC", "agent.pull_right": "10.66 mi", "agent.phone_number": "(480) 924-1200", "agent.street_address": "4801 E MCKELLIPS RD", "agent.address_locality": "Mesa, AZ 85215-2527" }, "29612": { "city_x_agent.id": 29612, "agent.id": 29391, "agent.ts": "2017-09-05 22:38:36", "agent.title": "WILSON INSURANCE INC", "agent.pull_right": "11.56 mi", "agent.phone_number": "(480) 964-2400", "agent.street_address": "3950 E BROADWAY RD STE 102", "agent.address_locality": "Mesa, AZ 85206-1031" }, "29607": { "city_x_agent.id": 29607, "agent.id": 29392, "agent.ts": "2017-09-05 22:38:36", "agent.title": "BREINHOLT INSURANCE GROUP LLC", "agent.pull_right": "11.74 mi", "agent.phone_number": "(480) 237-2050", "agent.street_address": "4115 E VALLEY AUTO DR STE 205", "agent.address_locality": "Mesa, AZ 85206-4612" }, "29605": { "city_x_agent.id": 29605, "agent.id": 29395, "agent.ts": "2017-09-05 22:38:36", "agent.title": "THE ARIZONA GROUP", "agent.pull_right": "12.73 mi", "agent.phone_number": "(480) 892-8755", "agent.street_address": "3325 E BASELINE RD", "agent.address_locality": "Gilbert, AZ 85234-2633" }, "29604": { "city_x_agent.id": 29604, "agent.id": 29396, "agent.ts": "2017-09-05 22:38:36", "agent.title": "STRONG TOWER INS GROUP INC", "agent.pull_right": "12.81 mi", "agent.phone_number": "(480) 926-9011", "agent.street_address": "3303 E BASELINE RD STE 101", "agent.address_locality": "Gilbert, AZ 85234-2739" }, "29599": { "city_x_agent.id": 29599, "agent.id": 29418, "agent.ts": "2017-09-05 22:39:01", "agent.title": "GBP RISK SOLUTIONS", "agent.pull_right": "19.57 mi", "agent.phone_number": "(480) 775-1811", "agent.street_address": "2222 S DOBSON RD STE 502", "agent.address_locality": "Mesa, AZ 85202-6493" }, "29597": { "city_x_agent.id": 29597, "agent.id": 29420, "agent.ts": "2017-09-05 22:39:01", "agent.title": "ALL VALLEY INSURANCE", "agent.pull_right": "19.61 mi", "agent.phone_number": "(480) 498-2278", "agent.street_address": "2266 S DOBSON RD STE 200", "agent.address_locality": "Mesa, AZ 85202-6412" }, "29609": { "city_x_agent.id": 29609, "agent.id": 29619, "agent.ts": "2017-09-05 22:41:06", "agent.title": "RELIABLE RISK MANAGEMENT LLC", "agent.pull_right": "7.87 mi", "agent.phone_number": "(480) 813-3415", "agent.street_address": "401 W BASELINE RD STE 210", "agent.address_locality": "Tempe, AZ 85283-5350" }, "29628": { "city_x_agent.id": 29628, "agent.id": 29638, "agent.ts": "2017-09-05 22:41:20", "agent.title": "MINARD-AMES INSURANCE SVCS LLC", "agent.pull_right": "13.21 mi", "agent.phone_number": "(602) 273-1625", "agent.street_address": "4646 E VAN BUREN ST STE 200", "agent.address_locality": "Phoenix, AZ 85008-6956" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "93": { "city.id": 93, "city.ts": "2017-08-15 02:34:18", "city.title": "Cottonwood", "city.city_x_agent_id": { "684": { "city_x_agent.id": 684, "agent.id": 684, "agent.ts": "2017-09-05 05:30:48", "agent.title": "BUTLER-LEAVITT INSURANCE AGCY", "agent.pull_right": "20.48 mi", "agent.phone_number": "(928) 634-5521", "agent.street_address": "405 S MAIN ST", "agent.address_locality": "Cottonwood, AZ 86326-3904" }, "685": { "city_x_agent.id": 685, "agent.id": 685, "agent.ts": "2017-09-05 05:30:48", "agent.title": "N F P PROPERTY & CASUALTY SVCS", "agent.pull_right": "1.04 mi", "agent.phone_number": "(928) 775-3430", "agent.street_address": "7120 E PAV WAY STE 105", "agent.address_locality": "Prescott Valley, AZ 86314" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "94": { "city.id": 94, "city.ts": "2017-08-15 02:34:18", "city.title": "Douglas", "city.city_x_agent_id": { "686": { "city_x_agent.id": 686, "agent.id": 686, "agent.ts": "2017-09-05 05:29:01", "agent.title": "N F P PROPERTY & CASUALTY SVCS", "agent.pull_right": "0.06 mi", "agent.phone_number": "(520) 364-8496", "agent.street_address": "952 F AVE", "agent.address_locality": "Douglas, AZ 85607-2001" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "95": { "city.id": 95, "city.ts": "2017-08-15 02:34:18", "city.title": "Flagstaff", "city.city_x_agent_id": { "687": { "city_x_agent.id": 687, "agent.id": 687, "agent.ts": "2017-09-05 05:29:07", "agent.title": "N F P PROPERTY & CASUALTY SVCS", "agent.pull_right": "0.33 mi", "agent.phone_number": "(928) 774-3345", "agent.street_address": "420 N HUMPHREYS ST", "agent.address_locality": "Flagstaff, AZ 86001-4532" }, "688": { "city_x_agent.id": 688, "agent.id": 688, "agent.ts": "2017-09-05 05:29:07", "agent.title": "THE MAHONEY GROUP", "agent.pull_right": "0.80 mi", "agent.phone_number": "(928) 774-0606", "agent.street_address": "809 W RIORDAN RD STE 206", "agent.address_locality": "Flagstaff, AZ 86001-0815" }, "689": { "city_x_agent.id": 689, "agent.id": 689, "agent.ts": "2017-09-05 05:29:07", "agent.title": "FLAGSTAFF INSURANCE INC", "agent.pull_right": "1.03 mi", "agent.phone_number": "(928) 774-6631", "agent.street_address": "1300 E BUTLER AVE STE 100", "agent.address_locality": "Flagstaff, AZ 86001" }, "690": { "city_x_agent.id": 690, "agent.id": 690, "agent.ts": "2017-09-05 05:29:07", "agent.title": "LEAVITT GROUP OF NORTHERN AZ", "agent.pull_right": "1.45 mi", "agent.phone_number": "(928) 526-3223", "agent.street_address": "1338 W FOREST MEADOWS ST STE 1", "agent.address_locality": "Flagstaff, AZ 86001-7218" }, "691": { "city_x_agent.id": 691, "agent.id": 691, "agent.ts": "2017-09-05 05:29:07", "agent.title": "WIT INS", "agent.pull_right": "1.59 mi", "agent.phone_number": "(602) 953-6926", "agent.street_address": "2201 N GEMINI DR # 119", "agent.address_locality": "Flagstaff, AZ 86001-1637" }, "692": { "city_x_agent.id": 692, "agent.id": 692, "agent.ts": "2017-09-05 05:29:07", "agent.title": "GIESE & EDEN INS GROUP LLC", "agent.pull_right": "1.76 mi", "agent.phone_number": "(928) 214-8694", "agent.street_address": "1750 S RAILROAD SPRINGS BLVD STE 9", "agent.address_locality": "Flagstaff, AZ 86001-8720" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "96": { "city.id": 96, "city.ts": "2017-09-05 22:41:59", "city.title": "Fountain Hills", "city.city_x_agent_id": { "694": { "city_x_agent.id": 694, "agent.id": 599, "agent.ts": "2017-09-05 05:31:23", "agent.title": "Maximos Soliman", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 315-0400", "agent.street_address": "16420 N 92nd St Ste 105", "agent.address_locality": "Scottsdale, AZ 85260" }, "29668": { "city_x_agent.id": 29668, "agent.id": 600, "agent.ts": "2017-09-05 05:28:31", "agent.title": "WESTERN AG-INS AGENCY INC", "agent.pull_right": "8.76 mi", "agent.phone_number": "(480) 550-1507", "agent.street_address": "STE 207", "agent.address_locality": "28170 N Alma School Pkwy, AZ 85262" }, "29667": { "city_x_agent.id": 29667, "agent.id": 601, "agent.ts": "2017-09-05 05:28:31", "agent.title": "WESTERN AG-INS AGENCY INC", "agent.pull_right": "8.76 mi", "agent.phone_number": "(480) 550-1507", "agent.street_address": "28170 N ALMA SCHOOL PKWY STE 207", "agent.address_locality": "Scottsdale, AZ 85262-8053" }, "29676": { "city_x_agent.id": 29676, "agent.id": 602, "agent.ts": "2017-09-05 05:28:31", "agent.title": "JVP INS AGENCY LLC", "agent.pull_right": "7.88 mi", "agent.phone_number": "(480) 473-3100", "agent.street_address": "10025 E DYNAMITE BLVD STE B135", "agent.address_locality": "Scottsdale, AZ 85262-3688" }, "29654": { "city_x_agent.id": 29654, "agent.id": 603, "agent.ts": "2017-09-05 05:28:09", "agent.title": "ARIZONA INS SPECIALISTS LLC", "agent.pull_right": "9.72 mi", "agent.phone_number": "(602) 717-4992", "agent.street_address": "30423 N 139TH ST", "agent.address_locality": "Scottsdale, AZ 85262-5988" }, "29659": { "city_x_agent.id": 29659, "agent.id": 604, "agent.ts": "2017-09-05 05:27:12", "agent.title": "BRIDGELIGHT INSURANCE", "agent.pull_right": "5.17 mi", "agent.phone_number": "(480) 999-3020", "agent.street_address": "20645 N PIMA RD STE 225", "agent.address_locality": "Scottsdale, AZ 85255-5681" }, "29651": { "city_x_agent.id": 29651, "agent.id": 605, "agent.ts": "2017-09-05 05:27:12", "agent.title": "LIGHTFOOT & ASSOCIATES LLC", "agent.pull_right": "5.45 mi", "agent.phone_number": "(720) 261-2249", "agent.street_address": "29306 N 153RD PL", "agent.address_locality": "Scottsdale, AZ 85262-6920" }, "29661": { "city_x_agent.id": 29661, "agent.id": 606, "agent.ts": "2017-09-05 05:27:12", "agent.title": "CREST INSURANCE GROUP", "agent.pull_right": "6.01 mi", "agent.phone_number": "(520) 881-5760", "agent.street_address": "8302 E BUTEO DR", "agent.address_locality": "Scottsdale, AZ 85255-3920" }, "29658": { "city_x_agent.id": 29658, "agent.id": 607, "agent.ts": "2017-09-05 05:27:12", "agent.title": "GREENE INS GROUP LLC", "agent.pull_right": "7.45 mi", "agent.phone_number": "(480) 657-2800", "agent.street_address": "17470 N PACESETTER WAY", "agent.address_locality": "Scottsdale, AZ 85255-5445" }, "702": { "city_x_agent.id": 702, "agent.id": 608, "agent.ts": "2017-09-05 05:29:15", "agent.title": "PRUTTING INS GROUP INC", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 502-4300", "agent.street_address": "8889 E BELL RD STE 201", "agent.address_locality": "Scottsdale, AZ 85260-1597" }, "29642": { "city_x_agent.id": 29642, "agent.id": 614, "agent.ts": "2017-09-05 05:28:31", "agent.title": "John Delbrocco", "agent.pull_right": "11.66 mi", "agent.phone_number": "(602) 863-1315", "agent.street_address": "20235 N Cave Creek Rd Ste 110", "agent.address_locality": "Phoenix, AZ 85024-0800" }, "29648": { "city_x_agent.id": 29648, "agent.id": 615, "agent.ts": "2017-09-05 05:30:33", "agent.title": "Maximos Soliman", "agent.pull_right": "7.95 mi", "agent.phone_number": "(602) 540-3673", "agent.street_address": "16841 N 31st Ave STE 146", "agent.address_locality": "Phoenix, AZ 85053" }, "29678": { "city_x_agent.id": 29678, "agent.id": 622, "agent.ts": "2017-09-05 05:27:31", "agent.title": "KOHLHASE INS INC", "agent.pull_right": "8.27 mi", "agent.phone_number": "(480) 832-8370", "agent.street_address": "6550 E MAIN ST", "agent.address_locality": "Mesa, AZ 85205-9041" }, "697": { "city_x_agent.id": 697, "agent.id": 623, "agent.ts": "2017-09-05 05:29:15", "agent.title": "CANYON LANDS INSURANCE 1 INC", "agent.pull_right": "8.73 mi", "agent.phone_number": "(480) 288-5900", "agent.street_address": "3654 N POWER RD STE 146", "agent.address_locality": "Mesa, AZ 85215-9793" }, "29641": { "city_x_agent.id": 29641, "agent.id": 624, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Aaron Isakson", "agent.pull_right": "8.70 mi", "agent.phone_number": "(480) 888-0318", "agent.street_address": "1819 E Southern Ave Ste E-20", "agent.address_locality": "Mesa, AZ 85204" }, "693": { "city_x_agent.id": 693, "agent.id": 625, "agent.ts": "2017-09-05 05:29:15", "agent.title": "Aaron Isakson", "agent.pull_right": "0.37 mi", "agent.phone_number": "(480) 888-0318", "agent.street_address": "16930 E Palisades Blvd", "agent.address_locality": "Fountain Hills, AZ 85268" }, "29640": { "city_x_agent.id": 29640, "agent.id": 626, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "3.87 mi", "agent.phone_number": "(480) 945-3123", "agent.street_address": "2932 N 68th St Ste 4", "agent.address_locality": "Scottsdale, AZ 85251" }, "29647": { "city_x_agent.id": 29647, "agent.id": 627, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Carlos Enrique Oliveros", "agent.pull_right": "6.09 mi", "agent.phone_number": "(480) 270-2935", "agent.street_address": "8400 S Kyrene Rd Ste 230", "agent.address_locality": "Tempe, AZ 85284" }, "29644": { "city_x_agent.id": 29644, "agent.id": 628, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Peter Tadevossian", "agent.pull_right": "1.83 mi", "agent.phone_number": "(480) 719-7183", "agent.street_address": "1910 S Priest Dr", "agent.address_locality": "Tempe, AZ 85281" }, "29645": { "city_x_agent.id": 29645, "agent.id": 635, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Ryan J Larson", "agent.pull_right": "9.37 mi", "agent.phone_number": "(602) 393-1338", "agent.street_address": "1500 E Bethany Home Rd Ste 170", "agent.address_locality": "Phoenix, AZ 85014-2444" }, "29643": { "city_x_agent.id": 29643, "agent.id": 637, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "7.76 mi", "agent.phone_number": "(602) 493-4851", "agent.street_address": "2415 E Camelback Rd Ste 700", "agent.address_locality": "Phoenix, AZ 85016" }, "29646": { "city_x_agent.id": 29646, "agent.id": 638, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Michelle Riachi", "agent.pull_right": "5.17 mi", "agent.phone_number": "(480) 438-8214", "agent.street_address": "9830 S 51st St Ste A127", "agent.address_locality": "Phoenix, AZ 85044" }, "29649": { "city_x_agent.id": 29649, "agent.id": 676, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Ernie Barten", "agent.pull_right": "7.74 mi", "agent.phone_number": "(480) 686-3099", "agent.street_address": "4425 E Agave Rd Ste 136", "agent.address_locality": "Phoenix, AZ 85044" }, "695": { "city_x_agent.id": 695, "agent.id": 695, "agent.ts": "2017-09-05 05:29:15", "agent.title": "GARVEY HANSEN LLC", "agent.pull_right": "0.11 mi", "agent.phone_number": "(480) 836-1468", "agent.street_address": "13034 N VERDE RIVER DR STE 101", "agent.address_locality": "Fountain Hills, AZ 85268-8443" }, "696": { "city_x_agent.id": 696, "agent.id": 696, "agent.ts": "2017-09-05 05:29:15", "agent.title": "SHEPHERD INSURANCE LLC", "agent.pull_right": "8.61 mi", "agent.phone_number": "(480) 657-8872", "agent.street_address": "14411 N 98TH PL", "agent.address_locality": "Scottsdale, AZ 85260-3851" }, "698": { "city_x_agent.id": 698, "agent.id": 698, "agent.ts": "2017-09-05 05:29:15", "agent.title": "PRIORITY INS ASSOC LLC", "agent.pull_right": "8.75 mi", "agent.phone_number": "(480) 477-6500", "agent.street_address": "14354 N FRANK LLOYD WRIGHT BLV", "agent.address_locality": "Scottsdale, AZ 85260-8844" }, "699": { "city_x_agent.id": 699, "agent.id": 699, "agent.ts": "2017-09-05 05:29:15", "agent.title": "SEEK INSURANCE SERVICES LLC", "agent.pull_right": "8.75 mi", "agent.phone_number": "(480) 666-9889", "agent.street_address": "14362 N FRANK LLOYD WRIGHT BLV SUITE 2600", "agent.address_locality": "Scottsdale, AZ 85260-8846" }, "700": { "city_x_agent.id": 700, "agent.id": 700, "agent.ts": "2017-09-05 05:29:15", "agent.title": "BRIGHTWAY INSURANCE", "agent.pull_right": "9.87 mi", "agent.phone_number": "(888) 254-5014", "agent.street_address": "9393 N 90TH ST STE 110", "agent.address_locality": "Scottsdale, AZ 85258-5041" }, "701": { "city_x_agent.id": 701, "agent.id": 701, "agent.ts": "2017-09-05 05:29:15", "agent.title": "HILL INSURANCE SERVICES LLC", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 368-5222", "agent.street_address": "14301 N 87TH ST STE 115", "agent.address_locality": "Scottsdale, AZ 85260-3688" }, "29679": { "city_x_agent.id": 29679, "agent.id": 818, "agent.ts": "2017-09-05 05:31:23", "agent.title": "EATON PROVIDENT GROUP LLC", "agent.pull_right": "0.85 mi", "agent.phone_number": "(480) 941-4895", "agent.street_address": "3333 N HAYDEN RD", "agent.address_locality": "Scottsdale, AZ 85251-6626" }, "29670": { "city_x_agent.id": 29670, "agent.id": 820, "agent.ts": "2017-09-05 05:31:23", "agent.title": "ROADRUNNER INS LLC", "agent.pull_right": "2.22 mi", "agent.phone_number": "(480) 625-4108", "agent.street_address": "5976 N 83RD ST", "agent.address_locality": "Scottsdale, AZ 85250-6215" }, "29653": { "city_x_agent.id": 29653, "agent.id": 29289, "agent.ts": "2017-09-05 22:37:15", "agent.title": "CORPORATE INS SOLUTIONS LLC", "agent.pull_right": "7.57 mi", "agent.phone_number": "(480) 336-8740", "agent.street_address": "8585 E HARTFORD DR STE 600", "agent.address_locality": "Scottsdale, AZ 85255-5475" }, "29674": { "city_x_agent.id": 29674, "agent.id": 29291, "agent.ts": "2017-09-05 22:37:15", "agent.title": "THE AMBASSADOR GROUP INC", "agent.pull_right": "7.92 mi", "agent.phone_number": "(480) 776-6950", "agent.street_address": "7010 E CHAUNCEY LN STE 230", "agent.address_locality": "Phoenix, AZ 85054-3118" }, "29675": { "city_x_agent.id": 29675, "agent.id": 29292, "agent.ts": "2017-09-05 22:37:15", "agent.title": "VAN LEER-AMBASSADOR GRP INS", "agent.pull_right": "7.92 mi", "agent.phone_number": "(480) 776-6950", "agent.street_address": "7010 E CHAUNCEY LN STE 230", "agent.address_locality": "Phoenix, AZ 85054-3118" }, "29665": { "city_x_agent.id": 29665, "agent.id": 29293, "agent.ts": "2017-09-05 22:37:15", "agent.title": "AZCAL INSURANCE SVS AGENCY INC", "agent.pull_right": "8.59 mi", "agent.phone_number": "(480) 948-8008", "agent.street_address": "7689 E PARADISE LN STE 4", "agent.address_locality": "Scottsdale, AZ 85260-1691" }, "29669": { "city_x_agent.id": 29669, "agent.id": 29294, "agent.ts": "2017-09-05 22:37:15", "agent.title": "ALLIANCE INSURANCE PARTNERS", "agent.pull_right": "8.60 mi", "agent.phone_number": "(602) 427-4300", "agent.street_address": "16427 N SCOTTSDALE RD STE 410", "agent.address_locality": "Scottsdale, AZ 85254-7102" }, "29672": { "city_x_agent.id": 29672, "agent.id": 29298, "agent.ts": "2017-09-05 22:37:17", "agent.title": "WILLIS OF ARIZONA INC", "agent.pull_right": "8.84 mi", "agent.phone_number": "(602) 787-6000", "agent.street_address": "16220 N SCOTTSDALE RD STE 600", "agent.address_locality": "Scottsdale, AZ 85254" }, "29673": { "city_x_agent.id": 29673, "agent.id": 29299, "agent.ts": "2017-09-05 22:37:17", "agent.title": "WILLIS PERSONAL LINES INC", "agent.pull_right": "8.84 mi", "agent.phone_number": "(602) 787-6132", "agent.street_address": "16220 N SCOTTSDALE RD STE 600", "agent.address_locality": "Scottsdale, AZ 85254-1804" }, "29652": { "city_x_agent.id": 29652, "agent.id": 29300, "agent.ts": "2017-09-05 22:37:17", "agent.title": "THE CLEMENTS AGENCY LLC", "agent.pull_right": "9.02 mi", "agent.phone_number": "(480) 477-5245", "agent.street_address": "8350 E RAINTREE DR #235", "agent.address_locality": "Scottsdale, AZ 85260-2695" }, "29657": { "city_x_agent.id": 29657, "agent.id": 29302, "agent.ts": "2017-09-05 22:37:17", "agent.title": "PINNACLE PEAK INS GROUP INC", "agent.pull_right": "9.33 mi", "agent.phone_number": "(480) 424-4756", "agent.street_address": "8147 E EVANS RD STE B-07", "agent.address_locality": "Scottsdale, AZ 85260-3646" }, "29671": { "city_x_agent.id": 29671, "agent.id": 29303, "agent.ts": "2017-09-05 22:37:17", "agent.title": "SULLIVAN JAMES LLC", "agent.pull_right": "9.69 mi", "agent.phone_number": "(480) 382-7332", "agent.street_address": "7077 E MARILYN RD STE 13", "agent.address_locality": "Scottsdale, AZ 85254-2781" }, "29662": { "city_x_agent.id": 29662, "agent.id": 29304, "agent.ts": "2017-09-05 22:37:17", "agent.title": "GG INSURANCE SERVICES INC", "agent.pull_right": "9.74 mi", "agent.phone_number": "(480) 264-7226", "agent.street_address": "7600 E REDFIELD RD HNGR B # 14", "agent.address_locality": "Scottsdale, AZ 85260-3493" }, "29663": { "city_x_agent.id": 29663, "agent.id": 29305, "agent.ts": "2017-09-05 22:37:17", "agent.title": "GG INSURANCE SERVICES INC", "agent.pull_right": "9.74 mi", "agent.phone_number": "(480) 264-7226", "agent.street_address": "7600 E REDFIELD RD STE 145", "agent.address_locality": "Scottsdale, AZ 85260-3491" }, "29664": { "city_x_agent.id": 29664, "agent.id": 29306, "agent.ts": "2017-09-05 22:37:17", "agent.title": "INS CONCEPTS & RISK MGMT LLC", "agent.pull_right": "9.82 mi", "agent.phone_number": "(602) 368-8977", "agent.street_address": "7585 E REDFIELD RD STE 107", "agent.address_locality": "Scottsdale, AZ 85260-6937" }, "29666": { "city_x_agent.id": 29666, "agent.id": 29326, "agent.ts": "2017-09-05 22:37:34", "agent.title": "PREMIER GROUP INSURANCE INC", "agent.pull_right": "12.89 mi", "agent.phone_number": "(480) 231-5329", "agent.street_address": "7702 E DOUBLETREE RANCH RD#300", "agent.address_locality": "Scottsdale, AZ 85258" }, "29650": { "city_x_agent.id": 29650, "agent.id": 29327, "agent.ts": "2017-09-05 22:37:34", "agent.title": "VIP INSURANCE SERVICES LLC", "agent.pull_right": "13.19 mi", "agent.phone_number": "(480) 696-6438", "agent.street_address": "9221 E. VIA DE VENTURE", "agent.address_locality": "Scottsdale, AZ 85258" }, "29677": { "city_x_agent.id": 29677, "agent.id": 29389, "agent.ts": "2017-09-05 22:38:36", "agent.title": "FOX RELIABLE INS SERVICES", "agent.pull_right": "10.31 mi", "agent.phone_number": "(480) 807-7753", "agent.street_address": "4930 E MAIN ST STE 9", "agent.address_locality": "Mesa, AZ 85205-8005" }, "29655": { "city_x_agent.id": 29655, "agent.id": 29390, "agent.ts": "2017-09-05 22:38:36", "agent.title": "SOUTHWEST RISK MANAGEMENT LLC", "agent.pull_right": "10.66 mi", "agent.phone_number": "(480) 924-1200", "agent.street_address": "4801 E MCKELLIPS RD", "agent.address_locality": "Mesa, AZ 85215-2527" }, "29656": { "city_x_agent.id": 29656, "agent.id": 29427, "agent.ts": "2017-09-05 22:39:01", "agent.title": "CANYON LANDS INSURANCE 1 INC", "agent.pull_right": "21.90 mi", "agent.phone_number": "(602) 953-6926", "agent.street_address": "8722 E VIA DE COMMERCIO STE 20", "agent.address_locality": "Scottsdale, AZ 85258-3434" }, "29660": { "city_x_agent.id": 29660, "agent.id": 29670, "agent.ts": "2017-09-05 22:41:45", "agent.title": "N F P PROPERTY & CASUALTY SVCS", "agent.pull_right": "10.81 mi", "agent.phone_number": "(480) 947-3556", "agent.street_address": "8201 N HAYDEN RD", "agent.address_locality": "Scottsdale, AZ 85258-2453" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "97": { "city.id": 97, "city.ts": "2017-09-05 22:42:36", "city.title": "Gilbert", "city.city_x_agent_id": { "29724": { "city_x_agent.id": 29724, "agent.id": 599, "agent.ts": "2017-09-05 05:31:23", "agent.title": "Maximos Soliman", "agent.pull_right": "9.97 mi", "agent.phone_number": "(480) 315-0400", "agent.street_address": "16420 N 92nd St Ste 105", "agent.address_locality": "Scottsdale, AZ 85260" }, "29710": { "city_x_agent.id": 29710, "agent.id": 622, "agent.ts": "2017-09-05 05:27:31", "agent.title": "KOHLHASE INS INC", "agent.pull_right": "8.27 mi", "agent.phone_number": "(480) 832-8370", "agent.street_address": "6550 E MAIN ST", "agent.address_locality": "Mesa, AZ 85205-9041" }, "29726": { "city_x_agent.id": 29726, "agent.id": 623, "agent.ts": "2017-09-05 05:29:15", "agent.title": "CANYON LANDS INSURANCE 1 INC", "agent.pull_right": "8.73 mi", "agent.phone_number": "(480) 288-5900", "agent.street_address": "3654 N POWER RD STE 146", "agent.address_locality": "Mesa, AZ 85215-9793" }, "703": { "city_x_agent.id": 703, "agent.id": 624, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Aaron Isakson", "agent.pull_right": "8.70 mi", "agent.phone_number": "(480) 888-0318", "agent.street_address": "1819 E Southern Ave Ste E-20", "agent.address_locality": "Mesa, AZ 85204" }, "29722": { "city_x_agent.id": 29722, "agent.id": 625, "agent.ts": "2017-09-05 05:29:15", "agent.title": "Aaron Isakson", "agent.pull_right": "0.37 mi", "agent.phone_number": "(480) 888-0318", "agent.street_address": "16930 E Palisades Blvd", "agent.address_locality": "Fountain Hills, AZ 85268" }, "29720": { "city_x_agent.id": 29720, "agent.id": 626, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "3.87 mi", "agent.phone_number": "(480) 945-3123", "agent.street_address": "2932 N 68th St Ste 4", "agent.address_locality": "Scottsdale, AZ 85251" }, "704": { "city_x_agent.id": 704, "agent.id": 627, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Carlos Enrique Oliveros", "agent.pull_right": "6.09 mi", "agent.phone_number": "(480) 270-2935", "agent.street_address": "8400 S Kyrene Rd Ste 230", "agent.address_locality": "Tempe, AZ 85284" }, "29718": { "city_x_agent.id": 29718, "agent.id": 628, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Peter Tadevossian", "agent.pull_right": "1.83 mi", "agent.phone_number": "(480) 719-7183", "agent.street_address": "1910 S Priest Dr", "agent.address_locality": "Tempe, AZ 85281" }, "29723": { "city_x_agent.id": 29723, "agent.id": 635, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Ryan J Larson", "agent.pull_right": "9.37 mi", "agent.phone_number": "(602) 393-1338", "agent.street_address": "1500 E Bethany Home Rd Ste 170", "agent.address_locality": "Phoenix, AZ 85014-2444" }, "29721": { "city_x_agent.id": 29721, "agent.id": 637, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "7.76 mi", "agent.phone_number": "(602) 493-4851", "agent.street_address": "2415 E Camelback Rd Ste 700", "agent.address_locality": "Phoenix, AZ 85016" }, "29717": { "city_x_agent.id": 29717, "agent.id": 638, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Michelle Riachi", "agent.pull_right": "5.17 mi", "agent.phone_number": "(480) 438-8214", "agent.street_address": "9830 S 51st St Ste A127", "agent.address_locality": "Phoenix, AZ 85044" }, "29719": { "city_x_agent.id": 29719, "agent.id": 676, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Ernie Barten", "agent.pull_right": "7.74 mi", "agent.phone_number": "(480) 686-3099", "agent.street_address": "4425 E Agave Rd Ste 136", "agent.address_locality": "Phoenix, AZ 85044" }, "712": { "city_x_agent.id": 712, "agent.id": 678, "agent.ts": "2017-09-05 05:29:26", "agent.title": "COLGROVE FINANCIAL LLC", "agent.pull_right": "3.76 mi", "agent.phone_number": "(480) 830-2595", "agent.street_address": "555 W CHANDLER BLVD STE 203", "agent.address_locality": "Chandler, AZ 85225-7540" }, "29691": { "city_x_agent.id": 29691, "agent.id": 679, "agent.ts": "2017-09-05 05:28:44", "agent.title": "SAN MARCOS INS GROUP LLC", "agent.pull_right": "0.55 mi", "agent.phone_number": "(480) 899-6633", "agent.street_address": "584 W CHANDLER BLVD", "agent.address_locality": "Chandler, AZ 85225-7531" }, "29705": { "city_x_agent.id": 29705, "agent.id": 680, "agent.ts": "2017-09-05 05:28:44", "agent.title": "JOHN MINARD INS SOUTHWEST LTD", "agent.pull_right": "2.81 mi", "agent.phone_number": "(480) 756-8439", "agent.street_address": "2727 W FRYE RD STE 200", "agent.address_locality": "Chandler, AZ 85224-4943" }, "29707": { "city_x_agent.id": 29707, "agent.id": 681, "agent.ts": "2017-09-05 05:28:44", "agent.title": "CLEAR CHOICE INSURANCE LLC", "agent.pull_right": "3.25 mi", "agent.phone_number": "(480) 719-2812", "agent.street_address": "1490 S PRICE RD STE 206", "agent.address_locality": "Chandler, AZ 85286-6608" }, "711": { "city_x_agent.id": 711, "agent.id": 682, "agent.ts": "2017-09-05 05:29:26", "agent.title": "RIDE NOW INSURANCE LLC", "agent.pull_right": "3.44 mi", "agent.phone_number": "(888) 743-3669", "agent.street_address": "3333 N ARIZONA AVE", "agent.address_locality": "Chandler, AZ 85225-7106" }, "29693": { "city_x_agent.id": 29693, "agent.id": 683, "agent.ts": "2017-09-05 05:31:17", "agent.title": "FOOTHILLS INSURANCE AGENCY INC", "agent.pull_right": "15.10 mi", "agent.phone_number": "(480) 759-1970", "agent.street_address": "2450 S GILBERT RD STE 203", "agent.address_locality": "Chandler, AZ 85286-1595" }, "705": { "city_x_agent.id": 705, "agent.id": 705, "agent.ts": "2017-09-05 05:29:26", "agent.title": "LEGACY ONE INSURANCE", "agent.pull_right": "1.67 mi", "agent.phone_number": "(480) 212-1913", "agent.street_address": "725 W ELLIOT RD STE 101-5", "agent.address_locality": "Gilbert, AZ 85233-5301" }, "706": { "city_x_agent.id": 706, "agent.id": 706, "agent.ts": "2017-09-05 05:29:26", "agent.title": "ELITE INSURANCE GROUP LLC", "agent.pull_right": "1.73 mi", "agent.phone_number": "(480) 632-8245", "agent.street_address": "207 N GILBERT RD STE 1", "agent.address_locality": "Gilbert, AZ 85234-5812" }, "707": { "city_x_agent.id": 707, "agent.id": 707, "agent.ts": "2017-09-05 05:29:26", "agent.title": "GILBERT INSURANCE GROUP INC", "agent.pull_right": "1.88 mi", "agent.phone_number": "(480) 926-9030", "agent.street_address": "350 N GILBERT RD STE 202", "agent.address_locality": "Gilbert, AZ 85234-5770" }, "708": { "city_x_agent.id": 708, "agent.id": 708, "agent.ts": "2017-09-05 05:29:26", "agent.title": "SAN TAN INSURANCE SERVICES", "agent.pull_right": "2.22 mi", "agent.phone_number": "(480) 391-3883", "agent.street_address": "625 N GILBERT RD STE 107", "agent.address_locality": "Gilbert, AZ 85234" }, "709": { "city_x_agent.id": 709, "agent.id": 709, "agent.ts": "2017-09-05 05:29:26", "agent.title": "COMMERCIAL WEST INS AGENCY", "agent.pull_right": "2.64 mi", "agent.phone_number": "(480) 961-5400", "agent.street_address": "971 N GILBERT RD STE 20301", "agent.address_locality": "Gilbert, AZ 85234-3472" }, "710": { "city_x_agent.id": 710, "agent.id": 710, "agent.ts": "2017-09-05 05:29:26", "agent.title": "ALLIANCE INS AGCY OF AZ LLC", "agent.pull_right": "3.09 mi", "agent.phone_number": "(602) 271-9171", "agent.street_address": "1450 W GUADALUPE RD STE 117", "agent.address_locality": "Gilbert, AZ 85233-3056" }, "29706": { "city_x_agent.id": 29706, "agent.id": 742, "agent.ts": "2017-09-05 05:30:02", "agent.title": "PASSEY BOND CO INC", "agent.pull_right": "0.08 mi", "agent.phone_number": "(480) 969-2291", "agent.street_address": "28 N CENTER ST", "agent.address_locality": "Mesa, AZ 85201-7328" }, "29695": { "city_x_agent.id": 29695, "agent.id": 743, "agent.ts": "2017-09-05 05:30:02", "agent.title": "LEBARON & CARROLL LLC", "agent.pull_right": "2.35 mi", "agent.phone_number": "(480) 834-9315", "agent.street_address": "1350 E SOUTHERN AVE", "agent.address_locality": "Mesa, AZ 85204-5142" }, "29697": { "city_x_agent.id": 29697, "agent.id": 745, "agent.ts": "2017-09-05 05:30:02", "agent.title": "MASSEY GROUP LLC", "agent.pull_right": "2.35 mi", "agent.phone_number": "(480) 729-6088", "agent.street_address": "1350 E SOUTHERN AVE", "agent.address_locality": "Mesa, AZ 85204-5142" }, "29698": { "city_x_agent.id": 29698, "agent.id": 746, "agent.ts": "2017-09-05 05:30:02", "agent.title": "THE MAHONEY GROUP", "agent.pull_right": "2.65 mi", "agent.phone_number": "(480) 730-4920", "agent.street_address": "1835 S EXTENSION RD", "agent.address_locality": "Mesa, AZ 85210-5942" }, "29725": { "city_x_agent.id": 29725, "agent.id": 790, "agent.ts": "2017-09-05 05:31:17", "agent.title": "THE INS TEAM", "agent.pull_right": "6.98 mi", "agent.phone_number": "(480) 626-1860", "agent.street_address": "22246 S ELLSWORTH RD", "agent.address_locality": "Queen Creek, AZ 85142-8358" }, "29713": { "city_x_agent.id": 29713, "agent.id": 791, "agent.ts": "2017-09-05 05:31:17", "agent.title": "OVERLAND INSURANCE SERVICES", "agent.pull_right": "8.28 mi", "agent.phone_number": "(800) 677-4027", "agent.street_address": "18842 E VIA DEL ORO", "agent.address_locality": "Queen Creek, AZ 85142-4063" }, "29714": { "city_x_agent.id": 29714, "agent.id": 792, "agent.ts": "2017-09-05 05:31:17", "agent.title": "OVERLAND MANAGEMENT CORP", "agent.pull_right": "8.28 mi", "agent.phone_number": "(800) 677-4027", "agent.street_address": "18842 E VIA DEL ORO", "agent.address_locality": "Queen Creek, AZ 85142-4063" }, "29729": { "city_x_agent.id": 29729, "agent.id": 793, "agent.ts": "2017-09-05 05:31:17", "agent.title": "A ARIZONA INS AGENCY LLC", "agent.pull_right": "6.11 mi", "agent.phone_number": "(480) 677-2575", "agent.street_address": "1542 OCOTILLO RD", "agent.address_locality": "San Tan Valley, AZ 85140" }, "29709": { "city_x_agent.id": 29709, "agent.id": 794, "agent.ts": "2017-09-05 05:31:17", "agent.title": "PINNACLE INSURANCE GROUP LLP", "agent.pull_right": "9.37 mi", "agent.phone_number": "(480) 474-0334", "agent.street_address": "17933 E SANOQUE BLVD", "agent.address_locality": "Gilbert, AZ 85298-8973" }, "29704": { "city_x_agent.id": 29704, "agent.id": 795, "agent.ts": "2017-09-05 05:31:17", "agent.title": "PREMIER GROUP INSURANCE INC", "agent.pull_right": "11.54 mi", "agent.phone_number": "(480) 275-2555", "agent.street_address": "4365 E PECOS RD STE 140", "agent.address_locality": "Gilbert, AZ 85295-8053" }, "29699": { "city_x_agent.id": 29699, "agent.id": 796, "agent.ts": "2017-09-05 05:31:17", "agent.title": "BATCHSOFT LLC", "agent.pull_right": "13.57 mi", "agent.phone_number": "(480) 436-7077", "agent.street_address": "4058 S WHITE DR STE A1", "agent.address_locality": "Chandler, AZ 85249-5533" }, "29728": { "city_x_agent.id": 29728, "agent.id": 818, "agent.ts": "2017-09-05 05:31:23", "agent.title": "EATON PROVIDENT GROUP LLC", "agent.pull_right": "0.85 mi", "agent.phone_number": "(480) 941-4895", "agent.street_address": "3333 N HAYDEN RD", "agent.address_locality": "Scottsdale, AZ 85251-6626" }, "29727": { "city_x_agent.id": 29727, "agent.id": 819, "agent.ts": "2017-09-05 05:31:23", "agent.title": "BENNETT & PORTER INS SERVICES", "agent.pull_right": "0.90 mi", "agent.phone_number": "(480) 212-1150", "agent.street_address": "3200 N HAYDEN RD STE 310", "agent.address_locality": "Scottsdale, AZ 85251-6655" }, "29711": { "city_x_agent.id": 29711, "agent.id": 843, "agent.ts": "2017-09-05 05:32:01", "agent.title": "ARIZONA INSURANCE AGENCY", "agent.pull_right": "1.96 mi", "agent.phone_number": "(480) 966-3400", "agent.street_address": "1713 E BROADWAY RD", "agent.address_locality": "Tempe, AZ 85282-1611" }, "29712": { "city_x_agent.id": 29712, "agent.id": 844, "agent.ts": "2017-09-05 05:32:01", "agent.title": "PREMIER GROUP INSURANCE INC", "agent.pull_right": "3.24 mi", "agent.phone_number": "(480) 535-5709", "agent.street_address": "600 E BASELINE RD STE B-3", "agent.address_locality": "Tempe, AZ 85283-1266" }, "29708": { "city_x_agent.id": 29708, "agent.id": 29389, "agent.ts": "2017-09-05 22:38:36", "agent.title": "FOX RELIABLE INS SERVICES", "agent.pull_right": "10.31 mi", "agent.phone_number": "(480) 807-7753", "agent.street_address": "4930 E MAIN ST STE 9", "agent.address_locality": "Mesa, AZ 85205-8005" }, "29715": { "city_x_agent.id": 29715, "agent.id": 29390, "agent.ts": "2017-09-05 22:38:36", "agent.title": "SOUTHWEST RISK MANAGEMENT LLC", "agent.pull_right": "10.66 mi", "agent.phone_number": "(480) 924-1200", "agent.street_address": "4801 E MCKELLIPS RD", "agent.address_locality": "Mesa, AZ 85215-2527" }, "29700": { "city_x_agent.id": 29700, "agent.id": 29391, "agent.ts": "2017-09-05 22:38:36", "agent.title": "WILSON INSURANCE INC", "agent.pull_right": "11.56 mi", "agent.phone_number": "(480) 964-2400", "agent.street_address": "3950 E BROADWAY RD STE 102", "agent.address_locality": "Mesa, AZ 85206-1031" }, "29694": { "city_x_agent.id": 29694, "agent.id": 29392, "agent.ts": "2017-09-05 22:38:36", "agent.title": "BREINHOLT INSURANCE GROUP LLC", "agent.pull_right": "11.74 mi", "agent.phone_number": "(480) 237-2050", "agent.street_address": "4115 E VALLEY AUTO DR STE 205", "agent.address_locality": "Mesa, AZ 85206-4612" }, "29690": { "city_x_agent.id": 29690, "agent.id": 29395, "agent.ts": "2017-09-05 22:38:36", "agent.title": "THE ARIZONA GROUP", "agent.pull_right": "12.73 mi", "agent.phone_number": "(480) 892-8755", "agent.street_address": "3325 E BASELINE RD", "agent.address_locality": "Gilbert, AZ 85234-2633" }, "29692": { "city_x_agent.id": 29692, "agent.id": 29396, "agent.ts": "2017-09-05 22:38:36", "agent.title": "STRONG TOWER INS GROUP INC", "agent.pull_right": "12.81 mi", "agent.phone_number": "(480) 926-9011", "agent.street_address": "3303 E BASELINE RD STE 101", "agent.address_locality": "Gilbert, AZ 85234-2739" }, "29702": { "city_x_agent.id": 29702, "agent.id": 29418, "agent.ts": "2017-09-05 22:39:01", "agent.title": "GBP RISK SOLUTIONS", "agent.pull_right": "19.57 mi", "agent.phone_number": "(480) 775-1811", "agent.street_address": "2222 S DOBSON RD STE 502", "agent.address_locality": "Mesa, AZ 85202-6493" }, "29701": { "city_x_agent.id": 29701, "agent.id": 29420, "agent.ts": "2017-09-05 22:39:01", "agent.title": "ALL VALLEY INSURANCE", "agent.pull_right": "19.61 mi", "agent.phone_number": "(480) 498-2278", "agent.street_address": "2266 S DOBSON RD STE 200", "agent.address_locality": "Mesa, AZ 85202-6412" }, "29716": { "city_x_agent.id": 29716, "agent.id": 29619, "agent.ts": "2017-09-05 22:41:06", "agent.title": "RELIABLE RISK MANAGEMENT LLC", "agent.pull_right": "7.87 mi", "agent.phone_number": "(480) 813-3415", "agent.street_address": "401 W BASELINE RD STE 210", "agent.address_locality": "Tempe, AZ 85283-5350" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "98": { "city.id": 98, "city.ts": "2017-09-05 22:43:15", "city.title": "Glendale", "city.city_x_agent_id": { "29778": { "city_x_agent.id": 29778, "agent.id": 614, "agent.ts": "2017-09-05 05:28:31", "agent.title": "John Delbrocco", "agent.pull_right": "11.66 mi", "agent.phone_number": "(602) 863-1315", "agent.street_address": "20235 N Cave Creek Rd Ste 110", "agent.address_locality": "Phoenix, AZ 85024-0800" }, "716": { "city_x_agent.id": 716, "agent.id": 615, "agent.ts": "2017-09-05 05:30:33", "agent.title": "Maximos Soliman", "agent.pull_right": "7.95 mi", "agent.phone_number": "(602) 540-3673", "agent.street_address": "16841 N 31st Ave STE 146", "agent.address_locality": "Phoenix, AZ 85053" }, "715": { "city_x_agent.id": 715, "agent.id": 616, "agent.ts": "2017-09-05 05:31:43", "agent.title": "TJ Mazur", "agent.pull_right": "6.68 mi", "agent.phone_number": "(623) 776-8501", "agent.street_address": "7121 W Bell Rd Ste 30L", "agent.address_locality": "Glendale, AZ 85308-8559" }, "713": { "city_x_agent.id": 713, "agent.id": 618, "agent.ts": "2017-09-05 05:30:42", "agent.title": "Edgar Acosta", "agent.pull_right": "8.32 mi", "agent.phone_number": "(623) 302-0313", "agent.street_address": "7141 N 51st Ave Ste B", "agent.address_locality": "Glendale, AZ 85301" }, "29779": { "city_x_agent.id": 29779, "agent.id": 626, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "3.87 mi", "agent.phone_number": "(480) 945-3123", "agent.street_address": "2932 N 68th St Ste 4", "agent.address_locality": "Scottsdale, AZ 85251" }, "29763": { "city_x_agent.id": 29763, "agent.id": 629, "agent.ts": "2017-09-05 05:27:49", "agent.title": "A1 INSURANCE LLC", "agent.pull_right": "17.42 mi", "agent.phone_number": "(602) 635-7411", "agent.street_address": "12409 W INDIAN SCHOOL RD C 302", "agent.address_locality": "Avondale, AZ 85392-9508" }, "29741": { "city_x_agent.id": 29741, "agent.id": 630, "agent.ts": "2017-09-05 05:27:49", "agent.title": "KENNY ONG FINANCIAL SERVICES", "agent.pull_right": "21.14 mi", "agent.phone_number": "(623) 907-8800", "agent.street_address": "8450 W MCDOWELL RD STE 105", "agent.address_locality": "Phoenix, AZ 85037-4150" }, "719": { "city_x_agent.id": 719, "agent.id": 631, "agent.ts": "2017-09-05 05:30:33", "agent.title": "COPPER MOUNTAIN INS SOLUTIONS", "agent.pull_right": "3.23 mi", "agent.phone_number": "(602) 412-3366", "agent.street_address": "6751 N SUNSET BLVD STE 320", "agent.address_locality": "Glendale, AZ 85305-3155" }, "714": { "city_x_agent.id": 714, "agent.id": 632, "agent.ts": "2017-09-05 05:30:42", "agent.title": "Miguel Torres", "agent.pull_right": "7.16 mi", "agent.phone_number": "(623) 873-1234", "agent.street_address": "5901 W Indian School Rd Ste 4", "agent.address_locality": "Phoenix, AZ 85033" }, "717": { "city_x_agent.id": 717, "agent.id": 635, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Ryan J Larson", "agent.pull_right": "9.37 mi", "agent.phone_number": "(602) 393-1338", "agent.street_address": "1500 E Bethany Home Rd Ste 170", "agent.address_locality": "Phoenix, AZ 85014-2444" }, "718": { "city_x_agent.id": 718, "agent.id": 637, "agent.ts": "2017-09-05 05:32:01", "agent.title": "Mark Alan Garland", "agent.pull_right": "7.76 mi", "agent.phone_number": "(602) 493-4851", "agent.street_address": "2415 E Camelback Rd Ste 700", "agent.address_locality": "Phoenix, AZ 85016" }, "720": { "city_x_agent.id": 720, "agent.id": 720, "agent.ts": "2017-09-05 05:30:33", "agent.title": "HENDERSON ANDERSON INSURANCE", "agent.pull_right": "3.19 mi", "agent.phone_number": "(866) 241-9005", "agent.street_address": "6677 W THUNDERBIRD RD STE K182", "agent.address_locality": "Glendale, AZ 85306-3758" }, "721": { "city_x_agent.id": 721, "agent.id": 721, "agent.ts": "2017-09-05 05:29:29", "agent.title": "ADRAR INS AGENCY LLC", "agent.pull_right": "5.43 mi", "agent.phone_number": "(602) 570-0140", "agent.street_address": "4801 N 19TH AVE STE 4", "agent.address_locality": "Phoenix, AZ 85015-7423" }, "722": { "city_x_agent.id": 722, "agent.id": 722, "agent.ts": "2017-09-05 05:29:29", "agent.title": "ADVANTAGE INS PLLC", "agent.pull_right": "5.50 mi", "agent.phone_number": "(623) 505-7910", "agent.street_address": "4548 N 19TH AVE", "agent.address_locality": "Phoenix, AZ 85015-4117" }, "29744": { "city_x_agent.id": 29744, "agent.id": 765, "agent.ts": "2017-09-05 05:31:43", "agent.title": "ENSIGN & ASSOC", "agent.pull_right": "5.41 mi", "agent.phone_number": "(623) 888-3041", "agent.street_address": "16165 N 83RD AVE STE 200", "agent.address_locality": "Peoria, AZ 85382-5816" }, "29742": { "city_x_agent.id": 29742, "agent.id": 767, "agent.ts": "2017-09-05 05:30:33", "agent.title": "ALL AMERICAN WESTERN INS INC", "agent.pull_right": "4.86 mi", "agent.phone_number": "(623) 773-9232", "agent.street_address": "6541 W BELL RD #1070", "agent.address_locality": "Glendale, AZ 85308" }, "29761": { "city_x_agent.id": 29761, "agent.id": 768, "agent.ts": "2017-09-05 05:30:33", "agent.title": "GLENDALE INSURANCE LLC", "agent.pull_right": "6.63 mi", "agent.phone_number": "(602) 843-1802", "agent.street_address": "19420 N 59 AVE BLDG B STE 245", "agent.address_locality": "Glendale, AZ 85308" }, "29764": { "city_x_agent.id": 29764, "agent.id": 776, "agent.ts": "2017-09-05 05:30:42", "agent.title": "WELLS FARGO INS SVCS USA INC", "agent.pull_right": "0.03 mi", "agent.phone_number": "(602) 528-3000", "agent.street_address": "100 W WASHINGTON ST FL 4", "agent.address_locality": "Phoenix, AZ 85003-1802" }, "29762": { "city_x_agent.id": 29762, "agent.id": 777, "agent.ts": "2017-09-05 05:30:42", "agent.title": "FARMER WOODS GROUP", "agent.pull_right": "0.74 mi", "agent.phone_number": "(602) 264-0566", "agent.street_address": "919 N 1ST ST", "agent.address_locality": "Phoenix, AZ 85004-1902" }, "29753": { "city_x_agent.id": 29753, "agent.id": 778, "agent.ts": "2017-09-07 21:53:23", "agent.title": "COBIZ INSURANCE INC", "agent.pull_right": "2.00 mi", "agent.phone_number": "(602) 296-2300", "agent.street_address": "2600 N CENTRAL AVE STE 1950", "agent.address_locality": "Phoenix, AZ 85004" }, "29774": { "city_x_agent.id": 29774, "agent.id": 29348, "agent.ts": "2017-09-05 22:38:03", "agent.title": "ALPHA INSURANCE SERVICES, LLP", "agent.pull_right": "13.40 mi", "agent.phone_number": "(623) 581-5234", "agent.street_address": "2401 W BEHREND DR STE 69", "agent.address_locality": "Phoenix, AZ 85027-4145" }, "29765": { "city_x_agent.id": 29765, "agent.id": 29350, "agent.ts": "2017-09-05 22:38:03", "agent.title": "RICHARD FERREIRA INS AGCY LLC", "agent.pull_right": "14.02 mi", "agent.phone_number": "(520) 448-4498", "agent.street_address": "2550 W UNION HILLS DR STE 350", "agent.address_locality": "Phoenix, AZ 85027-5187" }, "29777": { "city_x_agent.id": 29777, "agent.id": 29351, "agent.ts": "2017-09-05 22:38:03", "agent.title": "BAILEY INS LTD", "agent.pull_right": "14.35 mi", "agent.phone_number": "(602) 866-2600", "agent.street_address": "717 W UNION HILLS DR STE 10", "agent.address_locality": "Phoenix, AZ 85027-5580" }, "29776": { "city_x_agent.id": 29776, "agent.id": 29353, "agent.ts": "2017-09-05 22:38:03", "agent.title": "CDS INSURANCE AGENCY LLC", "agent.pull_right": "15.50 mi", "agent.phone_number": "(602) 996-5000", "agent.street_address": "706 E BELL RD STE 211", "agent.address_locality": "Phoenix, AZ 85022-6658" }, "29755": { "city_x_agent.id": 29755, "agent.id": 29376, "agent.ts": "2017-09-05 22:38:16", "agent.title": "SEMINOFF & ASSOCIATES LLC", "agent.pull_right": "20.13 mi", "agent.phone_number": "(602) 957-0915", "agent.street_address": "1124 E VOGEL AVE", "agent.address_locality": "Phoenix, AZ 85020-2621" }, "29740": { "city_x_agent.id": 29740, "agent.id": 29454, "agent.ts": "2017-09-05 22:39:18", "agent.title": "DANIELS NICOLSON INSURANCE", "agent.pull_right": "15.01 mi", "agent.phone_number": "(602) 277-0970", "agent.street_address": "4411 N 19TH AVE", "agent.address_locality": "Phoenix, AZ 85015-4115" }, "29749": { "city_x_agent.id": 29749, "agent.id": 29457, "agent.ts": "2017-09-05 22:39:18", "agent.title": "FORTRESS CAPITAL INS L L C", "agent.pull_right": "15.58 mi", "agent.phone_number": "(602) 233-3930", "agent.street_address": "2612 N 7TH AVE STE A", "agent.address_locality": "Phoenix, AZ 85006" }, "29750": { "city_x_agent.id": 29750, "agent.id": 29462, "agent.ts": "2017-09-05 22:39:20", "agent.title": "BROWN & BROWN INS OF AZ INC", "agent.pull_right": "16.08 mi", "agent.phone_number": "(602) 996-7600", "agent.street_address": "2800 N CENTRAL AVE STE 1600", "agent.address_locality": "Phoenix, AZ 85004-1047" }, "29752": { "city_x_agent.id": 29752, "agent.id": 29464, "agent.ts": "2017-09-05 22:39:20", "agent.title": "BROWN & BROWN INSURANCE OF AZ", "agent.pull_right": "16.08 mi", "agent.phone_number": "(602) 277-6672", "agent.street_address": "2800 N CENTRAL AVE STE 1600", "agent.address_locality": "Phoenix, AZ 85004-1047" }, "29748": { "city_x_agent.id": 29748, "agent.id": 29466, "agent.ts": "2017-09-05 22:39:20", "agent.title": "SOUTHWEST INS BROKERS LLC", "agent.pull_right": "16.99 mi", "agent.phone_number": "(602) 263-0777", "agent.street_address": "510 E CAMELBACK RD", "agent.address_locality": "Phoenix, AZ 85012-1616" }, "29746": { "city_x_agent.id": 29746, "agent.id": 29467, "agent.ts": "2017-09-05 22:39:20", "agent.title": "HESTER, HEITEL & ASSOCIATES", "agent.pull_right": "17.41 mi", "agent.phone_number": "(602) 230-7726", "agent.street_address": "6122 N 7TH ST", "agent.address_locality": "Phoenix, AZ 85014-1860" }, "29760": { "city_x_agent.id": 29760, "agent.id": 29468, "agent.ts": "2017-09-05 22:39:26", "agent.title": "T D INSURANCE", "agent.pull_right": "17.64 mi", "agent.phone_number": "(602) 254-3208", "agent.street_address": "1430 E INDIAN SCHOOL RD #240", "agent.address_locality": "Phoenix, AZ 85014-4976" }, "29747": { "city_x_agent.id": 29747, "agent.id": 29469, "agent.ts": "2017-09-05 22:39:26", "agent.title": "A A A ARIZONA INC", "agent.pull_right": "17.81 mi", "agent.phone_number": "(602) 650-2700", "agent.street_address": "742 E GLENDALE AVE STE 182", "agent.address_locality": "Phoenix, AZ 85020-5358" }, "29743": { "city_x_agent.id": 29743, "agent.id": 29471, "agent.ts": "2017-09-05 22:39:26", "agent.title": "ANCAP INSURANCE", "agent.pull_right": "18.30 mi", "agent.phone_number": "(602) 943-2586", "agent.street_address": "8802 N 4TH ST", "agent.address_locality": "Phoenix, AZ 85020-2902" }, "29756": { "city_x_agent.id": 29756, "agent.id": 29472, "agent.ts": "2017-09-05 22:39:26", "agent.title": "AVI PHX INSURANCE BROKERS LLC", "agent.pull_right": "18.77 mi", "agent.phone_number": "(602) 707-7707", "agent.street_address": "7220 N 16TH ST STE C", "agent.address_locality": "Phoenix, AZ 85020-5253" }, "29757": { "city_x_agent.id": 29757, "agent.id": 29473, "agent.ts": "2017-09-05 22:39:26", "agent.title": "SOUTHWEST BONDING & INS", "agent.pull_right": "18.87 mi", "agent.phone_number": "(602) 375-5200", "agent.street_address": "7315 N 16TH ST STE 100", "agent.address_locality": "Phoenix, AZ 85020-5271" }, "29766": { "city_x_agent.id": 29766, "agent.id": 29474, "agent.ts": "2017-09-05 22:39:26", "agent.title": "SUNSTATE INSURANCE AGENCY LLC", "agent.pull_right": "18.97 mi", "agent.phone_number": "(602) 650-2700", "agent.street_address": "2375 E CAMELBACK RD STE 500", "agent.address_locality": "Phoenix, AZ 85016-3489" }, "29767": { "city_x_agent.id": 29767, "agent.id": 29475, "agent.ts": "2017-09-05 22:39:26", "agent.title": "USI INSURANCE SERVICES LLC", "agent.pull_right": "18.97 mi", "agent.phone_number": "(855) 874-0780", "agent.street_address": "2375 E CAMELBACK RD STE 250", "agent.address_locality": "Phoenix, AZ 85016-3491" }, "29770": { "city_x_agent.id": 29770, "agent.id": 29476, "agent.ts": "2017-09-05 22:39:26", "agent.title": "GARLAND INS & FINANCIAL SERV LLC", "agent.pull_right": "19.08 mi", "agent.phone_number": "(602) 953-6915", "agent.street_address": "2415 E CAMELBACK RD STE 700", "agent.address_locality": "Phoenix, AZ 85016-4245" }, "29771": { "city_x_agent.id": 29771, "agent.id": 29477, "agent.ts": "2017-09-05 22:39:26", "agent.title": "INFINITY COMMERCIAL INS INC", "agent.pull_right": "19.08 mi", "agent.phone_number": "(602) 512-1319", "agent.street_address": "2415 E CAMELBACK RD STE 700", "agent.address_locality": "Phoenix, AZ 85016-4245" }, "29758": { "city_x_agent.id": 29758, "agent.id": 29768, "agent.ts": "2017-09-05 22:42:49", "agent.title": "RESECO INSURANCE ADVISORS LLC", "agent.pull_right": "8.06 mi", "agent.phone_number": "(602) 753-4250", "agent.street_address": "7901 N 16TH ST STE 100", "agent.address_locality": "Phoenix, AZ 85020-7426" }, "29759": { "city_x_agent.id": 29759, "agent.id": 29769, "agent.ts": "2017-09-05 22:42:49", "agent.title": "RESECO INSURANCE ADVISORS, LLC", "agent.pull_right": "8.06 mi", "agent.phone_number": "(602) 753-4250", "agent.street_address": "7901 N 16TH ST STE 100", "agent.address_locality": "Phoenix, AZ 85020-7426" }, "29768": { "city_x_agent.id": 29768, "agent.id": 29778, "agent.ts": "2017-09-05 22:42:54", "agent.title": "PAULA MARIE ZIELIN", "agent.pull_right": "9.27 mi", "agent.phone_number": "(602) 553-2212", "agent.street_address": "6245 N 24TH PKWY STE 212", "agent.address_locality": "Phoenix, AZ 85016-2030" }, "29769": { "city_x_agent.id": 29769, "agent.id": 29779, "agent.ts": "2017-09-05 22:42:54", "agent.title": "SOUTHWEST GENERAL INSURANCE", "agent.pull_right": "9.27 mi", "agent.phone_number": "(602) 553-2212", "agent.street_address": "6245 N 24TH PKWY STE 212", "agent.address_locality": "Phoenix, AZ 85016-2030" }, "29772": { "city_x_agent.id": 29772, "agent.id": 29782, "agent.ts": "2017-09-05 22:43:05", "agent.title": "SARBU & STAN INS SVCS LLC", "agent.pull_right": "9.32 mi", "agent.phone_number": "(480) 550-9105", "agent.street_address": "2415 E CAMELBACK RD STE 700", "agent.address_locality": "Phoenix, AZ 85016-4245" }, "29773": { "city_x_agent.id": 29773, "agent.id": 29783, "agent.ts": "2017-09-05 22:43:05", "agent.title": "ALLIANT INSURANCE SERVICES INC", "agent.pull_right": "9.32 mi", "agent.phone_number": "(602) 707-1900", "agent.street_address": "2415 E CAMELBACK RD STE 420", "agent.address_locality": "Phoenix, AZ 85016-9205" }, "29775": { "city_x_agent.id": 29775, "agent.id": 29785, "agent.ts": "2017-09-05 22:43:05", "agent.title": "HORIZON INS AGENCY LLC", "agent.pull_right": "9.89 mi", "agent.phone_number": "(602) 992-9750", "agent.street_address": "2880 E NORTHERN AVE STE 100", "agent.address_locality": "Phoenix, AZ 85028-4800" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "99": { "city.id": 99, "city.ts": "2017-09-05 22:43:28", "city.title": "Green Valley", "city.city_x_agent_id": { "723": { "city_x_agent.id": 723, "agent.id": 723, "agent.ts": "2017-09-05 05:29:39", "agent.title": "Peter Tadevossian", "agent.pull_right": "0.84 mi", "agent.phone_number": "(520) 399-4444", "agent.street_address": "101 S La Canada Dr Ste 73", "agent.address_locality": "Green Valley, AZ 85614" }, "724": { "city_x_agent.id": 724, "agent.id": 724, "agent.ts": "2017-09-05 05:32:06", "agent.title": "Peter Tadevossian", "agent.pull_right": "4.98 mi", "agent.phone_number": "(520) 294-6162", "agent.street_address": "5650 S 12th St Ste 100", "agent.address_locality": "Tucson, AZ 85706" }, "725": { "city_x_agent.id": 725, "agent.id": 725, "agent.ts": "2017-09-05 05:29:39", "agent.title": "INSURELY LLC", "agent.pull_right": "18.67 mi", "agent.phone_number": "(520) 200-8083", "agent.street_address": "3121 W CALLE ROSALINDA", "agent.address_locality": "Tucson, AZ 85746-2194" }, "726": { "city_x_agent.id": 726, "agent.id": 726, "agent.ts": "2017-09-05 05:32:06", "agent.title": "ALVARADO INS INC", "agent.pull_right": "3.57 mi", "agent.phone_number": "(520) 777-8020", "agent.street_address": "4455 S PARK AVE STE 103", "agent.address_locality": "Tucson, AZ 85714-1669" }, "727": { "city_x_agent.id": 727, "agent.id": 727, "agent.ts": "2017-09-05 05:32:06", "agent.title": "SHANER INS GROUP", "agent.pull_right": "1.10 mi", "agent.phone_number": "(520) 333-6224", "agent.street_address": "1250 S 4TH AVE STE 150", "agent.address_locality": "Tucson, AZ 85713-1694" }, "728": { "city_x_agent.id": 728, "agent.id": 728, "agent.ts": "2017-09-05 05:32:06", "agent.title": "CANYON LANDS INSURANCE 1 INC", "agent.pull_right": "2.06 mi", "agent.phone_number": "(520) 881-8222", "agent.street_address": "190 S STRATFORD DR STE 107", "agent.address_locality": "Tucson, AZ 85716-5318" }, "729": { "city_x_agent.id": 729, "agent.id": 729, "agent.ts": "2017-09-05 05:32:06", "agent.title": "GBP RISK SOLUTIONS", "agent.pull_right": "0.56 mi", "agent.phone_number": "(520) 798-1888", "agent.street_address": "621 N 6TH AVE", "agent.address_locality": "Tucson, AZ 85705-8330" }, "730": { "city_x_agent.id": 730, "agent.id": 730, "agent.ts": "2017-09-05 05:29:39", "agent.title": "CREST INSURANCE GROUP", "agent.pull_right": "24.40 mi", "agent.phone_number": "(520) 881-5760", "agent.street_address": "5285 E WILLIAMS CIR STE 4500", "agent.address_locality": "Tucson, AZ 85711-7456" }, "731": { "city_x_agent.id": 731, "agent.id": 731, "agent.ts": "2017-09-05 05:29:39", "agent.title": "CREST INSURANCE GROUP, LLC", "agent.pull_right": "24.40 mi", "agent.phone_number": "", "agent.street_address": "5285 E WILLIAMS CIR STE 4500", "agent.address_locality": "Tucson, AZ 85711-7456" }, "732": { "city_x_agent.id": 732, "agent.id": 732, "agent.ts": "2017-09-05 05:29:39", "agent.title": "RIGHTSURE INSURANCE GROUP", "agent.pull_right": "24.48 mi", "agent.phone_number": "(520) 901-7010", "agent.street_address": "5151 E BROADWAY BLVD STE 120", "agent.address_locality": "Tucson, AZ 85711-3780" }, "29790": { "city_x_agent.id": 29790, "agent.id": 850, "agent.ts": "2017-09-05 05:32:06", "agent.title": "F & B INSURANCE SERVICES INC", "agent.pull_right": "2.72 mi", "agent.phone_number": "(520) 512-5201", "agent.street_address": "3113 E 1ST ST", "agent.address_locality": "Tucson, AZ 85716-4202" }, "29791": { "city_x_agent.id": 29791, "agent.id": 29801, "agent.ts": "2017-09-05 22:43:25", "agent.title": "THE CLEMENTS AGENCY LLC", "agent.pull_right": "24.85 mi", "agent.phone_number": "(520) 624-3456", "agent.street_address": "6245 E BROADWAY BLVD STE 310", "agent.address_locality": "Tucson, AZ 85711-4044" }, "29792": { "city_x_agent.id": 29792, "agent.id": 29802, "agent.ts": "2017-09-05 22:43:25", "agent.title": "THE CLEMENTS AGENCY, LLC", "agent.pull_right": "24.85 mi", "agent.phone_number": "(480) 477-5245", "agent.street_address": "6245 E BROADWAY BLVD STE 310", "agent.address_locality": "Tucson, AZ 85711-4044" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" }, "100": { "city.id": 100, "city.ts": "2017-08-15 02:34:18", "city.title": "Holbrook", "city.city_x_agent_id": { "733": { "city_x_agent.id": 733, "agent.id": 733, "agent.ts": "2017-09-05 05:29:42", "agent.title": "SHUMWAY INSURANCE AGENCY INC", "agent.pull_right": "0.30 mi", "agent.phone_number": "(928) 524-6296", "agent.street_address": "538 W HOPI DR", "agent.address_locality": "Holbrook, AZ 86025-2848" } }, "state.id": 2, "state.ts": "2017-08-01 23:07:39", "state.title": "Arizona" } } } }