Title Page Background
DEBUG FN args: Array ( [0] => 3339 [1] => [2] => [3] => agent ) BEFORE: Site: 3339 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3339 Igate: njhud LocID: 3339 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('flhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3339 [1] => [2] => [3] => lender ) BEFORE: Site: 3339 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3339 Igate: njhud LocID: 3339 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('flhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3339 [1] => [2] => [3] => other ) BEFORE: Site: 3339 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3339 Igate: njhud LocID: 3339 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('flhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

5040 Sagebrush Avenue
Keystone Heights, FL 32656
LESLIE DOUGHER with COLDWELL BANKER VANGUARD REALTY, original listing - (904) 269-7117

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2308 Square Feet
Agency: COLDWELL BANKER VANGUARD REALTY
Agency Phone: (904) 269-7117

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: Rustic Luxury with Modern Comforts - Turnkey Equestrian Estate!<br /> Discover the perfect blend of craftsmanship, functionality, and natural beauty with this stunning log home built for durability and comfort! Nestled on a fully fenced multi-acre property, this estate offers high-end finishes, energy efficiency, equestrian facilities, and a stocked pond—everything you need for a self-sufficient, country lifestyle.<br /> Home Features:<br /> &#10004; Foundation & Flooring: Built on a monolithic slab with reinforced footers, solid Advantec subfloors, and Tiger Mahogany hardwood floors throughout the first level, with Slate tile in baths, pantry, & laundry. The second floor features gorgeous 2''x6'' tongue & groove knotty pine flooring.<br /> &#10004; Log Construction: 6'' Cypress D logs with 10'' lag screws every 2 feet, rubber gaskets for superior insulation, and a fresh oil-based stain applied in January 2025.<br /> &#10004; Roof & Insulation: Metal roof with 4'' solid foam panel insulation, topped with an ice shield moisture barrier for energy efficiency.<br /> High-End Kitchen & Appliances (All New 2024!):<br /> <br /> GE Wall Oven/Microwave & GE Profile Dishwasher<br /> Whirlpool Refrigerator/Freezer with Ice Maker<br /> Jen-Air Propane Gas Cooktop<br /> Commercial Ice Machine in Walk-in Pantry<br />  Fireplace & HVAC: Propane gas fireplace, 2024 Rinnai tankless water heater, new 2.5-ton AC for 1st floor, 2-ton AC for 2nd floor (serviced 2024).<br />  Energy Efficiency: SUNPRO/ADT Solar Panel System (2021) with a 25-year warranty!<br /> Outdoor & Agricultural Features:<br />  Equestrian Facilities:<br /> <br /> Barn #1: Three 12'x12' stalls with an 8'x36' breezeway.<br /> Barn #2: Three 12'x12' stalls + a 12'x24' breezeway, plus five more stalls currently used for equipment storage (convert to 8 total stalls).<br /> Two clients currently boarding horsespotential income opportunity!<br />  Fencing & Pastures: Divided into 4 separate pastures, enclosed with 2"x4" horse fencing.<br />  Stocked Pond: ½ acre pond, 25 feet deep, stocked with Blue Gill Brim, Florida Cracker Brim & Large Mouth Bass!<br />  Well Water & Septic: 500 ft deep well with 3 HP inline pump, major water lines to house & barns, septic system pumped (2024) with new commercial sump pump.<br />  Pole Barn (30'x30'): Attached to porch via breezeway, includes a steel barbecue/smoker (included!).<br /> =6 Dog Kennel & Additional Buildings:<br />  Dog Kennel:<br /> <br /> Multiple indoor/outdoor kennels with guillotine doors<br /> Tiled dog washroom w/ raised cast iron tub<br /> On-demand hot water heater<br /> Storage room + side-by-side refrigerator & freezer included!<br />  Wood Shop (24'x24' w/12'x12' finish area):<br /> Built on a monolithic slab with 2"x6" insulated walls & ceiling<br /> Custom wood doors<br /> Includes 12'x12' maintenance/workroom & 12'x8' tack room with shelving for saddles.<br /> =œ Equipment Included (Optional Purchase!):<br />  2008 L3400 HST 35HP Diesel Kubota Tractor<br />  5ft John Deere Mower & Bushhog Front End Loader<br />  Quick Change Forks & 5ft Box Blade<br />  2020 Gravely HD 60" Zero Turn Mower<br /> <br /> This property is move-in ready with high-end finishes, modern amenities, and endless possibilities for horse lovers, homesteaders, and outdoor enthusiasts! Serious inquiries onlythis one won't last long!<br /> Schedule your private showing today!
MlsNumber: --
ListingId: 2068789


Listing Provided By: COLDWELL BANKER VANGUARD REALTY, original listing
Phone: (904) 704-5831
Office Phone: (904) 269-7117
Agent Name: LESLIE DOUGHER
Disclaimer: Copyright © 2025 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => clay-south [3] => FL [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: clay-south State: FL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: clay-south State: FL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('flhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Angela Moilanen
ASCIIRound Table Realty
Call Today!: (904) 838-3159

Local Mortgage Pro

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => clay-south [3] => FL [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: clay-south State: FL Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: clay-south State: FL Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('flhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Tabatha Hughes NMLS#623256
ASCIIGuranteed Rate
Call Today!: (904) 755-5285

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App