SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='UB5 4PX' order by fulladdress
UB5 4PX - 627,000
- Freehold Semi-detached house
UB5 4PX - 585,000
- Freehold Semi-detached property
UB5 4PX - 562,000
- Freehold Semi-detached house
UB5 4PX - 596,000
- Freehold Semi-detached house
UB5 4PX - 338,000
- Feudal Converted flat
UB5 4PX - 276,000
- Leasehold Converted flat
UB5 4PX - 554,000
- Semi-detached house
UB5 4PX - 601,000
- Freehold Semi-detached house
UB5 4PX - 593,000
- Freehold Semi-detached house
UB5 4PX - 576,000
- Freehold Semi-detached house
UB5 4PX - 563,000
- Freehold Semi-detached house
UB5 4PX - 578,000
- Freehold Semi-detached house
UB5 4PX - 580,000
- Freehold Semi-detached house
UB5 4PX - 591,000
- Freehold Semi-detached house
UB5 4PX - 537,000
- Freehold Mid terrace house
UB5 4PX - 513,000
- Leasehold End terrace house
UB5 4PX - 582,000
- Freehold Semi-detached house
UB5 4PX - 574,000
- Freehold Semi-detached house
UB5 4PX - 602,000
- Freehold Semi-detached house
UB5 4PX - 616,000
- Freehold Semi-detached house
