Skip to main content
Web-Development

We turned building research into condo leads

A Cincinnati condo site rebuilt around the way buyers actually shop: building first, then unit, then what's for sale now.

Cincinnati Condo Connection is the condo-only site of Maria Walley, a Realtor with Comey & Shepherd Realtors. Her original site left buyers to work through dense building information and a separate listings button. We rebuilt it on Next.js in November 2025, then moved it onto Sonor in September 2026 with live MLS data, per-building listing alerts and CRM routing.

Next.js RebuildMLS IntegrationReal Estate CRM SetupBuilding And Neighborhood Pages
View Live Site
Desktop preview
Tablet preview
Mobile preview
165 inquiries
Eight months, no monthly plan
213 inquiries
Since launch
11.6K
Google Search clicks

Challenges & Solutions

What stood in the way, and how we cleared it.

01

A building page didn't answer the building question

Condo buyers compare a specific building, a specific unit and the listings available there now. Maria's original Edgecliff page, as the Wayback Machine archived it in August 2024, put the building's details in small gray type beside a photo slideshow and showed no listings, only a button to see them.

Solution

We made each building page the place to learn about the property and, for her Ohio buildings, see the condos for sale there.

Result: Buyers can research a building and act on its live inventory from the same page.
02

The MLS didn't know the unit number

Maria's MLS feed has no unit-number field at all, so an address alone couldn't tell a buyer which condo was for sale.

Solution

We checked every field the feed sends, then used parcel numbers to look up each unit at the Hamilton County Auditor.

Result: Listing cards, maps, page titles and lead records now identify the condo a buyer asked about.
03

The old listing sync had stopped

The old site matched listings to buildings in its own sync scripts, and those had stopped running, so new listings weren't reaching building pages.

Solution

We wired CincyMLS data into Sonor's real-estate module and automated the building match.

Result: On day one, Sonor matched 74 listings, active and pending, to 27 of Maria's buildings. Wherever the old site had placed the same address, Sonor agreed.
04

An inquiry needed more than a name and email

A Realtor needs to know whether a lead came from a building, listing or neighborhood before following up.

Solution

We routed every inquiry into Sonor's CRM, and inquiries from building, listing and neighborhood pages carry the page they came from.

Result: Maria can open a lead and see which condo or area started the conversation.

Edgecliff Private Residences, then and now

