The overall trend in housing units from 2010 to 2016 was an increase in the number of housing units. From 2010 to 2016, the number of housing units increased from 372,560 to 384,242, at an average rate of approximately 1.9%, with the highest increase occurring between 2015 and 2016.
The lowest gross price reported for the years included in the DataFrame is $1239.0
Did any year experience a drop in the average sale price per square foot compared to the previous year?
If so, did the gross rent increase or decrease during that year?
The sale price per square foot dropped between 2010 (369.34) and 2011(341.90).
The gross rent increased every year from 2010 to 2016. Therefore, even though there were slight dips along the way, the gross rent increased during that year.
For the Anza Vista neighborhood, is the average sale price per square foot for 2016 more or less than the price that’s listed for 2012?
To answer this question using the interactive line plot, we need to select "Anza Vista" from the dropdown selector widget for neighborhood and then compare the average sale price per square foot for 2012 and 2016.
Based on the plot, we can see that the average sale price per square foot for Anza Vista was lower in 2016(88.40) than it was in 2012(344.49).
Which neighborhood has the highest gross rent, and which has the highest sale price per square foot?
According to the geospatial visualisation, Union Square has the highest sale price per square foot at 903.99 and Westwood Park at 3959 is the highest gross rent.
Based on our analysis, we can see that there is a general upward trend in both rental income and sales prices across San Francisco from 2010 to 2016. However, the growth in rental income has been slower compared to the growth in sales prices. We can see that neighborhoods with higher sale prices per square foot also tend to have higher gross rent, but this trend does not hold true for all neighborhoods. For example, the neighborhoods of Presidio Heights and Seacliff have some of the highest sale prices per square foot, but their gross rent is not as high as other neighborhoods like South of Market and Pacific Heights.
What insights can you share with your company about the potential one-click, buy-and-rent strategy that they're pursuing?
Based on our analysis, it seems that the San Francisco real estate market has been experiencing steady growth in both rental income and sales prices, indicating that it may be a good time for investment in the city. However, it's important to note that the growth in rental income has been slower than the growth in sales prices, which may affect the profitability of a buy-and-rent strategy. As for specific neighborhoods to invest in, we suggest neighborhoods that have a combination of high sale prices per square foot and high gross rent, indicating a potential for high return on investment. Some neighborhoods that fit this criteria include Pacific Heights, Telegraph Hill, and South of Market. It's also important to consider other factors like vacancy rates, property taxes, and potential development projects in the area.
To help with this challenge I used the GeoViews & HoloViews Documentation for reference - https://holoviews.org/reference/index.html