SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SP3 6GX' order by fulladdress
SP3 6GX - 581,000
- Freehold Detached house
SP3 6GX - 635,000
- Freehold Detached house
SP3 6GX - 636,000
- Freehold Detached house
SP3 6GX - 651,000
- Freehold Detached house
SP3 6GX - 663,000
- Freehold Detached house
SP3 6GX - 617,000
- Freehold Detached house
SP3 6GX - 656,000
- Freehold Detached house
SP3 6GX - 647,000
- Freehold Detached house
SP3 6GX - 423,000
- Freehold Semi-detached house
SP3 6GX - 642,000
- Freehold Detached house
SP3 6GX - 624,000
- Freehold Detached house
SP3 6GX - 614,000
- Freehold Detached house
SP3 6GX - 629,000
- Freehold Detached house
SP3 6GX - 534,000
- Freehold Detached house
SP3 6GX - 660,000
- Freehold Detached house
SP3 6GX - 665,000
- Freehold Detached house
SP3 6GX - 432,000
- Freehold Semi-detached house
SP3 6GX - 669,000
- Freehold Detached house
SP3 6GX - 638,000
- Freehold Detached house
SP3 6GX - 609,000
- Freehold Detached house
SP3 6GX - 637,000
- Freehold Detached house
SP3 6GX - 646,000
- Freehold Detached house
