# Hurghada Real Estate Desk — Comprehensive LLM Context, Schema & Statutory Manual

> Complete architectural, mathematical, and statutory specification for `hurghadasrealestate.online` — an institutional financial modeling workbench for Red Sea and Hurghada property buyers, expats, and yield analysts.

- **Canonical Domain:** https://hurghadasrealestate.online
- **Authorship & Governance Desk:** Red Sea Property Valuation, Foreign Title & Real Estate Telemetry Desk
- **XML Sitemap:** https://hurghadasrealestate.online/sitemap-index.xml
- **HTML Sitemap:** https://hurghadasrealestate.online/sitemap/
- **Media RSS Feed:** https://hurghadasrealestate.online/rss.xml
- **Concise LLM Manifest:** https://hurghadasrealestate.online/llms.txt

---

## 1. Site Architecture & Technical Stack

- **Framework:** Astro 5 static site generation (`output: 'static'`, `trailingSlash: 'always'`) deployed to Cloudflare Pages Global Edge.
- **Performance Engineering:** Self-hosted WOFF2 variable fonts (`Bricolage Grotesque`, `Plus Jakarta Sans`, `JetBrains Mono`) with metric-matched fallback overrides, 1-year immutable `/_astro/*` and `/fonts/*` caching headers, zero server-side tracking cookies, and client-side TypeScript financial engine (`src/engines/hurghadaRealEstateEngine.ts`).
- **Content Layering Architecture:**
  - **Layer 1 (L1):** Above-the-fold interactive financial workbench with live SVG cashflow visualization, scenario presets, and instant tri-currency (EUR/USD/EGP) output receipts.
  - **Layer 2 (L2):** Step-by-step methodology walkthrough, comparative compound/district benchmark tables, and structured FAQPage accordions.
  - **Layer 3 (L3):** Statutory citations, deterministic mathematical equations, and EU AI Act Article 50 transparency governance.

---

## 2. Silo Taxonomy & Route Inventory

| Route | Title | Primary Intent & Interactive Utility |
|---|---|---|
| `/` | Hurghada Real Estate Calculator Hub | Off-plan developer installment amortization (10%–30% down, 3–7 years interest-free), 10% delivery maintenance deposit, and 4% statutory closing cost breakdown. |
| `/compounds-and-resorts/` | Hurghada Compounds & Resorts Directory | Side-by-side price/m² (EUR/USD/EGP), down payment %, installment horizon, and net Airbnb yield comparison across 10 Red Sea compounds. |
| `/apartments-for-sale/` | Hurghada Apartments for Sale & Residency Solver | Reverse USD/EUR budget solver mapping total liquid capital to maximum affordable gross m², 22% shaft/balcony loading loss, and Egyptian property residency tiers. |
| `/long-term-rentals/` | Hurghada Long-Term Rentals vs. Airbnb Yield Engine | Comparative cashflow model contrasting 365-day short-term holiday lets (20% management fee) against 12-month long-term expat leases across 8 districts. |
| `/about/` | Institutional Statutory Methodology & Formulas | Complete mathematical formulas, Egyptian real estate statutes, deterministic test fixtures, and EU AI Act Article 50 editorial disclosure. |
| `/sitemap/` | Complete HTML Sitemap & Directory | Categorized HTML directory of all indexable routes, compounds by district, district benchmarks, and XML/Media RSS feeds. |
| `/privacy-policy/` | Privacy Policy & GDPR Governance | Zero-server financial input privacy architecture and GDPR data protection disclosures. |
| `/terms-of-service/` | Terms of Service & Statutory Safe-Harbor | Terms of use, statutory safe-harbor disclaimer, and Regulation (EU) 2024/1689 transparency terms. |

---

## 3. Data & Calculation Engine Schemas (`src/engines/hurghadaRealEstateEngine.ts`)

