SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW15 2RG' order by fulladdress
SW15 2RG - 1,609,000
- Freehold Mid terrace house
SW15 2RG - 1,518,000
- Freehold Mid terrace house
SW15 2RG - 1,634,000
- Freehold Mid terrace house
SW15 2RG - 1,680,000
- Freehold Terrace property
SW15 2RG - 1,476,000
- Freehold Mid terrace house
SW15 2RG - 1,537,000
- Freehold Mid terrace house
SW15 2RG - 1,472,000
- Freehold Mid terrace house
SW15 2RG - 1,553,000
- Freehold Mid terrace house
SW15 2RG - 807,000
- Leasehold Purpose built flat
SW15 2RG - 702,000
- Leasehold Purpose built flat
SW15 2RG - 1,516,000
- Freehold Mid terrace house
SW15 2RG - 665,000
- Leasehold Converted flat
SW15 2RG - 941,000
- Freehold Purpose built flat
SW15 2RG - 1,446,000
- Freehold Mid terrace house
SW15 2RG - 648,000
- Leasehold Converted flat
SW15 2RG - 1,533,000
- Freehold Mid terrace house
SW15 2RG - 1,372,000
- Freehold Terrace property
SW15 2RG - 1,575,000
- Freehold Mid terrace house
SW15 2RG - 690,000
- Leasehold Converted flat
SW15 2RG - 1,439,000
- Freehold Detached house
SW15 2RG - 1,310,000
- Freehold Terrace property
SW15 2RG - 1,600,000
- Freehold Mid terrace house
SW15 2RG - 1,409,000
- Freehold Mid terrace house
SW15 2RG - 1,411,000
- Freehold Mid terrace house
SW15 2RG - 1,357,000
- Freehold Mid terrace house
SW15 2RG - 1,350,000
- Freehold Mid terrace house
SW15 2RG - 1,306,000
- Freehold Terrace property
SW15 2RG - 1,353,000
- Freehold Mid terrace house
SW15 2RG - 1,433,000
- Freehold Mid terrace house
SW15 2RG - 1,587,000
- Freehold Mid terrace house
SW15 2RG - 1,446,000
- Freehold Mid terrace house
SW15 2RG - 1,626,000
- Freehold Mid terrace house
SW15 2RG - 1,492,000
- Freehold Mid terrace house
SW15 2RG - 1,386,000
- Freehold Mid terrace house
SW15 2RG - 631,000
- Leasehold Converted flat
SW15 2RG - 648,000
- Leasehold Converted flat
