Prime investment opportunity near Downtown Columbia! This cleared 7, 600 sq. ft. lot at 1006 Prescott Road has been newly zoned R5, allowing for multi-family use and duplex potential. Located just 10 minutes from Downtown Columbia and Five Points, with easy highway access and proximity to the N. Main Street bus line, this property offers strong positioning for new construction, rental housing, or a long-term portfolio hold. Sewer and water are ready, and the lot is cleared. Modular or site-built construction permitted. Deed and title are available. Buyer and buyer’s agent to verify all zoning, utilities, setbacks, building requirements, and intended use. 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] => 139508
[post_author] => 1
[ListingKey] => 645391
[ListingId] => 645391
[PropertyType] => Land
[StandardStatus] => Active
[ModificationTimestamp] => 2026-10-20T21:28:24Z
[RFModificationTimestamp] => 2026-10-20T21:31:55Z
[ListPrice] => 27900
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 0.33
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => Columbia
[PostalCode] => 29203
[UnparsedAddress] => 1364 Bon Air Dr, Columbia, SC 29203
[Coordinates] => Array
(
[0] => -81.04397423
[1] => 34.08144503
)
[Latitude] => 34.08144503
[Longitude] => -81.04397423
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => Kingfisher Realty
[ListAgentMlsId] => 17676
[ListOfficeMlsId] => 1930
[OriginatingSystemName] => columbiamls
[PublicRemarks] => Owner or Investor Special of the Year! Don't miss this fantastic opportunity to build your dream home or bring your next investment project to life. This cleared lot is ready for your vision, with clearing completed in 2026 and city water, sewer, and electricity already set up. A survey was also completed in 2026, providing added convenience as you plan your next steps. Located just minutes from downtown Columbia, this property offers excellent potential in an area experiencing significant revitalization and redevelopment. Whether you're an individual looking to build a home of your own or a builder seeking your next project, this lot is full of possibilities. Take advantage of this opportunity to invest in an area with exciting potential! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[AssociationYN] =>
[BuildingAreaUnits] => Sqft
[CountyOrParish] => Richland
[CreationDate] => 2026-10-20T21:31:35.743643+00:00
[Directions] => Turn off of Blue Ridge Terrence onto Bon Air Dr.
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => lpostonre@gmail.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2026-10-20
[PhotosChangeTimestamp] => 2026-10-20T21:28:24Z
[PhotosCount] => 7
[RoadFrontageType] => City
[RoadSurfaceType] => Paved
[Sewer] => Public
[StateOrProvince] => SC
[StreetName] => Bon Air Dr
[StreetNumber] => 1364
[SubdivisionName] => HASKELL HEIGHTS
[WaterSource] => Public
[TMS] => 09412-07-32
[Address] => 1364 Bon Air Dr
[LVTDate] => 2026-10-20
[HighSchool] => Eau Claire
[class_name] => LD_2
[LA1UserCode] => POSTONL
[MiddleSchool] => Alcorn
[GeoSubdivision] => SC
[LO1MainOfficeID] => 1930
[ElementarySchool] => John P. Thomas
[LA1AgentLastName] => Poston
[RollbackTax(Y/N)] => No
[LA1AgentFirstName] => Luke
[GeoUpdateTimestamp] => 2026-10-20T21:28:24.4
[AddressSearchNumber] => 1364
[LO1OfficeIdentifier] => 1930
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[LO1OfficeAbbreviation] => KIFR01
[FirstPhotoAddTimestamp] => 2026-10-20T21:28:24.6
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6453910
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645391/0266bc57b12b64a97eceda9361b21a05.webp
[ClassName] =>
[MediaSize] => 1368972
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645391/thumbnail-0266bc57b12b64a97eceda9361b21a05.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645391
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6453911
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645391/78cb87d99a74469950a2d28ad68aadf1.webp
[ClassName] =>
[MediaSize] => 954116
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645391/thumbnail-78cb87d99a74469950a2d28ad68aadf1.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645391
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6453912
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645391/89fe915696137ec771d81e5befbadaf3.webp
[ClassName] =>
[MediaSize] => 1064642
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645391/thumbnail-89fe915696137ec771d81e5befbadaf3.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645391
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6453913
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645391/7f28778090adbb1e0e3944aa39eb87f3.webp
[ClassName] =>
[MediaSize] => 1121812
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645391/thumbnail-7f28778090adbb1e0e3944aa39eb87f3.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645391
)
[4] => Array
(
[Order] => 4
[MediaKey] => 6453914
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645391/904a3474a2080ffe08f472985338643f.webp
[ClassName] =>
[MediaSize] => 1115731
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645391/thumbnail-904a3474a2080ffe08f472985338643f.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645391
)
[5] => Array
(
[Order] => 5
[MediaKey] => 6453915
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645391/2b38c2b3e1105cb1519a1b05e19724c7.webp
[ClassName] =>
[MediaSize] => 1373933
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645391/thumbnail-2b38c2b3e1105cb1519a1b05e19724c7.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645391
)
[6] => Array
(
[Order] => 6
[MediaKey] => 6453916
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645391/4dc8a94f357b243f9a90263300695f2c.webp
[ClassName] =>
[MediaSize] => 1118699
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645391/thumbnail-4dc8a94f357b243f9a90263300695f2c.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645391
)
)
[DaysOnMarket] => 0
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('645391')
[ID] => 139508
)
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 638117 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] => 132882
[post_author] => 1
[ListingKey] => 638117
[ListingId] => 638117
[PropertyType] => Land
[StandardStatus] => Active
[ModificationTimestamp] => 2026-07-08T12:30:34Z
[RFModificationTimestamp] => 2026-07-08T12:35:45Z
[ListPrice] => 40000
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 0.18
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => Columbia
[PostalCode] => 29203
[UnparsedAddress] => 1006 Prescott Road, Columbia, SC 29203
[Coordinates] => Array
(
[0] => -81.014854
[1] => 34.060015
)
[Latitude] => 34.060015
[Longitude] => -81.014854
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => Noelle B Collective
[ListAgentMlsId] => 13040
[ListOfficeMlsId] => 1925
[OriginatingSystemName] => columbiamls
[PublicRemarks] => Prime investment opportunity near Downtown Columbia! This cleared 7,600 sq. ft. lot at 1006 Prescott Road has been newly zoned R5, allowing for multi-family use and duplex potential. Located just 10 minutes from Downtown Columbia and Five Points, with easy highway access and proximity to the N. Main Street bus line, this property offers strong positioning for new construction, rental housing, or a long-term portfolio hold. Sewer and water are ready, and the lot is cleared. Modular or site-built construction permitted. Deed and title are available. Buyer and buyer’s agent to verify all zoning, utilities, setbacks, building requirements, and intended use. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[AssociationYN] =>
[BuildingAreaUnits] => Sqft
[CountyOrParish] => Richland
[CreationDate] => 2026-07-07T20:28:03.342235+00:00
[Directions] => From Downtown Columbia, take N Main Street toward the 29203 area. Turn onto Prescott Road and continue to 1008 Prescott Road. Lot will be located on Prescott Road. Use GPS for most accurate routing.
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => Keyonasquire@noellebcollective.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2026-07-07
[PhotosChangeTimestamp] => 2026-07-07T20:40:29Z
[PhotosCount] => 1
[RoadFrontageType] => City
[RoadSurfaceType] => Paved
[Sewer] => Public
[StateOrProvince] => SC
[StreetName] => Prescott
[StreetNumber] => 1006
[StreetSuffix] => Road
[SubdivisionName] => NONE
[WaterSource] => Public
[TMS] => 11711-12-40
[Address] => 1006 Prescott Road
[LVTDate] => 2026-07-07
[class_name] => LD_2
[LA1UserCode] => SQUK
[AgentHitCount] => 9
[GeoSubdivision] => SC
[LO1MainOfficeID] => 1925
[LA1AgentLastName] => Squire
[RollbackTax(Y/N)] => No
[LA1AgentFirstName] => Keyona
[GeoUpdateTimestamp] => 2026-07-08T12:30:34.9
[AddressSearchNumber] => 1006
[LO1OfficeIdentifier] => 1925
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[LO1OfficeAbbreviation] => NBCO01
[FirstPhotoAddTimestamp] => 2026-07-07T20:40:29.4
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6381170
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/638117/dbafcadd2e60f49fe88589973f0477f9.webp
[ClassName] =>
[MediaSize] => 316764
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/638117/thumbnail-dbafcadd2e60f49fe88589973f0477f9.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 638117
)
)
[DaysOnMarket] => 105
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('638117')
[ID] => 132882
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.11 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