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 = 3339 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 = 3339 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 = 3339 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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;

2895 Windsor Lakes Way
Green Cove Springs, FL 32043

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $378,990
Beds: 3
Baths: 2
Status: Active
SqFt: 2003
Agency: Round Table Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2022
Notes: Closing Cost Contribution towards Interest Rate Buy-Down is available on this home when purchased NOW and close by 4/30/24. This former model home is sure to impress your guests as they arrive at your new single-story home with professional landscaping including flower beds, St. Augustine sod, and a full Rainbird® irrigation system to keep it looking it's best. The covered entry adorned with stacked brick welcomes guests to the front door where they will step into your home and fall in love with the luxury vinyl plank flooring that flows throughout the main living areas of your home. On one side there are two bedrooms and a hall bath having a vanity with knee space and a Solarite quartz vanity top. Across the hall, you pass your designated laundry room and enter into a spacious den - perfect for a home office, playroom, or quiet sitting room. The end of the central hallway leads to your stunning great room with soaring volume ceilings and a gourmet kitchen that would be the envy of any home chef. Your spacious kitchen includes a large wet island, stylish ginger stained Woodmont® poplar cabinets with 42" uppers, dark contrasting countertops, dual basin stainless steel sink, and is finished with Whirlpool® and Kitchen Aid® stainless appliances - including gas cooktop, double wall oven, dishwasher, microwave, and side-by-side refrigerator. After entertaining in your great room, bring your guests outside to your covered patio overlooking a serene pasture to enjoy the sunset or head to the amenity center and relax by the pool. Retire to your luxurious owner's suite at the end of the day where you will enjoy the tranquility of your spacious bath featuring a large walk-in shower, dual sink vanity with quartz top and large linen closet. Other features include KB Connect Smart Tech package, surround sound, security system, ceiling fans, Shaw® carpet in bedrooms, upgraded lighting, Ecobee3® Lite Wi-Fi Smart Thermostat, garage door opener, coach lights and more. The neighborhood will feature a pool, playground, splash pad, and dog park in the very near future as development has already begun! *Closing Cost Contribution towards cash to close and interest rate buy down available with the use of KBHS, pending home and financing guidelines. Home must close by 4/30/24.
MlsNumber: 1231432


Listing Provided By: Round Table Realty, original listing
Name: Round Table Realty
Phone: (904) 469-7653
Office Name: ROUND TABLE REALTY
Office Phone: (904) 469-7653
Agent Name: HOWARD FLASCHEN
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 = 3339 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 Jonathan Watts
Jonathan Watts
ASCIIAnchor Realty Florida
Call Today!: (904) 909-9494

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App