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;

143 Constance Lane
Saint Augustine, FL 32095

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $835,000
Beds: 5
Baths: Full: 4
Status: Active
SqFt: 3332 Square Feet
Agency: VIRTUAL HOMES REALTY
Agency Phone: (386) 445-9911

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2020
Notes: 143 Constance Ln is a stunning, upgraded Dream Finders home located in the beautiful city of St. Augustine, Florida. The property boasts five spacious bedrooms and four modern bathrooms, providing ample living space for a large family or group of individuals. With a total of 3332 square feet, there is plenty of room to spread out and enjoy all that this home has to offer.<br /> One of the standout features of this property is the oversized screened-in porch that is pre-plumbed for an outdoor kitchen. This area is perfect for entertaining guests or simply relaxing and enjoying the beautiful Florida weather. Additionally, the fenced yard and oversized lot offer privacy and plenty of space for outdoor activities.<br /> Inside the home, the upgrades continue with beautiful LVT flooring, laundry room built-ins, and a double tankless hot water heater, ensuring that the home is as functional as it is stylish. The kitchen is a true chef's dream, featuring a WiFi-enabled double oven making it easy to cook multiple dishes simultaneously and ample counter space for food preparation.<br /> The main living area boasts a beautiful gas fireplace with built-ins on each side, creating a cozy and inviting atmosphere that is perfect for family gatherings or quiet evenings at home. <br /> The Beacon Lake Community is a wonderful place to call home. This community boasts a state-of-the-art clubhouse and a wide range of amenities that are designed to enhance your lifestyle and provide endless hours of fun and recreation.<br /> For those who enjoy swimming and soaking up the sun, Beacon Lake's pool and splash park are the perfect spots. The pool is surrounded by comfortable lounge chairs and umbrellas, making it a great place to relax and unwind on a warm Florida day. The splash park is a hit with friends and family alike, with plenty of water features and fountains to keep everyone cool and refreshed.<br /> For those who love to stay active and fit, Beacon Lake's gym is equipped with state-of-the-art equipment including spin classes and plenty of space for working out. The community also features miles of scenic walking paths, perfect for those who enjoy walking, running, or cycling. Finally, Beacon Lake's kayaking and paddleboarding opportunities provide residents with a unique way to explore the beautiful waterways that surround the community. <br /> In summary, 143 Constance Ln is an impressive, upgraded home that offers a comfortable, modern living space with ample room for entertaining and family activities, all located in the picturesque city of St. Augustine, Florida.
MlsNumber: --
ListingId: FC290199


Listing Provided By: VIRTUAL HOMES REALTY, original listing
Phone: (321) 436-3746
Office Phone: (386) 445-9911
Agent Name: TERESA BROWNE
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 Joe Kramer
Joe Kramer
ASCIIAVANTI WAY
Call Today!: (904) 960-3333

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App