SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='KT19 8FL' order by fulladdress
KT19 8FL - 672,000
- Freehold Detached house
KT19 8FL - 674,000
- Freehold Detached house
KT19 8FL - 674,000
- Freehold Semi-detached house
KT19 8FL - 775,000
- Freehold Terrace property
KT19 8FL - 654,000
- Freehold Semi-detached house
KT19 8FL - 793,000
- Freehold Mid terrace house
KT19 8FL - 813,000
- Freehold End terrace house
KT19 8FL - 799,000
- Freehold Mid terrace house
KT19 8FL - 805,000
- Freehold Mid terrace house
KT19 8FL - 783,000
- Freehold End terrace house
KT19 8FL - 819,000
- Freehold Mid terrace house
KT19 8FL - 972,000
- Freehold Detached house
KT19 8FL - 368,000
- Leasehold Purpose built flat
KT19 8FL - 805,000
- Freehold Terrace property
KT19 8FL - 1,100,000
- Freehold Detached house
KT19 8FL - 690,000
- Freehold Semi-detached house
KT19 8FL - 660,000
- Freehold Semi-detached house
KT19 8FL - 684,000
- Freehold Detached house
KT19 8FL - 631,000
- Freehold Detached house
KT19 8FL - 653,000
- Freehold Detached house
KT19 8FL - 951,000
- Freehold Semi-detached house
KT19 8FL - 670,000
- Freehold Detached house
KT19 8FL - 1,034,000
- Freehold Detached house
KT19 8FL - 928,000
- Freehold Detached house
KT19 8FL - 616,000
- Freehold Detached house
KT19 8FL - 833,000
- Freehold Detached house
KT19 8FL - 959,000
- Freehold Detached house
KT19 8FL - 861,000
- Freehold Detached house
KT19 8FL - 948,000
- Freehold Detached house
KT19 8FL - 1,023,000
- Freehold Detached house
KT19 8FL - 687,000
- Freehold Semi-detached house
KT19 8FL - 935,000
- Freehold Semi-detached house
KT19 8FL - 1,025,000
- Freehold Detached house
KT19 8FL - 813,000
- Freehold Detached house
KT19 8FL - 539,000
- Freehold End terrace house
KT19 8FL - 549,000
- Freehold Mid terrace house
KT19 8FL - 823,000
- Freehold Semi-detached house
KT19 8FL - 547,000
- Freehold Mid terrace house
KT19 8FL - 557,000
- Freehold End terrace house
KT19 8FL - 837,000
- Freehold Detached house
KT19 8FL - 649,000
- Freehold Semi-detached house
KT19 8FL - 1,081,000
- Freehold Detached house
KT19 8FL - 685,000
- Freehold Detached house