SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='YO19 5SH' order by fulladdress
YO19 5SH - 618,000
- Freehold Detached house
YO19 5SH - 461,000
- Freehold Detached house
YO19 5SH - 621,000
- Freehold Detached house
YO19 5SH - 623,000
- Freehold Detached property
YO19 5SH - 632,000
- Freehold Detached property
YO19 5SH - 551,000
- Freehold Detached house
YO19 5SH - 473,000
- Freehold Detached property
YO19 5SH - 575,000
- Freehold Detached house
YO19 5SH - 415,000
- Freehold Detached house
YO19 5SH - 530,000
- Freehold Detached house
YO19 5SH - 387,000
- Freehold Detached house
YO19 5SH - 634,000
- Freehold Detached property
YO19 5SH - 696,000
- Freehold Detached house
YO19 5SH - 628,000
- Freehold Detached house
YO19 5SH - 608,000
- Freehold Detached house
YO19 5SH - 630,000
- Freehold Detached property
YO19 5SH - 667,000
- Freehold Detached house
YO19 5SH - 615,000
- Freehold Detached house
YO19 5SH - 657,000
- Freehold Detached house
YO19 5SH - 575,000
- Freehold Detached house
YO19 5SH - 552,000
- Freehold Detached house
YO19 5SH - 695,000
- Freehold Detached house
YO19 5SH - 608,000
- Freehold Detached house
YO19 5SH - 230,000
- Freehold End terrace house
YO19 5SH - 228,000
- Freehold Terrace property
YO19 5SH - 234,000
- Freehold Mid terrace house
YO19 5SH - 226,000
- Freehold Mid terrace house
YO19 5SH - 226,000
- Freehold Terrace property
YO19 5SH - 236,000
- Freehold End terrace house
YO19 5SH - 517,000
- Freehold Detached property
YO19 5SH - 563,000
- Freehold Detached house
YO19 5SH - 592,000
- Freehold Detached house
YO19 5SH - 583,000
- Freehold Detached house
YO19 5SH - 644,000
- Freehold Detached house
YO19 5SH - 581,000
- Freehold Detached house
YO19 5SH - 595,000
- Freehold Detached property
YO19 5SH - 452,000
- Freehold Detached house
YO19 5SH - 230,000
- Freehold Terrace property
YO19 5SH - 228,000
- Freehold Terrace property
YO19 5SH - 227,000
- Freehold Terrace property
YO19 5SH - 226,000
- Freehold Mid terrace house
YO19 5SH - 652,000
- Freehold Detached house
YO19 5SH - 524,000
- Freehold Detached house
YO19 5SH - 573,000
- Freehold Detached house
YO19 5SH - 530,000
- Freehold Detached house
YO19 5SH - 403,000
- Freehold Detached house
YO19 5SH - 613,000
- Freehold Detached house
YO19 5SH - 643,000
- Freehold Detached house
YO19 5SH - 541,000
- Freehold Detached house
YO19 5SH - 643,000
- Freehold Detached house
YO19 5SH - 482,000
- Freehold Detached property
YO19 5SH - 235,000
- Freehold Terrace property
YO19 5SH - 550,000
- Freehold Detached house
YO19 5SH - 663,000
- Freehold Detached house
YO19 5SH - 892,000
- Freehold Semi-detached property