$775,000
SOLD NOV 14, 2024
4 Beds
4.5 Baths
2,350 Sq Ft
0.5 Acres

Recently Sold

$330 Per Sq Ft

6% Below List Price

26 Days on Market

Highlights

  • New Construction
  • Craftsman Architecture
  • Forced Air Heating and Cooling System
  • 0.5 Acre Lot
  • No HOA
  • 2-minute walk to Bartlet Park

About This Home

As of November 2024

Welcome to 3704 Upshur St, Brentwood MD – an exquisite, newly constructed Victorian Craftsman residence that epitomizes luxury living just minutes from the DC/MD border. Nestled on an expansive and rare 1/2-acre double lot, this architectural gem boasts over 2,350 square feet of opulent, contemporary design, seamlessly blending classic elegance with modern sophistication.

From the moment you arrive, the grandeur of the home is undeniable. A sprawling front porch welcomes you, setting the stage for the refined living that awaits inside. Step into a world of luxury, with premium finishes, and bespoke details define every corner. The gourmet chef’s kitchen is an entertainer's dream, featuring high-end appliances, sleek countertops, and custom cabinetry – ideal for hosting lavish dinners or intimate gatherings.

This residence offers four palatial en-suite bedrooms, each featuring its own private bath, providing the ultimate retreat for family and guests alike. The finished attic adds an additional 300 square feet of flexible living space, perfect for a home office, studio, or guest suite.

The allure continues outside, with meticulously landscaped grounds and a private patio, perfect for alfresco dining or simply unwinding with your morning coffee. The fully fenced, expansive yard ensures utmost privacy, creating an oasis for relaxation or grand-scale entertaining. The driveway accommodates up to four vehicles, enhancing the home’s convenience and functionality.

Just moments from the dynamic Hyattsville Arts District, this luxurious haven offers easy access to upscale dining, boutique shopping, and cultural experiences. Enjoy the proximity to renowned spots such as Vigilante Coffee, Busboys & Poets, and YES Organic Market, all contributing to the vibrant lifestyle surrounding this prestigious address.

With the added bonus of a rare double lot, this property offers exceptional privacy and the potential for future development or income-generating opportunities. Experience unparalleled elegance and the finest in modern luxury living – 3704 Upshur St awaits your discerning taste.

Last Agent to Sell the Property

Nicola Taylor

EXP Realty, LLC License #624263

EXP Realty, LLC

Last Buyer's Agent

Fergus O'Brien

Long & Foster Real Estate, Inc. License #0225230305

Long & Foster Real Estate, Inc.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,244

Year Built

  • Built in 2024 | New Construction

Lot Details

  • 0.5 Acre Lot
  • Property is in excellent condition
  • Property is zoned RSF65

Home Design

  • Craftsman Architecture
  • Victorian Architecture
  • Permanent Foundation
  • Frame Construction
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,350 Sq Ft Home
  • Property has 2 Levels

Bedrooms and Bathrooms

Parking

  • 4 Parking Spaces
  • 4 Driveway Spaces
  • Fenced Parking

Schools

  • Northwestern High School

Utilities

  • Forced Air Heating and Cooling System
  • Electric Water Heater

Community Details

  • No Home Owners Association
  • Brentwood Subdivision

Listing and Financial Details

  • Assessor Parcel Number 17171956226

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,244

Year Built

Built in 2024 | New Construction

Lot Details

