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 6LN' order by fulladdress
BN2 6LN - 588,000
- Freehold Detached house
BN2 6LN - 468,000
- Freehold Semi-detached bungalow
BN2 6LN - 487,000
- Freehold Semi-detached property
BN2 6LN - 470,000
- Semi-detached bungalow
BN2 6LN - 388,000
- Leasehold Terrace property
BN2 6LN - 449,000
- Freehold Semi-detached house
BN2 6LN - 532,000
- Freehold Detached house
BN2 6LN - 449,000
- Semi-detached house
BN2 6LN - 554,000
- Freehold Detached house
BN2 6LN - 593,000
- Freehold Detached bungalow
BN2 6LN - 550,000
- Freehold Detached bungalow
BN2 6LN - 635,000
- Freehold Detached house
BN2 6LN - 491,000
- Freehold Detached bungalow
BN2 6LN - 595,000
- Freehold Detached house
BN2 6LN - 598,000
- Freehold Detached house
BN2 6LN - 583,000
- Freehold Detached house
BN2 6LN - 620,000
- Freehold Detached house
BN2 6LN - 527,000
- Freehold Detached bungalow
BN2 6LN - 465,000
- Freehold Semi-detached bungalow
BN2 6LN - 601,000
- Freehold Detached house
BN2 6LN - 491,000
- Freehold Semi-detached house
BN2 6LN - 510,000
- Freehold Detached property
BN2 6LN - 395,000
- Freehold Semi-detached house
BN2 6LN - 465,000
- Freehold Semi-detached bungalow
BN2 6LN - 428,000
- Freehold Bungalow property
BN2 6LN - 487,000
- Freehold Semi-detached bungalow
BN2 6LN - 493,000
- Freehold Semi-detached house
BN2 6LN - 492,000
- Freehold Semi-detached bungalow
BN2 6LN - 529,000
- Freehold Semi-detached bungalow
BN2 6LN - 479,000
- Freehold Semi-detached house
BN2 6LN - 449,000
- Freehold Bungalow property
BN2 6LN - 464,000
- Freehold Semi-detached property
BN2 6LN - 464,000
- Semi-detached bungalow
BN2 6LN - 425,000
- Semi-detached house
BN2 6LN - 401,000
- Freehold Mid terrace house
BN2 6LN - 484,000
- Freehold Semi-detached property
BN2 6LN - 410,000
- Freehold End terrace house
BN2 6LN - 422,000
- Freehold Semi-detached house
BN2 6LN - 624,000
- Freehold Detached bungalow
BN2 6LN - 446,000
- Freehold Semi-detached house
BN2 6LN - 442,000
- Semi-detached house
BN2 6LN - 531,000
- Semi-detached house
BN2 6LN - 511,000
- Semi-detached house
BN2 6LN - 638,000
- Freehold Detached house
BN2 6LN - 670,000
- Freehold Detached house
BN2 6LN - 659,000
- Freehold Detached house
BN2 6LN - 572,000
- Freehold Detached house