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

5637 Mcclellan (10 Acres) Road
Mechanicsville, VA 23111

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $849,000
Beds: 3
Baths: 2
Status: Active
SqFt: 2419
Agency: Olympian Properties, LLC.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 2004
Notes: One Of A Kind Opportunity With This Private Luxury FARM! 10 Level Open ACRES With Wooded Perimeter*Located Less Than 10 Minutes Off Interstate 295 Near New Kent County Line*Zoned Agriculture*Bring Your Horses*Over 500’ Hard Surface Rd Frontage*Approx. 880 Linear Ft & Over 11,000 SqFt Double Width Cement Drive Connects Home & Garage To Road Entrance*5,000 SqFt Steel Garage Warehouse Is Insulated/Heated/Cooled W/Heatpump & Gas Furnace. Garage measures 50’ x 1000’ W/Approx. 20’ Ceiling & Includes A Separately Enclosed 14’ x 13’ Office/Lounge W/Half Bathroom, A Charging Outlet For Electric Vehicles, 125 Amp Electric Service Panel, Both Walkup & Walk-In Storage Space, 2 Pedestrian Doors (1 Entrance Door Near Office & 1 Inside To Separate Both Sides), 3 Ten Foot Tall Aluminum Drive Through Rollup Doors (1 At Each End & 1 In The Middle Of Building), Exterior Attached Toolshed W/Air Compressor Rough In, Exterior Planting/Potting Station With 4’ Water Spigot. The All Brick Maintenance Free Williamsburg Styled Ranch Features; 1 Level Living, Hip Roof, Double Gabled Front Elevation With Brick Coined Detailing, Recessed Covered Cement Porch, 3 Bedrms, 2 Full Double Vanity Baths, Vaulted Ceiling Great Room W/Gas FP, Polished Harwood Floors, New Carpeting, New Heatpump, New Windows, New Stainless Kitchen Appliances, New Ceiling Fans, Laundry/Office Room, Eat-In Kitchen With Separate Dining Area, Expansive 10’ Chefs Island Serving Station, Sunroom W/French Door To Several Entertainment Patios, Main Bedroom Offers En Suite Bathrm W/100 Gallon Jetted Garden Soaking Tub, Walk-In Shower, Large 11x5 Lighted Walk-in Closet, Natural Lighting Throughout, Gas Hybrid HVAC System, 400 AMP Electric Service Panel, Artesian Deep Well Provides Delicious Water, 2 Pull-down Attics Offer Extra Storage, Built In Ceiling & Exterior Patio Speakers, Home Faces Eastern & Western Directions For Incredible Sunrise & Sunset Views, Watch Deer Graze In The Back Meadow, Excellent Soil For Those Famous Hanover Tomatoes!
MlsNumber: 2414874


Listing Provided By: Olympian Properties, LLC., original listing
Name: Olympian Properties, LLC.
Phone: (804) 564-9842
Office Name: Olympian Properties, LLC
Office Phone: (804) 564-9842
Agent Name: Deborah Peaks
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.


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 = 2861 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 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;
Kenny Dunn
ASCIIVirginia Capital Realty
Call Today!: (804) 774-5772

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App