C
Cyrano Security
12 min read
For sellers, listing brokers, and buyer reps in DD

The buyer’s lawyer already wrote the query. You just need to type it into the search box.

Every multifamily DD exchange starts with a 40 line checklist emailed from the buyer’s rep to the seller’s lawyer. Questions like “any package theft at the lobby in the last 90 days” and “vehicle dwelling after hours in the side lot.” The usual answer is a single sentence per question, written by a person who has never opened the DVR. The evidence link is blank.

This guide is the other way. The English sentence the lawyer wrote is the sentence you type into Cyrano’s natural language footage search. Every DD row becomes a count, a timestamp range, and a folder of 480x270 JPEG thumbnails. Forty rows in one afternoon. The data room gets a file called dd_query_dossier.csv instead of a thread of emails.

See the dossier run on a live DVR
4.9from 50+ properties
DD question typed verbatim into Cyrano's NL search
5 column dossier row: query, count, ts range, thumbs, confidence
Typical throughput: 40 DD questions handled in one afternoon
HDMI tap is read only, no DVR credentials required

Why the top results for “multifamily for sale” have no DD workflow at all

Type “multifamily for sale” into Google. Page one is LoopNet, Crexi, CBRE DealFlow, Marcus & Millichap, Ten-X, Zillow Commercial. Every one of them is a listings marketplace. Their product is a filter on cap rate, unit count, submarket, year built, and a carousel of 30 to 50 exterior photos. None of them publish anything on how DD gets answered after the LOI goes in, because that conversation happens in email between lawyers, not on the listing page.

Search for “multifamily due diligence checklist” and the top results come from BiggerPockets, Roofstock, Adventures in CRE, and Multifamily.loans. Each one is a PDF of 40 to 60 bullet points. The instruction next to every item is some version of “ask the seller for this.” Not one of them has a workflow that turns the bullet into a typed query with evidence attached. That is the gap this page fills.

The rest of this page is the workflow. The English sentence the lawyer wrote, typed verbatim into Cyrano’s natural language search box, producing one dossier row per DD question.

DD question list becomes a query dossier

DD Q01
DD Q07
DD Q14
DD Q22
DD Q31
Cyrano
count
range
thumbs
confidence
row

Left is the buyer’s DD checklist in its original English sentences. Right is what each sentence becomes after Cyrano runs the query. The hub is the product doing the translation in place, on the same HDMI tap that already sits inline with the DVR in the office closet.

One DD question, typed into the search box

Here is what the broker does when they open Cyrano during the DD window. The English sentence at the top is the verbatim text from the buyer’s DD email for question 17. Nothing is translated into SQL or tile labels. The model reads the sentence, searches the last 90 days of indexed footage, and returns the count plus a thumbnail list.

cyrano NL search — DD_017

One row of the dossier, in JSON

The dossier is the 40 row CSV the broker drops into the data room. Each row has a fixed schema. The row below is DD_017, produced by the terminal run above. The english_query_string is the sentence the lawyer wrote. Nothing else about it is rewritten.

dd_query_dossier.row.json
Anchor fact

The english_query_string column is the exact sentence the lawyer wrote, not a rewrite

Cyrano’s natural language footage search accepts a plain English sentence as input. The product page copy calls out “masked man near gate” and “person loitering at entrance” as canonical examples. The dossier row preserves the lawyer’s sentence verbatim in the english_query_string field, so the buyer’s rep can verify on audit that the question they asked is the one that was run. No tile labels, no regex, no SQL is substituted at query time.

This matters during a contested DD exchange. If the buyer’s rep later argues that the seller ran a watered-down version of the question, the dossier row shows otherwise. The english_query_string equals the DD question by construction. The only other fields the seller controls are the ts range window and the tile scope, both of which are recorded in the row for inspection.

Six DD questions and the English query that answered each

These are pulled from a DD question list on a 312 unit Class B property. The row on each card is what the broker typed into Cyrano’s search box and the resulting count. Each card also surfaces the tile.label that the model mapped the sentence onto, for verifiability.

Package theft, lobby

query: any package left unattended at the lobby for more than 30 minutes in the last 90 days. matched: 9. tiles: Lobby Mailroom, Package Room.

Pool gate loitering, after hours

query: any person loitering near the pool gate after 11pm in the last 90 days. matched: 14. tiles: Pool Gate, Pool Deck South.

Vehicle dwell, side lot

query: any vehicle dwelling in the side lot after hours in the last 90 days. matched: 21. tiles: South Parking, East Gate Cam.

Tailgate, pedestrian gate

query: any unauthorized follow through the pedestrian gate in the last 90 days. matched: 18. tiles: Pedestrian Gate.

Tampering, meter room

query: any person tampering near the meter room in the last 90 days. matched: 0. tiles: Meter Room Exterior.

Dumpster scavenging, non residents

query: any non resident at the dumpster area in the last 90 days. matched: 31. tiles: Dumpster West, Dumpster East.

DD email thread, versus DD Query Dossier

The same 40 DD questions. Different artifact. On the left is what the buyer’s rep gets today, a thread of email paragraphs written by a lawyer. On the right is what the same questions look like rendered as dossier rows with evidence attached.

