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.

Staff Apartment Block — Alexandria

ALX-APT-0117 · Alexandria

3 - Long term / complexPartially utilizedCondition: PoorDraftConfidence: Medium

Staff Apartment Block — Alexandria

41 Ramses Street, Agami, Alexandria, Alexandria

Apartment · Within compound · Ministry of Health

Fit-out cost is the only barrier; a lease with fit-out allowance is recommended.

Market value

⁦EGP 35.5m⁩

book value ⁦EGP 13.8m⁩

Value after renovation

⁦EGP 46.2m⁩

scope: Major - structural + MEP

CapEx

⁦EGP 26.4m⁩

over 14 months

Net operating income

⁦EGP 3.7m⁩

on ⁦EGP 5.3m⁩ gross revenue

Gross yield

⁦10.5%⁩

below the ⁦12%⁩ hurdle — sale candidate

Revenue gap

⁦EGP 2.8m⁩

against ⁦EGP 948k⁩ earned today

Recommendation

Highest & best use

Retain current use

Monetization route

Long-term lease

Payback

⁦7.1⁩yrs

Vacant

⁦6⁩yrs

Monthly rent equiv.

⁦EGP 444,844⁩

Assumed occupancy

⁦75%⁩

Blockers

  • Waqf consent required before any disposal

Location

Coordinates
⁦31.1899⁩, ⁦29.9384⁩
Main road / transport
⁦0.0⁩ / ⁦1.0⁩ 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
ALX-APT-0117
Asset Name (EN)asset_name_en
Staff Apartment Block — Alexandria
Asset Name (AR)asset_name_ar
عمارة سكن العاملين — الإسكندرية
Custodian Entitycustodian_entity
Ministry of Health
Ownership Typeownership_type
Waqf / endowment (وقف)
Title / Registration Statustitle_status
Registered (مسجل)
Real-Estate Registry No.registry_no
1991/9834
Asset Classasset_class
Apartment (شقة)
Asset Sub-Typeasset_subtype
Within compound
Current Usecurrent_use
Occasional official hosting
Utilization Statusutilization_status
Partially utilized (مستغل جزئياً)
Years Vacant / Underusedvacancy_years
⁦6⁩
Occupied By / Encumbrancesoccupied_by
None

B. Location & Geospatial

14
Governorategovernorate
Alexandria
City / Markazcity
Alexandria
District / Neighbourhooddistrict
Agami
Full Address (EN)address_en
41 Ramses Street, Agami, Alexandria, Alexandria
Full Address (AR)address_ar
٤١ شارع رمسيس، العجمي، الإسكندرية، الإسكندرية
Latitudelatitude
⁦31.189891⁩
Longitudelongitude
⁦29.938381⁩
Plot / Block No.plot_no
Plot 198
Zoning Classificationzoning
Residential
Distance to Main Road (km)dist_main_road
⁦0⁩
Distance to Transport Node (km)dist_transport
⁦0.96⁩
Catchment Population (000s)catchment_pop
⁦EGP 354⁩

C. Physical Characteristics

11
Land Area (m2)land_area
⁦840 m²⁩
Built-Up Area / BUA (m2)bua
⁦2,470 m²⁩
Gross Leasable Area (m2)gla
⁦2,080 m²⁩
Number of Floorsfloors_count
⁦5⁩
Number of Unitsunits_count
⁦22⁩
Year Builtyear_built
⁦2,016⁩
Building Age (yrs)building_ageƒ
⁦10⁩
Structure Typestructure_type
Pre-cast
Finishing Levelfinishing_level
Core & shell
Utilities Connectedutilities
Water only
Heritage-Listed?heritage_listed
No

D. Internal Division & Layout

9
Internally Divided?has_internal_division
Yes
Number of Roomsrooms_count
⁦72⁩
Number of Bathroomsbathrooms_count
⁦26⁩
Reception / Hallsreception_count
⁦17⁩
Kitchenskitchens_count
⁦21⁩
Open-Plan Area (m2)open_plan_area
⁦160 m²⁩
Partition Flexibilitypartition_flexibility
Medium - some structural constraints
Parking Spacesparking_spaces
⁦23⁩
Layout Noteslayout_notes
Single open floor plate, core to the north; ready for partitioning.

