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

208 Castlebar
Fredericksburg, VA 22406
Justin Sullivan with AGS Browning Realty, original listing - (540) 659-1617

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,190,550
Beds: 6
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4225 Square Feet
Agency: AGS Browning Realty
Agency Phone: (540) 659-1617

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: Introducing Brookstone Homes newest floorplan, THE FLORIDIAN! Now Under Construction with anticipated May/June 2025 move in. 3+ acre lot on cul-de-sac in sought after Sullivan Reserve. 3 car garage. Over 6,000 finished SF. TWO OWNER SUITES in this new contemporary floorplan loaded with gorgeous upgrades. First floor master suite AND second master suite on upper level with 2 additional upper bedrooms and upper family room plus two dens in basement with 4th full bathroom. This home has it all, to include: 10' ceilings on main level, 9' ceilings on second floor and 9' ceilings in your fully finished basement. Beautiful gourmet kitchen with 10' island, open to large 23x10 light filled dining area/morning room. Full overlay maple cabinets with soft close drawers, pull out shelving, wine station, pot filler, cabinet range hood, and CAMBRIA quartz countertops. Skylights. Walk-in pantry. Upgraded lighting package. Upgraded flooring and paint package. Stone fireplace. Craftsman interior trim. First floor study. Trey ceiling in main floor master. Luxury owners' bath with large luxury shower and two shower heads, plus wall jets. Two linen closets. Dual vanities with granite tops. Get organized with your 8'x9' walk in California closet in lower master suite. Hardwood stairs with modern pickets leading up to upper level with incredible layout including jack and jill bath between bedroom/den 3&4, and 18x12 upper-level family room. Plus, the upper master luxury suite has two walk-in closets and sitting room and luxury bathroom that will take your breath away. Enclosed tub in shower with glass, private water closet and dual vanities with granite. Large acreage lot on quiet cul-de-sac street with 32x12 screened porch with composite Trex floor and grilling deck. Great incentives are tied to use of preferred lender and title company. See sales managers for additional details. Photos show floorplan and interior pictures of similar homes built that are similar but are not the same floorplan since this is a new plan.
MlsNumber: --
ListingId: VAST2035458


Listing Provided By: AGS Browning Realty, original listing
Phone: (540) 659-1617
Office Phone: (540) 659-1617
Agent Name: Justin Sullivan
Disclaimer: Copyright © 2025 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','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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;
Alex Druash
ASCIICENTURY 21 Redwood Realty
Call Today!: (571) 302-0431

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App