CHARIS REALTY GROUP

Colonial

1002 LANDRAMS RETREAT

FREDERICKSBURG , VA 22401

MLS#: VAFB117142

$699,900

Status: Closed
Listing number: VAFB117142
Listing provided by: Coldwell Banker Elite
Listing agent phone: None
Last update: 1 year, 7 months ago
On site: 5 years ago
Browse Properties
ESTATES OF IDLEWILD - Residential

Property

Beds

4

Full Baths

4

1/2 Baths

1

Year Built

2008

Sq.Footage

6,658

An absolutely stunning home in The Estates of Idlewild. Over 6,600 finished square feet over three levels. The builder spared no expense as this custom home boasts with amazing upgrades throughout. The elegant two-story foyer sets the stage for this home as you enter. Prodigious first floor master bedroom, master sitting room, and master bathroom. Great open concept floor plan with the kitchen overlooking the massive two-story family room. Gourmet kitchen with GE Profile SS appliances, including a built-in coffee maker, warmer drawer, wall microwave/oven combo, wine cooler, and a gas cooktop with SS range hood. Hardwood and ceramic throughout the first floor. Beautiful moldings, tray ceilings, and two story features throughout. Huge Composite deck off of the first floor that leads down to a screened in porch with beautiful brick hardscape. The basement offers a huge wet bar, amazing theatre room, home gym, full bathroom, storage, and a huge rec room with walkout access to the screened in porch. Concrete driveway leads to a side-load three car garage. Great location that is easily accessible from Route 3 and Route 1 for amazing convenience to downtown Fredericksburg and I-95.

Features & Amenities

Interior

  • Other Interior Features

    Central Vacuum, Recessed Lighting, Walk-In Closet(s), High Ceilings

  • Total Bedrooms

    4

  • Bathrooms

    4

  • 1/2 Bathrooms

    1

  • Above Grade Finished Area

    4131.0

  • Basement YN

    YES

  • Cooling YN

    YES

  • Cooling

    Central Air, Zoned

  • Fireplace YN

    YES

  • Heating YN

    YES

  • Heating

    Natural Gas, Forced Air, Zoned

  • Main Level Bedrooms

    1

  • Pet friendly

    N/A

Exterior

  • Garage

    Yes

  • Garage spaces

    3

  • Construction Materials

    HardiPlank Type, Stone

  • Parking

    Concrete, Attached

  • Patio and Porch Features

    Deck

  • Pool

    No

  • Waterfront YN

    NO

Area & Lot

  • Lot Size(acres)

    1.09

  • Property Type

    Residential

  • Property Sub Type

    Single Family Residence

  • Architectural Style

    Colonial

Price

  • Sales Price

    $699,900

  • Tax Amount

    $5,271

  • Sq. Footage

    6, 658

  • Price/SqFt

    $105

HOA

  • Association

    Yes

  • Association Fee

    $200

  • Association Fee Frequency

    Quarterly

  • Association Fee Includes

    N/A

School District

  • Elementary School

    HUGH MERCER

  • Middle School

    WALKER GRANT

  • High School

    JAMES MONROE

Property Features

  • Senior Community YN

    NO

  • Sewer

    Public Sewer

  • Tax Lot

    2

  • Water Source

    Public

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

FREDERICKSBURG CITY

Elementary School

HUGH MERCER

Middle School

WALKER GRANT

High School

JAMES MONROE

Listing Courtesy of Paul Douglas Janney , Coldwell Banker Elite

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.

(571) 342-1160

andyselldreamhomes@hotmail.com


* 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.
An absolutely stunning home in The Estates of Idlewild. Over 6,600 finished square feet over three levels. The builder spared no expense as this custom home boasts with amazing upgrades throughout. The elegant two-story foyer sets the stage for this home as you enter. Prodigious first floor master bedroom, master sitting room, and master bathroom. Great open concept floor plan with the kitchen overlooking the massive two-story family room. Gourmet kitchen with GE Profile SS appliances, including a built-in coffee maker, warmer drawer, wall microwave/oven combo, wine cooler, and a gas cooktop with SS range hood. Hardwood and ceramic throughout the first floor. Beautiful moldings, tray ceilings, and two story features throughout. Huge Composite deck off of the first floor that leads down to a screened in porch with beautiful brick hardscape. The basement offers a huge wet bar, amazing theatre room, home gym, full bathroom, storage, and a huge rec room with walkout access to the screened in porch. Concrete driveway leads to a side-load three car garage. Great location that is easily accessible from Route 3 and Route 1 for amazing convenience to downtown Fredericksburg and I-95.

