SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BD23 1QG' order by fulladdress
BD23 1QG - 507,000
- Freehold Detached property
BD23 1QG - 199,000
- Leasehold Flat/Maisonette
BD23 1QG - 813,000
- Freehold Detached house
BD23 1QG - 195,000
- Leasehold Flat/Maisonette
BD23 1QG - 219,000
- Leasehold Flat/Maisonette
BD23 1QG - 686,000
- Freehold Detached house
BD23 1QG - 201,000
- Leasehold Flat/Maisonette
BD23 1QG - 648,000
- Freehold Detached house
BD23 1QG - 212,000
- Leasehold Converted flat
BD23 1QG - 791,000
- Freehold Detached house
BD23 1QG - 422,000
- Freehold End terrace house
BD23 1QG - 429,000
- Freehold Semi-detached property
BD23 1QG - 687,000
- Freehold Detached property
BD23 1QG - 397,000
- Freehold Mid terrace house
BD23 1QG - 661,000
- Freehold Detached house
BD23 1QG - 323,000
- Freehold End terrace house
BD23 1QG - 615,000
- Freehold Detached house
BD23 1QG - 425,000
- Freehold End terrace house
BD23 1QG - 603,000
- Freehold Detached house
BD23 1QG - 415,000
- Freehold Semi-detached property
BD23 1QG - 597,000
- Freehold Detached house
BD23 1QG - 940,000
- Freehold Detached house
BD23 1QG - 410,000
- Freehold Mid terrace house
BD23 1QG - 624,000
- Freehold Detached property
BD23 1QG - 456,000
- Freehold Semi-detached property
BD23 1QG - 407,000
- Freehold Mid terrace house
BD23 1QG - 446,000
- Freehold Mid terrace house
BD23 1QG - 430,000
- Freehold Terrace property
BD23 1QG - 474,000
- Freehold Semi-detached property
BD23 1QG - 506,000
- Freehold Semi-detached house
BD23 1QG - 263,000
- Leasehold Converted flat
BD23 1QG - 705,000
- Freehold Detached house