Great investment property located on both sides of I26 near the Little Mountain Exit 85. Eastbound side of I26 with approximately 28 acres and 1400 linear feet of road frontage and approximately 5 acres with 600 feet of road frontage on the westbound side. The property on the westbound side is located on Four Oaks Rd and has public water available. Located just 30 minutes from Downtown Columbia, 15 minutes to Newberry and Lake Murray. 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:11:15Z
[RFModificationTimestamp] => 2026-08-27T05:18:29Z
[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 556945 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] => 99784
[post_author] => 1
[ListingKey] => 556945
[ListingId] => 556945
[PropertyType] => Land
[StandardStatus] => Active
[ModificationTimestamp] => 2026-03-02T21:30:05Z
[RFModificationTimestamp] => 2026-06-09T06:00:35Z
[ListPrice] => 561000
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 33
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => Little Mountain
[PostalCode] => 29075
[UnparsedAddress] => 0 Parr Rd, Little Mountain, SC 29075
[Coordinates] => Array
(
[0] => -81.40203202
[1] => 34.21594744
)
[Latitude] => 34.21594744
[Longitude] => -81.40203202
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => Home Advantage Realty
[ListAgentMlsId] => 10743
[ListOfficeMlsId] => 1370
[OriginatingSystemName] => columbiamls
[PublicRemarks] => Great investment property located on both sides of I26 near the Little Mountain Exit 85. Eastbound side of I26 with approximately 28 acres and 1400 linear feet of road frontage and approximately 5 acres with 600 feet of road frontage on the westbound side. The property on the westbound side is located on Four Oaks Rd and has public water available. Located just 30 minutes from Downtown Columbia, 15 minutes to Newberry and Lake Murray. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[AssociationYN] =>
[BuildingAreaUnits] => Sqft
[CountyOrParish] => Newberry
[CreationDate] => 2026-03-02T21:35:08.462219+00:00
[Directions] => From I26 HWY 202 Exit 85 toward Pomaria, Right on Four Oaks, Property on the right. Remainder of the property turn right on Parr Rd, cross the bridge and right on frontage road. Frontage road dead ends at property.
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => ttimmerman@homeadvantagerealty.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2023-02-08
[PhotosChangeTimestamp] => 2026-03-02T07:01:03Z
[PhotosCount] => 2
[RoadFrontageType] => County
[RoadSurfaceType] => Paved
[Sewer] => None
[StateOrProvince] => SC
[StreetName] => Parr Rd
[StreetNumber] => 0
[SubdivisionName] => NONE
[WaterSource] => None
[TMS] => 696-11
[Address] => 0 Parr Rd
[LVTDate] => 2023-02-09
[HighSchool] => Mid-Carolina
[class_name] => LD_2
[LA1UserCode] => TIMMERT
[MiddleSchool] => Mid-Carolina
[AgentHitCount] => 282
[SchoolDistrict] => Newberry County
[LO1MainOfficeID] => 182
[ElementarySchool] => Little Mountain
[LA1AgentLastName] => Timmerman
[RollbackTax(Y/N)] => Unknown
[LA1AgentFirstName] => Tony
[ForeclosedProperty] => No
[GeoUpdateTimestamp] => 2023-02-09T22:28:53
[AddressSearchNumber] => 0
[LO1OfficeIdentifier] => 1370
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[LO1OfficeAbbreviation] => HOMA03
[FirstPhotoAddTimestamp] => 2023-02-20T17:16:03.9
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 5569450
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/556945/714319ced293be4c29e806b9fe446416.webp
[ClassName] =>
[MediaSize] => 480257
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/556945/thumbnail-714319ced293be4c29e806b9fe446416.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 556945
)
[1] => Array
(
[Order] => 1
[MediaKey] => 5569451
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/556945/63e11c340bd37e130471af3d9d2cb16d.webp
[ClassName] =>
[MediaSize] => 479040
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/556945/thumbnail-63e11c340bd37e130471af3d9d2cb16d.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 556945
)
)
[DaysOnMarket] => 177
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('556945')
[ID] => 99784
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.15 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