NOT LISTED FOR SALE

5902 Constance Way New Market, MD 21774

Estimated Value: $679,000 - $781,000

5 Beds
3.5 Baths
3,715 Sq Ft
$200/Sq Ft Est. Value

Last Sold May 30, 2023

Last sale price $699,999 $188 Per Sq Ft

Est. 6% increase in value since last sale

Current estimated payment $4,719/month

2 Days on Market

Highlights

  • Active Adult
  • Cape Cod Architecture
  • Recreation Room
  • Open Floorplan
  • Deck
  • Wood Flooring

About This Home

As of May 2023

55+ over ACTIVE community in a wonderful area and neighborhood - the most desirable one story living of its kind! Home presents like a model home in pristine condition. In addition to its marvelous neutral decor, the Castleton Legacy boasts every amenity imaginable in a luxurious yet comfortable floor plan.  Walk right into the welcoming open floorplan foyer.  The formal dining area with living area and sitting room a glance away.  Follow the hardwoods back to the breakfast bar and center island dinette.  The family room with wine bar and built ins featuring high ceilings and sun drenched windows for warmth and elevated living enjoyment is open to the entire kitchen space.   Adding additional warmth is a gas heated fireplace with designer logs.  This area opens right to a delightfully situated screened in porch and an open deck.  Steps away, a discerning buyer will appreciate private office quarters and primary owner's suite with large closets, tray ceilings, luxurious bath space and more.  The primary also offers a quiet sitting room just off the bedroom. Every space boasts the extra touches of select lighting products on dimmers, high end flooring, chair molding and lofty tray ceilings.  This entire main living floor opens to a 2 car garage with an organizational "mud room" and oversized laundry space.  Featured on this floor are rooms to suit 3 bedrooms and 2 full baths or use those spaces as bonus rooms, craft rooms or offices - options are endless and the floor plan allows for your creativity.

 Privacy is very much enjoyed on the upper level.  The 2nd floor features a large comfortable bedroom with extra padded floors and carpet, full bath with linen closet, and wonderful walk in closet.  Additional space over the garage is available for storage galore.   Enjoy another bonus level by visiting the walkout lower level recreation room and basement.  This spectacular finished lower level with extra living space features a theatre room with included surround sound and dimmed lighting, a fabulous full service entertainment bar and plenty of space for game night or recreational furniture.  As an added treat, a bathroom and bedroom area with a full walk in closet is steps away making additional space for a caregiver or visiting family. These private spaces make very comfortable allowances for holiday entertaining.  The community HOA maintains the roof, exterior, lawn care , mowing, mulching, trimming and snow removal.  The neighborhood offers a wonderful club house, pool, exercise room, pickleball court, shuffleboard, and so much more.  The community coordinates many social events and you'll appreciate seeing neighbors walking and visiting, all over.  Within minutes of this incredible offering is Holly Hills Country club with a swim team, a gardening club, social member highlights with activities and full golf memberships.  2 grocery stores within a few minutes drive making shopping OR grocery delivery service a cinch! Downtown Frederick provides wonderful activities and plenty of restaurants while 3 airports are all within a reasonable distance making travel a delight.  Don't miss this large amenity packed gem of a home!

Last Agent to Sell the Property

Deanna Rippeon

(240) 409-6473 deannaSELLSproperty@gmail.com Charis Realty Group Listed on: 04/14/2023

Charis Realty Group

Last Buyer's Agent

Deanne Miles

(240) 675-6734 Dmiles@reimove.com Real Estate Innovations License #WVS230302957

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,001

Year Built

  • Built in 2013

Lot Details

  • 5,812 Sq Ft Lot
  • Open Space
  • Backs To Open Common Area
  • Landscaped
  • Property is in excellent condition

HOA Fees

  • $388 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • 4 Driveway Spaces
  • Parking Storage or Cabinetry
  • Front Facing Garage
  • Garage Door Opener

Home Design

  • Cape Cod Architecture
  • Brick Exterior Construction
  • Asphalt Roof
  • Vinyl Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • Property has 3 Levels
  • Open Floorplan
  • Sound System
  • Built-In Features
  • Bar
  • Chair Railings
  • Crown Molding
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Recessed Lighting
  • Gas Fireplace
  • Double Pane Windows
  • Vinyl Clad Windows
  • Insulated Windows
  • Bay Window
  • Window Screens
  • ENERGY STAR Qualified Doors
  • Insulated Doors
  • Family Room Off Kitchen
  • Formal Dining Room
  • Recreation Room
  • Attic Fan

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen
  • Stove
  • Built-In Microwave
  • Dishwasher
  • Kitchen Island

