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

616 Cedar Run Road
Manakin Sabot, VA 23103

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,599,950
Beds: 5
Baths: 5
Status: Active
SqFt: 4659
Agency: Shaheen, Ruth, Martin & Fonville

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential
Year Built: 2003
Notes: Entertainer’s dream! Seamlessly blending traditional and contemporary features while optimizing function, this meticulously designed, flowing floorplan with 5 bedrooms, 4.5 baths sitting on over six private acres, is a luxurious retreat from today’s busy world. Soothing white walls grace the first floor and beautiful hardwood floors cover the main living areas and bedrooms, while the chef’s dream kitchen boasts a gorgeous large tile. The foyer holds a grand staircase and leads to the light-filled formal living and dining rooms. The perfectly modernized kitchen includes white custom cabinetry, quartz counters and solid quartz backsplash, oversized island with prep sink, top tiered appliances such as Thermador and Sub-Zero, Bosch dishwasher, beverage refrigerator, hot water feature on main sink, and a walk-in pantry. The kitchen extends to a dining area and family room with stone gas fireplace with doors leading to the deck and the screened porch. The second floor features wood shutters throughout. The private, primary suite boasts an impressive size, built-ins and two walk-in closets- the larger of the two is beyond spectacular – along with three ample attic areas. The boutique style primary bath has double sinks, large spa tub with tile surround, separate updated plunge shower and linen closet. 3 other bedrooms are upstairs, with attached baths and abundant closet space. 3rd floor offers a carpeted recreation room for what is desired, plus access to a walk-in attic. 5th bedroom (or office) is on the 1st floor with fully renovated full bath and closet, holding a 133 bottle wine fridge. Also on the 1st floor is a new half bath. Endless amenities abound this property but some to note are: HVAC 2022, water heaters (2021, 2023), second floor laundry room, over-sized 2-car garage, house generator, irrigation and security system, whole house water filtration system, 9+ft ceilings, fenced-in backyard area, and paved driveway with ample parking. Near Kinloch, Hermitage CC, convenient to all of Richmond's amenities.
MlsNumber: 2407922


Listing Provided By: Shaheen, Ruth, Martin & Fonville, original listing
Name: Shaheen, Ruth, Martin & Fonville
Phone: (804) 288-2100
Office Name: Shaheen Ruth Martin & Fonville
Office Phone: (804) 288-2100
Agent Name: Mahood Fonville
Disclaimer: Copyright © 2024 Central Virginia Regional Multiple Listing Service. 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