SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='TQ6 9QP' order by fulladdress
TQ6 9QP - 2,483,000
- Leasehold Semi-detached house
TQ6 9QP - 1,125,000
- Leasehold Flat/Maisonette
TQ6 9QP - 1,590,000
- Leasehold Mid terrace house
TQ6 9QP - 1,029,000
- Leasehold Flat/Maisonette
TQ6 9QP - 1,041,000
- Leasehold Flat/Maisonette
TQ6 9QP - 957,000
- Leasehold Flat/Maisonette
TQ6 9QP - 1,036,000
- Leasehold Flat/Maisonette
TQ6 9QP - 1,028,000
- Leasehold Purpose built flat
TQ6 9QP - 1,102,000
- Leasehold Flat/Maisonette
TQ6 9QP - 917,000
- Leasehold Flat/Maisonette
TQ6 9QP - 1,081,000
- Leasehold Flat/Maisonette
TQ6 9QP - 1,090,000
- Leasehold Flat/Maisonette
TQ6 9QP - 1,125,000
- Leasehold Flat/Maisonette
TQ6 9QP - 1,282,000
- Leasehold Flat/Maisonette
TQ6 9QP - 1,081,000
- Leasehold Mid terrace house
TQ6 9QP - 1,238,000
- Leasehold Mid terrace house
TQ6 9QP - 1,223,000
- Leasehold Terrace property
TQ6 9QP - 1,443,000
- Leasehold Mid terrace house
TQ6 9QP - 1,416,000
- Leasehold Mid terrace house
TQ6 9QP - 943,000
- Leasehold Mid terrace house
TQ6 9QP - 988,000
- Leasehold Flat/Maisonette
TQ6 9QP - 1,244,000
- Leasehold Flat/Maisonette
TQ6 9QP - 0
- Leasehold Purpose built flat
TQ6 9QP - 1,305,000
- Leasehold Flat/Maisonette
TQ6 9QP - 959,000
- Leasehold Flat/Maisonette
TQ6 9QP - 1,126,000
- Leasehold Purpose built flat
TQ6 9QP - 822,000
- Leasehold Flat/Maisonette
TQ6 9QP - 1,022,000
- Leasehold End terrace house
TQ6 9QP - 826,000
- Leasehold Purpose built flat
TQ6 9QP - 750,000
- Leasehold Flat/Maisonette
TQ6 9QP - 610,000
- Leasehold Flat/Maisonette
TQ6 9QP - 915,000
- Leasehold Flat/Maisonette
TQ6 9QP - 510,000
- Leasehold Flat/Maisonette
TQ6 9QP - 650,000
- Leasehold Flat/Maisonette
TQ6 9QP - 1,090,000
- Leasehold Flat/Maisonette
TQ6 9QP - 932,000
- Leasehold Purpose built flat
TQ6 9QP - 1,214,000
- Leasehold Flat/Maisonette
TQ6 9QP - 1,187,000
- Leasehold Flat/Maisonette
TQ6 9QP - 1,017,000
- Leasehold Flat/Maisonette