Flooring

  • Wood
  • Carpet
  • Laminate
  • Tile or Brick

Bedrooms and Bathrooms

Laundry

  • Laundry on main level
  • Electric Dryer
  • Front Loading Washer

Finished Basement

  • Walk-Out Basement
  • Interior and Exterior Basement Entry
  • Sump Pump
  • Shelving
  • Space For Rooms
  • Workshop

Home Security

  • Home Security System
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Eco-Friendly Details

  • Energy-Efficient Appliances
  • Energy-Efficient Windows with Low Emissivity
  • Energy-Efficient Construction
  • Energy-Efficient HVAC
  • Energy-Efficient Lighting
  • Green Energy Flooring

Outdoor Features

  • Deck
  • Enclosed Patio or Porch

Schools

  • Oakdale Elementary And Middle School
  • Oakdale High School

Utilities

  • Multiple cooling system units
  • 90% Forced Air Heating and Cooling System
  • Vented Exhaust Fan
  • Programmable Thermostat
  • Underground Utilities
  • High-Efficiency Water Heater
  • Natural Gas Water Heater
  • Phone Available
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 1109589461

Community Details

Overview

  • Active Adult
  • Active Adult | Residents must be 55 or older
  • Built by Ryan Homes
  • Signature Club At Greenview Subdivision, Castleton Floorplan

Recreation

  • Lap or Exercise Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,001

Year Built

Built in 2013

Lot Details

0

HOA Fees

$388 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Cape Cod
  • Ownership: Fee Simple
  • Exclusions: see disclosures
  • Home Warranty: No
  • Inclusions: see disclosures
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Expected On Market: 2023-04-14
  • Federal Flood Zone: No
  • Year Built: 2013
  • Automatically Close On Close Date: No
  • Building Winterized: No
  • Special Features: VirtualTour
  • Property Sub Type: Detached
  • Stories: 0

Interior Features

  • Appliances: Built-In Microwave, Dishwasher, Dryer - Electric, Exhaust Fan, Refrigerator, Stove, Water Heater - High-Efficiency, Washer - Front Loading
  • Flooring Type: Hardwood, Laminate Plank, Tile/Brick
  • Interior Amenities: Attic, Attic/House Fan, Bar, Breakfast Area, Built-Ins, Carpet, Ceiling Fan(s), Chair Railings, Combination Kitchen/Dining, Combination Kitchen/Living, Crown Moldings, Dining Area, Entry Level Bedroom, Family Room Off Kitchen, Floor Plan - Open, Formal/Separate Dining Room, Kitchen - Eat-In, Kitchen - Island, Pantry, Recessed Lighting, Sound System, Wood Floors
  • Window Features: Double Pane, Energy Efficient, Insulated, Low-E, Screens, Vinyl Clad, Bay/Bow
  • Fireplace Features: Gas/Propane
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Door Features: Insulated, Energy Star Qualified Door(s)
  • Wall Ceiling Types: 9'+ Ceilings
  • Foundation Details: Concrete Perimeter
  • Levels Count: 3
  • Room List: Recreation Room
  • Basement: Yes
  • Basement Type: Fully Finished, Improved, Interior Access, Outside Entrance, Rear Entrance, Shelving, Space For Rooms, Walkout Level, Workshop, Sump Pump
  • Laundry Type: Has Laundry, Main Floor
  • Total Sq Ft: 4076
  • Living Area Sq Ft: 3715
  • Price Per Sq Ft: 302.38
  • Above Grade Finished Sq Ft: 2315
  • Below Grade Finished Sq Ft: 1400
  • Below Grade Sq Ft: 361
  • Total Below Grade Sq Ft: 1761
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

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

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Brick, Vinyl Siding
  • Exterior Features: Sidewalks, Street Lights
  • Roof: Asphalt
  • 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
  • Garage Features: Additional Storage Area, Garage - Front Entry, Garage Door Opener
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 6
  • Type Of Parking: Attached Garage, Driveway
  • Number of Spaces in Driveway: 4

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Attic Fan, Ceiling Fan(s), Central A/C, Multi Units
  • Heating Fuel: Natural Gas
  • Heating Type: Programmable Thermostat, 90% Forced Air
  • Heating: Yes
  • Hot Water: Natural Gas
  • Security: Carbon Monoxide Detector(s), Smoke Detector, Security System
  • Sewer/Septic System: Public Sewer
  • Utilities: Cable Tv, Natural Gas Available, Phone, Under Ground, Other
  • Water Source: Public
  • Internet Services: Cable, Other

