Search Icon

Hunter Hayes

Professional Yacht Broker
hunterhayes@unitedyacht.com
843-605-7085

Born and raised in Charleston, SC, Hunter was very fortunate to have grown up in a boating family. He spent his childhood on the water, fishing and placing in offshore tournaments with his dad. As much as Hunter loved to fish, he loved boats even more, and never missed a boat show!

He has spent the past 8 years in South Florida, working on and captaining boats of all types. He offers an array of knowledge on all varieties of power boats, from center console to large sport yachts.

His character and enthusiasm for boating mean that customer service and attention to detail will always be there.

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 <p style="text-align: justify;">Born and raised in Charleston, SC, Hunter was very fortunate to have grown up in a boating family. He spent his childhood on the water, fishing and placing in offshore tournaments with his dad. As much as Hunter loved to fish, he loved boats even more, and never missed a boat show!</p> <p style="text-align: justify;">He has spent the past 8 years in South Florida, working on and captaining boats of all types. He offers an array of knowledge on all varieties of power boats, from center console to large sport yachts.</p> <p style="text-align: justify;">His character and enthusiasm for boating mean that customer service and attention to detail will always be there.</p> [empty string] 310 [empty string] [empty string] [empty string] https://www.unitedyacht.com/United-Yacht-Brokers/Hunter-Hayes/310 13 hunterhayes@unitedyacht.com 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] Professional Yacht Broker [empty string] [empty string] [empty string] Hunter Hunter Hayes Hayes, Hunter Hayes, Hunter (hunterhayes@unitedyacht.com) Hayes 2 United Yacht Sales Main Office 2 [empty string] 843-605-7085 [empty string] [empty string] 9D7C25D8-D1F6-AD60-75C4FF3C7A25198D [empty string] Hunter Hayes
CACHED false
EXECUTIONTIME 9
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 = 310 ORDER BY brokerID