Title Page Background
DEBUG FN args: Array ( [0] => 2921 [1] => [2] => [3] => agent ) BEFORE: Site: 2921 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2921 Igate: njhud LocID: 2921 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2921 AND i.igate IN ('vahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2921 [1] => [2] => [3] => lender ) BEFORE: Site: 2921 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2921 Igate: njhud LocID: 2921 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2921 AND i.igate IN ('vahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2921 [1] => [2] => [3] => other ) BEFORE: Site: 2921 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2921 Igate: njhud LocID: 2921 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2921 AND i.igate IN ('vahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

Tbd Lot 31 Circle Circle Lane
Colonial Beach, VA 22443

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $359,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1552 Square Feet
Agency: CENTURY 21 New Millennium
Agency Phone: (540) 373-2000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: GREAT LOCATION!! House is to be build Similar to the Pictures and NOT EXACTLY Only 35 Minutes to Dahlgren ,35 Minutes to Bowling Green /A.P. Hill ,and under a Hour of Driving to Fredericksburg. Easy access to Maryland via Harry Nice Bridge .Located in the boating community of Placid Bay Estates a Friendly Golf Cart Community with/optional Civic Association 1,552 square feet of living space on one floor with 3 bedrooms and 3 baths. Entry into the home from the front porch features access into the two secondary bedrooms and shared hall bath. Both bedrooms feature window views and ample closet space while the shared bath offers a tub/shower combination, a toilet area and vanity. Located diagonally across the floor plan is the owner’s suite with a spacious bedroom and an ensuite bathroom with both a garden tub and separate shower. Additionally, there are dual vanities, a compartmentalized toilet room, and a linen closet before stepping into the walk-in closet. The main living areas consist of a large open space that includes a family room, a dining room with sliders to the outdoor12x16 Covered Deck .Kitchen with an angled island and corner walk-in pantry.Some of the Upgrades are. Tile Walls in Bathrooms ,Luxury Vinyl Planks in Living Room ,Dining Room and Kitchen ,Stainless Steel Appliances Granite Counter Top and Recessed Lighting Voluntary Civic Association fee includes the use of Boat Ramp, Community Center, Picnic grounds and access to fresh water lakes and a Fishing Pier and Access to Potomac River via Mattox Creek . Purchaser still has time to pick all Interior Finishes .Completion date September/ October 2024 Real Estate Agent Related to Seller
MlsNumber: --
ListingId: VAWE2006560


Listing Provided By: CENTURY 21 New Millennium, original listing
Phone: (540) 373-2000
Office Phone: (540) 373-2000
Agent Name: John Denes
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App