This prime commercial property, located just steps away from the bustling Harbison Blvd shopping corridor, offers an exceptional opportunity for business owners and developers alike. Overlooking the serene Woodcross Pond, the site combines high visibility and tranquil surroundings, providing a unique setting for various commercial ventures. Zoned PUD-C, the property offers flexible usage options, ideal for retail, office, or mixed-use development. With its strategic location near major retail, dining, and residential areas, as well as easy access to key transportation routes, this property is positioned for long-term growth. 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] => 136277
[post_author] => 1
[ListingKey] => 641687
[ListingId] => 641687
[PropertyType] => Land
[StandardStatus] => Active
[ModificationTimestamp] => 2026-08-27T05:03:12Z
[RFModificationTimestamp] => 2026-08-27T05:09:48Z
[ListPrice] => 24900
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 0.23
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => Columbia
[PostalCode] => 29203
[UnparsedAddress] => 5224 Middleton Street, Columbia, SC 29203
[Coordinates] => Array
(
[0] => -81.020143
[1] => 34.047974
)
[Latitude] => 34.047974
[Longitude] => -81.020143
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => Ouzts Realty Company LLC
[ListAgentMlsId] => 16916
[ListOfficeMlsId] => 1561
[OriginatingSystemName] => columbiamls
[PublicRemarks] => A rare opportunity to build in an established Columbia neighborhood. This vacant residential lot previously held a single-family home that was removed in 2024, leaving a cleared, ready-to-build homesite. With utility connections likely already in place from the prior residence (verify with the city/county), this lot offers a head start over raw, undeveloped land.Located in a convenient area close to local schools, shopping, and downtown Columbia, 5224 Middleton St is well-suited for a custom home build, spec home, or investment property. Whether you're a builder looking for your next project or a buyer ready to design your dream home, this lot provides flexibility and potential in a desirable setting. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[AssociationYN] =>
[BuildingAreaUnits] => Sqft
[CountyOrParish] => Richland
[CreationDate] => 2026-08-27T04:55:36.555050+00:00
[Directions] => Continue onto SC-555 N, 1.3 mi, Turn left onto Standish St ,0.3 mi Turn right onto Middleton St
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => robert@ouztsrealty.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2026-08-24
[PhotosChangeTimestamp] => 2026-08-27T04:52:51Z
[PhotosCount] => 4
[RoadFrontageType] => City
[RoadSurfaceType] => Paved
[Sewer] => Public
[StateOrProvince] => SC
[StreetName] => Middleton
[StreetNumber] => 5224
[StreetSuffix] => Street
[SubdivisionName] => COLLEGE PLACE
[WaterSource] => Public
[Zoning] => RSF-3
[TMS] => 11608-08-07
[Address] => 5224 Middleton Street
[LVTDate] => 2026-08-27
[LotSize] => 0
[class_name] => LD_2
[LA1UserCode] => OUZTSR
[GeoSubdivision] => SC
[LO1MainOfficeID] => 1561
[LA1AgentLastName] => Ouzts
[RollbackTax(Y/N)] => No
[LA1AgentFirstName] => Robert
[GeoUpdateTimestamp] => 2026-08-27T04:52:50.5
[AddressSearchNumber] => 5224
[LO1OfficeIdentifier] => 1561
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[LO1OfficeAbbreviation] => OUZT01
[FirstPhotoAddTimestamp] => 2026-08-27T04:52:51.3
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6416870
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641687/a5d00761787f63656e2d2c54f5bfbf76.webp
[ClassName] =>
[MediaSize] => 822282
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641687/thumbnail-a5d00761787f63656e2d2c54f5bfbf76.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641687
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6416871
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641687/a8b1a0977670bbcf158adfb0609abc57.webp
[ClassName] =>
[MediaSize] => 693640
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641687/thumbnail-a8b1a0977670bbcf158adfb0609abc57.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641687
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6416872
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641687/db7e84bffc278de60931e60e6be80472.webp
[ClassName] =>
[MediaSize] => 851977
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641687/thumbnail-db7e84bffc278de60931e60e6be80472.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641687
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6416873
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641687/d6ced16b98d44c3cbd1ee30aec31e797.webp
[ClassName] =>
[MediaSize] => 824136
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641687/thumbnail-d6ced16b98d44c3cbd1ee30aec31e797.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641687
)
)
[DaysOnMarket] => 0
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('641687')
[ID] => 136277
)
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 627482 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] => 122848
[post_author] => 1
[ListingKey] => 627482
[ListingId] => 627482
[PropertyType] => Land
[StandardStatus] => Active
[ModificationTimestamp] => 2026-02-23T16:12:45Z
[RFModificationTimestamp] => 2026-06-09T06:01:37Z
[ListPrice] => 399000
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 1.15
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => Columbia
[PostalCode] => 29212-2036
[UnparsedAddress] => 0 Woodcross Drive, Columbia, SC 29212-2036
[Coordinates] => Array
(
[0] => -81.1497830711
[1] => 34.0777953808
)
[Latitude] => 34.0777953808
[Longitude] => -81.1497830711
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => EXIT Palmetto Real Estate Serv
[ListAgentMlsId] => 15870
[ListOfficeMlsId] => 976
[OriginatingSystemName] => columbiamls
[PublicRemarks] => This prime commercial property, located just steps away from the bustling Harbison Blvd shopping corridor, offers an exceptional opportunity for business owners and developers alike. Overlooking the serene Woodcross Pond, the site combines high visibility and tranquil surroundings, providing a unique setting for various commercial ventures. Zoned PUD-C, the property offers flexible usage options, ideal for retail, office, or mixed-use development. With its strategic location near major retail, dining, and residential areas, as well as easy access to key transportation routes, this property is positioned for long-term growth. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[AssociationYN] => 1
[BuildingAreaUnits] => Sqft
[CountyOrParish] => Richland
[CreationDate] => 2026-02-23T16:16:42.284519+00:00
[Directions] => From Harbison Blvd. turn onto Woodcross Drive. Parcel is on the left adjacent to the Wendy's.
[Fencing] => None
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => andrew@exitpalmetto.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2026-02-23
[PhotosChangeTimestamp] => 2026-02-23T16:12:45Z
[PhotosCount] => 3
[RoadFrontageType] => County
[RoadSurfaceType] => Paved
[Sewer] => Available,Public
[StateOrProvince] => SC
[StreetName] => Woodcross
[StreetNumber] => 0
[StreetSuffix] => Drive
[SubdivisionName] => NONE
[WaterSource] => Available,Public
[WaterfrontFeatures] => Common Pond
[Zoning] => PUD-C
[TMS] => 04907-02-01
[Address] => 0 Woodcross Drive
[LVTDate] => 2026-02-23
[HighSchool] => Irmo
[Topography] => Pond,Rolling,Wooded
[class_name] => LD_2
[LA1UserCode] => DIEGA
[LotLocation] => Water
[Improvements] => Curbs
[MiddleSchool] => Irmo
[ShortSaleY/N] => No
[AvailFinancing] => Cash,Conventional
[GeoSubdivision] => SC
[SchoolDistrict] => Lexington/Richland Five
[LO1MainOfficeID] => 976
[ElementarySchool] => Leaphart
[LA1AgentLastName] => Diegel
[RollbackTax(Y/N)] => Unknown
[LA1AgentFirstName] => Andrew
[ForeclosedProperty] => No
[GeoUpdateTimestamp] => 2026-02-23T16:12:45.2
[AddressSearchNumber] => 0
[LO1OfficeIdentifier] => 976
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[LO1OfficeAbbreviation] => EPAL01
[FirstPhotoAddTimestamp] => 2026-02-23T16:12:45.4
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6274820
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/627482/0c25b516c7b5c69ca639426cf0555515.webp
[ClassName] =>
[MediaSize] => 778877
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/627482/thumbnail-0c25b516c7b5c69ca639426cf0555515.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 627482
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6274821
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/627482/1ec113d9a793314737f1df8856b90aca.webp
[ClassName] =>
[MediaSize] => 1443544
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/627482/thumbnail-1ec113d9a793314737f1df8856b90aca.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 627482
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6274822
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/627482/8d48074c1843a2768a74a0aab3ec2f59.webp
[ClassName] =>
[MediaSize] => 1152767
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/627482/thumbnail-8d48074c1843a2768a74a0aab3ec2f59.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 627482
)
)
[DaysOnMarket] => 184
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('627482')
[ID] => 122848
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.22 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