The same building page as the Wayback Machine archived it on August 3, 2024 (the archive can't load its map), and live on September 22, 2026. Further down, the new page lists the condos for sale there, each with its unit number.

Edgecliff Private Residences, then and now: Live, September 2026
Edgecliff Private Residences, then and now: August 2024, Wayback Machine
August 2024, Wayback MachineLive, September 2026

See the archived page

The building page is where the decision happens

The building page is where the decision happens

Her original site put a building's details in small gray text next to a button that led somewhere else for listings. We designed every building page to answer both questions at once: what is this building, and what's for sale there right now.

Gallery

One search box: street, suburb, school district, zip code, MLS number or agent name.

One search box: street, suburb, school district, zip code, MLS number or agent name.

screenshot
103 buildings, filterable by river views, price, pet policy and building type.

103 buildings, filterable by river views, price, pet policy and building type.

screenshot
The unit number the MLS doesn't send, resolved by parcel lookup and shown right in the title.

The unit number the MLS doesn't send, resolved by parcel lookup and shown right in the title.

screenshot

Design System

The visual language we crafted for this project.

Color Palette

#db5003
buttons & links
#af4002
logo & hover state
#0b1321
navy overlays
#0b5cad
secondary accent
#fae5d9
surfaces & badges
#111827
headings & body

Typography

Headings

Urbanist

700800
Body

Arial

The quick brown fox jumps over the lazy dog. Clean, readable type that puts content first.

Our Strategy

A phased approach to delivering measurable results.

1

Put the listings on the building page

In November 2025 we rebuilt the site on Next.js so each building page could explain itself and show the condos for sale there, with an inquiry form on every building, listing and neighborhood page.

  • Next.js website
  • Building pages with their listings
  • Neighborhood guides
  • Inquiry forms on every building, listing and neighborhood page
2

Eight months with no monthly plan

From November 25, 2025 through July 25, 2026 there was no monthly plan, and no work from us after one round of updates in early December. The site brought in 165 inquiries and 11.6K clicks from Google on its own.

  • 165 inquiries, spam and sales pitches excluded
  • 11.6K Google Search clicks
  • 317K search impressions
3

Wire the site into Sonor

In September 2026, we connected the site to live MLS inventory, CRM records and email alerts, and gave Maria her Sonor sign-in for the admin she already used.

  • CincyMLS RESO feed
  • Sonor CRM routing
  • Per-building listing alerts
  • Sonor sign-in for her admin
4

Find the unit numbers the MLS doesn't send

Her MLS feed has no unit-number field, so we look up each condo's unit at the Hamilton County Auditor by parcel number. 165 of the 189 condos for sale on the site show it on cards, maps, page titles and leads (September 23, 2026).

  • Parcel-number lookup
  • Unit numbers on cards, maps, titles and leads

Results

Measurable outcomes that speak for themselves.

165 inquiries in eight months

Inquiries kept coming with no monthly plan

From November 25, 2025 through July 25, 2026, with no monthly plan and no work from us after early December, the Next.js build brought in 165 inquiries (spam, sales pitches and our own test excluded) and 11.6K clicks from 317K Google Search impressions.

measured
74 listings matched on day one

Live listings find their building

The CincyMLS feed carries 231 condo listings (189 for sale, 42 pending, September 23, 2026), and Sonor matches the ones in Maria's 105 buildings to their building pages automatically. On day one it matched 74, active and pending, to 27 buildings, agreeing with every address the old site had placed.

measured
165 of 189 for-sale condos show their unit

Unit numbers the MLS doesn't send

A parcel-number lookup at the county auditor supplies the unit the MLS leaves out, on cards, maps, page titles and inquiries.

measured
212 past inquiries migrated

Every past inquiry came into the new CRM

We moved all 212 past inquiries into Sonor's CRM (spam, sales pitches and our own test excluded), and new inquiries from building, listing and neighborhood pages carry the page they came from.

measured
96/100 mobile Lighthouse Performance

Faster on phones, with no third-party cookies on page view

Maps and video tours load on click, so a page view sets no Google or Vimeo cookies. Mobile Lighthouse Performance went from 66 on the original site to 96 on the live home page today (median of 3 PageSpeed Insights runs, September 23, 2026), with 100 for Accessibility, Best Practices and SEO.

measured
Google Search, eight months with no monthly plan

Google Search, eight months with no monthly plan

Google Search Console for November 25, 2025 through July 25, 2026. With no monthly plan and no work from us after early December, the site earned 11.6K clicks from 317K impressions, a 3.6% click-through rate at an average position of 10.3. These are Google Search numbers only. We didn't measure AI answers.

Performance

Mobile Lighthouse, median of 3 PageSpeed Insights runs, measured September 23, 2026 on cincinnaticondoconnection.com.

Before scores: single PageSpeed Insights mobile run on the original site, by Ramsey Deal.

96
Performance+30 pts
100
SEO+8 pts
100
Accessibility+18 pts
100
Best Practices+4 pts

Before (Original Site)

66Performance
92SEO
82Accessibility
96Best Practices

After (Next.js Rebuild)

96Performance
100SEO
100Accessibility
100Best Practices

Site Architecture

323 pages structured across 6 content categories.

/323 pages
323Pages
6Categories

Tech Stack

The technologies and tools powering this project.

N
Next.jsFramework

We used Next.js for the rebuilt condo discovery site and its reusable building pages.

R
ReactFrontend

React runs the listing search, maps and inquiry forms.

S
SonorPlatform

We used Sonor for the live MLS feed, lead records and alerts, and for Maria's sign-in to her own admin.

S
SupabaseDatabase

Maria's building content stays in the site's own Supabase database, separate from Sonor, and she edits it from her admin.

C
CincyMLS RESO feedData integration

We used the live MLS feed to publish active condo inventory to the relevant building pages.

H
Hamilton County AuditorPublic data integration

We used parcel records to resolve condo unit numbers the MLS feed doesn't send.

N
NetlifyHosting

The site runs on Netlify.

Services Provided

A breakdown of the services delivered for this project.

Next.js site rebuild

We rebuilt the condo research experience around the pages buyers need before they contact a Realtor.

  • A page for every building
  • Listing-aware page templates
  • Search by street, school district, ZIP or MLS number

Live MLS and unit-data integration

We connected CincyMLS inventory, automated building matches and filled missing unit numbers through parcel lookup.

  • RESO feed connection
  • Building matching
  • Hamilton County Auditor lookup

Lead operations

We brought her past inquiries into Sonor, and new inquiries carry the building, listing or neighborhood they came from.

  • CRM migration
  • Building and listing context
  • Neighborhood context

Owner-controlled content

We kept Maria in control of her building content, behind her Sonor sign-in.

  • Sonor sign-in for her admin
  • Editable building content

Project Details

IndustryReal Estate
Launch DateLate November 2025

Make every property inquiry useful

If your buyers research properties by building, neighborhood or listing, we can build the data and lead workflow around how they actually decide.