SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BN27 3TJ' order by fulladdress
BN27 3TJ - 318,000
- Freehold Semi-detached bungalow
BN27 3TJ - 396,000
- Freehold Detached property
BN27 3TJ - 336,000
- Freehold Semi-detached bungalow
BN27 3TJ - 332,000
- Freehold Semi-detached house
BN27 3TJ - 346,000
- Freehold Semi-detached house
BN27 3TJ - 335,000
- Freehold Semi-detached house
BN27 3TJ - 326,000
- Freehold Semi-detached house
BN27 3TJ - 354,000
- Freehold Detached house
BN27 3TJ - 359,000
- Freehold Semi-detached house
BN27 3TJ - 314,000
- Freehold Semi-detached house
BN27 3TJ - 347,000
- Freehold Detached property
BN27 3TJ - 317,000
- Freehold Semi-detached house
BN27 3TJ - 377,000
- Freehold Detached property
BN27 3TJ - 409,000
- Freehold Detached house
BN27 3TJ - 456,000
- Freehold Detached property
BN27 3TJ - 369,000
- Freehold Detached house
BN27 3TJ - 422,000
- Freehold Detached house
BN27 3TJ - 429,000
- Freehold Detached house
BN27 3TJ - 354,000
- Freehold Detached house
BN27 3TJ - 418,000
- Freehold Detached house
BN27 3TJ - 346,000
- Freehold Detached house
BN27 3TJ - 371,000
- Freehold Detached house
BN27 3TJ - 375,000
- Freehold Detached house
BN27 3TJ - 361,000
- Freehold Detached house
BN27 3TJ - 367,000
- Freehold Detached house
BN27 3TJ - 356,000
- Freehold Detached house
BN27 3TJ - 362,000
- Freehold Detached house
BN27 3TJ - 440,000
- Freehold Detached property
BN27 3TJ - 415,000
- Freehold Detached house