Title Page Background
DEBUG FN args: Array ( [0] => 2197 [1] => [2] => [3] => agent ) BEFORE: Site: 2197 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2197 Igate: njhud LocID: 2197 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2197 AND i.igate IN ('okhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2197 [1] => [2] => [3] => lender ) BEFORE: Site: 2197 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2197 Igate: njhud LocID: 2197 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2197 AND i.igate IN ('okhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2197 [1] => [2] => [3] => other ) BEFORE: Site: 2197 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2197 Igate: njhud LocID: 2197 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2197 AND i.igate IN ('okhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

14425 Vimy Ridge
Alexander, AR 72002

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $619,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3700 Square Feet
Agency: Lake Hamilton Realty
Agency Phone: (501) 525-1466

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Range, Refrigerator, Garbage Disposer, Ice Maker, Oven - Double
Architectural Style: New Traditional
Construction Materials: Stone, Cedar
Cooling: Heat Pumps, Zoned A/C
Flooring: Carpet, Tile, Wood
Heating: Central Furnace, Heat Pump, Zoned
Interior Features: Security System, Window Treatments, Walk-in Closet(s), Walk-in Shower, Ceiling Fan(s), Smoke Detector, Built-ins, Washer Connection, Dryer Connection-electric, Extra Insulation, Water Heater-electric, Balcony/Loft, Whirlpool/Hot Tub/Spa, Wired For Surround Sound, Ridge Vents, Primary Bedroom W/Bath, Solid Surface Countertops
Rooms: Office, Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Kitchen, Laundry, Great Room
Security Features: Security System
Utilities: Water Available, Electricity Available

Window Features

Exterior Features: Porch, Patio, Shop, Storage Building, Rv Parking, Fenced Back Yard, Insulated Windows, Insulated Doors, Pool - In Ground, Outside Storage Area, Guttering, Partially Fenced, Chlorine
Fencing: Fenced, Back Yard, Partial
Parking Features: Garage
Other Features: Storage
Patio and Porch Features: Patio, Porch
Roof: Shingle

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: METES&BOUNDS

Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Beautifully updated sprawling two-story home, with manifold possibilities for extended-family living. Sited within 15 minutes of the Little Rock/Pulaski County area, in a forested setting exuding a rural feel, yet close to all city amenities. Two primary bedroom ensuites, one on each level, afford either a balcony or sunroom for a sanctuary from the main home activities that our entertainers paradise has to offer. Two more large bedrooms with a shared full bath round out the sleeping accommodations. Large culinary-friendly kitchen with island, boasts professional quality 66" refrigerator/freezer, double convection ovens, and an abundance of granite topped custom cabinets for ease in preparing even the most elegant meals. Whether cooling off in the 8' deep pool while relaxing under your covered back porch or warming up next to the pellet stove watching your favorite sports, you won't find a home offering a more complete year round retreat for family and friends. Private office and an extra large laundry room with built in cabinetry and half bath, make daily tasks a snap. Three car garage and a free standing 2 car garage/shop supply plenty of space for your cars and toys, and yes there is even an RV parking pad with 240 V disconnect located near by, in case you still want to travel. Set back from the road, situated on an acre of level partially fenced land, a more comfortable quality built home in pristine condition will be hard to find!
MlsNumber: --
ListingId: 145871


Listing Provided By: Lake Hamilton Realty, original listing
Phone: (501) 525-1466
Office Phone: (501) 525-1466
Agent Name: KATHI MAFFIT
Disclaimer: Copyright © 2024 Hot Springs Board 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => tulsa [3] => OK [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: tulsa State: OK Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: tulsa State: OK Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2197 AND i.igate IN ('okhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Carolyn Blecha-McClary
ASCIISolid Rock Realtors
Call Today!: (918) 639-8875

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App