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.
Official Guest House — Shubra El Kheima
QLY-VIL-0053 · Qalyubia
3 - Long term / complexVacantCondition: GoodUnder reviewConfidence: Low
Official Guest House — Shubra El Kheima
137 El Nasr Road, Bahtim, Shubra El Kheima, Qalyubia
Villa · Standalone · Ministry of Education
Value is in the land, not the structures.
Market value
EGP 40.8m
book value EGP 16.8m
Value after renovation
EGP 42.8m
scope: Cosmetic / finishes only
CapEx
EGP 3.1m
over 3 months
Net operating income
EGP 3.3m
on EGP 4.7m gross revenue
Gross yield
8.0%
below the 12% hurdle — sale candidate
Revenue gap
EGP 3.3m
against EGP 0 earned today
Recommendation
Highest & best use
Retain current use
Monetization route
Retain & operate in-house
Payback
1.0yrs
Vacant
11yrs
Monthly rent equiv.
EGP 389,638
Assumed occupancy
61%
Blockers
- Licence lapsed, violation on record must be settled
Location
- Coordinates
- 30.1354, 31.2435
- Main road / transport
- 0.7 / 1.8 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
- QLY-VIL-0053
- Asset Name (EN)asset_name_en
- Official Guest House — Shubra El Kheima
- Asset Name (AR)asset_name_ar
- دار الضيافة الرسمية — شبرا الخيمة
- Custodian Entitycustodian_entity
- Ministry of Education
- Custodian Sub-Unit / Directoratecustodian_sub
- Property Office
- Ownership Typeownership_type
- Usufruct (حق انتفاع)
- Title / Registration Statustitle_status
- Registered (مسجل)
- Real-Estate Registry No.registry_no
- 2002/4809
- Asset Classasset_class
- Villa (فيلا)
- Asset Sub-Typeasset_subtype
- Standalone
- Current Usecurrent_use
- Partially occupied by a single unit
- Utilization Statusutilization_status
- Vacant (شاغر)
- Years Vacant / Underusedvacancy_years
- 11
- Occupied By / Encumbrancesoccupied_by
- None
B. Location & Geospatial
14- Governorategovernorate
- Qalyubia
- City / Markazcity
- Shubra El Kheima
- District / Neighbourhooddistrict
- Bahtim
- Full Address (EN)address_en
- 137 El Nasr Road, Bahtim, Shubra El Kheima, Qalyubia
- Full Address (AR)address_ar
- ١٣٧ طريق النصر، بهتيم، شبرا الخيمة، القليوبية
- Latitudelatitude
- 30.135409
- Longitudelongitude
- 31.243493
- Plot / Block No.plot_no
- Plot 116
- Zoning Classificationzoning
- Touristic
- Permitted Use per Detailed Planpermitted_use
- Residential + ground retail, FAR 2.5
- Distance to Main Road (km)dist_main_road
- 0.68
- Distance to Transport Node (km)dist_transport
- 1.81
- Catchment Population (000s)catchment_pop
- EGP 98
C. Physical Characteristics
11- Land Area (m2)land_area
- 1,590 m²
- Built-Up Area / BUA (m2)bua
- 1,200 m²
- Gross Leasable Area (m2)gla
- 1,020 m²
- Number of Floorsfloors_count
- 3
- Number of Unitsunits_count
- 2
- Year Builtyear_built
- 1,988
- Building Age (yrs)building_ageƒ
- 38
- Structure Typestructure_type
- Traditional / heritage
- 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
- 3
- Number of Bathroomsbathrooms_count
- 2
- Reception / Hallsreception_count
- 2
- Kitchenskitchens_count
- 2
- Open-Plan Area (m2)open_plan_area
- 140 m²
- Partition Flexibilitypartition_flexibility
- Medium - some structural constraints
- Parking Spacesparking_spaces
- 4
- Layout Noteslayout_notes
- Reception opens to a garden; bedrooms distributed across upper floors.
E. Condition & Renovation
9- Physical Conditioncondition_rating
- Good
- Condition Notes (EN)condition_notes_en
- Well maintained; minor cosmetic wear to finishes and external joinery.
- 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,600 m²
- Est. Renovation Cost (EGP)reno_cost_totalƒ
- EGP 3,120,000
- Renovation Duration (months)reno_duration_months
- 3
- Licensing / Compliance Statuscompliance_status
- Violation on record
F. Valuation
8- Valuation Methodvaluation_method
- Comparable sales (المقارنة)
- Land Value (EGP/m2)land_value_sqm
- EGP 16,200
- Building Value (EGP/m2)building_value_sqm
- EGP 12,500
- Est. Market Value (EGP)market_valueƒ
- EGP 40,758,000
- Value After Renovation (EGP)value_post_renoƒ
- EGP 42,795,900
- Government Book Value (EGP)book_value
- EGP 16,800,000
- Valuation Datevaluation_date
- 31 Jul 2026
- Valuation Sourcevaluation_source
- Heritage restoration cost benchmarks
G. Income & Rental Potential
11- ADR - Residential (EGP/day)adr_residential
- EGP 21,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 21,000
- Assumed Occupancy Rateoccupancy_rate
- 61.0%
- Gross Annual Revenue (EGP)gross_annual_revenueƒ
- EGP 4,675,650
- Monthly Rent Equivalent (EGP)monthly_rent_equivƒ
- EGP 389,638
- Annual Operating Cost (EGP)annual_opex
- EGP 1,402,695
- Net Operating Income (EGP)noiƒ
- EGP 3,272,955
- Gross Yield (%)gross_yieldƒ
- 8.0%
- Renovation Payback (yrs)reno_payback_yearsƒ
- 0.95
H. Utilization Gap & Monetization
7- Current Actual Income (EGP/yr)current_annual_income
- EGP 0
- Annual Revenue Gap (EGP)revenue_gapƒ
- EGP 3,272,955
- Highest & Best Usehighest_best_use
- Retain current use
- Recommended Monetization Routemonetization_option
- Retain & operate in-house
- CapEx to Activate (EGP)capex_to_activateƒ
- EGP 3,120,000
- Priority Tierpriority_tier
- 3 - Long term / complex
- Key Blockersblockers
- Licence lapsed, violation on record must be settled
I. Media & Documentation
6- Photos Folder (URL)photos_link
- https://drive.example.org/assets/QLY-VIL-0053/photos
- Number of Photosphotos_count
- 37
- Floor Plan / Survey (URL)floorplan_link
- https://drive.example.org/assets/QLY-VIL-0053/plan.pdf
- Title Deed & Docs (URL)deed_docs_link
- https://drive.example.org/assets/QLY-VIL-0053/deed.pdf
- Video / 360 Tour (URL)video_link
- https://video.example.org/QLY-VIL-0053/tour
J. Data Governance
7- Primary Data Sourcedata_source
- Government dataset (custodian)
- Data Confidenceconfidence_level
- Low
- Site Visit Datesite_visit_date
- 8 Jan 2025
- Surveyor / Analystsurveyor
- R. El Morally
- Last Updatedlast_updated
- 9 Jan 2026
- Record Statusrecord_status
- Under review
- General Notesnotes
- Value is in the land, not the structures.
37 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/QLY-VIL-0053/photosSource: Government dataset (custodian). Surveyed by R. El Morally on 8 Jan 2025. Record last updated 9 Jan 2026.