0

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Craftsman, Victorian
  • Ownership: Fee Simple
  • New Construction: Yes
  • Story List: Main, Upper 1
  • Year Built: 2024
  • Automatically Close On Close Date: No
  • Remarks Public: Welcome to 3704 Upshur St, Brentwood MD – an exquisite, newly constructed Victorian Craftsman residence that epitomizes luxury living just minutes from the DC/MD border. Nestled on an expansive and rare 1/2-acre double lot, this architectural gem boasts over 2,350 square feet of opulent, contemporary design, seamlessly blending classic elegance with modern sophistication. From the moment you arrive, the grandeur of the home is undeniable. A sprawling front porch welcomes you, setting the stage for the refined living that awaits inside. Step into a world of luxury, with premium finishes, and bespoke details define every corner. The gourmet chef’s kitchen is an entertainer's dream, featuring high-end appliances, sleek countertops, and custom cabinetry – ideal for hosting lavish dinners or intimate gatherings. This residence offers four palatial en-suite bedrooms, each featuring its own private bath, providing the ultimate retreat for family and guests alike. The finished attic adds an additional 300 square feet of flexible living space, perfect for a home office, studio, or guest suite. The allure continues outside, with meticulously landscaped grounds and a private patio, perfect for alfresco dining or simply unwinding with your morning coffee. The fully fenced, expansive yard ensures utmost privacy, creating an oasis for relaxation or grand-scale entertaining. The driveway accommodates up to four vehicles, enhancing the home’s convenience and functionality. Just moments from the dynamic Hyattsville Arts District, this luxurious haven offers easy access to upscale dining, boutique shopping, and cultural experiences. Enjoy the proximity to renowned spots such as Vigilante Coffee, Busboys & Poets, and YES Organic Market, all contributing to the vibrant lifestyle surrounding this prestigious address. With the added bonus of a rare double lot, this property offers exceptional privacy and the potential for future development or income-generating opportunities. Experience unparalleled elegance and the finest in modern luxury living – 3704 Upshur St awaits your discerning taste.
  • Special Features: 4098
  • Property Sub Type: Detached

Interior Features

  • Fireplace: No
  • Foundation Details: Concrete Perimeter, Permanent
  • Levels Count: 2
  • Basement: No
  • Total Sq Ft: 2350
  • Living Area Sq Ft: 2350
  • Price Per Sq Ft: 340.43
  • Above Grade Finished Sq Ft: 2350
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 3704

Beds/Baths

  • Bedrooms: 4
  • Main Level Bedrooms: 2
  • Total Bathrooms: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Main Level Bathrooms: 3.00
  • Upper Level Bathrooms: 2
  • Upper Level Bathrooms: 2.00
  • Main Level Full Bathrooms: 2
  • Upper Level Full Bathrooms: 2
  • Main Level Half Bathrooms: 1

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Frame
  • Construction Completed: No
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: No Pool
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage: No
  • Parking Features: Asphalt Driveway, Paved Driveway, Fenced
  • Total Garage And Parking Spaces: 4
  • Type Of Parking: Driveway
  • Number of Spaces in Driveway: 4

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Heating Fuel: Electric
  • Heating Type: Forced Air
  • Heating: Yes
  • Hot Water: Electric
  • Sewer/Septic System: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Condo Co-Op Association: No
  • HOA: No
  • Senior Community: No

Schools

  • School District: PRINCE GEORGE'S COUNTY PUBLIC SCHOOLS
  • High School: NORTHWESTERN
  • High School Source: 3rd Party
  • School District Key: 121137599599
  • School District Source: 3rd Party
  • High School: NORTHWESTERN

Lot Info

  • Land Use Code: R
  • Lot Size Acres: 0.50
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 21780.00
  • Property Condition: Excellent
  • Year Assessed: 2024
  • Zoning: RSF65
  • In City Limits: No

Rental Info

  • Vacation Rental: No

Tax Info

  • Tax Annual Amount: 6244.00
  • Assessor Parcel Number: 17171956226
  • Tax Total Finished Sq Ft: 1702
  • County Tax Payment Frequency: Annually
  • Tax Data Updated: No
  • Tax Year: 2024
  • Close Date: 11/14/2024

MLS Schools

  • School District Name: PRINCE GEORGE'S COUNTY PUBLIC SCHOOLS

Map

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

Property History

