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 (UPPER(COUNTRY) = 'USA') 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 featured = 'Y' union all 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 SOLDS as l inner join bus_type as b on l.bus_t_numb = b.numb WHERE featured = 'Y' AND SOLD_DATE > GETDATE() - 5060 ORDER BY main_sub, SELL_PRICE, SELL_DOWN
Click on the Listing Number to see more details
Click on column headings to sort
ascending
descending
Animals/Pets
Listing Number
Location
Category Detail
Price
Down
Disc Earn
Sales
BBN-1083-23185
Sold
Dallas, Texas USA
*Lender Pre-Qualified*
*May Qualify For Visa*
*Five-Star Business*
Pet Grooming
300,000
30,000
99,399
350,458
Educational/School
Listing Number
Location
Category Detail
Price
Down
Disc Earn
Sales
BBN-1083-23151
Sold
Withheld, Arkansas USA
*Lender Pre-Qualified*
*Five-Star Business*
Trade/Vocational School
2,300,000
250,000
568,101
1,195,395
Medical Related Biz
Listing Number
Location
Category Detail
Price
Down
Disc Earn
Sales
BBN-1856-03043
Sold
Withheld, Kentucky USA
*Five-Star Business*
Medical Equipment
995,000
200,000
371,755
1,023,357
Click on the Listing Number to see more details
Displaying Listings(s) 1 to 3 of 3 Total Listing(s)