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

235 Sir Walter Drive
Bumpass, VA 23024
Ashley Hoffman with Lake Anna Island Realty, original listing - (540) 894-4400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,600,000
Beds: 4
Baths: Full: 4, ½: 2
Status: Active
SqFt: 5366 Square Feet
Agency: Lake Anna Island Realty
Agency Phone: (540) 894-4400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Take a glimpse into unparalleled waterfront excellence at Lake Anna, Virginia. This exquisite recently-constructed tribute to lakeside opulence truly has no match. Overlooking the private side of Lake Anna, the builder of this impressive custom-built oasis has spared no expense; this 5,000+ square foot waterfront fortress exudes luxury living and meticulous craftsmanship in every corner. Make entry through the massive custom wood doors to discover soaring 20+ foot ceilings, massive windows showcasing your water views, 7 1/4 inch-wide French white oak wood plank flooring, gorgeous fixtures, and large open spaces. The cavernous great room openly transitions into an oversized gourmet kitchen with a massive center island that displays an electric fireplace with blower, exquisite quartz countertops, a tremendous built-in coffee bar framed in custom trim, and stunning high-end Italian stainless appliances. The 6 burner gas stove with griddle, high-end black cabinetry, and champagne hardware set the tone, along with your luxurious walk-in pantry that features wood countertops, white cabinets, and a full size beverage cooler. The large primary bedroom has stunning 10 foot ceilings, en suite bathroom with double vanity, incredible standalone soaking tub, a marble-tiled walk-in frameless shower with rainfall and handheld shower heads, and enormous adjoining custom walk-in closet that is larger than most bedrooms, offering custom shelving and a center island with drawers. There is one additional bedroom on the main level, a full bath, half bath and laundry. The finished walkout basement features a large main space perfect for a family room/rec area and a separate flex room with wet bar / kitchenette, that could make a great movie room or be converted easily into a fifth bedroom. There are two additional lakeside bedrooms, each with their own private full bathroom and walk-in closet. The downstairs level also includes a second attached garage with lake-facing entry, perfect for storing boats, water toys, lawn equipment or other personal property. Park your vehicles in your oversized (1,188 square foot) opulent attached garage with showroom mirror-polished floors, and large room above that could be finished into an apartment or bonus room. Your nearly-flat, park-like backyard gently connects with your 125+/- feet of shoreline at the lake in a no wake cove, where your large, double-decker 2,000+ square feet, two-slip boathouse with electric lifts was recently constructed, including a screened room, storage, and a massive second level sun deck for sunbathing, good times and entertaining your family and friends. It doesn't get any better than this. Come see for yourself and make the move to elevate your lifestyle at Lake Anna. Short term rentals are permitted and this retreat would make a high income-producing investment asset. See projected rental revenue in MLS documents!
MlsNumber: --
ListingId: VALA2006620


Listing Provided By: Lake Anna Island Realty, original listing
Phone: (540) 894-4400
Office Phone: (540) 894-4400
Agent Name: Ashley Hoffman
Disclaimer: Copyright © 2024 Bright MLS. 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 = 2874 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;
Angelica DelliCarpini
ASCIIDF Real Estate & Land Resources, LLC
Call Today!: (804) 569-5115

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App