SELECT org_code,listg_off,list_num,country,state,county,sic_code,sba,sell_price,sell_down,main_sub,per_1_t_ob,per_1_sale,comments,featured,sold_date,more_info,clsng_date,accept_offers,e_visa FROM listings as l inner join bus_type as b on l.bus_t_numb = b.numb WHERE (ORG_CODE = 'BBF') AND (UPPER(COUNTRY) = 'USA' AND ( UPPER(STATE) = 'FLORIDA')) AND SELL_PRICE <= 999999999 AND (SELL_PRICE >= -999999999 OR SELL_PRICE = 0) AND SELL_DOWN <= 999999999 AND PER_1_T_OB >= -999999999 AND PER_1_T_OB <= 999999999 AND PER_1_SALE >= -999999999 AND PER_1_SALE <= 999999999 AND MULTIPLE = 'Y' AND L_EXP_DATE >= '10/26/2025' and e_visa = 'Y' ORDER BY main_sub, SELL_PRICE, SELL_DOWN
There are no listings that match your selected criteria