SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='KT3 3ED' order by fulladdress
KT3 3ED - 659,000
- Freehold Terrace property
KT3 3ED - 686,000
- Freehold Terrace property
KT3 3ED - 876,000
- Freehold Semi-detached house
KT3 3ED - 840,000
- Freehold Semi-detached house
KT3 3ED - 640,000
- Freehold Mid terrace house
KT3 3ED - 780,000
- Freehold Semi-detached house
KT3 3ED - 665,000
- Freehold Mid terrace house
KT3 3ED - 685,000
- Freehold End terrace house
KT3 3ED - 702,000
- Freehold End terrace house
KT3 3ED - 707,000
- Freehold Terrace property
KT3 3ED - 654,000
- Semi-detached house
KT3 3ED - 702,000
- Freehold End terrace house
KT3 3ED - 718,000
- Freehold End terrace house
KT3 3ED - 761,000
- Freehold Semi-detached house
KT3 3ED - 705,000
- Freehold Mid terrace house
KT3 3ED - 838,000
- Freehold End terrace house
KT3 3ED - 696,000
- Freehold Mid terrace house
KT3 3ED - 809,000
- Freehold Semi-detached house
KT3 3ED - 741,000
- Freehold Mid terrace house
KT3 3ED - 690,000
- Freehold End terrace house
KT3 3ED - 670,000
- Freehold Semi-detached house
KT3 3ED - 796,000
- Freehold Semi-detached house
