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 6GB' order by fulladdress
BN1 6GB - 911,000
- Freehold Mid terrace house
BN1 6GB - 878,000
- Freehold Mid terrace house
BN1 6GB - 791,000
- Freehold Mid terrace house
BN1 6GB - 799,000
- Freehold Mid terrace house
BN1 6GB - 854,000
- Freehold Mid terrace house
BN1 6GB - 789,000
- Freehold Mid terrace house
BN1 6GB - 887,000
- Freehold End terrace house
BN1 6GB - 1,005,000
- Freehold Semi-detached property
BN1 6GB - 873,000
- Freehold End terrace house
BN1 6GB - 362,000
- Leasehold Flat/Maisonette
BN1 6GB - 804,000
- Freehold Mid terrace house
BN1 6GB - 841,000
- Freehold Mid terrace house
BN1 6GB - 837,000
- Freehold Mid terrace house
BN1 6GB - 812,000
- Freehold Mid terrace house
BN1 6GB - 803,000
- Freehold Mid terrace house
BN1 6GB - 346,000
- Leasehold Converted flat
BN1 6GB - 954,000
- Freehold Mid terrace house
BN1 6GB - 941,000
- Freehold Mid terrace house
BN1 6GB - 923,000
- Freehold Mid terrace house
BN1 6GB - 933,000
- Freehold Mid terrace house
BN1 6GB - 837,000
- Freehold Mid terrace house
BN1 6GB - 816,000
- Freehold Mid terrace house
BN1 6GB - 907,000
- Freehold Mid terrace house
BN1 6GB - 942,000
- Freehold Terrace property
BN1 6GB - 838,000
- Freehold Mid terrace house
BN1 6GB - 865,000
- Freehold Mid terrace house
BN1 6GB - 894,000
- Freehold Semi-detached house
BN1 6GB - 889,000
- Freehold Mid terrace house
BN1 6GB - 940,000
- Freehold Mid terrace house
BN1 6GB - 855,000
- Freehold Mid terrace house
BN1 6GB - 757,000
- Freehold Terrace property
BN1 6GB - 858,000
- Freehold Mid terrace house
BN1 6GB - 898,000
- Freehold Mid terrace house
BN1 6GB - 833,000
- Freehold Mid terrace house
BN1 6GB - 894,000
- Freehold Mid terrace house
BN1 6GB - 841,000
- Freehold Mid terrace house
BN1 6GB - 845,000
- Freehold Mid terrace house
BN1 6GB - 809,000
- Freehold Mid terrace house
BN1 6GB - 849,000
- Freehold Mid terrace house
BN1 6GB - 870,000
- Freehold Mid terrace house
BN1 6GB - 954,000
- Freehold Mid terrace house
BN1 6GB - 861,000
- Freehold Mid terrace house
BN1 6GB - 874,000
- Freehold Mid terrace house
BN1 6GB - 864,000
- Freehold Mid terrace house
BN1 6GB - 960,000
- Freehold Semi-detached house
BN1 6GB - 855,000
- Freehold Terrace property
BN1 6GB - 845,000
- Freehold Mid terrace house
