I personally have filled many roles from deckhand to captain as well as a broker to yacht owner. Finally ending up as owner and CEO of Lima Yacht Sales, LLC division of United Yacht Sales. My goal is to assemble the finest, most knowledgeable brokers to assist our respected clients. Please contact myself or any of the Lima Yacht Sales Division brokers for a consultation for a purchase of a new or used vessel. Ask for a free evaluation of your yacht to be put on the market.
|SQL||SELECT brokers.brokerID, brokers.officeREF, brokers.hideBroker, brokers.priority, brokers.name_last, brokers.name_first, brokers.name_first + ' ' + brokers.name_last AS name_full1, brokers.name_last + ', ' + brokers.name_first AS name_full2, brokers.name_last + ', ' + brokers.name_first + ' (' + brokers.email + ')' AS name_full3, brokers.jobTitle, brokers.phone_work, brokers.phone_mobile, brokers.email, brokers.brokerPassword, brokers.brokerPassHash, brokers.phoneNumber, brokers.brokerBio, brokers.brokerSEOURL, brokers.brokerDirect800, brokers.spotlightVideo, brokers.randomSeed, brokers.broker_locations, brokers.brokerLevelREF, brokers.lastLoggedOn, brokers.yw_matchname, brokers.iybaBrokerID, brokers.iyba_Biography, brokers.iyba_BrokerTitle, brokers.iyba_Cell, brokers.iyba_DisplayPicture, brokers.iyba_Phone, broker_level.levelValue, broker_level.levelName, userOffices.officeID, userOffices.officeName FROM brokers LEFT JOIN broker_level ON brokers.brokerLevelREF = broker_level.levelID LEFT JOIN userOffices ON brokers.officeREF = userOffices.officeID WHERE brokerID = 69 ORDER BY brokerID|