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

9323 San Jose Boulevard
Howey In The Hills, FL 34737
Brandon English with Engel & Völkers Clermont, original listing - (352) 242-3939

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $579,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2401 Square Feet
Agency: Engel & Völkers Clermont
Agency Phone: (352) 242-3939

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7,405 sqft
Property Type: Other-Single Family Residence
Year Built: 2007
Notes: This beautiful home in the exclusive gated community of Las Colinas overlooks the 17th fairway of the Mission Inn Resort. The 3-bedroom, Mediterranean-style house offers high ceilings, crown molding, and floor-to-ceiling windows that fill the space with natural light. The large chef’s kitchen anchors the rear of the single-level layout. It’s open to the living & dining rooms and features granite countertops, stainless appliances, custom cabinetry, and a massive center island with a breakfast bar & seating for a crowd. Next, the expansive lanai offers panoramic views of the golf course. With brick pavers underfoot, this is the perfect spot to entertain or enjoy your morning coffee. The primary suite is its separate wing, with relaxing views of the fairway & pond, plus private access to the lanai. It boasts 2 custom walk-in closets, double vanities, a corner soaking tub, and a separate tiled shower. The split floor plan places the guest rooms on the other side of the house, separated by a full bathroom. The 2,401 sqft home also includes a BONUS den/office, with built-in storage. There is plenty of closet space, and even the laundry/mud room (at the entrance of the 2-car garage) has a wall of cabinetry for all your storage needs. The sought-after & gated community of Las Colinas sits within the 1,100-acre Mission Inn Golf Resort – on the edge of Lake Harris. The resort offers two 18-hole championship golf courses, tennis/pickleball courts, restaurants, a lounge, a game room, a swimming pool+poolside grill, a spa, and workout facilities. The residents also have access to the marina for boat storage & rentals. Tree-lined San Jose Boulevard puts you about 10 minutes from shops & restaurants, with historic lakeside towns like Mt Dora, Tavares, and Leesburg just 20 minutes away. Downtown Orlando, the airport, and all the theme parks are about 45 mins from your front door, and you can be at the beach in less than 90 minutes. MEMBERSHIP REQUIRED: Either Social or Golf Social one-time initiation fee of $7,500 + 7% sales tax. Monthly $129.25 + 7% sales tax. Golf one-time initiation fee $24,000 + 7% sales tax. Monthly $425 + 7% sales tax.
MlsNumber: --
ListingId: G5087025


Listing Provided By: Engel & Völkers Clermont, original listing
Phone: (352) 242-3939
Office Phone: (352) 242-3939
Agent Name: Brandon English
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.


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 = 358 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 Alan Bird - "A man of His Word."  Broker Associate/Realtor GRI, ABR
Alan Bird - "A man of His Word." Broker Associate/Realtor GRI, ABR
ASCIIThe Real Estate Firm of Orlando
Call Today!: (407) 432-8303

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App