Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
Array
(
[RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(PropertyType eq 'Land' or PropertyType eq 'Residential' or PropertyType eq 'Residential Income') and (Appliances eq 'Patio,Front Porch - Uncovered' OR ArchitecturalStyle eq 'Patio,Front Porch - Uncovered' OR CommunityFeatures eq 'Patio,Front Porch - Uncovered' OR Cooling eq 'Patio,Front Porch - Uncovered' OR CountyOrParish eq 'Patio,Front Porch - Uncovered' OR ElementarySchool eq 'Patio,Front Porch - Uncovered' OR ExteriorFeatures eq 'Patio,Front Porch - Uncovered' OR Flooring eq 'Patio,Front Porch - Uncovered' OR Heating eq 'Patio,Front Porch - Uncovered' OR HighSchool eq 'Patio,Front Porch - Uncovered' OR InteriorFeatures eq 'Patio,Front Porch - Uncovered' OR ListingTerms eq 'Patio,Front Porch - Uncovered' OR MiddleOrJuniorSchool eq 'Patio,Front Porch - Uncovered' OR ParkingFeatures eq 'Patio,Front Porch - Uncovered' OR PoolFeatures eq 'Patio,Front Porch - Uncovered' OR PropertyType eq 'Patio,Front Porch - Uncovered' OR Roof eq 'Patio,Front Porch - Uncovered' OR SchoolDistrict eq 'Patio,Front Porch - Uncovered' OR Sewer eq 'Patio,Front Porch - Uncovered' OR Utilities eq 'Patio,Front Porch - Uncovered' OR WaterfrontFeatures eq 'Patio,Front Porch - Uncovered') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true] => Array
(
[RF Response] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse Object
(
[items] => Array
(
[0] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 135647
[post_author] => 1
[ListingKey] => 641023
[ListingId] => 641023
[PropertyType] => Residential
[PropertySubType] => Townhouse
[StandardStatus] => Pending
[ModificationTimestamp] => 2026-09-15T23:58:58Z
[RFModificationTimestamp] => 2026-09-16T00:04:07Z
[ListPrice] => 225000
[BathroomsTotalInteger] => 2
[BathroomsHalf] => 1
[BedroomsTotal] => 2
[LotSizeArea] => 0
[LivingArea] => 1050
[BuildingAreaTotal] => 1050
[City] => Columbia
[PostalCode] => 29201
[UnparsedAddress] => 114 Gadsden Street, Columbia, SC 29201
[Coordinates] => Array
(
[0] => -81.033603
[1] => 33.985426
)
[Latitude] => 33.985426
[Longitude] => -81.033603
[YearBuilt] => 1986
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => Keller Williams The Downing Group
[ListAgentMlsId] => 18974
[ListOfficeMlsId] => 1732
[OriginatingSystemName] => columbiamls
[PublicRemarks] => WELCOME TO 114 GADSDEN STREET IN THE HEART OF COLUMBIA’S WHALEY SQUARE! This inviting home offers a comfortable layout with plenty of character and flexibility. The main living area features a cozy fireplace, beautiful flooring, and an abundance of natural light, creating a warm space to relax or entertain. The kitchen offers generous counter space, quartz countertops, modern appliances, and a convenient breakfast bar that opens naturally to the living area.The primary bedroom provides a comfortable retreat, while the second bedroom offers flexibility for guests, family, or personal space. Need room to work or unwind? The home also includes a dedicated office and media room, giving you options beyond the traditional bedroom-and-living-room setup. A half bath adds convenience for guests. Currently leased until July 31, 2027, providing an immediate rental income opportunity for investors. Location adds another layer of appeal, with the University of South Carolina and the energy of downtown Columbia close by. For investors, the proximity to USC makes this property particularly interesting as a potential student rental, while the flexible layout and two-bedroom configuration provide versatility for a variety of rental strategies. Step outside to enjoy the patio and privacy-fenced outdoor space, a great spot for morning coffee, grilling, or simply enjoying some fresh air. Whether you're looking for a place to call home or an investment in a location with strong rental potential, 114 Gadsden Street is worth a closer look. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[Appliances] => Dishwasher,Disposal,Refrigerator,Microwave Countertop
[ArchitecturalStyle] => Traditional
[AssociationYN] => 1
[Basement] => No Basement
[BuildingAreaUnits] => Sqft
[ConstructionMaterials] => Vinyl
[Cooling] => None
[CountyOrParish] => Richland
[CreationDate] => 2026-08-17T19:00:52.741858+00:00
[Directions] => Assembly St to Whaley St, turn left on Gadsden St
[ExteriorFeatures] => Patio,Front Porch - Uncovered
[Fencing] => Privacy Fence
[FireplaceFeatures] => Wood Burning
[Heating] => Central,Electric
[InteriorFeatures] => Attic Pull-Down Access
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => tj@thedowningteam.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => PENDING
[OriginalEntryTimestamp] => 2026-08-14
[PhotosChangeTimestamp] => 2026-09-15T23:58:58Z
[PhotosCount] => 16
[RoadFrontageType] => Paved
[RoomKitchenFeatures] => Bar,Floors-Vinyl,Cabinets-Painted,Counter Tops-Quartz
[Sewer] => Public
[StateOrProvince] => SC
[StreetName] => Gadsden
[StreetNumber] => 114
[StreetSuffix] => Street
[SubdivisionName] => WHALEY SQUARE
[WaterSource] => Public
[TMS] => 08981-01-15
[Baths] => 2
[Range] => Convection
[Garage] => None
[Address] => 114 Gadsden Street
[AssnFee] => 140
[LVTDate] => 2026-08-17
[PowerOn] => Yes
[BathsFull] => 1
[#ofStories] => 2
[2ndBedroom] => Bath-Shared,Ceilings-Box,Bath-Jack & Jill ,Ceiling Fan,Closet-Private,Floors - Vinyl
[BathsCombo] => 1 / 1
[HighSchool] => Dreher
[HouseFaces] => West
[IDXInclude] => Yes
[LivingRoom] => Fireplace,Molding,Ceilings-Box,Ceiling Fan,Floors - Vinyl
[New/Resale] => Resale
[OtherRooms] => Media Room,Other
[class_name] => RE_1
[LA1UserCode] => DOWNINGT
[GarageSpaces] => 0
[MiddleSchool] => Hand
[PricePerSQFT] => 214.29
[ShortSaleY/N] => No
[StatusDetail] => 0
[AgentHitCount] => 72
[Level-Kitchen] => Main
[MasterBedroom] => Ceilings-Box,Bath-Jack & Jill ,Bath-Shared,Ceiling Fan,Closet-Private,Floors - Vinyl
[AvailFinancing] => Cash,Conventional,FHA,VA
[FullBaths-Main] => 1
[GeoSubdivision] => SC
[HalfBaths-Main] => 1
[Level-Bedroom2] => Second
[SchoolDistrict] => Richland One
[LO1MainOfficeID] => 1732
[Level-OtherRoom] => Main
[OtherHeatedSqFt] => 0
[SeniorLivingY/N] => N
[AssocFeeIncludes] => Common Area Maintenance,Exterior Maintenance,Front Yard Maintenance,Landscaping,Trash
[ElementarySchool] => A.C. Moore
[LA1AgentLastName] => Downing
[ListPriceTotSqFt] => 214.29
[RollbackTax(Y/N)] => No
[Assn/RegimeFeePer] => Monthly
[DetitledMobileY/N] => N
[LA1AgentFirstName] => TJ
[Level-WasherDryer] => Second
[ForeclosedProperty] => No
[GeoUpdateTimestamp] => 2026-08-17T18:59:56.8
[AddressSearchNumber] => 114
[BrokerAttribContact] => tj@thedowningteam.com
[LO1OfficeIdentifier] => 1732
[Level-MasterBedroom] => Second
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[Interior#ofFireplaces] => 1
[LO1OfficeAbbreviation] => DOWG01
[FirstPhotoAddTimestamp] => 2026-08-17T18:59:58.1
[MlsAreaMajor] => Columbia - South
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6410230
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641023/e2756a7f9a06e0a719df586a7d20ca34.webp
[ClassName] => Townhouse
[MediaSize] => 1024199
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641023/thumbnail-e2756a7f9a06e0a719df586a7d20ca34.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641023
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6410231
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641023/ca0c0b78baeec19022d6ddaab593b6f9.webp
[ClassName] => Townhouse
[MediaSize] => 343201
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641023/thumbnail-ca0c0b78baeec19022d6ddaab593b6f9.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641023
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6410232
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641023/61f2a9771f81220d1b6aa96b30757b3b.webp
[ClassName] => Townhouse
[MediaSize] => 417131
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641023/thumbnail-61f2a9771f81220d1b6aa96b30757b3b.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641023
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6410233
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641023/d1530532d1419ab3ebc06f14160086ca.webp
[ClassName] => Townhouse
[MediaSize] => 362644
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641023/thumbnail-d1530532d1419ab3ebc06f14160086ca.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641023
)
[4] => Array
(
[Order] => 4
[MediaKey] => 6410234
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641023/605df65fe8fc64375c3139a5216cc18e.webp
[ClassName] => Townhouse
[MediaSize] => 262129
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641023/thumbnail-605df65fe8fc64375c3139a5216cc18e.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641023
)
[5] => Array
(
[Order] => 5
[MediaKey] => 6410235
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641023/cc2593e2e7447bef92351388ea633889.webp
[ClassName] => Townhouse
[MediaSize] => 314720
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641023/thumbnail-cc2593e2e7447bef92351388ea633889.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641023
)
[6] => Array
(
[Order] => 6
[MediaKey] => 6410236
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641023/ead5061c58ea8b39ae17fe7c9d9a85a1.webp
[ClassName] => Townhouse
[MediaSize] => 383390
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641023/thumbnail-ead5061c58ea8b39ae17fe7c9d9a85a1.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641023
)
[7] => Array
(
[Order] => 7
[MediaKey] => 6410237
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641023/8b2aa5bb0990a46ad6e3701745fb3c3f.webp
[ClassName] => Townhouse
[MediaSize] => 324810
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641023/thumbnail-8b2aa5bb0990a46ad6e3701745fb3c3f.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641023
)
[8] => Array
(
[Order] => 8
[MediaKey] => 6410238
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641023/f982056715b62a1efa536d9a8a59b753.webp
[ClassName] => Townhouse
[MediaSize] => 224773
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641023/thumbnail-f982056715b62a1efa536d9a8a59b753.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641023
)
[9] => Array
(
[Order] => 9
[MediaKey] => 6410239
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641023/d95ca0fe8ee95151c338964b9f3a1325.webp
[ClassName] => Townhouse
[MediaSize] => 217911
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641023/thumbnail-d95ca0fe8ee95151c338964b9f3a1325.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641023
)
[10] => Array
(
[Order] => 10
[MediaKey] => 64102310
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641023/9d103898c1e020be17d07a7be4b571d3.webp
[ClassName] => Townhouse
[MediaSize] => 340813
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641023/thumbnail-9d103898c1e020be17d07a7be4b571d3.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641023
)
[11] => Array
(
[Order] => 11
[MediaKey] => 64102311
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641023/63ed60f70abbff14c0ab784208965fd3.webp
[ClassName] => Townhouse
[MediaSize] => 128371
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641023/thumbnail-63ed60f70abbff14c0ab784208965fd3.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641023
)
[12] => Array
(
[Order] => 12
[MediaKey] => 64102312
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641023/8ee9deeb98af0b61e09557224a0a4169.webp
[ClassName] => Townhouse
[MediaSize] => 353456
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641023/thumbnail-8ee9deeb98af0b61e09557224a0a4169.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641023
)
[13] => Array
(
[Order] => 13
[MediaKey] => 64102313
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641023/31e369adcf8d5d82297563ffd97b2b79.webp
[ClassName] => Townhouse
[MediaSize] => 448386
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641023/thumbnail-31e369adcf8d5d82297563ffd97b2b79.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641023
)
[14] => Array
(
[Order] => 14
[MediaKey] => 64102314
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641023/983230ac159fed2d75091a3e6fee76fe.webp
[ClassName] => Townhouse
[MediaSize] => 844722
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641023/thumbnail-983230ac159fed2d75091a3e6fee76fe.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641023
)
[15] => Array
(
[Order] => 15
[MediaKey] => 64102315
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641023/f811571e7f5041908e223e7503624189.webp
[ClassName] => Townhouse
[MediaSize] => 1025508
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641023/thumbnail-f811571e7f5041908e223e7503624189.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641023
)
)
[DaysOnMarket] =>
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('641023')
[ID] => 135647
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.14 seconds
)
)