Prototype. Every figure on this page is illustrative. The register holds 8 sample assets from the MoPED data-model workbook and 112 generated to match its schema — no real asset, valuation or coordinate.

Shop Unit No. 3 — District 3

CAI-RTL-0068 · Cairo

1 - Quick winVacantCondition: FairValidatedConfidence: Medium

Shop Unit No. 3 — District 3

12 Industrial Zone Road, District 3, Badr City, Cairo

Retail unit · Ministry of Housing, Utilities & Urban Communities

Strong conversion candidate given transport proximity.

Market value

⁦EGP 11.6m⁩

book value ⁦EGP 3.1m⁩

Value after renovation

⁦EGP 13.3m⁩

scope: Moderate - MEP & finishes

CapEx

⁦EGP 1.9m⁩

over 8 months

Net operating income

⁦EGP 1.4m⁩

on ⁦EGP 2.1m⁩ gross revenue

Gross yield

⁦12.5%⁩

clears the ⁦12%⁩ hurdle

Revenue gap

⁦EGP 1.4m⁩

against ⁦EGP 0⁩ earned today

Recommendation

Highest & best use

Mixed-use redevelopment

Monetization route

Securitize / REIT contribution

Payback

⁦1.4⁩yrs

Vacant

⁦5⁩yrs

Monthly rent equiv.

⁦EGP 171,550⁩

Assumed occupancy

⁦94%⁩

Blockers

None material recorded.

Location

Coordinates
⁦30.1467⁩, ⁦31.7099⁩
Main road / transport
⁦0.4⁩ / ⁦5.9⁩ km

Estimated valueSimulated

Back-cast from today's valuation at the Assumptions sheet's inflation rate plus governorate drift.

Condition scoreSimulated

Decay rate follows the recorded utilization status; the final point is today's rating.

A. Identification & Ownership

14
Asset IDasset_id
CAI-RTL-0068
Asset Name (EN)asset_name_en
Shop Unit No. 3 — District 3
Asset Name (AR)asset_name_ar
محل رقم ٣ — الحي الثالث
Custodian Entitycustodian_entity
Ministry of Housing, Utilities & Urban Communities
Custodian Sub-Unit / Directoratecustodian_sub
General Administration for Assets
Ownership Typeownership_type
State freehold (ملكية خاصة للدولة)
Title / Registration Statustitle_status
Registered (مسجل)
Real-Estate Registry No.registry_no
2010/4764
Asset Classasset_class
Retail unit (وحدة تجارية)
Current Usecurrent_use
Used as an informal store by third parties
Utilization Statusutilization_status
Vacant (شاغر)
Years Vacant / Underusedvacancy_years
⁦5⁩
Occupied By / Encumbrancesoccupied_by
None

B. Location & Geospatial

14
Governorategovernorate
Cairo
City / Markazcity
Badr City
District / Neighbourhooddistrict
District 3
Full Address (EN)address_en
12 Industrial Zone Road, District 3, Badr City, Cairo
Full Address (AR)address_ar
١٢ طريق المنطقة الصناعية، الحي الثالث، مدينة بدر، القاهرة
Latitudelatitude
⁦30.146676⁩
Longitudelongitude
⁦31.709899⁩
Plot / Block No.plot_no
Block 36 / Plot 36
Zoning Classificationzoning
Commercial
Permitted Use per Detailed Planpermitted_use
Cultural and hospitality, height restricted
Distance to Main Road (km)dist_main_road
⁦0.39⁩
Distance to Transport Node (km)dist_transport
⁦5.85⁩
Catchment Population (000s)catchment_pop
⁦EGP 363⁩

C. Physical Characteristics

11
Built-Up Area / BUA (m2)bua
⁦330 m²⁩
Gross Leasable Area (m2)gla
⁦414 m²⁩
Number of Floorsfloors_count
⁦1⁩
Number of Unitsunits_count
⁦3⁩
Year Builtyear_built
⁦2,003⁩
Building Age (yrs)building_ageƒ
⁦23⁩
Structure Typestructure_type
Reinforced concrete
Finishing Levelfinishing_level
Fully finished - standard
Utilities Connectedutilities
Electricity, Water, Gas, Sewage
Heritage-Listed?heritage_listed
No

D. Internal Division & Layout

