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 = 350 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 = 350 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 = 350 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;

4494 Haiti Drive
Hernando Beach, FL 34607

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,250,000
Beds: 3
Baths: 2
Status: Active
SqFt: 2407
Agency: Re/Max Advantage Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1998
Notes: ONCE IN A LIFETIME... Private, Tropical, Stunning... Come See! Custom Built Home on a Gorgeous HUGE Waterfront Lot..So Much Room to add your own touches.. Room for a Pool or Two.. 256 Feet on the Water! Porpoise Bay Canal is adequately named as Dolphin are almost daily visitors in your backyard.. PLUS a 5 Minute Boat Ride to the OPEN GULF. This Oasis has spots to see the Sunrise & the Sunset... Sit on the Side Upper Deck or Go Down the Path through the Arbor & sit on the Swing to watch Amazing Sunsets.. Sit on the Back Part of the Verandah or the Covered Back Swing for the Sunrises.. Beautiful Skies that change daily.. 234 Ft of Seawall for ALL of your waterfront toys! Plus an area 22 ft started for a Future Boat Ramp. The Backyard is my Favorite.. Gazebo with Lights & Fan, Firepit, Swaying Queen Palm Trees, Arbor, Swings, Pavers, Floating Dock with Shore Power & Water, 2 Showers.. Birds of Paradise, Jasmine, Chinese Fan Palm, Red & Yellow Oleander, Hawaiian Plumeria, Wisteria.. The Tropical Front is Beautiful with Robolini & Paurotis Palm Trees, Pavers for the Driveway & Walkway, Travertine Steps & Front Porch + Double Door Entry with Transom Window.. Open Floor Plan that you immediately see the Back Waterfront through the Pocket Sliding Glass Doors. Living Room offers Vaulted Ceilings & Lighted Shelving. Completely Remodeled Wow Kitchen with Wood Cabinets, Marble Counters, Custom Range Hood over the Stove with Copper Backsplash, Convection Oven, French Door Refrigerator, New Styled Microwave Drawer, Kitchen Island / Breakfast Bar and overlooks the Dining Room with Bay Window & Plantation Shutters. Master Bedroom Suite with Access to Back Verandah, Plantation Window & Sliding Glass Door Shutters, Remodeled Bathroom with Wood Cabinet & Copper Sink + Separate Vanity, Granite Counters & Copper Sink, Etched Mermaid Transom Window, Walk in Shower plus Soaking Garden Tub with Aqua Brass Fixtures... Walk in Closet.. Split Bedroom Plan with Bedroom 2 + 3 on the Other Side of the home with Remodeled Guest Coastal Looking Bathroom with Tub/Shower Combo, Pretty Bowl Sinks, Plantation Shutter, White Cabinets & Granite Counter. Every Man's Wish List is a HUGE Garage.. This Garage can fit 4 Cars Plus has Room for Storage & a Workshop. Home has Never Flooded.. Come.. Love Where You Live..
MlsNumber: 2235567


Listing Provided By: Re/Max Advantage Realty, original listing
Name: Re/Max Advantage Realty
Phone: (352) 596-9999
Office Name: REMAX Alliance Group
Office Phone: (352) 596-9999
Agent Name: Sharie L. Oakland PA
Disclaimer: Copyright © 2024 Hernando County Association of REALTORS ®, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 350 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;
Real Estate Expert Photo for Carlos Nunez & Adam Brandt
Carlos Nunez & Adam Brandt
ASCIIBerkshire Hathaway HomeServices Florida Properties Group
Call Today!: (413) 454-3287

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App