OHFA Housing Stability homes
Eligible buyers stack 5% Down Payment Assistance (DPA) on top of OHFA's flagship 3.5%.
Sort homes
Program Snapshot
Statutory allocation, deployment, and revolving fund health.
Statewide Reach
Counties served by funded homes. Color intensity reflects rank-quartile by number of homes per county. Hover for the exact count.
Loading map…
Top 25%
50-75%
25-50%
Bottom 25%
None
Rural vs Urban Deployment
Award distribution reflects the statutory priority for rural and disaster-area sites.
Units Built & Sold by Developer
Proposed, Completed to Date, and Sold per development. Hover over any bar for the exact numbers.
Proposed Units
Completed to Date
Units Sold
Capital Cycling
Where the $100.7M actually lives. Awarded dollars deploy out, repayments and interest cycle back in.
Award Concentration
Are a handful of large developments swallowing most of the funding, or is it spread across many builds? Each card below shows what share of the total awarded dollars goes to the top 5, 10, 15, and 25 developments.
Build-out Velocity
Per development: completed and sold units against proposed. Sorted by completion rate. Helps surface who is delivering vs who is stalled.
Loan Expiration Timeline
Funded developments by time-to-loan-expiration. Capital at risk if loans are not repaid by the expiration date.
Funded Developments
Loan awards under the Housing Stability Program, sorted by award size.
Roadmap: Production Data Sources
What this storefront could automate with the right data feeds, and where we hit real limits today.
PHASE 2 · AUTOMATION
MLS Feed → Listing Photos & Details
- Today, listing photos are stylized placeholders or developer-uploaded via the edit drawer.
- Production would automate this through an Internet Data Exchange (IDX) feed from the MLS covering each county.
SourceMLSOK (metro), NORES (NE OK), GFAR (Tulsa-area)
ProtocolRESO Web API (REST/JSON, modern) or RETS (legacy)
Auto-pullsPhotos, descriptions, room counts, lot specs, listing agent contact, status changes
Sync cadence15-min refresh, fully hands-off
RequirementsLicensed agent on the IDX agreement, vendor approval, ~$50–200/mo per MLS
Coverage~100% of homes once listed (under-construction listings appear when builder activates)
Until IDX is in place:
- Storefront pulls Zillow URLs from column M when OHFA pastes a curated link via the edit drawer.
- Falls back to a clean "no Zillow button" state otherwise.
- Photos route through the developer-upload path: each builder drops marketing renderings into the Drive folder we provision per JOB ID.
Recommended path:
- Partner with a licensed sponsor on the MLSOK IDX agreement first (covers OKC metro, where most OHFA volume sits).
- Expand to NORES + GFAR as listings reach the rest of the state.
- Estimated build: 1 to 2 weeks once IDX credentials are approved.
DATA LIMITATION · SCHOOLS
Why Many Schools Show "No reviews yet"
- The Nearby Schools list on each listing pulls from Google Places API.
- Rural Oklahoma elementary and middle schools genuinely lack Google reviews. These places aren't where people leave restaurant-style feedback.
- Rural districts have small populations of potential reviewers to begin with.
- Even the highest paid Places tier returns the same empty review array because the data doesn't exist.
What Places gives usName, address, geo, type. for almost every school
What Places doesn'tTest scores, state ratings, demographics, enrollment
Reviews coverage~90% in OKC/Tulsa metros, ~25% in rural towns
Better data sources we could swap in:
SchoolDiggerPaid tier (~$30/mo). Test scores, state ratings, student/teacher ratios. Coverage: 100% of US public schools.
GreatSchoolsPartner API (application-gated, free for non-commercial). Composite 1–10 rating per school, used by Zillow + Redfin.
NCESFree federal dataset. Enrollment, demographics, district boundaries. No ratings.
OK State Dept of EducationA–F school report card data, free CSV downloads. Annual refresh only.
Recommended path:
- Swap to SchoolDigger for ratings + test scores across every Oklahoma public school.
- Keep Google Places only for address geocoding.
- Estimated build: half a day.
PHASE 2 · ZILLOW DEEP LINKS
Zillow Bulk Backfill
- Zillow shut down their public API in 2021.
- There is no clean way to ask "what's the Zillow URL for this address?" at scale.
- Direct scraping is Cloudflare-walled within ~3 requests.
- Search-engine detours (DuckDuckGo, etc.) get rate-limited around 30 requests.
MLSOK / NORES / GFAR (IDX)The durable fix. Pull listings directly from the Oklahoma MLSs and we no longer need a Zillow URL at all, embed the listing, photos, and status native. Requires a licensed agent sponsor on the IDX agreement + $50-200/mo per MLS. See the "MLS IDX" card above.
Brave Search APIFree tier: 2,000 queries/month. Could backfill the full ~450 listings across 4 days at zero cost.
Paid scraper (e.g. ScrapingBee)~$30 one-time covers full backfill in under an hour.
Manual via edit drawerAlready wired. OHFA pastes URLs as listings go live on Zillow. Cell empty = no button on that card.
Expected hit rate even on a clean backfill: 30 to 50%.
- Under-construction and lot-numbered rural addresses won't appear on Zillow until the MLS feed indexes them.
- Same reason MLS IDX (above) is the durable answer to this whole class of problem.
Recommended path:
- Skip Zillow entirely once MLS IDX is wired.
- In the interim, run a one-shot Brave Search backfill (free tier) for the existing ~450 listings.
- Keep the edit-drawer paste workflow open for OHFA on new builds.
- Estimated build: half a day for the Brave script.