Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 361 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 361 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 361 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

1173 Palmetto Drive
Cedar Key, FL 32625

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $496,000
Beds: 2
Baths: 1
Status: Active
SqFt: 756
Agency: beycome

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1971
Notes: Property for sale at 1173 Palmetto Drive, Cedar Key, FL, USA. LOCATION, LOCATION, LOCATION! This is a unique property that has few equals in the entire state. Enjoy an unobstructed view of the Gulf of Mexico from your front deck. Own real estate that is directly on the Gulf of Mexico in your front yard and also own property on a navigable canal in the backyard. Dock your boat behind the house on the canal that offers a quick ride to the open Gulf. Launch your boat in the boat ramp that you own- Rare in Cedar Key. This property is a Gem and on a desirable street in Cedar Key. Sit on the large deck any time of day and watch the varied and vibrant wildlife frolic- Ospreys dive bombing for fish while eagles try to steal them! Pods of dolphins patrolling the waters for mullet. This is a mobile home that had a major upgrade in 2013. On the Inside 4 inch framed walls and new windows were added. Outside T111 siding added. The original mobile home is sandwiched in between. Take a close look at the map and pictures to see the unique positioning of Palmetto Drive. Peaceful, quiet, & serene with spectacular views, properties like this are few and far between. This is an opportunity to own a unicorn of a property that only comes available on rare occasions. For the last several years, this property (Goose Cove Cottage) has been a supremely highly rated vacation property on VRBO. It averages about $3,000 per month in gross rents. It has 136 reviews averaging 4.7 rating. If you chose to continue using it as a vacation rental, you are also buying an active operating business, that has a following of guests that love to vacation here. Everything in it comes with it. .
MlsNumber: O6096748


Listing Provided By: beycome, original listing
Name: beycome
Phone: (844) 239-2663
Office Name: BEYCOME OF FLORIDA LLC
Office Phone: (844) 239-2663
Agent Name: Steven Koleno
Disclaimer: Copyright © 2024 Stellar MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App