SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SA3 4HR' order by fulladdress
SA3 4HR - 425,000
- Freehold End terrace house
SA3 4HR - 347,000
- Freehold Semi-detached house
SA3 4HR - 320,000
- Freehold Detached property
SA3 4HR - 366,000
- Freehold Semi-detached property
SA3 4HR - 523,000
- Freehold Detached house
SA3 4HR - 610,000
- Freehold Detached house
SA3 4HR - 504,000
- Freehold Detached house
SA3 4HR - 575,000
- Freehold Detached property
SA3 4HR - 559,000
- Freehold Detached house
SA3 4HR - 216,000
- Freehold Semi-detached house
SA3 4HR - 424,000
- Freehold Semi-detached house
SA3 4HR - 626,000
- Freehold Detached house
SA3 4HR - 330,000
- Freehold Semi-detached house
SA3 4HR - 608,000
- Freehold Detached house
SA3 4HR - 605,000
- Freehold Detached property
SA3 4HR - 609,000
- Freehold Detached house
SA3 4HR - 601,000
- Freehold Detached house
SA3 4HR - 604,000
- Freehold Detached house
SA3 4HR - 568,000
- Freehold Detached house
SA3 4HR - 343,000
- Freehold Terrace property
SA3 4HR - 608,000
- Freehold Detached property
SA3 4HR - 668,000
- Freehold Detached property
SA3 4HR - 563,000
- Freehold Detached house
SA3 4HR - 588,000
- Freehold Detached house
SA3 4HR - 682,000
- Freehold Detached house
SA3 4HR - 636,000
- Freehold Detached house
SA3 4HR - 580,000
- Freehold Detached house
SA3 4HR - 641,000
- Freehold Detached property
SA3 4HR - 356,000
- Freehold Detached property
SA3 4HR - 366,000
- Freehold Semi-detached house
SA3 4HR - 345,000
- Freehold Terrace property
SA3 4HR - 356,000
- Freehold Semi-detached house
SA3 4HR - 358,000
- Freehold End terrace house