SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='UB3 2FH' order by fulladdress
UB3 2FH - 330,000
- Feudal Purpose built flat
UB3 2FH - 311,000
- Leasehold Purpose built flat
UB3 2FH - 327,000
- Leasehold Purpose built flat
UB3 2FH - 285,000
- Leasehold Flat/Maisonette
UB3 2FH - 325,000
- Leasehold Purpose built flat
UB3 2FH - 327,000
- Leasehold Purpose built flat
UB3 2FH - 326,000
- Leasehold Purpose built flat
UB3 2FH - 327,000
- Leasehold Purpose built flat
UB3 2FH - 328,000
- Leasehold Flat/Maisonette
UB3 2FH - 300,000
- Leasehold Flat/Maisonette
UB3 2FH - 336,000
- Leasehold Flat/Maisonette
UB3 2FH - 333,000
- Leasehold Purpose built flat
UB3 2FH - 314,000
- Leasehold Purpose built flat
UB3 2FH - 332,000
- Leasehold Purpose built flat
UB3 2FH - 275,000
- Leasehold Flat/Maisonette
UB3 2FH - 266,000
- Leasehold Purpose built flat
UB3 2FH - 315,000
- Leasehold Flat/Maisonette
UB3 2FH - 324,000
- Leasehold Flat/Maisonette
UB3 2FH - 313,000
- Leasehold Purpose built flat
UB3 2FH - 317,000
- Leasehold Purpose built flat
UB3 2FH - 309,000
- Leasehold Flat/Maisonette
UB3 2FH - 300,000
- Leasehold Flat/Maisonette
UB3 2FH - 274,000
- Leasehold Flat/Maisonette
UB3 2FH - 340,000
- Leasehold Purpose built flat
UB3 2FH - 327,000
- Leasehold Purpose built flat
UB3 2FH - 313,000
- Leasehold Flat/Maisonette
UB3 2FH - 328,000
- Leasehold Purpose built flat
UB3 2FH - 320,000
- Leasehold Flat/Maisonette
UB3 2FH - 328,000
- Leasehold Purpose built flat
UB3 2FH - 333,000
- Leasehold Purpose built flat
UB3 2FH - 332,000
- Leasehold Purpose built flat
UB3 2FH - 270,000
- Leasehold Flat/Maisonette
UB3 2FH - 268,000
- Leasehold Flat/Maisonette
UB3 2FH - 314,000
- Leasehold Flat/Maisonette
UB3 2FH - 323,000
- Leasehold Purpose built flat
UB3 2FH - 330,000
- Leasehold Flat/Maisonette
UB3 2FH - 333,000
- Feudal Purpose built flat
UB3 2FH - 264,000
- Leasehold Flat/Maisonette
UB3 2FH - 279,000
- Leasehold Flat/Maisonette
UB3 2FH - 263,000
- Leasehold Flat/Maisonette
UB3 2FH - 270,000
- Leasehold Purpose built flat
UB3 2FH - 315,000
- Leasehold Purpose built flat
UB3 2FH - 313,000
- Leasehold Purpose built flat
UB3 2FH - 333,000
- Leasehold Flat/Maisonette
UB3 2FH - 335,000
- Leasehold Purpose built flat
UB3 2FH - 314,000
- Leasehold Purpose built flat
UB3 2FH - 568,000
- Freehold Mid terrace house
UB3 2FH - 336,000
- Leasehold Purpose built flat
UB3 2FH - 273,000
- Leasehold Purpose built flat
UB3 2FH - 337,000
- Leasehold Flat/Maisonette
UB3 2FH - 265,000
- Leasehold Flat/Maisonette
UB3 2FH - 306,000
- Leasehold Purpose built flat
UB3 2FH - 314,000
- Leasehold Flat/Maisonette
UB3 2FH - 249,000
- Leasehold Purpose built flat
UB3 2FH - 302,000
- Leasehold Flat/Maisonette
UB3 2FH - 281,000
- Leasehold Flat/Maisonette
UB3 2FH - 270,000
- Leasehold Flat/Maisonette
UB3 2FH - 311,000
- Leasehold Flat/Maisonette
UB3 2FH - 331,000
- Leasehold Flat/Maisonette