Title Page Background
DEBUG FN args: Array ( [0] => 2839 [1] => [2] => [3] => agent ) BEFORE: Site: 2839 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2839 Igate: njhud LocID: 2839 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 = 2839 AND i.igate IN ('vahud','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 = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2839 [1] => [2] => [3] => lender ) BEFORE: Site: 2839 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2839 Igate: njhud LocID: 2839 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 = 2839 AND i.igate IN ('vahud','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 = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2839 [1] => [2] => [3] => other ) BEFORE: Site: 2839 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2839 Igate: njhud LocID: 2839 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 = 2839 AND i.igate IN ('vahud','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 = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

7215 Riverside Dr
Richmond, VA 23225

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,099,000
Beds: 4
Baths:
Status: Active
SqFt: --
Agency: Westham

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: Escape to a sun-filled sanctuary in this exquisite French Country-style home, just a leisurely 5-minute stroll from the James River, Pony Pasture, and trails! Upon entry, be captivated by the stunning highlights that adorn every corner of this home. High ceilings, newly refinished random width wood reflooring in most of the downstairs, plantation shutters, cast stone gas fireplace & more! The gourmet kitchen has been revamped with a Viking gas range, new double oven ('24), Bosch dishwasher ('24), LG Refrigerator/Freezer ('23), and top-of-the-line cabinetry, offering both style and functionality! The 1st floor Primary Suite will blow you away, with French doors leading to the patio and garden, two personal fitted closets, and an oversized en-suite with jetted tub! Entertain guests in the gorgeous Great Room, complete with vaulted ceilings, two ceiling fans, and French doors leading to the back and side Bluestone terraces, with two pergolas running the full width of the home! The main level also hosts a formal dining room with accent ceiling and a private office area with beautiful details such as wainscoting and French Doors for privacy! Upstairs you'll discover a loft area with custom built-ins plus 3 spacious bedrooms and a full bathroom. Storage is never an issue with 2 coat closets in the foyer, deep hidden built-ins throughout, attic space, storage below the home, and a 630+ square foot attached garage. The location of this home is a great place to retreat! Its secluded, wooded backyard is full of new plantings, mature trees and a 2020 Highlife Hot Springs Hot tub for comfort, entertainment and relaxation! Enjoy beautiful strolls along the James River, just minutes from restaurant options and grocery stores, and only a few miles from Downtown, Carytown, University of Richmond, Maymont, I-195 and more! Addtl' upgrades include fresh paint, regrouting and sealing of the patio Bluestone ('21), LG Washer and Dryer ('23), Carpet upstairs ('21), Level 2 ChargePoint Home Flex charger ('23), and Upstairs HVAC ('24)
MlsNumber: --


Listing Provided By: Westham, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Cabell Childress
Disclaimer: Copyright © 2024 Long & Foster Real Estate. 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] => chesterfield [3] => VA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: chesterfield State: VA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: chesterfield State: VA 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 = 2839 AND i.igate IN ('vahud','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 = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Sean Busch
Sean Busch
ASCIIERA Napier Realtors
Call Today!: (804) 916-0109

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App