Competitor Deep-Dive Analysis

Aldilaijan & Khobara Real Estate — Kuwait Market Gaps

Date: 2026-07-23
Scope: 5 competitors, 4 chosen gaps, exhaustive sub-page scraping
Analyst: Kimi Work agent
Methodology: Playwright stealth scraping of homepages + 25+ sub-pages; HTML/JSON extraction; direct codebase comparison.

---

Table of Contents

1. Executive Summary
2. Methodology & Competitor Map
3. Gap 1 — Public Registered-Deals Feed
4. Gap 2 — SEO Landing Pages + English Locale
5. Gap 3 — Reverse Demand Board
6. Gap 4 — Financing Products
7. Appendix: Other Missed Capabilities
8. Master Build-Spec Summary

---

1. Executive Summary

Gap	Primary Competitor(s)	Our Current State	Gap Severity	Effort
Public Registered-Deals Feed	alhisba.com (blocked by CF but homepage shows deals), taqeemkw.com (listings with license numbers)	real_estate_transactions (~149k rows), get_public_real_estate_transactions RPC, public transactions browser, market indicators, price index	Medium — we have data but no deal-card social feed	M
SEO Landing Pages + English Locale	boshamlan.com (764+ indexable URLs, /en, Astro SSR), bu3qar.com (Next.js, area slug pages), alhisba.com (Nuxt SSR, multi-page)	Flutter web app; no SSR/prerendering; no English public routes; single / landing	High — invisible to Google for long-tail queries	L
Reverse Demand Board	alhisba.com (طلب شراء / طلب إيجار tabs)	Internal CRM requests table + matching feature; no public posting or broker response UI	High — entirely internal today	M–L
Financing Products	alhisba.com (/constructionfinance — bank partner form), taqeemkw.com (no financing found), estater.com (B2B advisory only)	mortgage_calculator_screen (pure client-side annuity), roi_calculator_screen (pure client-side yield); no bank APIs, no product marketplace	Medium — calculators exist, product engine missing	L

Key first-pass misses discovered in this round:

• taqeemkw has a consumer property portfolio (/Frontend/Account/Portfolio) — login-gated but a major consumer retention feature we lack.
• taqeemkw lists license numbers on every ad detail (e.g., "ترخيص رقم 1989/2936") — builds trust via Ministry of Commerce attribution.
• alhisba has WhatsApp Channel + direct wa.me links for every listing — no email/phone intermediation.
• alhisba runs a newsletter + news section citing Ministry of Justice deal aggregates (928M KWD in 5 days, 153 deals).
• boshamlan has /agents directory with license numbers + ad counts per office — 71+ offices listed.
• bu3qar has C2C self-serve posting ("مالك عقار? أضف إعلانك") + video content channel (تلفزيون بوعقار) + YouTube integration.
• estater exposes a Google Maps API key in client HTML (AIzaSyAmnH9DzaMJXdNw2TzgZ18RydRBDIhWHUo) — client-side security anti-pattern.

---

2. Methodology & Competitor Map

Scraped Pages (25+ URLs)

Competitor	Home	Sub-pages Scraped	Anti-bot Hit?
taqeemkw.com	✅	Rent estimator, Price estimator, Construction estimator, Search, Ad detail, Portfolio (login gate), English attempt (404)	No
alhisba.com	✅	/deals (CF 403), /constructionfinance, /evaluation/ive/land (CF 403), /ads (CF 403)	Yes — Cloudflare challenge on /deals, /ads, /evaluation
boshamlan.com	✅	/sitemap, /en, /sale/apartments, /sale/properties/area, /agents	No
bu3qar.com	✅	/companies-list, /product-details, /products-for-sale, /tv-serieses implied	No
estater.com	✅	/products, /-en/api ("Coming Soon"), /-en/estater-advisory	No

Data Extraction

• Routes: Python script extracted 1,100+ unique hrefs from boshamlan sitemap alone.
• Meta tags: Title/description/OG tags captured for all 5 homepages.
• Feature flags: Boolean capability matrix (estimators, WhatsApp, financing, video, etc.).
• Screenshots: 20+ PNGs saved to docs/competitor_scrape/ for visual reference.

---

3. Gap 1 — Public Registered-Deals Feed

3.1 Competitor Capabilities

