SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SO51 7AE' order by fulladdress
SO51 7AE - 360,000
- Freehold Semi-detached house
SO51 7AE - 365,000
- Freehold Mid terrace house
SO51 7AE - 379,000
- Freehold Terrace property
SO51 7AE - 369,000
- Freehold Mid terrace house
SO51 7AE - 377,000
- Freehold Mid terrace house
SO51 7AE - 371,000
- Freehold Mid terrace house
SO51 7AE - 373,000
- Freehold Semi-detached house
SO51 7AE - 943,000
- Freehold Detached house
SO51 7AE - 633,000
- Freehold Detached house
SO51 7AE - 631,000
- Freehold Detached house
SO51 7AE - 362,000
- Freehold Semi-detached house
SO51 7AE - 629,000
- Freehold Detached house
SO51 7AE - 871,000
- Freehold Detached house
SO51 7AE - 932,000
- Freehold Detached house
SO51 7AE - 862,000
- Freehold Detached house
SO51 7AE - 931,000
- Freehold Detached house
SO51 7AE - 940,000
- Freehold Detached house
SO51 7AE - 614,000
- Freehold Detached house
SO51 7AE - 628,000
- Freehold Detached house
SO51 7AE - 626,000
- Freehold Detached house
SO51 7AE - 1,106,000
- Freehold Detached house
SO51 7AE - 354,000
- Freehold Semi-detached house
SO51 7AE - 1,059,000
- Freehold Detached house
SO51 7AE - 1,123,000
- Freehold Detached house
SO51 7AE - 359,000
- Freehold Semi-detached house
SO51 7AE - 336,000
- Freehold Semi-detached house
SO51 7AE - 333,000
- Freehold Semi-detached house
SO51 7AE - 384,000
- Freehold Semi-detached house
SO51 7AE - 375,000
- Freehold Mid terrace house
SO51 7AE - 370,000
- Freehold Mid terrace house