Commercial Real Estate Sold on The Outer Banks

<% county = "Dare" temp = "select * from retsproperty where (type= 'Commercial' or type= 'Multi Unit' or type= 'Retail' or type= 'Restaurant' or type= 'Condominium' or type= 'Gas Station' or type= 'Industrial' or type= 'Shopping Center' or type= 'Muti Family 5+ Units' or type= 'Other' or type= 'Warehouse' or type= 'Office' or type= 'Hotel / Motel') and county='Dare' and StatusCat= 'sold'" ShowRetsSoldListings %>

<% city = "Corolla" temp = "select * from retsproperty where (type= 'Commercial' or type= 'Multi Unit' or type= 'Retail' or type= 'Restaurant' or type= 'Condominium' or type= 'Gas Station' or type= 'Industrial' or type= 'Shopping Center' or type= 'Muti Family 5+ Units' or type= 'Other' or type= 'Warehouse' or type= 'Office' or type= 'Hotel / Motel') and city='" & city & "' and StatusCat= 'sold'" ShowRetsSoldListings %>