$735,000
OPEN HOUSE 9/12 COMING SOON SEP 10, 2026

Estimated payment $4,895/month

4 Beds
3.5 Baths
4,296 Sq Ft
4,756 Sq Ft Lot

Highlights

  • Tennis Courts
  • Gourmet Kitchen
  • Open Floorplan
  • Centerville Elementary Rated A
  • Waterfall on Lot
  • Colonial Architecture

About This Home

Welcome home to something truly special! This stunning former Advantage Homes Clairmont model in highly desirable Urbana Highlands offers an extraordinary combination of elegance, space, luxury, and lifestyle with over 4,494 square feet of finished living space and an incredible array of features and upgrades. From the moment you arrive, the inviting front porch and beautiful colonial architecture set the tone for what awaits inside. Step through the door and you'll immediately appreciate the abundance of natural light, hardwood floors, recessed lighting, decorative wall treatments, tray ceilings, and thoughtfully designed open floor plan. The impressive gourmet kitchen is designed for both everyday living and entertaining, featuring granite countertops, beautiful cherry cabinetry, stainless steel appliances, and gas cooking. The kitchen opens to spacious living areas highlighted by two fireplaces, creating warm and inviting spaces for relaxing with family or entertaining guests. A formal dining room adds the perfect touch for holidays and special occasions. Upstairs, escape to your private owner's retreat, featuring a spacious sitting room and luxurious owner's bathroom. The additional bedrooms feature beautiful decorative details, and the flexible floor plan offers the possibility of a 5th bedroom, home office, guest suite, or additional living space. But the real showstopper may be downstairs! The fully finished basement is an entertainer's dream, featuring a dedicated media/movie room wired for surround sound, a wet bar with mini refrigerator, and a beautifully finished tile bathroom with Jacuzzi tub. Whether you're hosting a movie night, watching the big game, entertaining friends, or simply relaxing with family, this space delivers. Step outside to the large rear patio, perfect for grilling, entertaining, and enjoying outdoor gatherings. And then there's the Urbana Highlands lifestyle! Enjoy an exceptional collection of community amenities including a pool, tennis courts, basketball courts, pickleball, nature paths and trails, and a community book club. Add the convenience of being close to schools, shopping, dining, and major commuter routes, and you have a location that truly has it all.

Listing Agent

Darren Ahearn

(301) 698-5005 darrenahearn@gmail.com RE/MAX Results Brokerage Phone: 3016985005

RE/MAX Results

Open House Schedule

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,397

Year Built

  • Built in 2003

Lot Details

  • 4,756 Sq Ft Lot
  • Landscaped
  • Level Lot
  • Cleared Lot
  • Property is in good condition
  • Property is zoned PUD

HOA Fees

  • $159 Monthly HOA Fees

Parking

  • 2 Car Detached Garage
  • Rear-Facing Garage
  • Garage Door Opener
  • Driveway
  • On-Street Parking

Home Design

  • Colonial Architecture
  • Architectural Shingle Roof
  • Stone Siding
  • Vinyl Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • Property has 3 Levels
  • Open Floorplan
  • Bar
  • Tray Ceiling
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Recessed Lighting
  • 2 Fireplaces
  • Gas Fireplace
  • Double Pane Windows
  • Double Hung Windows
  • Window Screens
  • Family Room Off Kitchen
  • Formal Dining Room
  • Storm Doors
  • Attic

Kitchen

  • Gourmet Kitchen
  • Gas Oven or Range
  • Built-In Microwave
  • Ice Maker
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Hydromassage or Jetted Bathtub
  • Bathtub with Shower
  • Walk-in Shower

Laundry

  • Laundry on upper level
  • Dryer
  • Washer

Finished Basement

  • Sump Pump
  • Basement Windows

Outdoor Features

  • Tennis Courts
  • Patio
  • Waterfall on Lot
  • Porch

Schools

  • Urbana Elementary And Middle School
  • Urbana High School

Utilities

  • Air Filtration System
  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Vented Exhaust Fan
  • Underground Utilities
  • 200+ Amp Service
  • Natural Gas Water Heater

Additional Features

  • Energy-Efficient Windows
  • Suburban Location

Listing and Financial Details

  • Coming Soon on 9/10/26
  • Tax Lot 25247
  • Assessor Parcel Number 1107236654

Community Details

Overview

  • Association fees include management, pool(s), recreation facility, road maintenance, snow removal
  • Camp HOA
  • Urbana Highlands Subdivision
  • Property Manager

Amenities

  • Recreation Room

Recreation

  • Tennis Courts
  • Community Playground
  • Community Pool
  • Jogging Path

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,397

Year Built

Built in 2003

Lot Details

4,756 Sq Ft Lot

HOA Fees

$159 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Colonial
  • Ownership: Fee Simple
  • Historic: No
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Expected On Market: 9/10/2026 12:00:00 AM
  • Federal Flood Zone: No
  • Year Built: 2003
  • Building Winterized: No
  • Special Features: ComingSoon
  • Property Sub Type: Detached

