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 |