SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BN1 5GB' order by fulladdress
BN1 5GB - 603,000
- Freehold Semi-detached house
BN1 5GB - 590,000
- Freehold Semi-detached house
BN1 5GB - 775,000
- Freehold Detached house
BN1 5GB - 641,000
- Freehold Semi-detached house
BN1 5GB - 681,000
- Freehold Semi-detached house
BN1 5GB - 595,000
- Freehold Semi-detached house
BN1 5GB - 665,000
- Freehold Detached house
BN1 5GB - 696,000
- Freehold Semi-detached house
BN1 5GB - 736,000
- Freehold Detached house
BN1 5GB - 647,000
- Freehold Detached house
BN1 5GB - 659,000
- Freehold Detached house
BN1 5GB - 723,000
- Semi-detached house
BN1 5GB - 528,000
- Freehold Detached property
BN1 5GB - 684,000
- Freehold Semi-detached house
BN1 5GB - 569,000
- Freehold Detached house
BN1 5GB - 608,000
- Freehold Semi-detached house
BN1 5GB - 717,000
- Freehold Semi-detached house
BN1 5GB - 622,000
- Freehold Semi-detached house
BN1 5GB - 704,000
- Freehold Semi-detached house
BN1 5GB - 650,000
- Freehold Semi-detached house
BN1 5GB - 594,000
- Freehold Semi-detached house
BN1 5GB - 701,000
- Freehold Semi-detached house
BN1 5GB - 663,000
- Freehold Semi-detached bungalow
BN1 5GB - 692,000
- Freehold Semi-detached house
BN1 5GB - 652,000
- Freehold Semi-detached house
BN1 5GB - 681,000
- Freehold Semi-detached house
BN1 5GB - 605,000
- Freehold Semi-detached house
BN1 5GB - 698,000
- Freehold Semi-detached house
BN1 5GB - 633,000
- Freehold Semi-detached house
BN1 5GB - 675,000
- Freehold Semi-detached house
BN1 5GB - 627,000
- Freehold Semi-detached house
BN1 5GB - 623,000
- Freehold Semi-detached house
BN1 5GB - 564,000
- Freehold Semi-detached property
BN1 5GB - 587,000
- Freehold Semi-detached house
BN1 5GB - 606,000
- Freehold Detached house
BN1 5GB - 645,000
- Freehold Detached house
BN1 5GB - 758,000
- Freehold Detached property
BN1 5GB - 591,000
- Freehold Semi-detached house
BN1 5GB - 656,000
- Freehold Detached house
BN1 5GB - 620,000
- Freehold Bungalow property
BN1 5GB - 645,000
- Freehold Semi-detached bungalow
BN1 5GB - 619,000
- Freehold Semi-detached house
BN1 5GB - 787,000
- Freehold Detached house