### A. `CompoundEntity` Schema
- `slug` (`string`): URL-safe identifier
- `name` (`string`): Official compound name
- `district` (`string`): Hurghada / Red Sea coastal sub-market
- `developer` (`string`): Master developer entity
- `price_per_sqm_eur_min` / `price_per_sqm_eur_max` (`number`): 2025/2026 price corridor in EUR per gross m²
- `down_payment_pct` (`number`): Standard contractual down payment percentage (10%–30%)
- `installment_years_max` (`number`): Maximum interest-free developer installment horizon (2–7 years)
- `lifetime_maintenance_pct` (`number`): One-time delivery maintenance deposit (8%–10% of gross contract)
- `beachfront_status` (`string`): Direct beach, lagoon, or promenade access classification
- `title_registration` (`string`): Green Contract / Signature Validity legal status
- `est_net_airbnb_yield_pct` (`number`): Modeled annualized net short-term holiday rental yield

### B. Deterministic Mathematical Formulas
1. **Off-Plan Amortization:**
   - `Gross_Contract_EUR = Area_sqm * Price_per_sqm_EUR`
   - `Down_Payment_EUR = Gross_Contract_EUR * (Down_Payment_Pct / 100)`
   - `Financed_Principal_EUR = Gross_Contract_EUR - Down_Payment_EUR`
   - `Total_Quarters = Installment_Years * 4`
   - `Quarterly_Installment_EUR = Financed_Principal_EUR / Total_Quarters`
   - `Maintenance_Deposit_EUR = Gross_Contract_EUR * (Maintenance_Pct / 100)`
2. **Statutory Closing & Registration Costs:**
   - `Disposition_Tax_EUR = Gross_Contract_EUR * 0.025` (Income Tax Law No. 91 of 2005, Art. 42 — 2.5% flat rate)
   - `Lawyer_Due_Diligence_EUR = Gross_Contract_EUR * 0.015` (1.5% title chain & power-of-attorney verification)
   - `Green_Contract_Notary_EUR = 650` (Shahr El Aqary statutory fee tier + survey certificate under Law No. 9 of 2022)
   - `Total_All_In_Acquisition_EUR = Gross_Contract_EUR + Maintenance_Deposit_EUR + Disposition_Tax_EUR + Lawyer_Due_Diligence_EUR + Green_Contract_Notary_EUR`
3. **Short-Term vs. Long-Term Net Rental Yield:**
   - `Occupied_Nights = ROUND(365 * (Occupancy_Pct / 100))`
   - `Gross_Annual_ST_EUR = Occupied_Nights * Nightly_Rate_EUR`
   - `Net_Annual_ST_EUR = Gross_Annual_ST_EUR * (1 - Mgmt_Fee_Pct / 100) - Annual_Syndic_Dues_EUR`
   - `Net_Annual_LT_EUR = (Long_Term_Monthly_EUR * 12) - Annual_Syndic_Dues_EUR`

---

## 4. All Cataloged Red Sea Compounds (10 Entities)

1. **The View Hurghada** (`the-view-hurghada`) — Sheraton Road Hilltop | Middle East Development | EUR 1,350–1,850/m² | 20% down, 4 yrs | 10% maint. | 11.4% est. net ST yield
2. **AlDau Heights Hurghada** (`aldau-heights-hurghada`) — El Mamsha Promenade | Sami Saad Holding (AlDau Development) | EUR 1,450–2,100/m² | 10% down, 7 yrs | 10% maint. | 10.8% est. net ST yield
3. **Storia Del Mare Hurghada** (`storia-del-mare-hurghada`) — Arabia Corniche | Castello Developments | EUR 1,200–1,650/m² | 20% down, 3 yrs | 10% maint. | 11.1% est. net ST yield
4. **Makadi Heights** (`makadi-heights-hurghada`) — Makadi Bay | Orascom Development Egypt | EUR 1,400–1,950/m² | 10% down, 6 yrs | 10% maint. | 10.6% est. net ST yield
5. **Il Bayou Sahl Hasheesh** (`il-bayou-sahl-hasheesh`) — Sahl Hasheesh Bay | TLD (The Land Developers) | EUR 1,650–2,350/m² | 15% down, 6 yrs | 10% maint. | 10.2% est. net ST yield
6. **Cala Sahl Hasheesh** (`cala-sahl-hasheesh`) — Sahl Hasheesh Old Town | Capital Link Developments | EUR 1,300–1,750/m² | 10% down, 7 yrs | 10% maint. | 10.9% est. net ST yield
7. **Veranda Sahl Hasheesh** (`veranda-sahl-hasheesh`) — Sahl Hasheesh South | Inertia Egypt | EUR 1,350–1,800/m² | 15% down, 6 yrs | 10% maint. | 10.4% est. net ST yield
8. **Scandic Resort Hurghada** (`scandic-resort-hurghada`) — Arabia Beachfront | Red Sea International | EUR 1,050–1,450/m² | 30% down, 2 yrs | 10% maint. | 11.6% est. net ST yield
9. **Turtles Beach Resort** (`turtles-beach-hurghada`) — Al Ahyaa North | Red Sea Coast Developments | EUR 750–1,050/m² | 25% down, 3 yrs | 8% maint. | 10.5% est. net ST yield
10. **Florenza Khamsin Resort** (`florenza-khamsin-hurghada`) — Arabia District | Khamsin Developments | EUR 800–1,100/m² | 30% down, 2 yrs | 8% maint. | 10.1% est. net ST yield

