Real Estate Tech

---
name: Real Estate Tech
description: Use when building property technology platforms with MLS integration, geospatial search, property valuation models, and listing management systems
category: Specialized
version: 1.0.0
tools: []
---

# Real Estate Technology Platform

Build platforms for property search, listing management, valuation, and transaction workflows. Integrate with MLS (Multiple Listing Service) data feeds, implement geospatial search and mapping, design automated valuation models, build transaction management systems supporting property lifecycle. Treat real estate data as messy and fragmented across hundreds of MLS systems requiring normalization and deduplication as foundational challenges.

## Data and Search Architecture

1. Design MLS data ingestion pipeline using RETS or RESO Web API standards pulling from multiple MLS sources, normalizing heterogeneous field names, data types, enumeration values into canonical schema with consistent address formatting and feature taxonomies.
2. Implement property deduplication matching listings across MLS sources using address normalization (USPS standardization), parcel number matching, fuzzy matching on characteristics.
3. Build geospatial search infrastructure using PostGIS or Elasticsearch geo queries, supporting bounding box searches for map interfaces, radius searches from points, polygon searches for neighborhoods, drive-time isochrone searches.
4. Design property search API with faceted filtering on type, price range, bedroom/bathroom counts, square footage, lot size, year built, listing status, implementing filters as composable query predicates.
5. Implement map-based property display using Mapbox or Google Maps with clustering for dense results, property pin customization, progressive loading fetching details on demand.
6. Build automated valuation model (AVM) using comparable sales analysis: select recent sales within defined radius/time window, adjust for property differences using hedonic regression coefficients, produce confidence-ranged estimates.
7. Design listing management workflow tracking status transitions (coming soon, active, pending, contingent, sold, withdrawn, expired) with validation rules and MLS compliance checks.
8. Implement property media pipeline ingesting photos, generating responsive variants (thumbnails, medium, full-size), extracting EXIF metadata, ordering by sequence, serving via CDN.
9. Build transaction management system tracking closing process: offer submission, acceptance, inspection, appraisal, financing contingencies, closing coordination, with document management and deadline tracking.
10. Design notification system alerting buyers to new listings matching saved searches with real-time matching against active searches, delivery via email, push, in-app alerts.

## Technical Standards

- Property addresses standardized using USPS normalization before storage and comparison preventing duplicate records.
- Geospatial queries use spatial indexes (GiST in PostGIS, geo_shape in Elasticsearch), never sequential scans on coordinate columns.
- MLS data feeds refreshed per MLS agreement (typically every 15 minutes for active listings), full reconciliation runs daily.
- Property photos served through CDN with WebP for supported browsers and JPEG fallback, lazy loading for below-fold images.
- Valuation models disclose confidence interval, comparable properties used, adjustment methodology for transparency.
- Listing status transitions enforce MLS business rules; invalid transitions rejected.
- All monetary values stored as integer cents with currency code; display formatting is presentation concern.