New State of AI 2026: Mid-Year Reality Check is live. Read the report
Skip to content
Case Study Grandview Homes

Scaling Real Estate Underwriting with AI

Client Grandview Homes
Sector Real estate
Markets Illinois, Ohio, Wisconsin
Grandview Homes, a real estate business underwriting deals with machine learning inside Salesforce
Hatchworks Team ML Engineer, Data Engineer, Solution Architect, QA Engineer, Product / Project Manager
Overview

Scaling underwriting without scaling costs.

HatchWorks AI designed and delivered a machine learning underwriting system for Grandview Homes, a Real Estate business in the US Midwest. The system augments Grandview's existing human-owned underwriting process with three machine learning models: ARV (After Repair Value), Rehab Cost, and Time to Sell, surfaced directly inside Salesforce.

Drawing on Grandview historical data and third-party data, the system produces model-driven predictions that feed Maximum Allowable Offer (MAO) calculations. It replaces a manual deterministic benchmark as the primary analytical input to offer pricing decisions.

ARV

After Repair Value. Market-comparable architecture.

Rehab Cost

Estimate-gated multi-output architecture, ten cost categories.

Time to Sell

Days from acquisition to resale.

The Challenge

Turning 15 years of experience into a scalable decision advantage

Grandview Homes acquires residential properties, renovates them, and resells them. Because deal margin is heavily influenced by the initial purchase price, underwriting decisions directly affect how effectively Grandview can deploy its capital.

As the company looked to scale, Grandview wanted to increase the number of opportunities its team could evaluate without adding underwriting cost at the same rate. It also wanted to improve the quality and consistency of those decisions by making better use of its proprietary historical data and current market data.

The existing underwriting process relied on a deterministic model to estimate ARV, rehab cost, and time to sell. While useful as a benchmark, the model could not effectively learn from Grandview’s historical transactions or adapt as market conditions changed.

Grandview had three core objectives:

  1. 01

    Scale deal volume while keeping underwriting costs relatively flat.

  2. 02

    Improve offer pricing and investment decisions using AI and data.

  3. 03

    Build a learning system that could use Grandview’s proprietary history and continuously improve as new transaction and market data became available.

Turning that vision into a production system presented a significant data challenge.

Grandview had approximately 4,000 historical purchases, with more advanced data capture introduced only in recent years.

The models also required data from seven different sources with no consistent joining key for straightforward normalization.

The Process

Building the data foundation for better decisions

HatchWorks AI led the end-to-end delivery of a system designed to turn Grandview’s historical and third-party data into actionable underwriting intelligence. The engagement covered the data foundation, machine learning models, Salesforce integration, and the MLOps infrastructure required for the system to continue learning over time.

  1. 01

    Data pipeline design and build

    Ingested and normalized Salesforce Opportunity data, QuickBooks actuals, Dropbox images, HouseCanary AVM data, Restb.ai imaging condition scores, and Realtor.com market data into a Bronze/Silver/Gold pipeline on Azure.

  2. 02

    Build vs buy vendor analysis

    Evaluated third-party sources to identify the right fit for Automated Valuation Models (AVM) and image evaluation.

  3. 03

    Address normalization

    Utilized third party services (HouseCanary Geocoder and Azure Maps) and matching logic to join data across sources.

  4. 04

    Feature engineering and model training

    Built three separate models, each with a distinct architecture: ARV (market-comparable), Rehab Cost (estimate-gated multi-output), and Time to Sell. Pipeline generates inference and SHAP explainability.

  5. 05

    Integration layer development

    Handled and exposed business logic, prediction storage, deterministic signals, error handling, and interaction with Salesforce and Azure ML.

  6. 06

    Salesforce integration

    Integration of system within Salesforce, supporting real-time predictions, scenario planning, model explainability, and supplementary features.

  7. 07

    Monitoring, evaluation, and retraining

    Automated deployment pipelines with monthly champion vs challenger model replacement, and model evaluation reporting.

How a prediction reaches the underwriter

Seven sources in. Three models in the middle. One offer price, inside Salesforce.

