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

55 Brookstone Road
Wetumpka, AL 36093
Belyn Richardson with REMAX Cornerstone Realty, original listing - (334) 478-3825

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $625,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4353 Square Feet
Agency: REMAX Cornerstone Realty
Agency Phone: (334) 478-3825

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: This stunning Mediterranean style home is gracefully situated on a lot in Brookwood, overlooking a breathtaking mountainous view. Picture perfect outdoor living areas create an ideal back yard spot for entertaining or just relaxing. This home features top of the industry upgrades and special finishes throughout including massive crown molding and columns, arched doorways, travertine marble and wood flooring. It boasts a gorgeous Great room with massive fireplace with 2 story windows and impressive views. The kitchen is a chefs dream with all stainless steel appliances, gas cooktop, double ovens, microwave, refrigerator, granite countertops and island with a large pantry and plenty of cabinets. There is a breakfast area at 1 end of the room. You also have a formal dining room off the foyer. <br /> A second den/library is just off the kitchen with floor to ceiling bookcases and a rugged stacked stone fireplace. The primary suite is also on the first level and features a sitting area, built ins and oversize bath with granite double vanities, jetted tub, separate shower and a large "his" closet. "Her" closet is a 10x13 room that was converted from an existing room/office and features a full length framed mirror, floor to ceiling drawer space, built in shoe rack, handbag storage, custom clothing hanging bars, crystal chandelier. Laundry room is on the main floor with cabinets and a soaking sink. Adjacent to laundry room is the another room with its own entrance. Ideal for an office. workout room or separate living area for a long-term guest. Upstairs houses the media room with a 75in screen, surround sound and theater recliners, 3 large bedrooms and 2 full baths. Upgrades in 2022 include entire home painted including floor molding and garage, epoxy flooring in garage, carpet in bedrooms, all custom closets, built in bookcases and cabinets, new refrigerator, disposal, ceiling fans, tiling of front and back patios.<br /> You can have it all and this is it.
MlsNumber: --
ListingId: 561995


Listing Provided By: REMAX Cornerstone Realty, original listing
Phone: (334) 478-3825
Office Phone: (334) 478-3825
Agent Name: Belyn Richardson
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.


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 = 25 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;
Diana Goodson
ASCIICentury 21 Prestige
Call Today!: (334) 657-0465

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App