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;

736 Marshall Avenue
Colonial Beach, VA 22443

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,995
Beds: 3
Baths: 2
Status: Active
SqFt: --
Agency: INK Homes and Lifestyle

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1994
Notes: ****UNIQUE TURN KEY OPPORTUNITY**** <br /> KEEP AN EYE OUT FOR WHEN THIS GOES ACTIVE <br /> MORE PHOTOS AND DETAILS COMING<br /> <br /> Exquisite Turn-Key Home in 'The Point' – Colonial Beach, Virginia<br /> <br /> Experience luxury and comfort in this beautifully remodeled 3 bedroom, 2 full bath home located in the charming area of 'The Point' in Colonial Beach. This splendid property comes with an attached garage and boasts stunning hardwood floors throughout.<br /> <br /> A new roof installed in 2017 adds to the value and peace of mind for this home.<br /> <br /> Step outside to relax on a high-end covered deck, perfect for soaking up the sun. The home is offered fully furnished, featuring solid wood Amish furniture, elegant rugs, stylish lamps, and tasteful wall decor. The kitchen has been completely updated to include all the modern conveniences, complemented by a new set of cookware, cups, and plates—making it truly ready for immediate occupancy.<br /> <br /> Ideal as a primary residence, a serene second home, or a lucrative Airbnb opportunity, this property also includes a like-new 2016 golf cart, perfect for quick trips to the beach or exploring the neighborhood.<br /> <br /> Outdoor enthusiasts will appreciate the top-tier outdoor furniture, enhancing your living and entertaining space.<br /> <br /> Everything in this immaculate home will convey with a full-price offer, ensuring a seamless and hassle-free transition to your new life in 'The Point'. Don’t miss this opportunity to own a piece of paradise!
MlsNumber: VAWE2006534


Listing Provided By: INK Homes and Lifestyle, original listing
Name: INK Homes and Lifestyle
Phone: (540) 735-4992
Office Name: INK Homes and Lifestyle, LLC.
Office Phone: (540) 372-7777
Agent Name: Alexander Wilson
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