Executive Summary

Phase Zero Pre-Development Assessment · April 2026

The Opportunity

The Colerain-North Bend Gateway is a 2.55-acre, 15-parcel assemblage at the intersection of Colerain Avenue and North Bend Road in Mount Airy, Cincinnati. The site is fully controlled by the Hamilton County Land Reutilization Corporation (HCLRC) at a nominal acquisition cost of $1, and has been confirmed for development consideration by HomeBase CDC through the Mt. Airy CURE partnership.

This assessment evaluates the site across four development scenarios ranging from 57 to 165 units, each structured as a LIHTC 9% affordable housing deal. The site's combination of Qualified Census Tract status, CRA Expand tax abatement, donated land, and market rents that already align with 60% AMI limits makes this a strong LIHTC candidate—but the calculator-backed underwriting reveals that all four scenarios carry a funding gap of $4.3–5.8M that will require additional soft sources, deferred developer fee, or gap financing to close.

Site Characteristics

The site sits at a prominent commercial intersection with approximately 400 ft of Colerain Avenue frontage and 200 ft of North Bend Road frontage. The block is zoned CC-P-B (Community Commercial, Pedestrian) across 14 parcels and CC-M-B (Community Commercial, Mixed-Use) on the corner parcel—both permitting mixed-use development with an 85 ft height limit, no story cap, no FAR limit, and a density allowance of 700 sf/unit yielding up to 167 units by right.

Topography is the primary physical constraint. The buildable plateau along both street frontages sits at 925–943 ft elevation with cross-slopes of 6–16%. Behind the Colerain frontage, the grade breaks sharply—dropping 53 ft over 150 ft of plan distance at 35–40% slope. This cliff defines the eastern edge of the buildable area and creates a natural boundary for a green buffer zone.

Development Concept

The site is organized into four zones based on topography, frontage, and zoning:

  • Zone 1 — L-Shape Corner (15,700 sf): Mixed-use anchor building wrapping the Colerain/North Bend intersection. Ground-floor retail at the corner (2,500 sf), residential above, tuck-under parking exploiting the cross-slope. This is the gateway identity building.
  • Zone 2 — Colerain Frontage (18,160 sf): Residential building(s) stepping down the south half of Colerain. Townhomes at smaller scale, walk-up apartments at larger scale. The steepening grade (10–14%) favors individually-stepped units.
  • Zone 3 — North Bend Frontage (12,642 sf): Mixed-use building east of the L, with ground-floor flex/retail (1,500 sf). Activated only in the Three Buildings and Max Density scenarios.
  • Zone 4 — Hillside Buffer (30,348 sf): Non-buildable. Trail system, bioswales for stormwater management, and community garden. This zone is the amenity differentiator—east-facing units look out over the tree canopy into the valley.

Scenario Matrix

Four scenarios test the relationship between project scale, capital structure, and CDC organizational capacity:

ScenarioUnitsBuildingsTDCLIHTC EquityGapCDC Profile
Starter572$28.9M$20.2M($4.3M)First LIHTC deal
Right-Sized872$38.8M$27.2M($5.3M)Proven operator
Three Buildings1313$52.7M$37.0M($5.8M)Co-developer needed
Max Density1653$60.5M$42.5M($5.1M)Major developer

All four scenarios use the same financing structure: LIHTC 9% tax credit equity as the primary capital source, a conventional permanent loan sized by NOI/DSCR, and CRA Expand property tax abatement (75% for 12 years). The QCT 30% basis boost generates significant credit equity ($20–43M depending on scale), but a persistent $4–6M funding gap remains across all scenarios. This gap reflects the full-cost underwriting from the deal-structuring engine—including financing carry, conservative soft cost ratios, and reserves that hand estimates typically undercount. Closing the gap will require layering soft sources: deferred developer fee, HOME loans, FHLB AHP grants, Ohio Housing Trust Fund, CDFI soft seconds, and/or Cincinnati gap grants.

The LIHTC Advantage at This Location

The most important finding of this assessment is that 60% AMI rent limits are essentially equal to market rents in Mt. Airy. The rent haircut for going LIHTC is negligible:

Unit TypeMarket Rent60% AMI (net)Difference
Studio$950$950$0
1 BR$1,150$1,134-$16
2 BR$1,400$1,361-$39
3 BR$1,650$1,419-$231

This means the LIHTC program is subsidizing the construction cost gap, not the rent gap. The credit generates $20–43M in tax credit equity depending on scale, while the revenue impact is minimal. This is the ideal LIHTC profile.

CDC Capacity Considerations

