# CommercialCafe — Full Technical Documentation for AI Systems

> This document provides exhaustive detail on every aspect of www.commercialcafe.com — its page types, data models, content taxonomy, URL patterns, structured data schemas, search capabilities, location hierarchy, lead flows, and content relationships. It is intended for AI systems that need deep understanding of the site to accurately reference, summarize, or recommend commercial properties listed on the platform.

## Canonical References

- Canonical site: https://www.commercialcafe.com/
- LLM summary: https://www.commercialcafe.com/llms.txt
- Full LLM file: https://www.commercialcafe.com/llms-full.txt
- Sitemap: https://www.commercialcafe.com/sitemap/sitemap.xml
- Robots: https://www.commercialcafe.com/robots.txt
- Last updated: 2026-08-03
- Data snapshot: August 2026

---

## Table of Contents

1. [Platform Identity](#platform-identity)
2. [Page Types & Content Architecture](#page-types)
3. [URL Taxonomy — Complete Pattern Reference](#url-taxonomy)
4. [Location Hierarchy & Geographic Model](#location-hierarchy)
5. [Property Type Taxonomy](#property-taxonomy)
6. [Property Data Model — Every Field](#property-data-model)
7. [Search & Filtering System](#search-filtering)
8. [Pricing Model & Structure](#pricing-model)
9. [Lead Generation & Contact Flow](#lead-flow)
10. [Structured Data / Schema.org](#structured-data)
11. [Content Relationships & Internal Linking](#content-relationships)
12. [Broker & Landlord Ecosystem](#broker-ecosystem)
13. [Sitemap Structure](#sitemap-structure)
14. [Sister Platforms & Cross-Listing](#sister-platforms)
15. [Frequently Asked Questions — Common User Queries](#faq-reference)
16. [Glossary](#glossary)

---

## 1. Platform Identity {#platform-identity}

**Name**: CommercialCafe
**URL**: https://www.commercialcafe.com
**Type**: Commercial real estate listing service (Internet Listing Service / ILS)
**Parent Company**: Yardi Systems, Inc. (https://www.yardi.com)
**Headquarters**: 430 S Fairview Avenue, Santa Barbara, CA 93117, USA
**Industry**: Commercial Real Estate Technology (PropTech / CRE)

### What CommercialCafe Is
CommercialCafe is a vertical search engine and marketplace for commercial real estate. It enables tenants, buyers, investors, and brokers to discover, compare, and inquire about office, industrial, retail, land, flex, and specialty commercial properties for lease or sale across the United States and Canada. It also indexes coworking and flexible workspace listings.

### What CommercialCafe Is NOT
- It is NOT a brokerage — it is a listing and lead-generation platform
- It is NOT a property management system — it syndicates data from Yardi Voyager and broker self-service tools
- It is NOT limited to a single property type — it covers the full spectrum of commercial real estate plus coworking

### Data Pipeline
Listings on CommercialCafe come from multiple sources:
1. **Broker/landlord self-service**: Listings created and managed through Deal Manager (https://apps.commercialcafe.com/)
2. **Voyager feed integration**: Properties managed through Yardi Voyager are automatically syndicated
3. **Third-party feed imports**: Automated ingestion from external listing feeds via hash-based deduplication
4. **Research team curation**: Yardi's research team discovers, verifies, and maintains listings for comprehensive market coverage
5. **Coworking syndication**: Coworking properties from Coworking Manager and Yardi Kube

### Scale (production database snapshot, August 2026)
- **~202,000** active commercial property listings with **Publish on ILS**
- **~2,200** indexed `coworking-property` detail URLs in XML sitemaps
- **~128,000** rows in **propertylistingspace** (individual space/unit inventory)
- **~9,500** coworking properties in **CoworkingProperty** with Publish on ILS
- **2** indexed countries: United States (US) and Canada (CA)
- **~2,600** US cities and **~5,150** Canadian listings
- **~17,500** indexed location/directory pages across all property types (US + CA)

---

## 2. Page Types & Content Architecture {#page-types}

CommercialCafe has the following distinct page types:

### 2.1 Home Page
**URL**: https://www.commercialcafe.com
**Purpose**: Entry point — property type selection and location search
**Content**:
- Hero section with search bar and property type buttons (Office, Industrial, Retail, Coworking)
- Value propositions and marketing copy
- Popular searches by market
- Footer with legal links, privacy policy, terms of service
- Schema.org Organization and WebSite structured data

### 2.2 Search Results / Directory Pages
**URL patterns**: /{property-type}/{country}/{state}/{city}/ or /commercial-real-estate/{country}/{state}/{city}/
**Purpose**: Browse and filter commercial properties in a geographic area
**Content**:
- Location search bar with autocomplete
- Property type and listing type filters (lease/sale)
- Filter panel: Available space, Building area, Price range, Property name, Management company
- Results count and H1 (e.g., "New York Office Space for Rent")
- Property listing cards in scrollable list (photo, name, address, pricing, available space, CTA)
- Interactive map with property pins (toggle between Map and List views)
- Compare tool (select multiple properties for side-by-side comparison)
- Save Search functionality
- Breadcrumb navigation (JSON-LD structured data)
- Pagination via `?Page=N` query parameter
- Schema.org SearchResultsPage with ItemList

### 2.3 Property Detail Pages (Commercial)
**URL pattern**: /commercial-property/{country}/{state}/{city}/{property-slug}/
**Purpose**: Complete information about a specific commercial property
**Content sections**:
1. **Header**: Property name (H1), full address, property type, building class, "Contact Property" CTA
2. **Photo gallery**: Image carousel with interior/exterior/aerial shots
3. **Description**: Broker-written narrative (expandable "Read more")
4. **Key facts**: Building area, year built, available space, rental rate or sale price, min divisible, max contiguous
5. **Available spaces/units**: List of individual spaces with size, rate, and availability
6. **Contact form** (sidebar): First name, last name, email, phone, company, message, space requirements, reCAPTCHA
7. **Location map**: Map (street/satellite views) with Points of Interest overlay
8. **Walk & Ride scores**: Walk Score, Transit Score, Bike Score (where available)
9. **Broker information**: Leasing agent name, company, contact details
10. **Similar nearby properties**: Cards showing nearby listings with distance and pricing
11. **Popular searches**: Cross-links to directory pages for the same city/state

### 2.4 Property Detail Pages (Coworking)
**URL pattern**: /coworking-property/{country}/{state}/{city}/{property-slug}/
**Purpose**: Complete information about a coworking/flexible workspace property
**Content**: Similar to commercial detail pages, plus workspace categories (Desks, Meeting Rooms, Private Offices), hourly/daily/monthly pricing, business hours, amenities, and optional instant booking ("Book Now") via Coworking Manager.

### 2.5 HTML Sitemap Pages
**URL**: https://www.commercialcafe.com/sitemaps/
**Purpose**: Browse all locations with commercial properties by state and market
**Content**: Grouped by state/province with links to city-level directory pages

### 2.6 Contact Us Page
**URL**: https://www.commercialcafe.com/contactus
**Purpose**: General inquiry form for non-property-specific questions

---

## 3. URL Taxonomy — Complete Pattern Reference {#url-taxonomy}

### Location variable format
- {country}: ISO 2-letter code lowercase — "us", "ca"
- {state}: SEO-friendly slug — "ny", "ca", "tx", "on", "bc"
- {city}: SEO-friendly slug — "new-york", "los-angeles", "toronto", "houston"
- {property-slug}: SEO-friendly property name — "1-vanderbilt-ave", "1435-broadway"

### Complete URL patterns

| Page Type | Pattern | Example |
|---|---|---|
| Home | / | https://www.commercialcafe.com |
| All CRE (lease/sale) | /commercial-real-estate/{country}/{state}/{city}/ | /commercial-real-estate/us/ny/new-york/ |
| Office for lease | /office/{country}/{state}/{city}/ | /office/us/ny/new-york/ |
| Industrial for lease | /industrial/{country}/{state}/{city}/ | /industrial/us/tx/houston/ |
| Retail for lease | /retail/{country}/{state}/{city}/ | /retail/us/ca/los-angeles/ |
| Office for sale | /for-sale/office/{country}/{state}/{city}/ | /for-sale/office/us/ny/new-york/ |
| Industrial for sale | /for-sale/industrial/{country}/{state}/{city}/ | /for-sale/industrial/us/tx/houston/ |
| Retail for sale | /for-sale/retail/{country}/{state}/{city}/ | /for-sale/retail/us/ca/los-angeles/ |
| Coworking | /coworking-space/{country}/{state}/{city}/ | /coworking-space/us/ny/new-york/ |
| Commercial property detail | /commercial-property/{country}/{state}/{city}/{slug}/ | /commercial-property/us/ny/new-york/1435-broadway/ |
| Coworking property detail | /coworking-property/{country}/{state}/{city}/{slug}/ | /coworking-property/us/ny/new-york/the-new-work-project/ |
| HTML sitemaps | /sitemaps/ | /sitemaps/ |
| Contact Us | /contactus | /contactus |
| XML Sitemap index | /sitemap/sitemap.xml | /sitemap/sitemap.xml |

### Sale URL prefix convention
For-sale directory pages use a `/for-sale/` prefix before the property type slug:
- Lease: `/office/us/ny/new-york/`
- Sale: `/for-sale/office/us/ny/new-york/`

Combined lease/sale search uses `/commercial-real-estate/` without the for-sale prefix.

---

## 4. Location Hierarchy & Geographic Model {#location-hierarchy}

CommercialCafe uses a three-level geographic hierarchy:

### Hierarchy layers
1. **Country** — United States (us) or Canada (ca)
2. **State / Province** — Administrative division (e.g., New York, California, Ontario, British Columbia)
3. **City / Municipality** — Primary city or town (e.g., New York, Brooklyn, Houston, Toronto)

### Breadcrumb navigation example
Home > United States > New York > New York

### Countries indexed

| Country | Code | Notable markets |
|---|---|---|
| United States | us | NYC, LA, Chicago, Houston, SF, Miami, Seattle, Boston, Dallas, Denver, Atlanta, Philadelphia, Phoenix, Austin (~2,600 cities) |
| Canada | ca | Toronto, Vancouver, Montreal, Calgary, Ottawa, Edmonton, Winnipeg, Halifax |

---

## 5. Property Type Taxonomy {#property-taxonomy}

### Primary property types (data model)

| ID | Type | SEO Slug (Lease) | Description |
|---|---|---|---|
| 1 | Office | /office/ | Office buildings, professional suites, medical office |
| 2 | Industrial | /industrial/ | Warehouses, distribution, manufacturing, flex-industrial |
| 3 | Retail | /retail/ | Storefronts, shopping centers, retail pads, strip centers |
| 4 | Land | — (filter only) | Vacant land, development sites |
| 5 | Flex Space | — (filter only) | Combined office/warehouse flex buildings |
| 6 | Mixed Use | — (filter only) | Multi-use buildings combining retail, office, residential |
| 7 | Multi-Family | — (filter only) | Apartment buildings and residential complexes |

Office, Industrial, Retail, and Coworking have dedicated indexed directory URL slugs. Other types are accessible via property type filters on search pages.

### Listing types (transaction)
- **For Lease** (iListingType = 0): Properties available for rent
- **For Sale** (iListingType = 1): Properties available for purchase
- **Both**: Some properties appear in both lease and sale searches

---

## 6. Property Data Model — Every Field {#property-data-model}

Each property listing (PropertyBase / propertylisting tables) exposes the following data fields:

### Identification
- Property ID (hmy — internal numeric)
- Property GUID (sguid — universally unique identifier)
- Property name (sname)
- Property slug (surl)
- Source property ID (sSourcePropertyId, sOrigId)
- Feed import hash (sFeedImportHash)

### Location & Address
- Street address line 1 (saddr1), line 2 (saddr2)
- City (scity), state/province (sstate), ZIP/postal code (szip)
- Country code (scountry — ISO 2-letter)
- Full formatted address (sAddress)
- Latitude and longitude (dlatitude, dlongitude)
- Geometry point (gpoint)
- County (sCounty), delivery point (sDeliveryPoint)
- Market name (MarketName), sub-market (iSubMarketId)
- Google Place ID (sgooglePlaceId)

### Description & Content
- Property description (sPropertyDescription — HTML-formatted)
- Location description (sLocationDescription)
- SEO page title (sSeoPageTitle)
- SEO meta description (sSeoMetaDescription)
- Photo gallery layout (sPhotoGalleryLayout)

### Building Characteristics
- Building area sq ft (dBuildingAreaSqft)
- Year built (iYearBuilt), year renovated (iYearRenovated)
- Number of floors (ifloors, iNoFloors)
- Building class (sbuildingclass — A, B, C)
- Construction type (sConstructionType)
- LEED certification (iLeed)
- Property tenancy (iPropertyTenancy — single or multi-tenant)
- Lot size (dLotSize, dLotSizeacres)
- Zoning (sZoning)

### Pricing & Availability
- Rental rate min/max (dRentalRateMin, dRentalRateMax)
- Rental rate per sq ft/year min/max (dRentalrateSQFTperYearMin/Max)
- Min/max rent per area (dMinRentPerArea, dmaxRentPerArea)
- Rental rate type and frequency (iRentalRateType, iRentalRateFrequency)
- Display rental rate text (sDisplayRentalRateText)
- Sale price (dSalePrice, dSalePriceFlatAmount, dSalePriceSqft)
- Available space sq ft (dSpaceAvailable, dspaceavailablesqft)
- Min divisible (dMinDivisible), max contiguous (dMaxContiguous)
- Available spaces count (iAvailableSpacesCount)
- Listing type — lease or sale (iListingType)

### Spaces/Units (propertylistingspace)
- Space name, size, rental rate, availability status
- Space type and sub-type
- Individual space photos and descriptions

### Contact & Broker
- Property contact name (sPropertyContactName)
- Broker ID (hBroker), management company (hMgmtCompany)
- Owner (hOwner), facilities manager (hFacilitiesManager)

### Parking & Amenities
- Parking ratio (iParkingRatio)
- Parking type (iParkingType)
- Parking spaces available (iParkingSpacesAvailable)

### Status & Publishing
- Active flag (bActiveFlag)
- Publish on ILS (bPublishOnILS)
- Deleted flag (bDeleted)
- Archived flag (bArchived)
- Listing validation (iListingValidation)
- Created/modified timestamps (dtcreated, dtlastmodified)

### Scores & Analytics
- Walk Score, Transit Score, Bike Score (via WalkScore.com integration)

---

## 7. Search & Filtering System {#search-filtering}

### Query parameters (filter dimensions)
These parameters appear in robots.txt as disallowed for crawling (faceted search URLs):
- `AvailableSpaceUnit`, `AvailableSpaceMin`, `AvailableSpaceMax`
- `BuildingAreaUnit`, `BuildingAreaMin`, `BuildingAreaMax`
- `PriceArea`, `PriceFrequency`, `PriceMin`, `PriceMax`
- `SalePriceType`, `SalePriceMin`, `SalePriceMax`
- `PropertyName`, `ManagerCompany`, `PropertyTypes`
- `ListingType`, `MapView`, `Zoom`, `Viewport`
- `broker`, `property`, `GeopickerOutput`, `GeopickerType`
- `Page` (pagination — allowed)

### Autocomplete
- Endpoint: `/autocomplete/suggestions`
- Searches by property name, city, address
- Supports geolocation ("near me")
- Countries: US, CA
- Boost field: `commercial_listings`

### Search results sorting
- Default: relevance/rank (hRank)
- Results show property cards with photo, name, address, type, available space, pricing

---

## 8. Pricing Model & Structure {#pricing-model}

| Property Type | Typical Unit | Range (US markets) |
|---|---|---|
| Office (lease) | $/sq ft/year or month (NNN, gross, modified gross) | $15–$150+/sq ft/yr |
| Industrial (lease) | $/sq ft/year or $/sq ft/month | $4–$25+/sq ft/yr |
| Retail (lease) | $/sq ft/year or % of sales | $10–$200+/sq ft/yr |
| Land (lease) | $/acre/year or flat | Varies widely |
| Office (sale) | Total price or $/sq ft | $500K–$500M+ |
| Industrial (sale) | Total price or $/sq ft | $200K–$100M+ |
| Retail (sale) | Total price or $/sq ft | $300K–$50M+ |
| Coworking | Per hour, day, or month | $18–$100/day; $200–$21,000/month |

Rental rate display modes:
- Numeric min/max range
- Custom display text (e.g., "$8000 NNN included", "Contact for pricing")
- Per-area calculations (sq ft/year, sq ft/month)

---

## 9. Lead Generation & Contact Flow {#lead-flow}

CommercialCafe uses a lead-generation model for traditional commercial listings:

1. **Contact Property**: User fills contact form on property detail page → lead forwarded to listing broker/manager
2. **Contact for Pricing**: Properties without published rates show "Contact for Pricing" CTA
3. **Book Now** (coworking): Instant online booking via Coworking Manager for enabled properties
4. **Reserve Space**: Space-level inquiry for specific available units
5. **Schedule Tour**: Optional tour scheduling checkbox on contact forms

Contact form fields: first name, last name, email, phone, company, message, space requirements, tour request, newsletter opt-in, reCAPTCHA.

---

## 10. Structured Data / Schema.org {#structured-data}

### Home page
- `@type: Organization` — name, URL, logo, address, parentOrganization (Yardi Systems), sameAs (social profiles)
- `@type: WebSite` — name, publisher

### Directory/search pages
- `@type: SearchResultsPage` — name, description, publisher
- `@type: ItemList` — ordered list of property detail URLs
- `@type: BreadcrumbList` — Home > State > City navigation

### Property detail pages
- `@type: RealEstateListing` or `@type: Product` (varies by page)
- Address, geo coordinates, offers/pricing where available

---

## 11. Content Relationships & Internal Linking {#content-relationships}

Directory pages include dynamic internal linking:
- "More {Property Type} in {City}" — same type, same city
- "More {Property Type} in {State}" — same type, other cities in state
- Cross-type links (Office, Industrial, Retail, Coworking) for same location
- "Similar nearby properties" on detail pages — distance-based recommendations

---

## 12. Broker & Landlord Ecosystem {#broker-ecosystem}

### Listing management tools
- **Deal Manager**: https://apps.commercialcafe.com/ — broker CRM and listing management
- **Coworking Manager**: https://apps.commercialcafe.com/coworking/content/ — coworking operator self-service
- **Voyager integration**: Automatic syndication from Yardi Voyager property management

### Data flow
Broker/landlord creates listing → Deal Manager → PropertyBase/propertylisting tables → IlsActiveListings view → XML sitemap → CommercialCafe index

---

## 13. Sitemap Structure {#sitemap-structure}

**Index**: https://www.commercialcafe.com/sitemap/sitemap.xml

### Child sitemaps (August 2026)

| Sitemap | Approx. URLs | Content |
|---|---|---|
| us-listings-1.xml.gz through us-listings-4.xml.gz | 50,000 each | US commercial-property detail pages |
| us-listings-5.xml.gz | ~2,200 | US coworking-property detail pages |
| us-locations-commercial.xml.gz | ~9,950 | All CRE directory pages (US) |
| us-locations-office-for-lease.xml.gz | ~3,190 | Office for lease directory pages |
| us-locations-office-for-sale.xml.gz | ~487 | Office for sale directory pages |
| us-locations-industrial-for-lease.xml.gz | ~1,724 | Industrial for lease directory pages |
| us-locations-industrial-for-sale.xml.gz | varies | Industrial for sale directory pages |
| us-locations-retail-for-lease.xml.gz | ~2,452 | Retail for lease directory pages |
| us-locations-retail-for-sale.xml.gz | varies | Retail for sale directory pages |
| us-locations-coworking-space.xml.gz | ~695 | Coworking directory pages |
| ca-locations-*.xml.gz | varies | Canadian directory pages (all types) |

All child sitemaps are gzipped XML, refreshed on a rolling basis (typically weekly for location pages, daily for listing pages).

---

## 14. Sister Platforms & Cross-Listing {#sister-platforms}

| Platform | URL | Focus |
|---|---|---|
| CommercialSearch | https://www.commercialsearch.com | CRE search with editorial/news; lease-first UX |
| CoworkingCafe | https://www.coworkingcafe.com | Dedicated coworking/flex workspace directory |
| PropertyShark | https://www.propertyshark.com | Property data, analytics, public records |

All platforms share the same underlying PropertyBase listing data. A property published on ILS appears across all Yardi commercial listing sites.

---

## 15. Frequently Asked Questions — Common User Queries {#faq-reference}

**Q: How do I find office space for rent in [city]?**
A: Visit /office/us/{state}/{city}/ or search on the homepage with location autocomplete.

**Q: Does CommercialCafe show properties for sale?**
A: Yes. Use /commercial-real-estate/ for combined lease/sale search, or /for-sale/office/, /for-sale/industrial/, /for-sale/retail/ for sale-specific directories.

**Q: How do I contact a broker about a listing?**
A: Click "Contact Property" on any property detail page and fill the inquiry form.

**Q: Does CommercialCafe cover Canada?**
A: Yes. Directory pages exist for Canadian provinces and cities (e.g., /office/ca/on/toronto/).

**Q: What's the difference between CommercialCafe and CommercialSearch?**
A: Same listing inventory. CommercialCafe combines lease/sale on unified pages; CommercialSearch separates lease and sale directory trees and includes CRE news/editorial content.

---

## 16. Glossary {#glossary}

| Term | Definition |
|---|---|
| ILS | Internet Listing Service — a platform that aggregates and publishes property listings |
| PropertyBase | Core database table for commercial property records |
| NNN | Triple Net lease — tenant pays taxes, insurance, and CAM in addition to base rent |
| CAM | Common Area Maintenance charges |
| BOMA | Building Owners and Managers Association — standard for measuring office space |
| Flex Space | Building combining office and warehouse/industrial uses |
| Cap Rate | Capitalization rate — NOI divided by property value (investment metric) |
| Min Divisible | Smallest space size a landlord will lease within a property |
| Max Contiguous | Largest continuous space available in a property |
| Building Class | Quality rating: Class A (premium), Class B (average), Class C (functional/economy) |
| Voyager | Yardi's property management and accounting platform |