Search Icon
photo of Lima Yacht Division,

Lima Yacht Division


john-limayachts@unitedyacht.com

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.

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>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&nbsp;the Lima Yacht Sales Division&nbsp;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.</p> [empty string] 247 [empty string] [empty string] [empty string] https://www.unitedyacht.com/United-Yacht-Brokers/Lima-Yacht-Division/247 13 john-limayachts@unitedyacht.com 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] Lima Lima Yacht Division Yacht Division, Lima Yacht Division, Lima (john-limayachts@unitedyacht.com) Yacht Division 25 United Yacht Sales | Lima Yacht Division 25 [empty string] [empty string] 1-561-445-0078 [empty string] 2D493506-D415-E1A0-6CD516E5D00CD456 [empty string] Lima Yacht Division
CACHED false
EXECUTIONTIME 71
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 = 247 ORDER BY brokerID

Lima Yacht Division'S LISTINGS

photo of 87' President 870 Tri Deck LRC 2020

Loretta

87' President 870 Tri Deck LRC 2020

Stuart, Florida, United States

photo of 38' Riva 38 Rivamare 2021

38' Riva 38 Rivamare 2021

Rogers, Arkansas, United States