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 3FP' order by fulladdress
BN2 3FP - 352,000
- Leasehold Converted flat
BN2 3FP - 330,000
- Feudal Converted flat
BN2 3FP - 257,000
- Leasehold Purpose built flat
BN2 3FP - 260,000
- Freehold Flat/Maisonette
BN2 3FP - 630,000
- Freehold Mid terrace house
BN2 3FP - 771,000
- Freehold Terrace property
BN2 3FP - 992,000
- Freehold Detached house
BN2 3FP - 244,000
- Leasehold Converted flat
BN2 3FP - 678,000
- Freehold Mid terrace house
BN2 3FP - 550,000
- Freehold Terrace property
BN2 3FP - 626,000
- Freehold Mid terrace house
BN2 3FP - 381,000
- Freehold Flat/Maisonette
BN2 3FP - 381,000
- Share of freehold Flat/Maisonette
BN2 3FP - 335,000
- Leasehold Converted flat
BN2 3FP - 565,000
- Freehold Terrace property
BN2 3FP - 671,000
- Freehold Mid terrace house
BN2 3FP - 756,000
- Freehold Mid terrace house
BN2 3FP - 664,000
- Freehold Mid terrace house
BN2 3FP - 564,000
- Freehold Mid terrace house
BN2 3FP - 573,000
- Freehold Flat/Maisonette
BN2 3FP - 603,000
- Freehold Mid terrace house
BN2 3FP - 272,000
- Leasehold Converted flat
BN2 3FP - 624,000
- Freehold Terrace property
BN2 3FP - 562,000
- Freehold Mid terrace house
BN2 3FP - 396,000
- Freehold Flat/Maisonette
BN2 3FP - 291,000
- Leasehold Converted flat
BN2 3FP - 326,000
- Leasehold Converted flat
BN2 3FP - 274,000
- Leasehold Converted flat