9
Internally Divided?has_internal_division
No
Number of Roomsrooms_count
⁦0⁩
Number of Bathroomsbathrooms_count
⁦1⁩
Reception / Hallsreception_count
⁦0⁩
Kitchenskitchens_count
⁦0⁩
Open-Plan Area (m2)open_plan_area
⁦270 m²⁩
Partition Flexibilitypartition_flexibility
High - open plan, easily partitioned
Parking Spacesparking_spaces
⁦4⁩
Layout Noteslayout_notes
Ground-floor retail frontage with independent access to upper levels.

E. Condition & Renovation

9
Physical Conditioncondition_rating
Fair
Condition Notes (EN)condition_notes_en
Serviceable but dated; damp staining to lower floors and failing waterproofing.
Condition Notes (AR)condition_notes_ar
صالح للاستخدام لكنه قديم؛ آثار رطوبة بالأدوار السفلية وفشل في العزل.
Renovation Required?renovation_required
Yes
Renovation Scoperenovation_scope
Moderate - MEP & finishes
Renovation Cost (EGP/m2)reno_cost_sqm
⁦5,900 m²⁩
Est. Renovation Cost (EGP)reno_cost_totalƒ
⁦EGP 1,947,000⁩
Renovation Duration (months)reno_duration_months
⁦8⁩
Licensing / Compliance Statuscompliance_status
Fully licensed

F. Valuation

8
Valuation Methodvaluation_method
Cost / replacement (التكلفة)
Building Value (EGP/m2)building_value_sqm
⁦EGP 35,000⁩
Est. Market Value (EGP)market_valueƒ
⁦EGP 11,550,000⁩
Value After Renovation (EGP)value_post_renoƒ
⁦EGP 13,282,500⁩
Government Book Value (EGP)book_value
⁦EGP 3,100,000⁩
Valuation Datevaluation_date
⁦29 Aug 2026⁩
Valuation Sourcevaluation_source
NUCA schedule price, adjusted

G. Income & Rental Potential

11
ADR - Residential (EGP/day)adr_residential
⁦EGP 0⁩
ADR - Commercial / Retail (EGP/day)adr_commercial
⁦EGP 6,000⁩
ADR - Office (EGP/day)adr_office
⁦EGP 0⁩
ADR Applied (EGP/day)adr_applicableƒ
⁦EGP 6,000⁩
Assumed Occupancy Rateoccupancy_rate
⁦94.0%⁩
Gross Annual Revenue (EGP)gross_annual_revenueƒ
⁦EGP 2,058,600⁩
Monthly Rent Equivalent (EGP)monthly_rent_equivƒ
⁦EGP 171,550⁩
Annual Operating Cost (EGP)annual_opex
⁦EGP 617,580⁩
Net Operating Income (EGP)noiƒ
⁦EGP 1,441,020⁩
Gross Yield (%)gross_yieldƒ
⁦12.5%⁩
Renovation Payback (yrs)reno_payback_yearsƒ
⁦1.35⁩

H. Utilization Gap & Monetization

7
Current Actual Income (EGP/yr)current_annual_income
⁦EGP 0⁩
Annual Revenue Gap (EGP)revenue_gapƒ
⁦EGP 1,441,020⁩
Highest & Best Usehighest_best_use
Mixed-use redevelopment
Recommended Monetization Routemonetization_option
Securitize / REIT contribution
CapEx to Activate (EGP)capex_to_activateƒ
⁦EGP 1,947,000⁩
Priority Tierpriority_tier
1 - Quick win
Key Blockersblockers
None material

I. Media & Documentation

6
Number of Photosphotos_count
45
Floor Plan / Survey (URL)floorplan_link
https://drive.example.org/assets/CAI-RTL-0068/plan.pdf
Title Deed & Docs (URL)deed_docs_link
https://drive.example.org/assets/CAI-RTL-0068/deed.pdf

J. Data Governance

7
Primary Data Sourcedata_source
Government dataset (custodian)
Data Confidenceconfidence_level
Medium
Site Visit Datesite_visit_date
⁦6 Aug 2026⁩
Surveyor / Analystsurveyor
S. Abdel Rahman
Last Updatedlast_updated
⁦9 Sept 2026⁩
Record Statusrecord_status
Validated
General Notesnotes
Strong conversion candidate given transport proximity.

45 photographs on file

The survey's geotagged photographs live in the custodian's drive folder. This prototype records the link and the count rather than shipping the images.

https://drive.example.org/assets/CAI-RTL-0068/photos

Source: Government dataset (custodian). Surveyed by S. Abdel Rahman on ⁦6 Aug 2026⁩. Record last updated ⁦9 Sept 2026⁩.