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 6WF' order by fulladdress
BN1 6WF - 1,264,000
- Freehold Detached house
BN1 6WF - 1,249,000
- Freehold Detached house
BN1 6WF - 1,253,000
- Freehold Detached property
BN1 6WF - 1,344,000
- Freehold Semi-detached house
BN1 6WF - 1,291,000
- Freehold Detached property
BN1 6WF - 1,253,000
- Freehold Detached house
BN1 6WF - 1,277,000
- Freehold Detached property
BN1 6WF - 1,289,000
- Freehold Detached house
BN1 6WF - 1,138,000
- Freehold Detached house
BN1 6WF - 1,344,000
- Freehold Detached house
BN1 6WF - 1,394,000
- Freehold Detached house
BN1 6WF - 1,358,000
- Freehold Detached house
BN1 6WF - 1,292,000
- Freehold Detached house
BN1 6WF - 1,125,000
- Freehold Detached house
BN1 6WF - 1,466,000
- Freehold Detached house
BN1 6WF - 1,357,000
- Freehold Detached house
BN1 6WF - 1,413,000
- Freehold Detached house
BN1 6WF - 1,255,000
- Freehold Detached house
BN1 6WF - 1,460,000
- Freehold Detached house
BN1 6WF - 929,000
- Freehold Detached bungalow
BN1 6WF - 1,361,000
- Freehold Detached property
BN1 6WF - 1,247,000
- Freehold Detached house
BN1 6WF - 1,403,000
- Freehold Detached house
BN1 6WF - 1,538,000
- Freehold Detached house
BN1 6WF - 1,067,000
- Freehold Detached house
BN1 6WF - 1,525,000
- Freehold Detached property