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;">John Kellogg has been in and on the water all his life, brokering boats since 1983. In 2007 he sold French Bay Marina in Clayton, NY and moved with his wife Debra to their winter residence on Cat Island, Bahamas. While in the Bahamas he operated a deep sea ?shing business and piloted airplane sightseeing tours. This last spring John and Debra reestablished residency in Clayton, building a house and leasing a brokerage of?ce at R J Marine associates on Riverside Drive. John is a 100 ton Master Mariner on the Great Lakes and Inland Seas and member of the Clayton Yacht Club. “We af?liated with United to best serve the brokerage needs of upstate New York boaters. United Yacht affords sellers international exposure for their vessels and unparalleled brokerage expertise.”</p> |
[empty string] |
183 |
[empty string] |
FA82D5884A78BDF9FBBA8429308AA0534AB951B3 |
11Starlight! |
https://www.unitedyacht.com/United-Yacht-Brokers/John-Kellogg-Jr/183 |
13,39 |
jkellogg@unitedyacht.com |
0 |
80487 |
<p class="ql-align-justify">John Kellogg has been in and on the water all his life, brokering boats since 1983. In 2007 he sold French Bay Marina in Clayton, NY and moved with his wife Debra to their winter residence on Cat Island, Bahamas. While in the Bahamas he operated a deep sea ?shing business and piloted airplane sightseeing tours. This last spring John and Debra reestablished residency in Clayton, building a house and leasing a brokerage of?ce at R J Marine associates on Riverside Drive. John is a 100 ton Master Mariner on the Great Lakes and Inland Seas and member of the Clayton Yacht Club. “We af?liated with United to best serve the brokerage needs of upstate New York boaters. United Yacht affords sellers international exposure for their vessels and unparalleled brokerage expertise.”</p> |
[empty string] |
1-315-921-8221 |
https://media.iyba.pro/biopic/3cb7e52ae62a9137f482dc7668d351fa.png |
1-772-463-3131 |
Professional Yacht Broker |
[empty string] |
[empty string] |
[empty string] |
John |
John Kellogg, Jr. |
Kellogg, Jr., John |
Kellogg, Jr., John (jkellogg@unitedyacht.com) |
Kellogg, Jr. |
5 |
United Yacht Sales | Spencer Christopher Division |
5 |
[empty string] |
315-921-8221 |
[empty string] |
[empty string] |
B6953F24-C17D-3BFC-F1B0B0309F9E2891 |
[empty string] |
John Kellogg |
|
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 = 183
ORDER BY brokerID |