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;

1400 Cedarbluff Drive
Henrico, VA 23238

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,900
Beds: 4
Baths: 3
Status: Pending
SqFt: 3349
Agency: Richmond Equity Ventures, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1975
Notes: Welcome to your picture-perfect oasis in the Canterbury neighborhood of Tuckahoe! This stunning home, nestled in an idyllic yet convenient location, has been meticulously updated and renovated to offer the ultimate in modern luxury and comfort. Pulling into the u-shaped drive, you will be taken aback by the spacious lot and lush greenery of the yard. Inside, you'll find gleaming wood floors throughout the main level, complemented by fresh paint that breathes new life into every room. The heart of the home, the kitchen, boasts quartz countertops, refinished cabinets, new backsplash, and flooring, creating a stylish and functional space for culinary adventures. From the informal dining space, step through the elegant French doors onto the newly refinished deck, where you can enjoy seamless indoor-outdoor living and soak in the tranquil surroundings. Retreat to the primary suite with its spacious walk-in closet and ensuite bath, complete with a new granite vanity countertop. With two fireplaces and recessed lighting in the living room, den, and basement, you'll always find the perfect ambiance to relax or entertain. Stay active and healthy in the full gym, featuring specialized flooring for your workouts (or playroom!). And when it's time to unwind, head to the large finished area of the basement, where you'll find additional living space perfect for movie nights or game days. Outside, the large corner lot offers endless possibilities for outdoor enjoyment, while the freshly refinished deck provides the ideal spot for al fresco dining and gatherings. Additional updates include new vinyl siding, ceiling fans in all bedrooms and living areas, and a new chandelier in the dining room. Plus, with two-zone central air, comfort is guaranteed year-round. Don't miss this opportunity to own a truly exceptional home in Tuckahoe – schedule your showing today and start living the life you've always dreamed of! Check out the Matterport tour linked to this listing!
MlsNumber: 2408508


Listing Provided By: Richmond Equity Ventures, LLC, original listing
Name: Richmond Equity Ventures, LLC
Phone: (804) 282-5901
Office Name: Keller Williams Realty
Office Phone: (804) 282-5901
Agent Name: Brad Ruckart
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