SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='IG7 4FH' order by fulladdress
IG7 4FH - 256,000
- Leasehold Purpose built flat
IG7 4FH - 555,000
- Freehold End terrace house
IG7 4FH - 454,000
- Freehold Mid terrace house
IG7 4FH - 482,000
- Freehold End terrace house
IG7 4FH - 314,000
- Leasehold Flat/Maisonette
IG7 4FH - 275,000
- Leasehold Purpose built flat
IG7 4FH - 683,000
- Freehold Semi-detached house
IG7 4FH - 693,000
- Freehold Semi-detached house
IG7 4FH - 551,000
- Freehold End terrace house
IG7 4FH - 468,000
- Freehold Mid terrace house
IG7 4FH - 468,000
- Freehold End terrace house
IG7 4FH - 479,000
- Freehold End terrace house
IG7 4FH - 473,000
- Freehold End terrace house
IG7 4FH - 473,000
- Freehold Mid terrace house
IG7 4FH - 566,000
- Freehold End terrace house
IG7 4FH - 838,000
- Freehold Detached house
IG7 4FH - 836,000
- Freehold Detached house
IG7 4FH - 267,000
- Leasehold Purpose built flat
IG7 4FH - 467,000
- Freehold End terrace house
IG7 4FH - 443,000
- Freehold Mid terrace house
IG7 4FH - 565,000
- Freehold End terrace house
IG7 4FH - 683,000
- Freehold Semi-detached house
IG7 4FH - 682,000
- Freehold Semi-detached house
IG7 4FH - 323,000
- Leasehold Purpose built flat
IG7 4FH - 847,000
- Freehold Detached house
IG7 4FH - 968,000
- Freehold Detached house
IG7 4FH - 1,000,000
- Freehold Detached house
IG7 4FH - 994,000
- Freehold Detached house
IG7 4FH - 1,047,000
- Freehold Detached house
IG7 4FH - 268,000
- Leasehold Purpose built flat
IG7 4FH - 588,000
- Freehold End terrace house
IG7 4FH - 534,000
- Freehold Mid terrace house
IG7 4FH - 461,000
- Freehold Mid terrace house
IG7 4FH - 594,000
- Freehold End terrace house
IG7 4FH - 310,000
- Leasehold Flat/Maisonette
IG7 4FH - 288,000
- Leasehold Flat/Maisonette
IG7 4FH - 332,000
- Leasehold Flat/Maisonette
IG7 4FH - 368,000
- Leasehold Flat/Maisonette
IG7 4FH - 371,000
- Leasehold Flat/Maisonette
IG7 4FH - 354,000
- Leasehold Flat/Maisonette
IG7 4FH - 364,000
- Leasehold Flat/Maisonette
IG7 4FH - 300,000
- Leasehold Purpose built flat
IG7 4FH - 357,000
- Leasehold Flat/Maisonette
IG7 4FH - 370,000
- Leasehold Purpose built flat
IG7 4FH - 297,000
- Leasehold Flat/Maisonette
IG7 4FH - 358,000
- Leasehold Flat/Maisonette
IG7 4FH - 375,000
- Leasehold Purpose built flat