SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='B91 3YE' order by fulladdress
B91 3YE - 521,000
- Freehold Detached house
B91 3YE - 554,000
- Freehold Detached property
B91 3YE - 625,000
- Freehold Detached house
B91 3YE - 529,000
- Freehold Detached house
B91 3YE - 665,000
- Freehold Detached house
B91 3YE - 659,000
- Leasehold Detached house
B91 3YE - 807,000
- Freehold Detached house
B91 3YE - 542,000
- Freehold Detached house
B91 3YE - 833,000
- Freehold Detached house
B91 3YE - 774,000
- Freehold Detached house
B91 3YE - 827,000
- Freehold Detached house
B91 3YE - 779,000
- Freehold Detached house
B91 3YE - 864,000
- Freehold Detached house
B91 3YE - 828,000
- Freehold Detached house
B91 3YE - 860,000
- Freehold Detached house
B91 3YE - 804,000
- Freehold Detached house
B91 3YE - 680,000
- Freehold Detached house
B91 3YE - 564,000
- Freehold Detached house
B91 3YE - 540,000
- Freehold Detached house
B91 3YE - 785,000
- Freehold Detached house
B91 3YE - 557,000
- Freehold Detached house
B91 3YE - 861,000
- Freehold Detached house
B91 3YE - 669,000
- Freehold Detached house
B91 3YE - 683,000
- Freehold Detached house
B91 3YE - 598,000
- Freehold Detached property
B91 3YE - 809,000
- Freehold Detached house
B91 3YE - 528,000
- Freehold Detached house
B91 3YE - 779,000
- Freehold Detached house
B91 3YE - 607,000
- Freehold Detached house
B91 3YE - 657,000
- Freehold Detached property
B91 3YE - 566,000
- Leasehold Detached house
B91 3YE - 717,000
- Freehold Detached house
B91 3YE - 634,000
- Freehold Detached house
B91 3YE - 691,000
- Freehold Detached house
B91 3YE - 606,000
- Freehold Detached house
B91 3YE - 605,000
- Freehold Detached house
B91 3YE - 584,000
- Freehold Detached house
B91 3YE - 622,000
- Freehold Detached house
B91 3YE - 665,000
- Freehold Detached house
B91 3YE - 681,000
- Freehold Detached house
B91 3YE - 648,000
- Freehold Detached house
B91 3YE - 684,000
- Freehold Detached house
B91 3YE - 678,000
- Leasehold Detached property
B91 3YE - 615,000
- Freehold Detached property
B91 3YE - 603,000
- Freehold Detached property
B91 3YE - 598,000
- Freehold Detached property
B91 3YE - 593,000
- Freehold Detached house
B91 3YE - 530,000
- Freehold Detached house
B91 3YE - 621,000
- Freehold Detached house