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 = 1053 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 = 1053 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 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 = 1053 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 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;

3016 Lightheart Rd
Louisville, KY 40222
Chip Crush with The Breland Group, original listing - (502) 451-4107 xx201

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,790,000
Beds: 5
Baths: Full: 4, ½: 3
Status: Active
SqFt: 4590 Square Feet
Agency: The Breland Group
Agency Phone: (502) 451-4107 xx201

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1968
Notes: You have to see it! This amazing remodel renovation provides convenience for multi-generational living in the perfect location with entirely new luxury construction. Find plentiful parking with a new driveway for family and friends in this peaceful neighborhood setting. Approach the inviting limestone front porch entry surrounded by fresh landscaping with full irrigation. The home has rich hardwoods and natural light throughout. This is evident the moment you enter, as the grand foyer has sight lines to the kitchen, dining, and family rooms, as well as the second floor library. There's a quiet elevator to the walkout lower level accessible in the foyer as well. The spacious dining room has built-ins that can function as a butler's pantry. Pocket doors offer privacy from the family room. The family room boasts a grand stone fireplace with built-ins and a view to the backyard and kitchen. Walk out to the deck through the double sliding doors or head to the first of two kitchens, which both offer top-of-the-line appliances (double ovens with warming drawer, gas and electric induction cook top / stove, large refrigerator/freezers, a wine refrigerator, dishwashers, and microwave drawer). There's a drop zone and half bath near the elevator and basement stairs. The first level primary suite has a fireplace, access to the back deck, a massive walk-in closet with the first of three laundries, and a full bathroom with no-step glass-enclosed shower, soaker tub, separate vanities, and private toilet. Notice the custom iron railing heading upstairs, where there are 3 bedrooms and a library - each with their own bathrooms! The second laundry is also upstairs for convenience. Take the stairs or elevator to the lower level, where the third laundry and second kitchen are found. Another drop zone can be found leading to the epoxy-floored garage. There's another living space with fireplace that walks out to the back patio and fire pit. The fifth bedroom and living room share access to another full bathroom. Finally, there's a well-equipped, epoxy-floored mechanical room with two tankless water heaters, the geothermal and solar power access points, one of two HVAC systems, electrical panel with a whole house generator, and the A/V control station for the entire house surround sound. The house provides a negative utility bill with all of the environmentally-friendly / green energy-efficient features. Ask for more details, but you have to see it!
MlsNumber: --
ListingId: 1670767


Listing Provided By: The Breland Group, original listing
Phone: (502) 451-4107 xx201
Office Phone: (502) 451-4107 xx201
Agent Name: Chip Crush
Disclaimer: Copyright © 2024 Greater Louisville Association of REALTORS®. 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 = 1053 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 Tamara Cecil
Tamara Cecil
ASCIIRealty Advanced
Call Today!: (270) 903-7777

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App