5200 Shoreview Drive
Concord, NC 28025
$915,000
Active
- 4 bedrooms
- 6 bathrooms
- 3,301 sq ft
- 1 acre lot
- built 2020
About this home
Welcome to a one-of-a-kind custom home where modern luxury, thoughtful design, and an income-producing VRBO come together seamlessly. Built in 2020, this stunning property was designed for both elevated everyday living and unforgettable entertaining, with the VRBO producing $30000/year. As you enter the home, the foyer immediately sets the tone with curated art display walls accented by dedicated lighting, creating a true gallery-style entrance. Rich black walnut hardwood floors run throughout the home, complementing the open-concept main living area that combines the living room, dining space, and chef’s kitchen into one expansive and inviting gathering space. The kitchen features luxury Dacor appliances, abundant workspace, and upscale finishes throughout. Anchoring the living room is a dramatic 60” direct vent linear stone fireplace with reclaimed hand-hewn beam mantle and custom built-ins.
Massive 12’ sliding doors open to nearly 1,000 square feet of composite decking, extending the living space outdoors and creating the ultimate entertainment area. Built-in surround sound speakers inside and out, home automation capabilities, dimmable smart switches, and whole-home mesh WiFi wiring elevate the home’s modern functionality.
The primary suite on the main floor is a true retreat featuring heated tile floors, elegant crown lighting, oversized walk-in closet systems with adjustable custom shelving and shoe storage, plus a hidden concealed storage space. The spa-inspired bath showcases an oversized walk-through rain shower with full body sprayers and luxury finishes throughout.
Two additional oversized bedrooms are also located on the main floor, each with their own private bathroom and spacious custom closets. The laundry room was designed with practicality in mind, offering built-in folding space, additional sink, and direct access to the custom dog wash station before entering the oversized 3-car garage.
Upstairs offers flexible finished living space perfect for work, play, or guests. A large built-in office area provides an ideal workspace, while the loft overlooks the living room through a stunning custom 3D metal railing design. The soaring ceilings create enough vertical space for an impressive 17’ Christmas tree centerpiece during the holidays. An additional upstairs room, currently used as a playroom, connects to a full bathroom and guest suite tucked quietly away for ultimate privacy.
Adding even more value, the detached studio apartment above the garage offers approximately 1,000 square feet of additional living space and incredible income-producing potential. Thoughtfully designed with separation and privacy in mind, the guest suite features its own dedicated parking area behind the garage, ensuring privacy for both owners and guests. The spacious studio includes a full kitchen with appliances, open-concept living area, laundry space, full bathroom, and additional nook currently used for extra sleeping accommodations. Whether used as an Airbnb, in-law suite, guest quarters, or private office, this space offers exceptional flexibility and can significantly offset ownership costs.
Additional upgrades and features include authentic 1600s Croatian wine press screws incorporated into the front entry design, on-demand hot water system, irrigation system, prewired exterior security cameras, built-in whole-home speaker system, reclaimed architectural details, expansive storage solutions, and a 3-stage water filtration system.
This is far more than a home — it’s a carefully crafted lifestyle property blending luxury, functionality, character, and opportunity into one unforgettable package
The details
- MLS number
- 4386372
- Status
- Active
- Property type
- Single Family Residence
- Bedrooms
- 4
- Bathrooms
- 5 full, 1 half
- Living area
- 3,301 sq ft
- Lot
- 1 acres
- Year built
- 2020
- Levels
- Two
- Garage
- Yes
- Subdivision
- Lake Shore Estates
- County
- Cabarrus County
- Days on market
- 124
- Originally listed at
- $1,050,000
Facts and features
Interior
- Bedrooms by level
- Main 3, Upper 1
- Full bathrooms by level
- Main 3, Upper 1
- Half bathrooms by level
- Main 1
- Heating
- Central
- Cooling
- Central Air
- Laundry
- Laundry Room
- Basement
- No
- Fireplace
- Yes
- Appliances
- Dishwasher
- Disposal
- Double Oven
- Gas Cooktop
- Microwave
- Refrigerator with Ice Maker
- Tankless Water Heater
Rooms
| Room | Features |
|---|---|
| 2nd Living Quarters | |
| Bathroom-Full | |
| Kitchen | |
| Living Room | |
| Main | |
| Primary Bedroom | |
| Bathroom-Full | |
| Living Room | |
| Kitchen | |
| Bedroom(s) | |
| Bedroom(s) | |
| Dining Room | |
| Laundry | |
| Upper | |
| Bathroom-Full | |
| Bedroom(s) | |
| Den | |
| Study | |
Square footage
- Above grade finished area
- 3,301 sq ft
- Below grade finished area
- 0 sq ft
- Main level area
- 2,521 sq ft
- Upper level area
- 780 sq ft
- Lower level area
- 0 sq ft
- Third level area
- 0 sq ft
- Unheated area
- 0 sq ft
- Total heated living area
- 4,096 sq ft
Property
- Garage spaces
- 3
- Parking
- Driveway, Attached Garage
- Open parking
- No
- Main level garage
- Yes
- Levels
- Two
- Parcel number
- 5568-32-4668-0000
- Zoning
- CR
- Zoning description
- CR
Construction
- Property sub type
- Single Family Residence
- Construction type
- Site Built
- Construction materials
- Fiber Cement
- Foundation
- Crawl Space
- New construction
- No
- Year built
- 2020
Utilities
- Sewer
- Septic Installed
- Water source
- Well
Community and HOA
- Subdivision
- Lake Shore Estates
- Has an association
- Yes
- Association fee
- $150, Annually
- Association
- Lake Shore Estates Inc
- Subject to HOA
- Optional
- City taxes paid to
- No City Taxes Paid
Financial and listing details
- Price per square foot
- $277 per sq ft (computed)
- Tax assessed value
- $846,240
- Date on market
- May 26, 2026
- Cumulative days on market
- 124
- Road surface
- Concrete, Paved
- Listing updated
- September 27, 2026
Price history for this listing
- Original list price
- $1,050,000
- Previous list price
- $950,000
- Price changed
- September 18, 2026
- Last change
- Price Change
- Last changed on
- September 18, 2026
Listing information
Listed by S and B Real Estate LLC
Listing agent: William Barbee
Email: WBARBEE@CAROLINA.RR.COM
MLS number 4386372 · Active
Listings courtesy of Canopy MLS as distributed by MLS GRID.
Some IDX listings have been excluded from this website.
IDX information is provided exclusively for consumers' 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 is deemed reliable but is not guaranteed by MLS GRID. Use of the Canopy MLS data may be subject to an end user licence agreement prescribed by Canopy MLS.
Any use or search of the data on this website, other than by a consumer looking to purchase real estate, is prohibited.
Think something here is wrong? Tell us at sunny@yatesrealty.com and we will correct or remove it. Copyright notices.