Looking for the perfect spot on Main Street in Gaston?This prime lot offers excellent road frontage, great visibility, and a high-traffic location with flexible potential for either commercial or residential use. Whether you’re dreaming of opening a business or building a new home, this property gives you room to make it happen.Septic permit is already in hand, making it even easier to move forward.Opportunities like this in a growing area don’t last long. Message today for more details or to schedule a look! 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] => 136786
[post_author] => 1
[ListingKey] => 642268
[ListingId] => 642268
[PropertyType] => Land
[StandardStatus] => Active
[ModificationTimestamp] => 2026-09-03T13:38:35Z
[RFModificationTimestamp] => 2026-09-03T13:41:37Z
[ListPrice] => 49000
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 0.07
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => Columbia
[PostalCode] => 29201
[UnparsedAddress] => 357 Canal Place Drive, Columbia, SC 29201
[Coordinates] => Array
(
[0] => -81.056583
[1] => 34.017977
)
[Latitude] => 34.017977
[Longitude] => -81.056583
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => Derrick Team Realty LLC
[ListAgentMlsId] => 12321
[ListOfficeMlsId] => 1995
[OriginatingSystemName] => columbiamls
[PublicRemarks] => 1 lot in the established neighborhood of Canal Place! Ready for you and your builder! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[AssociationYN] =>
[BuildingAreaUnits] => Sqft
[CountyOrParish] => Richland
[CreationDate] => 2026-09-03T13:35:55.532436+00:00
[Directions] => River Drive to Northwood, left on Richfield, right on Canal Place Drive.
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => Hope@thederrickteam.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2026-09-03
[PhotosChangeTimestamp] => 2026-09-03T13:35:11Z
[PhotosCount] => 1
[RoadFrontageType] => County
[RoadSurfaceType] => Paved
[Sewer] => Public
[StateOrProvince] => SC
[StreetName] => Canal Place
[StreetNumber] => 357
[StreetSuffix] => Drive
[SubdivisionName] => CANAL PLACE
[WaterSource] => Available
[TMS] => 09105-15-86
[Address] => 357 Canal Place Drive
[LVTDate] => 2026-09-03
[HighSchool] => Columbia
[class_name] => LD_2
[LA1UserCode] => DERRH
[MiddleSchool] => St Andrews
[ShortSaleY/N] => No
[GeoSubdivision] => SC
[SchoolDistrict] => Richland One
[LO1MainOfficeID] => 1995
[ElementarySchool] => Logan
[LA1AgentLastName] => Derrick
[RollbackTax(Y/N)] => No
[LA1AgentFirstName] => Hope
[ForeclosedProperty] => No
[GeoUpdateTimestamp] => 2026-09-03T13:35:11.1
[AddressSearchNumber] => 357
[LO1OfficeIdentifier] => 1995
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[LO1OfficeAbbreviation] => DETR01
[FirstPhotoAddTimestamp] => 2026-09-03T13:35:11.7
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6422680
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642268/4dd8269227330fc07351a3ba7545780a.webp
[ClassName] =>
[MediaSize] => 1066815
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642268/thumbnail-4dd8269227330fc07351a3ba7545780a.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642268
)
)
[DaysOnMarket] => 0
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('642268')
[ID] => 136786
)
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 638686 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] => 133437
[post_author] => 1
[ListingKey] => 638686
[ListingId] => 638686
[PropertyType] => Land
[StandardStatus] => Active
[ModificationTimestamp] => 2026-07-24T16:45:08Z
[RFModificationTimestamp] => 2026-07-24T16:50:05Z
[ListPrice] => 135000
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 1.03
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => Gaston
[PostalCode] => 29053
[UnparsedAddress] => 245 South Main Street, Gaston, SC 29053
[Coordinates] => Array
(
[0] => -81.102254
[1] => 33.812166
)
[Latitude] => 33.812166
[Longitude] => -81.102254
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => Coldwell Banker Realty
[ListAgentMlsId] => 12015
[ListOfficeMlsId] => 1097
[OriginatingSystemName] => columbiamls
[PublicRemarks] => Looking for the perfect spot on Main Street in Gaston?This prime lot offers excellent road frontage, great visibility, and a high-traffic location with flexible potential for either commercial or residential use. Whether you’re dreaming of opening a business or building a new home, this property gives you room to make it happen.Septic permit is already in hand, making it even easier to move forward.Opportunities like this in a growing area don’t last long. Message today for more details or to schedule a look! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[AssociationYN] =>
[BuildingAreaUnits] => Sqft
[CountyOrParish] => Lexington
[CreationDate] => 2026-07-15T18:34:20.716972+00:00
[Directions] => GPS 245 South Main Street
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => teresa.coleman@cbcarolinas.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2026-07-15
[PhotosChangeTimestamp] => 2026-07-15T18:26:55Z
[PhotosCount] => 2
[RoadFrontageType] => County
[RoadSurfaceType] => Paved
[Sewer] => Public
[StateOrProvince] => SC
[StreetName] => South Main
[StreetNumber] => 245
[StreetSuffix] => Street
[SubdivisionName] => NONE
[WaterSource] => Public
[TMS] => 010117-04-009
[Address] => 245 South Main Street
[LVTDate] => 2026-07-15
[class_name] => LD_2
[LA1UserCode] => COLETE
[AgentHitCount] => 24
[GeoSubdivision] => SC
[SchoolDistrict] => Lexington Four
[LO1MainOfficeID] => 1089
[LA1AgentLastName] => Coleman
[RollbackTax(Y/N)] => No
[LA1AgentFirstName] => Teresa
[GeoUpdateTimestamp] => 2026-07-15T18:26:55.6
[AddressSearchNumber] => 245
[LO1OfficeIdentifier] => 1097
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[LA1AgentMiddleInitial] => A
[LO1OfficeAbbreviation] => CBRB09
[FirstPhotoAddTimestamp] => 2026-07-15T18:26:55.9
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6386860
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/638686/c8a253bdf09bde7a78fba0b1c892ea9e.webp
[ClassName] =>
[MediaSize] => 165730
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/638686/thumbnail-c8a253bdf09bde7a78fba0b1c892ea9e.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 638686
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6386861
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/638686/0cd921d15566c3167109b636a308179b.webp
[ClassName] =>
[MediaSize] => 206049
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/638686/thumbnail-0cd921d15566c3167109b636a308179b.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 638686
)
)
[DaysOnMarket] => 40
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('638686')
[ID] => 133437
)
)
[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
[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