SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='CA13 9XZ' order by fulladdress
CA13 9XZ - 237,000
- Leasehold Flat/Maisonette
CA13 9XZ - 328,000
- Leasehold Detached house
CA13 9XZ - 230,000
- Leasehold Flat/Maisonette
CA13 9XZ - 234,000
- Leasehold Flat/Maisonette
CA13 9XZ - 226,000
- Leasehold Terrace property
CA13 9XZ - 250,000
- Leasehold Detached house
CA13 9XZ - 179,000
- Leasehold Flat/Maisonette
CA13 9XZ - 222,000
- Leasehold Mid terrace house
CA13 9XZ - 242,000
- Leasehold Detached house
CA13 9XZ - 291,000
- Leasehold Mid terrace house
CA13 9XZ - 222,000
- Leasehold End terrace bungalow
CA13 9XZ - 205,000
- Leasehold Flat/Maisonette
CA13 9XZ - 254,000
- Leasehold Terrace property
CA13 9XZ - 290,000
- Leasehold Semi-detached property
CA13 9XZ - 278,000
- Leasehold Terrace property
CA13 9XZ - 287,000
- Leasehold Detached bungalow
CA13 9XZ - 202,000
- Leasehold Semi-detached house
CA13 9XZ - 236,000
- Leasehold Flat/Maisonette
CA13 9XZ - 358,000
- Leasehold Semi-detached house
CA13 9XZ - 298,000
- Leasehold Terrace property
CA13 9XZ - 367,000
- Leasehold Terrace property
CA13 9XZ - 359,000
- Leasehold Terrace property
CA13 9XZ - 355,000
- Leasehold End terrace house
CA13 9XZ - 459,000
- Leasehold Semi-detached house
CA13 9XZ - 325,000
- Leasehold Terrace property
CA13 9XZ - 470,000
- Leasehold Semi-detached house
CA13 9XZ - 281,000
- Leasehold Terrace property
CA13 9XZ - 218,000
- Leasehold Flat/Maisonette
CA13 9XZ - 208,000
- Leasehold Flat/Maisonette
CA13 9XZ - 177,000
- Leasehold Flat/Maisonette
CA13 9XZ - 202,000
- Leasehold Flat/Maisonette
CA13 9XZ - 561,000
- Freehold Detached property
