| query | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RESULTSET |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| CACHED | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| EXECUTIONTIME | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 = 311 ORDER BY brokerID | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
- Used Yachts
- New Yachts
- Buying & Selling
- Our Team
- Charter
- Yachting
Search All Yachts
Pavel Kovylyaev
Professional Yacht Broker
pavelkov@unitedyacht.com
786-488-5290
Pavel Kovylyaev'S LISTINGS
Carmen Fontana
140' Custom Marine Industrial Technologies 140 1992
Athens, Greece
My Dream
138' Custom LZ-140 2009
Batumi, Georgia
105' Hatteras Raised Pilothouse 2022
Cape May, New Jersey, United States
Stella Maris
105' Broward 105 1993
La Paz, Mexico
CynderElla
101' Hargrave Custom Raised Pilothouse 2010
Palm Beach Gardens, Florida, United States
Fortuna
100' Palmer Johnson Motor Yacht 1999
Fort Lauderdale, Florida, United States
Marazul
98' Poole Chaffee Raised Pilothouse 1986
Acapulco, Mexico
94' PerMare Amer 94 Twin 2021
Sanremo, Italy
Silky
92' Sea Force IX Sportfish 2010
North Palm Beach, Florida, United States
90' Hatteras M90 Panacera 2022
Cape May, New Jersey, United States
Loretta
87' President 870 Tri Deck LRC 2020
Stuart, Florida, United States
Freedom
86' Burger Raised Pilothouse 1979
New Bern, North Carolina, United States
Silky
85' Jim Smith Convertible Sportfish 2006
Palm Beach, Florida, United States
Hemera Cuarta
82' Astondoa 82 GLX 2006
Ibiza, Spain
Soul Mates
82' Sunseeker Predator 82 2006
Pompano Beach, Florida, United States
El Chupacabra
80' Merritt 80 Custom Sportfish Yacht 2006
Pompano Beach, Florida, United States
Elena Queen of Arts
79' Custom AC Mcleod Sternwheeler House Barge 1982
Haverstraw, New York, United States
Ocho Uno 81
78' Fairline Squadron 2014
La Paz, Mexico
Prime Time
76' Palmer Johnson 76 EB Sportfisherman 1993
Stuart, Florida, United States
75' Hatteras Motor Yacht Sport Deck 2003
Stuart, Florida, United States
March Inn
75' Sumerset 75 Luxury Houseboat 2002
Charlestown, Massachusetts, United States
75' Hatteras M75 Panacera 2022
Cape May, New Jersey, United States
Lucky
75' Sunseeker 75 Motor Yacht 2004
Acapulco, Mexico
Elizabeth Ruth
74' Custom Robinson Modified Monk 1991
Poulsbo, Washington, United States
La Belva
74' Sunseeker Manhattan 2003
La Paz, Mexico
BOATOX
70' Hatteras Enclosed Bridge 2000
Key Largo, Florida, United States
70' Hatteras GT 70 2022
Cape May, New Jersey, United States
Lupo
70' Azimut 70 2011
Miami, Florida, United States
CHOPIN
68' Pershing 62 HT 2007
Pompano Beach, Florida, United States
68' Dyna Yachts 68 Skylounge 2021
Stuart, Florida, United States
Lauren Kristy
65' Custom East Bay Boat Works Paddle Wheeler 1987
Oakdale, New York, United States
Think's Its His
65' Sea Ray L650 Fly 2016
Miami, Florida, United States
64' Custom Carolina 64 Sportfish 2008
Biloxi, Mississippi, United States
Lady Caradoc
64' Horizon Elegance 64 1999
Stuart, Florida, United States
Good Fellows
63' Prestige 620 2013
Miami, Florida, United States
Hull 15
63' Dyna Yachts 63 Flybridge 2022
Miami, Florida, United States
HULL 16
63' Dyna Yachts 63 Flybridge 2022
Miami, Florida, United States
62' Ferretti Yachts 620 2003
Miami, Florida, United States
AMORE
62' Angel Pilothouse 1985
Fort Myers, Florida, United States
KAHUNA
61' Buddy Davis 61 Convertible 1987
Cabo San Lucas, Mexico
60' Hatteras 60 Yacht Fish 1970
Stuart, Florida, United States
Knot 2 Bad
60' Princess 60 2014
Vero Beach, Florida, United States
Chimera
60' Hinckley Custom 60 1997
Stuart, Florida, United States
Sirius
60' Trumpy Flush Deck Cruiser 1964
Cheboygan, Michigan, United States
Chesapeake
60' Trumpy Houseboat 1957
Beaufort, North Carolina, United States
60' Hatteras M60 2022
Cape May, New Jersey, United States
Mango Moon
60' Hatteras 60 Convertible 2000
Coral Gables, Florida, United States
Take It Deep
60' Hatteras 60 Convertible 2006
Willemstad, Curacao
Froja
60' Delta Powerboats 54 Carbon IPS 2018
Palm Beach, Florida, United States
OHHH BOY
58' Merritt Sportfish 1999
Key Largo, Florida, United States
Windward Destiny
58' Leopard 58 2018
Key West, Florida, United States
MERLION
58' Chris-Craft Roamer Riviera 1969
Seattle, Washington, United States
Sly Fox
58' Sea Ray 580 Sedan Bridge 2006
Miami Beach, Florida, United States
ATLAS
57' Trumpy CPMY 1960
Stuart, Florida, United States
IT'S ON
57' G&S Boats Convertible 1987
Enroute, Florida, United States
Sea Senorita
57' Ocean Yachts Super Sport Convertible 2004
Saint Augustine, Florida, United States
Ploto
56' Fountaine Pajot Marquises 1999
Key West, Florida, United States
Rum Line
56' Ocean 56 Super Sport 2002
Saint Petersburg, Florida, United States
Blood Money
55' Sea Ray 550 Sedan Bridge 2005
Saint Augustine, Florida, United States
SeaGoddess
55' Catamaran Cruisers 55 Houseboat 2011
Charlestown, Massachusetts, United States
Windrush
55' Trumpy 55 1966
Beaufort, North Carolina, United States
Sheer Luck
55' Little Harbor WhisperJet Flybridge Cruiser 1999
Marco Island, Florida, United States
Paradise II
55' Sea Ray Sedan Bridge 1995
Naples, Florida, United States
Northern Dream
55' Polar Beluga 2000
Guaymas, Sonora, Mexico
Spirit of Houston IV
55' President 55 Motor Yacht 1995
Fort Myers, Florida, United States
KA OSS ODY
54' Hatteras 54 Convertible 2006
Hobe Sound, Florida, United States
SILVERAY
54' Hatteras Convertible 1995
Paradise Island, Nassau, Bahamas
MY DIAMOND
54' Neptunus 54 Express 1999
Wilmington, North Carolina, United States
Out on a Limb
54' Bertram Convertible 1986
Ocean City, New Jersey, United States
54' Hatteras GT 54 2022
Cape May, New Jersey, United States
54' Dyna Yachts Flybridge 2022
Florida, Florida, United States
ALPHA
54' Bertram Sportfish 1982
Pompano Beach, Florida, United States
53' Hatteras 53 Convertible 1976
Jupiter, Florida, United States
SEA EAGLE
53' Navigator 5300 1997
North Kingstown, Rhode Island, United States
Skipping Stone
53' Pearson 530 1981
Wickford, Rhode Island, United States
Always Late
53' Hatteras 53 ED - Stabilized 1985
New Bern, North Carolina, United States
Passion
53' Ferretti Yachts 530 2003
Acapulco, Mexico
52' Gulf Crosser Custom Center Console 2020
Stuart, Florida, United States
52' Gulf Stream Yachts Custom Center Console 2020
Stuart, Florida, United States
Congaree
52' Hatteras Convertible 1990
Orange Beach, Alabama, United States
Feel Free
51' Spencer 51 Sloop 1970
Cruising the Sea of Cortez, Mexico
TRON
51' Sea Ray 510 Sundancer 2015
Jacksonville, Florida, United States
Shooting Star
50' Morrelli & Melvin 50 2007
Stuart, Florida, United States
Big Fox
50' Hatteras Convertible 2000
Key Largo, Florida, United States
The Turk's Steamer
50' Mikelson Luxury Sportfisher 1995
Chester, Maryland, United States
NORTHEASTERN
50' Custom Beal and Bunker Passenger Vessel 1967
Wickford, Rhode Island, United States
50' Sunseeker Camargue 2003
Cabo San Lucas, Mexico
AMORE
50' Monte Carlo Yachts MC 5 2017
Miami, Florida, United States
Simply Irresistible
50' Sea Ray 500 Sundancer 1996
Dania, Florida, United States
Meditrina
49' Fairline Targa 47 GT 2006
Edgewater, Maryland, United States