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

13729 Shipwatch Drive
Jacksonville, FL 32225
JAMES PITTMAN with KELLER WILLIAMS REALTY ATLANTIC PARTNERS, original listing - (904) 247-0059

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,999,999
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4157 Square Feet
Agency: KELLER WILLIAMS REALTY ATLANTIC PARTNERS
Agency Phone: (904) 247-0059

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Welcome to your dream home in the sought-after Queens Harbour Yacht and Country Club, a beautiful gated yacht and golf community where luxury meets comfort. This stunning 5-bedroom, 4.5-bath, 3 car garage estate offers over 4,100 sq. ft. of thoughtfully designed living space, perfect for families looking for both elegance and a warm, homely vibe.<br /> <br /> Nestled along a peaceful deep-water spring fed canal, this home features a private dock constructed of concrete. Equipped with power and fresh water, making it ideal for boating or simply enjoying the tranquil water views from your own backyard. It's your personal gateway to the serene beauty of waterfront living.<br /> <br /> Step through the front door and immediately feel the comfort of home. Newly installed wide plank flooring runs throughout the house, offering a fresh yet cozy ambiance. At the heart of the home is the beautifully updated kitchen, complete with new cabinetry, an oversized island, and striking Calcutta Cliff quartz countertops with waterfall edges. Whether you're preparing family meals or enjoying casual breakfasts, this kitchen is designed for both function and style, making it the heart of your home.<br /> <br /> The living room is a warm, inviting space, enhanced by custom cabinetry adjacent to the electric fireplace that adds both elegance and functionality. Upstairs, the newly updated stair railing and treads lead you to a versatile bonus room, perfect for a playroom, office, or home theater. The spacious master suite serves as your private retreat, complete with a luxurious spa-like bathroom that includes modern fixtures, a custom double vanity, and a relaxing soaking tub.<br /> <br /> All bathrooms have been beautifully remodeled with new showers, tubs, and high-end fixtures, offering a peaceful retreat for guests and residents alike. Each one is designed with comfort and luxury in mind.<br /> <br /> Your backyard is an oasis with its serene water views and lush landscaping. It's the perfect spot for family gatherings, BBQs, or just relaxing with a glass of your choice at the end of the day. The seamless flow between indoor and outdoor spaces makes entertaining a breeze.<br /> <br /> Beyond your front door, you'll enjoy the many amenities of Queens Harbor, including a championship golf course and a vibrant community atmosphere. Whether you're an avid golfer or simply enjoy the peaceful surroundings, this is a neighborhood where you'll feel right at home.<br /> <br /> This home offers everything you needluxury, comfort, and the perfect location. Come and see it for yourself, and discover how this waterfront retreat can be your forever home.<br /> <br /> Schedule your tour today!
MlsNumber: --
ListingId: 2052580


Listing Provided By: KELLER WILLIAMS REALTY ATLANTIC PARTNERS, original listing
Phone: (904) 894-6207
Office Phone: (904) 247-0059
Agent Name: JAMES PITTMAN
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 = 3345 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;
Erica Logan
ASCIISunshine Realty & Co.
Call Today!: (904) 322-9571

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App