1002 LANDRAMS RETREAT

Message successfully sent.

What would you like to know?

What is 3 + 4 ?

Related Properties

NEW LOTS JUST RELEASED!!!! - FABULOUS NEW FLOORPLAN -- SAMPLE LISTING AT BASE PRICE -- The TOULOUSE features an open floorplan with a main floor bedroom and full bath suite. Upper level features Large Primary bedroom with huge walk-in closet and well appointed full bath with seated shower and double vanity; plus 3 additional bedrooms, Loft with overlook and upper level laundry. Choose the optional finished lower level for even more space with rec room and den/bedroom with full bath. OR, add the optional covered porch for wonderful outdoor living area. Make this home your own! Rocky Run Village is a beautiful community of new homes in Fredericksburg, Virginia offering 104 single family homes for sale within Stafford County. Conveniently located off route 17, easy access to a wealth of shopping and dining options. Enjoy being less than 5 miles from I-95, major commute route, and 6 miles from the VRE. Each home is offered in one of our new interior design Looks: Loft, Farmhouse, Classic or Elements for on-trend style in your new home. Prices and terms subject to change***location premiums may apply. PHOTOS/RENDERINGS REPRESENTATIVE ONLY - MAY SHOW OPTIONS, UPGRADES OR DECORATOR ENHANCEMENTS.
#VAST2033374

FREDERICKSBURG

04 BROAD LAKE DRIVE

5 Beds

3 Baths

3,543 Sq.Ft.

$699,990

MLS#: VAST2033374

Beautiful Single-Family Home in Celebrate Virginia! Located in 55+ community, this stunning home offers elegance, comfort, and plenty of space. The main level features gleaming hardwood floors, a gourmet kitchen with stainless steel appliances, a breakfast room, and a separate dining area. The family room boasts a decorative fireplace, with access to the Trex deck with views of the private backyard. Grand primary suite includes an ensuite bath with dual vanities, soaking tub, shower, water closet, and a large walk-in closet with built-ins. Also on the main level is an additional bedroom with hallway bath access, a private office with glass French doors, and laundry. The basement is fully equipped for living and entertaining with brand-new carpet, a large rec room with backyard access, a bedroom, full bath, bonus room, and an unfinished utility room with ample storage Additional highlights include a 2-car garage with driveway parking and a location directly across from the community recreation center. Enjoy access to indoor/outdoor pools, a gym, clubhouse, party room, and a variety of resident clubs — everything you need for an active and social lifestyle!
#VAST2044212

FREDERICKSBURG

9 MONTERA AVENUE

3 Beds

3 Baths

2,060 Sq.Ft.

$633,000

MLS#: VAST2044212

NOW SELLING - FABULOUS NEW FLOORPLAN -- SAMPLE LISTING AT BASE PRICE -- The Canterbury features an open floorplan with a main floor bedroom and full bath suite. Upper level features Large Primary bedroom with huge walk-in closet and well appointed full bath with seated shower and double vanity; plus 3 additional bedrooms, Loft with overlook and upper level laundry. Choose the optional finished lower level for even more space with rec room and den/bedroom with full bath. OR, add the optional covered porch for wonderful outdoor living area. This home is a must see! Rocky Run Village is a beautiful community of new homes in Fredericksburg, Virginia offering 104 single family homes for sale within Stafford County. Conveniently located off route 17, easy access to a wealth of shopping and dining options. Enjoy being less than 5 miles from I-95, major commute route, and 6 miles from the VRE. Each home is offered in one of our new interior design Looks: Loft, Farmhouse, Classic or Elements for on-trend style in your new home. Prices and terms subject to change***location premiums may apply.
#VAST2033334

FREDERICKSBURG

01 BROAD LAKE DRIVE

5 Beds

3 Baths

2,737 Sq.Ft.

$649,990

MLS#: VAST2033334

