my $struct = $sth->fetchall_hashref('extracted_ads_id');

# $struct will look like
{  foo => { extracted_ads_id => foo,  prop_street_no => 12, prop_street_name => 'blah' }
   bar => { extracted_ads_id => bar, .....
}

# access like $struct->{foo}->{prop_street_no}