SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW6 3TB' order by fulladdress
SW6 3TB - 3,242,000
- Freehold End terrace house
SW6 3TB - 2,485,000
- Freehold Mid terrace house
SW6 3TB - 2,174,000
- Freehold Mid terrace house
SW6 3TB - 2,924,000
- Freehold Mid terrace house
SW6 3TB - 3,119,000
- Freehold Mid terrace house
SW6 3TB - 3,012,000
- Mid terrace property
SW6 3TB - 2,833,000
- Freehold Mid terrace house
SW6 3TB - 3,047,000
- Freehold Mid terrace house
SW6 3TB - 2,840,000
- Freehold Terraced
SW6 3TB - 3,014,000
- Freehold Mid terrace house
SW6 3TB - 2,949,000
- Freehold Mid terrace house
SW6 3TB - 3,215,000
- Freehold Mid terrace house
SW6 3TB - 3,274,000
- Freehold Mid terrace house
SW6 3TB - 3,176,000
- Freehold Mid terrace house
SW6 3TB - 3,855,000
- Freehold Mid terrace house
SW6 3TB - 3,382,000
- Freehold Terraced
SW6 3TB - 2,642,000
- Freehold Terraced
SW6 3TB - 2,999,000
- Freehold Mid terrace house
SW6 3TB - 2,837,000
- Freehold Mid terrace house
SW6 3TB - 3,459,000
- Freehold Mid terrace house
SW6 3TB - 3,224,000
- Freehold Terrace property
SW6 3TB - 3,726,000
- Freehold Mid terrace house
SW6 3TB - 3,163,000
- Freehold Mid terrace house
SW6 3TB - 3,840,000
- Freehold Mid terrace house
SW6 3TB - 3,042,000
- Mid terrace house
SW6 3TB - 3,474,000
- Freehold Mid terrace house