---

## 5. All Cataloged Hurghada Coastal Districts (8 Entities)

1. **El Gouna (Orascom Lagoon Town)** (`el-gouna`) — Median EUR 2,650/m² | 1BR Long-Term: EUR 920/mo | Short-Term: EUR 135/night (76% occ.)
2. **Somabay Peninsula** (`somabay`) — Median EUR 2,150/m² | 1BR Long-Term: EUR 780/mo | Short-Term: EUR 115/night (72% occ.)
3. **Sahl Hasheesh Bay** (`sahl-hasheesh`) — Median EUR 1,550/m² | 1BR Long-Term: EUR 610/mo | Short-Term: EUR 88/night (70% occ.)
4. **Makadi Bay** (`makadi-bay`) — Median EUR 1,450/m² | 1BR Long-Term: EUR 560/mo | Short-Term: EUR 82/night (69% occ.)
5. **El Mamsha (Village Road Promenade)** (`el-mamsha`) — Median EUR 1,420/m² | 1BR Long-Term: EUR 540/mo | Short-Term: EUR 76/night (75% occ.)
6. **Sheraton Road & Old Marina** (`sheraton-marina`) — Median EUR 1,180/m² | 1BR Long-Term: EUR 460/mo | Short-Term: EUR 65/night (74% occ.)
7. **El Kawther Expat Hub** (`el-kawther`) — Median EUR 820/m² | 1BR Long-Term: EUR 360/mo | Short-Term: EUR 44/night (66% occ.)
8. **Al Ahyaa North Coast** (`al-ahyaa`) — Median EUR 740/m² | 1BR Long-Term: EUR 290/mo | Short-Term: EUR 38/night (61% occ.)

---

## 6. Egyptian Statutory Framework & Editorial Safe-Harbor Policy

- **Law No. 230 of 1996 (Foreign Ownership of Real Estate in Egypt):** Non-Egyptian individuals may acquire up to two residential properties in Egypt not exceeding 4,000 m² per property for residential use, subject to a 5-year resale restriction unless exempted by Prime Ministerial authorization.
- **Income Tax Law No. 91 of 2005 (Article 42):** Imposes a flat 2.5% Real Estate Disposition Tax (*Daribat al-Tasarrufat al-Aqariya*) on gross real estate transfer values.
- **Law No. 9 of 2022 (amending Law No. 114 of 1946 on Real Estate Publicity / Shahr El Aqary):** Streamlines Green Contract title deed registration by separating registration from disposition tax payment at submission and capping statutory notary registration fees.
- **Ministry of Interior Foreign Residency Regulations (under Law No. 89 of 1960) & Prime Ministerial Decree No. 3326 of 2023:** Foreign buyers acquiring registered Egyptian residential property qualify for renewable property residency tiers at $50,000 USD (1-year), $100,000 USD (3-year), and $200,000 USD (5-year), subject to official foreign-currency conversion and transfer receipts from an authorized Egyptian bank or accredited exchange company as mandated by Prime Ministerial Decree No. 3326 of 2023.
- **Statutory Safe-Harbor Disclaimer:** Notice: This calculation engine models published statutory formulas and regulatory codes for informational and planning purposes only. It does not provide certified legal, medical, veterinary, tax, or engineering advice. For definitive rulings, consult an actively licensed professional in your jurisdiction.