Nestled in the private and picturesque enclave of Hartwood, this exceptional residence offers refined living in a serene, natural setting. Just six years young and impeccably maintained, the home presents as virtually brand new and is perfectly positioned on a flat 1.5-acre lot, surrounded by mature forests and over 30 acres of protected land—ensuring remarkable privacy and a tranquil backdrop. Designed for both elegance and comfort, the open-concept layout flows effortlessly between the expansive family room, sun-drenched sunroom, and a dedicated dining space. At the heart of the home is a stunning gourmet kitchen, thoughtfully appointed for elevated entertaining and everyday luxury living. The primary suite is a private retreat, featuring a spacious walk-in closet and a spa-inspired bathroom that invites relaxation. With two additional generously sized bedrooms with large closets, there are plenty of options for family members and guests alike. The large unfinished basement offers endless possibilities, with rough-in plumbing already in place and initial framing completed making it ideal for future bedrooms, a home theater, rec room, or custom living spaces tailored to your lifestyle. This home is enhanced with an impressive array of modern upgrades, including a whole-home water treatment system, whole-home humidifier with summer bypass, and a 30-amp generator plug with transfer switch and dedicated breaker panel. Advanced security includes POE exterior cameras with a professionally designed NVR system housed in the home office, providing continuous recording and smartphone alerts. Smart-home features seamlessly control lighting and ceiling fans in main living areas, exterior lighting, thermostat, and front door lock. While this location is tucked away from it all, it is also just minutes away from modern conveniences including shopping, restaurants, commuter parking, and the interstate. Prefer the outdoors? Curtis Park is just 2 miles away and offers a public pool, playgrounds, fishing at Curtis Lake, walking trails, disc golf, a skate park, and the par 72, 6,900 yard Gauntlet Golf Club. Offering sophisticated amenities, thoughtful upgrades, and an unparalleled natural setting, this Hartwood home delivers luxury, privacy, and timeless appeal in one exceptional package.
#VAST2045544

FREDERICKSBURG

245 SADDLE RIDGE LANE

3 Beds

2 Baths

2,108 Sq.Ft.

$755,000

MLS#: VAST2045544

Fully Remodeled Downtown Gem – Prime Location Across from Mary Washington University. Completely rebuilt from the ground up, this beautifully renovated 1.5-level home offers modern comfort in the heart of Downtown Fredericksburg. Designed with an open-concept floor plan, the home features 36” wide doorways and a handicap-accessible ramp for enhanced accessibility and ease of living. Every detail has been thoughtfully updated, including brand-new flooring, roof, HVAC system, kitchen, bathrooms, appliances, and fresh interior paint. Elegant crown molding throughout adds a refined finishing touch. The exterior is just as impressive, with a newly installed stamped concrete driveway and entrance, plus convenient rear access from the back alley. Enjoy true walkable downtown living with immediate access to the University, local shops, cafés, restaurants, historic sites, parks, the Rappahannock River, and major commuter routes. Move-in ready. Modern updates. Unbeatable location.
#VAFB2009390

FREDERICKSBURG

1407 SUNKEN ROAD

3 Beds

2 Baths

1,268 Sq.Ft.

$569,900

MLS#: VAFB2009390

Come see this beautiful home that has been meticulously maintained, with all major upgrades already completed. The property features custom stonework throughout the exterior and a spacious open layout with newly replaced flooring. Situated on 5.5 acres, this home offers plenty of room to relax and enjoy the outdoors. Recent upgrades include new siding, a new HVAC system, water pressure tank, water filtration system, well pump, water heater, roof, gutters and new decking. A brand-new, never-used gazebo conveys with the property. Ideally located just outside of town, the home offers convenient access to shopping, dining, and amenities in Fredericksburg, Locust Grove, and Culpeper area. This move-in-ready property combines comfort, privacy, and convenience—don’t miss this opportunity.
#VASP2039206

FREDERICKSBURG

10006 ELYS FORD ROAD

3 Beds

3 Baths

3,116 Sq.Ft.

$630,000

MLS#: VASP2039206

