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

3118 Queens Grant Dr
Midlothian, VA 23113
Faith Greenwood with Village of Midlothian, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: 6
Baths: Full: 6, ½: 1
Status: Active
SqFt: --
Agency: Village of Midlothian
Agency Phone: (888) 536-0216

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: ALL BRICK CUSTOM BUILT HOME WITH SPECTACULAR VIEW OF THE JAMES RIVER VALLEY! STUNNING MILLWORK, ARCHED DOORWAYS, GLEAMING HARDWOOD FLOORS, RAISED PANEL CABINETRY & MOLDINGS, PALLADIAN WINDOWS, SURROUND SOUND, SOARING CEILINGS AND FOUR LEVELS OF LIVING & ENTERTAINING SPACE WILL PLEASE THE MOST DISCERNING BUYER. Welcoming two story foyer w/ double closets is flanked by the formal living room w/ gas fireplace & built-ins and formal dining room. The family chef will appreciate the large kitchen w/ new quartz countertops, generous distressed finish cabinetry, stainless appliances including Wolf oven & gas cooktop, beautiful limestone island and morning room w/ access to the deck. Luxurious owners' suite w/ new hardwood floors, accent wall w/ wainscotting, two walk-in closets and a sumptuous spa bath w/ large marble shower & double vanity, enclosed water closet and linen closet. A half bath and utility room w/ sink, folding counter and cabinetry round out the main level. Front & rear staircases lead to the second floor w/ four bedrooms, all w/ direct bath access and new carpet. A balcony overlooks the foyer and great room. The third level offers a large guest suite/rec room w/ full bath, wet bar and mini fridge. Window seats offer amazing views of the James River and beyond! The walk-out basement features a curved granite bar w/ 2 mini-fridges, wine cooler & racks, kegerator, tv and is open to a sitting area w/ gas fireplace, tv and access to a covered porch. Two additional rooms can be game rooms, exercise space or a home office w/ pocket doors plus a full bath and 2 mechanical closets. Storage is plentiful in a secure 24x21 conditioned and floored space just off the rear patio. 3 car side load garage w/ pedestrian door. HVAC system is 3 zone, gas fueled. Two 50 gallon gas water heaters. Enjoy the private wooded view from the main level deck w/ stairs to the ground level patio. WELCOME HOME!
MlsNumber: --
ListingId: 2501665


Listing Provided By: Village of Midlothian, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Faith Greenwood
Disclaimer: Copyright © 2025 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

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 = 2839 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;
Real Estate Expert Photo for Rodney Baskerville
Rodney Baskerville
ASCIIUnited Real Estate Richmond
Call Today!: (804) 240-5351

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App