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.
Ground-Floor Retail Units — Borg El Arab
ALX-RTL-0054 · Alexandria
3 - Long term / complexAbandoned / derelictCondition: DerelictArchivedConfidence: High
Ground-Floor Retail Units — Borg El Arab
16 El Horreya Avenue, Borg El Arab, Alexandria, Alexandria
Retail unit · Standalone · Governorate - Port Said
Value is in the land, not the structures.
Market value
EGP 8m
book value EGP 3.3m
Value after renovation
EGP 11.6m
scope: Major - structural + MEP
CapEx
EGP 9.3m
over 16 months
Net operating income
EGP 1.8m
on EGP 2.6m gross revenue
Gross yield
22.5%
clears the 12% hurdle
Revenue gap
EGP 1.8m
against EGP 0 earned today
Recommendation
Highest & best use
Commercial / retail
Monetization route
Securitize / REIT contribution
Payback
5.2yrs
Vacant
9yrs
Monthly rent equiv.
EGP 214,133
Assumed occupancy
88%
Blockers
- Title unregistered, registration file must be opened
- Licence lapsed, violation on record must be settled
- Clearing informal occupants from the site
Location
- Coordinates
- 31.1963, 29.9142
- Main road / transport
- 0.8 / 2.7 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-RTL-0054
- Asset Name (EN)asset_name_en
- Ground-Floor Retail Units — Borg El Arab
- Asset Name (AR)asset_name_ar
- وحدات تجارية بالدور الأرضي — برج العرب
- Custodian Entitycustodian_entity
- Governorate - Port Said
- Custodian Sub-Unit / Directoratecustodian_sub
- Tourism Development Office
- Ownership Typeownership_type
- Public domain (أملاك عامة)
- Title / Registration Statustitle_status
- Unregistered (غير مسجل)
- Asset Classasset_class
- Retail unit (وحدة تجارية)
- Asset Sub-Typeasset_subtype
- Standalone
- Current Usecurrent_use
- Disused since the department merger
- Utilization Statusutilization_status
- Abandoned / derelict (مهجور)
- Years Vacant / Underusedvacancy_years
- 9
- Occupied By / Encumbrancesoccupied_by
- Informal scrap storage by third parties
B. Location & Geospatial
14- Governorategovernorate
- Alexandria
- City / Markazcity
- Alexandria
- District / Neighbourhooddistrict
- Borg El Arab
- Full Address (EN)address_en
- 16 El Horreya Avenue, Borg El Arab, Alexandria, Alexandria
- Full Address (AR)address_ar
- ١٦ طريق الحرية، برج العرب، الإسكندرية، الإسكندرية
- Latitudelatitude
- 31.196274
- Longitudelongitude
- 29.914169
- Plot / Block No.plot_no
- Block 29 / Plot 33
- Zoning Classificationzoning
- Commercial
- Permitted Use per Detailed Planpermitted_use
- Light and medium industry
- Distance to Main Road (km)dist_main_road
- 0.83
- Distance to Transport Node (km)dist_transport
- 2.70
- Catchment Population (000s)catchment_pop
- EGP 12
C. Physical Characteristics
11- Built-Up Area / BUA (m2)bua
- 760 m²
- Gross Leasable Area (m2)gla
- 680 m²
- Number of Floorsfloors_count
- 1
- Number of Unitsunits_count
- 6
- Year Builtyear_built
- 1,996
- Building Age (yrs)building_ageƒ
- 30
- Structure Typestructure_type
- Reinforced concrete
- 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
- 20
- Number of Bathroomsbathrooms_count
- 8
- Reception / Hallsreception_count
- 5
- Kitchenskitchens_count
- 4
- Open-Plan Area (m2)open_plan_area
- 90 m²
- Partition Flexibilitypartition_flexibility
- High - open plan, easily partitioned
- Parking Spacesparking_spaces
- 0
- Layout Noteslayout_notes
- Ground-floor retail frontage with independent access to upper levels.
E. Condition & Renovation
9- Physical Conditioncondition_rating
- Derelict
- Condition Notes (EN)condition_notes_en
- Roof partially collapsed, timber elements infested; walls structurally intact.
- Condition Notes (AR)condition_notes_ar
- انهيار جزئي بالسقف وإصابة العناصر الخشبية؛ الحوائط سليمة إنشائياً.
- Renovation Required?renovation_required
- Yes
- Renovation Scoperenovation_scope
- Major - structural + MEP
- Renovation Cost (EGP/m2)reno_cost_sqm
- 12,300 m²
- Est. Renovation Cost (EGP)reno_cost_totalƒ
- EGP 9,348,000
- Renovation Duration (months)reno_duration_months
- 16
- Licensing / Compliance Statuscompliance_status
- Unlicensed
F. Valuation
8- Valuation Methodvaluation_method
- Income capitalization (الدخل)
- Building Value (EGP/m2)building_value_sqm
- EGP 10,500
- Est. Market Value (EGP)market_valueƒ
- EGP 7,980,000
- Value After Renovation (EGP)value_post_renoƒ
- EGP 11,571,000
- Government Book Value (EGP)book_value
- EGP 3,300,000
- Valuation Datevaluation_date
- 17 Aug 2026
- Valuation Sourcevaluation_source
- Entlaq desk review + 3 comparables
G. Income & Rental Potential
11- ADR - Residential (EGP/day)adr_residential
- EGP 0
- ADR - Commercial / Retail (EGP/day)adr_commercial
- EGP 8,000
- ADR - Office (EGP/day)adr_office
- EGP 0
- ADR Applied (EGP/day)adr_applicableƒ
- EGP 8,000
- Assumed Occupancy Rateoccupancy_rate
- 88.0%
- Gross Annual Revenue (EGP)gross_annual_revenueƒ
- EGP 2,569,600
- Monthly Rent Equivalent (EGP)monthly_rent_equivƒ
- EGP 214,133
- Annual Operating Cost (EGP)annual_opex
- EGP 770,880
- Net Operating Income (EGP)noiƒ
- EGP 1,798,720
- Gross Yield (%)gross_yieldƒ
- 22.5%
- Renovation Payback (yrs)reno_payback_yearsƒ
- 5.20
H. Utilization Gap & Monetization
7- Current Actual Income (EGP/yr)current_annual_income
- EGP 0
- Annual Revenue Gap (EGP)revenue_gapƒ
- EGP 1,798,720
- Highest & Best Usehighest_best_use
- Commercial / retail
- Recommended Monetization Routemonetization_option
- Securitize / REIT contribution
- CapEx to Activate (EGP)capex_to_activateƒ
- EGP 9,348,000
- Priority Tierpriority_tier
- 3 - Long term / complex
- Key Blockersblockers
- Title unregistered, registration file must be opened; Licence lapsed, violation on record must be settled; Clearing informal occupants from the site
I. Media & Documentation
6- Photos Folder (URL)photos_link
- https://drive.example.org/assets/ALX-RTL-0054/photos
- Number of Photosphotos_count
- 10
- Floor Plan / Survey (URL)floorplan_link
- https://drive.example.org/assets/ALX-RTL-0054/plan.pdf
J. Data Governance
7- Primary Data Sourcedata_source
- Market research
- Data Confidenceconfidence_level
- High
- Site Visit Datesite_visit_date
- 6 Jun 2024
- Surveyor / Analystsurveyor
- N. Mohamed Yehia
- Last Updatedlast_updated
- 12 Aug 2024
- Record Statusrecord_status
- Archived
- General Notesnotes
- Value is in the land, not the structures.
10 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-RTL-0054/photosSource: Market research. Surveyed by N. Mohamed Yehia on 6 Jun 2024. Record last updated 12 Aug 2024.