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 — Ismailia
ISM-APT-0007 · Ismailia
Staff Apartment Block — Ismailia
Block 5, Canal Housing Compound, Ismailia
Apartment · Within compound · State-Owned Enterprise
Lowest capex-to-income ratio in the sample; recommend as pilot for the leasing model.
Market value
EGP 39.9m
book value EGP 26m
Value after renovation
EGP 41.9m
scope: Cosmetic / finishes only
CapEx
EGP 7.2m
over 4 months
Net operating income
EGP 3.6m
on EGP 5.1m gross revenue
Gross yield
9.0%
below the 12% hurdle — sale candidate
Revenue gap
EGP 3.4m
against EGP 216k earned today
Recommendation
Highest & best use
Residential development
Monetization route
Long-term lease
Payback
2.0yrs
Vacant
5yrs
Monthly rent equiv.
EGP 425,833
Assumed occupancy
70%
Blockers
- Staff tenancy terms need review before market letting
Location
- Coordinates
- 30.5961, 32.2719
- Main road / transport
- 0.4 / 2.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
- ISM-APT-0007
- Asset Name (EN)asset_name_en
- Staff Apartment Block — Ismailia
- Asset Name (AR)asset_name_ar
- عمارة سكن العاملين — الإسماعيلية
- Custodian Entitycustodian_entity
- State-Owned Enterprise
- Custodian Sub-Unit / Directoratecustodian_sub
- Canal Region Housing Unit
- Ownership Typeownership_type
- State freehold (ملكية خاصة للدولة)
- Title / Registration Statustitle_status
- Registered (مسجل)
- Real-Estate Registry No.registry_no
- 2011/3345
- Asset Classasset_class
- Apartment (شقة)
- Asset Sub-Typeasset_subtype
- Within compound
- Current Usecurrent_use
- 6 of 24 units occupied by staff
- Utilization Statusutilization_status
- Partially utilized (مستغل جزئياً)
- Years Vacant / Underusedvacancy_years
- 5
- Occupied By / Encumbrancesoccupied_by
- 6 staff households
B. Location & Geospatial
14- Governorategovernorate
- Ismailia
- City / Markazcity
- Ismailia
- District / Neighbourhooddistrict
- El Sheikh Zayed Quarter
- Full Address (EN)address_en
- Block 5, Canal Housing Compound, Ismailia
- Full Address (AR)address_ar
- عمارة ٥، مجمع إسكان القناة، الإسماعيلية
- Latitudelatitude
- 30.596111
- Longitudelongitude
- 32.271944
- Plot / Block No.plot_no
- Block 5
- Zoning Classificationzoning
- Residential
- Permitted Use per Detailed Planpermitted_use
- Residential
- Distance to Main Road (km)dist_main_road
- 0.40
- Distance to Transport Node (km)dist_transport
- 2
- Catchment Population (000s)catchment_pop
- EGP 130
C. Physical Characteristics
11- Land Area (m2)land_area
- 1,100 m²
- Built-Up Area / BUA (m2)bua
- 2,880 m²
- Gross Leasable Area (m2)gla
- 2,600 m²
- Number of Floorsfloors_count
- 6
- Number of Unitsunits_count
- 24
- Year Builtyear_built
- 2,011
- Building Age (yrs)building_ageƒ
- 15
- 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
- Yes
- Number of Roomsrooms_count
- 72
- Number of Bathroomsbathrooms_count
- 24
- Reception / Hallsreception_count
- 24
- Kitchenskitchens_count
- 24
- Partition Flexibilitypartition_flexibility
- Low - fixed load-bearing layout
- Parking Spacesparking_spaces
- 12
- Layout Noteslayout_notes
- 24 identical units: 3 rooms + reception + kitchen + 1 bathroom, ~120 m2 each
E. Condition & Renovation
9- Physical Conditioncondition_rating
- Good
- Condition Notes (EN)condition_notes_en
- Sound and habitable; vacant units need repainting and fixture replacement.
- Condition Notes (AR)condition_notes_ar
- سليمة وصالحة للسكن؛ الوحدات الشاغرة تحتاج دهانات وتغيير أطقم.
- Renovation Required?renovation_required
- Yes
- Renovation Scoperenovation_scope
- Cosmetic / finishes only
- Renovation Cost (EGP/m2)reno_cost_sqm
- 2,500 m²
- Est. Renovation Cost (EGP)reno_cost_totalƒ
- EGP 7,200,000
- Renovation Duration (months)reno_duration_months
- 4
- Licensing / Compliance Statuscompliance_status
- Fully licensed
F. Valuation
8- Valuation Methodvaluation_method
- Income capitalization (الدخل)
- Land Value (EGP/m2)land_value_sqm
- EGP 7,500
- Building Value (EGP/m2)building_value_sqm
- EGP 11,000
- Est. Market Value (EGP)market_valueƒ
- EGP 39,930,000
- Value After Renovation (EGP)value_post_renoƒ
- EGP 41,926,500
- Government Book Value (EGP)book_value
- EGP 26,000,000
- Valuation Datevaluation_date
- 29 Aug 2026
- Valuation Sourcevaluation_source
- Ismailia residential rent comparables
G. Income & Rental Potential
11- ADR - Residential (EGP/day)adr_residential
- EGP 20,000
- ADR - Commercial / Retail (EGP/day)adr_commercial
- EGP 0
- ADR - Office (EGP/day)adr_office
- EGP 0
- ADR Applied (EGP/day)adr_applicableƒ
- EGP 20,000
- Assumed Occupancy Rateoccupancy_rate
- 70.0%
- Gross Annual Revenue (EGP)gross_annual_revenueƒ
- EGP 5,110,000
- Monthly Rent Equivalent (EGP)monthly_rent_equivƒ
- EGP 425,833
- Annual Operating Cost (EGP)annual_opex
- EGP 1,533,000
- Net Operating Income (EGP)noiƒ
- EGP 3,577,000
- Gross Yield (%)gross_yieldƒ
- 9.0%
- Renovation Payback (yrs)reno_payback_yearsƒ
- 2.01
H. Utilization Gap & Monetization
7- Current Actual Income (EGP/yr)current_annual_income
- EGP 216,000
- Annual Revenue Gap (EGP)revenue_gapƒ
- EGP 3,361,000
- Highest & Best Usehighest_best_use
- Residential development
- Recommended Monetization Routemonetization_option
- Long-term lease (إيجار طويل الأجل)
- CapEx to Activate (EGP)capex_to_activateƒ
- EGP 7,200,000
- Priority Tierpriority_tier
- 1 - Quick win
- Key Blockersblockers
- Staff tenancy terms need review before market letting
I. Media & Documentation
6- Photos Folder (URL)photos_link
- https://drive.example.org/assets/ISM-APT-0007/photos
- Number of Photosphotos_count
- 22
- Floor Plan / Survey (URL)floorplan_link
- https://drive.example.org/assets/ISM-APT-0007/plan.pdf
- Title Deed & Docs (URL)deed_docs_link
- https://drive.example.org/assets/ISM-APT-0007/deed.pdf
J. Data Governance
7- Primary Data Sourcedata_source
- Government dataset (custodian)
- Data Confidenceconfidence_level
- High
- Site Visit Datesite_visit_date
- 21 Aug 2026
- Surveyor / Analystsurveyor
- Field Team B
- Last Updatedlast_updated
- 4 Sept 2026
- Record Statusrecord_status
- Validated
- General Notesnotes
- Lowest capex-to-income ratio in the sample; recommend as pilot for the leasing model.
22 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/ISM-APT-0007/photosSource: Government dataset (custodian). Surveyed by Field Team B on 21 Aug 2026. Record last updated 4 Sept 2026.