{"id":1291,"date":"2007-04-11T11:30:18","date_gmt":"2007-04-11T18:30:18","guid":{"rendered":"http:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/?p=1291"},"modified":"2007-04-11T11:31:33","modified_gmt":"2007-04-11T18:31:33","slug":"birth-of-a-zillowbot-a-faster-way-to-pee-on-the-tree","status":"publish","type":"post","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/1291\/birth-of-a-zillowbot-a-faster-way-to-pee-on-the-tree\/","title":{"rendered":"Birth of a Zillow.bot: A faster way to pee on the tree"},"content":{"rendered":"<p>I have a little prototype of a Zillow.bot. Here is all it does for now:<\/p>\n<ul>\n<li>It takes as input a download of listings from the ARMLS system<\/li>\n<li>It isolates the street address, the price, and the listing brokerage, throwing away all the other fields<\/li>\n<li>It sorts these newly concatenated fields by street name and house number, pumping the results to the screen for printing or post-processing in an Excel spreadsheet<\/li>\n<\/ul>\n<p>The gross idea is that a human input operator can work street by street in Zillow, which is more convenient and less error-prone than working in price order, which is how the MLS system sorts listings. (Plus which, there is no Excel-sortable ARMLS report that includes the name of the listing brokerage.)<\/p>\n<p>Ahem #1: I can convert the output to an XML file in four minutes, tops.<\/p>\n<p>Ahem #2: If I get bored enough with doing this work manually, I&#8217;ll figure out a way to do it in JavaScript.<\/p>\n<p>Actually, the real grief is going to be hot-sheeting every search.bot I build for my little Zillow.bot. If I pee on the tree when the house is listed for sale, I have an obligation to hose it off when it sells. <i>This<\/i> is a challenge for automation&#8230;<br \/>\n<!-- technorati tags start --><\/p>\n<p style=\"text-align:right;font-size:10px;\">Technorati Tags: <a href=\"http:\/\/www.technorati.com\/tag\/real estate\" rel=\"tag\">real estate<\/a>, <a href=\"http:\/\/www.technorati.com\/tag\/real estate marketing\" rel=\"tag\">real estate marketing<\/a><\/p>\n<p><!-- technorati tags end --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have a little prototype of a Zillow.bot. Here is all it does for now: It takes as input a download of listings from the ARMLS system It isolates the street address, the price, and the listing brokerage, throwing away all the other fields It sorts these newly concatenated fields by street name and house [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[6,5,19,25],"tags":[],"class_list":["post-1291","post","type-post","status-publish","format-standard","hentry","category-marketing","category-real-estate","category-technology","category-zillowcom","no-featured-image"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":2707,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/2707\/no-more-web-sites-in-the-remarks-section-armls-drops-the-hammer-on-the-one-little-bit-of-the-21st-century-it-was-getting-right\/","url_meta":{"origin":1291,"position":0},"title":"No more web sites in the remarks section? ARMLS drops the hammer on the one little bit of the 21st century it was getting right","author":"Greg Swann","date":"March 6, 2008","format":false,"excerpt":"I read about the outlawing of web site URLs in listings on the \"Welcome to Tempo\" page of the Arizona Regional Multiple Listings Services (ARMLS), but I wasn't certain it meant what it seemed to mean. Since I have been a Realtor, we have promoted our single-property websites in the\u2026","rel":"","context":"In &quot;Blogging&quot;","block_context":{"text":"Blogging","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/blogging\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":868,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/868\/was-businessweek-bamboozled-twist-doesnt-know-what-she-doesnt-know\/","url_meta":{"origin":1291,"position":1},"title":"Was BusinessWeek bamboozled? &#8220;Twist&#8221; doesn&#8217;t know what she doesn&#8217;t know . . .","author":"Greg Swann","date":"January 8, 2007","format":false,"excerpt":"This is a copy of email I just sent to Peter Coy of BusinessWeek with respect to false claims made last week about deception in the Arizona Regional Multiple Listings Service. Cliff's Notes: False alarm resulting from \"crackpot claims, the end product of a fervid imagination and a Rube Goldberg\u2026","rel":"","context":"In &quot;Blogging&quot;","block_context":{"text":"Blogging","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/blogging\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":14848,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/14848\/do-you-want-to-know-how-cool-armls-could-be-sell-it-as-a-business-and-see-what-someone-who-is-working-for-money-can-do-with-it\/","url_meta":{"origin":1291,"position":2},"title":"Do you want to know how cool ARMLS could be? Sell it as a business and see what someone who is working for money can do with it.","author":"Greg Swann","date":"July 25, 2011","format":false,"excerpt":"Here's a true fact of life: Not-for-profit \"businesses\" suck. Don't believe me? We'll discuss it after you get back from the Department of Motor Vehicles. To be fair, I'm willing to regard the Arizona Regional Multiple Listings Service (ARMLS) as something of an exception, at least as administered by Bob\u2026","rel":"","context":"In &quot;Flourishing&quot;","block_context":{"text":"Flourishing","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/flourishing\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":333,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/333\/ask-the-broker-why-would-an-mlsidx-system-forbid-commingling-with-listings-from-other-sources\/","url_meta":{"origin":1291,"position":3},"title":"Ask the Broker: Why would an MLS\/IDX system forbid commingling with listings from other sources . . . ?","author":"Greg Swann","date":"September 14, 2006","format":false,"excerpt":"Giving my prominent proboscis a good hard tweak, a certain pseudonymous Scarlet Pimpernelesque semi-retired real estate weblogger asks: \"Are you trying to say that the MLS' are not fascist dictatorships???\" The question refers to a weblog entry I posted last night chastising Trulia Blog for hyperbole in its complaints about\u2026","rel":"","context":"In &quot;Ask the Broker&quot;","block_context":{"text":"Ask the Broker","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/ask-the-broker\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":17353,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/17353\/dear-daniel-morillo-heres-why-opendoors-houses-sell-so-poorly-even-in-a-blistering-real-estate-market\/","url_meta":{"origin":1291,"position":4},"title":"Dear Daniel Morillo: Here\u2019s why #OpenDoor\u2019s houses sell so poorly \u2013 even in a blistering real estate\u00a0market.","author":"Greg Swann","date":"October 25, 2020","format":false,"excerpt":"Once upon a time in my young career, I used to think about sending little notes to flailing sellers, telling them why their houses weren't selling. Arguably, this would have been a violation of Article 15 of the NAR Code of (ahem) Ethics, but it would have been bad form\u2026","rel":"","context":"In &quot;Marketing&quot;","block_context":{"text":"Marketing","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/marketing\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-content\/uploads\/2020\/10\/109-clipped.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-content\/uploads\/2020\/10\/109-clipped.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-content\/uploads\/2020\/10\/109-clipped.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-content\/uploads\/2020\/10\/109-clipped.jpg?resize=700%2C400 2x"},"classes":[]},{"id":15702,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/15702\/schmoozing-on-line-with-the-junior-league-may-or-may-not-get-you-a-listing-but-twitbooking-is-corporate-networking-on-steroids\/","url_meta":{"origin":1291,"position":5},"title":"Schmoozing on-line with the Junior League may or may not get you a listing, but TwitBooking is corporate networking on steroids.","author":"Greg Swann","date":"February 13, 2012","format":false,"excerpt":"Spam from ARMLS:On February 13, 2012, at a Special Called Meeting of the ARMLS Board of Directors, Bob Bemis tendered his resignation notice as ARMLS CEO, to accept the newly created position of Vice President of Partner Relations for Zillow, Inc. in Seattle.Good on him. I'm thinking the retirement plan\u2026","rel":"","context":"In &quot;Real Estate&quot;","block_context":{"text":"Real Estate","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/real-estate\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/posts\/1291","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/comments?post=1291"}],"version-history":[{"count":0,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/posts\/1291\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/media?parent=1291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/categories?post=1291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/tags?post=1291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}