SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BS20 7FG' order by fulladdress
BS20 7FG - 400,000
- Freehold Mid terrace house
BS20 7FG - 398,000
- Freehold End terrace house
BS20 7FG - 647,000
- Freehold Detached house
BS20 7FG - 455,000
- Freehold Semi-detached house
BS20 7FG - 443,000
- Freehold Detached house
BS20 7FG - 471,000
- Freehold Semi-detached house
BS20 7FG - 661,000
- Freehold Detached house
BS20 7FG - 552,000
- Freehold Detached house
BS20 7FG - 532,000
- Freehold Detached property
BS20 7FG - 546,000
- Freehold Semi-detached house
BS20 7FG - 579,000
- Freehold Semi-detached house
BS20 7FG - 734,000
- Freehold Detached house
BS20 7FG - 482,000
- Freehold Mid terrace house
BS20 7FG - 482,000
- Freehold Mid terrace house
BS20 7FG - 465,000
- Freehold End terrace house
BS20 7FG - 567,000
- Freehold Detached house
BS20 7FG - 558,000
- Freehold Semi-detached house
BS20 7FG - 550,000
- Freehold Semi-detached property
BS20 7FG - 534,000
- Freehold Mid terrace house
BS20 7FG - 487,000
- Freehold Terrace property
BS20 7FG - 540,000
- Freehold End terrace house
BS20 7FG - 582,000
- Freehold End terrace house
BS20 7FG - 533,000
- Freehold Mid terrace house
BS20 7FG - 583,000
- Freehold End terrace house
BS20 7FG - 537,000
- Freehold End terrace house
BS20 7FG - 521,000
- Freehold Mid terrace house
BS20 7FG - 576,000
- Freehold Semi-detached house
BS20 7FG - 498,000
- Freehold Detached property
BS20 7FG - 551,000
- Freehold End terrace house
BS20 7FG - 557,000
- Freehold Mid terrace house
BS20 7FG - 586,000
- Freehold Semi-detached house
BS20 7FG - 529,000
- Freehold End terrace house
BS20 7FG - 527,000
- Freehold Mid terrace house
BS20 7FG - 520,000
- Freehold Terrace property
BS20 7FG - 351,000
- Freehold Detached house
BS20 7FG - 555,000
- Freehold End terrace house
BS20 7FG - 501,000
- Freehold End terrace house
BS20 7FG - 539,000
- Freehold Detached property
BS20 7FG - 531,000
- Freehold Mid terrace house
BS20 7FG - 527,000
- Freehold Terrace property
BS20 7FG - 521,000
- Freehold Mid terrace house
BS20 7FG - 505,000
- Freehold Mid terrace house
BS20 7FG - 275,000
- Leasehold Purpose built flat
BS20 7FG - 286,000
- Leasehold Purpose built flat
BS20 7FG - 299,000
- Leasehold Flat/Maisonette
BS20 7FG - 481,000
- Freehold Semi-detached house
BS20 7FG - 460,000
- Freehold Semi-detached house
BS20 7FG - 510,000
- Freehold Semi-detached house
BS20 7FG - 477,000
- Freehold Semi-detached house
BS20 7FG - 452,000
- Freehold Detached house
BS20 7FG - 616,000
- Freehold Detached house
BS20 7FG - 417,000
- Freehold Semi-detached house
BS20 7FG - 377,000
- Freehold Mid terrace house
BS20 7FG - 401,000
- Freehold End terrace house
BS20 7FG - 400,000
- Freehold End terrace house