Date Event Price Change Sq Ft Price
11/14/2024 11/14/24 Sold $775,000 -3.1% $330 / Sq Ft
10/16/2024 10/16/24 Pending -- -- --
09/24/2024 09/24/24 Price Changed $799,999 -3.0% $340 / Sq Ft
09/20/2024 09/20/24 For Sale $825,000 +94.1% $351 / Sq Ft
03/18/2024 03/18/24 Sold $425,000 -10.5% $250 / Sq Ft
03/04/2024 03/04/24 Pending -- -- --
01/16/2024 01/16/24 Price Changed $475,000 -5.0% $279 / Sq Ft
12/14/2023 12/14/23 Price Changed $499,900 -6.6% $294 / Sq Ft
11/27/2023 11/27/23 Price Changed $535,000 -7.0% $314 / Sq Ft
10/09/2023 10/09/23 Price Changed $575,000 -4.0% $338 / Sq Ft
08/12/2023 08/12/23 For Sale $599,000 -- $352 / Sq Ft
Source: Bright MLS

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
2024 $6,381 $352,000 $116,200 $235,800
2023 $4,109 $341,800 $0 $0
2022 $4,599 $331,600 $0 $0
2021 $3,821 $321,400 $100,600 $220,800
2020 $4,938 $297,800 $0 $0
2019 $4,853 $274,200 $0 $0
2018 $3,561 $250,600 $75,600 $175,000
2017 $1,206 $226,600 $0 $0
2016 -- $202,600 $0 $0
2015 $2,792 $178,600 $0 $0
2014 $2,792 $178,600 $0 $0
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $375,000 New Conventional
Previous Owner $625,000 New Conventional
Previous Owner $544,185 Reverse Mortgage Home Equity Conversion Mortgage
Previous Owner $45,000 New Conventional
Source: Public Records

Deed History

Date Type Sale Price Title Company
Deed $775,000 Rgs Title
Deed $425,000 Stewart Title
Source: Public Records

About the Listing Agent

Nicola Taylor

EXP Realty, LLC

(301) 792-9276

Section Image

Nicola Taylor is committed to delivering a 5-star luxury real estate experience to accommodate her clients' unique needs. Nicola’s interior design background, investment property renovation, and project management allow her to find exceptional properties in the high-end luxury real estate market for her clients.
Nicola proudly serves the following realty areas. Potomac, Chevy Chase, Bethesda and Rockville, Maryland.Great Falls, Alexandria and McLean, Virginia. Georgetown, Washington DC.

