SELECT * FROM cre_listings1 WHERE ID > 0 AND ( post_title REGEXP '[[:<:]]scion[[:>:]]') AND active = 1 ORDER BY user_listing DESC, FIELD(`location`, 'Miami, FL','Key West, FL','Orlando, FL','Fort Myers, FL','Tallahassee, FL','Space Coast, FL','Tampa, FL','Lakeland, FL','Treasure Coast, FL','Jacksonville, FL','Sarasota, FL','Pensacola, FL','Panama City, FL','Lake City, FL','Ocala, FL','Sebring, FL','Daytona Beach, FL','Brunswick, GA','Savannah, GA','Atlanta, GA','Columbus, GA','Valdosta, GA','Macon, GA','NW Georgia, GA','Augusta, GA','Albany, GA','Statesboro, GA','Athens, GA','Charleston, SC','Columbia, SC','Florence, SC','Greenville, SC','Hilton Head, SC','Myrtle Beach, SC','Asheville, NC','Charlotte, NC','Eastern, NC','Fayetteville, NC','Greensboro, NC','Hickory, NC','Jacksonville, NC','Outer Banks, NC','Raleigh, NC','Wilmington, NC','Winston-Salem, NC','Charlottesville, VA','Danville, VA','Eastern Shore, VA','Fredericksburg, VA','Norfolk, VA','Harrisonburg, VA','Lynchburg, VA','Blacksburg, VA','Richmond, VA','Roanoke, VA','Delaware, DE','Annapolis, MD','Baltimore, MD','Frederick, MD','South, MD','West, MD','Central, NJ','Jersey Shore, NJ','North Jersey, NJ','South Jersey, NJ','Altoona, PA','Erie, PA','Harrisbutg, PA','Lancaster, PA','Allentown, PA','Philapelphia, PA','Pittsburgh, PA','Poconos, PA','Reading, PA','Scranton, PA','Williamsport, PA','York, PA','Penn State , PA','Albany, NY','Binghamton, NY','Buffalo, NY','Chautauqua, NY','Elmira, NY','Finger Lakes, NY','Glensfalls, NY','Hudson Valley, NY','Ithaca, NY','Long Island, NY','New York, NY','Plattsburgh, NY','Potsdam, NY','Rochester, NY','Syracuse, NY','Utica, NY','Watertown, NY','New London, CT','Hartford, CT','New Haven, CT','North-West, CT','Washington, DC','Austin, TX','Dallas, TX','Houston, TX','San Antonio, TX','San Francisco, CA','Bakersfield, CA','Chico, CA','Fresno, CA','Gold Country, CA','Humboldt, CA','Inland Empire, CA','Los Angeles, CA','Merced, CA','Modesto, CA','Monterey Bay, CA','Orange County, CA','Palm Springs, CA','Redding, CA','Reno, CA','Sacramento, CA','San Diego, CA','S. Luis Obispo, CA','Santa Barbara, CA','Santa Maria, CA','Stockton, CA','Ventura, CA','Visalia, CA','Yuba, CA','Morgantown, WV','Auburn, AL','Birmingham, AL','Dothan, AL','Florence, AL','Gadsten, AL','Huntsville, AL','Mobile, AL','Montgomery, AL','Tuscaloosa, AL','Baton Rouge, LA','Central, LA','Houma, LA','Lafayette, LA','Lake Charles, LA','Monroe, LA','New Orleans, LA','Shreveport, LA')