Condo/Co-op/Association

  • Condo Co-Op Association: Yes
  • Condo Co-Op Fee: 388.00
  • Condo Co-Op Fee Frequency: Monthly
  • HOA: No
  • Senior Community Age Requirement: 55
  • Senior Community: Yes
  • Community Pool Features: In Ground, Lap/Exercise

Schools

  • Elementary School Source: 3rd Party
  • High School Source: 3rd Party
  • Middle School Source: 3rd Party
  • School District Source: 3rd Party
  • Elementary School: OAKDALE
  • High School: OAKDALE
  • Middle Or Junior School: OAKDALE

Lot Info

  • Horses: No
  • Additional Parcels: No
  • Improvement Assessed Value: 334500.00
  • Land Assessed Value: 100000.00
  • Lot Features: Adjoins - Open Space, Backs - Open Common Area, Landscaping
  • Lot Size Acres: 0.13
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 5812.00
  • Outdoor Living Structures: Deck(s), Patio(s), Porch(es), Enclosed, Screened
  • Property Condition: Excellent
  • Zoning: RESIDENTIAL
  • In City Limits: No

Green Features

  • Efficiency: Construction, Appliances, Flooring, Hvac, Lighting
  • Clean Green Assessed: No

Building Info

  • Builder Name: Ryan Homes

Rental Info

  • Ground Rent Exists: No
  • Lease Considered: No
  • Pets Allowed: No
  • Vacation Rental: No

Tax Info

  • Assessor Parcel Number: 11542453
  • Tax Annual Amount: 5001.00
  • Assessor Parcel Number: 1109589461
  • County Tax Payment Frequency: Annually
  • Tax Data Updated: No
  • Tax Year: 2023

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 14, 2023
Closed on
May 17, 2023
Sold by
Maxine B Lloyd Revocable Trust
Bought by
Davis Victor C and Davis Marlene M
Seller's Agent
Deanna Rippeon
Charis Realty Group
Buyer's Agent
Deanne Miles
Real Estate Innovations
List Price
$699,999
Sold Price
$699,999
Views
18
Current Estimated Value
$742,139

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$42,140
Avg. Annual Appreciation
2.45%
Original Mortgage
$524,999
Outstanding Balance
$510,507
Interest Rate
6.43%
Mortgage Type
New Conventional
Estimated Equity
$231,632

Purchase Details

Closed on
Apr 16, 2022
Sold by
Lloyd Maxine B and Lloyd Edmund H
Bought by
Maxine B Lloyd Revocable Trust

Purchase Details

Closed on
Sep 30, 2013
Sold by
Nvr Inc
Bought by
Lloyd Edmind H and Lloyd Maxine B

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$150,000
Interest Rate
4.53%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 29, 2013
Sold by
Oomfm Lllp
Bought by
Nvr Inc
Source: Public Records

Range of Values:

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

Purchase History

Date Buyer Sale Price Title Company
Davis Victor C $699,999 None Listed On Document
Maxine B Lloyd Revocable Trust -- None Listed On Document
Lloyd Edmind H $537,705 Stewart Title Guaranty Co
Nvr Inc $125,000 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Davis Victor C $524,999
Previous Owner Lloyd Edmind H $150,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
05/30/2023 05/30/23 Sold $699,999 0.0% $188 / Sq Ft
04/17/2023 04/17/23 Pending -- -- --
04/14/2023 04/14/23 For Sale $699,999 -- $188 / Sq Ft
Source: Bright MLS

Tax History Compared to Growth

Source: Public Records

Tax History

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
2025 $5,349 $523,067 -- --
2024 $5,349 $434,500 $100,000 $334,500
2023 $5,089 $430,600 $0 $0
2022 $88 $426,700 $0 $0
2021 $176 $422,800 $100,000 $322,800
2020 $88 $419,867 $0 $0
2019 $88 $416,933 $0 $0
2018 $4,852 $414,000 $100,000 $314,000
2017 $4,333 $414,000 $0 $0
2016 -- $369,800 $0 $0
2015 -- $347,700 $0 $0
2014 -- $347,700 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: MDFR2032570

Bright MLS

APN: 09-589461