The site can support 165 units. LIHTC equity covers 70–85% of TDC at every scale, but a $4–6M gap remains that requires soft source layering. Beyond the capital stack, the binding constraint is organizational capacity. A $60M LIHTC deal requires:

  • A dedicated development team managing $3–5M/month in construction draws
  • A syndicator relationship—the tax credit investor will underwrite the CDC's capacity before committing equity
  • 15+ years of LIHTC compliance infrastructure (income verification, unit mix monitoring, annual reporting)
  • Asset management for 100+ units indefinitely

Recommended Path

Phase the project by CDC growth stage. Start with the L-building (Zone 1, 57 units, ~$29M TDC) as a single LIHTC application, potentially with a co-developer. The ~$4.3M gap on Phase 1 is addressable with deferred developer fee (~$1.4M), HOME ($110k), FHLB AHP ($85k), Ohio HTF ($60k), CDFI ($75k), Cincinnati gap grant ($50k), and sponsor equity or additional state sources for the remainder. Use Phase 1 to build syndicator relationships and compliance infrastructure. Pursue Zones 2 and 3 as separate LIHTC applications once Phase 1 is stabilized. Each phase builds the CDC's track record for the next.

Comparable Scale

For context, this project at full buildout (165 units, $60.5M TDC) is comparable in scale to the College Hill Station mixed-use development on Hamilton Avenue—a multi-building, transit-oriented project that combined LIHTC, CRA, and gap financing across phased delivery. The Colerain-North Bend site has similar advantages: gateway corner, public land, and strong overlay incentives. The difference is that College Hill had an established development team from the outset; HomeBase/CURE may need to build toward that capacity through phasing or partnership.

Key Risks

  • Funding gap requires soft source layering. The engine shows a $4.3–5.8M gap across all scenarios after LIHTC equity and permanent debt. This is typical for new-construction affordable deals in Cincinnati—it means the project needs 3–5 additional soft sources (HOME, FHLB AHP, Ohio HTF, CDFI, deferred fee) to close. Each source has its own application cycle and compliance requirements.
  • 9% LIHTC allocation is competitive. Ohio awards credits through a scored Qualified Allocation Plan. QCT status, donated land, and CRA abatement strengthen the application, but the allocation is not guaranteed.
  • Construction cost sensitivity. The $210/sf assumption is based on RS Means Q1 2026 Cincinnati metro data. The engine applies this to full gross building area including circulation, which produces higher TDCs than net-rentable-only estimates. A 14–18 month LIHTC application-to-closing timeline means construction starts in late 2027 or 2028. Even modest cost escalation widens the gap.
  • DSCR at 1.16x is below target. All four scenarios produce a debt service coverage ratio of 1.16x, below the typical 1.25x lender minimum. This constrains permanent loan sizing and may require interest rate buydowns, longer amortization, or subordinate debt to reach closing.
  • Hillside site work. The $450k site extraordinary budget for retaining walls, stormwater, and utility connections is a preliminary estimate. Geotechnical investigation is needed before design development to confirm foundation conditions on the 12–16% slopes.
  • Competing disposition. Parcels 022800030019 (5460 Colerain, $596k sale in 2024) and 022800030064 (2559 N Bend, $3.3M adjacent sale in 2025) flag concurrent commercial assembly activity in the area. Monitor for competing interests during the predevelopment period.

Methodology & Sources

Site Data

Parcels
Hamilton County Auditor via CAGIS API
Geometry
CAGIS parcel boundaries, EPSG:3735 projection
Topography
USGS 3DEP 1m DEM + CAGIS LiDAR
Soils
USDA NRCS gSSURGO via Web Soil Survey
Zoning
Cincinnati Municode, confirmed against CAGIS zoning layer

Financial Assumptions

Construction
RS Means 2026, Cincinnati metro adjustment
Rents
CoStar Cincinnati Q1 2026, Mt. Airy submarket
AMI Limits
HUD FY2025 Income Limits, Hamilton County
QCT
HUD QCT2026 dataset (huduser.gov), Tract 85.01
CRA
City of Cincinnati CRA Expand program schedule
Cap Rates
CoStar Cincinnati multifamily Q1 2026

Underwriting Engine

TDC
Site-engine deal-structuring-engine v1
LIHTC
9% credit, 10yr period, $0.92 pricing
Debt sizing
NOI ÷ DSCR (1.25x min), 6.25%, 30yr amort
Overlays
QCT 30% basis boost, CRA 75%/12yr abatement

What This Is Not

Appraisal
No. Preliminary feasibility only.
Engineering
No. Geotech & civil needed.
Legal
No. Title work & entitlements required.
Commitment
No. No financing commitments exist.

About This Assessment

This is a Phase Zero pro forma light—a conversation starter, not a financing commitment. It answers "is this worth pursuing?" before anyone commits predevelopment capital to architects, engineers, and attorneys. The analysis uses deterministic site data, published financial benchmarks, and a calculator-backed underwriting engine to evaluate feasibility across multiple scenarios. All assumptions are documented and adjustable.