Step 01 Sources
Salesforce Opportunity data QuickBooks actuals Dropbox images HouseCanary AVM Restb.ai condition scores Realtor.com market data MLS
Step 02 Medallion pipeline on Azure
Bronze, Silver, Gold Ingestion and normalization via Azure Data Factory.
Address normalization HouseCanary Geocoder and Azure Maps, plus matching logic, join data across sources.
Step 03 Azure Machine Learning
Three models ARV, Rehab Cost, and Time to Sell, each with a distinct architecture. Feature engineering, inference, and SHAP explainability.
MLOps Monthly champion vs challenger replacement, evaluation reporting, and drift monitoring.
Step 04 Integration layer
APIs Inference and deterministic features exposed via APIs: business logic, prediction storage, error handling.
Step 05 Salesforce
Maximum Allowable Offer Real-time predictions, scenario planning, and model explainability where underwriters already work.
The Outcome

Better predictions today, a smarter underwriting system over time

The system is live in production and accessible directly within the Salesforce workflow Grandview’s underwriters already use.

Independent holdout evaluation showed the new models outperforming Grandview’s existing benchmark on two of the three core predictions, with near parity on the third. ARV prediction error was reduced by 31%, while Time to Sell prediction error fell by 69%.

Because these predictions feed Grandview’s Maximum Allowable Offer calculations, the system gives underwriters stronger analytical inputs when determining what to offer for a property. It creates the foundation for Grandview to evaluate opportunities more consistently and scale underwriting capacity without relying on a proportional increase in overhead.

Just as importantly, the system was designed to improve over time. Automated ingestion, monthly retraining, evaluation, and drift monitoring allow new transaction and market data to inform future model versions, helping Grandview build on its proprietary data advantage as the business grows.

A deterministic model estimated ARV, rehab cost, and time to sell.

Underwriting cost that rose in step with deal volume.

No effective learning from historical deal data, no adaptation to market conditions.

Seven data sources with no consistent joining key for straightforward normalization.

Key Stats

Model versus benchmark

31%

reduction in ARV prediction error vs the existing benchmark

69%

reduction in Time to Sell prediction error

7

third-party data integrations

Holdout evaluation Mean absolute error. Lower is better.
ARV 31% lower error
Benchmark $24,577 Model $16,919

R² of 0.95

Time to Sell 69% lower error
Benchmark 23.7 days Model 7.28 days
Rehab Cost Near parity
Benchmark $4,569 Model $4,554

Metrics determined via programmatic holdout evaluation across ~1,000-strong model training sets.

  • Three ML models deployed, one with ten outputs (individual Rehab Cost categories)

  • Each model makes simultaneous predictions for three strategic variations

Technologies Used

The stack

System infrastructure
Microsoft Azure Azure Data Factory Azure ML Application Insights Azure Maps API
Underwriting platform
Salesforce (underwriting platform and user interface)
Third-party integrations
HouseCanary (AVM, Geocoder, Sales Comparables) Restb.ai (property imaging and condition scoring) Realtor.com (market data by ZIP) QuickBooks via OneDrive (actuals ingestion) Dropbox MLS
Data and modeling
Python (data pipeline, feature engineering, model training)
Next Steps

A data advantage that compounds over time

Grandview has introduced the machine learning predictions alongside its existing deterministic model, allowing underwriters to use both when determining an appropriate offer amount. This approach gives the team an opportunity to understand where the models are strongest and build trust through real-world use.

Underwriters also have access to historical predictions and monthly evaluation metrics. Combining those results with their own observations will help Grandview identify reliable patterns, improve future features, and continue refining how AI informs underwriting decisions.

As Grandview captures more data from future purchases, renovations, and sales, that information can feed back into the system and improve the signals available to its models. Over time, this creates a compounding advantage: Grandview can use what it learns from each investment to make more informed decisions about where to deploy its limited capital next.

Client Quote

In their words

“Offer pricing is where our margin lives. Having model-driven predictions inside Salesforce gives our underwriters a sharper, more consistent starting point than the benchmark we relied on before.”
Lucino Sotelo, Chief Commercial Officer, Grandview Homes
Context

About the work

About Grandview Homes

Grandview Homes is a real estate business based in Chicago and operating across Illinois, Ohio, and Wisconsin. The company acquires residential properties, renovates them, and resells them, with deal margin driven primarily by the accuracy of the initial offer price. Grandview runs its underwriting on Salesforce.

About HatchWorks AI

HatchWorks AI turns AI into ROI by automating key business processes, transforming data, deploying intelligent agents, and shipping AI-powered products that deliver measurable results.

Ready to put models where the decisions happen?

See how HatchWorks AI builds machine learning into the systems your teams already run on.