Spotting Overpriced and Underpriced...

A listing can sit above or below a comparable asking-price range for many reasons: condition, urgency, document risk, dues, duplication, wrong area conversion, or simply bad data. A price gap is a question signal, not proof of a bargain or overcharge.

After this lesson, you can create a triage flag from a clean comparable set and produce a verification checklist before anyone acts on the gap.

Establish a Comparable Reference

Use the sheet from Lesson 3.1. Keep only rows that match the exact market cell and remove known duplicates. Calculate the median asking price per normalized area.

Then compute:

subject_asking_per_area = subject_asking_price / subject_normalized_area
gap_percent = (subject_asking_per_area - comparable_median) /
              comparable_median × 100

Positive means above the sample median; negative means below. Choose review bands before seeing the subject result, such as “within band,” “review,” and “high-priority verification.” The band is an internal triage rule, not a universal market standard.

The misconception is that below median means underpriced. It may mean the area, property type, document state, condition, location, or listing itself is wrong.

Diagnose the Gap in Four Buckets

Data quality

Wrong unit, lakh/crore conversion, duplicate, missing digit, stale status, or misleading covered/plot area.

Property difference

Floor, lift, age, renovation, orientation, road width, parking, view, occupancy, condition, access, and permanent defects.

Transaction/document difference

Possession, lease/title/allotment state, dues, transfer restrictions, litigation/encumbrance questions, tenancy, payment schedule, or seller authority.

Seller/listing context

Asking strategy, urgency claim, bundle/part share, incomplete media, or a bait listing. These remain hypotheses until verified.

AI can generate the question list:

Given SUBJECT, COMPARABLE SUMMARY, and GAP, classify possible explanations
into data quality, property difference, document/transaction difference, and
seller/listing context. Use only supplied facts for statements. Phrase every
unsupported explanation as a question to verify. Do not call the property a
bargain, overpriced, fraudulent, or investment opportunity.

Use a Triage Card

subject_id | observed_at | asking_price | source_area/unit |
normalized_basis | asking_per_area | comp_count | comp_median |
gap_percent | triage_band | known_differences | data_checks |
document_checks | physical_checks | seller_questions | decision_owner

Require a minimum comparable count and disclose it. When the sample is too thin or heterogeneous, set triage_band = insufficient evidence.

Worked Example

Sample only: a Lahore plot is advertised at PKR 18,000,000. Verified source area is 5 marla using a documented 225 sq ft basis for this sample, so normalized area is 5 × 225 = 1,125 sq ft. Subject asking per area is 18,000,000 / 1,125 = 16,000 PKR/sq ft.

The clean comparable median is a hypothetical 20,000 PKR/sq ft from six current asking records.

gap = (16,000 - 20,000) / 20,000 × 100
    = -4,000 / 20,000 × 100
    = -20%

The card flags high-priority verification under the team’s prewritten sample rule. Investigation finds the listing says “5 marla” but the exact plot dimensions and possession state are absent. The output is: 20% below selected asking sample; area and possession not established. It is not called a 20% bargain.

A second check finds two comparables were duplicates. Removing one changes the median. The sheet preserves both versions and explains the correction.

Failure Cases to Diagnose

Gap is calculated from total prices across different sizes: normalize with a documented basis.
The comparable median includes duplicates: clean identity before statistics.
A fixed threshold is called a market rule: label it internal triage logic.
Below-range becomes bargain language: convert hypotheses into verification questions.
Above-range ignores renovation or commercial frontage: record material differences before judgment.
Thin sample still receives a flag: use insufficient evidence.
AI alleges fraud: reserve legal/fraud conclusions for evidence and appropriate authorities.

🇵🇰 Pakistan Angle

Files, possession plots, constructed houses, leased property, cooperative-society records, and authority-approved schemes can carry very different transaction risks. A low asking price may reflect dues, transfer limits, litigation, tenancy, access, or a document type that was incorrectly grouped. Route each question to the relevant society, authority, land record, physical inspection, and qualified professional.

Scam pressure often uses WhatsApp urgency, token-payment demands, or a copied listing. Do not transfer money because a spreadsheet shows a negative gap. Verify the person’s authority, property, documents, payment process, and receipt through safe independent channels. Never send CNIC or banking evidence into an AI chat for “verification.”

Hands-On Exercise

Choose one labelled sample subject and at least six cleaned comparables.
Define your internal review bands before calculating the gap.
Compute subject price per area, median, and gap manually and in a sheet.
Fill all four diagnostic buckets as facts or questions.
Remove one duplicate or bad unit and recalculate to observe sensitivity.
Write a triage conclusion that never uses bargain, overpriced, or fraud language without evidence.

Done means: the flag is reproducible, changes when bad data is removed, and leads to a bounded verification plan rather than a purchase recommendation.

Completion Rubric

Exact market cell, conversion basis, and clean comparable count are recorded.
Median and gap formulas have been manually checked.
Triage bands were defined before seeing the result and labelled internal.
Data, property, document, and seller-context explanations are separated.
Insufficient or heterogeneous samples stop the classification.
Output makes no bargain, fraud, valuation, or return promise.

Sources

Key takeaway: a price gap is a reproducible triage signal that should trigger data, property, document, and seller checks—not a verdict about value.

Spotting Overpriced and Underpriced Listings Fast

Turn this lesson into one checked practice output