Agent profile image in chat bubble
Agent profile image in chat header

IDX Support

sales rep | Brivity IDX

Agent profile image in message

9058 Major Smith Ln , Frederick, MD 21704
$3,900
Est. Payment: $21.42/mo
4 Bed
3 Bath
3740 Sqft
0.19 Acres
Status: active | Days on site: 81
Get Pre-Qualified
LRL1 - 3031407
By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from IDX Support, its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.

House Description

Beautiful and highly sought-after Waverly model located in the desirable Urbana High School district. This spacious home welcomes you with hardwood flooring in the foyer and a bright, open layout. The generously sized kitchen features cherry cabinetry, ceramic tile flooring, a center island with cooktop, double ovens, and a large pantry, opening to a sun-filled morning room with direct access to the rear deck and backyard. Just off the kitchen, the step-down family room features a dramatic cathedral ceiling and cozy gas fireplace perfect for relaxing or entertaining. Upstairs, the expansive primary suite offers a private sitting room and a luxurious bath with a separate shower and Jacuzzi tub. Three additional generously sized bedrooms provide plenty of space for family, guests, or a home office. Additional highlights include a separate laundry/mud room and an attached two-car garage. A Tesla Wall Connector is already installed in the garage, providing convenient at-home charging for Tesla owners and other compatible EV drivers. The home has also been freshly repainted, and the main-level carpeting was replaced just two years ago, giving it a fresh and move-in-ready feel. Enjoy an exceptional community lifestyle with access to fitness facilities, swimming pools, parks, and scenic walking and biking trails. The location is incredibly convenient, with the library, shopping, dining, and everyday services just minutes away, plus easy access to I-70, I-270, and major commuter routes. A wonderful combination of spacious living, desirable schools, resort-style community amenities, EV-ready convenience, and an excellent commuter location.

Highlights

Listed by HaiYan Ni , 3019089577 Libra Realty, LLC , 3019725588. Bright MLS

Property Type

Residential Lease

Lot/Acreage
0.19

HOA Fee

140 Monthly

Year Built

2001

County

Frederick

Neighborhood

Villages Of Urbana

School District

Frederick County Public Schools

Listing ID

MDFR2087202

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:4
  • ▪ Bathrooms:3
  • ▪ Full Bathrooms:2
  • ▪ 1/2 Bathrooms:1
Air Cond:Central A/C,Ceiling Fan(s)
Fireplaces:1 Fireplace
Above Ground Sq Ft:3740
Basement:Daylight,Full,Outside Entrance,Walkout Stairs
Other:
  • ▪ Additional:Case by Case Basis, Pets Allowed
Water:Public

Exterior Features

Lot:Not New Construction,Horse Property: No
Garage Capacity:2
Zoning:Planned Unit Development
Roof:Shingle
Others:
  • ▪ Additional:Basketball Courts, Bike Trail, Club House, Community Center, Exercise Room, Fitness Center, Jog/Walk Path, Pool - Outdoor, Pickleball Courts, Party Room, Swimming Pool, Tennis Courts, Common Area Maintenance, Health Club, Management, Pool(s), Recreation Facility
Sewer:Public Sewer
Parking Features:Asphalt Driveway,Inside Access,Garage Door Opener,Garage - Front Entry,Additional Storage Area,Attached Garage,2+ Spaces,1+ Spaces
Principal Interest
$21
Taxes
$2
HOA
$140

Home Price

$3,900

Loan Details

30 yrs
7.312%

Down Payment

20%
$780
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$21.42

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $21.42 $2.49 $140.00 $163.90
Yearly $256.98 $29.84 $1,680.00 $1,966.82
Total $7,709.49 $895.05 $50,400.00 $59,004.54
Lender profile image
Chico Gordy
Test
GET PRE-QUALIFIED

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Nov 2026

Average Price

All Price Ranges
N/A
Nov 2026

Average Days on Market

All Price Ranges
N/A
Nov 2026
Market insight data is pulled from the same city as the listing being viewed (Frederick, MD).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

Information provided by Bright MLS, and is deemed reliable but not guaranteed accurate.

IDX service by Blueroof 360

Data last updated: 2026-11-14T11:13:36.000Z

© 2026 Bright MLS