Features & Amenities

Interior

  • Other Interior Features

    Cathedral Ceiling(s)

  • Total Bedrooms

    4

  • Bathrooms

    2

  • Above Grade Finished Area

    2488.0

  • Basement YN

    YES

  • Cooling YN

    YES

  • Cooling

    Central Air, Heat Pump

  • Fireplace YN

    NO

  • Heating YN

    YES

  • Heating

    Baseboard, Electric, Forced Air

  • Main Level Bedrooms

    1

  • Pet friendly

    Number Limit, Breed Restrictions

Exterior

  • Garage

    No

  • Construction Materials

    Wood Siding, Glass

  • Parking

    Off Street, Circular Driveway

  • Patio and Porch Features

    Deck

  • Pool

    No

  • Waterfront YN

    YES

  • View

    Water, Trees/Woods

Area & Lot

  • Lot Features

    Wooded, Waterfront

  • Lot Size(acres)

    0.34

  • Property Type

    Residential Lease

  • Property Sub Type

    Single Family Residence

  • Architectural Style

    Contemporary

Price

  • Sales Price

    $2,000

  • Sq. Footage

    2, 488

  • Price/SqFt

    N/A

HOA

  • Association

    Yes

  • Association Fee Frequency

    Monthly

  • Association Fee Includes

    N/A

School District

  • Elementary School

    N/A

  • Middle School

    N/A

  • High School

    JAMES WOOD

Property Features

  • Association Amenities

    Meeting Room, Party Room, Picnic Area, Tennis Court(s), Security, Clubhouse, Dog Park

  • Foundation Details

    Permanent

  • Senior Community YN

    NO

  • Sewer

    Public Sewer

Schedule a Showing

Showing scheduled successfully.

<
>
IN PERSON
VIA CHAT

What is 3 + 4 ?


Change time

Mortgage calculator

Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.

Your payment

Principal and Interest:

$

Property taxes:

$

HOA fees:

$

Total loan payment:

$

Total interest amount:

$

Location

County

FREDERICK

Elementary School

Middle School

High School

JAMES WOOD

Listing Courtesy of Teresa L Strohmeyer , ERA Oakcrest Realty, Inc.

RealHub Information is provided exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RealHub website owner shall not be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

Agent Andrew Boateng

AGENT

Andrew Boateng

Call Andrew today to schedule a private showing.


* Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request.© 2024 FMLS.
LIVE AT THE LAKE! SPECTACULAR WATERFRONT HOME WITH WATER VIEWS AND DOCK. Unique contemporary on lovely wooded lot. Gated community near Winchester and 90 minutes from the beltway. Enjoy all that Lake Holiday has to offer - beaches, swimming, boating, fishing, water skiing, dog park, walking trails, clubhouse with exercise room, playgrounds and basketball, tennis and volleyball courts. The property is on a wide finger, just off the main body of Lake Holiday. One-third acre wooded lot with 82 feet of lakefront. Great place for entertaining both indoors and outdoors. Large deck overlooking the water and a dock on the lake. Spacious, dramatic great room plus basement family room.  4 bedrooms, including one on main level. Walkout basement. Heat pump for heating and cooling plus baseboard electric heat. Circular driveway.  Landlords pay HOA fee. VR lease and tenant consent form required for all tenants and guarantors. Application fee $45 each. Lister to run reports, write lease. No smoking. Pets considered case-by-case.  Landlords prefer tenants with credit scores of 680+ and monthly income of at least 3x the rent. Minimum 1-year lease but 2 years preferred. Owners/agents. Fireplace and wood-burning furnace are not for tenant's use. Square footage, lot size, water frontage approximate.

237 SUNSET CIRCLE

Message successfully sent.

What would you like to know?

What is 3 + 4 ?

Rental Inquiry

Rental Inquiry

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

 - property

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

Reason for contacting?

Sign Out

Virtual Assistant

Would you like to take the next step with this property? We can help you schedule a showing or virtual tour, or send you more details.

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

Already have an account ? Login here

We use cookies

We use cookies primarily for analytics to enhance your experience. By accepting, you agree to our use of these cookies. You can manage your preferences or learn more about our cookies policy.