Start with Columbia if the priority is a lower acquisition price or a stronger gross-yield screen. Its Zillow home-value index is $232,810 versus $333,224 in Greenville, while its index-based gross yield is 7.6% versus 5.6%. Start in Columbia when the acquisition budget is tight. Compare property-level net cash flow before choosing either city. Test that apparent advantage with an actual purchase price, achievable rent, vacancy assumptions and a property-specific expense budget.
Greenville is the better starting point if renter affordability is the concern. Measured rent burden is lower there, at 50.2% versus 60.0% in Columbia, though it is substantial in both cities. Let the asset type guide the housing search. Columbia has a larger single-family share, at 55.1% versus 46.9%, while Greenville has a larger share in large multifamily buildings. Use those differences to guide the search, then check comparable leases and competing supply around the property.
Start a local demand review in Greenville when citywide employment and housing occupancy matter to the screen. Keep Columbia in the search. Greenville has lower measured unemployment (4.4% versus 7.5%) and lower overall housing vacancy (9.9% versus 14.4%), but Columbia’s Zillow rent index grew faster year over year (1.8% versus 0.9%). That faster growth gives a reason to examine recent Columbia leases alongside Greenville’s. Before choosing between properties, compare recent signed rents, concessions and time to lease for similar units in each neighborhood.