Nicola's Other Listings

  • 1938 I St NE, Washington, DC 20002

    $1,199,999

    • Studio
    • 2,368 Sq Ft
    • 1938 I St NE
    • Washington, DC

    Discover a prime condo conversion development opportunity in NE DC, strategically positioned near the vibrant H Street corridor. This VACANT (NO TOPA) 4-unit multi-family building comes ready for transformation, with Approved Plans and a recently issued Building Permit to construct 10 luxury condo units spanning a cellar, four floors, and a penthouse (PH) level. Additionally, the property

    Nicola Taylor EXP Realty, LLC

  • 1938 I St NE, Washington, DC 20002

    $999,000

    • Studio
    • 2,368 Sq Ft
    • 1938 I St NE
    • Washington, DC

    Discover a prime condo conversion development opportunity in NE DC, strategically positioned near the vibrant H Street corridor. This VACANT (NO TOPA) 4-unit multi-family building comes ready for transformation, with Approved Plans and a recently issued Building Permit to construct 10 luxury condo units spanning a cellar, four floors, and a penthouse (PH) level. Additionally, the property

    Nicola Taylor EXP Realty, LLC

  • 4016 Georgia Ave NW Unit 9, Washington, DC 20011

    $814,900 Open Sat 1PM - 3PM

    • 3 Beds
    • 2 Baths
    • 1,095 Sq Ft
    • 4016 Georgia Ave NW
    • Unit 9
    • Washington, DC

    RARE FIND! This penthouse includes 1 PRIVATE GATED PARKING SPACE--- a true luxury in DC! Never worry about street parking again.Welcome to 4016 Georgia Ave NW, PH9—a stunning penthouse condo that redefines modern urban living in the vibrant Petworth neighborhood! Spanning two luxurious levels with 1,195 sq. ft., this contemporary boutique residence is bathed in natural light, thanks to

    Nicola Taylor EXP Realty, LLC

  • 460 New York Ave NW Unit 206, Washington, DC 20001

    $549,900

    • 1 Bed
    • 1 Bath
    • 769 Sq Ft
    • 460 New York Ave NW
    • Unit 206
    • Washington, DC

    Immediate Move-In Opportunity! Modern 1BR + Den Condo with Garage Parking in Prime Mount Vernon Triangle – 460 New York Ave NW, Unit 206Seize the chance to own a sleek, contemporary 1-bedroom + den, 1-bathroom condo in the heart of Mount Vernon Triangle—one of DC’s most vibrant and walkable neighborhoods! With garage parking included, this stunning unit at 460 New York Ave NW, Unit 206 is

    Nicola Taylor EXP Realty, LLC

  • 1721 Q St SE, Washington, DC 20020

    $374,000 Pending

    • Studio
    • 1,258 Sq Ft
    • 1721 Q St SE
    • Washington, DC

    Investor’s Dream in Booming Anacostia!Investor’s Dream in Booming Anacostia! This RA-2 zoned, VACANT (NO TOPA) semi-detached duplex will come ready for transformation, with Approved Plans and a Building Permit for legal 2-Units with 2 Bedrooms and 1 Bath in EACH unit. Comparable ARV projections reach $715K (see sold comp at 1638 16th St SE). Moreover, one can take advantage of the RA-2

    Nicola Taylor EXP Realty, LLC

  • 4306 40th St, Brentwood, MD 20722

    $875,000 Sold Jun 28, 2024

    • 5 Beds
    • 4 Baths
    • 2,600 Sq Ft
    • 4306 40th St
    • Brentwood, MD

    Introducing an exceptional, newly completed Victorian-inspired luxury residence, strategically positioned just moments from the prestigious Washington DC/MD border. This masterpiece of modern architecture combines the grandeur of Victorian aesthetics with cutting-edge design, creating a living experience that epitomizes sophistication and luxury. Step inside and discover a sanctuary that offers

    Nicola Taylor EXP Realty, LLC

  • 430 Ethan Allen Ave, Takoma Park, MD 20912

    $815,000 Sold Nov 21, 2024

    • 4 Beds
    • 3 Baths
    • 2,543 Sq Ft
    • 430 Ethan Allen Ave
    • Takoma Park, MD

    Price Improvement - Discover the refined charm of this beautifully renovated bungalow, a treasure tucked away in Takoma Park, complete with a welcoming front porch perfect for peaceful morning retreats. This home has been meticulously updated to fulfill the desires and demands of modern living. Stepping inside, you're greeted by a beautiful living room, with the primary bedroom suite

    Nicola Taylor EXP Realty, LLC

  • 518 Kenyon St NW, Washington, DC 20010

    $1,385,000 Sold Mar 26, 2025

    • 5 Beds
    • 3.5 Baths
    • 3,892 Sq Ft
    • 518 Kenyon St NW
    • Washington, DC

    Welcome to 518 Kenyon St NW, Washington, DC.Discover the epitome of urban luxury at 518 Kenyon Street NW, a meticulously designed residence where elegance and functionality converge. Nestled in the vibrant Columbia Heights neighborhood of Washington, DC, this stunning home offers 5 bedrooms, 3.5 baths, and over 3,000 square feet of thoughtfully curated living space, making it an

    Nicola Taylor EXP Realty, LLC

  • 10105 Wildwood Rd, Kensington, MD 20895

    $2,225,000 Sold Dec 06, 2024

    • 7 Beds
    • 5.5 Baths
    • 6,509 Sq Ft
    • 10105 Wildwood Rd
    • Kensington, MD

    Introducing an architectural masterpiece at 10105 Wildwood Rd, Kensington, where contemporary luxury meets prime location. Just minutes from downtown Bethesda, Walter Reed Military Hospital, NIH, Suburban Hospital, Bethesda Row, Rock Creek Park, and Kensington Antique Row, this residence exemplifies the pinnacle of modern living.Crafted with meticulous attention to detail, this home

    Nicola Taylor EXP Realty, LLC

Source: Bright MLS

MLS Number: MDPG2126410

Bright MLS

APN: 17-1956226