SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SA4 4GA' order by fulladdress
SA4 4GA - 199,000
- Leasehold Semi-detached house
SA4 4GA - 261,000
- Freehold Semi-detached house
SA4 4GA - 207,000
- Leasehold Semi-detached property
SA4 4GA - 209,000
- Freehold Semi-detached house
SA4 4GA - 205,000
- Freehold Semi-detached bungalow
SA4 4GA - 283,000
- Freehold Semi-detached house
SA4 4GA - 253,000
- Freehold Detached house
SA4 4GA - 284,000
- Freehold Detached house
SA4 4GA - 378,000
- Freehold Detached house
SA4 4GA - 301,000
- Freehold Detached house
SA4 4GA - 820,000
- Freehold Detached house
SA4 4GA - 203,000
- Freehold End terrace house
SA4 4GA - 203,000
- Freehold Semi-detached house
SA4 4GA - 187,000
- Freehold Mid terrace house
SA4 4GA - 322,000
- Freehold Detached house
SA4 4GA - 196,000
- Freehold Semi-detached house
SA4 4GA - 204,000
- Freehold Mid terrace house
SA4 4GA - 203,000
- Freehold Semi-detached house
SA4 4GA - 209,000
- Freehold End terrace house
SA4 4GA - 418,000
- Freehold Detached house
SA4 4GA - 498,000
- Freehold Detached house
SA4 4GA - 184,000
- Leasehold Semi-detached property
SA4 4GA - 367,000
- Freehold Detached house
SA4 4GA - 196,000
- Semi-detached house
SA4 4GA - 194,000
- Freehold Semi-detached house
SA4 4GA - 271,000
- Freehold Detached house
SA4 4GA - 242,000
- Freehold Detached house
SA4 4GA - 183,000
- Semi-detached house
SA4 4GA - 199,000
- Freehold Semi-detached house
SA4 4GA - 306,000
- Freehold Detached house
SA4 4GA - 268,000
- Freehold Detached house
SA4 4GA - 308,000
- Freehold Detached house
SA4 4GA - 303,000
- Freehold Detached house
SA4 4GA - 228,000
- Leasehold Semi-detached house
SA4 4GA - 253,000
- Freehold Detached house
SA4 4GA - 219,000
- Freehold Semi-detached property
SA4 4GA - 160,000
- Freehold Semi-detached property
SA4 4GA - 224,000
- Leasehold Semi-detached property