first.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>FullStreetAddress</th>\n",
       "      <th>Amenities</th>\n",
       "      <th>Appliances</th>\n",
       "      <th>AssessmentYear</th>\n",
       "      <th>Attic</th>\n",
       "      <th>Baths</th>\n",
       "      <th>BathsFull</th>\n",
       "      <th>BathsHalf</th>\n",
       "      <th>Beds</th>\n",
       "      <th>CityName</th>\n",
       "      <th>CloseDate</th>\n",
       "      <th>ClosePrice</th>\n",
       "      <th>ContractDate</th>\n",
       "      <th>County</th>\n",
       "      <th>CountyTax</th>\n",
       "      <th>CountyTaxPaymentFreq</th>\n",
       "      <th>DaysOnMarket</th>\n",
       "      <th>DomProperty</th>\n",
       "      <th>Fireplaces</th>\n",
       "      <th>Foreclosure</th>\n",
       "      <th>Heating</th>\n",
       "      <th>HOA</th>\n",
       "      <th>HotWater</th>\n",
       "      <th>ImprovementAssessmentAmount</th>\n",
       "      <th>ImprovementAssessmentPaymentFreq</th>\n",
       "      <th>InteriorFeatures</th>\n",
       "      <th>LandAssessmentAmount</th>\n",
       "      <th>LandAssessmentPaymentFreq</th>\n",
       "      <th>Stories</th>\n",
       "      <th>ListDate</th>\n",
       "      <th>ListPrice</th>\n",
       "      <th>ListingLowPrice</th>\n",
       "      <th>ListingType</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>ListingID</th>\n",
       "      <th>OriginalListPrice</th>\n",
       "      <th>Ownership</th>\n",
       "      <th>Parking</th>\n",
       "      <th>PropertyType</th>\n",
       "      <th>Remarks</th>\n",
       "      <th>ShowDays</th>\n",
       "      <th>StreetName</th>\n",
       "      <th>StreetNumber</th>\n",
       "      <th>Style</th>\n",
       "      <th>ListingTaxID</th>\n",
       "      <th>TotalAssessment</th>\n",
       "      <th>TotalOpenHouses</th>\n",
       "      <th>TotalShowings</th>\n",
       "      <th>LivingArea</th>\n",
       "      <th>TotalTaxes</th>\n",
       "      <th>TotalTours</th>\n",
       "      <th>Type</th>\n",
       "      <th>YearBuilt</th>\n",
       "      <th>Zip4</th>\n",
       "      <th>PostalCode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3601 5TH ST S #504</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dishwasher, Disposal, Refrigerator, Range Hood...</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-02-22</td>\n",
       "      <td>185000.0</td>\n",
       "      <td>2017-01-15</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>1872.62</td>\n",
       "      <td>Annually</td>\n",
       "      <td>688</td>\n",
       "      <td>688</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Summer / Winter Changeover</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>154100.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Traditional</td>\n",
       "      <td>36400.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2015-02-27</td>\n",
       "      <td>192500.0</td>\n",
       "      <td>192500.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.096760</td>\n",
       "      <td>AR8563022</td>\n",
       "      <td>229000.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Unassigned</td>\n",
       "      <td>Residential</td>\n",
       "      <td>This condo has been thoroughly renovated just ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5TH</td>\n",
       "      <td>3601.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>23-015-111</td>\n",
       "      <td>190500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1011</td>\n",
       "      <td>1897.38</td>\n",
       "      <td>1</td>\n",
       "      <td>Mid-Rise 5-8 Floors</td>\n",
       "      <td>1958</td>\n",
       "      <td>1636.0</td>\n",
       "      <td>22204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1600 OAK ST #1915/1914</td>\n",
       "      <td>Built-in Bookcases, Chair Railing, Crown Moldi...</td>\n",
       "      <td>Cooktop, Dishwasher, Disposal, Dryer, Exhaust ...</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>No</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-02-21</td>\n",
       "      <td>1700000.0</td>\n",
       "      <td>2016-11-16</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>514</td>\n",
       "      <td>514</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Heat Pump(s)</td>\n",
       "      <td>True</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>1648000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>122000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2015-06-22</td>\n",
       "      <td>1850000.0</td>\n",
       "      <td>1850000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.073770</td>\n",
       "      <td>AR8673996</td>\n",
       "      <td>2800000.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>A blend of two homes-3,390 interior sqft. w/mu...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>OAK</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>17-003-291</td>\n",
       "      <td>1770000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3390</td>\n",
       "      <td>17629.00</td>\n",
       "      <td>1</td>\n",
       "      <td>Hi-Rise 9+ Floors</td>\n",
       "      <td>1986</td>\n",
       "      <td>2760.0</td>\n",
       "      <td>22209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1719 GREENBRIER ST</td>\n",
       "      <td>Attic - Finished, Automatic Garage Door Opener...</td>\n",
       "      <td>ENERGY STAR Dishwasher, ENERGY STAR Refrigerat...</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-03-03</td>\n",
       "      <td>1625000.0</td>\n",
       "      <td>2017-01-08</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>7353.82</td>\n",
       "      <td>Annually</td>\n",
       "      <td>489</td>\n",
       "      <td>489</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>ENERGY STAR Heating System, Forced Air, Heat P...</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas, 60 or More Gallon Tank</td>\n",
       "      <td>173100.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>575000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>4</td>\n",
       "      <td>2015-09-08</td>\n",
       "      <td>1695000.0</td>\n",
       "      <td>1695000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.130370</td>\n",
       "      <td>AR8742330</td>\n",
       "      <td>1751000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage, Basement Garage, Drvwy/Off Str, Paved ...</td>\n",
       "      <td>Residential</td>\n",
       "      <td>New Custom Arts and Crafts home by Calvert Hom...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GREENBRIER</td>\n",
       "      <td>1719.0</td>\n",
       "      <td>Arts &amp; Crafts</td>\n",
       "      <td>09-016-016</td>\n",
       "      <td>748100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5994</td>\n",
       "      <td>7451.08</td>\n",
       "      <td>1</td>\n",
       "      <td>Detached</td>\n",
       "      <td>2016</td>\n",
       "      <td>3629.0</td>\n",
       "      <td>22205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3723 FOUR MILE RUN DR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dishwasher, Disposal, Oven / Range - Gas, Refr...</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-01-17</td>\n",
       "      <td>430000.0</td>\n",
       "      <td>2016-12-03</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>3361.86</td>\n",
       "      <td>Annually</td>\n",
       "      <td>121</td>\n",
       "      <td>121</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>152000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>190000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>3</td>\n",
       "      <td>2015-09-20</td>\n",
       "      <td>475000.0</td>\n",
       "      <td>475000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.090230</td>\n",
       "      <td>AR8747453</td>\n",
       "      <td>450000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Street</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Perfect location!  This is your client's oppor...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>FOUR MILE RUN</td>\n",
       "      <td>3723.0</td>\n",
       "      <td>Federal</td>\n",
       "      <td>31-030-066</td>\n",
       "      <td>342000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3406.32</td>\n",
       "      <td>1</td>\n",
       "      <td>Semi-Detached</td>\n",
       "      <td>1945</td>\n",
       "      <td>2332.0</td>\n",
       "      <td>22206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2005 KEY BLVD #11579</td>\n",
       "      <td>Bathroom(s) - Ceramic Tile, Countertop(s) - Gr...</td>\n",
       "      <td>Dishwasher, Disposal, Exhaust Fan, Microwave, ...</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-04-07</td>\n",
       "      <td>362000.0</td>\n",
       "      <td>2017-03-06</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>3386.81</td>\n",
       "      <td>Annually</td>\n",
       "      <td>81</td>\n",
       "      <td>81</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Heat Pump(s), Forced Air</td>\n",
       "      <td>True</td>\n",
       "      <td>Electric</td>\n",
       "      <td>309700.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Traditional</td>\n",
       "      <td>36600.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-12-10</td>\n",
       "      <td>365000.0</td>\n",
       "      <td>365000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.083800</td>\n",
       "      <td>AR9823220</td>\n",
       "      <td>369000.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Street</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Fully updated 2BR/1BA corner unit in Colonial ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KEY</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>Rambler</td>\n",
       "      <td>16-026-213</td>\n",
       "      <td>346300</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>852</td>\n",
       "      <td>3431.80</td>\n",
       "      <td>0</td>\n",
       "      <td>Garden 1-4 Floors</td>\n",
       "      <td>1940</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1719 GLEBE RD N</td>\n",
       "      <td>Fireplace Mantel(s), Countertop(s) - Granite, ...</td>\n",
       "      <td>Dishwasher, Disposal, Dryer, Exhaust Fan, Icem...</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-04-28</td>\n",
       "      <td>760000.0</td>\n",
       "      <td>2017-03-25</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>7480.72</td>\n",
       "      <td>Annually</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Radiator</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>288700.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Traditional</td>\n",
       "      <td>476200.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>3</td>\n",
       "      <td>2017-03-09</td>\n",
       "      <td>765000.0</td>\n",
       "      <td>765000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.119080</td>\n",
       "      <td>AR9882001</td>\n",
       "      <td>765000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage, Drvwy/Off Str</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Stylish, high end renovations of Georgetown st...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>GLEBE</td>\n",
       "      <td>1719.0</td>\n",
       "      <td>Colonial</td>\n",
       "      <td>07-025-004</td>\n",
       "      <td>764900</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1854</td>\n",
       "      <td>7580.14</td>\n",
       "      <td>1</td>\n",
       "      <td>Detached</td>\n",
       "      <td>1937</td>\n",
       "      <td>2037.0</td>\n",
       "      <td>22207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1400 KENMORE ST</td>\n",
       "      <td>Attic - Floored, Attic - Stairs Fixed, Attic -...</td>\n",
       "      <td>Dishwasher, Disposal, Dryer, Extra Refrigerato...</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-04-07</td>\n",
       "      <td>930000.0</td>\n",
       "      <td>2017-03-15</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>7869.97</td>\n",
       "      <td>Annually</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Wall Unit, Radiator</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>192700.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>NaN</td>\n",
       "      <td>612000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>3</td>\n",
       "      <td>2017-03-07</td>\n",
       "      <td>899000.0</td>\n",
       "      <td>899000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.102050</td>\n",
       "      <td>AR9881038</td>\n",
       "      <td>899000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Drvwy/Off Str, Garage, Paved Driveway, Asphalt...</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Fabulous location! Near Clarendon, Vir. Sq. &amp; ...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>KENMORE</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>Traditional</td>\n",
       "      <td>15-039-029</td>\n",
       "      <td>804700</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>7974.56</td>\n",
       "      <td>2</td>\n",
       "      <td>Detached</td>\n",
       "      <td>1942</td>\n",
       "      <td>4912.0</td>\n",
       "      <td>22201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1800 WILSON BLVD #222</td>\n",
       "      <td>Automatic Garage Door Opener, Elevator, Closet...</td>\n",
       "      <td>Dishwasher, Disposal, Exhaust Fan, Icemaker, M...</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-05-10</td>\n",
       "      <td>392000.0</td>\n",
       "      <td>2017-04-03</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>3576.55</td>\n",
       "      <td>Annually</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>326200.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>39500.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2017-03-24</td>\n",
       "      <td>399900.0</td>\n",
       "      <td>399900.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.079100</td>\n",
       "      <td>AR9895940</td>\n",
       "      <td>399900.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Assigned, Covered Parking, Garage, Prk Space C...</td>\n",
       "      <td>Residential</td>\n",
       "      <td>When this condo was built, AHC purchased sever...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>WILSON</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>17-010-138</td>\n",
       "      <td>365700</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>718</td>\n",
       "      <td>3624.08</td>\n",
       "      <td>3</td>\n",
       "      <td>Garden 1-4 Floors</td>\n",
       "      <td>2007</td>\n",
       "      <td>6604.0</td>\n",
       "      <td>22201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4195 FOUR MILE RUN DR S #201</td>\n",
       "      <td>Closet - Master Bedroom Walk-in, Countertop(s)...</td>\n",
       "      <td>Dishwasher, Disposal, Dryer, Refrigerator, Ice...</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-06-29</td>\n",
       "      <td>313000.0</td>\n",
       "      <td>2017-05-26</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>3009.31</td>\n",
       "      <td>Annually</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Electric</td>\n",
       "      <td>273700.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>34000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2017-05-09</td>\n",
       "      <td>313000.0</td>\n",
       "      <td>313000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.097465</td>\n",
       "      <td>AR9941117</td>\n",
       "      <td>316000.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Unassigned, Surface</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Sunny, pristine condo at West Village of Shirl...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>FOUR MILE RUN</td>\n",
       "      <td>4195.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>27-007-579</td>\n",
       "      <td>307700</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>851</td>\n",
       "      <td>3049.30</td>\n",
       "      <td>2</td>\n",
       "      <td>Garden 1-4 Floors</td>\n",
       "      <td>1966</td>\n",
       "      <td>3986.0</td>\n",
       "      <td>22204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>6961 FAIRFAX DR</td>\n",
       "      <td>Bathroom(s) - Ceramic Tile, Closet - Master Be...</td>\n",
       "      <td>Central Vacuum, Dishwasher, Disposal, Dryer, M...</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-08-04</td>\n",
       "      <td>639000.0</td>\n",
       "      <td>2017-07-12</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>5522.77</td>\n",
       "      <td>Annually</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Programmable Thermostat, Zoned</td>\n",
       "      <td>False</td>\n",
       "      <td>Electric</td>\n",
       "      <td>204700.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>NaN</td>\n",
       "      <td>360000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>3</td>\n",
       "      <td>2017-07-05</td>\n",
       "      <td>642144.0</td>\n",
       "      <td>642144.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.167080</td>\n",
       "      <td>AR9988772</td>\n",
       "      <td>642144.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Beautiful 3 BR, 3 BA End unit townhouse in Bro...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>FAIRFAX</td>\n",
       "      <td>6961.0</td>\n",
       "      <td>Traditional</td>\n",
       "      <td>01-010-041</td>\n",
       "      <td>564700</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5596.16</td>\n",
       "      <td>1</td>\n",
       "      <td>Townhouse</td>\n",
       "      <td>1988</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>22213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2200 WESTMORELAND ST N #420</td>\n",
       "      <td>Attached Master Bathroom, Closet - Master Bedr...</td>\n",
       "      <td>Dishwasher, Dryer - Front Loading, Icemaker, M...</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>No</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-10-09</td>\n",
       "      <td>565000.0</td>\n",
       "      <td>2017-09-27</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>440100.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>52700.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>565000.0</td>\n",
       "      <td>565000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.162653</td>\n",
       "      <td>AR9010756</td>\n",
       "      <td>574900.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Assigned</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Spectacular 2 BR &amp; DEN /2 BA in sought after W...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>WESTMORELAND</td>\n",
       "      <td>2200.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>11-011-118</td>\n",
       "      <td>492800</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1172</td>\n",
       "      <td>4883.64</td>\n",
       "      <td>2</td>\n",
       "      <td>Mid-Rise 5-8 Floors</td>\n",
       "      <td>2006</td>\n",
       "      <td>1051.0</td>\n",
       "      <td>22213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>832 GREENBRIER ST S #1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-03-23</td>\n",
       "      <td>140000.0</td>\n",
       "      <td>2017-02-23</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>1138.31</td>\n",
       "      <td>Annually</td>\n",
       "      <td>407</td>\n",
       "      <td>407</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Radiator</td>\n",
       "      <td>True</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>91500.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Flat</td>\n",
       "      <td>24300.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2015-10-20</td>\n",
       "      <td>150000.0</td>\n",
       "      <td>150000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.119080</td>\n",
       "      <td>AR9501967</td>\n",
       "      <td>180000.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Assigned, Surface</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Price reduced for quick sell.Contract failed d...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>GREENBRIER</td>\n",
       "      <td>832.0</td>\n",
       "      <td>Other</td>\n",
       "      <td>22-011-212</td>\n",
       "      <td>115800</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>695</td>\n",
       "      <td>1153.37</td>\n",
       "      <td>1</td>\n",
       "      <td>Garden 1-4 Floors</td>\n",
       "      <td>1948</td>\n",
       "      <td>2712.0</td>\n",
       "      <td>22204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2704 BUCHANAN ST N</td>\n",
       "      <td>Attached Master Bathroom, Attic - Stairs Pull ...</td>\n",
       "      <td>Dishwasher, Disposal, Humidifier, Icemaker, Mi...</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-07-21</td>\n",
       "      <td>1999900.0</td>\n",
       "      <td>2016-01-06</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>6494.68</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas, 60 or More Gallon Tank</td>\n",
       "      <td>142000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>518700.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>3</td>\n",
       "      <td>2016-01-05</td>\n",
       "      <td>1999900.0</td>\n",
       "      <td>1999900.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.129570</td>\n",
       "      <td>AR9546034</td>\n",
       "      <td>1999900.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage, Drvwy/Off Str</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Fabulous new design by Arlington's premier bui...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>BUCHANAN</td>\n",
       "      <td>2704.0</td>\n",
       "      <td>Colonial</td>\n",
       "      <td>02-088-046</td>\n",
       "      <td>660700</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6305</td>\n",
       "      <td>6580.57</td>\n",
       "      <td>0</td>\n",
       "      <td>Detached</td>\n",
       "      <td>2017</td>\n",
       "      <td>2725.0</td>\n",
       "      <td>22207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>28 S PERSHING DR</td>\n",
       "      <td>Attic - Stairs Pull Down, Automatic Garage Doo...</td>\n",
       "      <td>Dishwasher, Disposal, Dryer, Exhaust Fan, Icem...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-02-17</td>\n",
       "      <td>487500.0</td>\n",
       "      <td>2016-08-01</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>413</td>\n",
       "      <td>632</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air, Heat Pump(s), Zoned</td>\n",
       "      <td>False</td>\n",
       "      <td>60 or More Gallon Tank, Natural Gas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2016-01-18</td>\n",
       "      <td>979000.0</td>\n",
       "      <td>979000.0</td>\n",
       "      <td>Excl. Agency</td>\n",
       "      <td>-77.110890</td>\n",
       "      <td>AR9555136</td>\n",
       "      <td>999000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Drvwy/Off Str, Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>This is an MLS Placement Limited Service Listi...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>S PERSHING</td>\n",
       "      <td>28.0</td>\n",
       "      <td>Craftsman</td>\n",
       "      <td>23-004-026</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>Detached</td>\n",
       "      <td>2016</td>\n",
       "      <td>1356.0</td>\n",
       "      <td>22204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1001 VERMONT ST #614</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dishwasher, Disposal, Microwave, Oven / Range ...</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-01-30</td>\n",
       "      <td>410000.0</td>\n",
       "      <td>2016-12-21</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>4141.38</td>\n",
       "      <td>Annually</td>\n",
       "      <td>300</td>\n",
       "      <td>300</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Heat Pump(s)</td>\n",
       "      <td>False</td>\n",
       "      <td>Electric</td>\n",
       "      <td>388700.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Traditional</td>\n",
       "      <td>32600.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-02-24</td>\n",
       "      <td>419999.0</td>\n",
       "      <td>419999.0</td>\n",
       "      <td>Excl. Agency</td>\n",
       "      <td>-77.114370</td>\n",
       "      <td>AR9578263</td>\n",
       "      <td>435000.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Underground</td>\n",
       "      <td>Residential</td>\n",
       "      <td>LUXURY 2 BR condo in the heart of Ballston!  F...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>VERMONT</td>\n",
       "      <td>1001.0</td>\n",
       "      <td>Traditional</td>\n",
       "      <td>14-017-152</td>\n",
       "      <td>421300</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>814</td>\n",
       "      <td>4196.15</td>\n",
       "      <td>1</td>\n",
       "      <td>Hi-Rise 9+ Floors</td>\n",
       "      <td>2005</td>\n",
       "      <td>4766.0</td>\n",
       "      <td>22201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>6318 31ST ST N</td>\n",
       "      <td>Attic - Finished, Automatic Garage Door Opener...</td>\n",
       "      <td>Dishwasher, Disposal, Exhaust Fan, Icemaker, M...</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-08-08</td>\n",
       "      <td>1729000.0</td>\n",
       "      <td>2016-05-10</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>69</td>\n",
       "      <td>145</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air, Wood Burning Stove, Zoned</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>105200.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>545000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>4</td>\n",
       "      <td>2016-03-03</td>\n",
       "      <td>1749000.0</td>\n",
       "      <td>1749000.0</td>\n",
       "      <td>Modified/Excl</td>\n",
       "      <td>-77.155344</td>\n",
       "      <td>AR9585142</td>\n",
       "      <td>1749000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Looking for new construction but tired of the ...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>31ST</td>\n",
       "      <td>6318.0</td>\n",
       "      <td>Farm House</td>\n",
       "      <td>01-021-002</td>\n",
       "      <td>650200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5500</td>\n",
       "      <td>6475.99</td>\n",
       "      <td>1</td>\n",
       "      <td>Detached</td>\n",
       "      <td>2015</td>\n",
       "      <td>1123.0</td>\n",
       "      <td>22207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>664 29TH RD S</td>\n",
       "      <td>Attic - Access Only, Automatic Garage Door Ope...</td>\n",
       "      <td>Cooktop, Dishwasher, Disposal, Dryer - Front L...</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-02-16</td>\n",
       "      <td>1149000.0</td>\n",
       "      <td>2017-01-11</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>9551.81</td>\n",
       "      <td>Annually</td>\n",
       "      <td>202</td>\n",
       "      <td>202</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air, Heat Pump(s)</td>\n",
       "      <td>False</td>\n",
       "      <td>60 or More Gallon Tank, Natural Gas</td>\n",
       "      <td>595800.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>427500.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>3</td>\n",
       "      <td>2016-03-24</td>\n",
       "      <td>1149900.0</td>\n",
       "      <td>1149900.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.056092</td>\n",
       "      <td>AR9605099</td>\n",
       "      <td>1269000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Drvwy/Off Str, Garage, Paved Driveway, Street,...</td>\n",
       "      <td>Residential</td>\n",
       "      <td>MASSIVE PRICE DROP ~ This hard-to-find Arlingt...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>29TH</td>\n",
       "      <td>664.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>37-027-040</td>\n",
       "      <td>1023300</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3493</td>\n",
       "      <td>9678.13</td>\n",
       "      <td>1</td>\n",
       "      <td>Detached</td>\n",
       "      <td>1990</td>\n",
       "      <td>2315.0</td>\n",
       "      <td>22202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2004 CULPEPER ST N</td>\n",
       "      <td>Automatic Garage Door Opener, Bathroom(s) - Ce...</td>\n",
       "      <td>Dishwasher, Cooktop, Disposal, Dryer, Dryer - ...</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>No</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-01-05</td>\n",
       "      <td>1050000.0</td>\n",
       "      <td>2016-11-16</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>10517.12</td>\n",
       "      <td>Annually</td>\n",
       "      <td>224</td>\n",
       "      <td>224</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Electric, Natural Gas</td>\n",
       "      <td>609900.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>NaN</td>\n",
       "      <td>460000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>4</td>\n",
       "      <td>2016-04-03</td>\n",
       "      <td>1099000.0</td>\n",
       "      <td>1099000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.126214</td>\n",
       "      <td>AR9615310</td>\n",
       "      <td>1199888.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>***OWNER SAYS SELL***BRING ALL OFFERS***1 Mile...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>CULPEPER</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Arts &amp; Crafts</td>\n",
       "      <td>08-011-032</td>\n",
       "      <td>1069900</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6550</td>\n",
       "      <td>10656.20</td>\n",
       "      <td>2</td>\n",
       "      <td>Detached</td>\n",
       "      <td>2008</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>22207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1309 S. QUINN ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ENERGY STAR Dishwasher, ENERGY STAR Refrigerat...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-02-24</td>\n",
       "      <td>740285.0</td>\n",
       "      <td>2016-06-10</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>ENERGY STAR Heating System</td>\n",
       "      <td>True</td>\n",
       "      <td>Instant Hot Water, Tankless Water Heater</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>2016-04-06</td>\n",
       "      <td>740285.0</td>\n",
       "      <td>740285.0</td>\n",
       "      <td>Excl. Agency</td>\n",
       "      <td>-77.073900</td>\n",
       "      <td>AR9618603</td>\n",
       "      <td>724900.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage, Garage Door Opener, Paved Driveway</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Introducing Carver Place, an exciting new cons...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>S. QUINN</td>\n",
       "      <td>1309.0</td>\n",
       "      <td>Craftsman</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2080</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>Townhouse</td>\n",
       "      <td>2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2834 SOMERSET ST N</td>\n",
       "      <td>Attached Master Bathroom, Attic - Stairs Pull ...</td>\n",
       "      <td>Dishwasher, Disposal</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-05-23</td>\n",
       "      <td>1635000.0</td>\n",
       "      <td>2017-04-03</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>355</td>\n",
       "      <td>355</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>770700.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>688800.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>3</td>\n",
       "      <td>2016-04-13</td>\n",
       "      <td>1649900.0</td>\n",
       "      <td>1649900.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.158123</td>\n",
       "      <td>AR9625262</td>\n",
       "      <td>1699000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Move in ready! Modern Craftsman on 1/3 acre at...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SOMERSET</td>\n",
       "      <td>2834.0</td>\n",
       "      <td>Craftsman</td>\n",
       "      <td>01-019-030</td>\n",
       "      <td>1459500</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5035</td>\n",
       "      <td>7662.38</td>\n",
       "      <td>3</td>\n",
       "      <td>Detached</td>\n",
       "      <td>2016</td>\n",
       "      <td>1219.0</td>\n",
       "      <td>22213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2408 1ST RD S</td>\n",
       "      <td>Closet(s) - Walk-in, Countertop(s) - Granite, ...</td>\n",
       "      <td>Central Vacuum, Dishwasher, Disposal, Dryer, I...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-02-06</td>\n",
       "      <td>1187000.0</td>\n",
       "      <td>2016-12-29</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>261</td>\n",
       "      <td>261</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Heat Pump(s)</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>2016-04-12</td>\n",
       "      <td>1249888.0</td>\n",
       "      <td>1249888.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.085140</td>\n",
       "      <td>AR9624755</td>\n",
       "      <td>1349888.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Paved Driveway</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Ultra Luxurious custom home in the heart of Ar...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1ST</td>\n",
       "      <td>2408.0</td>\n",
       "      <td>Craftsman</td>\n",
       "      <td>24-005-007</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3977</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>Detached</td>\n",
       "      <td>2016</td>\n",
       "      <td>1823.0</td>\n",
       "      <td>22204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>4141 HENDERSON RD #814</td>\n",
       "      <td>Closet(s) - Walk-in, Countertop(s) - Granite, ...</td>\n",
       "      <td>Dishwasher, Refrigerator, Oven / Range - Gas</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-01-31</td>\n",
       "      <td>244000.0</td>\n",
       "      <td>2016-12-17</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2407.37</td>\n",
       "      <td>Annually</td>\n",
       "      <td>249</td>\n",
       "      <td>249</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Central</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>223200.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Efficiency</td>\n",
       "      <td>21700.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-04-13</td>\n",
       "      <td>249900.0</td>\n",
       "      <td>249900.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.109480</td>\n",
       "      <td>AR9625903</td>\n",
       "      <td>249900.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>On-site Prk/Rent</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Enjoy Beautiful Sunset from your balcony,Or wa...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>HENDERSON</td>\n",
       "      <td>4141.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>20-012-223</td>\n",
       "      <td>244900</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>542</td>\n",
       "      <td>2439.20</td>\n",
       "      <td>1</td>\n",
       "      <td>Hi-Rise 9+ Floors</td>\n",
       "      <td>1973</td>\n",
       "      <td>2467.0</td>\n",
       "      <td>22203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>4118 27TH RD N</td>\n",
       "      <td>Attached Master Bathroom, Automatic Garage Doo...</td>\n",
       "      <td>Dishwasher, Disposal, Dryer, Microwave, Oven -...</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-02-10</td>\n",
       "      <td>950000.0</td>\n",
       "      <td>2017-01-10</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>8340.76</td>\n",
       "      <td>Annually</td>\n",
       "      <td>229</td>\n",
       "      <td>229</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>258500.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Traditional</td>\n",
       "      <td>590000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>2</td>\n",
       "      <td>2016-04-16</td>\n",
       "      <td>929000.0</td>\n",
       "      <td>929000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.112880</td>\n",
       "      <td>AR9629124</td>\n",
       "      <td>995000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Drvwy/Off Str, Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Schedule showings online through showingtime. ...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>27TH</td>\n",
       "      <td>4118.0</td>\n",
       "      <td>Split Foyer</td>\n",
       "      <td>05-001-027</td>\n",
       "      <td>848500</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2349</td>\n",
       "      <td>8451.06</td>\n",
       "      <td>3</td>\n",
       "      <td>Detached</td>\n",
       "      <td>1965</td>\n",
       "      <td>5116.0</td>\n",
       "      <td>22207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>412 GARFIELD ST N</td>\n",
       "      <td>Automatic Garage Door Opener, Chair Railing, C...</td>\n",
       "      <td>Cooktop, Dishwasher, Disposal, Dryer, Microwav...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-03-31</td>\n",
       "      <td>1735000.0</td>\n",
       "      <td>2017-01-23</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>262</td>\n",
       "      <td>262</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>2016-05-06</td>\n",
       "      <td>1888000.0</td>\n",
       "      <td>1888000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.093210</td>\n",
       "      <td>AR9631923</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Exotic-European Flair &amp; Noble Ambiance! Luxury...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GARFIELD</td>\n",
       "      <td>412.0</td>\n",
       "      <td>Colonial</td>\n",
       "      <td>18-049-013</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5750</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>Detached</td>\n",
       "      <td>2005</td>\n",
       "      <td>1610.0</td>\n",
       "      <td>22201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1319 S. QUINN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ENERGY STAR Dishwasher, ENERGY STAR Refrigerat...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-02-27</td>\n",
       "      <td>877015.0</td>\n",
       "      <td>2016-05-19</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>ENERGY STAR Heating System</td>\n",
       "      <td>True</td>\n",
       "      <td>Instant Hot Water, Tankless Water Heater</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>2016-04-21</td>\n",
       "      <td>829900.0</td>\n",
       "      <td>829900.0</td>\n",
       "      <td>Excl. Agency</td>\n",
       "      <td>-77.072590</td>\n",
       "      <td>AR9634927</td>\n",
       "      <td>819900.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage, Garage Door Opener, Paved Driveway</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Home is currently under construction. End Unit...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>S. QUINN</td>\n",
       "      <td>1319.0</td>\n",
       "      <td>Craftsman</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2580</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>Townhouse</td>\n",
       "      <td>2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>900 TAYLOR ST #1527</td>\n",
       "      <td>Master Bedroom - Full Bathroom, Attached Maste...</td>\n",
       "      <td>Dishwasher, Disposal, Dryer, Dryer - Front Loa...</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>No</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-04-28</td>\n",
       "      <td>195000.0</td>\n",
       "      <td>2017-04-10</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>1311.32</td>\n",
       "      <td>Annually</td>\n",
       "      <td>350</td>\n",
       "      <td>350</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Central</td>\n",
       "      <td>False</td>\n",
       "      <td>Electric</td>\n",
       "      <td>95000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>38400.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-04-26</td>\n",
       "      <td>240000.0</td>\n",
       "      <td>240000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.112836</td>\n",
       "      <td>AR9639067</td>\n",
       "      <td>270000.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Parking Fee</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Please notice this is a Retirement Community. ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TAYLOR</td>\n",
       "      <td>900.0</td>\n",
       "      <td>Traditional</td>\n",
       "      <td>14-051-227</td>\n",
       "      <td>133400</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>960</td>\n",
       "      <td>1328.66</td>\n",
       "      <td>2</td>\n",
       "      <td>Hi-Rise 9+ Floors</td>\n",
       "      <td>1992</td>\n",
       "      <td>1890.0</td>\n",
       "      <td>22203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1715 13TH ROAD S.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ENERGY STAR Dishwasher, ENERGY STAR Refrigerat...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-03-28</td>\n",
       "      <td>835970.0</td>\n",
       "      <td>2016-05-25</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>ENERGY STAR Heating System</td>\n",
       "      <td>True</td>\n",
       "      <td>Instant Hot Water, Tankless Water Heater</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>2016-05-03</td>\n",
       "      <td>809900.0</td>\n",
       "      <td>809900.0</td>\n",
       "      <td>Excl. Agency</td>\n",
       "      <td>-77.073290</td>\n",
       "      <td>AR9646368</td>\n",
       "      <td>809900.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage, Garage Door Opener, Paved Driveway</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Home is currently under construction. 2580 sq ...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>13TH ROAD S.</td>\n",
       "      <td>1715.0</td>\n",
       "      <td>Craftsman</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2580</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>Townhouse</td>\n",
       "      <td>2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>4366 PERSHING DR #43662</td>\n",
       "      <td>Wood Floors</td>\n",
       "      <td>Dishwasher, Disposal, Microwave, Refrigerator,...</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-02-17</td>\n",
       "      <td>260000.0</td>\n",
       "      <td>2017-01-29</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2588.24</td>\n",
       "      <td>Annually</td>\n",
       "      <td>263</td>\n",
       "      <td>263</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Radiator</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>210900.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Traditional</td>\n",
       "      <td>52400.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-05-11</td>\n",
       "      <td>274900.0</td>\n",
       "      <td>274900.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.108866</td>\n",
       "      <td>AR9654407</td>\n",
       "      <td>315000.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Permit Required, Unassigned, Surface</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Please see documents for disclosures &amp; conveya...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PERSHING</td>\n",
       "      <td>4366.0</td>\n",
       "      <td>Colonial</td>\n",
       "      <td>20-026-360</td>\n",
       "      <td>263300</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>936</td>\n",
       "      <td>2622.47</td>\n",
       "      <td>1</td>\n",
       "      <td>Garden 1-4 Floors</td>\n",
       "      <td>1940</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2907 KENSINGTON ST N</td>\n",
       "      <td>Attic - Finished, Closet - Master Bedroom Walk...</td>\n",
       "      <td>Dishwasher, Disposal, Dryer, Exhaust Fan, Icem...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-03-31</td>\n",
       "      <td>2186500.0</td>\n",
       "      <td>2017-02-04</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>263</td>\n",
       "      <td>263</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>2016-05-18</td>\n",
       "      <td>2295000.0</td>\n",
       "      <td>2295000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.145620</td>\n",
       "      <td>AR9661083</td>\n",
       "      <td>2295000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Completed in March '17. A frame design on one ...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>KENSINGTON</td>\n",
       "      <td>2907.0</td>\n",
       "      <td>A-Frame</td>\n",
       "      <td>000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7078</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>Detached</td>\n",
       "      <td>2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>900 TAYLOR ST #1420</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>No</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-02-28</td>\n",
       "      <td>249000.0</td>\n",
       "      <td>2016-12-22</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>1586.56</td>\n",
       "      <td>Annually</td>\n",
       "      <td>172</td>\n",
       "      <td>264</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Central</td>\n",
       "      <td>False</td>\n",
       "      <td>Electric</td>\n",
       "      <td>122200.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>39200.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-06-02</td>\n",
       "      <td>249999.0</td>\n",
       "      <td>249999.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.112643</td>\n",
       "      <td>AR9675673</td>\n",
       "      <td>275000.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Parking Fee</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Monthly Service Fee of $3,170.00 is not option...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TAYLOR</td>\n",
       "      <td>900.0</td>\n",
       "      <td>Traditional</td>\n",
       "      <td>14-051-201</td>\n",
       "      <td>161400</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>981</td>\n",
       "      <td>1607.54</td>\n",
       "      <td>1</td>\n",
       "      <td>Hi-Rise 9+ Floors</td>\n",
       "      <td>1992</td>\n",
       "      <td>1873.0</td>\n",
       "      <td>22203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3054</th>\n",
       "      <td>1311 Quinn ST S</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-02-23</td>\n",
       "      <td>751955.0</td>\n",
       "      <td>2016-12-30</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Central</td>\n",
       "      <td>True</td>\n",
       "      <td>Electric</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>2016-12-30</td>\n",
       "      <td>751955.0</td>\n",
       "      <td>751955.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.072630</td>\n",
       "      <td>AR10117538</td>\n",
       "      <td>751955.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Comp purposes only</td>\n",
       "      <td>NaN</td>\n",
       "      <td>QUINN</td>\n",
       "      <td>1311.0</td>\n",
       "      <td>Arts &amp; Crafts</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Townhouse</td>\n",
       "      <td>2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3055</th>\n",
       "      <td>4360 LEE HWY #203</td>\n",
       "      <td>Bathroom(s) - Ceramic Tile, Built-in Bookcases...</td>\n",
       "      <td>Dishwasher, Disposal, Exhaust Fan, Oven / Rang...</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>No</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-12-29</td>\n",
       "      <td>330000.0</td>\n",
       "      <td>2017-12-17</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2677.76</td>\n",
       "      <td>Annually</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>True</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>240000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>33800.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2017-12-14</td>\n",
       "      <td>324900.0</td>\n",
       "      <td>324900.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.115720</td>\n",
       "      <td>AR10118991</td>\n",
       "      <td>324900.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Assigned</td>\n",
       "      <td>Residential</td>\n",
       "      <td>MULTIPLE OFFERS RECEIVED - SUNDAY OPEN HOUSE C...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>LEE</td>\n",
       "      <td>4360.0</td>\n",
       "      <td>Other</td>\n",
       "      <td>07-012-048</td>\n",
       "      <td>273800</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>938</td>\n",
       "      <td>2713.34</td>\n",
       "      <td>2</td>\n",
       "      <td>Garden 1-4 Floors</td>\n",
       "      <td>1964</td>\n",
       "      <td>3231.0</td>\n",
       "      <td>22207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3056</th>\n",
       "      <td>117 FILLMORE ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>No</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-12-12</td>\n",
       "      <td>960000.0</td>\n",
       "      <td>2017-12-12</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>220</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>688700.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>410800.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>3</td>\n",
       "      <td>2017-12-12</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.088390</td>\n",
       "      <td>AR10119050</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>**Sun Filled Custom Built Home**Minutes to Was...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>FILLMORE</td>\n",
       "      <td>117.0</td>\n",
       "      <td>Colonial</td>\n",
       "      <td>24-001-131</td>\n",
       "      <td>1099500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4326</td>\n",
       "      <td>10896.02</td>\n",
       "      <td>1</td>\n",
       "      <td>Detached</td>\n",
       "      <td>2006</td>\n",
       "      <td>1838.0</td>\n",
       "      <td>22204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3057</th>\n",
       "      <td>1633 BARTON ST #12</td>\n",
       "      <td>Bathroom(s) - Ceramic Tile, Bedroom - Entry Le...</td>\n",
       "      <td>Dishwasher, Microwave, Oven / Range - Electric...</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>No</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-12-30</td>\n",
       "      <td>379900.0</td>\n",
       "      <td>2017-12-29</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Heat Pump(s)</td>\n",
       "      <td>True</td>\n",
       "      <td>Electric</td>\n",
       "      <td>362000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Other</td>\n",
       "      <td>44800.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2017-12-14</td>\n",
       "      <td>389900.0</td>\n",
       "      <td>389900.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.081490</td>\n",
       "      <td>AR10120026</td>\n",
       "      <td>409900.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Assigned</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Contact ShowingTime at 800-746-9464. Direct al...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BARTON</td>\n",
       "      <td>1633.0</td>\n",
       "      <td>Other</td>\n",
       "      <td>32-001-618</td>\n",
       "      <td>406800</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1120</td>\n",
       "      <td>4031.38</td>\n",
       "      <td>1</td>\n",
       "      <td>Garden 1-4 Floors</td>\n",
       "      <td>1985</td>\n",
       "      <td>4856.0</td>\n",
       "      <td>22204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3058</th>\n",
       "      <td>1418 RHODES ST #B412</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>No</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-12-15</td>\n",
       "      <td>950000.0</td>\n",
       "      <td>2017-12-15</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>7921.80</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>716100.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>93900.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>2</td>\n",
       "      <td>2017-12-15</td>\n",
       "      <td>950000.0</td>\n",
       "      <td>950000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.079370</td>\n",
       "      <td>AR10120801</td>\n",
       "      <td>950000.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Bright 2 bed 2.5 bath Unit Only blocks to shop...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RHODES</td>\n",
       "      <td>1418.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>17-023-090</td>\n",
       "      <td>810000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1878</td>\n",
       "      <td>8027.10</td>\n",
       "      <td>0</td>\n",
       "      <td>Garden 1-4 Floors</td>\n",
       "      <td>2010</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3059</th>\n",
       "      <td>3600 GLEBE RD S #621W</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>No</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-02-24</td>\n",
       "      <td>473000.0</td>\n",
       "      <td>2017-02-14</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>4465.55</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Central</td>\n",
       "      <td>True</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>389200.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>67400.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-02-14</td>\n",
       "      <td>485000.0</td>\n",
       "      <td>485000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.051547</td>\n",
       "      <td>AR10121715</td>\n",
       "      <td>485000.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Comp Purposes Only.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GLEBE</td>\n",
       "      <td>3600.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>34-027-243</td>\n",
       "      <td>456600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1123</td>\n",
       "      <td>4524.88</td>\n",
       "      <td>0</td>\n",
       "      <td>Hi-Rise 9+ Floors</td>\n",
       "      <td>2006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3060</th>\n",
       "      <td>3546 UTAH ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-12-18</td>\n",
       "      <td>865000.0</td>\n",
       "      <td>2017-12-18</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>7236.22</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Central</td>\n",
       "      <td>False</td>\n",
       "      <td>Electric</td>\n",
       "      <td>129900.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>NaN</td>\n",
       "      <td>610000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>2</td>\n",
       "      <td>2017-12-18</td>\n",
       "      <td>865000.0</td>\n",
       "      <td>865000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.123850</td>\n",
       "      <td>AR10122043</td>\n",
       "      <td>865000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Drvwy/Off Str</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Sold to builder before going on the market. So...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UTAH</td>\n",
       "      <td>3546.0</td>\n",
       "      <td>Rambler</td>\n",
       "      <td>03-036-108</td>\n",
       "      <td>739900</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7332.40</td>\n",
       "      <td>0</td>\n",
       "      <td>Detached</td>\n",
       "      <td>1953</td>\n",
       "      <td>4444.0</td>\n",
       "      <td>22207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3061</th>\n",
       "      <td>3650 38TH ST N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-12-19</td>\n",
       "      <td>862000.0</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>8402.76</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>237300.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Traditional</td>\n",
       "      <td>608900.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>2</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>872000.0</td>\n",
       "      <td>872000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.118920</td>\n",
       "      <td>AR10122381</td>\n",
       "      <td>872000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Sold privately \"as is.\"   Entered for comp pur...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>38TH</td>\n",
       "      <td>3650.0</td>\n",
       "      <td>Split Foyer</td>\n",
       "      <td>04-036-010</td>\n",
       "      <td>846200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8512.76</td>\n",
       "      <td>0</td>\n",
       "      <td>Detached</td>\n",
       "      <td>1959</td>\n",
       "      <td>4824.0</td>\n",
       "      <td>22207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3062</th>\n",
       "      <td>3450 14TH ST N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-12-12</td>\n",
       "      <td>980000.0</td>\n",
       "      <td>2017-11-10</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>7529.90</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>122300.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>NaN</td>\n",
       "      <td>636000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>3</td>\n",
       "      <td>2017-11-10</td>\n",
       "      <td>980000.0</td>\n",
       "      <td>980000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.102840</td>\n",
       "      <td>AR10122669</td>\n",
       "      <td>980000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Other</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Comp purposes only. Purchased from builder pri...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14TH</td>\n",
       "      <td>3450.0</td>\n",
       "      <td>Cape Cod</td>\n",
       "      <td>15-081-028</td>\n",
       "      <td>758300</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7628.46</td>\n",
       "      <td>0</td>\n",
       "      <td>Detached</td>\n",
       "      <td>1949</td>\n",
       "      <td>4910.0</td>\n",
       "      <td>22201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3063</th>\n",
       "      <td>1307 HUDSON ST N</td>\n",
       "      <td>Attached Master Bathroom, Attic - Finished, Au...</td>\n",
       "      <td>Dishwasher, Disposal, Dryer - Front Loading, E...</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-12-20</td>\n",
       "      <td>1905000.0</td>\n",
       "      <td>2017-11-21</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air, Programmable Thermostat</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>1059500.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>725000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>4</td>\n",
       "      <td>2017-11-21</td>\n",
       "      <td>1949900.0</td>\n",
       "      <td>1949900.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.097540</td>\n",
       "      <td>AR10123038</td>\n",
       "      <td>1949900.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Drvwy/Off Str, Garage, Detached, Garage Door O...</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Contact Alt Listing Agent  Bridget Hodge @ 703...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>HUDSON</td>\n",
       "      <td>1307.0</td>\n",
       "      <td>Craftsman</td>\n",
       "      <td>15-073-001</td>\n",
       "      <td>1784500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4894</td>\n",
       "      <td>17684.38</td>\n",
       "      <td>1</td>\n",
       "      <td>Detached</td>\n",
       "      <td>2007</td>\n",
       "      <td>5015.0</td>\n",
       "      <td>22201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3064</th>\n",
       "      <td>2616 KENMORE CT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-11-07</td>\n",
       "      <td>755000.0</td>\n",
       "      <td>2017-10-05</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>6386.96</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Central, Forced Air</td>\n",
       "      <td>True</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>356200.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>287000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>4</td>\n",
       "      <td>2017-10-05</td>\n",
       "      <td>755000.0</td>\n",
       "      <td>755000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.086220</td>\n",
       "      <td>AR10123175</td>\n",
       "      <td>755000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage, Street</td>\n",
       "      <td>Residential</td>\n",
       "      <td>immaculate home in Shirlington Crest</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KENMORE</td>\n",
       "      <td>2616.0</td>\n",
       "      <td>Federal</td>\n",
       "      <td>31-033-205</td>\n",
       "      <td>643200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2049</td>\n",
       "      <td>6470.56</td>\n",
       "      <td>0</td>\n",
       "      <td>Townhouse</td>\n",
       "      <td>2008</td>\n",
       "      <td>2365.0</td>\n",
       "      <td>22206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3065</th>\n",
       "      <td>5212 32ND ST N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-12-21</td>\n",
       "      <td>795000.0</td>\n",
       "      <td>2017-12-21</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>7426.64</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>147900.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>NaN</td>\n",
       "      <td>600000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>2</td>\n",
       "      <td>2017-12-21</td>\n",
       "      <td>795000.0</td>\n",
       "      <td>795000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.142310</td>\n",
       "      <td>AR10123182</td>\n",
       "      <td>795000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Drvwy/Off Str</td>\n",
       "      <td>Residential</td>\n",
       "      <td>For comp purposes only. Off market sale. Buyer...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32ND</td>\n",
       "      <td>5212.0</td>\n",
       "      <td>Rambler</td>\n",
       "      <td>02-025-011</td>\n",
       "      <td>747900</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7523.86</td>\n",
       "      <td>0</td>\n",
       "      <td>Detached</td>\n",
       "      <td>1955</td>\n",
       "      <td>1503.0</td>\n",
       "      <td>22207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3066</th>\n",
       "      <td>1338 ROLFE ST S</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>No</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-08-11</td>\n",
       "      <td>726275.0</td>\n",
       "      <td>2017-03-09</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>True</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>60800.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>3</td>\n",
       "      <td>2017-03-09</td>\n",
       "      <td>726275.0</td>\n",
       "      <td>726275.0</td>\n",
       "      <td>Modified/Excl</td>\n",
       "      <td>-77.074336</td>\n",
       "      <td>AR10125276</td>\n",
       "      <td>726275.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Drvwy/Off Str</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Settled on 8/11/2017</td>\n",
       "      <td>All Days</td>\n",
       "      <td>ROLFE</td>\n",
       "      <td>1338.0</td>\n",
       "      <td>Colonial</td>\n",
       "      <td>33-007-074</td>\n",
       "      <td>60800</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2202</td>\n",
       "      <td>611.64</td>\n",
       "      <td>0</td>\n",
       "      <td>Townhouse</td>\n",
       "      <td>2017</td>\n",
       "      <td>4750.0</td>\n",
       "      <td>22204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3067</th>\n",
       "      <td>1530 KEY BLVD #1216</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dishwasher, Disposal, Dryer, Exhaust Fan, Icem...</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-12-29</td>\n",
       "      <td>650000.0</td>\n",
       "      <td>2017-11-10</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>5828.90</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Heat Pump(s)</td>\n",
       "      <td>False</td>\n",
       "      <td>Electric</td>\n",
       "      <td>546500.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Traditional</td>\n",
       "      <td>40500.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2017-11-10</td>\n",
       "      <td>650000.0</td>\n",
       "      <td>650000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.076060</td>\n",
       "      <td>AR10125734</td>\n",
       "      <td>650000.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Garage, Assigned, Underground</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Stunning 12th floor condo with sweeping views ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KEY</td>\n",
       "      <td>1530.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>16-034-343</td>\n",
       "      <td>587000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1125</td>\n",
       "      <td>5905.20</td>\n",
       "      <td>0</td>\n",
       "      <td>Hi-Rise 9+ Floors</td>\n",
       "      <td>1986</td>\n",
       "      <td>1543.0</td>\n",
       "      <td>22209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3068</th>\n",
       "      <td>5225 11TH ST S</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>No</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-12-29</td>\n",
       "      <td>466625.0</td>\n",
       "      <td>2017-12-29</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>4871.64</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>136500.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>NaN</td>\n",
       "      <td>354100.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>2</td>\n",
       "      <td>2017-12-29</td>\n",
       "      <td>466625.0</td>\n",
       "      <td>466625.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.116090</td>\n",
       "      <td>AR10125794</td>\n",
       "      <td>466625.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>None</td>\n",
       "      <td>Residential</td>\n",
       "      <td>.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11TH</td>\n",
       "      <td>5225.0</td>\n",
       "      <td>Colonial</td>\n",
       "      <td>28-005-024</td>\n",
       "      <td>490600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4935.40</td>\n",
       "      <td>0</td>\n",
       "      <td>Detached</td>\n",
       "      <td>1947</td>\n",
       "      <td>3216.0</td>\n",
       "      <td>22204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3069</th>\n",
       "      <td>1701 16th ST N #318</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-08-10</td>\n",
       "      <td>1499900.0</td>\n",
       "      <td>2017-03-01</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2017-03-01</td>\n",
       "      <td>1499900.0</td>\n",
       "      <td>1499900.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.077760</td>\n",
       "      <td>AR10125930</td>\n",
       "      <td>1499900.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Entered for Comparative Purposes.  Selling Age...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16TH</td>\n",
       "      <td>1701.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1880</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Garden 1-4 Floors</td>\n",
       "      <td>2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3070</th>\n",
       "      <td>1709 13TH RD S</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>No</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>854755.0</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>4488.36</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>True</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>182000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>NaN</td>\n",
       "      <td>270000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>4</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>854755.0</td>\n",
       "      <td>854755.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.073142</td>\n",
       "      <td>AR10126594</td>\n",
       "      <td>854755.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13TH</td>\n",
       "      <td>1709.0</td>\n",
       "      <td>Colonial</td>\n",
       "      <td>33-007-043</td>\n",
       "      <td>452000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2496</td>\n",
       "      <td>4547.12</td>\n",
       "      <td>0</td>\n",
       "      <td>Townhouse</td>\n",
       "      <td>2016</td>\n",
       "      <td>4720.0</td>\n",
       "      <td>22204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3071</th>\n",
       "      <td>5130 16TH ST N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-12-27</td>\n",
       "      <td>645000.0</td>\n",
       "      <td>2017-10-13</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>7533.88</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>143400.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>NaN</td>\n",
       "      <td>615300.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>2</td>\n",
       "      <td>2017-10-13</td>\n",
       "      <td>650000.0</td>\n",
       "      <td>650000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.126380</td>\n",
       "      <td>AR10126669</td>\n",
       "      <td>650000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Entered for comp purposes only.  Home needed u...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16TH</td>\n",
       "      <td>5130.0</td>\n",
       "      <td>Rambler</td>\n",
       "      <td>09-031-011</td>\n",
       "      <td>758700</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7632.50</td>\n",
       "      <td>0</td>\n",
       "      <td>Detached</td>\n",
       "      <td>1952</td>\n",
       "      <td>2644.0</td>\n",
       "      <td>22205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3072</th>\n",
       "      <td>4312 2ND RD N #2</td>\n",
       "      <td>Bathroom(s) - Ceramic Tile, Shades / Blinds, W...</td>\n",
       "      <td>Disposal, Microwave, Oven / Range - Gas, Refri...</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-12-29</td>\n",
       "      <td>246100.0</td>\n",
       "      <td>2017-11-21</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>98</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>180400.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Traditional</td>\n",
       "      <td>49000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2017-11-21</td>\n",
       "      <td>234900.0</td>\n",
       "      <td>234900.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.106470</td>\n",
       "      <td>AR10127109</td>\n",
       "      <td>234900.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Gen Comm Elem, Permit Required, Prk Space Cnvys</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Call Alt Agent Sarah Noel with questions. SCHE...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>2ND</td>\n",
       "      <td>4312.0</td>\n",
       "      <td>Colonial</td>\n",
       "      <td>20-028-044</td>\n",
       "      <td>229400</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>875</td>\n",
       "      <td>2273.34</td>\n",
       "      <td>1</td>\n",
       "      <td>Garden 1-4 Floors</td>\n",
       "      <td>1940</td>\n",
       "      <td>2970.0</td>\n",
       "      <td>22203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3073</th>\n",
       "      <td>1336 S. Quinn ST</td>\n",
       "      <td>Home Warranty, Vanities - Double, Countertop(s...</td>\n",
       "      <td>ENERGY STAR Dishwasher, ENERGY STAR Refrigerat...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-11-21</td>\n",
       "      <td>809990.0</td>\n",
       "      <td>2017-05-17</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>ENERGY STAR Heating System</td>\n",
       "      <td>True</td>\n",
       "      <td>Instant Hot Water, Tankless Water Heater</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>2017-05-17</td>\n",
       "      <td>719900.0</td>\n",
       "      <td>719900.0</td>\n",
       "      <td>Excl. Agency</td>\n",
       "      <td>-77.073900</td>\n",
       "      <td>AR10130028</td>\n",
       "      <td>719900.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Garage, Garage Door Opener, Paved Driveway</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Arlington's fastest selling community.  Conven...</td>\n",
       "      <td>All Days</td>\n",
       "      <td>S. QUINN</td>\n",
       "      <td>1336.0</td>\n",
       "      <td>Craftsman</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2879</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>Townhouse</td>\n",
       "      <td>2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3074</th>\n",
       "      <td>3458 S WAKEFIELD ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-12-18</td>\n",
       "      <td>604000.0</td>\n",
       "      <td>2017-11-27</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>5168.56</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Heat Pump(s)</td>\n",
       "      <td>False</td>\n",
       "      <td>Electric</td>\n",
       "      <td>461900.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Traditional</td>\n",
       "      <td>58600.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>3</td>\n",
       "      <td>2017-11-27</td>\n",
       "      <td>585000.0</td>\n",
       "      <td>585000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.091601</td>\n",
       "      <td>AR10132615</td>\n",
       "      <td>594000.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Assigned</td>\n",
       "      <td>Residential</td>\n",
       "      <td>For comp purposes, sold off-market.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S WAKEFIELD</td>\n",
       "      <td>3458.0</td>\n",
       "      <td>Colonial</td>\n",
       "      <td>30-021-642</td>\n",
       "      <td>520500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1830</td>\n",
       "      <td>5236.22</td>\n",
       "      <td>1</td>\n",
       "      <td>Townhouse</td>\n",
       "      <td>1940</td>\n",
       "      <td>1706.0</td>\n",
       "      <td>22206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3075</th>\n",
       "      <td>1701 16th Street N #311</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-07-05</td>\n",
       "      <td>1250724.0</td>\n",
       "      <td>2017-02-10</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Loft</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2017-02-10</td>\n",
       "      <td>1250724.0</td>\n",
       "      <td>1250724.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.077760</td>\n",
       "      <td>AR10132004</td>\n",
       "      <td>1250724.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Gaslight Select.... New Construction by Abdo.....</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16TH STREET</td>\n",
       "      <td>1701.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>17-008-091</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1650</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Duplex</td>\n",
       "      <td>2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3076</th>\n",
       "      <td>1701 16th St #353</td>\n",
       "      <td>Countertop(s) - Silestone, Elevator, Master Be...</td>\n",
       "      <td>Dishwasher, Disposal, Dryer - Front Loading, I...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-06-28</td>\n",
       "      <td>939900.0</td>\n",
       "      <td>2017-01-20</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2017-01-20</td>\n",
       "      <td>939900.0</td>\n",
       "      <td>939900.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.077760</td>\n",
       "      <td>AR10138138</td>\n",
       "      <td>939900.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>2 Bedroom Flat for comparable purposes only.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16TH ST</td>\n",
       "      <td>1701.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>17-008-122</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1337</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Garden 1-4 Floors</td>\n",
       "      <td>2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3077</th>\n",
       "      <td>1701 16th ST #334</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-07-11</td>\n",
       "      <td>1205900.0</td>\n",
       "      <td>2017-01-22</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Floor Plan-Traditional, Floor Plan-Open</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2017-01-22</td>\n",
       "      <td>1205900.0</td>\n",
       "      <td>1205900.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.077760</td>\n",
       "      <td>AR10138178</td>\n",
       "      <td>1205900.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>For Comp purposes only. 2 bedroom loft unit, n...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16TH</td>\n",
       "      <td>1701.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>17-008-109</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1875</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Mid-Rise 5-8 Floors</td>\n",
       "      <td>2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3078</th>\n",
       "      <td>1701 16th #351</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-09-22</td>\n",
       "      <td>971900.0</td>\n",
       "      <td>2017-09-01</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Floor Plan-Open</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2017-09-01</td>\n",
       "      <td>971900.0</td>\n",
       "      <td>971900.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.077760</td>\n",
       "      <td>AR10138196</td>\n",
       "      <td>971900.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>For Comp Purposes.  1st level 2 bedroom flat w...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16TH</td>\n",
       "      <td>1701.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>17-008-120</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1337</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Mid-Rise 5-8 Floors</td>\n",
       "      <td>2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3079</th>\n",
       "      <td>1701 16th St. N ST #322</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-06-30</td>\n",
       "      <td>849900.0</td>\n",
       "      <td>2017-03-01</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Hot Water</td>\n",
       "      <td>False</td>\n",
       "      <td>60 or More Gallon Tank</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Loft</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2017-03-01</td>\n",
       "      <td>849900.0</td>\n",
       "      <td>849900.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.077760</td>\n",
       "      <td>AR10149248</td>\n",
       "      <td>849900.0</td>\n",
       "      <td>Condo</td>\n",
       "      <td>Assigned</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Listing for comp purposes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16TH ST. N</td>\n",
       "      <td>1701.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>125356</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1024</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Attach/Row Hse</td>\n",
       "      <td>2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3080</th>\n",
       "      <td>5709 11TH ST N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>No</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-09-22</td>\n",
       "      <td>867604.0</td>\n",
       "      <td>2017-04-14</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>3972.00</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>True</td>\n",
       "      <td>Natural Gas, Tankless Water Heater</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>NaN</td>\n",
       "      <td>400000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>4</td>\n",
       "      <td>2017-04-14</td>\n",
       "      <td>867604.0</td>\n",
       "      <td>867604.0</td>\n",
       "      <td>Modified/Excl</td>\n",
       "      <td>-77.134070</td>\n",
       "      <td>AR10150737</td>\n",
       "      <td>867604.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>New Construction. Arlington Row.  For Comp Pur...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11TH</td>\n",
       "      <td>5709.0</td>\n",
       "      <td>Other</td>\n",
       "      <td>09-064-022</td>\n",
       "      <td>400000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4024.00</td>\n",
       "      <td>0</td>\n",
       "      <td>Townhouse</td>\n",
       "      <td>2017</td>\n",
       "      <td>2303.0</td>\n",
       "      <td>22205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3081</th>\n",
       "      <td>1121 ARLINGTON BLVD #505</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>159000.0</td>\n",
       "      <td>2017-06-20</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>1651.34</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Summer / Winter Changeover</td>\n",
       "      <td>True</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>143900.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>Floor Plan-Traditional</td>\n",
       "      <td>22400.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>1</td>\n",
       "      <td>2017-06-20</td>\n",
       "      <td>159000.0</td>\n",
       "      <td>159000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.069365</td>\n",
       "      <td>AR10153179</td>\n",
       "      <td>159000.0</td>\n",
       "      <td>Coop</td>\n",
       "      <td>On-site Prk/Rent</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Great Rental Return</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>1121.0</td>\n",
       "      <td>Transitional</td>\n",
       "      <td>17-039-181</td>\n",
       "      <td>166300</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>559</td>\n",
       "      <td>1672.94</td>\n",
       "      <td>0</td>\n",
       "      <td>Hi-Rise 9+ Floors</td>\n",
       "      <td>1955</td>\n",
       "      <td>3226.0</td>\n",
       "      <td>22209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3082</th>\n",
       "      <td>1120 KENSINGTON ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>No</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-12-12</td>\n",
       "      <td>1041943.0</td>\n",
       "      <td>2017-05-27</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>3972.00</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>Forced Air</td>\n",
       "      <td>True</td>\n",
       "      <td>Tankless Water Heater</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>NaN</td>\n",
       "      <td>400000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>4</td>\n",
       "      <td>2017-05-27</td>\n",
       "      <td>949990.0</td>\n",
       "      <td>949990.0</td>\n",
       "      <td>Excl. Agency</td>\n",
       "      <td>-77.133797</td>\n",
       "      <td>AR10155430</td>\n",
       "      <td>949990.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Basement Garage</td>\n",
       "      <td>Residential</td>\n",
       "      <td>New Construction</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KENSINGTON</td>\n",
       "      <td>1120.0</td>\n",
       "      <td>Contemporary</td>\n",
       "      <td>09-064-034</td>\n",
       "      <td>400000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4024.00</td>\n",
       "      <td>0</td>\n",
       "      <td>Townhouse</td>\n",
       "      <td>2017</td>\n",
       "      <td>3532.0</td>\n",
       "      <td>22205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3083</th>\n",
       "      <td>1401 GLEBE RD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>2017-03-24</td>\n",
       "      <td>668000.0</td>\n",
       "      <td>2017-02-24</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>6951.98</td>\n",
       "      <td>Annually</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Hot Water, Forced Air</td>\n",
       "      <td>False</td>\n",
       "      <td>Natural Gas</td>\n",
       "      <td>148100.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>NaN</td>\n",
       "      <td>552000.0</td>\n",
       "      <td>Annually</td>\n",
       "      <td>3</td>\n",
       "      <td>2017-02-24</td>\n",
       "      <td>656000.0</td>\n",
       "      <td>656000.0</td>\n",
       "      <td>Excl. Right</td>\n",
       "      <td>-77.118140</td>\n",
       "      <td>AR10157944</td>\n",
       "      <td>656000.0</td>\n",
       "      <td>Fee Simple</td>\n",
       "      <td>Drvwy/Off Str</td>\n",
       "      <td>Residential</td>\n",
       "      <td>Entered for comps purposes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GLEBE</td>\n",
       "      <td>1401.0</td>\n",
       "      <td>Tudor</td>\n",
       "      <td>07-042-005</td>\n",
       "      <td>700100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7042.98</td>\n",
       "      <td>0</td>\n",
       "      <td>Detached</td>\n",
       "      <td>1926</td>\n",
       "      <td>2119.0</td>\n",
       "      <td>22207</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3084 rows × 55 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 FullStreetAddress  \\\n",
       "0               3601 5TH ST S #504   \n",
       "1           1600 OAK ST #1915/1914   \n",
       "2               1719 GREENBRIER ST   \n",
       "3            3723 FOUR MILE RUN DR   \n",
       "4             2005 KEY BLVD #11579   \n",
       "5                  1719 GLEBE RD N   \n",
       "6                  1400 KENMORE ST   \n",
       "7            1800 WILSON BLVD #222   \n",
       "8     4195 FOUR MILE RUN DR S #201   \n",
       "9                  6961 FAIRFAX DR   \n",
       "10     2200 WESTMORELAND ST N #420   \n",
       "11          832 GREENBRIER ST S #1   \n",
       "12              2704 BUCHANAN ST N   \n",
       "13                28 S PERSHING DR   \n",
       "14            1001 VERMONT ST #614   \n",
       "15                  6318 31ST ST N   \n",
       "16                   664 29TH RD S   \n",
       "17              2004 CULPEPER ST N   \n",
       "18                1309 S. QUINN ST   \n",
       "19              2834 SOMERSET ST N   \n",
       "20                   2408 1ST RD S   \n",
       "21          4141 HENDERSON RD #814   \n",
       "22                  4118 27TH RD N   \n",
       "23               412 GARFIELD ST N   \n",
       "24                   1319 S. QUINN   \n",
       "25             900 TAYLOR ST #1527   \n",
       "26               1715 13TH ROAD S.   \n",
       "27         4366 PERSHING DR #43662   \n",
       "28            2907 KENSINGTON ST N   \n",
       "29             900 TAYLOR ST #1420   \n",
       "...                            ...   \n",
       "3054               1311 Quinn ST S   \n",
       "3055             4360 LEE HWY #203   \n",
       "3056               117 FILLMORE ST   \n",
       "3057            1633 BARTON ST #12   \n",
       "3058          1418 RHODES ST #B412   \n",
       "3059         3600 GLEBE RD S #621W   \n",
       "3060                  3546 UTAH ST   \n",
       "3061                3650 38TH ST N   \n",
       "3062                3450 14TH ST N   \n",
       "3063              1307 HUDSON ST N   \n",
       "3064               2616 KENMORE CT   \n",
       "3065                5212 32ND ST N   \n",
       "3066               1338 ROLFE ST S   \n",
       "3067           1530 KEY BLVD #1216   \n",
       "3068                5225 11TH ST S   \n",
       "3069           1701 16th ST N #318   \n",
       "3070                1709 13TH RD S   \n",
       "3071                5130 16TH ST N   \n",
       "3072              4312 2ND RD N #2   \n",
       "3073              1336 S. Quinn ST   \n",
       "3074           3458 S WAKEFIELD ST   \n",
       "3075       1701 16th Street N #311   \n",
       "3076             1701 16th St #353   \n",
       "3077             1701 16th ST #334   \n",
       "3078                1701 16th #351   \n",
       "3079       1701 16th St. N ST #322   \n",
       "3080                5709 11TH ST N   \n",
       "3081      1121 ARLINGTON BLVD #505   \n",
       "3082            1120 KENSINGTON ST   \n",
       "3083                 1401 GLEBE RD   \n",
       "\n",
       "                                              Amenities  \\\n",
       "0                                                   NaN   \n",
       "1     Built-in Bookcases, Chair Railing, Crown Moldi...   \n",
       "2     Attic - Finished, Automatic Garage Door Opener...   \n",
       "3                                                   NaN   \n",
       "4     Bathroom(s) - Ceramic Tile, Countertop(s) - Gr...   \n",
       "5     Fireplace Mantel(s), Countertop(s) - Granite, ...   \n",
       "6     Attic - Floored, Attic - Stairs Fixed, Attic -...   \n",
       "7     Automatic Garage Door Opener, Elevator, Closet...   \n",
       "8     Closet - Master Bedroom Walk-in, Countertop(s)...   \n",
       "9     Bathroom(s) - Ceramic Tile, Closet - Master Be...   \n",
       "10    Attached Master Bathroom, Closet - Master Bedr...   \n",
       "11                                                  NaN   \n",
       "12    Attached Master Bathroom, Attic - Stairs Pull ...   \n",
       "13    Attic - Stairs Pull Down, Automatic Garage Doo...   \n",
       "14                                                  NaN   \n",
       "15    Attic - Finished, Automatic Garage Door Opener...   \n",
       "16    Attic - Access Only, Automatic Garage Door Ope...   \n",
       "17    Automatic Garage Door Opener, Bathroom(s) - Ce...   \n",
       "18                                                  NaN   \n",
       "19    Attached Master Bathroom, Attic - Stairs Pull ...   \n",
       "20    Closet(s) - Walk-in, Countertop(s) - Granite, ...   \n",
       "21    Closet(s) - Walk-in, Countertop(s) - Granite, ...   \n",
       "22    Attached Master Bathroom, Automatic Garage Doo...   \n",
       "23    Automatic Garage Door Opener, Chair Railing, C...   \n",
       "24                                                  NaN   \n",
       "25    Master Bedroom - Full Bathroom, Attached Maste...   \n",
       "26                                                  NaN   \n",
       "27                                          Wood Floors   \n",
       "28    Attic - Finished, Closet - Master Bedroom Walk...   \n",
       "29                                                  NaN   \n",
       "...                                                 ...   \n",
       "3054                                                NaN   \n",
       "3055  Bathroom(s) - Ceramic Tile, Built-in Bookcases...   \n",
       "3056                                                NaN   \n",
       "3057  Bathroom(s) - Ceramic Tile, Bedroom - Entry Le...   \n",
       "3058                                                NaN   \n",
       "3059                                                NaN   \n",
       "3060                                                NaN   \n",
       "3061                                                NaN   \n",
       "3062                                                NaN   \n",
       "3063  Attached Master Bathroom, Attic - Finished, Au...   \n",
       "3064                                                NaN   \n",
       "3065                                                NaN   \n",
       "3066                                                NaN   \n",
       "3067                                                NaN   \n",
       "3068                                                NaN   \n",
       "3069                                                NaN   \n",
       "3070                                                NaN   \n",
       "3071                                                NaN   \n",
       "3072  Bathroom(s) - Ceramic Tile, Shades / Blinds, W...   \n",
       "3073  Home Warranty, Vanities - Double, Countertop(s...   \n",
       "3074                                                NaN   \n",
       "3075                                                NaN   \n",
       "3076  Countertop(s) - Silestone, Elevator, Master Be...   \n",
       "3077                                                NaN   \n",
       "3078                                                NaN   \n",
       "3079                                                NaN   \n",
       "3080                                                NaN   \n",
       "3081                                                NaN   \n",
       "3082                                                NaN   \n",
       "3083                                                NaN   \n",
       "\n",
       "                                             Appliances  AssessmentYear Attic  \\\n",
       "0     Dishwasher, Disposal, Refrigerator, Range Hood...          2014.0    No   \n",
       "1     Cooktop, Dishwasher, Disposal, Dryer, Exhaust ...          2015.0    No   \n",
       "2     ENERGY STAR Dishwasher, ENERGY STAR Refrigerat...          2015.0   Yes   \n",
       "3     Dishwasher, Disposal, Oven / Range - Gas, Refr...          2015.0   Yes   \n",
       "4     Dishwasher, Disposal, Exhaust Fan, Microwave, ...          2016.0    No   \n",
       "5     Dishwasher, Disposal, Dryer, Exhaust Fan, Icem...          2016.0   Yes   \n",
       "6     Dishwasher, Disposal, Dryer, Extra Refrigerato...          2016.0   Yes   \n",
       "7     Dishwasher, Disposal, Exhaust Fan, Icemaker, M...          2016.0    No   \n",
       "8     Dishwasher, Disposal, Dryer, Refrigerator, Ice...          2016.0    No   \n",
       "9     Central Vacuum, Dishwasher, Disposal, Dryer, M...          2016.0   Yes   \n",
       "10    Dishwasher, Dryer - Front Loading, Icemaker, M...          2016.0    No   \n",
       "11                                                  NaN          2015.0    No   \n",
       "12    Dishwasher, Disposal, Humidifier, Icemaker, Mi...          2015.0   Yes   \n",
       "13    Dishwasher, Disposal, Dryer, Exhaust Fan, Icem...             NaN   Yes   \n",
       "14    Dishwasher, Disposal, Microwave, Oven / Range ...          2015.0    No   \n",
       "15    Dishwasher, Disposal, Exhaust Fan, Icemaker, M...          2015.0   Yes   \n",
       "16    Cooktop, Dishwasher, Disposal, Dryer - Front L...          2015.0   Yes   \n",
       "17    Dishwasher, Cooktop, Disposal, Dryer, Dryer - ...          2015.0    No   \n",
       "18    ENERGY STAR Dishwasher, ENERGY STAR Refrigerat...             NaN    No   \n",
       "19                                 Dishwasher, Disposal          2017.0   Yes   \n",
       "20    Central Vacuum, Dishwasher, Disposal, Dryer, I...             NaN   Yes   \n",
       "21         Dishwasher, Refrigerator, Oven / Range - Gas          2015.0    No   \n",
       "22    Dishwasher, Disposal, Dryer, Microwave, Oven -...          2015.0   Yes   \n",
       "23    Cooktop, Dishwasher, Disposal, Dryer, Microwav...             NaN    No   \n",
       "24    ENERGY STAR Dishwasher, ENERGY STAR Refrigerat...             NaN    No   \n",
       "25    Dishwasher, Disposal, Dryer, Dryer - Front Loa...          2015.0    No   \n",
       "26    ENERGY STAR Dishwasher, ENERGY STAR Refrigerat...             NaN    No   \n",
       "27    Dishwasher, Disposal, Microwave, Refrigerator,...          2015.0    No   \n",
       "28    Dishwasher, Disposal, Dryer, Exhaust Fan, Icem...             NaN   Yes   \n",
       "29                                                  NaN          2015.0    No   \n",
       "...                                                 ...             ...   ...   \n",
       "3054                                                NaN             NaN    No   \n",
       "3055  Dishwasher, Disposal, Exhaust Fan, Oven / Rang...          2016.0    No   \n",
       "3056                                                NaN          2016.0    No   \n",
       "3057  Dishwasher, Microwave, Oven / Range - Electric...          2016.0    No   \n",
       "3058                                                NaN          2016.0    No   \n",
       "3059                                                NaN          2016.0    No   \n",
       "3060                                                NaN          2016.0   Yes   \n",
       "3061                                                NaN          2017.0   Yes   \n",
       "3062                                                NaN          2017.0   Yes   \n",
       "3063  Dishwasher, Disposal, Dryer - Front Loading, E...          2016.0   Yes   \n",
       "3064                                                NaN          2017.0   Yes   \n",
       "3065                                                NaN          2017.0   Yes   \n",
       "3066                                                NaN          2017.0    No   \n",
       "3067  Dishwasher, Disposal, Dryer, Exhaust Fan, Icem...          2017.0    No   \n",
       "3068                                                NaN          2017.0    No   \n",
       "3069                                                NaN             NaN    No   \n",
       "3070                                                NaN          2017.0    No   \n",
       "3071                                                NaN          2017.0   Yes   \n",
       "3072  Disposal, Microwave, Oven / Range - Gas, Refri...          2016.0    No   \n",
       "3073  ENERGY STAR Dishwasher, ENERGY STAR Refrigerat...             NaN    No   \n",
       "3074                                                NaN          2017.0   Yes   \n",
       "3075                                                NaN             NaN    No   \n",
       "3076  Dishwasher, Disposal, Dryer - Front Loading, I...             NaN    No   \n",
       "3077                                                NaN             NaN    No   \n",
       "3078                                                NaN             NaN    No   \n",
       "3079                                                NaN             NaN    No   \n",
       "3080                                                NaN          2017.0    No   \n",
       "3081                                                NaN          2017.0    No   \n",
       "3082                                                NaN          2017.0    No   \n",
       "3083                                                NaN          2017.0   Yes   \n",
       "\n",
       "      Baths  BathsFull  BathsHalf  Beds   CityName   CloseDate  ClosePrice  \\\n",
       "0         1          1          0     2  ARLINGTON  2017-02-22    185000.0   \n",
       "1         3          2          1     3  ARLINGTON  2017-02-21   1700000.0   \n",
       "2         8          7          1     7  ARLINGTON  2017-03-03   1625000.0   \n",
       "3         3          2          1     2  ARLINGTON  2017-01-17    430000.0   \n",
       "4         1          1          0     2  ARLINGTON  2017-04-07    362000.0   \n",
       "5         3          2          1     3  ARLINGTON  2017-04-28    760000.0   \n",
       "6         3          2          1     4  ARLINGTON  2017-04-07    930000.0   \n",
       "7         1          1          0     1  ARLINGTON  2017-05-10    392000.0   \n",
       "8         1          1          0     1  ARLINGTON  2017-06-29    313000.0   \n",
       "9         3          3          0     3  ARLINGTON  2017-08-04    639000.0   \n",
       "10        2          2          0     2  ARLINGTON  2017-10-09    565000.0   \n",
       "11        1          1          0     2  ARLINGTON  2017-03-23    140000.0   \n",
       "12        7          6          1     7  ARLINGTON  2017-07-21   1999900.0   \n",
       "13        4          4          0     5  ARLINGTON  2017-02-17    487500.0   \n",
       "14        1          1          0     2  ARLINGTON  2017-01-30    410000.0   \n",
       "15        5          4          1     5  ARLINGTON  2017-08-08   1729000.0   \n",
       "16        4          3          1     5  ARLINGTON  2017-02-16   1149000.0   \n",
       "17        7          5          2     5  ARLINGTON  2017-01-05   1050000.0   \n",
       "18        4          3          1     3  ARLINGTON  2017-02-24    740285.0   \n",
       "19        5          4          1     5  ARLINGTON  2017-05-23   1635000.0   \n",
       "20        5          4          1     6  ARLINGTON  2017-02-06   1187000.0   \n",
       "21        1          1          0     0  ARLINGTON  2017-01-31    244000.0   \n",
       "22        3          3          0     4  ARLINGTON  2017-02-10    950000.0   \n",
       "23        5          5          0     7  ARLINGTON  2017-03-31   1735000.0   \n",
       "24        4          3          1     3  ARLINGTON  2017-02-27    877015.0   \n",
       "25        2          2          0     2  ARLINGTON  2017-04-28    195000.0   \n",
       "26        5          3          2     3  ARLINGTON  2017-03-28    835970.0   \n",
       "27        1          1          0     2  ARLINGTON  2017-02-17    260000.0   \n",
       "28        8          6          2     7  ARLINGTON  2017-03-31   2186500.0   \n",
       "29        2          2          0     2  ARLINGTON  2017-02-28    249000.0   \n",
       "...     ...        ...        ...   ...        ...         ...         ...   \n",
       "3054      4          3          1     3  ARLINGTON  2017-02-23    751955.0   \n",
       "3055      2          2          0     2  ARLINGTON  2017-12-29    330000.0   \n",
       "3056      5          5          0     5  ARLINGTON  2017-12-12    960000.0   \n",
       "3057      2          2          0     2  ARLINGTON  2017-12-30    379900.0   \n",
       "3058      2          2          0     2  ARLINGTON  2017-12-15    950000.0   \n",
       "3059      2          2          0     2  ARLINGTON  2017-02-24    473000.0   \n",
       "3060      2          2          0     4  ARLINGTON  2017-12-18    865000.0   \n",
       "3061      2          2          0     4  ARLINGTON  2017-12-19    862000.0   \n",
       "3062      2          2          0     3  ARLINGTON  2017-12-12    980000.0   \n",
       "3063      5          4          1     5  ARLINGTON  2017-12-20   1905000.0   \n",
       "3064      4          3          1     3  ARLINGTON  2017-11-07    755000.0   \n",
       "3065      2          2          0     3  ARLINGTON  2017-12-21    795000.0   \n",
       "3066      3          2          1     3  ARLINGTON  2017-08-11    726275.0   \n",
       "3067      1          1          0     1  ARLINGTON  2017-12-29    650000.0   \n",
       "3068      3          2          1     2  ARLINGTON  2017-12-29    466625.0   \n",
       "3069      3          2          1     2  ARLINGTON  2017-08-10   1499900.0   \n",
       "3070      5          3          2     3  ARLINGTON  2017-12-31    854755.0   \n",
       "3071      3          2          1     3  ARLINGTON  2017-12-27    645000.0   \n",
       "3072      1          1          0     2  ARLINGTON  2017-12-29    246100.0   \n",
       "3073      3          2          1     3  ARLINGTON  2017-11-21    809990.0   \n",
       "3074      2          2          0     3  ARLINGTON  2017-12-18    604000.0   \n",
       "3075      3          2          1     2  ARLINGTON  2017-07-05   1250724.0   \n",
       "3076      2          2          0     2  ARLINGTON  2017-06-28    939900.0   \n",
       "3077      3          2          1     2  ARLINGTON  2017-07-11   1205900.0   \n",
       "3078      2          2          0     2  ARLINGTON  2017-09-22    971900.0   \n",
       "3079      1          1          0     1  ARLINGTON  2017-06-30    849900.0   \n",
       "3080      3          2          1     3  ARLINGTON  2017-09-22    867604.0   \n",
       "3081      1          1          0     1  ARLINGTON  2017-07-24    159000.0   \n",
       "3082      5          4          1     5  ARLINGTON  2017-12-12   1041943.0   \n",
       "3083      3          3          0     3  ARLINGTON  2017-03-24    668000.0   \n",
       "\n",
       "     ContractDate     County  CountyTax CountyTaxPaymentFreq  DaysOnMarket  \\\n",
       "0      2017-01-15  ARLINGTON    1872.62             Annually           688   \n",
       "1      2016-11-16  ARLINGTON        NaN                  NaN           514   \n",
       "2      2017-01-08  ARLINGTON    7353.82             Annually           489   \n",
       "3      2016-12-03  ARLINGTON    3361.86             Annually           121   \n",
       "4      2017-03-06  ARLINGTON    3386.81             Annually            81   \n",
       "5      2017-03-25  ARLINGTON    7480.72             Annually            12   \n",
       "6      2017-03-15  ARLINGTON    7869.97             Annually             7   \n",
       "7      2017-04-03  ARLINGTON    3576.55             Annually            10   \n",
       "8      2017-05-26  ARLINGTON    3009.31             Annually            17   \n",
       "9      2017-07-12  ARLINGTON    5522.77             Annually             7   \n",
       "10     2017-09-27  ARLINGTON        NaN                  NaN            42   \n",
       "11     2017-02-23  ARLINGTON    1138.31             Annually           407   \n",
       "12     2016-01-06  ARLINGTON    6494.68             Annually             1   \n",
       "13     2016-08-01  ARLINGTON        NaN                  NaN           413   \n",
       "14     2016-12-21  ARLINGTON    4141.38             Annually           300   \n",
       "15     2016-05-10  ARLINGTON        NaN                  NaN            69   \n",
       "16     2017-01-11  ARLINGTON    9551.81             Annually           202   \n",
       "17     2016-11-16  ARLINGTON   10517.12             Annually           224   \n",
       "18     2016-06-10  ARLINGTON        NaN                  NaN            44   \n",
       "19     2017-04-03  ARLINGTON        NaN                  NaN           355   \n",
       "20     2016-12-29  ARLINGTON        NaN                  NaN           261   \n",
       "21     2016-12-17  ARLINGTON    2407.37             Annually           249   \n",
       "22     2017-01-10  ARLINGTON    8340.76             Annually           229   \n",
       "23     2017-01-23  ARLINGTON        NaN                  NaN           262   \n",
       "24     2016-05-19  ARLINGTON        NaN                  NaN            11   \n",
       "25     2017-04-10  ARLINGTON    1311.32             Annually           350   \n",
       "26     2016-05-25  ARLINGTON        NaN                  NaN            19   \n",
       "27     2017-01-29  ARLINGTON    2588.24             Annually           263   \n",
       "28     2017-02-04  ARLINGTON        NaN                  NaN           263   \n",
       "29     2016-12-22  ARLINGTON    1586.56             Annually           172   \n",
       "...           ...        ...        ...                  ...           ...   \n",
       "3054   2016-12-30  ARLINGTON        NaN                  NaN             0   \n",
       "3055   2017-12-17  ARLINGTON    2677.76             Annually             3   \n",
       "3056   2017-12-12  ARLINGTON        NaN                  NaN             0   \n",
       "3057   2017-12-29  ARLINGTON        NaN                  NaN            16   \n",
       "3058   2017-12-15  ARLINGTON    7921.80             Annually             0   \n",
       "3059   2017-02-14  ARLINGTON    4465.55             Annually             0   \n",
       "3060   2017-12-18  ARLINGTON    7236.22             Annually             0   \n",
       "3061   2017-10-31  ARLINGTON    8402.76             Annually             0   \n",
       "3062   2017-11-10  ARLINGTON    7529.90             Annually             0   \n",
       "3063   2017-11-21  ARLINGTON        NaN                  NaN             0   \n",
       "3064   2017-10-05  ARLINGTON    6386.96             Annually             0   \n",
       "3065   2017-12-21  ARLINGTON    7426.64             Annually             0   \n",
       "3066   2017-03-09  ARLINGTON        NaN                  NaN             0   \n",
       "3067   2017-11-10  ARLINGTON    5828.90             Annually             0   \n",
       "3068   2017-12-29  ARLINGTON    4871.64             Annually             0   \n",
       "3069   2017-03-01  ARLINGTON        NaN                  NaN             0   \n",
       "3070   2017-12-31  ARLINGTON    4488.36             Annually             0   \n",
       "3071   2017-10-13  ARLINGTON    7533.88             Annually             0   \n",
       "3072   2017-11-21  ARLINGTON        NaN                  NaN             0   \n",
       "3073   2017-05-17  ARLINGTON        NaN                  NaN             0   \n",
       "3074   2017-11-27  ARLINGTON    5168.56             Annually             0   \n",
       "3075   2017-02-10  ARLINGTON        NaN                  NaN             0   \n",
       "3076   2017-01-20  ARLINGTON        NaN                  NaN             0   \n",
       "3077   2017-01-22  ARLINGTON        NaN                  NaN             0   \n",
       "3078   2017-09-01  ARLINGTON        NaN                  NaN             0   \n",
       "3079   2017-03-01  ARLINGTON        NaN                  NaN             0   \n",
       "3080   2017-04-14  ARLINGTON    3972.00             Annually             0   \n",
       "3081   2017-06-20  ARLINGTON    1651.34             Annually             0   \n",
       "3082   2017-05-27  ARLINGTON    3972.00             Annually             0   \n",
       "3083   2017-02-24  ARLINGTON    6951.98             Annually             0   \n",
       "\n",
       "      DomProperty  Fireplaces  Foreclosure  \\\n",
       "0             688           0        False   \n",
       "1             514           0        False   \n",
       "2             489           1        False   \n",
       "3             121           0        False   \n",
       "4              81           0        False   \n",
       "5              12           1        False   \n",
       "6               7           1        False   \n",
       "7              10           0        False   \n",
       "8              17           0        False   \n",
       "9               7           1        False   \n",
       "10             42           0        False   \n",
       "11            407           0        False   \n",
       "12              1           1        False   \n",
       "13            632           1        False   \n",
       "14            300           0        False   \n",
       "15            145           1        False   \n",
       "16            202           1        False   \n",
       "17            224           3        False   \n",
       "18             44           0        False   \n",
       "19            355           1        False   \n",
       "20            261           1        False   \n",
       "21            249           0        False   \n",
       "22            229           1        False   \n",
       "23            262           1        False   \n",
       "24             11           0        False   \n",
       "25            350           0        False   \n",
       "26             19           0        False   \n",
       "27            263           0        False   \n",
       "28            263           2        False   \n",
       "29            264           0        False   \n",
       "...           ...         ...          ...   \n",
       "3054            0           0        False   \n",
       "3055            3           1        False   \n",
       "3056          220           1        False   \n",
       "3057           29           1        False   \n",
       "3058            0           0        False   \n",
       "3059            0           0        False   \n",
       "3060            0           1        False   \n",
       "3061            0           1        False   \n",
       "3062            0           1        False   \n",
       "3063           27           1        False   \n",
       "3064            0           1        False   \n",
       "3065            0           1        False   \n",
       "3066            0           0        False   \n",
       "3067            0           0        False   \n",
       "3068            0           0        False   \n",
       "3069            0           0        False   \n",
       "3070            0           2        False   \n",
       "3071            0           1        False   \n",
       "3072           98           0        False   \n",
       "3073            0           1        False   \n",
       "3074            0           0        False   \n",
       "3075            0           0        False   \n",
       "3076            0           0        False   \n",
       "3077            0           1        False   \n",
       "3078            0           0        False   \n",
       "3079            0           0        False   \n",
       "3080            0           0        False   \n",
       "3081            0           0        False   \n",
       "3082            0           0        False   \n",
       "3083            1           1        False   \n",
       "\n",
       "                                                Heating    HOA  \\\n",
       "0                            Summer / Winter Changeover  False   \n",
       "1                                          Heat Pump(s)   True   \n",
       "2     ENERGY STAR Heating System, Forced Air, Heat P...  False   \n",
       "3                                            Forced Air  False   \n",
       "4                              Heat Pump(s), Forced Air   True   \n",
       "5                                              Radiator  False   \n",
       "6                                   Wall Unit, Radiator  False   \n",
       "7                                            Forced Air  False   \n",
       "8                                            Forced Air  False   \n",
       "9                        Programmable Thermostat, Zoned  False   \n",
       "10                                           Forced Air  False   \n",
       "11                                             Radiator   True   \n",
       "12                                           Forced Air  False   \n",
       "13                      Forced Air, Heat Pump(s), Zoned  False   \n",
       "14                                         Heat Pump(s)  False   \n",
       "15                Forced Air, Wood Burning Stove, Zoned  False   \n",
       "16                             Forced Air, Heat Pump(s)  False   \n",
       "17                                           Forced Air  False   \n",
       "18                           ENERGY STAR Heating System   True   \n",
       "19                                           Forced Air  False   \n",
       "20                                         Heat Pump(s)  False   \n",
       "21                                              Central  False   \n",
       "22                                           Forced Air  False   \n",
       "23                                           Forced Air  False   \n",
       "24                           ENERGY STAR Heating System   True   \n",
       "25                                              Central  False   \n",
       "26                           ENERGY STAR Heating System   True   \n",
       "27                                             Radiator  False   \n",
       "28                                           Forced Air  False   \n",
       "29                                              Central  False   \n",
       "...                                                 ...    ...   \n",
       "3054                                            Central   True   \n",
       "3055                                         Forced Air   True   \n",
       "3056                                         Forced Air  False   \n",
       "3057                                       Heat Pump(s)   True   \n",
       "3058                                         Forced Air  False   \n",
       "3059                                            Central   True   \n",
       "3060                                            Central  False   \n",
       "3061                                         Forced Air  False   \n",
       "3062                                         Forced Air  False   \n",
       "3063                Forced Air, Programmable Thermostat  False   \n",
       "3064                                Central, Forced Air   True   \n",
       "3065                                         Forced Air  False   \n",
       "3066                                         Forced Air   True   \n",
       "3067                                       Heat Pump(s)  False   \n",
       "3068                                         Forced Air  False   \n",
       "3069                                         Forced Air  False   \n",
       "3070                                         Forced Air   True   \n",
       "3071                                         Forced Air  False   \n",
       "3072                                         Forced Air  False   \n",
       "3073                         ENERGY STAR Heating System   True   \n",
       "3074                                       Heat Pump(s)  False   \n",
       "3075                                         Forced Air  False   \n",
       "3076                                         Forced Air  False   \n",
       "3077                                         Forced Air  False   \n",
       "3078                                         Forced Air  False   \n",
       "3079                                          Hot Water  False   \n",
       "3080                                         Forced Air   True   \n",
       "3081                         Summer / Winter Changeover   True   \n",
       "3082                                         Forced Air   True   \n",
       "3083                              Hot Water, Forced Air  False   \n",
       "\n",
       "                                      HotWater  ImprovementAssessmentAmount  \\\n",
       "0                                  Natural Gas                     154100.0   \n",
       "1                                  Natural Gas                    1648000.0   \n",
       "2          Natural Gas, 60 or More Gallon Tank                     173100.0   \n",
       "3                                  Natural Gas                     152000.0   \n",
       "4                                     Electric                     309700.0   \n",
       "5                                  Natural Gas                     288700.0   \n",
       "6                                  Natural Gas                     192700.0   \n",
       "7                                  Natural Gas                     326200.0   \n",
       "8                                     Electric                     273700.0   \n",
       "9                                     Electric                     204700.0   \n",
       "10                                 Natural Gas                     440100.0   \n",
       "11                                 Natural Gas                      91500.0   \n",
       "12         Natural Gas, 60 or More Gallon Tank                     142000.0   \n",
       "13         60 or More Gallon Tank, Natural Gas                          NaN   \n",
       "14                                    Electric                     388700.0   \n",
       "15                                 Natural Gas                     105200.0   \n",
       "16         60 or More Gallon Tank, Natural Gas                     595800.0   \n",
       "17                       Electric, Natural Gas                     609900.0   \n",
       "18    Instant Hot Water, Tankless Water Heater                          NaN   \n",
       "19                                 Natural Gas                     770700.0   \n",
       "20                                 Natural Gas                          NaN   \n",
       "21                                 Natural Gas                     223200.0   \n",
       "22                                 Natural Gas                     258500.0   \n",
       "23                                 Natural Gas                          NaN   \n",
       "24    Instant Hot Water, Tankless Water Heater                          NaN   \n",
       "25                                    Electric                      95000.0   \n",
       "26    Instant Hot Water, Tankless Water Heater                          NaN   \n",
       "27                                 Natural Gas                     210900.0   \n",
       "28                                 Natural Gas                          NaN   \n",
       "29                                    Electric                     122200.0   \n",
       "...                                        ...                          ...   \n",
       "3054                                  Electric                          NaN   \n",
       "3055                               Natural Gas                     240000.0   \n",
       "3056                               Natural Gas                     688700.0   \n",
       "3057                                  Electric                     362000.0   \n",
       "3058                               Natural Gas                     716100.0   \n",
       "3059                               Natural Gas                     389200.0   \n",
       "3060                                  Electric                     129900.0   \n",
       "3061                               Natural Gas                     237300.0   \n",
       "3062                               Natural Gas                     122300.0   \n",
       "3063                               Natural Gas                    1059500.0   \n",
       "3064                               Natural Gas                     356200.0   \n",
       "3065                               Natural Gas                     147900.0   \n",
       "3066                               Natural Gas                          0.0   \n",
       "3067                                  Electric                     546500.0   \n",
       "3068                               Natural Gas                     136500.0   \n",
       "3069                               Natural Gas                          NaN   \n",
       "3070                               Natural Gas                     182000.0   \n",
       "3071                               Natural Gas                     143400.0   \n",
       "3072                               Natural Gas                     180400.0   \n",
       "3073  Instant Hot Water, Tankless Water Heater                          NaN   \n",
       "3074                                  Electric                     461900.0   \n",
       "3075                               Natural Gas                          NaN   \n",
       "3076                               Natural Gas                          NaN   \n",
       "3077                               Natural Gas                          NaN   \n",
       "3078                               Natural Gas                          NaN   \n",
       "3079                    60 or More Gallon Tank                          NaN   \n",
       "3080        Natural Gas, Tankless Water Heater                          0.0   \n",
       "3081                               Natural Gas                     143900.0   \n",
       "3082                     Tankless Water Heater                          0.0   \n",
       "3083                               Natural Gas                     148100.0   \n",
       "\n",
       "     ImprovementAssessmentPaymentFreq  \\\n",
       "0                            Annually   \n",
       "1                            Annually   \n",
       "2                            Annually   \n",
       "3                            Annually   \n",
       "4                            Annually   \n",
       "5                            Annually   \n",
       "6                            Annually   \n",
       "7                            Annually   \n",
       "8                            Annually   \n",
       "9                            Annually   \n",
       "10                           Annually   \n",
       "11                           Annually   \n",
       "12                           Annually   \n",
       "13                                NaN   \n",
       "14                           Annually   \n",
       "15                           Annually   \n",
       "16                           Annually   \n",
       "17                           Annually   \n",
       "18                                NaN   \n",
       "19                           Annually   \n",
       "20                                NaN   \n",
       "21                           Annually   \n",
       "22                           Annually   \n",
       "23                                NaN   \n",
       "24                                NaN   \n",
       "25                           Annually   \n",
       "26                                NaN   \n",
       "27                           Annually   \n",
       "28                                NaN   \n",
       "29                           Annually   \n",
       "...                               ...   \n",
       "3054                              NaN   \n",
       "3055                         Annually   \n",
       "3056                         Annually   \n",
       "3057                         Annually   \n",
       "3058                         Annually   \n",
       "3059                         Annually   \n",
       "3060                         Annually   \n",
       "3061                         Annually   \n",
       "3062                         Annually   \n",
       "3063                         Annually   \n",
       "3064                         Annually   \n",
       "3065                         Annually   \n",
       "3066                         Annually   \n",
       "3067                         Annually   \n",
       "3068                         Annually   \n",
       "3069                              NaN   \n",
       "3070                         Annually   \n",
       "3071                         Annually   \n",
       "3072                         Annually   \n",
       "3073                              NaN   \n",
       "3074                         Annually   \n",
       "3075                              NaN   \n",
       "3076                              NaN   \n",
       "3077                              NaN   \n",
       "3078                              NaN   \n",
       "3079                              NaN   \n",
       "3080                         Annually   \n",
       "3081                         Annually   \n",
       "3082                         Annually   \n",
       "3083                         Annually   \n",
       "\n",
       "                             InteriorFeatures  LandAssessmentAmount  \\\n",
       "0                      Floor Plan-Traditional               36400.0   \n",
       "1                             Floor Plan-Open              122000.0   \n",
       "2                             Floor Plan-Open              575000.0   \n",
       "3                             Floor Plan-Open              190000.0   \n",
       "4                      Floor Plan-Traditional               36600.0   \n",
       "5                      Floor Plan-Traditional              476200.0   \n",
       "6                                         NaN              612000.0   \n",
       "7                             Floor Plan-Open               39500.0   \n",
       "8                             Floor Plan-Open               34000.0   \n",
       "9                                         NaN              360000.0   \n",
       "10                            Floor Plan-Open               52700.0   \n",
       "11                                       Flat               24300.0   \n",
       "12                            Floor Plan-Open              518700.0   \n",
       "13                                        NaN                   NaN   \n",
       "14                     Floor Plan-Traditional               32600.0   \n",
       "15                            Floor Plan-Open              545000.0   \n",
       "16                            Floor Plan-Open              427500.0   \n",
       "17                                        NaN              460000.0   \n",
       "18                            Floor Plan-Open                   NaN   \n",
       "19                            Floor Plan-Open              688800.0   \n",
       "20                            Floor Plan-Open                   NaN   \n",
       "21                                 Efficiency               21700.0   \n",
       "22                     Floor Plan-Traditional              590000.0   \n",
       "23                                        NaN                   NaN   \n",
       "24                            Floor Plan-Open                   NaN   \n",
       "25                            Floor Plan-Open               38400.0   \n",
       "26                            Floor Plan-Open                   NaN   \n",
       "27                     Floor Plan-Traditional               52400.0   \n",
       "28                                        NaN                   NaN   \n",
       "29                            Floor Plan-Open               39200.0   \n",
       "...                                       ...                   ...   \n",
       "3054                                      NaN                   NaN   \n",
       "3055                          Floor Plan-Open               33800.0   \n",
       "3056                          Floor Plan-Open              410800.0   \n",
       "3057                                    Other               44800.0   \n",
       "3058                          Floor Plan-Open               93900.0   \n",
       "3059                          Floor Plan-Open               67400.0   \n",
       "3060                                      NaN              610000.0   \n",
       "3061                   Floor Plan-Traditional              608900.0   \n",
       "3062                                      NaN              636000.0   \n",
       "3063                          Floor Plan-Open              725000.0   \n",
       "3064                          Floor Plan-Open              287000.0   \n",
       "3065                                      NaN              600000.0   \n",
       "3066                          Floor Plan-Open               60800.0   \n",
       "3067                   Floor Plan-Traditional               40500.0   \n",
       "3068                                      NaN              354100.0   \n",
       "3069                          Floor Plan-Open                   NaN   \n",
       "3070                                      NaN              270000.0   \n",
       "3071                                      NaN              615300.0   \n",
       "3072                   Floor Plan-Traditional               49000.0   \n",
       "3073                          Floor Plan-Open                   NaN   \n",
       "3074                   Floor Plan-Traditional               58600.0   \n",
       "3075                                     Loft                   NaN   \n",
       "3076                          Floor Plan-Open                   NaN   \n",
       "3077  Floor Plan-Traditional, Floor Plan-Open                   NaN   \n",
       "3078                          Floor Plan-Open                   NaN   \n",
       "3079                                     Loft                   NaN   \n",
       "3080                                      NaN              400000.0   \n",
       "3081                   Floor Plan-Traditional               22400.0   \n",
       "3082                                      NaN              400000.0   \n",
       "3083                                      NaN              552000.0   \n",
       "\n",
       "     LandAssessmentPaymentFreq  Stories    ListDate  ListPrice  \\\n",
       "0                     Annually        1  2015-02-27   192500.0   \n",
       "1                     Annually        1  2015-06-22  1850000.0   \n",
       "2                     Annually        4  2015-09-08  1695000.0   \n",
       "3                     Annually        3  2015-09-20   475000.0   \n",
       "4                     Annually        1  2016-12-10   365000.0   \n",
       "5                     Annually        3  2017-03-09   765000.0   \n",
       "6                     Annually        3  2017-03-07   899000.0   \n",
       "7                     Annually        1  2017-03-24   399900.0   \n",
       "8                     Annually        1  2017-05-09   313000.0   \n",
       "9                     Annually        3  2017-07-05   642144.0   \n",
       "10                    Annually        1  2017-08-16   565000.0   \n",
       "11                    Annually        1  2015-10-20   150000.0   \n",
       "12                    Annually        3  2016-01-05  1999900.0   \n",
       "13                         NaN        2  2016-01-18   979000.0   \n",
       "14                    Annually        1  2016-02-24   419999.0   \n",
       "15                    Annually        4  2016-03-03  1749000.0   \n",
       "16                    Annually        3  2016-03-24  1149900.0   \n",
       "17                    Annually        4  2016-04-03  1099000.0   \n",
       "18                         NaN        4  2016-04-06   740285.0   \n",
       "19                    Annually        3  2016-04-13  1649900.0   \n",
       "20                         NaN        4  2016-04-12  1249888.0   \n",
       "21                    Annually        1  2016-04-13   249900.0   \n",
       "22                    Annually        2  2016-04-16   929000.0   \n",
       "23                         NaN        3  2016-05-06  1888000.0   \n",
       "24                         NaN        4  2016-04-21   829900.0   \n",
       "25                    Annually        1  2016-04-26   240000.0   \n",
       "26                         NaN        4  2016-05-03   809900.0   \n",
       "27                    Annually        1  2016-05-11   274900.0   \n",
       "28                         NaN        4  2016-05-18  2295000.0   \n",
       "29                    Annually        1  2016-06-02   249999.0   \n",
       "...                        ...      ...         ...        ...   \n",
       "3054                       NaN        4  2016-12-30   751955.0   \n",
       "3055                  Annually        1  2017-12-14   324900.0   \n",
       "3056                  Annually        3  2017-12-12  1000000.0   \n",
       "3057                  Annually        1  2017-12-14   389900.0   \n",
       "3058                  Annually        2  2017-12-15   950000.0   \n",
       "3059                  Annually        0  2017-02-14   485000.0   \n",
       "3060                  Annually        2  2017-12-18   865000.0   \n",
       "3061                  Annually        2  2017-10-31   872000.0   \n",
       "3062                  Annually        3  2017-11-10   980000.0   \n",
       "3063                  Annually        4  2017-11-21  1949900.0   \n",
       "3064                  Annually        4  2017-10-05   755000.0   \n",
       "3065                  Annually        2  2017-12-21   795000.0   \n",
       "3066                  Annually        3  2017-03-09   726275.0   \n",
       "3067                  Annually        1  2017-11-10   650000.0   \n",
       "3068                  Annually        2  2017-12-29   466625.0   \n",
       "3069                       NaN        1  2017-03-01  1499900.0   \n",
       "3070                  Annually        4  2017-12-31   854755.0   \n",
       "3071                  Annually        2  2017-10-13   650000.0   \n",
       "3072                  Annually        1  2017-11-21   234900.0   \n",
       "3073                       NaN        3  2017-05-17   719900.0   \n",
       "3074                  Annually        3  2017-11-27   585000.0   \n",
       "3075                       NaN        2  2017-02-10  1250724.0   \n",
       "3076                       NaN        1  2017-01-20   939900.0   \n",
       "3077                       NaN        2  2017-01-22  1205900.0   \n",
       "3078                       NaN        1  2017-09-01   971900.0   \n",
       "3079                       NaN        2  2017-03-01   849900.0   \n",
       "3080                  Annually        4  2017-04-14   867604.0   \n",
       "3081                  Annually        1  2017-06-20   159000.0   \n",
       "3082                  Annually        4  2017-05-27   949990.0   \n",
       "3083                  Annually        3  2017-02-24   656000.0   \n",
       "\n",
       "      ListingLowPrice    ListingType  Longitude   ListingID  \\\n",
       "0            192500.0    Excl. Right -77.096760   AR8563022   \n",
       "1           1850000.0    Excl. Right -77.073770   AR8673996   \n",
       "2           1695000.0    Excl. Right -77.130370   AR8742330   \n",
       "3            475000.0    Excl. Right -77.090230   AR8747453   \n",
       "4            365000.0    Excl. Right -77.083800   AR9823220   \n",
       "5            765000.0    Excl. Right -77.119080   AR9882001   \n",
       "6            899000.0    Excl. Right -77.102050   AR9881038   \n",
       "7            399900.0    Excl. Right -77.079100   AR9895940   \n",
       "8            313000.0    Excl. Right -77.097465   AR9941117   \n",
       "9            642144.0    Excl. Right -77.167080   AR9988772   \n",
       "10           565000.0    Excl. Right -77.162653   AR9010756   \n",
       "11           150000.0    Excl. Right -77.119080   AR9501967   \n",
       "12          1999900.0    Excl. Right -77.129570   AR9546034   \n",
       "13           979000.0   Excl. Agency -77.110890   AR9555136   \n",
       "14           419999.0   Excl. Agency -77.114370   AR9578263   \n",
       "15          1749000.0  Modified/Excl -77.155344   AR9585142   \n",
       "16          1149900.0    Excl. Right -77.056092   AR9605099   \n",
       "17          1099000.0    Excl. Right -77.126214   AR9615310   \n",
       "18           740285.0   Excl. Agency -77.073900   AR9618603   \n",
       "19          1649900.0    Excl. Right -77.158123   AR9625262   \n",
       "20          1249888.0    Excl. Right -77.085140   AR9624755   \n",
       "21           249900.0    Excl. Right -77.109480   AR9625903   \n",
       "22           929000.0    Excl. Right -77.112880   AR9629124   \n",
       "23          1888000.0    Excl. Right -77.093210   AR9631923   \n",
       "24           829900.0   Excl. Agency -77.072590   AR9634927   \n",
       "25           240000.0    Excl. Right -77.112836   AR9639067   \n",
       "26           809900.0   Excl. Agency -77.073290   AR9646368   \n",
       "27           274900.0    Excl. Right -77.108866   AR9654407   \n",
       "28          2295000.0    Excl. Right -77.145620   AR9661083   \n",
       "29           249999.0    Excl. Right -77.112643   AR9675673   \n",
       "...               ...            ...        ...         ...   \n",
       "3054         751955.0    Excl. Right -77.072630  AR10117538   \n",
       "3055         324900.0    Excl. Right -77.115720  AR10118991   \n",
       "3056        1000000.0    Excl. Right -77.088390  AR10119050   \n",
       "3057         389900.0    Excl. Right -77.081490  AR10120026   \n",
       "3058         950000.0    Excl. Right -77.079370  AR10120801   \n",
       "3059         485000.0    Excl. Right -77.051547  AR10121715   \n",
       "3060         865000.0    Excl. Right -77.123850  AR10122043   \n",
       "3061         872000.0    Excl. Right -77.118920  AR10122381   \n",
       "3062         980000.0    Excl. Right -77.102840  AR10122669   \n",
       "3063        1949900.0    Excl. Right -77.097540  AR10123038   \n",
       "3064         755000.0    Excl. Right -77.086220  AR10123175   \n",
       "3065         795000.0    Excl. Right -77.142310  AR10123182   \n",
       "3066         726275.0  Modified/Excl -77.074336  AR10125276   \n",
       "3067         650000.0    Excl. Right -77.076060  AR10125734   \n",
       "3068         466625.0    Excl. Right -77.116090  AR10125794   \n",
       "3069        1499900.0    Excl. Right -77.077760  AR10125930   \n",
       "3070         854755.0    Excl. Right -77.073142  AR10126594   \n",
       "3071         650000.0    Excl. Right -77.126380  AR10126669   \n",
       "3072         234900.0    Excl. Right -77.106470  AR10127109   \n",
       "3073         719900.0   Excl. Agency -77.073900  AR10130028   \n",
       "3074         585000.0    Excl. Right -77.091601  AR10132615   \n",
       "3075        1250724.0    Excl. Right -77.077760  AR10132004   \n",
       "3076         939900.0    Excl. Right -77.077760  AR10138138   \n",
       "3077        1205900.0    Excl. Right -77.077760  AR10138178   \n",
       "3078         971900.0    Excl. Right -77.077760  AR10138196   \n",
       "3079         849900.0    Excl. Right -77.077760  AR10149248   \n",
       "3080         867604.0  Modified/Excl -77.134070  AR10150737   \n",
       "3081         159000.0    Excl. Right -77.069365  AR10153179   \n",
       "3082         949990.0   Excl. Agency -77.133797  AR10155430   \n",
       "3083         656000.0    Excl. Right -77.118140  AR10157944   \n",
       "\n",
       "      OriginalListPrice   Ownership  \\\n",
       "0              229000.0       Condo   \n",
       "1             2800000.0       Condo   \n",
       "2             1751000.0  Fee Simple   \n",
       "3              450000.0  Fee Simple   \n",
       "4              369000.0       Condo   \n",
       "5              765000.0  Fee Simple   \n",
       "6              899000.0  Fee Simple   \n",
       "7              399900.0       Condo   \n",
       "8              316000.0       Condo   \n",
       "9              642144.0  Fee Simple   \n",
       "10             574900.0       Condo   \n",
       "11             180000.0       Condo   \n",
       "12            1999900.0  Fee Simple   \n",
       "13             999000.0  Fee Simple   \n",
       "14             435000.0       Condo   \n",
       "15            1749000.0  Fee Simple   \n",
       "16            1269000.0  Fee Simple   \n",
       "17            1199888.0  Fee Simple   \n",
       "18             724900.0  Fee Simple   \n",
       "19            1699000.0  Fee Simple   \n",
       "20            1349888.0  Fee Simple   \n",
       "21             249900.0       Condo   \n",
       "22             995000.0  Fee Simple   \n",
       "23            2000000.0  Fee Simple   \n",
       "24             819900.0  Fee Simple   \n",
       "25             270000.0       Condo   \n",
       "26             809900.0  Fee Simple   \n",
       "27             315000.0       Condo   \n",
       "28            2295000.0  Fee Simple   \n",
       "29             275000.0       Condo   \n",
       "...                 ...         ...   \n",
       "3054           751955.0  Fee Simple   \n",
       "3055           324900.0       Condo   \n",
       "3056          1000000.0  Fee Simple   \n",
       "3057           409900.0       Condo   \n",
       "3058           950000.0       Condo   \n",
       "3059           485000.0       Condo   \n",
       "3060           865000.0  Fee Simple   \n",
       "3061           872000.0  Fee Simple   \n",
       "3062           980000.0  Fee Simple   \n",
       "3063          1949900.0  Fee Simple   \n",
       "3064           755000.0  Fee Simple   \n",
       "3065           795000.0  Fee Simple   \n",
       "3066           726275.0       Condo   \n",
       "3067           650000.0       Condo   \n",
       "3068           466625.0  Fee Simple   \n",
       "3069          1499900.0       Condo   \n",
       "3070           854755.0  Fee Simple   \n",
       "3071           650000.0  Fee Simple   \n",
       "3072           234900.0       Condo   \n",
       "3073           719900.0       Condo   \n",
       "3074           594000.0       Condo   \n",
       "3075          1250724.0       Condo   \n",
       "3076           939900.0       Condo   \n",
       "3077          1205900.0       Condo   \n",
       "3078           971900.0       Condo   \n",
       "3079           849900.0       Condo   \n",
       "3080           867604.0  Fee Simple   \n",
       "3081           159000.0        Coop   \n",
       "3082           949990.0  Fee Simple   \n",
       "3083           656000.0  Fee Simple   \n",
       "\n",
       "                                                Parking PropertyType  \\\n",
       "0                                            Unassigned  Residential   \n",
       "1                                                Garage  Residential   \n",
       "2     Garage, Basement Garage, Drvwy/Off Str, Paved ...  Residential   \n",
       "3                                                Street  Residential   \n",
       "4                                                Street  Residential   \n",
       "5                                 Garage, Drvwy/Off Str  Residential   \n",
       "6     Drvwy/Off Str, Garage, Paved Driveway, Asphalt...  Residential   \n",
       "7     Assigned, Covered Parking, Garage, Prk Space C...  Residential   \n",
       "8                                   Unassigned, Surface  Residential   \n",
       "9                                                Garage  Residential   \n",
       "10                                             Assigned  Residential   \n",
       "11                                    Assigned, Surface  Residential   \n",
       "12                                Garage, Drvwy/Off Str  Residential   \n",
       "13                                Drvwy/Off Str, Garage  Residential   \n",
       "14                                          Underground  Residential   \n",
       "15                                               Garage  Residential   \n",
       "16    Drvwy/Off Str, Garage, Paved Driveway, Street,...  Residential   \n",
       "17                                               Garage  Residential   \n",
       "18           Garage, Garage Door Opener, Paved Driveway  Residential   \n",
       "19                                               Garage  Residential   \n",
       "20                                       Paved Driveway  Residential   \n",
       "21                                     On-site Prk/Rent  Residential   \n",
       "22                                Drvwy/Off Str, Garage  Residential   \n",
       "23                                               Garage  Residential   \n",
       "24           Garage, Garage Door Opener, Paved Driveway  Residential   \n",
       "25                                          Parking Fee  Residential   \n",
       "26           Garage, Garage Door Opener, Paved Driveway  Residential   \n",
       "27                 Permit Required, Unassigned, Surface  Residential   \n",
       "28                                               Garage  Residential   \n",
       "29                                          Parking Fee  Residential   \n",
       "...                                                 ...          ...   \n",
       "3054                                             Garage  Residential   \n",
       "3055                                           Assigned  Residential   \n",
       "3056                                             Garage  Residential   \n",
       "3057                                           Assigned  Residential   \n",
       "3058                                             Garage  Residential   \n",
       "3059                                             Garage  Residential   \n",
       "3060                                      Drvwy/Off Str  Residential   \n",
       "3061                                             Garage  Residential   \n",
       "3062                                              Other  Residential   \n",
       "3063  Drvwy/Off Str, Garage, Detached, Garage Door O...  Residential   \n",
       "3064                                     Garage, Street  Residential   \n",
       "3065                                      Drvwy/Off Str  Residential   \n",
       "3066                                      Drvwy/Off Str  Residential   \n",
       "3067                      Garage, Assigned, Underground  Residential   \n",
       "3068                                               None  Residential   \n",
       "3069                                             Garage  Residential   \n",
       "3070                                             Garage  Residential   \n",
       "3071                                             Garage  Residential   \n",
       "3072    Gen Comm Elem, Permit Required, Prk Space Cnvys  Residential   \n",
       "3073         Garage, Garage Door Opener, Paved Driveway  Residential   \n",
       "3074                                           Assigned  Residential   \n",
       "3075                                             Garage  Residential   \n",
       "3076                                             Garage  Residential   \n",
       "3077                                             Garage  Residential   \n",
       "3078                                             Garage  Residential   \n",
       "3079                                           Assigned  Residential   \n",
       "3080                                             Garage  Residential   \n",
       "3081                                   On-site Prk/Rent  Residential   \n",
       "3082                                    Basement Garage  Residential   \n",
       "3083                                      Drvwy/Off Str  Residential   \n",
       "\n",
       "                                                Remarks  ShowDays  \\\n",
       "0     This condo has been thoroughly renovated just ...       NaN   \n",
       "1     A blend of two homes-3,390 interior sqft. w/mu...  All Days   \n",
       "2     New Custom Arts and Crafts home by Calvert Hom...       NaN   \n",
       "3     Perfect location!  This is your client's oppor...  All Days   \n",
       "4     Fully updated 2BR/1BA corner unit in Colonial ...       NaN   \n",
       "5     Stylish, high end renovations of Georgetown st...  All Days   \n",
       "6     Fabulous location! Near Clarendon, Vir. Sq. & ...  All Days   \n",
       "7     When this condo was built, AHC purchased sever...  All Days   \n",
       "8     Sunny, pristine condo at West Village of Shirl...  All Days   \n",
       "9     Beautiful 3 BR, 3 BA End unit townhouse in Bro...  All Days   \n",
       "10    Spectacular 2 BR & DEN /2 BA in sought after W...  All Days   \n",
       "11    Price reduced for quick sell.Contract failed d...  All Days   \n",
       "12    Fabulous new design by Arlington's premier bui...  All Days   \n",
       "13    This is an MLS Placement Limited Service Listi...  All Days   \n",
       "14    LUXURY 2 BR condo in the heart of Ballston!  F...  All Days   \n",
       "15    Looking for new construction but tired of the ...  All Days   \n",
       "16    MASSIVE PRICE DROP ~ This hard-to-find Arlingt...  All Days   \n",
       "17    ***OWNER SAYS SELL***BRING ALL OFFERS***1 Mile...  All Days   \n",
       "18    Introducing Carver Place, an exciting new cons...  All Days   \n",
       "19    Move in ready! Modern Craftsman on 1/3 acre at...       NaN   \n",
       "20    Ultra Luxurious custom home in the heart of Ar...       NaN   \n",
       "21    Enjoy Beautiful Sunset from your balcony,Or wa...  All Days   \n",
       "22    Schedule showings online through showingtime. ...  All Days   \n",
       "23    Exotic-European Flair & Noble Ambiance! Luxury...       NaN   \n",
       "24    Home is currently under construction. End Unit...  All Days   \n",
       "25    Please notice this is a Retirement Community. ...       NaN   \n",
       "26    Home is currently under construction. 2580 sq ...  All Days   \n",
       "27    Please see documents for disclosures & conveya...       NaN   \n",
       "28    Completed in March '17. A frame design on one ...  All Days   \n",
       "29    Monthly Service Fee of $3,170.00 is not option...       NaN   \n",
       "...                                                 ...       ...   \n",
       "3054                                 Comp purposes only       NaN   \n",
       "3055  MULTIPLE OFFERS RECEIVED - SUNDAY OPEN HOUSE C...  All Days   \n",
       "3056  **Sun Filled Custom Built Home**Minutes to Was...  All Days   \n",
       "3057  Contact ShowingTime at 800-746-9464. Direct al...       NaN   \n",
       "3058  Bright 2 bed 2.5 bath Unit Only blocks to shop...       NaN   \n",
       "3059                                Comp Purposes Only.       NaN   \n",
       "3060  Sold to builder before going on the market. So...       NaN   \n",
       "3061  Sold privately \"as is.\"   Entered for comp pur...       NaN   \n",
       "3062  Comp purposes only. Purchased from builder pri...       NaN   \n",
       "3063  Contact Alt Listing Agent  Bridget Hodge @ 703...  All Days   \n",
       "3064               immaculate home in Shirlington Crest       NaN   \n",
       "3065  For comp purposes only. Off market sale. Buyer...       NaN   \n",
       "3066                               Settled on 8/11/2017  All Days   \n",
       "3067  Stunning 12th floor condo with sweeping views ...       NaN   \n",
       "3068                                                  .       NaN   \n",
       "3069  Entered for Comparative Purposes.  Selling Age...       NaN   \n",
       "3070                                               None       NaN   \n",
       "3071  Entered for comp purposes only.  Home needed u...       NaN   \n",
       "3072  Call Alt Agent Sarah Noel with questions. SCHE...  All Days   \n",
       "3073  Arlington's fastest selling community.  Conven...  All Days   \n",
       "3074                For comp purposes, sold off-market.       NaN   \n",
       "3075  Gaslight Select.... New Construction by Abdo.....       NaN   \n",
       "3076       2 Bedroom Flat for comparable purposes only.       NaN   \n",
       "3077  For Comp purposes only. 2 bedroom loft unit, n...       NaN   \n",
       "3078  For Comp Purposes.  1st level 2 bedroom flat w...       NaN   \n",
       "3079                          Listing for comp purposes       NaN   \n",
       "3080  New Construction. Arlington Row.  For Comp Pur...       NaN   \n",
       "3081                                Great Rental Return       NaN   \n",
       "3082                                   New Construction       NaN   \n",
       "3083                         Entered for comps purposes       NaN   \n",
       "\n",
       "         StreetName  StreetNumber          Style ListingTaxID  \\\n",
       "0               5TH        3601.0   Contemporary   23-015-111   \n",
       "1               OAK        1600.0   Contemporary   17-003-291   \n",
       "2        GREENBRIER        1719.0  Arts & Crafts   09-016-016   \n",
       "3     FOUR MILE RUN        3723.0        Federal   31-030-066   \n",
       "4               KEY        2005.0        Rambler   16-026-213   \n",
       "5             GLEBE        1719.0       Colonial   07-025-004   \n",
       "6           KENMORE        1400.0    Traditional   15-039-029   \n",
       "7            WILSON        1800.0   Contemporary   17-010-138   \n",
       "8     FOUR MILE RUN        4195.0   Contemporary   27-007-579   \n",
       "9           FAIRFAX        6961.0    Traditional   01-010-041   \n",
       "10     WESTMORELAND        2200.0   Contemporary   11-011-118   \n",
       "11       GREENBRIER         832.0          Other   22-011-212   \n",
       "12         BUCHANAN        2704.0       Colonial   02-088-046   \n",
       "13       S PERSHING          28.0      Craftsman   23-004-026   \n",
       "14          VERMONT        1001.0    Traditional   14-017-152   \n",
       "15             31ST        6318.0     Farm House   01-021-002   \n",
       "16             29TH         664.0   Contemporary   37-027-040   \n",
       "17         CULPEPER        2004.0  Arts & Crafts   08-011-032   \n",
       "18         S. QUINN        1309.0      Craftsman         0.00   \n",
       "19         SOMERSET        2834.0      Craftsman   01-019-030   \n",
       "20              1ST        2408.0      Craftsman   24-005-007   \n",
       "21        HENDERSON        4141.0   Contemporary   20-012-223   \n",
       "22             27TH        4118.0    Split Foyer   05-001-027   \n",
       "23         GARFIELD         412.0       Colonial   18-049-013   \n",
       "24         S. QUINN        1319.0      Craftsman         0.00   \n",
       "25           TAYLOR         900.0    Traditional   14-051-227   \n",
       "26     13TH ROAD S.        1715.0      Craftsman         0.00   \n",
       "27         PERSHING        4366.0       Colonial   20-026-360   \n",
       "28       KENSINGTON        2907.0        A-Frame       000000   \n",
       "29           TAYLOR         900.0    Traditional   14-051-201   \n",
       "...             ...           ...            ...          ...   \n",
       "3054          QUINN        1311.0  Arts & Crafts          NaN   \n",
       "3055            LEE        4360.0          Other   07-012-048   \n",
       "3056       FILLMORE         117.0       Colonial   24-001-131   \n",
       "3057         BARTON        1633.0          Other   32-001-618   \n",
       "3058         RHODES        1418.0   Contemporary   17-023-090   \n",
       "3059          GLEBE        3600.0   Contemporary   34-027-243   \n",
       "3060           UTAH        3546.0        Rambler   03-036-108   \n",
       "3061           38TH        3650.0    Split Foyer   04-036-010   \n",
       "3062           14TH        3450.0       Cape Cod   15-081-028   \n",
       "3063         HUDSON        1307.0      Craftsman   15-073-001   \n",
       "3064        KENMORE        2616.0        Federal   31-033-205   \n",
       "3065           32ND        5212.0        Rambler   02-025-011   \n",
       "3066          ROLFE        1338.0       Colonial   33-007-074   \n",
       "3067            KEY        1530.0   Contemporary   16-034-343   \n",
       "3068           11TH        5225.0       Colonial   28-005-024   \n",
       "3069           16TH        1701.0   Contemporary          NaN   \n",
       "3070           13TH        1709.0       Colonial   33-007-043   \n",
       "3071           16TH        5130.0        Rambler   09-031-011   \n",
       "3072            2ND        4312.0       Colonial   20-028-044   \n",
       "3073       S. QUINN        1336.0      Craftsman         0.00   \n",
       "3074    S WAKEFIELD        3458.0       Colonial   30-021-642   \n",
       "3075    16TH STREET        1701.0   Contemporary   17-008-091   \n",
       "3076        16TH ST        1701.0   Contemporary   17-008-122   \n",
       "3077           16TH        1701.0   Contemporary   17-008-109   \n",
       "3078           16TH        1701.0   Contemporary   17-008-120   \n",
       "3079     16TH ST. N        1701.0   Contemporary       125356   \n",
       "3080           11TH        5709.0          Other   09-064-022   \n",
       "3081      ARLINGTON        1121.0   Transitional   17-039-181   \n",
       "3082     KENSINGTON        1120.0   Contemporary   09-064-034   \n",
       "3083          GLEBE        1401.0          Tudor   07-042-005   \n",
       "\n",
       "      TotalAssessment  TotalOpenHouses  TotalShowings  LivingArea  TotalTaxes  \\\n",
       "0              190500                0              0        1011     1897.38   \n",
       "1             1770000                0              0        3390    17629.00   \n",
       "2              748100                0              0        5994     7451.08   \n",
       "3              342000                0              1           0     3406.32   \n",
       "4              346300                0              0         852     3431.80   \n",
       "5              764900                0              0        1854     7580.14   \n",
       "6              804700                0              1           0     7974.56   \n",
       "7              365700                0              1         718     3624.08   \n",
       "8              307700                0              0         851     3049.30   \n",
       "9              564700                0              0           0     5596.16   \n",
       "10             492800                0              1        1172     4883.64   \n",
       "11             115800                0              0         695     1153.37   \n",
       "12             660700                0              0        6305     6580.57   \n",
       "13                  0                0              0        3200         NaN   \n",
       "14             421300                0              0         814     4196.15   \n",
       "15             650200                0              0        5500     6475.99   \n",
       "16            1023300                0              0        3493     9678.13   \n",
       "17            1069900                0              1        6550    10656.20   \n",
       "18                  0                0              0        2080         NaN   \n",
       "19            1459500                0              1        5035     7662.38   \n",
       "20                  0                0              0        3977         NaN   \n",
       "21             244900                0              0         542     2439.20   \n",
       "22             848500                0              1        2349     8451.06   \n",
       "23                  0                0              0        5750         NaN   \n",
       "24                  0                0              0        2580         NaN   \n",
       "25             133400                0              0         960     1328.66   \n",
       "26                  0                0              0        2580         NaN   \n",
       "27             263300                0              0         936     2622.47   \n",
       "28                  0                0              0        7078         NaN   \n",
       "29             161400                0              0         981     1607.54   \n",
       "...               ...              ...            ...         ...         ...   \n",
       "3054                0                0              0           0         NaN   \n",
       "3055           273800                0              0         938     2713.34   \n",
       "3056          1099500                0              0        4326    10896.02   \n",
       "3057           406800                0              0        1120     4031.38   \n",
       "3058           810000                0              0        1878     8027.10   \n",
       "3059           456600                0              0        1123     4524.88   \n",
       "3060           739900                0              0           0     7332.40   \n",
       "3061           846200                0              0           0     8512.76   \n",
       "3062           758300                0              0           0     7628.46   \n",
       "3063          1784500                0              0        4894    17684.38   \n",
       "3064           643200                0              0        2049     6470.56   \n",
       "3065           747900                0              0           0     7523.86   \n",
       "3066            60800                0              0        2202      611.64   \n",
       "3067           587000                0              0        1125     5905.20   \n",
       "3068           490600                0              0           0     4935.40   \n",
       "3069                0                0              0        1880         NaN   \n",
       "3070           452000                0              0        2496     4547.12   \n",
       "3071           758700                0              0           0     7632.50   \n",
       "3072           229400                0              0         875     2273.34   \n",
       "3073                0                0              0        2879         NaN   \n",
       "3074           520500                0              0        1830     5236.22   \n",
       "3075                0                0              0        1650         NaN   \n",
       "3076                0                0              0        1337         NaN   \n",
       "3077                0                0              0        1875         NaN   \n",
       "3078                0                0              0        1337         NaN   \n",
       "3079                0                0              0        1024         NaN   \n",
       "3080           400000                0              0           0     4024.00   \n",
       "3081           166300                0              0         559     1672.94   \n",
       "3082           400000                0              0           0     4024.00   \n",
       "3083           700100                0              0           0     7042.98   \n",
       "\n",
       "      TotalTours                 Type  YearBuilt    Zip4  PostalCode  \n",
       "0              1  Mid-Rise 5-8 Floors       1958  1636.0       22204  \n",
       "1              1    Hi-Rise 9+ Floors       1986  2760.0       22209  \n",
       "2              1             Detached       2016  3629.0       22205  \n",
       "3              1        Semi-Detached       1945  2332.0       22206  \n",
       "4              0    Garden 1-4 Floors       1940     NaN       22201  \n",
       "5              1             Detached       1937  2037.0       22207  \n",
       "6              2             Detached       1942  4912.0       22201  \n",
       "7              3    Garden 1-4 Floors       2007  6604.0       22201  \n",
       "8              2    Garden 1-4 Floors       1966  3986.0       22204  \n",
       "9              1            Townhouse       1988  1008.0       22213  \n",
       "10             2  Mid-Rise 5-8 Floors       2006  1051.0       22213  \n",
       "11             1    Garden 1-4 Floors       1948  2712.0       22204  \n",
       "12             0             Detached       2017  2725.0       22207  \n",
       "13             1             Detached       2016  1356.0       22204  \n",
       "14             1    Hi-Rise 9+ Floors       2005  4766.0       22201  \n",
       "15             1             Detached       2015  1123.0       22207  \n",
       "16             1             Detached       1990  2315.0       22202  \n",
       "17             2             Detached       2008  2005.0       22207  \n",
       "18             1            Townhouse       2016     NaN       22204  \n",
       "19             3             Detached       2016  1219.0       22213  \n",
       "20             2             Detached       2016  1823.0       22204  \n",
       "21             1    Hi-Rise 9+ Floors       1973  2467.0       22203  \n",
       "22             3             Detached       1965  5116.0       22207  \n",
       "23             2             Detached       2005  1610.0       22201  \n",
       "24             1            Townhouse       2016     NaN       22204  \n",
       "25             2    Hi-Rise 9+ Floors       1992  1890.0       22203  \n",
       "26             1            Townhouse       2016     NaN       22204  \n",
       "27             1    Garden 1-4 Floors       1940     NaN       22203  \n",
       "28             1             Detached       2016     NaN       22207  \n",
       "29             1    Hi-Rise 9+ Floors       1992  1873.0       22203  \n",
       "...          ...                  ...        ...     ...         ...  \n",
       "3054           0            Townhouse       2017     NaN       22204  \n",
       "3055           2    Garden 1-4 Floors       1964  3231.0       22207  \n",
       "3056           1             Detached       2006  1838.0       22204  \n",
       "3057           1    Garden 1-4 Floors       1985  4856.0       22204  \n",
       "3058           0    Garden 1-4 Floors       2010     NaN       22209  \n",
       "3059           0    Hi-Rise 9+ Floors       2006     NaN       22202  \n",
       "3060           0             Detached       1953  4444.0       22207  \n",
       "3061           0             Detached       1959  4824.0       22207  \n",
       "3062           0             Detached       1949  4910.0       22201  \n",
       "3063           1             Detached       2007  5015.0       22201  \n",
       "3064           0            Townhouse       2008  2365.0       22206  \n",
       "3065           0             Detached       1955  1503.0       22207  \n",
       "3066           0            Townhouse       2017  4750.0       22204  \n",
       "3067           0    Hi-Rise 9+ Floors       1986  1543.0       22209  \n",
       "3068           0             Detached       1947  3216.0       22204  \n",
       "3069           0    Garden 1-4 Floors       2017     NaN       22209  \n",
       "3070           0            Townhouse       2016  4720.0       22204  \n",
       "3071           0             Detached       1952  2644.0       22205  \n",
       "3072           1    Garden 1-4 Floors       1940  2970.0       22203  \n",
       "3073           1            Townhouse       2017     NaN       22204  \n",
       "3074           1            Townhouse       1940  1706.0       22206  \n",
       "3075           0               Duplex       2017     NaN       22209  \n",
       "3076           0    Garden 1-4 Floors       2017     NaN       22209  \n",
       "3077           0  Mid-Rise 5-8 Floors       2017     NaN       22209  \n",
       "3078           0  Mid-Rise 5-8 Floors       2017     NaN       22209  \n",
       "3079           0       Attach/Row Hse       2017     NaN       22209  \n",
       "3080           0            Townhouse       2017  2303.0       22205  \n",
       "3081           0    Hi-Rise 9+ Floors       1955  3226.0       22209  \n",
       "3082           0            Townhouse       2017  3532.0       22205  \n",
       "3083           0             Detached       1926  2119.0       22207  \n",
       "\n",
       "[3084 rows x 55 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "house_df = pd.read_csv(\"Arlington_County_Sales_2017.csv\")\n",
    "house_df.head()\n",
    "pd.set_option(\"display.max_columns\", 500)\n",
    "counter = 0\n",
    "for column in house_df:\n",
    "\n",
    "    if house_df[column].isnull().sum()>= 1000:\n",
    "        house_df.drop(column, axis=1, inplace = True)\n",
    "house_df.to_csv(\"Trimmed\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}