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;

88 Colonial Drive
Montross, VA 22520
Susan E Johnson with CENTURY 21 New Millennium, original listing - (540) 373-2000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $748,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2496 Square Feet
Agency: CENTURY 21 New Millennium
Agency Phone: (540) 373-2000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: NESTLED AMONG ROLLING HILLS AND TREES LOCATED ON LAKE INDEPENDENCE, THIS LOG CABIN HOME IS MOVE IN READY, I MEAN MOVE IN READY. ALL YOU NEED IS YOUR CLOTHES TO ENJOY THE RELAXING BREATH-TAKING HIDEAWAY ON THE LAKE. THIS 3 BEDROOM, 2 BATH LOG CABIN BOASTS 2,496 SQUARE FEET OF LIVING SPACE, ALONG WITH AN UNFINISHED BASEMENT OF 996 SQUARE FEET FOR PLENTY OF STORAGE OR FAMILY GAME ROOM OR BOTH. THE MAIN ROOM OF HOME HAS A FLOOR TO CEILING STONE FIREPLACE WITH GAS LOGS. THE ENSUITE MASTER BEDROOM IS ON THE MAIN FLOOR, WITH TWO GUEST BEDROOMS UPSTAIRS WITH FULL BATH. THE KITCHEN AREA BOAST AN ISLAND WITH A JENN-AIR STOVE, STAINLESS STEEL APPLIANCES, CABINETS, AND OPEN SHELVING, LEADING INTO SPACIOUS DINING ROOM AREA. THE SELLERS ARE CONVEYING MOST OF THE UNIQUE DECOR THEME FURNISHINGS OF THE HOME. THE OUTSIDE AREA INCLUDES FIRE PIT, WRAPAROUND DECK, STAIRS DOWN TO LAKE AND BOAT RAMP WITH THE JON BOAT WITH MOTOR THAT WILL CONVEY. THERE IS A PRIVATE SMALL BEACH AREA ON THE LAKE WHICH IS YOURS ONLY. PROPERTY CONSISTS OF TWO LOTS 56 and 57. TOTAL ACREAGE IS 1.0885 THE AMENTIES THROUGHOUT THE COMMUNITY INCLUDE CLUBHOUSE, SWIMMING POOL, TENNIS AND PICKLE BALLS COURTS, BASKETBALL COURT, TOT LOT, WITH NEARBY LARGE PAVILION. COMMUNITY HAS A MARINA ON THE POTOMAC WITH BOAT SLIPS (CHECK FOR AVAILABILITY) AND FISH PREP STATION. KAYAKS ARE AVAILABLE FOR RENTALPURPOSES. LAKE INDEPENDENCE AND POTOMAC RIVER (SHARK TOOTH) BEACHES WITH PICNIC TABLES AND GRILLS.
MlsNumber: --
ListingId: VAWE2007440


Listing Provided By: CENTURY 21 New Millennium, original listing
Phone: (540) 663-2000
Office Phone: (540) 373-2000
Agent Name: Susan E Johnson
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 = 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;
Real Estate Expert Photo for Christa Rorrer
Christa Rorrer
ASCIIEXIT Realty Expertise
Call Today!: (540) 760-1479

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App