Analyzing Land Subdivision Investment

Given a budget and target region, produce this deliverable structure:

1. Price comparison table (€/m²): urban land ("terreno urbano") vs. built house+plot, by parish
2. Regional pricing map: cheapest vs. most expensive areas that still meet quality-of-life criteria
3. Live listings: 3-5 real candidates with URLs, size, price, zoning
4. Subdivision P&L model: cost/revenue table over 2-3 years for the best candidate
5. Verdict: profitable or not, with sensitivity range, and a legal red-flag check

Never skip the legal feasibility check — subdivision restrictions can invalidate the entire thesis before any financial modeling matters.

Progress:
- [ ] Step 1: Define scope precisely (municipality/parish, not vague "region")
- [ ] Step 2: Pull €/m² data for terreno urbano vs. built property, same parish
- [ ] Step 3: Map price variation across neighboring parishes; screen for safety/quality-of-life
- [ ] Step 4: Search live listings on Idealista/Imovirtual/Supercasa matching budget
- [ ] Step 5: Verify legal subdivision limits for each candidate parcel
- [ ] Step 6: Build cost/revenue model with sensitivity cases
- [ ] Step 7: Deliver verdict with numbers, caveats, and recommended next action

Step 1 — Scope the question

"Viana do Castelo region" is too broad to price meaningfully. Narrow to the specific municipality (e.g., Caminha) and list its constituent parishes (freguesias) — e.g., Vila Praia de Âncora, Moledo, Vilar de Mouros, Seixas, Âncora. Price varies 2-3x between coastal/tourist parishes and inland rural ones.

Step 2 — Normalize price data

• Separate terreno urbano (zoned buildable, has PIP/loteamento potential) from terreno rústico (agricultural, cannot legally build without reclassification — a much harder, longer path).
• Compute €/m² for: (a) raw urban land, (b) built house + plot, in the same parish, same time window.
• Built-property €/m² usually looks lower per m² of total plot because the house adds value without proportionally adding land — but the relevant profitability metric is return per euro invested, not raw €/m². Compute both:
  • €/m² of land only
  • Total price ÷ (land m² + construction cost equivalent) to sanity-check whether buying-built is arbitraging construction cost.

Step 3 — Map regional variation + quality-of-life filter

Build a simple table:

Quality-of-life screen — exclude or flag areas with:

• High vacancy/abandoned building ratio
• Known industrial or heavy-transit corridors
• Isolated hamlets with declining population (check INE demographic trend — shrinking parishes often mean the "cheap land" is cheap because no one wants to live there, not because it's a hidden gem)

Step 4 — Find live listings

Search Idealista.pt, Imovirtual.pt, Supercasa.pt, filtered to the target parish, "terreno urbano," size range that supports 3-way subdivision (generally need 1,000+ m² total to yield three viable, legally-buildable lots after access roads/setbacks). For each listing capture: price, size, price/m², zoning classification (urbano/rústico/misto), listing age (stale listings = weak demand or overpriced).

Step 5 — Legal feasibility check (do this BEFORE financial modeling)

• Confirm the parcel's PDM (Plano Diretor Municipal) classification permits loteamento (subdivision into separate registered lots).
• Check minimum lot size ("área mínima de lote") set by the municipal câmara — this determines whether a given plot can actually yield 3 lots.
• Confirm whether subdivision requires a full "operação de loteamento" (slower, more expensive, more scrutiny) vs. simple destaque (faster, but Portugal restricted the destaque mechanism significantly in urban contexts — verify current rules with the câmara).
• If the parcel is rústico, budget for reclassification risk: can take years, is not guaranteed, and should be treated as a separate, higher-risk sub-scenario, not the base case.

Step 6 — Build the cost/revenue model

Run three cases: pessimistic (flat prices, permit delays), base (current market trend), optimistic (continued appreciation). State the holding-cost drag (IMI property tax annually, maintenance) across the 2-3 year window — this is often ignored and quietly erodes margin.

Step 7 — Verdict

State plainly: profitable or not, under which scenario, with the budget constraint (≤€100k) explicitly checked against total cost-to-completion, not just purchase price. Many buyers hit the ceiling once subdivision + utilities + tax are added to sticker price.

Example 1: Input: "Compare terreno urbano vs. built house in Caminha, budget €100k, want to subdivide into 3." Output:

• Terreno urbano avg (Caminha parish core): ~€80-120/m²; coastal parishes (Moledo, VP Âncora): ~€150-300/m²
• Built house + plot: often €900-1,400/m² total, but land component alone implied ~€100-180/m²
• Conclusion: buying-built is not more "profitable" for this strategy since you can't subdivide a house — raw urban land is the only viable path to the 3-way split goal. Built property comparison matters only if the goal were "cheapest way to a personal home," a separate question from subdivision profit.
• At €100k, realistic target: 1,500-2,500 m² urban plot in an inland-but-serviced parish (e.g., Vilar de Mouros), NOT coastal (too expensive per m² at this budget for 3 viable lots).

Example 2: Input: "Is a 2,000 m² rústico plot near the Spanish border for €40k a good deal for this strategy?" Output: Flag immediately — rústico classification means no legal building right until reclassified. At this price it may be cheap for a reason. Recommend against as base case; only pursue if buyer explicitly wants a long-horizon speculative reclassification bet, modeled separately with much lower probability of success and no fixed timeline.