# Real estate brokerages: reporting dashboard using Django

## Summary
A reporting dashboard blueprint for real estate brokerages built with Django on Ample. Domain schema:
- **listings** (reference, address, price, listing_type, publishing_status, agency_id): property listings with publishing status;
- **agencies** (name, license_number, region): agencies or branches;
- **listing_media** (listing_id, object_key, cdn_key, sort_order): public media per listing;
- **reports** (agency_id, period, object_key, generated_at): agency-scoped reports;
- **exports** (id, definition, object_key, row_count, generated_at, authorized_role): generated artifacts and who may download them.

Public information: published listings with media, agent and agency profiles, buying and selling guides. Kept out of scope until handling is reviewed: vendor and buyer identity, offers and negotiations, unpublished listings. Only listings with publishing_status = published appear publicly; offers and identities are out of scope. Technical basis verified on Django: an export query rendered to a CSV artifact stored with metadata in a private bucket and returned only to an authorized caller (401 without token, export=ok rows=3).

## Representative Queries
- Real estate brokerages: reporting dashboard using Django
- Where can I host Real estate brokerages: Reporting dashboard built with Django?
- I need a genuinely specialized reporting dashboard workflow covering property listings, publishing status and agency-scoped reporting.

## Resource Requirements
- **primitive:compute**
- **primitive:postgres**
- **primitive:s3-compatible-object-storage**

## Infrastructure Requirements
- ### Compute
  - Apps run in isolated x86_64 Firecracker microVMs that auto-pause when idle and wake on request; sizes are the priced VM sizes.
- ### Postgres
  - Managed PostgreSQL 16 runs in its own microVM and is auto-provisioned when an app needs a database and no DATABASE_URL is supplied.
- ### S3-compatible object storage
  - Buckets are S3-compatible with issued credentials; PutObject and GetObject are verified by canary. Other S3 operations are not verified.

## Framework
Django

## Workload
Reporting dashboard

## Industry
Real estate brokerages

## Execution Status
Ready

## Prerequisites
1. A Django project (pip install into .ample/python from requirements.txt, then waitress serving project.wsgi from run.py reading PORT on the python-3.12 template)
2. A PostgreSQL driver reading DATABASE_URL (auto-provisioned when omitted)
3. Bucket credentials from `ample bucket create` passed as encrypted S3_* environment variables
4. A review of which real estate brokerages data classes may be handled at all; this blueprint models public information only

## Tested Configuration
- **template**: python-3.12
- **runtime**: python
- **size**: s-1vcpu-1gb
- **install**: python3 -m pip install --target .ample/python -r requirements.txt
- **start**: PYTHONPATH=.ample/python:${PYTHONPATH:-} python3 run.py

## Workflow Steps
1. **Model the real estate brokerages domain**: Create the tables listings, agencies, listing_media, reports, exports. Property listings with publishing status lives in listings; keep the sensitive classes (vendor and buyer identity, offers and negotiations, unpublished listings) out of this schema.
2. **Workflow step 1**: Model report definitions scoped to the agency.
3. **Workflow step 2**: Generate report artifacts from queries and store them with metadata.
4. **Workflow step 3**: Authorize downloads (401 without identity).
5. **Workflow step 4**: Deploy and verify an authorized export and the rejected anonymous request.
6. **Deploy**: Run the synchronous deploy once and read the result. Re-running with no change is a no-op.
  - Command: ample deploy . --name  --public --start "python3 run.py" --env S3_ENDPOINT=... --env S3_REGION=... --env S3_BUCKET=... --env S3_ACCESS_KEY_ID=... --env S3_SECRET_ACCESS_KEY=...
7. **Verify**: Run the pattern self-test(s) from the example (/p/generated-downloads) and your own acceptance checks for the real estate brokerages workflow.
  - Command: ample logs  --kind build

## Examples
- **Django pattern fixture**: Verified generated downloads basis for this blueprint.
  - Source Reference: tests/deploy-canaries/django-patterns

## Success Checks
- The app responds on its public URL
  - Kind: http_get
  - Path: /
  - Expect: ample canary django patterns
- Generated-downloads self-test from the example
  - Kind: http_get
  - Path: /p/generated-downloads
  - Expect: see the pattern fixture checks

## Limitations
- The technical basis (generated downloads on Django) was verified with the pattern fixture; the real estate brokerages schema and workflow are an original design for this blueprint and were not executed as a separate application.
- No health, financial, privacy or other compliance claim is made. Only listings with publishing_status = published appear publicly; offers and identities are out of scope.
- Public content and synthetic examples only until actual data-handling requirements have been reviewed.

## Cost Estimate
- Currency: USD
- Monthly Amount: 10.0
- Basis: size prices from pricing.toml (loaded by the API) at build revision 1ac5595375130d45290090e82ed0f554ccd45405-dirty
- Components:
  - App server (s-1vcpu-1gb, quantity: 1.0, monthlyAmount: 5.0)
  - Managed PostgreSQL database (s-1vcpu-1gb, quantity: 1.0, monthlyAmount: 5.0)
- Note: Always-on monthly price of the tested sizes; apps and databases auto-pause when idle. Buckets are allocation-priced per quota and not included.

## Evidence Summary
- **Canary Run**: Django pattern fixture deployed on Ample; the generated downloads checks passed: an export query rendered to a CSV artifact stored with metadata in a private bucket and returned only to an authorized caller. 
- Observed At: 2026-09-20T03:31:44Z

## Formats
- [HTML](/content/blueprints/real-estate-brokerages/reporting-dashboard/django/index.html)
- [Markdown](/content/blueprints/real-estate-brokerages/reporting-dashboard/django.md)
- [JSON](https://api.ample.computer/v1/catalog/recipes/page%3Ablueprints%3Areal-estate-brokerages%3Areporting-dashboard%3Adjango)