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 3HA' order by fulladdress
BN1 3HA - 2,163,000
- Freehold End terrace house
BN1 3HA - 0
- Freehold Mid terrace house
BN1 3HA - 1,689,000
- Freehold Mid terrace house
BN1 3HA - 1,939,000
- Freehold Mid terrace house
BN1 3HA - 423,000
- Leasehold Converted flat
BN1 3HA - 400,000
- Leasehold Converted flat
BN1 3HA - 2,005,000
- Freehold Mid terrace house
BN1 3HA - 1,827,000
- Freehold Terraced
BN1 3HA - 1,848,000
- Freehold Mid terrace house
BN1 3HA - 1,513,000
- Freehold Mid terrace house
BN1 3HA - 1,831,000
- Freehold Mid terrace house
BN1 3HA - 1,811,000
- Freehold Mid terrace house
BN1 3HA - 1,589,000
- Freehold Terrace property
BN1 3HA - 1,811,000
- Freehold Terraced
BN1 3HA - 715,000
- Leasehold Flat/Maisonette
BN1 3HA - 404,000
- Leasehold Converted flat
BN1 3HA - 662,000
- Leasehold Converted flat
BN1 3HA - 1,408,000
- Freehold Terrace property
BN1 3HA - 1,767,000
- Freehold Terrace property
BN1 3HA - 470,000
- Leasehold Converted flat
BN1 3HA - 1,778,000
- Freehold Mid terrace property
BN1 3HA - 405,000
- Leasehold Flat/Maisonette
BN1 3HA - 476,000
- Leasehold Flat/Maisonette
BN1 3HA - 383,000
- Leasehold Converted flat
BN1 3HA - 556,000
- Leasehold Converted flat
BN1 3HA - 537,000
- Leasehold Flat/Maisonette
BN1 3HA - 722,000
- Leasehold Flat/Maisonette
BN1 3HA - 636,000
- Leasehold Converted flat
BN1 3HA - 841,000
- Freehold Semi-detached house
