added

[August 23, 2024] 12 New Bulk Data POST Endpoints, Investor Insights, Enhanced Property Search, and Performance Boost

v0.17.0

v0.17.0 brings powerful new tools for bulk data retrieval, deeper insights into property ownership, and substantial performance improvements.

What’s new:

  • 💪 12 new POST endpoints for bulk data retrieval across Rental, Investor, and Portfolio metrics
  • 💰 Added investor_flag and entity_owner_name fields to all property events
  • 🚀 Redesigned property search with optimized performance for bulk property data pulls
  • 🛠️ Significant performance enhancements and bug fixes across the API and SDK

Read on for full details:

12 New POST Endpoints for Bulk Data Retrieval

We've added 12 new POST endpoints across Rental Market Metrics, Investor Metrics, and Portfolio Metrics categories. These endpoints allow you to retrieve data for up to 1000 parcl_ids in a single request, enabling efficient bulk data collection across multiple markets.

Rental Market Metrics (3 new endpoints):

  • Gross Yield: Get percent gross yield for specified parcl_ids.
  • New Listings For Rent Rolling Counts: Get weekly updated rolling counts of newly listed rental properties.
  • Rental Units Concentration: Get rental unit counts, total units, and rental concentration percentages.

Investor Metrics (5 new endpoints):

  • Housing Event Counts: Get monthly counts of investor housing events.
  • Housing Event Prices: Get monthly median prices for investor housing events.
  • Housing Stock Ownership: Get counts and percentages of investor-owned properties.
  • New Listings For Sale Rolling Counts: Get weekly updated rolling counts of investor-owned properties newly listed for sale.
  • Purchase To Sale Ratio: Get monthly investor purchase-to-sale ratios.

Portfolio Metrics (4 new endpoints):

  • SF Housing Event Counts: Get monthly counts of investor-owned single-family property events, segmented by portfolio size.
  • SF Housing Stock Ownership: Get counts and percentages of investor-owned single-family properties, segmented by portfolio size.
  • SF New Listings For Rent Rolling Counts: Get weekly updated rolling counts of investor-owned single-family properties newly listed for rent, segmented by portfolio size.
  • SF New Listings For Sale Rolling Counts: Get weekly updated rolling counts of investor-owned single-family properties newly listed for sale, segmented by portfolio size.

Enhanced Property Events

We've added two new fields to property events, providing deeper insights into involved owners for every event across sales, listings, and rentals:

  • investor_flag: A boolean flag indicating if the property is owned by an investor at the time of the event.
    • 0: Not investor-owned
    • 1: Investor-owned
    • NULL: Unknown status
  • entity_owner_name: The name of the entity that owns the property at the time of the event, if owned by a named large-scale operator. Possible values: AMH, TRICON, INVITATION_HOMES, HOME_PARTNERS_OF_AMERICA, NULL

Redesigned Property Search

We have introduced major enhancements to our property search API:

  • Pagination Removal: The /property/search endpoint now returns all properties matching the search parameters in a single request, eliminating pagination. Some queries may return over a million records at once.
  • Backend Optimization: We’ve implemented substantial backend optimizations to ensure efficient bulk data retrieval.
  • SDK Updates: The SDK has been refactored to align with these changes. Tutorials will be provided to guide users in handling large data pulls when querying the API directly.

Performance Enhancements and Bug Fixes

  • For the /property/event_history endpoint:
    • The endpoint can now support 10,000 parcl_property_ids in one request. Previously it was limited to 1,000
    • Fixed an issue where properties with null events for a given query were incorrectly exposed in the endpoint
  • Corrected the price_feed category POST endpoints to accept dates prior to January 01, 2019
  • Resolved an SDK bug to ensure accurate listing of units for bulk pulls (many markets)

As always, we welcome your feedback. Happy building!