A full underwriting assessment—with sensitivity analysis, Monte Carlo simulations, construction scheduling, lender-ready pro formas, and third-party market studies—is the next step if the CDC decides to move forward. See the Roadmap tab for the 30/60/90 day action plan and what that full assessment would include.

Site Overview

Deterministic facts · 15 parcels · 2.55 ac
15
Parcels
2.55 ac
Total Area
136
Max Units
104 ft
Elev. Drop
15%
Mean Slope

Identity

Site
Colerain-North Bend Gateway
Neighborhood
Mount Airy
Municipality
City of Cincinnati, OH
Address
COLERAIN AVE + 9 more
Lot Frame
397.68 ft × 472.26 ft
Total Area
111,182 sf / 2.55 ac
Centroid
-84.5696, 39.1909

Control

Entity
Hamilton County Land Reutilization Corp.
Status
confirmed
Confirmed
2026-03-15
Source
HomeBase / Alexis Heidenreich
Acquisition
$1 + $3,500 closing

Zoning

Primary
CC-P-B × 13 parcels
Corner
CC-M-B × 1 parcel
Residential
SF-6-MH × 1 parcel
Max Height
85 ft (CC zones)
Density
700 sf/unit → 136 units
Illustrative
158 units (sitewide)

Overlays

CRA
Expand 75% / 12 yr
Hillside
yes
Opportunity Zone
no
Historic
no
Flood Zone
no
QCT
unverified

Parcels

15 parcels · all HCLRC-controlled · tax exempt
Address ID Zoning Slope Elevation Status Role

Terrain Analysis

DEM: USGS 3DEP 1m / CAGIS LiDAR · Soil: USDA NRCS gSSURGO

Slope Analysis

Elev range 870–943 ft · Colerain sidewalk ~937 ft · North Bend ~940 ft
Hard slope break at 16% → 27%. ~110 ft parcel depth on Colerain at ~12% grade → rear property line at ~923 ft → 53 ft drop to 870 ft at 35% avg. No parcels in between.

Buildable Zone 6–16% slope

ParcelRoleAvg SlopeElevationDrop
035 (2565 N Bend)N Bend extension6%925–931 ft6 ft
036 (ROW sliver)N Bend edge8%926–930 ft4 ft
049 (5448 Colerain)Colerain frontage9%925–937 ft12 ft
105 (5442 Colerain)Colerain frontage10%923–937 ft14 ft
020 (5456 Colerain)Colerain frontage11%926–938 ft12 ft
033 (2563 N Bend)N Bend extension11%915–931 ft16 ft
104 (5454 Colerain)Colerain frontage11%926–937 ft11 ft
019 (5460 Colerain)CC-M-B corner anchor13%928–940 ft12 ft
018 (ROW sliver)N Bend edge14%931–942 ft11 ft
034 (5430 Colerain)Colerain frontage14%908–936 ft28 ft
017 (2563 N Bend)N Bend frontage15%930–943 ft13 ft
064 (2559 N Bend)N Bend frontage16%911–943 ft32 ft

Hillside / Non-Buildable >25% slope

