SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='L34 0JQ' order by fulladdress
L34 0JQ - 353,000
- Freehold Detached house
L34 0JQ - 446,000
- Freehold Detached house
L34 0JQ - 441,000
- Freehold Detached house
L34 0JQ - 478,000
- Freehold Detached house
L34 0JQ - 497,000
- Freehold Detached house
L34 0JQ - 634,000
- Freehold Detached house
L34 0JQ - 446,000
- Freehold Detached house
L34 0JQ - 458,000
- Freehold Detached house
L34 0JQ - 344,000
- Freehold Detached house
L34 0JQ - 418,000
- Freehold Detached property
L34 0JQ - 485,000
- Freehold Detached house
L34 0JQ - 455,000
- Freehold Detached house
L34 0JQ - 407,000
- Freehold Detached house
L34 0JQ - 494,000
- Freehold Detached house
L34 0JQ - 485,000
- Freehold Detached property
L34 0JQ - 506,000
- Freehold Detached house
L34 0JQ - 440,000
- Freehold Detached house
L34 0JQ - 359,000
- Freehold Detached house
L34 0JQ - 370,000
- Freehold Detached house
L34 0JQ - 299,000
- Freehold Bungalow property
L34 0JQ - 398,000
- Freehold Detached house
L34 0JQ - 412,000
- Freehold Detached house
L34 0JQ - 414,000
- Freehold Detached house
L34 0JQ - 342,000
- Freehold Detached house
L34 0JQ - 432,000
- Freehold Detached house
L34 0JQ - 481,000
- Freehold Detached house
