Search Icon
photo of Frank Tuma, Professional Yacht Broker

Frank Tuma

Professional Yacht Broker
ftuma@unitedyacht.com
1-561-379-2590

query
RESULTSET
query
  BROKERBIO BROKERDIRECT800 BROKERID BROKERLEVELREF BROKERPASSHASH BROKERPASSWORD BROKERSEOURL BROKER_LOCATIONS EMAIL HIDEBROKER IYBABROKERID IYBA_BIOGRAPHY IYBA_BROKERTITLE IYBA_CELL IYBA_DISPLAYPICTURE IYBA_PHONE JOBTITLE LASTLOGGEDON LEVELNAME LEVELVALUE NAME_FIRST NAME_FULL1 NAME_FULL2 NAME_FULL3 NAME_LAST OFFICEID OFFICENAME OFFICEREF PHONENUMBER PHONE_MOBILE PHONE_WORK PRIORITY RANDOMSEED SPOTLIGHTVIDEO YW_MATCHNAME
1 [empty string] [empty string] 187 [empty string] 199BE8AD48DE8C0DDB948874CB4ED7E035C70809 teak123 https://www.unitedyacht.com/United-Yacht-Brokers/Frank-Tuma/187 13 ftuma@unitedyacht.com 0 80531 <p><br></p> Yacht Broker 1-561-379-2590 https://media.iyba.pro/biopic/8617c786c56c99e8419948ebf473dfd2.jpg 1-772-463-3131 Professional Yacht Broker [empty string] [empty string] [empty string] Frank Frank Tuma Tuma, Frank Tuma, Frank (ftuma@unitedyacht.com) Tuma 2 United Yacht Sales Main Office 2 [empty string] 1-561-379-2590 [empty string] [empty string] 2F79050B-DE71-BC2A-5FFF1DF1C753F071 [empty string] Frank Tuma
CACHED false
EXECUTIONTIME 59
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 = 187 ORDER BY brokerID