922 property ads do not mean 922 different plots: how duplication affects pricing research

What the research shows

• Property Desk calculation: The existing import groups 922 captured advertisements into 687 normalized records, removing 235 repeated ad observations from property counts.

  [1]

• Property Desk calculation: 162 normalized records have more than one source advertisement; the largest group contains 8 ads.

  [1]

• Property Desk calculation: After source exceptions, area checks and the stated outlier rule, 627 normalized records contribute to this batch's headline price comparisons.

  [1]

Property Desk research context

Amaravati Property Desk analysed advertised asking prices captured on 27 August 2026. The figures describe that snapshot and are not completed-sale prices.

Count the property before you count the market

A listing website can show the same property in more than one advertisement. Different source entries can repeat an exact plot code while carrying different asking amounts or publication details. Counting each advertisement as new stock inflates the apparent number of properties represented in that channel.

The captured source has 922 advertisements but 687 normalized records. 162 records (23.6%) contain multiple ads. The 235 repeated observations represent 25.5% of the ad count. These are properties as grouped by the import's identity rule, not an independently verified register of current owners or sellers.

How much repetition is present?

• 525 normalized records have 1 source advertisement each.
• 117 normalized records have 2 source advertisements each.
• 27 normalized records have 3 source advertisements each.
• 13 normalized records have 4 source advertisements each.
• 3 normalized records have 5 source advertisements each.
• 1 normalized records have 7 source advertisements each.
• 1 normalized records have 8 source advertisements each.

The grouping follows the existing import's exact-code identity, with source exceptions retained for audit. It does not infer that two vaguely similar descriptions are the same property. That distinction avoids an undocumented merge that could hide separate properties or combine incompatible evidence.

The lowest advertised amount is a selection rule

For an exact-code group, the existing import retains the lowest positive advertised amount. This produces one asking amount for each normalized property and avoids giving a heavily advertised record more weight in the median. It also creates a selection effect: the resulting figures may sit below a calculation that weights every advertisement equally.

The lowest source amount is not an accepted offer, the current seller's confirmed quote or evidence of a discount negotiated by Property Desk. It can only be described as the lowest positive amount in that captured group. Present-day terms require a fresh quotation from someone with authority to sell.

More ads are not proof of more demand

Repetition alone does not tell us whether a property is popular, difficult to sell, being offered by several parties or simply being relisted. Those explanations need their own evidence. The dataset does not contain a verified buyer-enquiry or completed-transaction series, so ad count cannot be used as a liquidity metric.

What owners and buyers can do with this insight

• Owners can ask for one clear, authorized property description with consistent current terms.
• Buyers can compare the property identity and source dates before treating two ads as two options.
• A brokerage can retain the source history and show which quote is current after reconfirmation.
• Any conflicting area, use or authority claim should be resolved independently rather than hidden by the grouping.

The later exclusions that produce the 627-record pricing cohort are separate from deduplication. A source exception, unresolved area discrepancy or statistical outlier is not a duplicate merely because it is excluded from a median. The audit keeps those reasons distinct so the research can be reproduced.

The practical advantage is a cleaner conversation: one identifiable property, a stated asking amount and date, a record of what has been checked, and an explicit set of remaining questions. A larger raw ad count cannot substitute for those details.

How to read these figures

Unless a paragraph explicitly describes the original source or an excluded example, pricing and budget figures use 627 retained records: 400 residential and 227 commercial. We excluded 4 source exceptions, 14 unresolved area differences above 1% and 42 outliers using one-pass 1.5-IQR boundaries within advertised use on total ask, area and unit rate. Original records remain intact. Each retained property has equal weight; budget ceilings are inclusive; localities retain the source labels; group price medians require at least five records. Totals shown in Lacs and Cr are rounded to at most two decimals.

The import keeps the lowest positive advertised amount for each exact-code group. A median is the middle observation; the middle-half range runs from the 25th to 75th percentile. The figures describe this filtered, single-source capture. Current seller availability, authority, title, boundaries, approval and access require separate checks.