Property details
About 2208-2210 Shamrock Dr
Exceptional Duplex Opportunity - Ideal for Investors or Owner-Occupants! Don't miss this rare opportunity to own a spacious 6-bedroom, 4-bathroom duplex with a 4-car garage, perfectly suited for rental income or multigenerational living. Each side of this well-maintained property features 3 bedrooms , 2 full bathrooms, large walk-in closets, and an attached 2 car garage offering generous living space, privacy, and comfort. One unit is currently vacant and move-in ready, making it perfect for an owner-occupant looking to offset the mortgage with rental income—or an investor ready to lease at market rates. The occupied unit has a stable tenant in place, providing immediate cash flow. Easy to show!
Highlights
Summary
- Appliances: Dryer, Disposal, Oven/Range, Microwave, Washer, Refrigerator, Dishwasher
- Basement: No
- Heating: Natural Gas, Forced Air
- Cooling: Central Air
- List Price: $350,000
- Price/SqFt: $99
- Directions: Clark Ln, at round about take second exit onto Ballenger Pl. Turn right onto Geyser Blvd. Turn left onto Shamrock Dr. Property is second duplex on the left.
- Year Built: 2002
- Stories: 1
- Living Area: 3,512 SqFt
- MLS Number: 427880
- MLS Name: Columbia Board of REALTORS®
- Office Name: Central Missouri Real Estate
- Office Phone: (573) 818-5533
- Office Email: natwier.realtor@gmail.com
- Listing Agent: Natalie Wier
Listing information comes in part from the Internet Data Exchange (IDX) of the Columbia Board of REALTORS ® or its Multiple Listing Service. IDX information is provided exclusively for consumers’ personal, non - commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS. Copyright © 2025 Columbia Board of REALTORS®. All rights reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 7/16/2025, 10:40:33 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
We're sorry, we currently don't have tax history data for this listing.
Nearby schools
3
Eliot Battle Elementary School
Public District PK-5
1.6 mi
•2600 Battle Ave
3
Blue Ridge Elementary School
Public District PK-5
2.4 mi
•3700 Woodland Dr
3
Alpha Hart Lewis Elementary School
Public District PK-5
3.2 mi
•5801 Arbor Pointe Pkwy
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $57,093. The most common annual income of people living in Columbia, MO is between $35k-100k. The most common type of family is single, no kids. Typical level of education for residents in this area is post secondary degree.
How much money do the neighbors make?
What level of education do the neighbors have?
What types of families live nearby?
Are the neighbors home owners or renters?
How old are people in this area?
What do the neighbors do for fun?
Pro Wrestling
Extreme Sports
College Football
Where do the neighbors shop?
Family Dollar
Academy Sports & Outdoors
Express/Express For Men
Where do the neighbors go to eat?
Dominos Pizza
Little Caesars
Sonic
What do the neighbors drive?
Ford
Chevrolet
Kia
What do the neighbors listen to?
New Country
Country
Oldies
Frequently asked questions
Living in Columbia, MO
Columbia's transport infrastructure includes a public transit system that serves residents with routes connecting key areas of the city. The availability of ride-sharing services complements the public transportation options, providing flexibility for residents. The city is designed with walkability in mind, particularly in the downtown area and near the university, where pedestrian traffic is common. A network of roads and highways facilitates commuting and travel to and from Columbia, with ongoing projects aimed at improving transport efficiency and accessibility.
The community benefits from a robust educational system, with multiple public and private schools that cater to various educational needs, including higher education institutions. Healthcare services in Columbia are comprehensive, with several hospitals and clinics offering a range of medical care, from primary to specialized treatments. The city also features a network of public libraries and a variety of retail and dining options that reflect the local culture. City initiatives are in place to continually enhance these services, adapting to the growing and diverse population.
Columbia is celebrated for its vibrant community spirit and cultural richness. The city prides itself on being home to numerous festivals and events that showcase its artistic and educational heritage. As a college town, the atmosphere is dynamic, with a youthful energy that permeates local cafes, bookstores, and public spaces. The community's character is further defined by its commitment to preserving green spaces and promoting a family-friendly environment.
Columbia's housing market is diverse, offering a mix of residential options that cater to a range of preferences and budgets. Single-family homes are prevalent, with architectural styles ranging from traditional to contemporary, reflecting the city's growth and evolving tastes. The market also includes a selection of apartments and townhouses, providing alternatives for those seeking a more urban living experience. The area features a homeownership rate that is reflective of a community with a healthy balance between owning and renting.
About 2208-2210 Shamrock Dr
The listing price of 2208-2210 Shamrock Dr property is $350,000.
The property 2208-2210 Shamrock Dr is a multi located in Columbia, Missouri, 65202.
Active Listing: 2208-2210 Shamrock Dr is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 2208-2210 Shamrock Dr are: Eliot Battle Elementary School (GreatSchools Rating 3/10), Blue Ridge Elementary School (GreatSchools Rating 3/10), Alpha Hart Lewis Elementary School (GreatSchools Rating 3/10), Oakland Middle School (GreatSchools Rating 3/10), Lange Middle School (GreatSchools Rating 2/10), Jefferson Middle School (GreatSchools Rating 5/10), Muriel Battle High School (GreatSchools Rating 3/10), Hickman High School (GreatSchools Rating 5/10), Frederick Douglass High School (GreatSchools Rating 1/10).
The property 2208-2210 Shamrock Dr is 3,512 SqFt (source: MLS/tax record).
The year of construction for 2208-2210 Shamrock Dr is 2002.
This home is located at 2208-2210 Shamrock Dr in Columbia, MO and zip code 65202. This 3,512 square foot home was built in 2002. Features: 0 bathroom. It has been listed on Rocket Homes since June 18, 2025 and is currently priced at $350,000.
Columbia, MO housing market in June 2025 saw over 69 listings sold above listed price, more than 58 sold at listed price and over 58 sold below. The inventory of homes for sale in Columbia, MO between May and June 2025 decreased by 6.5%. While the average time on the market in June 2025 was 28 days, the median list price was $315,000.