coronaHousingPrices.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import requests\n",
    "import gspread\n",
    "from oauth2client.service_account import ServiceAccountCredentials\n",
    "import time\n",
    "from bs4 import BeautifulSoup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "There repeats zpids:\n",
      "1\n",
      "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n",
      "<html>\n",
      " <body>\n",
      "  <comps:comps xmlns:comps=\"http://www.zillow.com/static/xsd/Comps.xsd\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:schemalocation=\"http://www.zillow.com/static/xsd/Comps.xsd https://www.zillowstatic.com/vstatic/6ce354c/static/xsd/Comps.xsd\">\n",
      "   <request>\n",
      "    <zpid>\n",
      "     49816662\n",
      "    </zpid>\n",
      "    <count>\n",
      "     25\n",
      "    </count>\n",
      "   </request>\n",
      "   <message>\n",
      "    <text>\n",
      "     Request successfully processed\n",
      "    </text>\n",
      "    <code>\n",
      "     0\n",
      "    </code>\n",
      "   </message>\n",
      "   <response>\n",
      "    <properties>\n",
      "     <principal>\n",
      "      <zpid>\n",
      "       49816662\n",
      "      </zpid>\n",
      "      <links>\n",
      "       <homedetails>\n",
      "        https://www.zillow.com/homedetails/4144-Crooked-Stick-Ln-Corona-CA-92883/49816662_zpid/\n",
      "       </homedetails>\n",
      "       <graphsanddata>\n",
      "        http://www.zillow.com/homedetails/4144-Crooked-Stick-Ln-Corona-CA-92883/49816662_zpid/#charts-and-data\n",
      "       </graphsanddata>\n",
      "       <mapthishome>\n",
      "        http://www.zillow.com/homes/49816662_zpid/\n",
      "       </mapthishome>\n",
      "       <comparables>\n",
      "        http://www.zillow.com/homes/comps/49816662_zpid/\n",
      "       </comparables>\n",
      "      </links>\n",
      "      <address>\n",
      "       <street>\n",
      "        4144 Crooked Stick Ln\n",
      "       </street>\n",
      "       <zipcode>\n",
      "        92883\n",
      "       </zipcode>\n",
      "       <city>\n",
      "        Corona\n",
      "       </city>\n",
      "       <state>\n",
      "        CA\n",
      "       </state>\n",
      "       <latitude>\n",
      "        33.816139\n",
      "       </latitude>\n",
      "       <longitude>\n",
      "        -117.528605\n",
      "       </longitude>\n",
      "      </address>\n",
      "      <taxassessmentyear>\n",
      "       2017\n",
      "      </taxassessmentyear>\n",
      "      <taxassessment>\n",
      "       360839.0\n",
      "      </taxassessment>\n",
      "      <yearbuilt>\n",
      "       2000\n",
      "      </yearbuilt>\n",
      "      <lotsizesqft>\n",
      "       7840\n",
      "      </lotsizesqft>\n",
      "      <finishedsqft>\n",
      "       2871\n",
      "      </finishedsqft>\n",
      "      <bathrooms>\n",
      "       3.0\n",
      "      </bathrooms>\n",
      "      <bedrooms>\n",
      "       4\n",
      "      </bedrooms>\n",
      "      <totalrooms>\n",
      "       10\n",
      "      </totalrooms>\n",
      "      <lastsolddate>\n",
      "       02/22/2002\n",
      "      </lastsolddate>\n",
      "      <lastsoldprice currency=\"USD\">\n",
      "       275000\n",
      "      </lastsoldprice>\n",
      "      <zestimate>\n",
      "       <amount currency=\"USD\">\n",
      "        583575\n",
      "       </amount>\n",
      "       <last-updated>\n",
      "        12/01/2017\n",
      "       </last-updated>\n",
      "       <oneweekchange deprecated=\"true\">\n",
      "       </oneweekchange>\n",
      "       <valuechange currency=\"USD\" duration=\"30\">\n",
      "        -69\n",
      "       </valuechange>\n",
      "       <valuationrange>\n",
      "        <low currency=\"USD\">\n",
      "         554396\n",
      "        </low>\n",
      "        <high currency=\"USD\">\n",
      "         612754\n",
      "        </high>\n",
      "       </valuationrange>\n",
      "       <percentile>\n",
      "        87\n",
      "       </percentile>\n",
      "      </zestimate>\n",
      "      <localrealestate>\n",
      "       <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "        <zindexvalue>\n",
      "         562,500\n",
      "        </zindexvalue>\n",
      "        <links>\n",
      "         <overview>\n",
      "          http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "         </overview>\n",
      "         <forsalebyowner>\n",
      "          http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "         </forsalebyowner>\n",
      "         <forsale>\n",
      "          http://www.zillow.com/eagle-glen-corona-ca/\n",
      "         </forsale>\n",
      "        </links>\n",
      "       </region>\n",
      "      </localrealestate>\n",
      "     </principal>\n",
      "     <comparables>\n",
      "      <comp score=\"7.0\">\n",
      "       <zpid>\n",
      "        63150491\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/1680-Tamarron-Dr-Corona-CA-92883/63150491_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/1680-Tamarron-Dr-Corona-CA-92883/63150491_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/63150491_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/63150491_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         1680 Tamarron Dr\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.815321\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.541961\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        500490.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2003\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        10018\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        3584\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.75\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        08/02/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        735000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         737539\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         3348\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          700662\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          774416\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         96\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"3.0\">\n",
      "       <zpid>\n",
      "        54590808\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4370-Leonard-Way-Corona-CA-92883/54590808_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4370-Leonard-Way-Corona-CA-92883/54590808_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/54590808_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/54590808_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4370 Leonard Way\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.811474\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.536837\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        485869.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2001\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        5662\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        2608\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <totalrooms>\n",
      "        9\n",
      "       </totalrooms>\n",
      "       <lastsolddate>\n",
      "        08/28/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        605000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         597461\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         8939\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          567588\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          627334\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         89\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"3.0\">\n",
      "       <zpid>\n",
      "        54954966\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4315-Driving-Range-Rd-Corona-CA-92883/54954966_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4315-Driving-Range-Rd-Corona-CA-92883/54954966_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/54954966_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/54954966_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4315 Driving Range Rd\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.809953\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.532673\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        555900.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2000\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        6098\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        2740\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        2.5\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        10/27/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        620000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         601008\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         -16148\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          570958\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          631058\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         89\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"5.0\">\n",
      "       <zpid>\n",
      "        52470705\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4384-Edenwild-Ln-Corona-CA-92883/52470705_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4384-Edenwild-Ln-Corona-CA-92883/52470705_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/52470705_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/52470705_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4384 Edenwild Ln\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.812329\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.540706\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        550800.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2002\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        10018\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        3670\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.5\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        5\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        10/24/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        625000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         668054\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         -2282\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          634651\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          701457\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         93\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"4.0\">\n",
      "       <zpid>\n",
      "        54954971\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/1843-Couples-Rd-Corona-CA-92883/54954971_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/1843-Couples-Rd-Corona-CA-92883/54954971_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/54954971_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/54954971_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         1843 Couples Rd\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.811015\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.533732\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        443820.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2000\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        5662\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        3076\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        5\n",
      "       </bedrooms>\n",
      "       <totalrooms>\n",
      "        5\n",
      "       </totalrooms>\n",
      "       <lastsolddate>\n",
      "        09/25/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        535000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         567738\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         2313\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          539351\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          596125\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         85\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"4.0\">\n",
      "       <zpid>\n",
      "        52470670\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4360-Edenwild-Ln-Corona-CA-92883/52470670_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4360-Edenwild-Ln-Corona-CA-92883/52470670_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/52470670_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/52470670_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4360 Edenwild Ln\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.813419\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.540335\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        451549.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2001\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        9147\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        2885\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        09/22/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        625000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         632934\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         3964\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          601287\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          664581\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         91\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"6.0\">\n",
      "       <zpid>\n",
      "        52470696\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/1731-Spyglass-Dr-Corona-CA-92883/52470696_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/1731-Spyglass-Dr-Corona-CA-92883/52470696_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/52470696_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/52470696_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         1731 Spyglass Dr\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.814177\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.538301\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        700000.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2001\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        7841\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        3731\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        4.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <totalrooms>\n",
      "        16\n",
      "       </totalrooms>\n",
      "       <lastsolddate>\n",
      "        04/26/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        700000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         716103\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         -13019\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          680298\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          751908\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         95\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"4.0\">\n",
      "       <zpid>\n",
      "        54954979\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/1837-Couples-Rd-Corona-CA-92883/54954979_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/1837-Couples-Rd-Corona-CA-92883/54954979_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/54954979_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/54954979_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         1837 Couples Rd\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.810631\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.533393\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        529000.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2000\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        5227\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        2608\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        2.75\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        05/23/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        520000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         550816\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         6527\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          523275\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          578357\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         83\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"3.0\">\n",
      "       <zpid>\n",
      "        54954965\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4329-Driving-Range-Rd-Corona-CA-92883/54954965_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4329-Driving-Range-Rd-Corona-CA-92883/54954965_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/54954965_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/54954965_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4329 Driving Range Rd\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.809836\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.532799\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        515100.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2000\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        5662\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        2942\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        5\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        03/10/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        563000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         595054\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         -658\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          565301\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          624807\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         88\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"3.0\">\n",
      "       <zpid>\n",
      "        54954952\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4421-Player-Rd-Corona-CA-92883/54954952_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4421-Player-Rd-Corona-CA-92883/54954952_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/54954952_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/54954952_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4421 Player Rd\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.809767\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.535027\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        377486.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2000\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        11326\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        2527\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        04/10/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        614888\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         5457883\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         7763\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          5184989\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          10915766\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         100\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"5.0\">\n",
      "       <zpid>\n",
      "        54954936\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4565-Garden-City-Ln-Corona-CA-92883/54954936_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4565-Garden-City-Ln-Corona-CA-92883/54954936_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/54954936_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/54954936_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4565 Garden City Ln\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.808148\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.535223\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        355342.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2002\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        5227\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        2740\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        01/13/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        502000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         549979\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         4074\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          522480\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          577478\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         83\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"4.0\">\n",
      "       <zpid>\n",
      "        54859929\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4440-Butler-National-Rd-Corona-CA-92883/54859929_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4440-Butler-National-Rd-Corona-CA-92883/54859929_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/54859929_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/54859929_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4440 Butler National Rd\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.809918\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.5345\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        539737.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2000\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        5662\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        2942\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        5\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        01/23/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        529000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         574728\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         -2029\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          545992\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          603464\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         86\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"3.0\">\n",
      "       <zpid>\n",
      "        54859927\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4325-Butler-National-Rd-Corona-CA-92883/54859927_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4325-Butler-National-Rd-Corona-CA-92883/54859927_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/54859927_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/54859927_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4325 Butler National Rd\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.810366\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.533501\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        395965.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2000\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        6969\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        3076\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        5\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        06/30/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        559000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         579676\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         -2828\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          550692\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          608660\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         87\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"4.0\">\n",
      "       <zpid>\n",
      "        54784120\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4405-Leonard-Way-Corona-CA-92883/54784120_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4405-Leonard-Way-Corona-CA-92883/54784120_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/54784120_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/54784120_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4405 Leonard Way\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.810727\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.53627\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        320113.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2001\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        6969\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        2371\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        06/15/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        535000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         554660\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         1969\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          526927\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          582393\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         83\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"4.0\">\n",
      "       <zpid>\n",
      "        54621297\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4386-Driving-Range-Rd-Corona-CA-92883/54621297_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4386-Driving-Range-Rd-Corona-CA-92883/54621297_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/54621297_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/54621297_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4386 Driving Range Rd\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.809559\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.533657\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        532440.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2000\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        5227\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        2954\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        5\n",
      "       </bedrooms>\n",
      "       <totalrooms>\n",
      "        9\n",
      "       </totalrooms>\n",
      "       <lastsolddate>\n",
      "        03/16/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        554000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         585423\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         -539\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          556152\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          614694\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         87\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"6.0\">\n",
      "       <zpid>\n",
      "        54483342\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4365-Leonard-Way-Corona-CA-92883/54483342_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4365-Leonard-Way-Corona-CA-92883/54483342_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/54483342_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/54483342_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4365 Leonard Way\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.811363\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.536296\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        320059.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2001\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        6098\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        2344\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        01/13/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        476000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         525494\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         2962\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          499219\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          551769\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         79\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"3.0\">\n",
      "       <zpid>\n",
      "        53731258\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4399-Driving-Range-Rd-Corona-CA-92883/53731258_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4399-Driving-Range-Rd-Corona-CA-92883/53731258_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/53731258_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/53731258_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4399 Driving Range Rd\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.809219\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.533236\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        486709.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2000\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        5227\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        2740\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        04/03/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        552000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         584960\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         791\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          555712\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          614208\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         87\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"6.0\">\n",
      "       <zpid>\n",
      "        52470672\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4352-Edenwild-Ln-Corona-CA-92883/52470672_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4352-Edenwild-Ln-Corona-CA-92883/52470672_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/52470672_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/52470672_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4352 Edenwild Ln\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.813804\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.540383\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        530263.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2001\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        10018\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        3574\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        2.5\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        06/20/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        693000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         719659\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         2177\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          683676\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          755642\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         95\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"3.0\">\n",
      "       <zpid>\n",
      "        52470667\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4363-Edenwild-Ln-Corona-CA-92883/52470667_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4363-Edenwild-Ln-Corona-CA-92883/52470667_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/52470667_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/52470667_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4363 Edenwild Ln\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.81325\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.539759\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        577000.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2001\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        7405\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        2885\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <totalrooms>\n",
      "        11\n",
      "       </totalrooms>\n",
      "       <lastsolddate>\n",
      "        05/01/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        595000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         626856\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         1696\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          595513\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          658199\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         91\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"4.0\">\n",
      "       <zpid>\n",
      "        54954915\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/1860-Crenshaw-Cir-Corona-CA-92883/54954915_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/1860-Crenshaw-Cir-Corona-CA-92883/54954915_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/54954915_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/54954915_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         1860 Crenshaw Cir\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.808278\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.534938\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        384171.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2000\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        8276\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        2920\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        5\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        09/08/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        640000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         619408\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         -8024\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          588438\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          650378\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         90\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"8.0\">\n",
      "       <zpid>\n",
      "        52470506\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/1731-Flag-Pin-Dr-Corona-CA-92883/52470506_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/1731-Flag-Pin-Dr-Corona-CA-92883/52470506_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/52470506_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/52470506_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         1731 Flag Pin Dr\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.810337\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.540347\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        651288.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2000\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        11038\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        3731\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        4.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        10/17/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        783000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         764266\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         -3685\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          726053\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          802479\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         96\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"2.0\">\n",
      "       <zpid>\n",
      "        52470546\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4202-Havenridge-Dr-Corona-CA-92883/52470546_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4202-Havenridge-Dr-Corona-CA-92883/52470546_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/52470546_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/52470546_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4202 Havenridge Dr\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.813592\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.531041\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        562000.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2001\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        9583\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        2664\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <totalrooms>\n",
      "        10\n",
      "       </totalrooms>\n",
      "       <lastsolddate>\n",
      "        10/17/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        650000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         639243\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         -17760\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          607281\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          671205\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         92\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"5.0\">\n",
      "       <zpid>\n",
      "        54954888\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4570-Garden-City-Ln-6-Corona-CA-92883/54954888_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4570-Garden-City-Ln-6-Corona-CA-92883/54954888_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/54954888_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/54954888_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4570 Garden City Ln # 6\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.807731\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.535677\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        530400.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        1999\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        5662\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        3076\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        02/28/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        525000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         561119\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         -5001\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          533063\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          589175\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         84\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"3.0\">\n",
      "       <zpid>\n",
      "        52470645\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4282-Havenridge-Dr-Corona-CA-92883/52470645_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4282-Havenridge-Dr-Corona-CA-92883/52470645_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/52470645_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/52470645_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4282 Havenridge Dr\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.813046\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.534997\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        535000.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2001\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        9583\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        2427\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        3.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        12/16/2016\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        535000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         575878\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         -1317\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          547084\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          604672\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         86\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "      <comp score=\"3.0\">\n",
      "       <zpid>\n",
      "        52470637\n",
      "       </zpid>\n",
      "       <links>\n",
      "        <homedetails>\n",
      "         https://www.zillow.com/homedetails/4250-Havenridge-Dr-Corona-CA-92883/52470637_zpid/\n",
      "        </homedetails>\n",
      "        <graphsanddata>\n",
      "         http://www.zillow.com/homedetails/4250-Havenridge-Dr-Corona-CA-92883/52470637_zpid/#charts-and-data\n",
      "        </graphsanddata>\n",
      "        <mapthishome>\n",
      "         http://www.zillow.com/homes/52470637_zpid/\n",
      "        </mapthishome>\n",
      "        <comparables>\n",
      "         http://www.zillow.com/homes/comps/52470637_zpid/\n",
      "        </comparables>\n",
      "       </links>\n",
      "       <address>\n",
      "        <street>\n",
      "         4250 Havenridge Dr\n",
      "        </street>\n",
      "        <zipcode>\n",
      "         92883\n",
      "        </zipcode>\n",
      "        <city>\n",
      "         Corona\n",
      "        </city>\n",
      "        <state>\n",
      "         CA\n",
      "        </state>\n",
      "        <latitude>\n",
      "         33.81338\n",
      "        </latitude>\n",
      "        <longitude>\n",
      "         -117.533459\n",
      "        </longitude>\n",
      "       </address>\n",
      "       <taxassessmentyear>\n",
      "        2017\n",
      "       </taxassessmentyear>\n",
      "       <taxassessment>\n",
      "        456511.0\n",
      "       </taxassessment>\n",
      "       <yearbuilt>\n",
      "        2000\n",
      "       </yearbuilt>\n",
      "       <lotsizesqft>\n",
      "        9583\n",
      "       </lotsizesqft>\n",
      "       <finishedsqft>\n",
      "        3446\n",
      "       </finishedsqft>\n",
      "       <bathrooms>\n",
      "        4.0\n",
      "       </bathrooms>\n",
      "       <bedrooms>\n",
      "        4\n",
      "       </bedrooms>\n",
      "       <lastsolddate>\n",
      "        03/24/2017\n",
      "       </lastsolddate>\n",
      "       <lastsoldprice currency=\"USD\">\n",
      "        625000\n",
      "       </lastsoldprice>\n",
      "       <zestimate>\n",
      "        <amount currency=\"USD\">\n",
      "         665387\n",
      "        </amount>\n",
      "        <last-updated>\n",
      "         12/01/2017\n",
      "        </last-updated>\n",
      "        <oneweekchange deprecated=\"true\">\n",
      "        </oneweekchange>\n",
      "        <valuechange currency=\"USD\" duration=\"30\">\n",
      "         38\n",
      "        </valuechange>\n",
      "        <valuationrange>\n",
      "         <low currency=\"USD\">\n",
      "          632118\n",
      "         </low>\n",
      "         <high currency=\"USD\">\n",
      "          698656\n",
      "         </high>\n",
      "        </valuationrange>\n",
      "        <percentile>\n",
      "         93\n",
      "        </percentile>\n",
      "       </zestimate>\n",
      "       <localrealestate>\n",
      "        <region id=\"417705\" name=\"Eagle Glen\" type=\"neighborhood\">\n",
      "         <zindexvalue>\n",
      "          562,500\n",
      "         </zindexvalue>\n",
      "         <links>\n",
      "          <overview>\n",
      "           http://www.zillow.com/local-info/CA-Corona/Eagle-Glen/r_417705/\n",
      "          </overview>\n",
      "          <forsalebyowner>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/fsbo/\n",
      "          </forsalebyowner>\n",
      "          <forsale>\n",
      "           http://www.zillow.com/eagle-glen-corona-ca/\n",
      "          </forsale>\n",
      "         </links>\n",
      "        </region>\n",
      "       </localrealestate>\n",
      "      </comp>\n",
      "     </comparables>\n",
      "    </properties>\n",
      "   </response>\n",
      "  </comps:comps>\n",
      "  <!-- H:009  T:30ms  S:24581  R:Sun Dec 03 12:33:11 PST 2017  B:5.0.50267.8-hotfix_2017-11-28.3ecc3df~hotfix-platform-for-2017-11-28.4b0f42f -->\n",
      " </body>\n",
      "</html>\n"
     ]
    }
   ],
   "source": [
    "ZWSID = \"Enter-your-Zillow-API-Key-Here\"\n",
    "citystatezip = 'Corona+CA'\n",
    "address = \"3398+Braemar+Ln\"\n",
    "allzpid = [\"17766346\",\"17764374\",\"17784702\",\"17883327\",\"2092097213\",\"69282540\",\"52467816\",\"17776098\",\"52466361\",\"17784701\",\"2092411569\",\"17762198\",\"2091899447\",\"2091899446\",\"2091899448\",\"2092575442\",\"52467377\",\"17763538\",\"17783295\",\"63303820\",\"17777843\",\"17784702\",\"52470434\",\"17884332\",\"17777002\",\"17885696\",\"17882840\",\"2099477599\",\"52470252\",\"79832345\",\"49816662\",]\n",
    "zpid = []\n",
    "for z in allzpid:\n",
    "    if z not in zpid:\n",
    "        zpid.append(z)\n",
    "print (\"There repeats zpids:\")\n",
    "print len(allzpid) - len(zpid)\n",
    "count = \"25\"\n",
    "#initialize arrays for..\n",
    "location = []\n",
    "price = []\n",
    "street = []\n",
    "city = []\n",
    "zipcode = []\n",
    "bath = []\n",
    "room = []\n",
    "lotsize = []\n",
    "finsize = []\n",
    "yearbuilt = []\n",
    "rid = []\n",
    "rname = []\n",
    "rtype = []\n",
    "rezpid = []\n",
    "hisurl = []\n",
    "valuech = []\n",
    "\n",
    "for z in zpid:\n",
    "    url = 'http://www.zillow.com/webservice/GetDeepComps.htm?zws-id='+ZWSID+'&zpid='+z+'&count='+count\n",
    "    page = requests.get(url)\n",
    "    tree = page.text\n",
    "    # soup tree for all current values\n",
    "    soup = BeautifulSoup(tree, 'lxml')\n",
    "    prices = soup.find_all('amount')\n",
    "    streets = soup.find_all('street')\n",
    "    cities = soup.find_all('city')\n",
    "    zips = soup.find_all('zipcode')\n",
    "    soup.find_all('bathrooms')\n",
    "    rooms = soup.find_all('bedrooms')\n",
    "    lotsizes = soup.find_all('lotsizesqft')\n",
    "    finsizes = soup.find_all('finishedsqft')\n",
    "    yearbuilts = soup.find_all('yearbuilt')\n",
    "    rids = soup.find_all('region')\n",
    "    zpids = soup.find_all('zpid')\n",
    "    comps = soup.find_all('comp')\n",
    "    for c in comps:\n",
    "        if (c.findChild('lotsizesqft')):\n",
    "            lotsize.append(c.find('lotsizesqft').get_text())\n",
    "        else:\n",
    "            lotsize.append('N/A')\n",
    "    for c in comps:\n",
    "        if (c.findChild('finishedsqft')):\n",
    "            finsize.append(c.find('finishedsqft').get_text())\n",
    "        else:\n",
    "            finsize.append('N/A')\n",
    "    for c in comps:\n",
    "        if (c.findChild('bathrooms')):\n",
    "            bath.append(c.find('bathrooms').get_text())\n",
    "        else:\n",
    "            bath.append('N/A')\n",
    "    for c in comps:\n",
    "        if (c.findChild('yearbuilt')):\n",
    "            yearbuilt.append(c.find('yearbuilt').get_text())\n",
    "        else:\n",
    "            yearbuilt.append('N/A')\n",
    "    for c in comps:\n",
    "        if (c.findChild(\"valuechange\")):\n",
    "            valuech.append(c.find('valuechange').get_text())\n",
    "           \n",
    "    #add soup tree text into arrays\n",
    "    for zp in zpids:\n",
    "        if (zp.parent.name == 'comp'):\n",
    "            rezpid.append(zp.get_text())\n",
    "    for p in prices:\n",
    "        if (p.parent.parent.name == 'comp'):\n",
    "            price.append(p.get_text())\n",
    "    for s in streets:\n",
    "        if (s.parent.parent.name == 'comp'):\n",
    "            street.append(s.get_text())\n",
    "    for c in cities:\n",
    "        if (c.parent.parent.name == 'comp'):\n",
    "            city.append(c.get_text())\n",
    "    for z in zips:\n",
    "        if (z.parent.parent.name == 'comp'):\n",
    "            zipcode.append(z.get_text())\n",
    "    for ro in rooms:\n",
    "        if (ro.parent.name == 'comp'):\n",
    "            room.append(ro.get_text())\n",
    "    for r in rids:\n",
    "        if (r.parent.parent.name == 'comp'):\n",
    "            rid.append(r.get('id'))\n",
    "    for n in rids:\n",
    "        if (n.parent.parent.name == 'comp'):\n",
    "            rname.append(r.get('name'))\n",
    "    for t in rids:\n",
    "        if (t.parent.parent.name == 'comp'):\n",
    "            rtype.append(r.get('type'))\n",
    "\n",
    "\n",
    "\n",
    "#use this code to uniquify all arrays\n",
    "\n",
    "\n",
    "print(soup.prettify())\n",
    "#print(rtype)\n",
    "            \n",
    "scope = ['https://spreadsheets.google.com/feeds']\n",
    "credentials = ServiceAccountCredentials.from_json_keyfile_name('coronaHousingPrices-864beb1e6330.json', scope)\n",
    "gc = gspread.authorize(credentials)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "31\n"
     ]
    }
   ],
   "source": [
    "print(len(allzpid))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "price:\n",
      "626\n",
      "zpid:\n",
      "626\n",
      "street:\n",
      "626\n",
      "city:\n",
      "626\n",
      "zipcode:\n",
      "626\n",
      "bath:\n",
      "626\n",
      "room:\n",
      "626\n",
      "lotsize:\n",
      "626\n",
      "finsize:\n",
      "626\n",
      "yearbuilt:\n",
      "626\n",
      "rname:\n",
      "626\n",
      "rtype:\n",
      "626\n"
     ]
    }
   ],
   "source": [
    "print(\"price:\")\n",
    "print(len(price))\n",
    "print(\"zpid:\")\n",
    "print(len(rezpid))\n",
    "print(\"street:\")\n",
    "print(len(street))\n",
    "print(\"city:\")\n",
    "print(len(city))\n",
    "print(\"zipcode:\")\n",
    "print(len(zipcode))\n",
    "print(\"bath:\")\n",
    "print(len(bath))\n",
    "print(\"room:\")\n",
    "print(len(room))\n",
    "print(\"lotsize:\")\n",
    "print(len(lotsize))\n",
    "print(\"finsize:\")\n",
    "print(len(finsize))\n",
    "print(\"yearbuilt:\")\n",
    "print(len(yearbuilt))\n",
    "print(\"rname:\")\n",
    "print(len(rname))\n",
    "print(\"rtype:\")\n",
    "print(len(rtype))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "google_doc_link = 'https://docs.google.com/spreadsheets/d/1pT64oM4FGVQcGGffjAS8l6fd2YwL4XKxELpEoaMQTwg/edit#gid=0'\n",
    "wks = gc.open_by_url(google_doc_link).worksheet('Sheet1')\n",
    "for i in range(len(rezpid)):\n",
    "    wks.append_row([time.strftime(\"%m/%d/%Y\"), time.strftime(\"%H:%m\"),rezpid[i], street[i], city[i], zipcode[i], price[i], bath[i],room[i],lotsize[i],finsize[i],yearbuilt[i],rid[i],rname[i],rtype[i],valuech[i]])\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}