{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["DataPull","Inputs","Sheet4","Sources"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DataPull","index":0,"n_rows":97,"n_cols":11,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Auction Date","County ","Courthouse","Time","Property Address","Open Bid","Bid Status","Owner","Source"]
[null,"Check Site","Uintah","Vernal","11:00:00","332 West 2100 South, Vernal\n"," ","Sale is canceled. File is on hold.","Webb, Bart J.\n","Scalley"]
[null,"Check Site","Carbon","Price","12:00:00","140 North 200 East, Wellington\n"," ","Sale canceled. File is on hold.","Lupo, Raymond\n","Scalley"]
[null,"Check Site","Davis","Farmington","15:00:00","443 East 1450 North, Bountiful\n"," ",null,"York, Lapriel\n","Scalley"]
[null,"Check Site","Weber","Ogden","16:00:00","4423 South 1800 West, Roy\n"," ",null,"Lewis, Gary C.; Lewis, Pamela\n","Scalley"]
[null,"Check Site","Utah","Provo","11:00:00","2179 North 600 West, Pleasant Grove\n"," ",null,"Terry, Keith\n","Scalley"]
[null,"Check Site","Salt Lake","Salt Lake","12:00:00","9929 S Dolomite Lane, Sandy\n"," ",null,"Strickland, Phillip Rush\n","Scalley"]
[null,"Check Site","Salt Lake","Salt Lake","12:00:00","12063 South 1350 West, Riverton\n"," ",null,"Wise, Kathleen B.\n","Scalley"]
[null,"Check Site","San Juan","Monticello","12:00:00","Hwy 162 W. #3 Montezuma Creek\n"," ",null,"Orvin, Debbee P.\n","Scalley"]
[null,"Check Site","Uintah","Vernal","11:00:00","1405 West 250 South, Vernal\n"," ",null,"Antillon, Tommy E.; Antillon, Jessica L.\n","Scalley"]
[null,"Check Site","Utah","Provo","11:00:00","25 East 1450 South, Payson\n"," ",null,"Allen, Charles W.; Allen, Laura L.\n","Scalley"]
[null,"Check Site","Cache","Logan","16:00:00","844 West Hwy 101, Hyrum\n"," ","Sale Canceled. File on hold.","Esparza, Lloyd O.; Esparza, Jennifer\n","Scalley"]
[null,"Check Site","Weber","Ogden","16:00:00","4397 Monroe Blvd, S. Ogden\n"," ",null,"Mora, Rafael\n","Scalley"]
[null,"Check Site","Tooele","Tooele","09:30:00","5520 N. Windsor Way, Stansbury Park\n"," ","Sale is canceled. File is on hold.","Elggren, Paula\n","Scalley"]
[null,"Check Site","Weber","Ogden","16:00:00","914 East 1200 North, Ogden\n"," ",null,"Aeschlimann, Cynthia\n","Scalley"]
[null,"Check Site","Salt Lake","Salt Lake","12:00:00","5432 W Ridge Flower Way, Salt Lake City\n"," ",null,"Howick, David Ward\n","Scalley"]
[null,"Check Site","Uintah","Vernal","11:00:00","2357 West 550 South, Vernal\n"," ",null,"Forster, Seth L.\n","Scalley"]
[null,"Check Site","Salt Lake","Salt Lake","12:00:00","1311 E Murphys Lane, Salt Lake City\n"," ",null,"Terastvadsadrian, Srbui\n","Scalley"]
[null,"Check Site","Salt Lake","Salt Lake","12:00:00","5124 W Chippewa Place, West Valley City\n"," ","Sale is canceled. File is on hold.","Zambrana, Juan B.; Zambrana, Casey L.\n","Scalley"]
[null,"Check Site","Weber","Ogden","15:00:00","3367 East 4100 North, Eden\n"," ",null,"Stewart, Barbara L.; Stewart, Ralph C.\n","Scalley"]
[null,"Check Site","Box Elder","Brigham City","16:00:00","5675 North 4700 West, Bear River City\n"," ",null,"Tolboe, Rodney G.\n","Scalley"]
[null,"Check Site","Utah","Provo","11:00:00","1941 E Red Oak Road, Eagle Mountain\n"," ",null,"Albrecht, Shauna\n","Scalley"]
[null,"Check Site","Cache","Logan","16:00:00","431 West 3400 South, Nibley\n"," ","Sale is canceled. File is on hold.","Douglas, Brandon R.; Douglas, Jaydale S.\n","Scalley"]
[null,"Check Site","Duchesne","Duchesne","09:30:00","497 East 500 North, Roosevelt\n"," ",null,"McMillan, Reece; McMillan, Kristie\n","Scalley"]
[null,"Check Site","Uintah","Vernal","11:00:00","3924 East 5000 South, Vernal\n"," ",null,"Steimle, Daniel C.\n","Scalley"]
[null,"Check Site","Salt Lake","Salt Lake","12:00:00","3145 E Canyon Rim Lane, Salt Lake City\n"," ","Sale postponed to 5/17/16 @ 12:00 pm","Carlin, Peggy J.; Carlin, Ashlie C.\n","Scalley"]
[null,"Check Site","Salt Lake","Salt Lake","12:00:00","852 East Three Fountains Dr. #201, Salt Lake City\n"," ",null,"Whiting, Karen K.\n","Scalley"]
[null,"Check Site","Salt Lake","Salt Lake","12:00:00","7181 Sorrento Way, West Jordan\n"," ",null,"Johnson, Tina M.\n","Scalley"]
[null,"Check Site","Uintah","Vernal","11:00:00","1010 North 500 East, Vernal\n"," ",null,"Green, Jory D.\n","Scalley"]
[null,"Check Site","Salt Lake","Salt Lake","12:00:00","4589 S 5400 W, Salt Lake City\n"," ",null,"Lucero, Brooke N.; Aragon, Carol\n","Scalley"]
[null,"Check Site","Salt Lake","Salt Lake","12:00:00","3263 W Caraway Bay, West Jordan\n"," ",null,"Kennington, Ralph Brent\n","Scalley"]
[null,"Check Site","Duchesne","Duchesne","09:30:00","126 East 600 North, Roosevelt\n"," ",null,"Harman, Althea B.\n","Scalley"]
[null,"Check Site","Duchesne","Duchesne","09:30:00","9242 W Ledge Lane, Upalco\n"," ",null,"Madsen, Deejay\n","Scalley"]
[null,"Check Site","Duchesne","Duchesne","09:30:00","145 East 500 North, Roosevelt\n"," ",null,"Hardman, Sandy L.\n","Scalley"]
[null,"Check Site","Duchesne","Duchesne","09:30:00","43507 W SR 35, Hanna\n"," ",null,"Hamilton, Thomas\n","Scalley"]
[null,"Check Site","Duchesne","Duchesne","09:30:00","582 East 530 South, Duchesne\n"," ",null,"Sorensen, Todd\n","Scalley"]
[null,"2016-04-12","Davis","N/A","09:30AM","2287 East 2400 North, Layton",197400,"Sold to 3rd party","N/A","Halliday-watkins.com"]
[null,"2016-04-12","Salt Lake","N/A","09:45AM","1639 East Pebble Beach Circle, Sandy",305327.09999999998,"Sold to 3rd party","N/A","Halliday-watkins.com"]
[null,"2016-04-12","Weber","N/A","10:30AM","2539 West 2625 North, Farr West",0,"Sale Cancelled/BK filed","N/A","Halliday-watkins.com"]
[null,"2016-04-12","Weber","N/A","10:30AM","325 East 2550 North #9, North Ogden",57712,"Sold to 3r party","N/A","Halliday-watkins.com",154000]
[null,"2016-04-12","Weber","N/A","10:30AM","5229 South 4000 West, Roy",0,"Sale Cancelled/FC closed","N/A","Halliday-watkins.com"]
[null,"2016-04-13","Salt Lake","N/A","09:45AM","3437 South 6400 West, West Valley City",0,"Sale Cancelled/FC on hold","N/A","Halliday-watkins.com"]
[null,"2016-04-13","Washington","N/A","04:30PM","2336 West Entrada Trail #7, St. George",522000,"Postponed to 4-13-2016","N/A","Halliday-watkins.com"]
[null,"2016-04-14","Weber","N/A","10:30AM","2307 \"C\" Avenue, Ogden",0,"Postponed to 5-17-2016","N/A","Halliday-watkins.com"]
[null,"2016-04-14","Weber","N/A","10:30AM","2857 West 3965 South #52, West Haven",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-15","Utah","N/A","09:00AM","240 South 180 East, Orem",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-15","Utah","N/A","09:00AM","1422 East 700 South, Provo",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-15","Salt Lake","N/A","09:45AM","2315 West 4240 South, Taylorsville",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-15","Salt Lake","N/A","09:45AM","4827 South Brown Villa Cove, Taylorsville",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-15","Salt Lake","N/A","09:45AM","1135 West Windfield Court, West Jordan",0,"Postponed to 4-15-2016","N/A","Halliday-watkins.com"]
[null,"2016-04-15","Cache","N/A","12:00PM","1030 North 130th West #100, Logan",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-15","Washington","N/A","04:30PM","5565 North 1070 West, Saint George",0,"Sale Cancelled/Short sale","N/A","Halliday-watkins.com"]
[null,"2016-04-18","Salt Lake","N/A","09:45AM","1703 West Man O War Drive, Bluffdale",0,null,"N/A","Halliday-watkins.com",451482]
[null,"2016-04-18","Salt Lake","N/A","09:45AM","14886 South Treseder  Street, Draper",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-18","Salt Lake","N/A","09:45AM","12946 South 6000 West, Herriman",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-18","Salt Lake","N/A","09:45AM","1241 West Eagle Nest Drive, Murray",0,"Sale Cancelled/BK re-opened","N/A","Halliday-watkins.com"]
[null,"2016-04-18","Salt Lake","N/A","09:45AM","5516 West 6635 South, West Jordan",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-18","Salt Lake","N/A","09:45AM","6808 South Cyclamen Drive, West Jordan",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-18","Salt Lake","N/A","09:45AM","6842 South 3335 West, West Jordan",0,"Postponed to 6-2-2016","N/A","Halliday-watkins.com"]
[null,"2016-04-18","Cache","N/A","12:00PM","170 West 200 South, Lewiston",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-18","Washington","N/A","04:30PM","1717 East 2290 South, St. George",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-18","Tooele","N/A","04:30PM","455 East Utah Avenue, Tooele",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-18","Tooele","N/A","04:30PM","974 West 740 South, Tooele",0,"Postponed to 4-18-2016","N/A","Halliday-watkins.com"]
[null,"2016-04-19","Davis","N/A","09:30AM","220 Barbara Avenue, Layton",0,"Sale Cancelled/BK filed","N/A","Halliday-watkins.com"]
[null,"2016-04-19","Weber","N/A","10:30AM","2595 West 2325 South, aka Ogden",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-19","Weber","N/A","10:30AM","3257 Harrison Boulevard Apt D10, Ogden",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-19","Weber","N/A","10:30AM","5742 South 2050 West, Roy",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-19","Box Elder","N/A","11:15AM","8120 North 4600 West, aka Tremonton",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-21","Weber","N/A","10:30AM","3290 West 4800 South, Roy",0,"Postponed to 4-21-2016","N/A","Halliday-watkins.com"]
[null,"2016-04-21","Weber","N/A","10:30AM","825 38th Street, South Ogden",0,"Postponed to 4-21-2016","N/A","Halliday-watkins.com"]
[null,"2016-04-21","Summit","N/A","03:00PM","2680 Aspen Springs, Park City",0,"Postponed to 4-21-2016","N/A","Halliday-watkins.com"]
[null,"2016-04-22","Utah","N/A","09:00AM","1153 East 1400 South, Spanish Fork",0,"Sale Cancelled/FC on hold","N/A","Halliday-watkins.com"]
[null,"2016-04-22","Carbon","N/A","09:45AM","267 North 100 West, Price",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-22","Salt Lake","N/A","09:45AM","5055 West 3000 South, West Valley City",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-22","Millard","N/A","12:30PM","345 Canyon Road, Fillmore",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-25","Utah","N/A","09:00AM","1227 North 3020 West, Provo",0,null,"N/A","Halliday-watkins.com"]
[null,"2016-04-13","Iron","N/A","01:00pm","3971 North Arabian Way,Enoch",0,"sale postponed from 3/16/16","Haley","Smith Knowles"]
[null,"2016-04-13","Salt Lake","N/A","02:00pm","858 North Lafayette Drive,Salt Lake City",65489.75,null,"Medina","Smith Knowles"]
[null,"2016-04-13","Davis","N/A","03:00pm","741 South 3900 West,Syracuse",0,"sale canceled - BK filed<br>","Miller, A","Smith Knowles"]
[null,"2016-04-13","Davis","N/A","03:00pm","229 North 360 West,Clearfield",0,"sale canceled<br>","Krava","Smith Knowles"]
[null,"2016-04-19","Uintah","N/A","10:00am","1456 West 400 South,Vernal",0,null,"Sunkees","Smith Knowles"]
[null,"2016-04-20","Washington","N/A","10:00am","74 North 100 East,Ivins",0,"sale postponed&nbsp;from 3/9/16","Howard","Smith Knowles"]
[null,"2016-04-20","Salt Lake","N/A","02:00pm","3248 South Field Mint Lane,Salt Lake City",0,null,"Chavez","Smith Knowles"]
[null,"2016-04-20","Salt Lake","N/A","02:00pm","7456 West Antonio Drive,Magna",0,null,"Bentley","Smith Knowles"]
[null,"2016-04-26","Box Elder","N/A","01:00pm","595 West 375 South,Tremonton",0,null,"Fletcher","Smith Knowles"]
[null,"2016-05-03","Weber","N/A","12:00pm","3683 Adams Ave,South Ogden",85900,null,"Bond","Smith Knowles"]
[null,"2016-05-03","Weber","N/A","12:00pm","293 East 4775 South,Washington Terrace",0,null,"Lizardo","Smith Knowles"]
[null,"2016-05-04","Salt Lake","N/A","02:00pm","2907 South Maiden Court,West Valley City",0,null,"Zenkic","Smith Knowles"]
[null,"2016-05-04","Salt Lake","N/A","02:00pm","3573 West 3965 South,West Valley City",0,null,"Malichanh","Smith Knowles"]
[null,"2016-05-04","Salt Lake","N/A","02:00pm","204 East Helm Avenue,Salt Lake City",0,null,"Orenday","Smith Knowles"]
[null,"2016-05-10","Duchesne","N/A","10:00am","175 North 400 West,Roosevelt",0,null,"Winder","Smith Knowles"]
[null,"2016-05-11","Washington","N/A","10:00am","1978 Chalet Drive,Santa Clara",0,null,"Bell","Smith Knowles"]
[null,"2016-05-11","Salt Lake","N/A","02:00pm","3580 South 1200 East,Salt Lake City",234087.89,null,"Noble","Smith Knowles"]
[null,"2016-05-11","Davis","N/A","03:00pm","265 North Terrace Drive,Clearfield",0,null,"Martin","Smith Knowles"]
[null,"2016-05-11","Davis","N/A","03:00pm","44 South Lakeview Drive,Clearfield",0,null,"Widner","Smith Knowles"]
[null,"2016-05-12","Utah","N/A","12:00pm","3907 Lake Vista Drive,Saratoga Springs",0,null,"Rosier","Smith Knowles"]

{"sheet":"Inputs","index":1,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Auction Data","County ","Courthouse","Time","Property Address","Open Bid","Bid Status","Owner","Source","Zestimate"]
["2016-04-18","Salt Lake","N/A","09:45AM","1703 West Man O War Drive, Bluffdale",0,null,"N/A","Halliday-watkins.com",451482]

{"sheet":"Sheet4","index":2,"n_rows":69,"n_cols":6,"rows_kept":69,"cut":false,"hidden":true,"merged":[]}
[null,null,"Website List","http://www.realauction.com/online-property-auction/foreclosure-and-tax-deed-auction-clients/"]
[null,"County","Population","Tax Deed Sales","When","Website"]
[null,"Miami-Dade County",2662874,"Yes","Random, Often, Combined","https://www.miamidade.realforeclose.com"]
[null,"Broward County",1869235,"Didn’t see any thru March",null,"https://www.broward.realforeclose.com"]
[null,"Palm Beach County",1397710]
[null,"Hillsborough County",1316298]
[null,"Orange County",1253001]
[null,"Pinellas County",938098]
[null,"Duval County",897698,"Yes, but not frequent.","January 13th, 2016","https://www.duval.realtaxdeed.com"]
[null,"Lee County",679513]
[null,"Polk County",634638,"Yes, Looks like monthly","Jan 21. (Looked, nothing good)","https://www.polk.realtaxdeed.com"]
[null,"Brevard County",556885]
[null,"Volusia County",507531,"Yes, Biweekly","Every other week on Tuesday","https://www.volusia.realtaxdeed.com"]
[null,"Pasco County",485331]
[null,"Seminole County",442516]
[null,"Sarasota County",396962]
[null,"Manatee County",351746]
[null,"Collier County",348777]
[null,"Marion County",339167]
[null,"Lake County",315690]
[null,"Escambia County",310659]
[null,"Osceola County",310211]
[null,"St. Lucie County",291028]
[null,"Leon County",283988]
[null,"Alachua County",256380]
[null,"St. Johns County",217919]
[null,"Clay County",199798]
[null,"Okaloosa County",196512]
[null,"Bay County",178985]
[null,"Hernando County",175855]
[null,"Charlotte County",168474]
[null,"Santa Rosa County",163422]
[null,"Martin County",153392]
[null,"Indian River County",144755]
[null,"Citrus County",139377]
[null,"Sumter County",114350]
[null,"Flagler County",102408]
[null,"Highlands County",98236]
[null,"Monroe County",77136]
[null,"Nassau County",76619]
[null,"Putnam County",72143]
[null,"Columbia County",67857]
[null,"Walton County",61530]
[null,"Jackson County",48801]
[null,"Gadsden County",46281]
[null,"Suwannee County",44022]
[null,"Levy County",39613]
[null,"Okeechobee County",39149]
[null,"Hendry County",38505]
[null,"DeSoto County",35012]
[null,"Wakulla County",31432]
[null,"Hardee County",27469]
[null,"Baker County",27093]
[null,"Bradford County",26702]
[null,"Washington County",24451]
[null,"Taylor County",22582]
[null,"Holmes County",19650]
[null,"Madison County",18518]
[null,"Gilchrist County",16997]
[null,"Gulf County",15944]
[null,"Dixie County",15907]
[null,"Union County",15190]
[null,"Calhoun County",14532]
[null,"Jefferson County",14050]
[null,"Hamilton County",14048]
[null,"Glades County",13635]
[null,"Franklin County",11815]
[null,"Lafayette County",8835]
[null,"Liberty County",8360]

{"sheet":"Sources","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Trustee Sales"]
["Company","Website","Notes"]
["Scalley, Reading, etc.","http://www.scalleyreading.net/index.php/trustee/futureTrusteeSales","Includes Utah, SL, Wasatch, Millard, Weber Counties, plus.","Done"]
["Lundberg and Associates","http://lundbergfirm.com/foreclosures"]
["Smith and Knowles","http://www.smithknowles.com/pending_foreclosure.php",null,"Done"]
["Halliday, Watkins, Mann","http://halliday-watkins.com/index.php?id=23",null,"Done"]