SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BN2 1HF' order by fulladdress
BN2 1HF - 210,000
- Freehold Flat/Maisonette
BN2 1HF - 781,000
- Freehold Mid terrace house
BN2 1HF - 834,000
- Freehold Mid terrace house
BN2 1HF - 786,000
- Freehold Mid terrace house
BN2 1HF - 440,000
- Freehold Converted flat
BN2 1HF - 325,000
- Leasehold Converted flat
BN2 1HF - 653,000
- Freehold End terrace house
BN2 1HF - 636,000
- Freehold Terrace property
BN2 1HF - 589,000
- Freehold Mid terrace house
BN2 1HF - 633,000
- Freehold Mid terrace house
BN2 1HF - 322,000
- Freehold Converted flat
BN2 1HF - 710,000
- Freehold Terrace property
BN2 1HF - 636,000
- Freehold Mid terrace house
BN2 1HF - 701,000
- Freehold Mid terrace house
BN2 1HF - 675,000
- Freehold Mid terrace house
BN2 1HF - 478,000
- Freehold Flat/Maisonette
BN2 1HF - 632,000
- Freehold Mid terrace house
BN2 1HF - 642,000
- Freehold Mid terrace house
BN2 1HF - 638,000
- Freehold Mid terrace house
BN2 1HF - 623,000
- Freehold Mid terrace house
BN2 1HF - 873,000
- Freehold End terrace house
BN2 1HF - 853,000
- Freehold Mid terrace house
BN2 1HF - 856,000
- Freehold End terrace house
BN2 1HF - 1,119,000
- Freehold Semi-detached house
BN2 1HF - 1,243,000
- Freehold Mid terrace house
BN2 1HF - 993,000
- Freehold Mid terrace house
BN2 1HF - 742,000
- Freehold Terrace property