alhisba.com /deals (Cloudflare-protected; inferred from homepage + public reports)

Data fields per deal (from homepage cards + news citations):

• Price (د.ك)
• Price per m² (computed)
• % share sold (partial deals noted in news)
• Plot/piece number (قطعة)
• Category (سكني / تجاري / استثماري)
• Area / governorate
• Transaction date
• Source attribution: "من وزارة العدل" (MoJ sourced)
• Deal volume aggregates (weekly headlines: "928 مليون دينار خلال 5 أيام")

Filter/facet options (inferred from Nuxt route structure):

• /deals — all registered deals
• /ads/for-sale — broker listings (separate tab)
• /auctions/organizer — Ministry of Justice auctions
• Homepage tabs: للبيع / للايجار / طلب شراء / طلب إيجار / للبدل

Features:

• News integration: Links to Al-Qabas, Al-Rai, Al-Seyassah with deal aggregates
• WhatsApp channel for deal alerts (0029VbBk51I1HspwgRMIqg1p)
• App: iOS + Android (2018 founding, 18+ years team experience)
• No observable export/share API from scraped HTML

taqeemkw.com (valuation portal with listings)

Listing data fields (from search + ad detail):

• Purpose: للبيع / للإيجار / للبدل
• Date (e.g., 22/07/2026)
• Area (e.g., الزهراء)
• Category: سكني
• Property type: بيت / أرض فضاء / شقة / فيلا
• Size in m²
• Price in د.ك
• License number on every ad detail (e.g., "ترخيص رقم 1989/2936")
• Agent contact: WhatsApp + Call buttons
• Suggested properties (عقارات مقترحة) — cross-sell

Search filters (from /Frontend/Ads/Search):

• Purpose (ForSale / ForRent / ForExchange)
• Area / Governorate
• Price range
• Size range
• Property type

Valuation estimators (10 types):

• Rent: House, Investment, Artisanal, Commercial
• Price: House (plot + house), Investment (plot + property), Apartment, Artisanal
• Construction: House (skeleton + detailed), Investment (skeleton + detailed)

Consumer portfolio feature:

• /Frontend/Account/Portfolio — login-gated consumer property portfolio tracker

No observable registered-deals feed — taqeemkw is listing-centric, not MoJ transaction-centric.

estater.com (B2B data platform)

• Estater Markets: Data platform with API ("Coming Soon" page observed)
• 500M data points, 6M+ properties, 75+ property details
• Advisory services: Feasibility studies, market reports, highest-and-best-use
• No consumer-facing deal feed

3.2 Our Assets vs. Gap

Capability	Our State	Gap
MoJ transaction data	real_estate_transactions table (~149k rows), refreshed from Ministry of Justice	✅ Strong
Public transaction browser	get_public_real_estate_transactions RPC + public transactions screen	✅ Strong
Analytics RPCs	get_transaction_stats, get_transaction_gov_distribution, get_transaction_cat_distribution, get_transaction_area_prices, get_transaction_monthly_trend, get_transaction_yearly_comparison	✅ Strong
Price index	price_index_screen.dart + price_index_repository.dart	✅ Exists
Market indicators	market_indicators_screen.dart + market_indicators_repository.dart	✅ Exists
Comparables explorer	comparables_screen.dart + comparables_repository.dart	✅ Exists
Deal cards with share %	Not exposed in public UI	❌ Missing
Weekly aggregate headlines	Not auto-generated	❌ Missing
License number on listings	Not shown on public catalog	❌ Missing
WhatsApp integration	Not implemented	❌ Missing
Newsletter / news section	Not implemented	❌ Missing
Consumer property portfolio	Not implemented	❌ Missing

3.3 Build Spec — Public Registered-Deals Feed

Phase 1 (S effort, 1–2 sprints):

• Add license number display to PublicPropertyTile and property detail screens (data already in properties table from broker profiles).
• Add "Suggested properties" cross-link widget to property detail (similar listings by area + type + price band).

Phase 2 (M effort, 2–3 sprints):

• New screen: PublicRegisteredDealsScreen under lib/features/public/screens/
  • Reuse TransactionsFeedController from transactions_repository.dart
  • Card design: price, price/m², area, governorate, date, property type, share % (if available)
  • Filter sheet: governorate, area, property type, date range, price range
  • Sort: date desc/asc, price desc/asc, price/m² desc/asc