Lawyer writes a paragraph per question. Attachments are occasional and inconsistent. Each answer is a claim, not evidence. Back and forth takes 3 to 5 business days.

  • One paragraph per question, no structured fields
  • Evidence link is usually blank
  • Lawyer wrote the claim, not the person who watched footage
  • Buyer's rep reads 40 paragraphs and underlines risk
  • 3 to 5 day round trip before LOI vetted

Dossier production flow, from email to data room

Five steps, no cooperation required from the DVR admin, no recorder credentials. The only prerequisite is that the Cyrano unit was plugged into the HDMI output of the recorder at or before the time the OM went out.

DD question to dossier row

1

DD email arrives

Buyer's rep sends the 40 line question list to the seller's lawyer in the usual way. No change to the buyer side.

2

Broker opens Cyrano

Logs into the dashboard. Navigates to the NL search box that already ships with the product.

3

Paste English query

The sentence from the DD email goes directly into the search box. No rewriting. No SQL. No tile mapping.

4

Model returns row

Count, ts range, thumbnail gallery, model_confidence. One row of dd_query_dossier.csv per DD question.

5

Row lands in data room

CSV and thumbs folder drop into the same data room that holds the T-12 and the rent roll. Buyer's rep reads 40 rows.

The 21 day inspection window, day by day

A typical mid market multifamily deal has a 21 day inspection window. Here is where the dossier work happens against that clock. Day 1 is the day after LOI acceptance.

1

Day 1. DD question list lands.

Buyer's rep emails the 40 line checklist to the seller's lawyer. Listing broker is cc'd and starts to triage which questions are behavioral.

2

Day 2. Behavioral subset tagged.

Broker reads the 40 questions and tags the 10 to 18 that resolve to observable behavior at the property. Those are the rows Cyrano will answer.

3

Day 3. Query run in one afternoon.

Broker pastes each behavioral DD question into the Cyrano search box, captures the row, exports the thumbnails. The full subset is done in under 4 hours on a 90 day archive.

4

Day 4. Dossier in data room.

dd_query_dossier.csv and the thumbnails folder are uploaded to the data room. Buyer's rep is notified by email, no attachments sent by the seller's lawyer.

5

Day 5 to 14. Follow up queries.

Buyer's rep runs additional questions as they read the dossier. Broker appends rows 41, 42, 43, etc. Median turnaround on a follow up query is under 10 minutes.

6

Day 15 to 21. Risk narrative closes.

Buyer's rep finalizes their underwriting narrative using dossier counts as inputs. Security related concession requests drop because the data is sitting next to the T-12.

Real numbers from one 312 unit dossier

Numbers below are from a 312 unit Class B property in Texas. 16 active tiles on a Hikvision DS-7716NI-K4 recorder. 94 day pre listing tap. DD question list was 41 items, of which 14 resolved to behavioral queries and 27 to financial or legal. Dossier was produced on day 3 of the inspection window.

0DD questions in the list
0Behavioral questions Cyrano answered
0Thumbnails exported to the gallery
0 hrsTotal dossier production time
Median time to answer one DD query
0s
from paste to thumbnails. The English sentence the lawyer wrote goes into the search box, the model scans 90 days of indexed footage, and a row lands in dd_query_dossier.csv. Forty rows fit in one afternoon because the expensive step, the indexing, already happened at the edge before the OM went out.
We had always answered DD questions with a paragraph. On our last deal the broker handed the buyer a CSV where every row had a count and a clip link. The buyer's rep came back with three follow ups and stopped. The deal closed in 37 days.
M
Multifamily listing broker
Texas based shop, 400 unit average listing
20

At one Class C multifamily property in Fort Worth, Cyrano caught 20 incidents including a break-in attempt in the first month. Customer renewed after 30 days.

Fort Worth, TX property deployment

See the DD dossier run on a live recorder

15 minute walkthrough. We plug into the HDMI of a multifamily DVR, type the buyer's DD questions into Cyrano verbatim, and show you the dossier row format that drops into the data room alongside the T-12.

Book a call

Frequently asked questions

What exactly is a DD Query Dossier and why would it replace the email thread a buyer's rep normally sends the seller's lawyer?

A DD Query Dossier is a 40 row artifact, one row per DD question, that sits in the data room alongside the T-12 and the rent roll. Each row has five columns: question_id, english_query_string, matched_event_count, iso8601_ts_range, thumbnail_gallery_href. The english_query_string is literally the sentence the buyer's lawyer wrote in their DD email ('any package theft in the lobby in the last 90 days'), typed verbatim into Cyrano's natural language search box. The matched_event_count is the number of clips the model found. The thumbnail_gallery_href points to a folder of 480x270 JPEGs. It replaces the email thread because the buyer's rep can read the row in 10 seconds instead of a lawyer paragraph, and they have evidence attached, not a claim.

Why is the keyword 'multifamily for sale' the right place to publish a DD workflow? Aren't the top search results listing marketplaces?

