SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='YO26 8BE' order by fulladdress
YO26 8BE - 365,000
- Freehold Semi-detached house
YO26 8BE - 501,000
- Freehold Detached house
YO26 8BE - 505,000
- Freehold Detached house
YO26 8BE - 550,000
- Freehold Detached property
YO26 8BE - 494,000
- Freehold Detached house
YO26 8BE - 559,000
- Freehold Detached house
YO26 8BE - 372,000
- Freehold Semi-detached house
YO26 8BE - 499,000
- Freehold Detached house
YO26 8BE - 517,000
- Freehold Detached house
YO26 8BE - 427,000
- Freehold Semi-detached house
YO26 8BE - 558,000
- Freehold Detached house
YO26 8BE - 686,000
- Freehold Detached house
YO26 8BE - 512,000
- Freehold Detached house
YO26 8BE - 675,000
- Freehold Detached house
YO26 8BE - 555,000
- Freehold Detached house
YO26 8BE - 797,000
- Freehold Detached house
YO26 8BE - 510,000
- Freehold Detached property
YO26 8BE - 748,000
- Freehold Detached house
YO26 8BE - 490,000
- Freehold Detached house
YO26 8BE - 490,000
- Freehold Detached property
YO26 8BE - 668,000
- Freehold Detached house
YO26 8BE - 374,000
- Freehold Semi-detached house
YO26 8BE - 357,000
- Freehold Semi-detached house
YO26 8BE - 474,000
- Freehold Detached house
YO26 8BE - 724,000
- Freehold Detached house
YO26 8BE - 467,000
- Freehold Detached house
YO26 8BE - 388,000
- Freehold Semi-detached house
YO26 8BE - 311,000
- Freehold Semi-detached house
YO26 8BE - 304,000
- Freehold Semi-detached house
YO26 8BE - 309,000
- Freehold Semi-detached house
YO26 8BE - 585,000
- Freehold Detached property
YO26 8BE - 533,000
- Freehold Detached property
YO26 8BE - 352,000
- Freehold Semi-detached house
YO26 8BE - 326,000
- Freehold Semi-detached house
YO26 8BE - 561,000
- Freehold Detached property
YO26 8BE - 368,000
- Freehold Semi-detached house
YO26 8BE - 541,000
- Freehold Detached property
YO26 8BE - 555,000
- Freehold Detached house