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.
View live site- Next.js Rebuild
- MLS Integration
- Real Estate CRM Setup
- Building And Neighborhood Pages
01HeatAct 1 of 4
Where the heat was.
We turned Cincinnati Condo Connection into a condo research site where buyers could find a building, identify a unit and see live inventory.
We started with a site where building research ended before listings: Edgecliff showed building details but no condos for sale. The MLS omitted unit numbers, listing sync had stopped, and inquiries lacked source context.
The problem
Four things stood in the way.
What the work had to clear, and how each one was cleared.
Challenge 1: 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.
How we cleared it
We made each building page the place to learn about the property and, for her Ohio buildings, see the condos for sale there.
ResultBuyers can research a building and act on its live inventory from the same page.
Challenge 2: 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.
How we cleared it
We checked every field the feed sends, then used parcel numbers to look up each unit at the Hamilton County Auditor.
ResultListing cards, maps, page titles and lead records now identify the condo a buyer asked about.
Challenge 3: 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.
How we cleared it
We wired CincyMLS data into Sonor's real-estate module and automated the building match.
ResultOn 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.
Challenge 4: 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.
How we cleared it
We routed every inquiry into Sonor's CRM, and inquiries from building, listing and neighborhood pages carry the page they came from.
ResultMaria can open a lead and see which condo or area started the conversation.
Before and after
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.
Before: Cincinnati Condo Connection project: before the redesign, August 2024, Wayback Machine. After: Cincinnati Condo Connection project: after the redesign, Live, September 2026.
Feature spotlight
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.
The work, up close
Gallery
3 frames from the finished site. Open any one to see it full size.
The design system
The visual language we set for the site.
Colour, type and the rules that hold them together, so every page we add later is unmistakably theirs.
Palette
Typography
HeadingsUrbanist
Arial
Every page we add later is unmistakably theirs.
The quick brown fox jumps over the lazy dog. Clean, readable type that puts content first.
Urbanist for headings, Arial for body copy.
Build history
Project timeline.
How the work unfolded, with the decisions, releases, and deliverables recorded along the way.
01Milestone
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.
Clearschallenge 01: A building page didn't answer the building question
Handed over
- Next.js website
- Building pages with their listings
- Neighborhood guides
- Inquiry forms on every building, listing and neighborhood page
02Milestone
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.
Handed over
- 165 inquiries, spam and sales pitches excluded
- 11.6K Google Search clicks
- 317K search impressions
03Milestone
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.
Clearschallenge 03: The old listing sync had stopped
Handed over
- CincyMLS RESO feed
- Sonor CRM routing
- Per-building listing alerts
- Sonor sign-in for her admin
04Milestone
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. 178 of the 213 condos for sale on the site show it on cards, maps, page titles and leads (October 12, 2026).
Clearschallenge 02: The MLS didn't know the unit number
Handed over
- Parcel-number lookup
- Unit numbers on cards, maps, titles and leads
Feature spotlight
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.
The structure
How the site is laid out.
346 pages structured across 6 content categories.
The materials
Seven tools in the build.
What the finished site runs on, and what each piece is there to do.
- NNext.jsFramework
We used Next.js for the rebuilt condo discovery site and its reusable building pages.
- RReactFrontend
React runs the listing search, maps and inquiry forms.
- SSonorPlatform
We used Sonor for the live MLS feed, lead records and alerts, and for Maria's sign-in to her own admin.
- SSupabaseDatabase
Maria's building content stays in the site's own Supabase database, separate from Sonor, and she edits it from her admin.
- CCincyMLS RESO feedData integration
We used the live MLS feed to publish active condo inventory to the relevant building pages.
- HHamilton County AuditorPublic data integration
We used parcel records to resolve condo unit numbers the MLS feed doesn't send.
- NNetlifyHosting
The site runs on Netlify.
The checks
Measured before, and measured after.
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.
Before and after
The outcome
What the finished work is doing.
The outcomes the project produced, with the source of each number beside it.
The handover
Four things we delivered.
The work that went into the finished build, and what each part of it covered.
- 01
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
- 02
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
- 03
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
- 04
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
The record
The project, on one sheet.
The facts of the engagement, for the record.
- Industry
- Real Estate
- Launched
- Late 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.
