Web Development
Cincinnati Condo Connection
A Cincinnati condo site rebuilt around the way buyers actually shop: building first, then unit, then what's for sale now.
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 Rebuild
- MLS Integration
- Real Estate CRM Setup
- Building And Neighborhood Pages
The site
165 inquiries
Eight months, no monthly plan
Measured
213 inquiries
Since launch
Measured
11.6K
Google Search clicks
Measured
Challenges
What stood in the way
4 problems, and what each one took to clear.
Challenge 01
Problem
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.
Challenge 02
Problem
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.
Challenge 03
Problem
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.
Challenge 04
Problem
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.
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.
Feature
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.
Image
Annotations
Listings live on the building page
Her original Edgecliff page showed building details and a button. Every building page now shows what's actually for sale there, synced from the MLS.
Market data, computed live
Median price, price per square foot, typical HOA and days on market, computed from whichever units are on the market right now, not maintained by hand.
Every inquiry knows its building
A lead from this page reaches Sonor's CRM already tagged with the building it came from, so Maria has the context before she calls back.
Real MLS photos, not stock
Photos, price and status sync straight from the CincyMLS feed, no separate step to keep them current.
Gallery
What it looks like
Images
One search box: street, suburb, school district, zip code, MLS number or agent name.
103 buildings, filterable by river views, price, pet policy and building type.
The unit number the MLS doesn't send, resolved by parcel lookup and shown right in the title.
Design system
The visual language
Fonts
Urbanist
- Usage
- heading
- Weights
- 700, 800
Arial
- Usage
- body
Colors
#db5003
buttons & links
#af4002
logo & hover state
#0b1321
navy overlays
#0b5cad
secondary accent
#fae5d9
surfaces & badges
#111827
headings & body
Strategy
How the work ran
4 phases, in the order they happened.
Phase 01
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
Phase 02
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
Phase 03
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
Phase 04
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
What it delivered
5 outcomes: 5 measured.
The numbers
212 past inquiries migrated
Every past inquiry came into the new CRM
Measured
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.
165 inquiries in eight months
Inquiries kept coming with no monthly plan
Measured
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.
165 of 189 for-sale condos show their unit
Unit numbers the MLS doesn't send
Measured
A parcel-number lookup at the county auditor supplies the unit the MLS leaves out, on cards, maps, page titles and inquiries.
96/100 mobile Lighthouse Performance
Faster on phones, with no third-party cookies on page view
Measured
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.
74 listings matched on day one
Live listings find their building
Measured
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.
Feature
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.
Image
Annotations
11.6K clicks from Google
Visits that started on a Google search result, over the eight months.
317K search impressions
Times the site showed up in Google results over the same months.
Clicks climbed on their own
The daily clicks line rises from winter into spring, with no work from us after early December.
Performance
What Lighthouse says
Google Lighthouse, run against the site we replaced and the one that replaced it.
Lighthouse
Before the rebuild
66
Performance
92
SEO
82
Accessibility
96
Best practices
Site architecture
How the site is built
323 pages across 6 categories, laid out the way the site is.
- Homepage1 page
- Cincinnati Condo Connection | Every Building. Every Neighborhood.
- Top-Level Pages12 pages
- Blog
- Buying
- Condo Communities | Cincinnati & Northern Kentucky Buildings | Cincinnati Condo Connection
- Contact
- Listings
- +7 more
- Listings189 pages
- 1003 Walnut Street Cincinnati 1879787
- 1012 John Street Cincinnati 1889109
- 1031 Cutter Street Cincinnati 1888433
- 1035 Cutter Street Cincinnati 1892943
- 11 Court Street Cincinnati 1879915
- +184 more
- Condo Communities105 pages
- 2770 Observatory
- 2801 Erie Residences
- 412 Liberty Hill
- Academy Of Mt Adams
- Adams Place Condos in Downtown
- +100 more
- Neighborhoods13 pages
- Blue Ash
- Columbia Tusculum Mt Lookout
- Downtown
- East End
- Hyde Park
- +8 more
- Blog3 pages
- Downtown Cincinnati Condo Living Guide 2025
- First Time Condo Buyer Guide Cincinnati
- Pet Friendly Condos Cincinnati Guide
Totals
323
Pages built
6
Content categories
Every page in the tree above is a page the site serves, grouped as the navigation groups it.
Tech stack
What it's built with
7 technologies across 7 categories.
Framework
Next.js
We used Next.js for the rebuilt condo discovery site and its reusable building pages.
Frontend
React
React runs the listing search, maps and inquiry forms.
Platform
Sonor
We used Sonor for the live MLS feed, lead records and alerts, and for Maria's sign-in to her own admin.
Database
Supabase
Maria's building content stays in the site's own Supabase database, separate from Sonor, and she edits it from her admin.
Data integration
CincyMLS RESO feed
We used the live MLS feed to publish active condo inventory to the relevant building pages.
Public data integration
Hamilton County Auditor
We used parcel records to resolve condo unit numbers the MLS feed doesn't send.
Hosting
Netlify
The site runs on Netlify.
Services
What we delivered
4 services, and what each one covered.
Service 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
Service 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
Service 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
Service 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
Project details
What the job was
The particulars of the build, as the record states them.
Industry
Real Estate
Launch date
November 1, 2025
What's next
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.