Exactly, and that is the gap. LoopNet, Crexi, CBRE DealFlow, Marcus & Millichap, Ten-X, and Zillow Commercial are inventory marketplaces. Their product is a filter on cap rate, unit count, submarket, year built. Their audience is buyers looking at 30 to 50 listings at once. None of them publish DD workflow content because DD historically happens in email after the LOI, not on the listing page. But the buyer's decision to even submit an LOI is influenced by how the seller looks prepared to answer DD. A one page dossier preview in the OM signals a seller who will close in 45 days, not one who will spend 14 days hunting for a DVR password.

Does the seller need to answer 40 DD questions themselves, or does the broker run Cyrano?

The broker runs the query interface. The seller plugs in the Cyrano unit on HDMI in the office closet before the broker sends the OM. After that, when the buyer's lawyer emails the 40 line DD question list, the broker pastes each English question directly into the Cyrano search box, captures the result count and the thumbnails, and exports a row to the dossier. Typical throughput is 40 DD questions handled in one afternoon, versus a three day back and forth where the seller chases property managers and ex employees for DVR admin credentials.

What does the buyer's lawyer actually write that gets typed into the search box verbatim?

DD question lists are short English sentences written by lawyers who have never seen the DVR. Common examples: 'any person loitering near the pool gate after 11pm', 'packages left unattended at the lobby for more than 30 minutes', 'vehicle dwelling in the parking lot after hours', 'tailgating at the pedestrian gate', 'tampering near the meter room'. Every one of those is directly typable into Cyrano's search box. The model matches the phrase against 90 days of indexed footage and returns a ranked clip list. Nothing reformats the lawyer's sentence into SQL or tile labels.

If the seller never installed Cyrano before marketing the asset, can a buyer run this workflow during inspection instead?

Yes, but the dataset is thinner. If the unit goes in on day 1 of the 21 day inspection window, the buyer has at most 21 days of indexed footage to query against. That is enough to answer time-of-day patterns but not seasonality. If the seller installed Cyrano 60 to 90 days before listing (the pre-listing tap playbook), the buyer queries a full operating quarter and the answers are stronger. Most mid market sellers we see now deploy at the same time the OM is drafted, so the dossier is populated by the time DD starts.

What happens when the DD question cannot be answered by video at all, for example a financial or legal question?

The dossier has a specific non applicable flag. If the DD question is 'confirm current property tax assessment', the row is marked question_type=financial, english_query_string=null, and the row links to the tax bill PDF instead of a clip gallery. The 40 row artifact is not a replacement for the entire DD answer set. It is the subset of DD questions that resolve to observable behavior at the property, which on a typical multifamily list is 10 to 18 questions out of 40.

How is this different from the seller pre listing tap workflow on your 'multifamily properties for sale' page?

The pre listing tap page is about the seller generating a measured indicator (incidents per 1000 resident days) for the OM. This page is about the DD back and forth after the OM is out. Different audience, different moment, different artifact. The pre listing page ships a summary number in the OM. This page ships a typed query log with evidence. Both can run on the same Cyrano unit, but the pre listing page serves the underwriting model and this page serves the lawyer email exchange.

Does the buyer get to keep the query dossier after close?

Yes. The dossier is a static CSV plus a thumbnails folder. At close, the file transfers to the new owner as part of the data room archive. The Cyrano unit also stays plugged into the HDMI port and continues to accrue indexed events under the new owner, so the dossier becomes the first 90 day archive of a running log that now extends forward. A buyer's rep who wants to benchmark month 1 post close against month 1 pre LOI can pull both from the same dataset using the same English queries.

Is typing an English query into the search box a reliable replacement for a formal forensic video review?

It is not a replacement for forensic review. It is a replacement for the lawyer paragraph that currently answers the DD question. A forensic review is commissioned after a specific dispute arises, takes two to four weeks, costs $5,000 to $15,000, and produces an affidavit. An English query is a 10 second answer to a DD checklist item during the inspection window, costs zero incremental dollars, and produces a count plus thumbnails. The dossier is upstream of forensics, not a substitute for it.

If the buyer pushes for raw DVR access during DD instead of the dossier, what do sellers do?

The dossier is designed to make that request unnecessary. Most sellers cannot produce DVR admin credentials on a five year old recorder, and the buyer's rep has no standard schema for reading a raw DVR anyway. When the dossier exists, the buyer's first move is to ask for an additional query ('also run: vehicle dwell at the side entrance between 1am and 4am'), which the broker runs in one minute and appends as row 41. The DD exchange becomes query based, not credential based.

What kind of questions does the model handle poorly, so a seller's broker can flag them upfront?

Plate level identification ('the blue sedan with partial plate 7ABC'), specific individual re identification across multiple days, and audio based events all perform worse than object level queries. The dossier flags these rows as model_confidence=low and routes to a conventional timeline scrub. Everything at the object level, person with backpack, unattended package, vehicle dwell, loitering, tailgating, tampering, performs well at DD grade precision because these are exactly the classes the on device model is trained on.

🛡️CyranoEdge AI Security for Apartments
© 2026 Cyrano. All rights reserved.

How did this page land for you?

React to reveal totals

Comments ()

Leave a comment to see what others are saying.

Public and anonymous. No signup.