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

420 Balaclava Drive
Greenville, AL 36037
Susan Rhodes with First Realty of Greenville, original listing - (334) 382-2688

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $449,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3176 Square Feet
Agency: First Realty of Greenville
Agency Phone: (334) 382-2688

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1971
Notes: Immaculate Executive Style 3BR/2.5 brick home located in great neighborhood! The Stone home has been an icon for the last 50+ years situated beautifully atop this hill. This home has custom details that can rarely be found in this area. This home features a formal living room and dining room along with two additional family rooms. One family room has a lovely sitting area with a beautiful fireplace with gas logs and a beautiful custom built-in oak curio cabinet that has beautiful Baldwin brass knobs, lighting and glass doors perfect for anything you would like to showcase. The second family room is perfect for enjoying the kids, watching television or just entertaining friends. It has lots of windows that provide a great deal of natural light and it also has a large oak entertainment center and bookcase. The oak wood trim and cabinets in this home are fabulous. The kitchen has lovely oak cabinets as well with melamine lining in all of the cabinets. The stove and dishwasher are quality Kitchen Aid appliances. The countertops in the kitchen are Corian. This home features 2 offices-one executive style and the other is very elaborate with a light table, storage, work station and lots of storage-perfect for a teacher or architect! The bedrooms are nice size and have large closets. The master bath is spacious and has 2 separate vanities and lots of storage. There is also a large jacuzzi tub and separate shower. There is also a very nice laundry room. And last but not the least, is the lovely brick patio that is partially covered and is easily accessible from the second family room. This home was custom built for Melvyn and Glenda Stone and has been beautifully and meticulously cared for over the years. Call us today to make this fabulous home yours!
MlsNumber: --
ListingId: 561405


Listing Provided By: First Realty of Greenville, original listing
Phone: (334) 382-2688
Office Phone: (334) 382-2688
Agent Name: Susan Rhodes
Disclaimer: Copyright © 2024 Montgomery Area Association of Realtors MLS. 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