Property catalog for an AI agent

Resale: flagged to show on the website and with status Sale, Sale and Rent or In Negotiation, excluding the project category and inactive land. Launch: project category, condition other than used, and flagged for the website. Rental: total rent above zero and below a sanity ceiling (for example, R$ 50 thousand). Each purpose becomes a table or a purpose column.

A property in negotiation stays eligible so the client is not lost, but the agent says it is in negotiation and offers similar ones. Sold, rented, reserved or suspended never enters. A property that does not exist in the catalog is a different answer from an unavailable property.

Values arrive as numbers, as text with a decimal comma or as 'value|BRL' (in Bitrix24). Convert, round and format as R$ 1.250.000,00. A zero or null value becomes a fixed sentence, for example 'Entre em contato para informações de valores.' (contact us for pricing). Launches show 'from'; resales show the value. Condo fee and IPTU (property tax) go in their own fields.

Amenities and features arrive as a structure with dozens of Yes, No or empty fields. Generate a list with only what is Yes or has a value, each item with its Portuguese label ('Piscina', 'Churrasqueira', 'Água: poço artesiano'). Empty fields disappear from the text instead of becoming 'Label:' with no value.

Use only photos flagged to show on the website, with the featured photo first. The URL must be public: photos from a new CRM usually need a base domain for the portal feed. Website links with localhost or from a test environment stay out.

For the agent, one text per property with 'Label: value' separated by commas, starting with the code. For semantic search, one JSON per property with readable keys and the same content as metadata, with a stable property id for updates and deletes. For portals, one row per property already in the VrSync standard. All three come from the same eligible table.

Map the CRM property type to the VrSync PropertyType through a dictionary (apartment, house, townhouse, penthouse, land, office). Title up to 100 characters, description without HTML and without the CDATA closing sequence, up to 3000 characters. Empty transaction becomes sale. Empty bedrooms use rooms plus suites. Year built outside 1800 to 2100 becomes null. Listing highlight comes from the property's portals field.

The agent table never carries the owner's or listing agent's name, phone or document, commission or internal notes. It only holds what can be told to the end client. Expanding what the agent can say is a management decision, recorded.

When the same agent serves more than one brokerage or brand, each row carries the tenant_id and the agent always filters by it. The property cache and the contact cache live in separate tables.

The table runs by event right after the CRM sync, and each row stores the load date. If the load is late beyond the agreed limit, the agent does not confirm availability: it says it will check with a broker.