SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='IP4 2UB' order by fulladdress
IP4 2UB - 581,000
- Freehold Detached house
IP4 2UB - 679,000
- Freehold Detached property
IP4 2UB - 688,000
- Freehold Detached house
IP4 2UB - 652,000
- Freehold Detached house
IP4 2UB - 625,000
- Freehold Detached property
IP4 2UB - 697,000
- Freehold Detached house
IP4 2UB - 591,000
- Freehold Detached house
IP4 2UB - 750,000
- Freehold Detached property
IP4 2UB - 619,000
- Freehold Detached house
IP4 2UB - 723,000
- Freehold Detached property
IP4 2UB - 703,000
- Freehold Detached property
IP4 2UB - 614,000
- Freehold Detached house
IP4 2UB - 608,000
- Freehold Detached house
IP4 2UB - 755,000
- Freehold Detached property
IP4 2UB - 477,000
- Freehold Detached property
IP4 2UB - 548,000
- Freehold Detached house
IP4 2UB - 626,000
- Freehold Detached house
IP4 2UB - 717,000
- Freehold Detached house
IP4 2UB - 627,000
- Freehold Detached house
IP4 2UB - 643,000
- Freehold Detached property
IP4 2UB - 598,000
- Freehold Detached house
IP4 2UB - 651,000
- Freehold Detached property
IP4 2UB - 640,000
- Freehold Detached house
IP4 2UB - 621,000
- Freehold Detached house
IP4 2UB - 721,000
- Freehold Detached house
IP4 2UB - 648,000
- Freehold Detached property
IP4 2UB - 595,000
- Freehold Detached house
