SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='B46 3EF' order by fulladdress
B46 3EF - 556,000
- Freehold Detached house
B46 3EF - 664,000
- Freehold Detached property
B46 3EF - 565,000
- Freehold Detached house
B46 3EF - 654,000
- Freehold Detached house
B46 3EF - 590,000
- Freehold Detached house
B46 3EF - 705,000
- Freehold Detached property
B46 3EF - 599,000
- Freehold Detached house
B46 3EF - 660,000
- Freehold Detached house
B46 3EF - 629,000
- Freehold Detached house
B46 3EF - 621,000
- Freehold Detached house
B46 3EF - 623,000
- Freehold Detached house
B46 3EF - 625,000
- Freehold Detached house
B46 3EF - 726,000
- Freehold Detached house
B46 3EF - 678,000
- Freehold Detached house
B46 3EF - 721,000
- Freehold Detached property
B46 3EF - 702,000
- Freehold Detached property
B46 3EF - 639,000
- Freehold Detached house
B46 3EF - 628,000
- Freehold Detached house
B46 3EF - 606,000
- Freehold Detached house
B46 3EF - 661,000
- Freehold Detached house
B46 3EF - 634,000
- Freehold Detached house
B46 3EF - 702,000
- Freehold Detached house
B46 3EF - 749,000
- Freehold Detached property
B46 3EF - 276,000
- Freehold Semi-detached house
B46 3EF - 630,000
- Freehold Detached house
B46 3EF - 282,000
- Freehold Mid terrace house
B46 3EF - 617,000
- Freehold Detached property
B46 3EF - 286,000
- Freehold End terrace house
B46 3EF - 660,000
- Freehold Detached property
B46 3EF - 302,000
- Freehold Terrace property
B46 3EF - 619,000
- Freehold Detached house
B46 3EF - 620,000
- Freehold Detached house
B46 3EF - 281,000
- Freehold Terrace property
B46 3EF - 781,000
- Freehold Detached house
B46 3EF - 287,000
- Freehold Mid terrace house
B46 3EF - 281,000
- Freehold End terrace house
B46 3EF - 643,000
- Freehold Detached property
B46 3EF - 264,000
- Freehold Semi-detached house
B46 3EF - 645,000
- Freehold Detached property
B46 3EF - 270,000
- Freehold Semi-detached house
B46 3EF - 601,000
- Freehold Detached property
B46 3EF - 272,000
- Freehold Semi-detached house
B46 3EF - 649,000
- Freehold Detached property
B46 3EF - 279,000
- Freehold Semi-detached house
B46 3EF - 685,000
- Freehold Detached property
B46 3EF - 282,000
- Freehold End terrace house
B46 3EF - 696,000
- Freehold Detached house
B46 3EF - 315,000
- Freehold Mid terrace house
B46 3EF - 312,000
- Freehold Mid terrace house
B46 3EF - 623,000
- Freehold Detached house
B46 3EF - 357,000
- Freehold Mid terrace house
B46 3EF - 365,000
- Freehold Semi-detached property
B46 3EF - 326,000
- Freehold End terrace house
B46 3EF - 338,000
- Freehold Mid terrace house
B46 3EF - 339,000
- Freehold Mid terrace house
B46 3EF - 619,000
- Freehold Detached house
B46 3EF - 342,000
- Freehold Mid terrace house
B46 3EF - 272,000
- Freehold End terrace house
B46 3EF - 362,000
- Freehold Semi-detached house
B46 3EF - 353,000
- Freehold Semi-detached house
B46 3EF - 348,000
- Freehold End terrace house
B46 3EF - 575,000
- Freehold Detached property
B46 3EF - 344,000
- Freehold Mid terrace house
B46 3EF - 328,000
- Freehold End terrace house
B46 3EF - 650,000
- Freehold Detached house