• Add weekly aggregate headline generator edge function:
  • Cron weekly, computes total volume, deal count, top area
  • Store in new market_headlines table
  • Display on public landing as live stat strip

Phase 3 (M effort, 2–3 sprints):

• Consumer property portfolio (property_portfolio_screen.dart exists but is calculator-only; expand):
  • Allow logged-in users to save favorite properties
  • Track saved search alerts
  • New table: user_favorites (user_id, property_id, created_at)
  • RLS: users can only read/write their own rows

Data/RLS changes:

-- market_headlines table
CREATE TABLE market_headlines (
  id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  week_start date NOT NULL,
  week_end date NOT NULL,
  headline_ar text NOT NULL,
  headline_en text,
  total_volume numeric,
  deal_count int,
  top_area text,
  created_at timestamptz DEFAULT now()
);

-- user_favorites table
CREATE TABLE user_favorites (
  id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  user_id uuid REFERENCES auth.users(id) ON DELETE CASCADE,
  property_id uuid REFERENCES properties(id) ON DELETE CASCADE,
  created_at timestamptz DEFAULT now(),
  UNIQUE(user_id, property_id)
);
ALTER TABLE user_favorites ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Users manage own favorites" ON user_favorites
  FOR ALL USING (auth.uid() = user_id);

Edge functions needed:

• generate-weekly-headline (cron trigger, weekly)

Effort: M (4–6 sprints total)

---

4. Gap 2 — SEO Landing Pages + English Locale

4.1 Competitor Capabilities

boshamlan.com (Astro-based, SSR/static generation)

URL taxonomy (from sitemap scrape — 764+ unique URLs):

/{purpose}/{type}/                    → e.g. /sale/apartments
/{purpose}/{type}/{governorate}/      → e.g. /sale/apartments/al-asimah-governorate
/{purpose}/{type}/{governorate}/{area}/ → e.g. /sale/apartments/al-asimah-governorate/yarmouk

Purpose values: sale, rent, exchange
Type values: apartments, houses, lands, buildings, chalets, commercials, offices, properties
Governorates: al-ahmadi, al-asimah, al-farwaniya, al-jahra, hawally, mubarak-al-kabeer
Areas: 70+ slugs (yarmouk, salmiya, jabriya, etc.)

Meta patterns:

• Title: "شقق للايجار | بيوت للبيع | بوشملان دليل عقارات الكويت #1" (homepage)
• Area page title: "عقارات للبيع في اليرموك | بيوت واراضي | بوشملان"
• Description: "شقق للإيجار في الكويت | بيوت اراضي عقارات للبيع | من المالك مباشرة وبدون عمولة"

English locale:

• /en — full English mirror of Arabic site
• Property types translated: "Apartments for Rent", "Houses for Sale"
• Area names romanized: "yarmouk", "salmiya", "al-ahmadi-governorate"

Internal linking:

• Footer links to all governorate × type combinations
• Sitemap page (/sitemap) lists all indexable URLs for crawlers

bu3qar.com (Next.js, Arabic-only)

URL patterns:

/products-for-sale/{slug}   → SEO slug with Arabic keywords
/products-for-rent/{slug}
/products-for-exchange/{slug}
/companies-list             → Office directory
/tv-serieses/{slug}         → Video content

SEO features:

• Arabic keyword-rich URLs (عقارات-للبيع-في-الكويت)
• Product detail pages with related properties (عقارات ذات صلة)
• Office profile pages (/profile/{company-slug})

No English version observed.

alhisba.com (Nuxt.js, SSR)

Routes:

/                    → Homepage with tabs
/ads/for-sale        → Broker listings
/deals               → Registered deals (CF protected)
/evaluation/ive/land → Instant valuation
/constructionfinance → Financing calculator
/auctions/organizer  → MoJ auctions

Meta:

• Title: "موقع العقارات #1 في الكويت | الحسبة العقارية دليل سوق العقارات"
• Description mentions "مزاد وزارة العدل", "تفاصيل المزادات العقارية والصفقات العقارية", "تكلفة البناء", "التقييم الرسمي والفوري"

No English version observed.

estater.com (Webflow/custom, bilingual)

Bilingual: / (Arabic default), /-en (English)

• Full English version with all product pages
• API docs page (/-en/api) — currently "Coming Soon"