Nestled in the serene community of Summerset Ridge South on the banks of the Rappahannock River, this stunning 6-bedroom, 3.5-bathroom home offers a perfect blend of modern comfort, outdoor adventures and traditional charm. Built in 2021, the residence features a classic Colonial design with HardiPlank siding, ensuring durability and timeless appeal. Step inside to discover an inviting open floor plan that seamlessly connects the gourmet kitchen, complete with stainless steel appliances, a spacious island, and a cozy breakfast area, to the family room, where a warm fireplace beckons for gatherings. The formal dining room adds an elegant touch for special occasions, while the walk-in closets and ample pantry space cater to your storage needs. The fully finished basement, with daylight windows and a walkout entrance, provides additional living space, perfect for a home theater or play area. Enjoy the tranquility of your 3.01-acre lot, which backs to lush trees and features a peaceful stream, creating a private oasis for relaxation and outdoor activities. The back of the lot abuts the Fredericksburg Watershed Property – huntable public land along the Rappahannock River under permanent protection from development. Take a walk through the woods to enjoy time on the Rappahannock River for fishing, SUP, kayaking, splashing, or skipping rocks. Step out your back door onto the expansive deck and porch and savor morning coffee or evening sunsets while overlooking the picturesque views of the garden and woods. With an attached two-car garage and a well-maintained gutter system, this home combines convenience with nature's beauty. Experience the perfect blend of comfort, style, and nature in this exceptional property—your dream home awaits!
#VAST2045920

FREDERICKSBURG

85 HOPEWELL DRIVE

5 Beds

3 Baths

3,947 Sq.Ft.

$799,900

MLS#: VAST2045920

Move in Ready! Welcome to 15214 Spotswood Furnace Rd, a five-bedroom, two-full-bathroom ranch-style home with a spacious detached two-car garage and nearly one acre of land. The interior has been freshly painted throughout, and the beautiful updated kitchen features stainless steel appliances, a butcher block counter, a new farmhouse sink and new cabinets. The spacious living room invites natural light, creating a warm and welcoming atmosphere. The entire house has undergone a comprehensive renovation, including the installation of new lighting fixtures and flooring. Additionally, all new electrical work has been completed. The finished basement offers two bedrooms with ample space for a home gym, office, storage room or recreation room. Step outside onto the deck to savor your morning coffee, host a barbecue, or simply unwind while taking in the serene beauty of the outdoors and tranquil surroundings. Recent updates include the roof, siding, HVAC system, water heater, and septic system. Conveniently located just moments off Route 3, this home is situated near shopping centers, Publix, Riverbed High School, Mary Washington Emergency Room, Spotsylvania Hospital Emergency Room, historic battlefields, and access to the Hunting Run Reservoir and Rapidan River.
#VASP2038070

FREDERICKSBURG

15214 SPOTSWOOD FURNACE ROAD

5 Beds

2 Baths

3,032 Sq.Ft.

$577,000

MLS#: VASP2038070

Colebrook Estates is home to 1-acre homesites near downtown Fredericksburg with easy access to I-95. The Carlisle Floorplan is a beautiful 4-bedroom, 2.5-bath home with up to 3,789 square feet of living space. This single-family home design features an open floor plan, highlighted by a spacious great room, a light-filled kitchen, and a breakfast area. There is also an option for a sunroom extension to provide additional living space. The flex space is an ideal space for a study, playroom, or den. On the second floor, you'll find 4 bedrooms and 2 bathrooms, including a large owner's retreat with a private bath and a walk-in closet, as well as a conveniently located laundry area. You can also choose to add a fully finished basement and a 2-3 car garage. Customize this home to meet your family's needs today!
#VAST2040370

FREDERICKSBURG

7 HILLSDALE DRIVE

4 Beds

2 Baths

3,934 Sq.Ft.

$683,990

MLS#: VAST2040370

Model Home for sale! Colebrook Estates is located in the desirable Falmouth/White Oak area of Stafford County. The Somerset model features an open floor plan with a sunroom extension, flex space for an office or playroom, and luxury vinyl plank flooring throughout the main level. The kitchen is equipped with stainless steel Samsung appliances, upgraded cabinets, and quartz countertops. Enjoy outdoor living with a 10x18 composite deck off the rear sunroom extension. The upper level includes 4 bedrooms and 3 full baths. The owner's suite boasts a deluxe bathroom with a rain shower and soaking tub. The finished lower level features an expansive finished rec room with a full bathroom and a sliding door exit, adding even more convenience and space. Don't miss this opportunity!
#VAST2032148

FREDERICKSBURG

101 HILLSDALE DRIVE

4 Beds

4 Baths

3,514 Sq.Ft.

$749,000

MLS#: VAST2032148

- 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.

Privacy Policy Terms of Service