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

25 Rollins Dunes Dr
Palm Coast, FL 32137
Jesse Warmka with Your Home Sold Guaranteed Realty - Jesse Warmka Team, original listing - (386) 597-6383

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,199,990
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3968 Square Feet
Agency: Your Home Sold Guaranteed Realty - Jesse Warmka Team
Agency Phone: (386) 597-6383

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Purchase this home, if YOU Are Not Satisfied, We'll SELL IT FOR FREE! *First Responders and Military Members Ask About our Appreciation Discount! + Love it or Leave it Guaranteed! Purchase this home and receive an exceptional financing rate of 5.84% APR with ZERO down payment available for those who qualify. For information on this exclusive Buyer Protection Plan, call the listing agent directly see the info below. Welcome to your dream oasis by the sea! Nestled just 50 feet from the sandy shores, this custom-built masterpiece is a beacon of luxury living in every aspect. Built in 2023, this home boasts not only timeless elegance but also reliability for years to come. Prepare to be captivated by the show-stopping front elevation that sets the tone for the remarkable interior within. As you step inside, a grand entryway adorned with modern architecture, voluminous ceilings, and glamorous pillars welcomes you into a realm of opulence. Spread across three spacious stories, this residence features four bedrooms, three and a half baths, and a three-car garage. The ground floor unveils a private oasis, perfect for guests, with its own wet bar, laundry room, and en-suite bedroom offering direct ocean views and seamless access to the pool deck-a true embodiment of beachfront luxury. Ascend the hand-crafted oak staircase or opt for the convenience of the elevator to reach the expansive second floor, where the heart of the home resides. An open-concept design seamlessly blends the gourmet kitchen, equipped with top-of-the-line appliances and custom cabinetry, with a family room adorned by a stone fireplace-a perfect gathering spot for intimate conversations or grand entertaining affairs. Step onto the expansive balcony through sliding glass doors from either the family room or the formal dining room and soak in the breathtaking panoramic ocean views. On the third floor awaits the ultimate retreat-the primary bedroom sanctuary. Here, a private balcony beckons you to unwind and indulge in endless ocean vistas. Luxuriate in the lavish primary bathroom, complete with spacious His/Her closets, a jacuzzi tub, and a meticulously crafted walk-in shower-a true haven of relaxation and rejuvenation. This coastal haven is not just about luxury; it's also about practicality and peace of mind. With a durable metal roof, hardy board soffits and siding, three HVAC units, two tankless water heaters, propane for gas cooking, and electric blinds, every detail has been carefully considered to ensure comfort and convenience.This home is a true showstopper, brimming with features too numerous to list comprehensively. Offered FULLY FURNISHED and "turn-key". Don't miss the opportunity to experience the epitome of ocean-side living. Contact us today to embark on your journey to owning this unparalleled coastal retreat. Schedule your private showing to see this incredible opportunity today! 24-Hour Open House! Call us today for open house times! Exclusive Benefits Just for You! Enjoy peace of mind with our 12-month Home Warranty, a $500 lender credit, $100 home inspection credit.and a 24-month Satisfaction Guarantee: Love this home, or will buy it back or sell it for free! First-time responders and military members-ask about our appreciation discount! Don't get stuck owning two homes-Buy This Home, I Will Buy Yours! Ready to discuss this incredible opportunity? Call the listing agent or visit our website for a free report on how this exclusive offer works. 0% Down financing available to those who qualify. Exclusive financing rate is subject to buyer using seller's preferred lender. Don't miss out on your dream home-contact us today! *All products and values are subject to the buyer becoming a VIP buyer to qualify for benefits and products. Buyer and agent must agree on all terms.
MlsNumber: --
ListingId: 11434080


Listing Provided By: Your Home Sold Guaranteed Realty - Jesse Warmka Team, original listing
Phone: (386) 597-6383
Office Phone: (386) 597-6383
Agent Name: Jesse Warmka
Disclaimer: Copyright © 2025 My State 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 = 341 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 Lisa Ann Loiacono
Lisa Ann Loiacono
ASCIIMark Spain Real Estate
Call Today!: (904) 403-7585

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App