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

523 Nw Brinkley Terrace
Lake City, FL 32055

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $700,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1548
Agency: Chad and Sandy Real Estate Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 1989
Notes: ** TWO HOMES ** 5 ACRE PROPERTY ** COMPLETELY RENOVATED IN 2022 **<br /> Unparalleled Opportunity: Two Homes + Acreage in Lake City, FL<br /> Calling horse lovers and those seeking the ultimate Florida lifestyle! This exceptional property in Lake City offers two charming homes, expansive cleared land, and equestrian amenities, all conveniently nestled within a peaceful community. 5.2 acres of cleared land: Plenty of space for outdoor adventures, gardening, or simply enjoying the serenity of nature. Both homes were completely renovated 2022. Renovations for both homes include: all-new flooring, HVAC units, metal roofs, kitchens, and more, ensuring comfort and peace of mind. In the first house you'll find 3 bedrooms, 2 bathrooms, and a 2-car garage, perfect for your family or guests. The second house has 2 bedrooms, 2.5 bathrooms, and a spacious 3.5-car garage. Ideal for those with an extra vehicle, or looking an additional living space such as a game room, a movie room, etc...the possibilities are endless! This property has the potential to be an equestrian paradise! There's two separate, fenced large horse pens providing ample space for your equine companions. You'll love the detached tandem workshop (garage) and a horse barn built in 2022. The workshop provides the perfect place to work on your next creative project, and the barn offers storage and functionality for all your equestrian needs. The barn has three horse stalls, power, water, and a feeding room. A space creating a complete and convenient experience for horse care. & Last but not least, high and dry land: A valuable feature in Lake City, offering peace of mind during Florida's rainy seasons. This extraordinary property offers a unique combination of comfortable living spaces, ample land, and equestrian facilities, making it ideal for families, horse enthusiasts, or investors seeking a one-of-a-kind opportunity. Don't miss out on this chance to create your dream Florida lifestyle!
MlsNumber: 2012874


Listing Provided By: Chad and Sandy Real Estate Group, original listing
Name: Chad and Sandy Real Estate Group
Phone: (904) 219-7539
Office Name: CHAD AND SANDY REAL ESTATE GROUP
Office Phone: (904) 219-7539
Agent Name: CHAD NEUMANN
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App