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

Lot 32 Boxwood Road
Bumpass, VA 23024

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,780,410
Beds: 6
Baths: 6
Status: Active
SqFt: 5331
Agency: Carolines Realty, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: Welcome yourself home to the peace and tranquility of Waterfront living! This WATERFRONT, CUSTOM HOME is located on the private side of Lake Anna in Beautiful Mill Run! <br /> <br /> This stunning home is situated on .92 acres, in a private cul-de-sac, with gorgeous WATERFRONT views. The Walnut Grove model is enormous in size with all of the bells and whistles. Simply Home is a high-end, high-quality builder located in Fredericksburg, Virginia. This featured model is loaded with upgrades to include 5331 finished sq. ft., two-car garage with courtyard driveway, Hardie plank siding with stone over exposed front foundation with cedar details, Whirlpool Energy Efficient Stainless-Steel Appliances, Granite in kitchen and all bathrooms, Great room with 42" gas fireplace with marble surround, a waterfront, screened in porch with Trex flooring and ceiling fan, waterfront Trex deck (304 sq. ft.) with vinyl white railing. The First Floor Waterfront and Spacious Owners Suite features a bay window as well as a Luxurious Owner's bath with free standing tub! Coffered ceiling in Great Room, Tray Ceiling in Formal Dining, Beautiful Pella Windows throughout with 16' x 6'8" 4-Panel Sliding Doors in Great Room! Walk out of your beautiful, fully finished basement and enjoy more gorgeous views! Basement includes Wet Bar Rough Ins, Recreation Room, Bedroom with Walk in Closet, Full Bath with Tub, Home Office and Media Room. Home is set back 120 ft from the road to provide a peaceful, private and tranquil Lake Retreat! Mill Run Community is meticulously cared for with a wonderful, gated and waterfront common area. The common area includes a boat launch, pavilion with outdoor fireplace, picnic areas and community restrooms. Lake Anna is roughly 72 miles south of Washington, DC, and is one of the largest freshwater inland reservoirs in Virginia (13,000 acres). Enjoy restaurants, wineries, breweries, live music, putt putt golf, boat rentals, skiing, fishing, tubing and many other activities. <br /> <br /> PHOTOS ARE FOR ILLUSTRATION PURPOSES ONLY. <br /> <br /> This HOA is short term rental approved. Buy now and customize your selections! TO BE BUILT! <br /> <br /> PRICES & OPTIONS ARE SUBJECT TO CHANGE WITHOUT NOTICE! <br /> <br /> BOAT HOUSE AND DOCK ARE AVAILABLE AS OPTIONS! (NOT INCLUDED IN PRICE)
MlsNumber: VALA2005564


Listing Provided By: Carolines Realty, LLC, original listing
Name: Carolines Realty, LLC
Phone: (804) 363-4613
Office Name: Lando Massey Real Estate
Office Phone: (804) 363-4613
Agent Name: Ann-Marie Jewell
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','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 Londie Blesi
Londie Blesi
ASCIIColdwell Banker Elite
Call Today!: (804) 433-9989

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App