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

1915 Carter Road
Lanexa, VA 23089

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,499,999
Beds: 3
Baths: 4
Status: Active
SqFt: 3473
Agency: Long & Foster R E

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 25 acre(s)
Property Type: Residential
Year Built: 2002
Notes: Ultimate Privacy on 25 Picturesque Acres with 2900 feet of Water Frontage on Diascund Creek & home to Unbelievable Wildlife and Excellent Fishing. Sprawling Custom Rancher with a Serene View of the Creek from Most Rooms boasts 3,473 sq feet filled with Custom Upgrades and Finishes to include Vaulted Ceilings in multiple rooms, New Lighting, Anderson Windows & Doors, Custom High Quality Cabinetry throughout, Stone 2 Sided Fireplace, Soaring Windows for Natural Light, Very Large Rooms, Fresh Paint, Top of the Line Black Stainless Steel Appliances, Smart Home Connected, New Roof, 17 x 14 Screened Porch w/Dumbwaiter for Wood, Extensive, Maintenance Free Deck w/Trex, Paver Patio, Irrigated Lawn, 2 New HVAC Units, Whole House Generator just serviced, & a 2 Car Oversized Garage w/new Bluetooth enabled openers, & a Shower & Mud Sink. For Your Guest or Investment Potential is the Quaint Creekside Cottage offering 1 Bedroom, 1 1/2 baths, Living Room, Kitchen, New Deck, New Roof, Whole House Generator just serviced, Fresh Paint, & 3 Car Attached Garage w/new Bluetooth enabled openers. At the Waters Edge is a Boat House with 3 Boat Lifts, 1 New Jet Ski Lift, An Entertaining Deck with Storage, Rip Rap Shoreline, Retaining Wall, an Add’l Deck, Small Floating Dock with Swim Ladder, 3 Floating Jet Ski Docks, & a Private Boat Launch to 12+ feet of Water. Let’s not forget about the 30 x 70 Barn/Workshop w/Lean To - (2) 12 x 12 Custom Built Horse Stalls & a Wash Stall, Tack Room, Kitchen, 2 Garage Doors, Shelving, Water & Electricity, & Pasture w/Polymer Fence & Hot Wire. Last but not least - Detached Shed and Pole Barn. Property is located 15 minutes to Williamsburg & 30 minutes to Richmond Airport.
MlsNumber: 2403882


Listing Provided By: Long & Foster R E, original listing
Name: Long & Foster R E
Phone: (804) 328-5500
Office Name: Long & Foster REALTORS
Office Phone: (804) 328-5500
Agent Name: Jena Simpson
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