Interior Features

  • Appliances: Built-In Microwave, Dishwasher, Disposal, Dryer, Exhaust Fan, Icemaker, Oven/Range - Gas, Refrigerator, Stainless Steel Appliances, Washer, Water Heater
  • Flooring Type: Carpet, Ceramic Tile, Hardwood
  • Interior Amenities: Air Filter System, Attic, Bar, Bathroom - Jetted Tub, Bathroom - Tub Shower, Bathroom - Walk-In Shower, Carpet, Ceiling Fan(s), Dining Area, Family Room Off Kitchen, Floor Plan - Open, Formal/Separate Dining Room, Kitchen - Gourmet, Kitchen - Island, Recessed Lighting, Walk-In Closet(s), Wood Floors
  • Window Features: Double Hung, Double Pane, Energy Efficient, Screens
  • Fireplace Features: Gas/Propane
  • Fireplaces Count: 2
  • Fireplace: Yes
  • Door Features: Storm
  • Wall Ceiling Types: 9'+ Ceilings, Dry Wall, High, Tray Ceilings
  • Foundation Details: Concrete Perimeter
  • Levels Count: 3
  • Basement: Yes
  • Basement Type: Daylight, Full, Fully Finished, Sump Pump, Windows
  • Basement Finished Percent: 90.00
  • Basement Footprint Percent: 100.00
  • Laundry Type: Hookup, Has Laundry, Upper Floor
  • Total Sq Ft: 4494
  • Living Area Sq Ft: 4296
  • Price Per Sq Ft: 245.33
  • Above Grade Finished Sq Ft: 2996
  • Below Grade Finished Sq Ft: 1300
  • Below Grade Sq Ft: 198
  • Total Below Grade Sq Ft: 1498
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

  • Bedrooms: 4
  • Total Bathrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Main Level Bathrooms: 1.00
  • Upper Level Bathrooms: 2
  • Lower Levels Bathrooms: 1
  • Upper Level Bathrooms: 2.00
  • Lower Levels Bathrooms: 1.00
  • Lower Level Full Bathrooms: 1
  • Main Level Half Bathrooms: 1

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Vinyl Siding, Stone
  • Exterior Features: Sidewalks, Tennis Court(s), Water Falls
  • Roof: Architectural Shingle
  • Spa: No
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Community
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage: Yes
  • Parking Features: Asphalt Driveway
  • Garage Features: Garage - Rear Entry, Garage Door Opener
  • Number Of Detached Garage Spaces: 2
  • Total Garage And Parking Spaces: 2
  • Type Of Parking: Detached Garage, On Street

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Previous Twelve Months Electric Expense: 2280.00
  • Electric Service: 200+ Amp Service
  • Heating Fuel: Natural Gas
  • Heating Type: Forced Air
  • Heating: Yes
  • Hot Water: Natural Gas
  • Sewer/Septic System: Public Sewer
  • Utilities: Natural Gas Available, Under Ground
  • Water Previous Twelve Months: 720.00
  • Water Source: Public
  • Municipal Trash: No
  • Internet Services: Broadband

Condo/Co-op/Association

  • HOA Fees: 159.00
  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA Condo Co-Op Amenities: Jog/Walk Path, Pool - Outdoor, Recreational Center, Tennis Courts, Tot Lots/Playground
  • HOA Condo Co-Op Fee Includes: Management, Pool(s), Recreation Facility, Road Maintenance, Snow Removal
  • HOA Name: CAMP
  • HOA: Yes
  • Senior Community: No
  • Association Recreation Fee: No
  • Community Pool Features: Concrete, Gunite

Schools

  • Elementary School Source: Listing Agent
  • High School Source: Listing Agent
  • Middle School Source: Listing Agent
  • Elementary School: URBANA
  • High School: URBANA
  • Middle Or Junior School: URBANA

Lot Info

  • Horses: No
  • Additional Parcels: No
  • Lot Features: Cleared, Landscaping, Level
  • Lot Size Acres: 0.11
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 4756.00
  • Outdoor Living Structures: Patio(s), Porch(es)
  • Property Condition: Good
  • Soil Types: Unknown
  • Zoning: PUD
  • Zoning Description: Residential
  • In City Limits: No

Rental Info

  • Ground Rent Exists: No
  • Lease Considered: No
  • Vacation Rental: No
  • Property Manager: Yes

Tax Info

  • Tax Annual Amount: 8397.00
  • Assessor Parcel Number: 1107236654
  • Tax Lot: 25247
  • County Tax Payment Frequency: Semi-Annually
  • Tax Year: 2026

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2026 $8,981 $751,700
2025 $8,670 $692,800
2024 $8,670 $633,900 $170,000 $463,900
2023 $8,083 $592,700 $0 $0
2022 $7,656 $551,500 $0 $0
2021 $7,329 $510,300 $145,000 $365,300
2020 $7,343 $490,367 $0 $0
2019 $7,081 $470,433 $0 $0
2018 $5,280 $450,500 $108,000 $342,500
2017 $6,603 $450,500 $0 $0
2016 $6,180 $436,900 $0 $0
2015 $6,180 $430,100 $0 $0
2014 $6,180 $423,667 $0 $0
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
03/26/2018 03/26/18 Sold $505,000 -3.8% $169 / Sq Ft View Prior Sale
02/10/2018 02/10/18 Pending -- -- --
02/07/2018 02/07/18 For Sale $525,000 -- $175 / Sq Ft
Source: Bright MLS

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Deed -- None Listed On Document
Deed $505,000 Monocacy Title Inc
Deed $575,000 --
Deed $409,900 --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Previous Owner $392,000 New Conventional
Previous Owner $395,625 Adjustable Rate Mortgage/ARM
Previous Owner $404,000 New Conventional
Previous Owner $460,000 Purchase Money Mortgage
Source: Public Records

Source: Bright MLS

MLS Number: MDFR2088912

Bright MLS

APN: 07-236654

Your Personal Tour Guide

Ask me questions while you tour the home.