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

1100 Dwight Avenue
Colonial Beach, VA 22443

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $469,000
Beds: 2
Baths: 2
Status: Pending
SqFt: 1502
Agency: Coldwell Banker Elite

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1965
Notes: Like NEW, renovated June 2023! This one of a kind, 2 Bedroom, 1 bath Bungalow boast 1,502 sq. ft. and has an additional 480 sq. ft. Casita with a full bathroom. Easily host friends and family, while also providing privacy. Upon entering, you will be greeted with the white picket fence, enclosing the oversized yard (three lots). Enjoy sipping your coffee or glass of wine on the NEW 26'x10' covered deck. During the winter months, stay cozy in the enclosed porch. There is plenty of room to host your family and friends with the oversized living room and connecting dining room. Stay cool with the mini-split A/C (4 units total in main house). The two adjoining bedrooms are generous in size and provide closets in each room. Cooking is a breeze in the oversized kitchen, with plenty of counter space and new stainless appliances. Store your kitchen appliances and groceries in the expansive walk-in pantry. The large bathroom has a stand-in shower and vanity. Completing the main house is the oversized laundry room, which can also provide extra storage. <br /> The 480 sq. ft. casita is complete with engineered hardwood flooring, mini-split A/C and an oversized full bath. The possibilities are endless with this space! Use as a home office or have a separate guest room or living area. Two sheds in the backyard are great to store tools and yard equipment. With all these exceptional features and its location in the desirable Colonial Beach neighborhood, this property is one of a kind. Don't miss out on this opportunity to own a versatile property that provides for every possible need.
MlsNumber: VAWE2005812


Listing Provided By: Coldwell Banker Elite, original listing
Name: Coldwell Banker Elite
Phone: (540) 735-2600
Office Name: Coldwell Banker Elite
Office Phone: (540) 735-2600
Agent Name: Charlotte Rouse
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