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 = 'BBN' and listg_off = '1466') 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 ((ORG_CODE = 'BBN' AND LISTG_OFF = '1466' AND MULTIPLE = 'X') OR MULTIPLE = 'Y' OR UPPER(LIST_TYPE) = 'OPEN LISTING') AND L_EXP_DATE >= '10/31/2025' ORDER BY main_sub, SELL_PRICE, SELL_DOWN
There are no listings that match your selected criteria