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

345 Redwing Lane
Saint Augustine, FL 32080

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,530,000
Beds: 4
Baths: 4
Status: Active
SqFt: 2918
Agency: Berkshire Hathaway HS Florida Network Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1994
Notes: Poised on a prized .62-acre lot, this home sits on a cul-de-sac with extreme privacy. This 4 bedroom and 3 and a half bath, pool home has been totally upgraded and has room to add a detached in law suite or “Casita”. Inspiration has struck. You’ve found what you have been looking for and are ready to make it part of your story.<br /> The gourmet kitchen is classic, uncluttered and works beautifully. It has 9’8” X 5’ marble granite island as well as a butcher block prep area, double ovens, a gas stove, a pot filler, and soft close shaker cabinets. It will delight the finest of chefs.<br /> The laundry room is oftentimes ignored as a simple utility space but in this case is elevated with a white marble pet washing station and lots of storage.<br /> There are two oversized master suites with walk in closets and a 3rd ensuite guest bedroom. Each bedroom has a distinct look. All bathrooms have been renovated with glass shower enclosures, rain and massage shower settings, sparking mosaic tile, custom self-flushing toilets and upgraded vanities. Mahogany floors flow seamlessly throughout the home with plantation shutters accenting the windows for privacy. This home is tailored to the style and lifestyle of a modern family, casual enough for soccer parties but formal enough for fundraisers.<br /> There is a ground floor sunken flex space/office that could be converted to a 5th bedroom. The English style front door welcomes you home and once inside the wrought iron stair rails and custom designed stair tread runner up the staircase is magnificent. The spacious bonus room upstairs is a fabulous family retreat with a custom digital fireplace and affords a place for recreation. This home has every imaginable upgrade and the attention to detail is unmatched. The upgrades are too many too mention so please refer to the Notable Features attached to the MLS.<br /> Put up your feet, toast and relax for gatherings that linger long into the night. The 42 ft pool has been refurbished and resurfaced with new paint and tile and is the largest on Anastasia Island with a 10 ft depth. There is a new outdoor custom kitchen with an ice hold, led lights and a large marble bar that seats 6. <br /> The two-car garage is epoxied and oversized and has an extra-long driveway with multiple parking spaces.<br /> This home is being sold partially furnished with acceptable offer (see attached furnishings that convey).<br /> Getting away from it all has never been this close to it all. Island Hammock is a gated community in the heart of St. Augustine Beach surrounded by rolling hills and majestic Oaks. It’s just a few blocks from the Beach and a few minutes’ drive to historic downtown. The Beach and many restaurants and supermarkets are just steps away.
MlsNumber: FC296352


Listing Provided By: Berkshire Hathaway HS Florida Network Realty, original listing
Name: Berkshire Hathaway HS Florida Network Realty
Phone: (904) 471-6906
Office Name: BERKSHIRE HATHAWAY HS FLORIDA NETWORK REALTY
Office Phone: (904) 471-6906
Agent Name: Debbie Da Silva
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 = 378 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 Georgina Essa
Georgina Essa
ASCIIRound Table Realty
Call Today!: (904) 629-8242

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App