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 = 3220 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 = 3220 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 = 3220 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;

166 Coquina Key Drive
Ormond Beach, FL 32176

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,094,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2348
Agency: Virtual Homes Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1999
Notes: Back on the market, buyer’s financing fell through! Owner will entertain lease with option to purchase! Welcome to your oceanfront oasis! This extraordinary home offers a luxurious coastal living experience like no other. Situated directly across A1A from the beach, you'll wake up to breathtaking ocean views and the soothing sound of waves crashing against the shore. As you enter the main level, you'll be greeted by a large in-ground pool, seamlessly integrated into the house's design. Imagine lounging by the poolside, enjoying the sun's warm rays, and taking refreshing dips in the crystal-clear water. This level also features a spacious kitchen with ample cabinets, perfect for storing all your culinary essentials. The adjacent dining room overlooks a large family room, where sliding glass doors lead out to the pool area, creating a seamless indoor-outdoor flow for entertaining guests. The main floor is also home to a master bedroom with an en-suite bathroom, providing a private sanctuary for relaxation. On the upper level, you'll discover another master suite with a large balcony that offers panoramic views of the Atlantic Ocean. This level also boasts another family room and an office/loft space, as well as an additional guest suite, ensuring that everyone has their own space to unwind and enjoy. Large brand new impact windows throughout the home allow natural light to flood the rooms, enhancing the bright and airy ambiance. The views from these windows are simply breathtaking, showcasing the pristine sandy beaches and the endless horizon of the ocean. On the third floor, you'll find another loft/office space which could be a cozy perfect place for curling up with a book or enjoying some quiet time. The third-floor family room opens up to an enormous outdoor space with a large covered area and a spacious open deck, providing the ultimate setting for unforgettable oceanfront entertainment. Imagine hosting gatherings, soaking up the sun, and savoring magical views from this incredible vantage point.<br /> The community offers a private beach walkover just across the street from the entrance, providing easy access to miles of pristine sandy beaches. Additionally, you'll have the pleasure of being located next to the beautiful Gamble Rogers State Park and nature preserve, offering opportunities for kayaking, paddleboarding, biking trails, and immersing yourself in the area's natural beauty.Convenience is at your fingertips with shopping, dining, and entertainment options just a short distance away. This oceanfront gem truly offers the perfect blend of luxury, tranquility, and access to a vibrant coastal lifestyle.Don't miss the chance to make this remarkable home your own and experience the unparalleled beauty of oceanfront living. Schedule a viewing today and let your beachside dreams become a reality!
MlsNumber: FC291439


Listing Provided By: Virtual Homes Realty, original listing
Name: Virtual Homes Realty
Phone: (386) 445-9911
Office Name: VIRTUAL HOMES REALTY
Office Phone: (386) 445-9911
Agent Name: ALINA PEKARSKY
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.


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 = 3220 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 Sharlene Barhoo
Sharlene Barhoo
UTF-8WEICHERT, REALTORS® - Hallmark Properties
Call Today!: (386) 334-6822

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App