 |
SELECT res.resID,res.First,res.Last,res.Seller,res.Co_Name,res.Phone,res.Phone2,res.Counties,res.BenType,res.Featured
FROM res, Active_Listings
WHERE res.resID = Active_Listings.resID && Active_Listings.Active_Listings > '0' && Active_Listings.Active_Listings IS NOT NULL && res.GeoAreas LIKE '%40%' && (res.Seller = 'a' || res.Seller = 'b') && res.Active = '1' && (TO_DAYS(res.Advertising_Expires)-TO_DAYS(now())>= '0' OR res.Auto_Pay = '1')
ORDER BY res.Featured, res.Rating, RAND()
Business Brokers Serving
Southern California Other AreaBusinesses Opportunities In This Area
Franchises For Sale In This Area
Resources Serving This Area
Ron Hottes, Broker | Business Team | 310-539-8300 Show Current Listings
| More Info About Ron Hottes
| Aritcles Written By Ron Hottes Counties Served: Los Angeles-a County, Orange-b County, Riverside-a County, San Bernardino-a County
Sells These Types of Businesses: Auto Related, Liquor Stores, Markets, Restaurant Related, Manufacturing Related, Retail Related, Service Related, Wholesale/Distribution
|
Mel Jones, Broker | Paramount Restaurant Brokers, Inc. | 916-632-9003 Show Current Listings
Counties Served: El Dorado-b County, Nevada-b County, Placer-b County, Sacramento-b County, Sutter-b County, Yuba-b County
Sells These Types of Businesses: Restaurant Related
|
Chris Smith, Agent | Premier Laundry Systems | 626-307-0147 Show Current Listings
Counties Served: Imperial-b County, Los Angeles-b County, Mono-b County, Orange-b County, Riverside-b County, San Bernardino-b County, San Diego-b County
Sells These Types of Businesses:
|
John Willingham, Broker | Sunbelt Business Brokers | 661-323-2358 Show Current Listings
Counties Served: Kern-c County, Tulare-c County
Sells These Types of Businesses: Auto Related, Restaurant Related, Manufacturing Related, Retail Related, Service Related
|
Gene Kwon, Broker | Capital Realty & Investment Inc. | 213-272-4242, 213-247-9494 Show Current Listings
Counties Served: Los Angeles-c County, Orange-c County, Riverside-c County, San Bernardino-c County, San Diego-c County, Ventura-c County
Sells These Types of Businesses: Retail Related, Service Related
|
Mike Qutami, Agent | First Team Commercial | 951-301-5950 Show Current Listings
Counties Served: Imperial-d County, Mono-d County, Orange-d County, Riverside-d County, San Bernardino-d County, San Diego-d County
Sells These Types of Businesses: Auto Related, Liquor Stores, Markets, Restaurant Related, Retail Related, Service Related
|
Sean Linch, Agent | Buysell Inc. | 619-804-7979 Show Current Listings
Counties Served: San Diego-d County
Sells These Types of Businesses:
|
Jason Dang, Agent | Century 21 | 559-430-9215 Show Current Listings
Counties Served: Fresno-d County, Kern-d County, Kings-d County, Madera-d County, Merced-d County, San Joaquin-d County, Stanislaus-d County, Tulare-d County
Sells These Types of Businesses: Retail Related, Service Related
|
Chuck Rogers, Broker | Empire Business Solutions Of Bakersfield, Inc. | 661-377-1921, 661-809-6566 Show Current Listings
Counties Served: Kern-f County
Sells These Types of Businesses: Retail Related, Service Related
|
Anup Patel, Broker | Daisie Enterprises, Inc. | 714-520-1773 Show Current Listings
Counties Served: Los Angeles-f County, Orange-f County, Riverside-f County, San Bernardino-f County, San Diego-f County
Sells These Types of Businesses: Auto Related, Retail Related, Service Related
|
Ken Belsky, Agent | Car Wash Brokers | 562-280-0401 Show Current Listings
Counties Served: Imperial-f County, Los Angeles-f County, Orange-f County, Riverside-f County, San Bernardino-f County, San Diego-f County, Ventura-f County
Sells These Types of Businesses: Auto Related
|
Larry Gonzales, Broker | LG Brokers, LLC. | 909-388-1234 Show Current Listings
Counties Served: Los Angeles-f County, Orange-f County, Riverside-f County, San Bernardino-f County
Sells These Types of Businesses: Retail Related, Service Related
|
|
|
