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

1413 Clubhouse Lane
Mt Sterling, KY 40353

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $479,900
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2298 Square Feet
Agency: HomeLand Real Estate Inc - Mt Sterling
Agency Phone: (606) 356-3063

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Refrigerator
Architectural Style: Ranch
Construction Materials: Brick, Stone, Brick Veneer
Flooring: Tile, Hardwood
Interior Features: Walk-in Closet(s), Ceiling Fan(s), Dining Area, Bedroom First Floor, Primary First Floor
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4

Window Features

Exterior Features: Porch, Patio
Parking Features: Garage
Patio and Porch Features: Patio, Porch
Property Condition: New Construction
Roof: Shingle, Composition

Neighborhood/Schools

Elementary School/District: Mapleton/Montgomery County - 18
Middle/Junior High School/District: /Montgomery County - 18
High School/District: Montgomery Co/Montgomery County - 18
Subvidision Name: Silver Creek

Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Introducing a STUNNING new construction brick and stone home, designed to exude elegance and modern comfort. Step inside to discover a thoughtfully designed interior that embraces functionality and luxury. The open-concept layout seamlessly connects the main living spaces, fostering a sense of togetherness and ease. This spacious residence boasts 4 bedrooms and 2.5 bathrooms, offering ample space for relaxation and stylish living. The gourmet kitchen is a culinary enthusiast's dream come true. It boasts ample cabinet space, and a spacious center island that serves as a gathering point for family and friends. The exterior of the house showcases a seamless blend of classic brick and sleek stone, creating a captivating facade that is both timeless and contemporary. The combination of these materials not only enhances the home's durability but also lends an air of sophistication to its overall aesthetic. This one has to be put on your list of homes to see in todays market!
MlsNumber: --
ListingId: 23024128


Listing Provided By: HomeLand Real Estate Inc - Mt Sterling, original listing
Phone: (606) 356-3063
Office Phone: (606) 356-3063
Agent Name: Jonathan Wood
Disclaimer: Copyright © 2024 Lexington-Bluegrass 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App