SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CM17 9PU' order by fulladdress
CM17 9PU - 600,000
- Freehold Detached house
CM17 9PU - 749,000
- Freehold Detached house
CM17 9PU - 632,000
- Freehold Detached house
CM17 9PU - 636,000
- Freehold Detached house
CM17 9PU - 672,000
- Freehold Detached house
CM17 9PU - 714,000
- Freehold Detached house
CM17 9PU - 706,000
- Freehold Detached house
CM17 9PU - 690,000
- Freehold Detached property
CM17 9PU - 527,000
- Freehold Detached house
CM17 9PU - 628,000
- Freehold Detached house
CM17 9PU - 710,000
- Freehold Detached house
CM17 9PU - 718,000
- Freehold Detached house
CM17 9PU - 701,000
- Freehold Detached house
CM17 9PU - 636,000
- Freehold Detached house
CM17 9PU - 714,000
- Freehold Detached house
CM17 9PU - 559,000
- Freehold Detached house
CM17 9PU - 623,000
- Freehold Detached house
CM17 9PU - 700,000
- Freehold Detached house
CM17 9PU - 756,000
- Freehold Detached house
CM17 9PU - 666,000
- Freehold Detached house
CM17 9PU - 682,000
- Freehold Detached house
CM17 9PU - 570,000
- Freehold Detached house
CM17 9PU - 696,000
- Freehold Detached house
CM17 9PU - 656,000
- Freehold Detached house
CM17 9PU - 685,000
- Freehold Detached house
CM17 9PU - 817,000
- Freehold Detached house
CM17 9PU - 803,000
- Freehold Detached property
CM17 9PU - 767,000
- Freehold Detached property
CM17 9PU - 621,000
- Freehold Detached house
CM17 9PU - 595,000
- Freehold Detached house
CM17 9PU - 631,000
- Freehold Detached house
CM17 9PU - 584,000
- Freehold Detached house
CM17 9PU - 569,000
- Freehold Detached property
CM17 9PU - 611,000
- Freehold Detached house
CM17 9PU - 627,000
- Freehold Detached property
CM17 9PU - 582,000
- Freehold Detached house
CM17 9PU - 655,000
- Freehold Detached property
CM17 9PU - 560,000
- Freehold Detached house
CM17 9PU - 520,000
- Freehold Detached house
CM17 9PU - 511,000
- Freehold Detached house
CM17 9PU - 577,000
- Freehold Detached house
CM17 9PU - 672,000
- Freehold Detached house
CM17 9PU - 673,000
- Freehold Detached property
CM17 9PU - 567,000
- Freehold Detached house
CM17 9PU - 644,000
- Freehold Detached house
CM17 9PU - 586,000
- Freehold Detached house
CM17 9PU - 521,000
- Freehold Detached house
CM17 9PU - 559,000
- Freehold Detached house
CM17 9PU - 607,000
- Freehold Detached house
CM17 9PU - 733,000
- Freehold Detached house
CM17 9PU - 508,000
- Freehold Detached house
CM17 9PU - 502,000
- Freehold Detached house
CM17 9PU - 507,000
- Freehold Detached house
CM17 9PU - 589,000
- Freehold Detached property
CM17 9PU - 634,000
- Freehold Detached property
CM17 9PU - 532,000
- Freehold Detached house
CM17 9PU - 639,000
- Freehold Detached property
CM17 9PU - 688,000
- Freehold Detached house
CM17 9PU - 608,000
- Freehold Detached house
CM17 9PU - 684,000
- Freehold Detached house
CM17 9PU - 696,000
- Freehold Detached house
CM17 9PU - 679,000
- Freehold Detached house