Newer construction DOWNTOWN COLUMBIA HOUSE-HACK OPPORTUNITY in one of Columbia's most charming & historic communities, Earlewood. This investment offers the perfect blend of modern comfort for the owner—the entire home was built in 2024 & great short- or long-term income-generating potential w/NO HOA, just minutes from I-26 & the University of South Carolina, making this perfect for families looking for an income-generating solution for their kids attending USC. The owner’s main residence (or luxurious short- or long-term rental) is located upstairs & offers a 3 bedroom, 2 bath home w/an open-concept kitchen/family room featuring high-end appliances/finishes & easy access to a private extra-deep, oversized deck overlooking the woods. The owner’s bedroom suite feels like a treehouse wrapped in windows & has a beautiful bath w/a huge walk-in shower w/forest views that feels like a vacation. Additional owner's-suite features include dual closets & a private screened-in porch perfect for large outdoor furniture. Bedrooms 2 & 3 are large & share a full bath in the hall, & there is also a flex/office. The main house has private laundry and sits over an oversized 2-car garage. There are 2 ways to enter the main residence, through the garage or from the back stairs/deck. There are 3 separate entrances for the rental apts: Apt 1 has a private entrance through the front/lower level or through the garage/laundry room, & Apt 2 has a private entrance through the back/lower level or through the garage/laundry room. Apt 1 has a den, kitchenette & private full bath. Apt 2 is a mirror image of Apt 1 & located at the back of the home. Between the 2 units, you’ll find a shared laundry room & garage access that can be locked by the owner if access isn’t permitted. 2 lots convey w/this property, totaling 0.52 acres, w/room to add additional space for expansion to create another potential apt (ask for details). This is a unique opportunity, a comfortable, luxurious living situation for the owner or high-end rental upstairs, & dual low-maintenance apts management. This is unlike any of its kind currently available in Columbia! Disclaimer: CMLS has not reviewed and, therefore, do D