SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='KT15 1UX' order by fulladdress
KT15 1UX - 382,000
- Freehold End terrace house
KT15 1UX - 436,000
- Freehold Terrace property
KT15 1UX - 371,000
- Freehold Mid terrace house
KT15 1UX - 367,000
- Freehold Terrace property
KT15 1UX - 352,000
- Freehold Terrace property
KT15 1UX - 156,000
- Leasehold Flat/Maisonette
KT15 1UX - 174,000
- Leasehold Flat/Maisonette
KT15 1UX - 189,000
- Leasehold Purpose built flat
KT15 1UX - 154,000
- Leasehold Purpose built flat
KT15 1UX - 369,000
- Freehold Terrace property
KT15 1UX - 165,000
- Leasehold Flat/Maisonette
KT15 1UX - 154,000
- Leasehold Purpose built flat
KT15 1UX - 159,000
- Leasehold Purpose built flat
KT15 1UX - 159,000
- Leasehold Purpose built flat
KT15 1UX - 157,000
- Leasehold Purpose built flat
KT15 1UX - 380,000
- Freehold End terrace house
KT15 1UX - 384,000
- Freehold Mid terrace house
KT15 1UX - 354,000
- Freehold Terrace property
KT15 1UX - 388,000
- Freehold End terrace house
KT15 1UX - 378,000
- Freehold Mid terrace house
KT15 1UX - 381,000
- Freehold End terrace house
KT15 1UX - 375,000
- Freehold Terrace property
KT15 1UX - 369,000
- Freehold Mid terrace house
KT15 1UX - 168,000
- Leasehold Purpose built flat
KT15 1UX - 166,000
- Leasehold Purpose built flat
KT15 1UX - 163,000
- Leasehold Purpose built flat
KT15 1UX - 122,000
- Leasehold Purpose built flat
KT15 1UX - 160,000
- Leasehold Purpose built flat
KT15 1UX - 174,000
- Leasehold Purpose built flat
KT15 1UX - 367,000
- Freehold Mid terrace house
KT15 1UX - 160,000
- Leasehold Flat/Maisonette
KT15 1UX - 167,000
- Leasehold Flat/Maisonette
KT15 1UX - 159,000
- Leasehold Purpose built flat
KT15 1UX - 148,000
- Leasehold Flat/Maisonette
KT15 1UX - 146,000
- Leasehold Flat/Maisonette
KT15 1UX - 170,000
- Leasehold Purpose built flat
KT15 1UX - 386,000
- Freehold End terrace house
KT15 1UX - 389,000
- Freehold Mid terrace house
KT15 1UX - 378,000
- Freehold Mid terrace house
KT15 1UX - 375,000
- Freehold Mid terrace house
KT15 1UX - 327,000
- Freehold Terrace property
KT15 1UX - 311,000
- Freehold Mid terrace house
KT15 1UX - 314,000
- Freehold Mid terrace house
KT15 1UX - 316,000
- Freehold End terrace house
KT15 1UX - 315,000
- Freehold Mid terrace house
KT15 1UX - 379,000
- Freehold Terrace property
KT15 1UX - 381,000
- Freehold Mid terrace house
KT15 1UX - 379,000
- Freehold Mid terrace house
KT15 1UX - 364,000
- Freehold Terrace property
KT15 1UX - 399,000
- Freehold Mid terrace house
KT15 1UX - 251,000
- Freehold Mid terrace house
KT15 1UX - 360,000
- Freehold Semi-detached property
KT15 1UX - 395,000
- Freehold Mid terrace house
KT15 1UX - 378,000
- Freehold End terrace house
KT15 1UX - 305,000
- Freehold Terrace property
KT15 1UX - 310,000
- Freehold Mid terrace house
KT15 1UX - 169,000
- Leasehold Flat/Maisonette