3804 Shetland Court
3804 Shetland Court
Frederick, MD 21704
$1,125,000
Price
4
Beds
3
Baths
1
1/2 Bath
5,654 Sq. Ft.
$199 / Sq. Ft.
5,654
Sq. Ft.
$199
per Sq. Ft.
Active Under Contract
Virtual Tour
Active Under Contract
Virtual Tour
Description
Experience luxury in this meticulously renovated NV Wynterhall model, boasting an array of high-end upgrades and nearly 6,000 square feet of opulent living space. The home features an extended family room, a sunlit morning room, and an expansive main suite that offers the ultimate retreat. Revel in the spacious, open floor plan drenched in natural light, perfect for both grand entertaining and intimate gatherings. The two-story foyer and family room create an impressive entrance, complemented by...Experience luxury in this meticulously renovated NV Wynterhall model, boasting an array of high-end upgrades and nearly 6,000 square feet of opulent living space. The home features an extended family room, a sunlit morning room, and an expansive main suite that offers the ultimate retreat. Revel in the spacious, open floor plan drenched in natural light, perfect for both grand entertaining and intimate gatherings. The two-story foyer and family room create an impressive entrance, complemented by both front and back staircases for seamless flow throughout the home. Culinary enthusiasts will delight in the large gourmet kitchen featuring a vast center island and state-of-the-art appliances. Elegant separate living and dining rooms provide ample space for hosting, while a convenient home office on the main level allows for privacy and productivity. Recent updates include a new roof, HVAC units, and appliances, ensuring comfort and efficiency. Rich wood flooring and fresh paint both inside and out add a touch of sophistication. Exquisite real crystal chandeliers further enhance each room, adding a dash of luxury and brilliance to the decor. The expansive finished basement includes a bonus room, a full bath, and extensive extra storage space. The yard is lined with mature trees, offering privacy and tranquility. The extensive deck is ideal for outdoor entertainment. Just steps away, enjoy easy access to the community clubhouse, pool, sports courts, and tot lots. This exquisite home blends elegance with practicality, making it a must-see property.
- Listed by Richard A Saltos • Real Estate Professionals, Inc.P: 2402915309 richard@casasmd.com
Property Details for 3804 Shetland Court
Tax ID Number
1107233612
OwnershipFee Simple
Condo Coop AssociationNo
HOAYes
Structure TypeDetached
StyleColonial
Levels/Stories3
WaterfrontNo
Location
Listing Courtesy of Real Estate Professionals, Inc.
Add your commute
LISTING UPDATED: 05/23/2024 04:43 PM
Property Details for 3804 Shetland Court
| Status | Active Under Contract |
|---|---|
| MLS # | MDFR2047814 |
| Days on Market | 16 |
| Taxes | $7,655 / year |
| HOA Fees | $115 / month |
| Condo/Co-op Fees | - |
| Compass Type | Single Family |
| MLS Type | Residential / Fee Simple |
| Year Built | 2002 |
| Lot Size | 0.25 AC / 10,820 SF |
| County | Frederick County, MD |
Location
Listing Courtesy of Real Estate Professionals, Inc.
Add your commute
Virtual Tour
Building Information for 3804 Shetland Court
Stories3Year Built2002Building Size-Lot Size0.25 AC / 10,820 SF
Payment Calculator
$6,893 per month
30 year fixed, 7.25% Interest
Principal and Interest
$6,140
Property Taxes
$638
HOA Dues
$115
The Payment Calculator is for illustrative purposes only.
Property Information for 3804 Shetland Court
Location
Location
- In City Limits: No
- School District Name: FREDERICK COUNTY PUBLIC SCHOOLS
- School District County ID: 121139693024
- SchoolDistrictSource: Listing Agent
- Elementary School: CENTERVILLE (FREDERICK MD)
- ElementarySchoolSource: Listing Agent
- Middle Or Junior School: URBANA (FREDERICK MD)
- MiddleSchoolSource: Listing Agent
- High School: URBANA (FREDERICK MD)
- County: FREDERICK
Waterfront / Water Access
Waterfront / Water Access
- Water View: No
- Water Access: No
- Water Oriented: No
- Navigable Water: No
- Tidal Water: No
- Riparian Rights Y/N: No
Association / Community Info
Association / Community Info
- Senior Community: No
- Type of Condo: Home Owner Association
Taxes and Assessment
Taxes and Assessment
- Tax Year: 2023
- Tax Assessed Value: $653,167
- Year Assessed: 2023
- County Tax: $7,655
- Improvement Assessed Value: $406,800
- Land Assessed Value: $150,500
- Clean Green Assessed: No
- Land Use Code: R
- Section: P3
- Refuse Fee: $88
- Historic: No
- Zoning: PUD
- Tax Lot: 25026
- School Tax: $0
- Automatically Update Tax Values Y/N: Yes
Rooms
Main
- # Bedrooms Count Main Level: 0
- # Bathrooms Count Main Level: 1
- # Bathrooms Full Main Level: 0
- # Bathrooms Half Main Level: 1
All Upper Levels
- # Bedrooms Count All Upper Levels: 4
- # Bathrooms Count All Upper Levels: 2
- # Bathrooms Full All Upper Levels: 2
- # Bathrooms Half All Upper Levels: 0
Upper Level 1
- # Bedrooms Count Upper Level: 4
- # Bathrooms Count Upper Level: 2
- # Bathrooms Full Upper Level: 2
- # Bathrooms Half Upper Level: 0
All Lower Levels
- # Bedrooms All Lower Levels: 0
- # Bathrooms All Lower Levels: 1
- # Bathrooms Full All Lower Levels: 1
- # Bathrooms Half All Lower Levels: 0
Lower Level 1
- # Bedrooms Lower Level: 0
- # Bathrooms Lower Level: 1
- # Bathrooms Full Lower Level: 1
- # Bathrooms Half Lower Level: 0
Rooms
- Room List: Living Room, Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Kitchen, Family Room, Foyer, Breakfast Room, Study, Laundry, Storage Room
- Stories: Lower 1, Main, Upper 1
Rooms Information
Room 1
- Room Type: Breakfast Room
- Room Level: Main
- Room Exists: Yes
- Room Features: Flooring - Tile/Brick
Room 2
- Room Type: Bedroom 3
- Room Level: Upper 1
- Room Exists: Yes
- Room Features: Flooring - HardWood
Room 3
- Room Type: Dining Room
- Room Level: Main
- Room Exists: Yes
- Room Features: Flooring - HardWood
Room 4
- Room Type: Primary Bedroom
- Room Level: Upper 1
- Room Exists: Yes
- Room Features: Flooring - HardWood
Room 5
- Room Type: Study
- Room Level: Main
- Room Exists: Yes
- Room Features: Flooring - HardWood
Room 6
- Room Type: Kitchen
- Room Level: Main
- Room Exists: Yes
- Room Features: Flooring - Tile/Brick
Room 7
- Room Type: Foyer
- Room Level: Main
- Room Exists: Yes
- Room Features: Flooring - HardWood
Room 8
- Room Type: Living Room
- Room Level: Main
- Room Exists: Yes
- Room Features: Flooring - HardWood
Room 9
- Room Type: Storage Room
- Room Level: Lower 1
- Room Exists: Yes
- Room Features: Flooring - Concrete
Room 10
- Room Type: Family Room
- Room Level: Main
- Room Exists: Yes
- Room Features: Flooring - HardWood, Fireplace - Gas
Room 11
- Room Type: Bedroom 2
- Room Level: Upper 1
- Room Exists: Yes
- Room Features: Flooring - HardWood
Room 12
- Room Type: Bedroom 4
- Room Level: Upper 1
- Room Exists: Yes
- Room Features: Flooring - HardWood
Room 13
- Room Type: Laundry
- Room Level: Main
- Room Exists: Yes
- Room Features: Flooring - Tile/Brick
Building Info
Building Info
- Builder Name: NV HOMES
- Total Finished SQFT: 5,654.00
- Total Finished SQFT Source: Estimated
- Tax Total Finished SQFT: 4,154.00
- Total SQFT: 6,308.00
- Total SQFT Source: Estimated
- Construction Materials: Combination, Brick
- Roof: Architectural Shingle
- Flooring Type: Hardwood
- Basement Type: Connecting Stairway, Fully Finished, Walkout Stairs
- Foundation Details: Permanent
- Room and Floor: Bathrooms Half-Main Level-1, Bedrooms-Upper Level 1-1, Bedrooms-Upper Level 1-2, Bedrooms-Upper Level 1-3, Bedrooms-Upper Level 1-4, Bathrooms Full-Upper Level 1-1, Bathrooms Full-Upper Level 1-2, Bathrooms Full-Lower Level 1-1
- # Bathrooms Full: 3
- # Bathrooms Half: 1
- Other Structure: Above Grade, Below Grade
Lot / Land Information
Lot / Land Information
- Lot Size Source: Assessor
- Parcel ID: 11571272
- Ground Rent Exists: No
Parking
Parking
- Type Of Parking: Driveway, Off Street
- Parking Features: Paved Driveway
Interior Features
Interior Features
- Interior Features: Attic, Dining Area, Breakfast Area, Floor Plan - Open
- Fireplace: Yes
- Fireplaces Count: 1
- Appliances: Built-In Microwave, Cooktop, Dishwasher, Disposal, Dryer, Oven - Double, Refrigerator, Stainless Steel Appliances, Washer
- Accessibility Features: None
- Laundry Type: Main Floor
- Virtual Tour URL Unbranded: https://my.matterport.com/show/?m=mEP4KedytbZ&mls=1
Exterior Features
Exterior Features
- Pool: No Pool
Utilities
Utilities
- Heating: Yes
- Cooling Type: Central A/C, Zoned
- Cooling Fuel: Electric
- Heating Type: Central, Zoned
- Heating Fuel: Natural Gas
- Hot Water: Natural Gas
- Water Source: Public
- Sewer Septic: Public Sewer
- Electric Service: 110 Volts
Confidential Data
Listing Office
- List Agent AOR: Greater Baltimore Board of REALTORS
Property History for 3804 Shetland Court
| Date | Event & Source | Price | Appreciation |
|---|
| Date | Event & Source | Price |
|---|
For completeness, Compass often displays two records for one sale: the MLS record and the public record.
Public Records for 3804 Shetland Court
Taxable ValueLand-Additions-Total-
Tax Record2023$9,144 ($762 / month)
Home Facts
Beds0Baths3.5Total Finished SqFt4,154 SqFtAbove Grade Finished SqFt4,154 SqFtStories2Lot Size10,820 SqFtStyleSingle Family ResidenceYear Built2002ZoningPUDCountyFREDERICKAPN07-233612Fireplace TypeHas Fireplace
Schools near 3804 Shetland Court
This home is within Frederick County Public Schools.
Rating | School | Type | Grades | Distance |
|---|---|---|---|---|
| Public - | K to 5 | |||
| Public - | 6 to 8 | |||
| Public - | 9 to 12 | |||
| Public - | K to 5 |
Rating | School | Distance |
|---|---|---|
Centerville Elementary PublicK to 5 | ||
Urbana Middle School Public6 to 8 | ||
Urbana High School Public9 to 12 | ||
Sugarloaf Elementary PublicK to 5 |
School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.
Similar Homes
Sorry, we can't find any similar homes at this time. Please check back later.
Similar Sold Homes
Sorry, we can't find any similar sold homes at this time. Please check back later.
Homes for Sale near Urbana
Neighborhoods
Cities
No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. No financial or legal advice provided. Equal Housing Opportunity.
Listing Courtesy of Real Estate Professionals, Inc.
© 2024 Bright MLS. All rights reserved. All information is deemed reliable, but accuracy is not guaranteed. Listing information is from various brokers who participate in IDX and not all listings may be visible on the site. The property information being provided is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated on 05/23/2024 04:43 PM