SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CM16 6RE' order by fulladdress
CM16 6RE - 549,000
- Freehold Terrace property
CM16 6RE - 510,000
- Freehold Bungalow property
CM16 6RE - 499,000
- Freehold Mid terrace house
CM16 6RE - 532,000
- Freehold Semi-detached house
CM16 6RE - 479,000
- Freehold End terrace house
CM16 6RE - 534,000
- Freehold Mid terrace house
CM16 6RE - 515,000
- Freehold Mid terrace house
CM16 6RE - 516,000
- Freehold End terrace house
CM16 6RE - 592,000
- Freehold Bungalow property
CM16 6RE - 543,000
- Freehold Semi-detached property
CM16 6RE - 526,000
- Freehold Semi-detached bungalow
CM16 6RE - 679,000
- Freehold Semi-detached bungalow
CM16 6RE - 1,058,000
- Freehold Detached house
CM16 6RE - 875,000
- Freehold Semi-detached property
CM16 6RE - 1,104,000
- Freehold Detached house
CM16 6RE - 543,000
- Freehold Mid terrace house
CM16 6RE - 497,000
- Freehold Mid terrace house
CM16 6RE - 491,000
- Freehold Terrace property
CM16 6RE - 485,000
- Freehold Mid terrace house
CM16 6RE - 487,000
- Freehold Bungalow property
CM16 6RE - 492,000
- Freehold Mid terrace house
CM16 6RE - 500,000
- Freehold Mid terrace property
CM16 6RE - 647,000
- Freehold Semi-detached house
CM16 6RE - 589,000
- Freehold Semi-detached property
CM16 6RE - 658,000
- Freehold Semi-detached house
CM16 6RE - 849,000
- Freehold Detached property
CM16 6RE - 1,034,000
- Freehold Detached property
CM16 6RE - 577,000
- Freehold End terrace house
CM16 6RE - 669,000
- Freehold Semi-detached house
CM16 6RE - 1,285,000
- Freehold Detached house
CM16 6RE - 651,000
- Freehold Semi-detached house
