SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BN6 8RD' order by fulladdress
BN6 8RD - 549,000
- Freehold Semi-detached house
BN6 8RD - 519,000
- Freehold Semi-detached house
BN6 8RD - 552,000
- Freehold Semi-detached house
BN6 8RD - 524,000
- Freehold Semi-detached property
BN6 8RD - 546,000
- Semi-detached house
BN6 8RD - 653,000
- Freehold Semi-detached house
BN6 8RD - 579,000
- Freehold Semi-detached house
BN6 8RD - 968,000
- Freehold Detached house
BN6 8RD - 544,000
- Freehold Semi-detached house
BN6 8RD - 544,000
- Freehold Semi-detached house
BN6 8RD - 563,000
- Freehold Semi-detached house
BN6 8RD - 554,000
- Freehold Semi-detached house
BN6 8RD - 553,000
- Freehold Semi-detached house
BN6 8RD - 548,000
- Freehold Semi-detached house
BN6 8RD - 730,000
- Freehold Detached property
BN6 8RD - 548,000
- Freehold Semi-detached house
BN6 8RD - 608,000
- Freehold Detached house
BN6 8RD - 559,000
- Freehold Detached house
BN6 8RD - 575,000
- Freehold Semi-detached house
BN6 8RD - 576,000
- Freehold Semi-detached house
BN6 8RD - 553,000
- Freehold Semi-detached house
BN6 8RD - 555,000
- Freehold Semi-detached house
BN6 8RD - 690,000
- Freehold Detached house
BN6 8RD - 595,000
- Freehold Semi-detached house
BN6 8RD - 619,000
- Freehold Semi-detached house
BN6 8RD - 556,000
- Freehold Semi-detached house
BN6 8RD - 804,000
- Freehold Detached house
BN6 8RD - 799,000
- Freehold Detached house
BN6 8RD - 774,000
- Freehold Detached house
BN6 8RD - 735,000
- Freehold Detached property
BN6 8RD - 768,000
- Freehold Detached house
BN6 8RD - 764,000
- Freehold Detached house
BN6 8RD - 574,000
- Freehold Semi-detached house
BN6 8RD - 546,000
- Freehold Semi-detached house
BN6 8RD - 600,000
- Freehold Semi-detached property
BN6 8RD - 612,000
- Freehold Detached house