Create a marketing landing page for 1475 Sand Bay Dr SW, Atlanta, GA 30331 that I could show a broker or use internally to pitch the deal. Include the property highlights, location and market context, and key investment metrics, presented like a professional asset overview site rather than a spreadsheet
mkdir -p /vercel/sandbox/work && cat > /vercel/sandbox/work/metrics.py << 'EOF'
# The Slate - key derived investment metrics
noi = 3959341.22
egi = 6872228.26
gpr = 6387766.24
opex = 2912887.04
tax = 837000.76
last_sale_price = 63500000
units = 350
unit_sqft = 1146
total_sqft = 401100
price_per_unit = last_sale_price / units
implied_cap_rate_on_current_noi = noi / last_sale_price
noi_margin = noi / egi
opex_ratio = opex / egi
tax_pct_of_opex = tax / opex
# rent comparisons
prop_in_place_avg = 1514.29
prop_in_place_psf = 1.33
submarket_in_place_avg = 1397.09
market_in_place_avg = 1662.19
market_cap_rate = 0.0533
prop_vs_submarket_premium = prop_in_place_avg/submarket_in_place_avg - 1
prop_vs_market_discount = prop_in_place_avg/market_in_place_avg - 1
occ_property = 0.9514
occ_submarket = 0.9586
occ_market = 0.9305
asking_rent_t12_property = 0.0269
asking_rent_t12_market = -0.0169
print(f"Price per unit: ${price_per_unit:,.0f}")
print(f"Implied cap rate (2021 basis, current NOI): {implied_cap_rate_on_current_noi:.2%}")
print(f"NOI margin (NOI/EGI): {noi_margin:.1%}")
print(f"OpEx ratio (OpEx/EGI): {opex_ratio:.1%}")
print(f"Property tax as % of total opex: {tax_pct_of_opex:.1%}")
print(f"In-place rent premium vs submarket: {prop_vs_submarket_premium:.1%}")
print(f"In-place rent discount vs market avg: {prop_vs_market_discount:.1%}")
print(f"Occupancy: property {occ_property:.1%} vs submarket {occ_submarket:.1%} vs market {occ_market:.1%}")
print(f"Asking rent T12 growth: property {asking_rent_t12_property:.1%} vs market {asking_rent_t12_market:.1%}")
print(f"Current market MF cap rate benchmark: {market_cap_rate:.2%}")
print(f"Spread: implied cap on current NOI vs market cap rate: {(implied_cap_rate_on_current_noi - market_cap_rate)*100:.0f} bps")
EOF
python3 /vercel/sandbox/work/metrics.pycat > /vercel/sandbox/work/metrics2.py << 'EOF'
noi = 3959341.22
egi = 6872228.26
last_sale_price = 63500000
units = 350
noi_margin = 0.5692
opex_ratio = 0.4308
tax = 837000.76
opex = 2912887.04
price_per_unit = last_sale_price/units
implied_cap = noi/last_sale_price
tax_pct_opex = tax/opex
print(f"price/unit ${price_per_unit:,.0f}")
print(f"implied cap {implied_cap:.2%}")
print(f"NOI margin {noi_margin:.1%}")
print(f"opex ratio {opex_ratio:.1%}")
print(f"tax % of opex {tax_pct_opex:.1%}")
EOF
python3 /vercel/sandbox/work/metrics2.pyNow building the landing page.
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>The Slate | 1475 Sand Bay Dr SW, Atlanta, GA | Investment Overview</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<style>
:root{
--navy:#0f2540; --navy2:#16324f; --gold:#c9a24a; --ink:#1c2a36;
--gray:#5b6b78; --line:#e4e8ec; --bg:#f7f8fa; --green:#2e7d5b;
}
*{box-sizing:border-box;}
body{margin:0;font-family:'Helvetica Neue',Arial,sans-serif;color:var(--ink);background:var(--bg);}
h1,h2,h3,h4{font-family:Georgia,'Times New Roman',serif;margin:0;}
.wrap{max-width:1180px;margin:0 auto;padding:0 32px;}
a{color:inherit;}
/* HERO */
.hero{
background:linear-gradient(135deg,var(--navy) 0%, var(--navy2) 55%, #1d3f63 100%);
color:#fff; position:relative; overflow:hidden;
}
.hero::after{
content:""; position:absolute; right:-120px; top:-120px; width:480px; height:480px;
border-radius:50%; background:radial-gradient(circle, rgba(201,162,74,0.18), transparent 70%);
}
.topbar{display:flex; justify-content:space-between; align-items:center; padding:22px 0; border-bottom:1px solid rgba(255,255,255,0.15);}
.brandmark{font-family:Georgia,serif; font-size:20px; letter-spacing:2px; text-transform:uppercase;}
.brandmark span{color:var(--gold);}
.topbar .tag{font-size:12px; letter-spacing:1.5px; text-transform:uppercase; color:#c8d2dc;}
.hero-body{padding:64px 0 56px; position:relative; z-index:1;}
.kicker{display:inline-block; font-size:12px; letter-spacing:2px; text-transform:uppercase; color:var(--gold); border:1px solid rgba(201,162,74,0.5); padding:6px 14px; border-radius:20px; margin-bottom:22px;}
.hero h1{font-size:52px; line-height:1.05; font-weight:400;}
.hero .former{font-size:14px; color:#aebccb; margin-top:6px; font-style:italic;}
.hero .addr{font-size:19px; color:#dbe4ec; margin-top:14px;}
.hero-stats{display:grid; grid-template-columns:repeat(5,1fr); gap:0; margin-top:48px; border-top:1px solid rgba(255,255,255,0.18); padding-top:28px;}
.hstat{border-right:1px solid rgba(255,255,255,0.18); padding-right:20px;}
.hstat:last-child{border-right:none;}
.hstat .num{font-size:30px; font-weight:600; font-family:Georgia,serif; color:#fff;}
.hstat .lbl{font-size:12px; letter-spacing:1px; text-transform:uppercase; color:#a9b8c7; margin-top:6px;}
/* SECTION SHELL */
section{padding:64px 0;}
.section-head{margin-bottom:36px;}
.eyebrow{font-size:12px; letter-spacing:2px; text-transform:uppercase; color:var(--gold); font-weight:700; margin-bottom:10px;}
.section-head h2{font-size:32px; color:var(--navy);}
.lede{color:var(--gray); font-size:16px; max-width:780px; margin-top:14px; line-height:1.6;}
.band-alt{background:#fff; border-top:1px solid var(--line); border-bottom:1px solid var(--line);}
/* HIGHLIGHTS GRID */
.grid3{display:grid; grid-template-columns:repeat(3,1fr); gap:28px;}
.card{background:#fff; border:1px solid var(--line); border-radius:6px; padding:26px 24px;}
.card h3{font-size:17px; color:var(--navy); margin-bottom:10px; font-family:'Helvetica Neue',Arial,sans-serif; font-weight:700;}
.card p{color:var(--gray); font-size:14.5px; line-height:1.55; margin:0;}
.card .icon{width:38px;height:38px;border-radius:8px;background:#eef2f6;color:var(--navy);display:flex;align-items:center;justify-content:center;font-size:18px;margin-bottom:14px;font-weight:700;}
/* AMENITIES */
.amen-cols{display:grid; grid-template-columns:1fr 1fr; gap:36px;}
.amen-cols h4{font-size:13px; letter-spacing:1px; text-transform:uppercase; color:var(--navy); margin-bottom:14px; border-bottom:2px solid var(--gold); display:inline-block; padding-bottom:6px;}
.amen-list{list-style:none; margin:0; padding:0; display:grid; grid-template-columns:1fr 1fr; gap:10px 18px;}
.amen-list li{font-size:14px; color:var(--ink); padding-left:18px; position:relative;}
.amen-list li::before{content:"—"; position:absolute; left:0; color:var(--gold);}
/* METRICS TABLE */
.metrics-grid{display:grid; grid-template-columns:repeat(4,1fr); gap:20px; margin-bottom:40px;}
.mcard{background:var(--navy); color:#fff; border-radius:8px; padding:22px 20px;}
.mcard .v{font-size:26px; font-family:Georgia,serif; font-weight:600;}
.mcard .l{font-size:11.5px; letter-spacing:0.8px; text-transform:uppercase; color:#b9c6d3; margin-top:6px;}
.mcard.gold{background:linear-gradient(135deg,#c9a24a,#a9822f); color:#241a06;}
.mcard.gold .l{color:#4a3a12;}
table.fintab{width:100%; border-collapse:collapse; background:#fff; border:1px solid var(--line); border-radius:6px; overflow:hidden;}
table.fintab th, table.fintab td{padding:12px 18px; text-align:left; font-size:14px; border-bottom:1px solid var(--line);}
table.fintab th{background:#eef2f6; color:var(--navy); font-size:12px; letter-spacing:0.8px; text-transform:uppercase;}
table.fintab td.num{text-align:right; font-weight:600;}
table.fintab tr:last-child td{border-bottom:none;}
.note{font-size:12px; color:var(--gray); margin-top:10px;}
/* MARKET COMP TABLE */
.comp-table{width:100%; border-collapse:collapse;}
.comp-table th, .comp-table td{padding:14px 16px; font-size:14px; border-bottom:1px solid var(--line);}
.comp-table th{background:var(--navy); color:#fff; font-size:12px; letter-spacing:0.6px; text-transform:uppercase; text-align:left;}
.comp-table td{text-align:right;}
.comp-table td:first-child{text-align:left; font-weight:600; color:var(--navy);}
.comp-table tr.hi td{background:#fbf5e8; font-weight:700;}
.pill{display:inline-block; padding:3px 10px; border-radius:12px; font-size:11.5px; font-weight:700;}
.pill.up{background:#e2f3e9; color:var(--green);}
.pill.down{background:#fdecec; color:#a63636;}
/* TWO COL */
.twocol{display:grid; grid-template-columns:1.15fr 0.85fr; gap:40px; align-items:start;}
footer{background:var(--navy); color:#c8d2dc; padding:46px 0; font-size:13px;}
footer .foot-grid{display:flex; justify-content:space-between; align-items:flex-start; gap:24px; flex-wrap:wrap;}
footer .disc{max-width:680px; line-height:1.6; color:#8fa0b0;}
footer strong{color:#fff;}
.cta-strip{background:var(--gold); color:#241a06; padding:26px 0;}
.cta-strip .wrap{display:flex; justify-content:space-between; align-items:center; flex-wrap:wrap; gap:12px;}
.cta-strip h3{font-size:19px; font-family:Georgia,serif;}
.cta-strip .sub{font-size:13px; opacity:0.85;}
@media(max-width:900px){
.hero-stats{grid-template-columns:repeat(2,1fr); row-gap:20px;}
.hstat{border-right:none;}
.grid3{grid-template-columns:1fr;}
.amen-cols{grid-template-columns:1fr;}
.metrics-grid{grid-template-columns:repeat(2,1fr);}
.twocol{grid-template-columns:1fr;}
.hero h1{font-size:36px;}
}
</style>
</head>
<body>
<!-- HERO -->
<div class="hero">
<div class="wrap">
<div class="topbar">
<div class="brandmark">THE <span>SLATE</span> · ATLANTA</div>
<div class="tag">Confidential Investment Overview</div>
</div>
<div class="hero-body">
<div class="kicker">Stabilized Value-Add Multifamily · Southwest Atlanta</div>
<h1>The Slate</h1>
<div class="former">Formerly known as Sandtown Vista</div>
<div class="addr">1475 Sand Bay Dr SW, Atlanta, GA 30331 · Sandtown Submarket · Atlanta MSA</div>
<div class="hero-stats">
<div class="hstat"><div class="num">350</div><div class="lbl">Units</div></div>
<div class="hstat"><div class="num">2009</div><div class="lbl">Built / Reno. 2022</div></div>
<div class="hstat"><div class="num">95.1%</div><div class="lbl">Physical Occupancy</div></div>
<div class="hstat"><div class="num">$1,514</div><div class="lbl">Avg. In-Place Rent</div></div>
<div class="hstat"><div class="num">$181.4K</div><div class="lbl">Basis / Unit (2021)</div></div>
</div>
</div>
</div>
</div>
<!-- PROPERTY HIGHLIGHTS -->
<section>
<div class="wrap">
<div class="section-head">
<div class="eyebrow">Property Highlights</div>
<h2>350 Units of Garden-Style Living, Renovated in 2022</h2>
<p class="lede">A 22-acre, brick-clad garden community built in 2009 and renovated in 2022, offering large average unit sizes and a resort-style amenity package rarely found at this price basis in the Atlanta market.<sup>1</sup></p>
</div>
<div class="grid3">
<div class="card">
<div class="icon">SF</div>
<h3>Scale & Design</h3>
<p>350 units across 401,100 rentable square feet — an average of 1,146 SF per unit — in four-story, garden-style buildings on 22.0 acres. Brick exterior with wood-frame construction.<sup>2</sup></p>
</div>
<div class="card">
<div class="icon">RN</div>
<h3>Recent Capital Investment</h3>
<p>Renovated in 2022, thirteen years after original construction — positioning the asset ahead of much of its 2009-vintage garden-style competitive set on finish quality.<sup>2</sup></p>
</div>
<div class="card">
<div class="icon">OC</div>
<h3>Operating Momentum</h3>
<p>95.1% physically occupied (96.1% trailing-30-day average), with asking rents up 2.7% over the trailing 12 months — outperforming a metro where asking rents fell 1.7% over the same period.<sup>3</sup></p>
</div>
</div>
</div>
</section>
<!-- AMENITIES -->
<div class="band-alt">
<section>
<div class="wrap">
<div class="section-head">
<div class="eyebrow">Amenities</div>
<h2>Resort-Style Community, Modern In-Unit Finishes</h2>
</div>
<div class="amen-cols">
<div>
<h4>Community Amenities</h4>
<ul class="amen-list">
<li>Outdoor swimming pool</li>
<li>Fitness center</li>
<li>Business center</li>
<li>Gated entry / secure access</li>
<li>Package delivery room</li>
<li>Surface parking lot</li>
<li>BBQ / grilling stations</li>
</ul>
</div>
<div>
<h4>In-Unit Features</h4>
<ul class="amen-list">
<li>In-unit washer / dryer</li>
<li>Hardwood-style flooring</li>
<li>Central air conditioning</li>
<li>Private balcony / patio</li>
<li>Walk-in closets</li>
<li>Dishwasher, range & microwave</li>
<li>Full-size refrigerator</li>
</ul>
</div>
</div>
<p class="note">Amenity data per RealAI multifamily property records.<sup>4</sup></p>
</div>
</section>
</div>
<!-- INVESTMENT METRICS -->
<section>
<div class="wrap">
<div class="section-head">
<div class="eyebrow">Key Investment Metrics</div>
<h2>Trading Near Replacement-Level Basis, Cash-Flowing Today</h2>
<p class="lede">The Slate last traded in April 2021 at $63.5M ($181,429/unit) — a basis that, against current in-place NOI, implies a 6.2% cap rate, roughly in line with today's institutional multifamily benchmark for Atlanta.<sup>5</sup></p>
</div>
<div class="metrics-grid">
<div class="mcard gold"><div class="v">$63.5M</div><div class="l">Last Sale Price (Apr 2021)</div></div>
<div class="mcard"><div class="v">$181,429</div><div class="l">Price / Unit</div></div>
<div class="mcard"><div class="v">6.2%</div><div class="l">Implied Cap Rate, Current NOI</div></div>
<div class="mcard"><div class="v">$3.96M</div><div class="l">Net Operating Income</div></div>
</div>
<div class="twocol">
<div>
<table class="fintab">
<tr><th>Operating Metric</th><th style="text-align:right;">Value</th></tr>
<tr><td>Gross Potential Rent</td><td class="num">$6,387,766</td></tr>
<tr><td>Effective Gross Income</td><td class="num">$6,872,228</td></tr>
<tr><td>Total Operating Expenses</td><td class="num">$2,912,887 (43.1% of EGI)</td></tr>
<tr><td>Net Operating Income</td><td class="num">$3,959,341 (56.9% margin)</td></tr>
<tr><td>Property Tax (2025)</td><td class="num">$837,001 / $2,391 per unit</td></tr>
<tr><td>Tax-Assessed Value</td><td class="num">$21.7M ($62,086/unit)</td></tr>
</table>
<p class="note">Financials reflect RealAI Ops Benchmark estimates built from GSE, HUD/FHA, and tax-assessor sources, not sponsor-reported financials.<sup>6</sup></p>
</div>
<div>
<table class="fintab">
<tr><th>Rent & Occupancy</th><th style="text-align:right;">Value</th></tr>
<tr><td>In-Place Rent (avg)</td><td class="num">$1,514 / $1.33 psf</td></tr>
<tr><td>Asking Rent (avg)</td><td class="num">$1,682 / $1.49 psf</td></tr>
<tr><td>Physical Occupancy</td><td class="num">95.1%</td></tr>
<tr><td>12-Mo Retention Rate</td><td class="num">65.7%</td></tr>
<tr><td>Rent-to-Income Ratio</td><td class="num">28.0% (about average)</td></tr>
<tr><td>Median Resident Household Income</td><td class="num">$64,925</td></tr>
</table>
<p class="note">Rent Index sample: 231 units, "excellent" confidence rating.<sup>7</sup></p>
</div>
</div>
</div>
</section>
<!-- MARKET POSITIONING -->
<div class="band-alt">
<section>
<div class="wrap">
<div class="section-head">
<div class="eyebrow">Comp Set Positioning</div>
<h2>Priced Below Metro Average, at a Premium to Its Immediate Submarket</h2>
<p class="lede">The Slate's in-place rent sits 8.4% above the Sandtown submarket average, while remaining 8.9% below the broader Atlanta metro average — headroom that supports continued mark-to-market as leases turn.<sup>8</sup></p>
</div>
<table class="comp-table">
<tr><th style="text-align:left;">Metric</th><th>The Slate</th><th>Sandtown Submarket</th><th>Atlanta MSA</th></tr>
<tr><td>In-Place Rent (avg)</td><td>$1,514</td><td>$1,397</td><td>$1,662</td></tr>
<tr><td>Physical Occupancy</td><td>95.1%</td><td>95.9%</td><td>93.1%</td></tr>
<tr class="hi"><td>Asking Rent Growth (T12)</td><td>+2.7%</td><td>+1.8%</td><td>−1.7%</td></tr>
<tr><td>12-Mo Retention Rate</td><td>65.7%</td><td>73.0%</td><td>66.5%</td></tr>
<tr><td>MF Cap Rate Benchmark</td><td colspan="3" style="text-align:center;">5.33% (Atlanta institutional multifamily, 2Q26)</td></tr>
</table>
<p class="note">Source: RealAI Rent Index and GreenStreet market cap rate data.<sup>9</sup></p>
</div>
</section>
</div>
<!-- LOCATION & MARKET CONTEXT -->
<section>
<div class="wrap">
<div class="section-head">
<div class="eyebrow">Location & Market Context</div>
<h2>Southwest Atlanta, Inside a Metro Still Adding Jobs and People</h2>
</div>
<div class="grid3">
<div class="card">
<div class="icon">MK</div>
<h3>Atlanta MSA Fundamentals</h3>
<p>6.4M residents, up 1.6% over the past year and 9.3% over five years. Employment grew 2.2% in the trailing year and 13.6% over five years, with 49.6% of adults holding a bachelor's degree or higher.<sup>10</sup></p>
</div>
<div class="card">
<div class="icon">SM</div>
<h3>Sandtown Submarket</h3>
<p>71.5% owner-occupied, above-average educational attainment (78.3% bachelor's-degree-plus) relative to the metro, and household income growth that outpaces population growth — a submarket transitioning upmarket around The Slate.<sup>11</sup></p>
</div>
<div class="card">
<div class="icon">SP</div>
<h3>Supply Backdrop</h3>
<p>13,609 units under construction metro-wide against 7,104 delivered year-to-date and 6,230 units of net absorption — a still-elevated pipeline, but one the property has out-leased through 2.7% trailing rent growth.<sup>12</sup></p>
</div>
</div>
</div>
</section>
<div class="cta-strip">
<div class="wrap">
<div>
<h3>The Slate — 1475 Sand Bay Dr SW, Atlanta, GA 30331</h3>
<div class="sub">350 Units · Built 2009, Renovated 2022 · Sandtown Submarket, Atlanta MSA</div>
</div>
<div class="sub">Prepared for broker & internal discussion purposes · Not an offer to sell securities</div>
</div>
</div>
<footer>
<div class="wrap">
<div class="foot-grid">
<div>
<strong>The Slate</strong><br>
1475 Sand Bay Dr SW<br>
Atlanta, GA 30331
</div>
<div class="disc">
This overview was prepared from RealAI Datamart property, market, and demographic data (RealAI Rent Index, RealAI Ops Benchmarks, RealAI SuperCensus™, and GreenStreet market cap rates) for informational and discussion purposes only. Financial figures are modeled estimates, not sponsor-reported financials, and should be independently verified before use in underwriting or an offer. Not an offer to sell or a solicitation of an offer to buy any security or interest.
</div>
</div>
</div>
</footer>
</body>
</html>
Now let's save and present it, plus add supporting artifacts (comp table/chart/map) inline.
The Slate: a 350-unit Atlanta value-add asset with 2.7% trailing rent growth against a metro that's shrinking rents
I built the landing page below as a shareable HTML file — property highlights, amenities, key investment metrics, and market/comp context, formatted like a broker teaser rather than a spreadsheet.
| Metric | |||
|---|---|---|---|
| In-Place Rent (avg) | $1,514 | $1,397 | $1,6621 |
| Physical Occupancy | 95.1% | 95.9% | 93.1% |
| Asking Rent Growth (T12) | +2.7% | +1.8% | -1.7% |
| 12-Mo Retention Rate | 65.7% | 73.0% | 66.5% |
The headline for a broker conversation: The Slate last traded in April 2021 at $63.5M ($181,429/unit) . Run that basis against today's in-place NOI of $3.96M and you land at a 6.2% cap rate — essentially in line with the current 5.33% institutional multifamily benchmark for Atlanta , meaning the deal is pricing at (not above) today's market clearing yield despite the asset having improved operationally since acquisition.
Three things carry the pitch:
The one number to flag before it goes to a lender or buyer: resident credit quality here is weak (average FICO 562, 23.3% past-due rate) — worth having an answer ready on retention (65.7%, trailing the submarket's 73.0% ) before someone else raises it.
Happy to add a floor-plan-level rent breakdown or a sales-comp set if you want more ammunition for the broker conversation.
This is a read-only snapshot of a RealAI analysis.