Lone Stone Realty, a fictional real estate brokerage located in the Stone Oak area of San Antonio, Texas, has contracted you to provide an analysis of residential sales for the metropolitan area. Using sales information for the past year, they would like to use your services to get a better understanding of the underlying geographic patterns that influence their business, guide their potential expansion efforts, and assist with marketing efforts.

Lone Star Realty currently has a single office location in the Stone Oak area and a large percentage of their business is conducted in this area. The brokerage focuses on assisting buyers and sellers within a price range of $250,000 to $400,000, and for the most part, within a roughly 5 square miles radius of the neighborhood. They would like to have you analyze a dataset of all residential sales from the past year to determine what areas have experienced a high volume of sales...