E. Condition & Renovation

9
Physical Conditioncondition_rating
Poor
Condition Notes (EN)condition_notes_en
Extensive water ingress; electrical installation unsafe and disconnected.
Condition Notes (AR)condition_notes_ar
تسرب مياه واسع؛ التركيبات الكهربائية غير آمنة ومفصولة.
Renovation Required?renovation_required
Yes
Renovation Scoperenovation_scope
Major - structural + MEP
Renovation Cost (EGP/m2)reno_cost_sqm
⁦10,700 m²⁩
Est. Renovation Cost (EGP)reno_cost_totalƒ
⁦EGP 26,429,000⁩
Renovation Duration (months)reno_duration_months
⁦14⁩
Licensing / Compliance Statuscompliance_status
Fully licensed

F. Valuation

8
Valuation Methodvaluation_method
Income capitalization (الدخل)
Land Value (EGP/m2)land_value_sqm
⁦EGP 21,700⁩
Building Value (EGP/m2)building_value_sqm
⁦EGP 7,000⁩
Est. Market Value (EGP)market_valueƒ
⁦EGP 35,518,000⁩
Value After Renovation (EGP)value_post_renoƒ
⁦EGP 46,173,400⁩
Government Book Value (EGP)book_value
⁦EGP 13,800,000⁩
Valuation Datevaluation_date
⁦4 Aug 2026⁩
Valuation Sourcevaluation_source
Replacement cost less depreciation

G. Income & Rental Potential

11
ADR - Residential (EGP/day)adr_residential
⁦EGP 19,500⁩
ADR - Commercial / Retail (EGP/day)adr_commercial
⁦EGP 0⁩
ADR - Office (EGP/day)adr_office
⁦EGP 0⁩
ADR Applied (EGP/day)adr_applicableƒ
⁦EGP 19,500⁩
Assumed Occupancy Rateoccupancy_rate
⁦75.0%⁩
Gross Annual Revenue (EGP)gross_annual_revenueƒ
⁦EGP 5,338,125⁩
Monthly Rent Equivalent (EGP)monthly_rent_equivƒ
⁦EGP 444,844⁩
Annual Operating Cost (EGP)annual_opex
⁦EGP 1,601,438⁩
Net Operating Income (EGP)noiƒ
⁦EGP 3,736,687⁩
Gross Yield (%)gross_yieldƒ
⁦10.5%⁩
Renovation Payback (yrs)reno_payback_yearsƒ
⁦7.07⁩

H. Utilization Gap & Monetization

7
Current Actual Income (EGP/yr)current_annual_income
⁦EGP 948,000⁩
Annual Revenue Gap (EGP)revenue_gapƒ
⁦EGP 2,788,687⁩
Highest & Best Usehighest_best_use
Retain current use
Recommended Monetization Routemonetization_option
Long-term lease (إيجار طويل الأجل)
CapEx to Activate (EGP)capex_to_activateƒ
⁦EGP 26,429,000⁩
Priority Tierpriority_tier
3 - Long term / complex
Key Blockersblockers
Waqf consent required before any disposal

I. Media & Documentation

6
Number of Photosphotos_count
66
Floor Plan / Survey (URL)floorplan_link
https://drive.example.org/assets/ALX-APT-0117/plan.pdf

J. Data Governance

7
Primary Data Sourcedata_source
Real-estate registry (الشهر العقاري)
Data Confidenceconfidence_level
Medium
Site Visit Datesite_visit_date
⁦12 Dec 2025⁩
Surveyor / Analystsurveyor
Field Team D
Last Updatedlast_updated
⁦8 May 2026⁩
Record Statusrecord_status
Draft
General Notesnotes
Fit-out cost is the only barrier; a lease with fit-out allowance is recommended.

66 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/ALX-APT-0117/photos

Source: Real-estate registry (الشهر العقاري). Surveyed by Field Team D on ⁦12 Dec 2025⁩. Record last updated ⁦8 May 2026⁩.