A stunning two-story home with a basement that has it all! The spacious kitchen boasts a charming breakfast area, with direct access to a deck that flows seamlessly into the main living space. The dining room is surrounded by large windows, filling the space with abundant natural light. Upstairs, you'll find four generously sized bedrooms and two full bathrooms. The lower level offers a versatile second living area, an additional bedroom, a full bath, and access to a cozy back patio. This home backs onto a serene wooded lot, offering privacy and just the right amount of yard space for outdoor enjoyment. Imagine starting your mornings on the inviting front covered porch, coffee in hand, as you watch the sunrise. Don't miss the chance to make this dream home yours!
Sold
Street View
Price Unknown
1904 Longstreet Dr, Columbia, MO 65202
5beds
3,037sqft
Single Family Residence
Built in 2002
0.26 Acres Lot
$376,000 Zestimate®
$--/sqft
$2,563 Estimated rent
Home value
$376,000
$346,000 - $406,000
$2,563/mo
Zestimate® history
Owner options
List your home for rent
$2,563/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$2,563/mo
Rent Zestimate®
Refinance and save
$85/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$85/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Inviting front covered porchGenerously sized bedroomsCharming breakfast areaSerene wooded lotCozy back patioSurrounded by large windowsAbundant natural light
Zillow last checked:
Listing updated:
Listed by:
Lori Brockman 573-864-4702,
Weichert, Realtors - First Tier 573-256-8601,
Kelsey Brockman 573-864-8778,
Weichert, Realtors - First Tier
Bought with:
David DeSmit, 2020015103
Weichert, Realtors - First Tier
Source: CBORMLS,MLS#: 423945
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Full bathroom
- Level: Lower
Full bathroom
- Level: Upper
Full bathroom
- Level: Upper
Half bathroom
- Level: Main
Heating
- Forced Air, Natural Gas
Cooling
- Central Electric
Appliances
- Laundry: Washer/Dryer Hookup
Features
- High Speed Internet, Stand AloneShwr/MBR, Eat-in Kitchen, Formal Dining, Laminate Counters, Wood Cabinets
- Flooring: Wood, Carpet, Ceramic Tile, Tile, Vinyl
- Doors: Storm Door(s)
- Windows: Some Window Treatments
- Has basement: Yes
- Has fireplace: Yes
- Fireplace features: Gas
Interior area
- Total structure area: 3,037
- Total interior livable area: 3,037 sqft
- Finished area below ground: 785
Property
Parking
- Total spaces: 2
- Parking features: Attached, Paved
- Attached garage spaces: 2
Features
- Levels: 2 Story
- Patio & porch: Concrete, Back, Deck, Front Porch
- Has spa: Yes
- Spa features: Tub/Built In Jetted
Lot
- Size: 0.26 Acres
- Dimensions: 90 x 125
- Features: Rolling Slope, Curbs and Gutters
- Residential vegetation: Partially Wooded
Details
- Parcel number: 1270100012260001
- Zoning description: R-1 One- Family Dwelling*
- Other equipment: Satellite Dish
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Foundation: Concrete Perimeter
Condition
- Year built: 2002
Details
- Builder name: Pate-Jones
Utilities & green energy
- Electric: County
- Gas: Gas-Natural
- Sewer: City
- Water: Public
- Utilities for property: Natural Gas Connected, Trash-City
Community & HOA
Community
- Security: Smoke Detector(s)
- Subdivision: Arcadia
HOA
- Has HOA: Yes
- HOA fee: $85 annually
Location
- Region: Columbia
Financial & listing details
- Tax assessed value: $252,900
- Annual tax amount: $2,831
- Date on market: 11/26/2024
Price history
| Date | Event | Price |
|---|---|---|
| 1/21/2025 | Sold | -- |
Source:  CBORMLS #423945 Report a problem | ||
| 12/10/2024 | Pending sale | $350,000$115/sqft |
Source: CBORMLS #423945 Report a problem | ||
| 11/26/2024 | Listed for sale | $350,000+40.6%$115/sqft |
Source: CBORMLS #423945 Report a problem | ||
| 2/3/2020 | Sold | -- |
Source: CBORMLS #520001_388785 Report a problem | ||
| 10/18/2019 | Listed for sale | $249,000+18.6%$82/sqft |
Source: Weichert, Realtors - First Tier #388785 Report a problem | ||
| 5/14/2012 | Sold | -- |
Source: CBORMLS #338651 Report a problem | ||
| 3/23/2012 | Price change | $209,900-2.4%$69/sqft |
Source: Weichert, Realtors First-Tier #334883 Report a problem | ||
| 12/24/2011 | Price change | $215,000+2.4%$71/sqft |
Source: Weichert, Realtors First-Tier #334883 Report a problem | ||
| 10/19/2011 | Price change | $209,900-2.4%$69/sqft |
Source: Weichert Realtors #334883 Report a problem | ||
| 8/10/2011 | Price change | $215,000-6.5%$71/sqft |
Source: Weichert Realtors #334883 Report a problem | ||
| 7/21/2011 | Listed for sale | $229,900+0.9%$76/sqft |
Source: Wechert, REALTORS-First Tier #334883 Report a problem | ||
| 2/21/2011 | Listing removed | $227,900$75/sqft |
Source: RE/MAX Boone Realty #329141 Report a problem | ||
| 8/21/2010 | Listed for sale | $227,900-0.9%$75/sqft |
Source: Boone Group Ltd dba RE/MAX Boone Realty #329141 Report a problem | ||
| 11/30/2009 | Listing removed | $229,900$76/sqft |
Source: Century 21 Advantage #321987 Report a problem | ||
| 11/2/2009 | Price change | $229,900-4.2%$76/sqft |
Source: Century 21 Advantage #321987 Report a problem | ||
| 8/8/2009 | Listed for sale | $239,900+6.6%$79/sqft |
Source: Century 21 Advantage #321987 Report a problem | ||
| 3/17/2008 | Listing removed | $225,000$74/sqft |
Source: Visual Tour #303090 Report a problem | ||
| 2/19/2008 | Listed for sale | $225,000$74/sqft |
Source: Visual Tour #303090 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $48,051 +14.5% |
| 2024 | $2,831 +0.8% | $41,971 |
| 2023 | $2,808 +8.1% | $41,971 +8% |
| 2022 | $2,597 -0.2% | $38,855 |
| 2021 | $2,602 -2.3% | $38,855 +4% |
| 2020 | $2,663 0% | $37,365 |
| 2019 | $2,663 +3.3% | $37,365 +4% |
| 2018 | $2,578 +1.2% | $35,929 |
| 2017 | $2,547 +0.2% | $35,929 |
| 2016 | $2,543 | $35,929 |
| 2015 | $2,543 +8.9% | $35,929 |
| 2014 | $2,335 | $35,929 |
| 2013 | -- | $35,929 |
| 2012 | -- | $35,929 |
| 2011 | -- | $35,929 |
| 2010 | -- | $35,929 |
| 2009 | -- | $35,929 |
| 2008 | -- | $35,929 |
| 2007 | -- | -- |
| 2003 | -- | $31,255 +996.7% |
| 2002 | -- | $2,850 |
| 2001 | -- | $2,850 |
Find assessor info on the county website
Neighborhood: Arcadia
Nearby homes
- $--4 bd3 ba2.9k sqft1902 Longstreet Dr, Columbia, MO 65202Sold
- $339,4003 bd3 ba1.6k sqft1906 Longstreet Dr, Columbia, MO 65202Off Market
- $374,5004 bd3 ba2.4k sqft4702 Hockaday Ct, Columbia, MO 65202Off Market
- $288,9003 bd2 ba1.6k sqft1901 Thoreau Ct, Columbia, MO 65202Off Market
- $413,5004 bd3 ba2.6k sqft1908 Longstreet Dr, Columbia, MO 65202Off Market
- $408,0004 bd3 ba2.8k sqft4700 Hockaday Ct, Columbia, MO 65202Off Market
- $362,5004 bd3 ba2.6k sqft1900 Longstreet Dr, Columbia, MO 65202Off Market
- $--3 bd2 ba1.5k sqft1900 Thoreau Ct, Columbia, MO 65202Sold
Nearby schools
GreatSchools rating
- 7/10Derby Ridge Elementary SchoolGrades: PK-5Distance: 0.7 mi
- 5/10John B. Lange Middle SchoolGrades: 6-8Distance: 0.4 mi
- 3/10Muriel Battle High SchoolGrades: 9-12Distance: 5.1 mi
Schools provided by the listing agent
- Elementary: Derby Ridge
- Middle: Lange
- High: Battle
Source: CBORMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Sell for more on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$376,000
2% more
+$7,520
With Zillow Showcase(estimated)
$383,520
- Missouri
- Boone County
- Columbia
- 65202
- Arcadia
- 1904 Longstreet Dr
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Columbia Topics
