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;

39215 Treeline Drive
Lady Lake, FL 32159
Stephen Hachey with FLAT FEE MLS REALTY, original listing - (813) 642-6030

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $539,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2384 Square Feet
Agency: FLAT FEE MLS REALTY
Agency Phone: (813) 642-6030

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: WELCOME HOME to this 3 bedroom, 2 1/2 bath house in the community of Harbor Hills and Country Club. This house is move in condition with many upgrades and a great split floor plan. Discover the privacy, tranquility and security of this fully gated community, situated in the rolling hills of Lady Lake, with picturesque views of Lake Griffin. Harbor Hills is an established, all ages community that includes a club house, premier golf course, tennis courts, exercise room, restaurant, community boat launch and docks, club house pool and manned security gates. As you enter in through the oversized front entry door, this house boasts high ceilings, 8' doors throughout the house, all hard surface flooring and custom crown trim throughout. When you pass through the front entry, you walk into the open plan great room with double French doors to the office on one side and the formal dining room on the other side. The views through the great room into the large screened in lanai and landscaped back yard, give you a great place to have your morning coffee and a large area for entertaining. Off from the great room is an oversized gourmet kitchen with built in appliances and a pass through entry into the dining room. The master bedroom is off the opposite side of the great room with more than enough room for large sized bedroom furniture and a patio door out to the lanai. This master bedroom also has separate his/hers walk in closets. The master bathroom provides dual vanities, soaking tub, walk in shower and a toilet in its on room. For the 2nd and 3rd bedrooms, they are located off the front entry on the opposite side of the house. These two bedrooms have a Jack and Jill bathroom between the two rooms with pocket door dividers. This is a one owner house that has always been meticulously maintained. Listed next are the upgrades done to this house at the time of build, cement clay tile roof, double pane casement windows, gourmet kitchen, whole house Home Defense bug injection system, yearly termite protection and bi-yearly heat/cool system service. Upgrades done to this house since being built are crown and custom moldings throughout, glued down engineered hardwood flooring, color flaked epoxy garage floor, newer energy efficient patio doors, fully enclosed screened in back lanai(screen replaced 2 1/2 years ago) and an upgraded heating/cooling system with 3 zones for separate temperature control in different sections of the house. This house has had a whole house 4 point inspection done by the insurance company less the 1 1/2 years ago. The house passed the full inspection with no issue and the report is available to review. Thank you for your interest in this house and please call for your personal tour today.
MlsNumber: --
ListingId: TB8314262


Listing Provided By: FLAT FEE MLS REALTY, original listing
Phone: (813) 642-6030
Office Phone: (813) 642-6030
Agent Name: Stephen Hachey
Disclaimer: Copyright © 2024 Stellar MLS. 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