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

264 Holly Berry Road
Fredericksburg, VA 22406

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,175,000
Beds: 3
Baths: 4
Status: Active
SqFt: 3086
Agency: Century 21 Redwood Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential
Year Built: 2001
Notes: Welcome to this Stunning Estate Rambler that shows pride of ownership throughout! The Home sits on 3.10 wooded Acres with manicured green lawn and beautiful landscaping that flows the front of the home to the main stamped driveway which leads to the 6-car garage with lighted stone columns and a gated entry. The gorgeous front entry has large stone columns, concrete aggregate porch and sidewalk, shake siding and hardwood ceiling. Enter a grand foyer with formal Living Room to the right, ahead is the formal Dining Room with gas stone fireplace and Barn doors leading into the hallway where 2 beds and full bath await. Gourmet Chef's Kitchen includes, large SS single bowl, Granite countertops, tile backsplash with under cabinet lighting, Stainless Appliances, 2 dishwashers, Commercial Range/Oven and Stainless Steel Hood, Large Refrigerator, under cabinet Ice machine and mini refrigerator, 2 Food warmer drawers and Veggie sink with Built- Ins for lots of storage and a half bath off of the kitchen. Continue around and step down into the Large Family Room with tile heated floors, shiplap half wall w/quartz ledge on top, wet bar, quartz countertop with plenty of cabinet storage, a table area for those family game nights. Primary Suite has Large Walnut Built-ins and a door that leads to the Large deck, the Primary bath has a large walk in closet with custom built cabinets, tile heated floors, double bowl sinks, comfort height toilet w/bidet seat, enjoy the freestanding air tub with electric wall fireplace for those nights you need to relax or the large walk-in shower with rain shower head, body sprays and handheld shower. Laundry room has double bowl sink, refrigerator, front load washer/dryer and cabinets for storage with quarts countertops and a full bath with shower. Huge house garage is heated/air conditioned has 2 car lifts, SS wall cabinet and plenty of room for 6 car parking (for the car enthusiast). Unfinished basement with washer/dryer, SS utility sink, water treatment system and lots of storage or room for expanding with bathroom pipe stubs for a future bath. Enjoy your backyard gated paradise with a salt water pool 5 1/2" depth and large patio surrounding the pool and large deck overlooking the pool with a gas grill and smoker for grilling out and entertaining those summer days/nights. Paved 2nd gated entry driveway leads to the Huge detached garage and pool area. The detached garage is heated/air conditioned and has a full pool bath, 2 car lifts, SS wall cabinets for storage and parking for 8 vehicles and a paint booth, and plenty of room for tools cabinets and working on your favorite hobbies. Additional features: 2 backup generators, yard sprinklers, auto gated entry, ADT alarm system with outdoor/partial indoor cameras. A short distance to Shopping and Dining on Rt. 17 (Warrenton Road or Rt. 3 (Plank Road). Don't miss out on this Beautiful home and property, hurry and make your appointment!
MlsNumber: VAST2028654


Listing Provided By: Century 21 Redwood Realty, original listing
Name: Century 21 Redwood Realty
Phone: (703) 858-5676
Office Name: Century 21 Redwood Realty
Office Phone: (540) 659-2161
Agent Name: Andy Hicks
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 = 2912 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 Edward Burrow
Edward Burrow
ASCIIBerkshire Hathaway HomeServices Pen Fed Realty
Call Today!: (540) 993-6723

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App