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

11127 Arrowtree Boulevard
Clermont, FL 34715

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $929,000
Beds: 5
Baths: 3
Status: Active
SqFt: 3581
Agency: Engel & Völkers Clermont

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Other
Year Built: 2005
Notes: Welcome to Arrowtree Reserve, a community of custom homes set in the tranquil countryside. Beautiful pristine 1 acre homesite on a prominent corner lot with a circular driveway will impress upon arrival. This meticulously maintained 5 bedroom 3 bath home offers everything you expect from a country retreat from the large inviting front porch to an oversized garage with epoxy flooring. Step inside the double doors to a foyer with details such as high ceilings, crown molding and arches. Separate home office with fast fiber optic connections provides modern convenience to today's non commuter. Stunning natural quartz countertops with leather finish are a show stopper! Solid cabinets, induction cooktop, glass tile backsplash and composite sink make this kitchen a dream. Spacious sun filled family room is perfect for holidays and years of memories to be made. Open the glass pocket doors to reveal your very own oasis. This resort style heated pool area was designed by an architectural firm in California. Pool features Tennessee rock around the spill over spa, beach entry along with a baja shelf. Summer has never been so fun! Bright and spacious primary room is comfortable and inviting ensuite with double sinks, shower and jetted tub and custom closet design perfect for king and queen. Additional home features: Roof 2017 * Hybrid Water Heater 2015* Central Vac*Underground Electric dog fence* Bahama Shutters throughout entire home* Water Filtration/Softener* Remote controlled blinds for glass slider and breakfast nook* 1st time on the market - Do not miss your dream come true!
MlsNumber: G5080485


Listing Provided By: Engel & Völkers Clermont, original listing
Name: Engel & Völkers Clermont
Phone: (352) 242-3939
Office Name: Engel & Völkers Clermont
Office Phone: (352) 242-3939
Agent Name: Celia Davis
Disclaimer: Copyright © 2024 Engel & Völkers. 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