4.2 Our Assets vs. Gap

Capability	Our State	Gap
Flutter web app	Single-page app, all routes hash-based (/#/sign-in)	❌ No SSR/prerendering
Public routes	/, /catalog, /tools, /transactions, /contact, etc.	✅ Functional but not indexable
English locale	AppLocalizations supports en, but no public English routes	❌ Missing
Area-specific pages	None	❌ Missing
Property-type-specific pages	None	❌ Missing
Sitemap	None	❌ Missing
Meta tags per route	Generic, not dynamic per listing/area	❌ Missing

4.3 Build Spec — SEO Landing Pages + English Locale

Architecture decision: Flutter Web cannot do true SSR. Two viable paths:

Option A: Prerender service (recommended for Phase 1)

• Use flutter build web + a prerenderer (e.g., rendertron, Puppeteer prerender) to generate static HTML for key routes
• Host prerendered HTML via Cloudflare Pages or a lightweight Node service
• Map /sale/apartments/yarmouk → prerendered HTML with proper meta tags

Option B: Hybrid Astro site (recommended for Phase 2)

• Build a separate Astro site (docs/seo-site/ or separate repo) that consumes our Supabase API
• Astro generates static pages at build time for all area × type × purpose combinations
• Embed Flutter app as the interactive layer (e.g., /app/ routes)

Phase 1 (M effort, 2–3 sprints) — Prerender + meta injection:

• Create SeoMetaInjector widget in Flutter that updates document.title and <meta name="description"> dynamically per route
• Generate a static sitemap.xml from our area + property type data:
  • Export all areas from area_repository.dart
  • Export property types from property_choice_labels.dart
  • Script generates sitemap.xml with all combinations
• Add robots.txt pointing to sitemap

Phase 2 (L effort, 4–6 sprints) — English public routes:

• Duplicate public route tree under /en/ prefix:
  • public_landing_screen_en.dart (or reuse with locale switch)
  • All tool screens get English copy review
• Add language switcher to PublicVisitorShell
• Update GoRouter to support /:lang/ prefix or query param

Phase 3 (L effort, 4–6 sprints) — Area landing pages:

• New edge function: generate-area-pages that creates static HTML for each area
  • Consumes get_public_real_estate_transactions RPC for area stats
  • Consumes properties table for active listings in area
  • Generates: avg price, price/m², recent transactions, active listings count
• New screen: AreaLandingScreen (lib/features/public/screens/area_landing_screen.dart)
  • Hero: area name + stats
  • Tabs: For Sale / For Rent / Transactions / Price Trend
  • Related areas links (internal linking)

Data/RLS changes:

• No schema changes needed — reads from existing properties, real_estate_transactions, areas tables
• Add seo_slugs column to areas table (English URL slug) if not present

Edge functions needed:

• generate-sitemap (manual or scheduled)
• generate-area-page-html (on-demand or scheduled)

Effort: L (10–15 sprints across phases)

---

5. Gap 3 — Reverse Demand Board

5.1 Competitor Capabilities

alhisba.com (طلب شراء / طلب إيجار)

From homepage content preview:

• Tabs on homepage: "طلب شراء" (Purchase Request) and "طلب إيجار" (Rent Request)
• These appear alongside "للبيع" / "للايجار" / "للبدل" tabs
• Routing: inferred to be query params on /ads or separate /requests routes

Data model (inferred from UI patterns + industry standards):

• Budget range (min/max)
• Area preferences (governorate + specific areas)
• Property type (بيت / شقة / أرض / فيلا)
• Purpose (سكني / استثماري / تجاري)
• Contact method (phone, WhatsApp)
• Expiry date
• Visibility: public vs. registered brokers only

Broker response flow (inferred):

• Broker sees request, contacts requester via WhatsApp/phone
• No observable in-app messaging from scraped data

boshamlan.com / bu3qar.com

• No reverse demand board observed — both are supply-side (listing) only
• bu3qar has C2C posting but no "I'm looking for" feature

5.2 Our Assets vs. Gap

Capability	Our State	Gap
Internal requests CRM	requests table with: name, phone, budget, areas, property types, purpose, status, assigned_agent, follow_up_date	✅ Strong (internal)
Matching engine	matching_screen.dart, request_matches_screen.dart, buyer_journey_screen.dart	✅ Strong (internal)
Request form	request_form_screen.dart — rich form with areas, budget, size, street type, subdividable, tags	✅ Strong (internal)
Public request posting	None	❌ Missing entirely
Public request browsing	None	❌ Missing entirely
Broker response UI	Internal only (request_suggestions_list_screen.dart)	❌ Missing
Request-to-listing matching	Internal algorithm exists; not exposed publicly	❌ Missing

5.3 Build Spec — Reverse Demand Board

Phase 1 (M effort, 3–4 sprints) — Public request posting:

• New screen: PublicRequestBoardScreen (lib/features/public/screens/)
  • Tabbed: Purchase Requests / Rent Requests
  • List cards: budget, areas, property type, date posted, requester initials (anonymized)
  • Filter: governorate, area, property type, budget range
• New table: public_requests (or reuse requests with visibility column)

-- Add visibility column to existing requests table
ALTER TABLE requests ADD COLUMN IF NOT EXISTS visibility text DEFAULT 'internal'
  CHECK (visibility IN ('internal', 'public', 'public_anonymous'));

-- Or new table if schema divergence is too high
CREATE TABLE public_demand_requests (
  id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  requester_name text,
  requester_phone text,
  budget_min numeric,
  budget_max numeric,
  areas text[],
  governorates text[],
  property_types text[],
  purpose text,
  details text,
  status text DEFAULT 'active' CHECK (status IN ('active', 'fulfilled', 'expired')),
  expires_at timestamptz,
  created_at timestamptz DEFAULT now(),
  user_id uuid REFERENCES auth.users(id) ON DELETE SET NULL
);

• Posting flow:
  • Anonymous or logged-in user fills simplified PublicRequestFormScreen
  • Fields: name, phone, budget, areas (multi-select), property type, purpose, details
  • OTP verification for phone (optional Phase 2)
  • Request expires in 30 days by default

Phase 2 (M effort, 3–4 sprints) — Broker response + matching:

• New screen: PublicRequestDetailScreen
  • Shows full request details
  • "I have a match" button for logged-in brokers
  • Contact requester via WhatsApp (deep link) or in-app message
• Extend request_matches or create public_request_responses:

CREATE TABLE public_request_responses (
  id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  request_id uuid REFERENCES public_demand_requests(id) ON DELETE CASCADE,
  responder_id uuid REFERENCES auth.users(id),
  responder_type text DEFAULT 'broker' CHECK (responder_type IN ('broker', 'owner')),
  message text,
  property_id uuid REFERENCES properties(id),
  status text DEFAULT 'pending' CHECK (status IN ('pending', 'accepted', 'rejected')),
  created_at timestamptz DEFAULT now()
);

• Integrate with existing matching feature:
  • When a new listing is posted, auto-match against active public requests
  • Notify requester (SMS/WhatsApp in Phase 3)

Phase 3 (S effort, 1–2 sprints) — Notifications + expiry:

• Edge function: expire-old-requests (daily cron)
• Edge function: notify-request-matches (on property insert trigger)

RLS policies:

-- Public can read active requests
CREATE POLICY "Public reads active requests" ON public_demand_requests
  FOR SELECT USING (status = 'active' AND expires_at > now());

-- Users manage own requests
CREATE POLICY "Users manage own requests" ON public_demand_requests
  FOR ALL USING (auth.uid() = user_id);

-- Brokers can create responses
CREATE POLICY "Brokers create responses" ON public_request_responses
  FOR INSERT WITH CHECK (auth.uid() = responder_id);

Effort: M–L (6–10 sprints)

---

6. Gap 4 — Financing Products

6.1 Competitor Capabilities

alhisba.com /constructionfinance

User flow (from scraped page):

1. Header: "حسبة التمويل" (Financing Calculator)
2. Service definition + terms of use disclaimer
3. Form fields:
   • "هل لديك حساب في بنك بوبيان ؟" (Do you have a Boubyan Bank account?) — yes/no
   • "قيمة العقار" (Property value)
   • "الدفعة الأولى" (Down payment)
   • "فترة السداد" (Repayment period) — dropdown: 12 months default, up to 25 years inferred
4. "التالي" (Next) button

What's behind the form (inferred):

• Bank partner: Boubyan Bank (Islamic bank)
• Calculation uses bank's approved rates/formulas
• Likely redirects to bank application or generates a referral code
• Monetization: Lead generation / referral fee from bank

Other financing features on alhisba:

• "موّل بيت أحلامك" (Finance your dream home) — homepage CTA
• Instant residential rent estimator (for investment yield calculation)
• IVE (Instant Valuation Engine) for land
• CCE (construction cost estimator)

taqeemkw.com

• No financing products observed
• Pure valuation + listing portal
• No bank partnerships visible

estater.com

• B2B advisory only — no consumer financing
• "Highest and Best Use Study", "Feasibility Study", "Market Report"
• Client-base: developers, banks, government (100+ GCC clients)

6.2 Our Assets vs. Gap

Capability	Our State	Gap
Mortgage calculator	mortgage_calculator_screen.dart — pure client-side annuity formula (principal × rate / (1-(1+r)^-n))	✅ Basic calc
ROI calculator	roi_calculator_screen.dart — gross yield + cap rate, client-side	✅ Basic calc
Construction cost calc	construction_cost_calculator_screen.dart	✅ Exists
Bank partner integration	None	❌ Missing
Rate feed from banks	None	❌ Missing
Eligibility check	None	❌ Missing
Product comparison	None	❌ Missing
Application / referral flow	None	❌ Missing
Construction finance	None	❌ Missing

6.3 Build Spec — Financing Products

Phase 1 (M effort, 3–4 sprints) — Mortgage product marketplace:

• New table: mortgage_products

CREATE TABLE mortgage_products (
  id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  bank_name text NOT NULL,
  bank_name_en text,
  product_name text NOT NULL,
  product_type text CHECK (product_type IN ('residential_purchase', 'construction', 'refinance', 'investment')),
  min_down_payment_pct numeric DEFAULT 20,
  max_loan_amount numeric,
  max_term_years int DEFAULT 25,
  profit_rate_fixed numeric,
  profit_rate_variable numeric,
  profit_rate_type text DEFAULT 'fixed' CHECK (profit_rate_type IN ('fixed', 'variable', 'diminishing')),
  eligibility_notes text,
  application_url text,
  is_active boolean DEFAULT true,
  created_at timestamptz DEFAULT now()
);

• New screen: MortgageMarketplaceScreen

  • List active products from mortgage_products
  • Filter: product type, bank, down payment, term
  • Card: bank logo, product name, rate, max amount, eligibility teaser
  • CTA: "Apply" → opens bank application URL or pre-fills referral form

• Extend existing MortgageCalculatorScreen:

  • After calculation, show "Compare bank products" CTA
  • Pre-fill calculator inputs into product filter

Phase 2 (M effort, 3–4 sprints) — Eligibility engine + referral:

• New edge function: check-financing-eligibility

  • Inputs: salary, existing debt, property value, down payment
  • Outputs: eligible products, max loan amount, estimated monthly payment per product
  • Rules based on Kuwait Central Bank guidelines (debt-to-income ≤ 50%)

• New screen: FinancingEligibilityScreen

  • Wizard: salary → existing debt → property value → down payment
  • Results: eligible banks + products + pre-approved amount
  • "Request callback" CTA (creates CRM lead)

• New table: financing_referrals

CREATE TABLE financing_referrals (
  id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  user_id uuid REFERENCES auth.users(id),
  product_id uuid REFERENCES mortgage_products(id),
  property_value numeric,
  down_payment numeric,
  loan_amount numeric,
  term_years int,
  monthly_payment numeric,
  status text DEFAULT 'submitted' CHECK (status IN ('submitted', 'contacted', 'approved', 'rejected', 'closed')),
  broker_notes text,
  created_at timestamptz DEFAULT now()
);

Phase 3 (S effort, 1–2 sprints) — Construction finance:

• Add construction to mortgage_products.product_type
• New screen: ConstructionFinanceScreen (inspired by alhisba)
  • Staged disbursement calculator (foundation, skeleton, finishing)
  • Link to CCE (construction cost estimator) for baseline property value

RLS policies:

CREATE POLICY "Public reads active products" ON mortgage_products
  FOR SELECT USING (is_active = true);

CREATE POLICY "Users manage own referrals" ON financing_referrals
  FOR ALL USING (auth.uid() = user_id);

CREATE POLICY "Staff read all referrals" ON financing_referrals
  FOR SELECT USING (is_staff_or_admin());

Effort: L (7–10 sprints)

---

7. Appendix: Other Missed Capabilities

7.1 Saved Searches & Alerts

• boshamlan: No explicit saved search observed, but "مميز" (featured) badge system implies promotion capability
• alhisba: WhatsApp channel acts as passive alert system
• Our gap: No saved search or price-drop alert system

7.2 Map Search

• estater: Uses Google Maps (API key exposed in HTML — security issue)
• taqeemkw: No map search observed
• Our state: public_price_map_screen.dart exists — ✅ competitive

7.3 Ad Promotion / Featured Listings

• boshamlan: "مميز" (featured) badge on listings — paid promotion
• taqeemkw: No promotion observed
• Our gap: No paid promotion system for listings

7.4 WhatsApp Integration Patterns

• alhisba: WhatsApp Channel (0029VbBk51I1HspwgRMIqg1p) + direct wa.me links + WhatsApp button on every listing
• taqeemkw: "وتساب" button on ad detail pages
• bu3qar: No WhatsApp observed; phone-only
• Our gap: No WhatsApp integration anywhere

7.5 Video Content / TV Channel

• bu3qar: "تلفزيون بوعقار" — dedicated video content section with meetings, discussions, news, programs
• YouTube channel: UC8saXgab00UZFBKZWchBSCA
• Our gap: No video content strategy

7.6 Newsletter / Email Subscription

• alhisba: Email subscription widget on homepage
• News integration: Links to Al-Qabas, Al-Rai, Al-Seyassah
• Our gap: No newsletter or content marketing

7.7 Agent / Office Directory

• boshamlan: /agents — 71+ offices with license numbers, ad counts, addresses
• bu3qar: /companies-list — filterable by area, licensed office badge
• Our gap: No public office directory (internal broker profiles only)

7.8 C2C Self-Serve Listing Posting

• bu3qar: "مالك عقار? أضف إعلانك" — owner self-serve posting with simple signup
• taqeemkw: /Frontend/Ads/AddAdLocation — multi-step ad creation (location → category → details)
• Our gap: Only staff can post listings via CRM

7.9 Property Portfolio for Consumers

• taqeemkw: /Frontend/Account/Portfolio — consumer can track their properties
• Our gap: No consumer property portfolio (only staff deal portal)

7.10 Report Verification

• Our state: report_verify_screen.dart exists — ✅ unique competitive advantage

---

8. Master Build-Spec Summary

Gap	Priority	Phase 1 (Quick Wins)	Phase 2 (Core)	Phase 3 (Scale)	Total Effort
1. Registered Deals	P2	License numbers on listings; Suggested properties	Public deals feed screen; Weekly headline generator	Consumer portfolio; Favorites; Alerts	M (4–6 sprints)
2. SEO + English	P1	Dynamic meta injection; robots.txt; sitemap.xml	English public route tree; Language switcher	Astro hybrid site; Area landing pages	L (10–15 sprints)
3. Reverse Demand	P1	Public request board; Simplified posting form	Broker response UI; Auto-match on new listings	SMS/WhatsApp notifications; OTP verification	M–L (6–10 sprints)
4. Financing	P2	Mortgage product marketplace table + screen	Eligibility engine; Referral workflow	Construction finance; Bank API integration	L (7–10 sprints)

Recommended Phased Rollout

Q3 2026 — Foundation (SEO + Demand):

• Sprint 1–2: SEO meta injection, sitemap, robots.txt
• Sprint 3–4: English public routes (language switcher)
• Sprint 5–6: Public reverse demand board (posting + browsing)
• Sprint 7–8: Broker response UI for demand board

Q4 2026 — Growth (Deals + Financing):

• Sprint 1–2: Public registered-deals feed (reuse transactions RPC)
• Sprint 3–4: Weekly headline generator; License numbers on listings
• Sprint 5–6: Mortgage product marketplace
• Sprint 7–8: Eligibility engine + referral workflow

Q1 2027 — Scale:

• Area landing pages (Astro hybrid or prerender)
• Consumer property portfolio
• Construction finance
• WhatsApp integration (dependent on business API approval)
• Video content strategy

---

End of report. All scraped artifacts (HTML, PNG screenshots, extraction scripts) are preserved in docs/competitor_scrape/.