ParcelRoleAvg SlopeElevationDrop
247 (N Bend Rd, no #)Hillside27%905–930 ft25 ft
016 (Colerain Ave, no #)Hillside35%873–926 ft53 ft
048 (5430 Colerain REAR)Hillside40%870–923 ft53 ft

Development Zones

4 zones · 3 buildable + 1 green buffer
Development Zone Plan

Zone 1 — L-Shape Corner anchor_mixed_use

15,700 sf · CC-M-B · Parcels: 019, 020, 017, 018, 036
Ground floor: retail (2,500 sf) · Slope: 9% · Tuck-under parking · Max 85 ft

Zone 2 — Colerain Frontage residential

18,160 sf (14,400 usable) · CC-P-B · Parcels: 049, 104, 105, 034
Ground floor: residential · Slope: 12%

Zone 3 — North Bend Frontage mixed_use

12,642 sf (10,100 usable) · CC-P-B · Parcels: 035, 033, 064
Ground floor: flex (1,500 sf retail) · Slope: 14%

Zone 4 — Hillside Buffer green_buffer

30,348 sf · Non-buildable · Parcels: 048, 016, 247
Program: trail, bioswale, community garden

Concept Renderings

5 styles · axonometric · infographic · photorealistic · pencil sketch

Roadmap & Next Steps

Pro forma light · conversation starter · not a full underwriting commitment
What this is: A Phase Zero feasibility sketch—enough to start the conversation with HomeBase/CURE, identify the right development partners, and decide whether to commit predevelopment capital. What this is not: A full underwriting assessment. A complete deal package would include sensitivity analysis, Monte Carlo simulations on cost/rent scenarios, detailed construction scheduling, and lender-ready pro formas. That work is Phase 1.

Project Timeline

Decision Flow


      

30 / 60 / 90 Day Action Plan

0–30 DAYS Alignment & Capacity

  • Complete Phase Zero site analysis & pro forma lightCo-Llab
  • Verify QCT status (Tract 85.01 confirmed)Co-Llab
  • Confirm site control via HCLRCHomeBase
  • Present workbook to HomeBase/CURE leadershipCo-Llab + HomeBase
  • CDC capacity self-assessment: staffing, track record, compliance readinessHomeBase
  • Select target scenario (Starter / Right-Sized / Three Buildings / Max)HomeBase + Co-Llab
  • Identify 2–3 potential co-developer partners (if needed for selected scale)HomeBase

30–60 DAYS Pre-Development Scoping

  • Co-developer interviews & LOI (if applicable)HomeBase
  • Commission geotechnical investigation (hillside slopes, foundation conditions)Co-Llab / Engineer
  • Phase I environmental site assessmentConsultant
  • Preliminary title work on all 15 parcelsAttorney
  • Soft source inventory: identify which gap programs are open, deadlines, and dollar limitsCo-Llab
  • OHFA QAP review: confirm scoring criteria, application deadlines, competitive landscapeCo-Llab
  • Full underwriting: sensitivity analysis, best/worst/base case scenariosCo-Llab

60–90 DAYS Design & Application Prep

  • Architect RFP / selection for schematic designHomeBase + Co-Dev
  • Schematic site plan based on selected scenario + geotech findingsArchitect
  • Syndicator pre-engagement: capacity presentation, preliminary LOICo-Dev / HomeBase
  • CRA Expand application (if not already filed)HomeBase
  • Soft source applications: HOME, FHLB AHP, Ohio HTF (match to open cycles)Co-Llab + HomeBase
  • LIHTC 9% application draft & scoring self-assessmentCo-Llab + Co-Dev

90+ DAYS Beyond Phase Zero

  • Submit OHFA 9% LIHTC applicationDevelopment team
  • Construction loan engagement & term sheetDevelopment team
  • Design development & construction documentsArchitect
  • GC procurement & pricingDevelopment team
  • Financial closingDevelopment team
  • Construction start (Phase 1 — Zone 1 L-building)GC

Outstanding Questions for CDC Review

  • Organizational capacity: Has HomeBase completed a LIHTC deal before? What was the scale? Do they have compliance staff?HomeBase
  • Co-developer relationships: Does HomeBase have existing relationships with experienced LIHTC developers in Ohio?HomeBase
  • Scale appetite: Which scenario aligns with the CDC's 3–5 year strategic plan? Is phasing preferred?HomeBase
  • Product vision: Is 100% affordable rental the right product, or is there appetite for mixed-income or a for-sale component?HomeBase + Community
  • Retail tenanting: Is there a known tenant for the corner retail space? A letter of intent strengthens the LIHTC application.HomeBase
  • Community engagement: Has the neighborhood been engaged on the development concept? Any known opposition or support?HomeBase
  • Competing interests: Status of the $596k / $3.3M sale activity on parcels 019 and 064?HomeBase
  • HCLRC disposition timeline: Are there any parallel disposition commitments or deadlines on these parcels?HomeBase / HCLRC

What Full Underwriting Would Include

Sensitivity Analysis

Hard cost
$190 / $210 / $230 / $250 per sf
Vacancy
3% / 5% / 7% / 10%
Rent growth
0% / 1% / 2% / 3%
Interest rate
5.5% / 6.25% / 7.0% / 7.5%
Credit pricing
$0.86 / $0.89 / $0.92 / $0.95

Simulation Runs

Monte Carlo
1,000+ iterations on cost/rent/rate
Best case
Low cost + high rents + low rates
Worst case
High cost + flat rents + high rates
Break-even
What inputs make the gap = $0?
Stress test
12-month vacancy + 15% cost overrun

Construction Detail

Draw schedule
Monthly construction draws + S-curve
Interest carry
Actual accrual, not lump estimate
GC pricing
Real bids, not RS Means benchmarks
Geotech
Foundation design from soil borings
Value engineering
Where to save without cutting quality

Lender-Ready Package

15-year DCF
Year-by-year cash flow + exit
Tax credit schedule
Annual credits, equity draws, recapture
Compliance plan
Income verification, reporting, monitoring
Market study
Third-party rent comp + demand analysis
Appraisal
As-completed + as-stabilized values

Finance

LIHTC 9% · 60% AMI · Hamilton County 2025