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

3647 Westover Road
Fleming Island, FL 32003

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,995,000
Beds: 7
Baths: Full: 6, ½: 2
Status: Active
SqFt: 6777 Square Feet
Agency: KELLER WILLIAMS REALTY ATLANTIC PARTNERS SOUTHSIDE
Agency Phone: (904) 515-2700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1979
Notes: Welcome to Your Dream Riverfront Oasis<br /> Nestled on a sprawling 1.5-acre lot, this breathtaking riverfront home boasts an impressive 110 feet of direct river frontage, offering unparalleled views and a serene setting that promises a lifestyle of luxury and tranquility. From the moment you arrive, you are greeted by the grandeur of this meticulously renovated residence. 7 bedrooms, 6 full baths, 2 half bathrooms, a gym, game room, 2 offices, 2 kitchens, 2 laundry rooms and 3 entertainment-living rooms make up the impressive 6,777 sqft layout. As you step through the front door, the expansive foyer sets the tone for what lies beyond - a seamless blend of classic charm and modern sophistication. The stunning custom staircase is an absolute showstopper. The interior spaces are thoughtfully designed to cater to multigenerational living, with distinct areas that provide both communal gathering spaces and private retreats. The second wing offers a true guest-home feel as it boasts its own first floor primary suite, kitchen and living room. The heart of the home is undoubtedly the gourmet kitchen, a culinary masterpiece that will delight even the most discerning chef. Adorned with top-of-the-line appliances, custom cabinetry, and stylish finishes, this kitchen is a culinary haven where memories are made and culinary creations come to life. Whether you're hosting a lively dinner party in the elegant dining room or seeking solace in the cozy reading nook, this home offers the perfect balance of togetherness and privacy.<br /> Step outside, and you'll discover a true outdoor oasis that seamlessly blends with the natural beauty of the surroundings. A private dock leads to the boat house, offering endless opportunities for boating, fishing, or simply basking in the tranquility of the water. The meticulously landscaped grounds provide a picturesque backdrop for outdoor entertaining, whether you're hosting a summer barbecue on the terrace or enjoying a peaceful evening by the riverside.<br /> This riverfront home isn't just a residence - it's a legacy in the making. Embrace the luxury, beauty, and serenity that come with riverfront living and make this extraordinary property your own. With its sophisticated design, unparalled views, and endless recreational opportunities, this home offers a truly unique waterfront lifestyle that is ready to be enjoyed to the fullest. Don't miss your chance to experience the epitome of riverfront living - schedule a viewing today and make this oasis your new home.
MlsNumber: --
ListingId: 2040058


Listing Provided By: KELLER WILLIAMS REALTY ATLANTIC PARTNERS SOUTHSIDE, original listing
Phone: (904) 651-6548
Office Phone: (904) 515-2700
Agent Name: JORDAN FERIA
Disclaimer: Copyright © 2024 Northeast Florida Multiple Listing Service, 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 = 333 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 Rick Jurkovac
Rick Jurkovac
ASCIIThames Realty, INC
Call Today!: (904) 874-6714

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App