Wonderful opportunity for an investor looking to build new rental properties in a good location, convenient to the VA Hospital, to work in conjunction with their patients and employees, not to mention its proximity to downtown. Plans for 12 One BR unit apartment complex in documents. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 140512
[post_author] => 1
[ListingKey] => 646520
[ListingId] => 646520
[PropertyType] => Land
[StandardStatus] => Active
[ModificationTimestamp] => 2026-11-07T22:04:22Z
[RFModificationTimestamp] => 2026-11-07T22:05:44Z
[ListPrice] => 44900
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 0.54
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => West Columbia
[PostalCode] => 29169
[UnparsedAddress] => 0 Jones Avenue, West Columbia, SC 29169
[Coordinates] => Array
(
[0] => -81.0914
[1] => 33.9931
)
[Latitude] => 33.9931
[Longitude] => -81.0914
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => South Carolina Realty
[ListAgentMlsId] => 1136
[ListOfficeMlsId] => 350
[OriginatingSystemName] => columbiamls
[PublicRemarks] => Approximately 0.54-acre wooded parcel with frontage on Jones Avenue in the City of West Columbia. Zoned R-4 and conveniently located near Sunset Boulevard, shopping, dining, and major commuter routes. Sloping, wooded terrain provides an opportunity for a buyer to explore potential residential use, subject to applicable zoning, utility availability, site conditions, and municipal approvals. Buyer to verify acreage, permitted uses, utilities, and suitability for intended development. This parcel is right behind 1617 Sunset Boulevard, which is also for sale and could be sold with that duplex. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[AssociationYN] =>
[BuildingAreaUnits] => Sqft
[CountyOrParish] => Lexington
[CreationDate] => 2026-11-07T22:05:36.133964+00:00
[Directions] => From I-26 at Highway 378, turn towards Columbia. Go approximately one mile, turn R on Jones Avenue. Property is on the corner at Sunset and Jones.
[Fencing] => None
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => msprousebrowne@gmail.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2026-11-07
[PhotosChangeTimestamp] => 2026-11-07T22:04:22Z
[PhotosCount] => 1
[RoadFrontageType] => County
[RoadSurfaceType] => Paved
[Sewer] => Public
[StateOrProvince] => SC
[StreetName] => Jones
[StreetNumber] => 0
[StreetSuffix] => Avenue
[SubdivisionName] => NONE
[WaterSource] => Public
[Zoning] => R4
[TMS] => 004645-02-077
[Address] => 0 Jones Avenue
[LVTDate] => 2026-11-07
[LotSize] => 120-185-101-241
[HighSchool] => Brookland-Cayce
[Topography] => Rolling,Wooded
[class_name] => LD_2
[LA1UserCode] => SPROUM
[LotLocation] => Corner
[MiddleSchool] => Northside
[RoadFrontage] => 120
[ShortSaleY/N] => No
[MobileAllowed] => No
[AvailFinancing] => Cash,Conventional,FHA,VA
[SchoolDistrict] => Lexington Two
[LO1MainOfficeID] => 350
[#ofLotsRemaining] => 1
[ElementarySchool] => Saluda River
[LA1AgentLastName] => Sprouse
[RollbackTax(Y/N)] => No
[LA1AgentFirstName] => Melissa
[ForeclosedProperty] => No
[GeoUpdateTimestamp] => 2026-11-07T22:04:22.4
[AddressSearchNumber] => 0
[LO1OfficeIdentifier] => 350
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[LO1OfficeAbbreviation] => SOCA01
[FirstPhotoAddTimestamp] => 2026-11-07T22:04:22.6
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6465200
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646520/0bea73372c9167a3cddfa96278e99fcb.webp
[ClassName] =>
[MediaSize] => 316850
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646520/thumbnail-0bea73372c9167a3cddfa96278e99fcb.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646520
)
)
[DaysOnMarket] => 1
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('646520')
[ID] => 140512
)
MLS On The Fly Debug Panel
Array
(
[RF Query: /Property?$select=ALL&$top=20&$filter=(PropertyType eq 'Land' or PropertyType eq 'Residential' or PropertyType eq 'Residential Income') and ListingKey eq 638268 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] => 133033
[post_author] => 1
[ListingKey] => 638268
[ListingId] => 638268
[PropertyType] => Land
[StandardStatus] => Active
[ModificationTimestamp] => 2026-09-30T11:53:54Z
[RFModificationTimestamp] => 2026-09-30T11:59:10Z
[ListPrice] => 215000
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 1.08
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => Columbia
[PostalCode] => 29209
[UnparsedAddress] => 6430 Norris Street, Columbia, SC 29209
[Coordinates] => Array
(
[0] => -80.956517
[1] => 33.98498
)
[Latitude] => 33.98498
[Longitude] => -80.956517
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => Carter Realty, Inc
[ListAgentMlsId] => 5245
[ListOfficeMlsId] => 508
[OriginatingSystemName] => columbiamls
[PublicRemarks] => Wonderful opportunity for an investor looking to build new rental properties in a good location, convenient to the VA Hospital, to work in conjunction with their patients and employees, not to mention its proximity to downtown. Plans for 12 One BR unit apartment complex in documents. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[AssociationYN] =>
[BuildingAreaUnits] => Sqft
[CountyOrParish] => Richland
[CreationDate] => 2026-07-09T13:28:14.441510+00:00
[Directions] => Garners Ferry to Cedar Terrace, right at Norris St., property on left at right turn at intersection with Drake Street.
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => johnbblackmon@att.net
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2026-07-09
[PhotosChangeTimestamp] => 2026-07-09T13:23:27Z
[PhotosCount] => 4
[RoadFrontageType] => State
[RoadSurfaceType] => Paved
[Sewer] => Public
[StateOrProvince] => SC
[StreetName] => Norris
[StreetNumber] => 6430
[StreetSuffix] => Street
[SubdivisionName] => CEDAR TERRACE
[WaterSource] => Public
[Zoning] => MU-1
[TMS] => 16505-02-05
[Address] => 6430 Norris Street
[LVTDate] => 2026-07-09
[HighSchool] => A. C. Flora
[class_name] => LD_2
[LA1UserCode] => BLACKMJ
[MiddleSchool] => Crayton
[RoadFrontage] => 110
[AgentHitCount] => 30
[GeoSubdivision] => SC
[SchoolDistrict] => Richland One
[LO1MainOfficeID] => 508
[#ofLotsRemaining] => 0
[ElementarySchool] => Brennen
[LA1AgentLastName] => Blackmon
[RollbackTax(Y/N)] => Unknown
[LA1AgentFirstName] => John
[GeoUpdateTimestamp] => 2026-07-09T13:23:26.9
[AddressSearchNumber] => 6430
[LO1OfficeIdentifier] => 508
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[LA1AgentMiddleInitial] => B
[LO1OfficeAbbreviation] => CART01
[FirstPhotoAddTimestamp] => 2026-07-09T13:23:27.5
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6382680
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/638268/9757728bcc47b77892b27a7a46951ddd.webp
[ClassName] =>
[MediaSize] => 1185400
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/638268/thumbnail-9757728bcc47b77892b27a7a46951ddd.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 638268
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6382681
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/638268/4f30c888414aca2a74628eb2f80dafd4.webp
[ClassName] =>
[MediaSize] => 1128755
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/638268/thumbnail-4f30c888414aca2a74628eb2f80dafd4.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 638268
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6382682
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/638268/9c32a2af1fc0920345061b0e94fe285f.webp
[ClassName] =>
[MediaSize] => 1258789
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/638268/thumbnail-9c32a2af1fc0920345061b0e94fe285f.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 638268
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6382683
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/638268/d4207be5e2c497557e93428146ab6cc8.webp
[ClassName] =>
[MediaSize] => 1483593
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/638268/thumbnail-d4207be5e2c497557e93428146ab6cc8.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 638268
)
)
[DaysOnMarket] => 122
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('638268')
[ID] => 133033
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.18 seconds
)
)
MLS On The Fly Debug Panel
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147