Investment lot opportunity in Columbia. residential lot available in the North Columbia area of Columbia, South Carolina. Located near the Fairfield Road and Old Winnsboro Road corridor with convenient access to downtown Columbia, I-20, and I-77. This parcel offers potential for new construction or long-term investment. Buyer and buyer’s agent responsible for verifying zoning, utilities, lot size, restrictions, and buildability. Information deemed reliable but not guaranteed. Seller has additional parcels available in Richland County. Inquire with listing agent. 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 628499 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] => 123817
[post_author] => 1
[ListingKey] => 628499
[ListingId] => 628499
[PropertyType] => Land
[StandardStatus] => Active
[ModificationTimestamp] => 2026-03-06T23:23:16Z
[RFModificationTimestamp] => 2026-06-09T06:01:13Z
[ListPrice] => 23900
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 0.33
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => Columbia
[PostalCode] => 29203
[UnparsedAddress] => 6905 Old Winnsboro Rd, Columbia, SC 29203
[Coordinates] => Array
(
[0] => -81.0197
[1] => 34.0689
)
[Latitude] => 34.0689
[Longitude] => -81.0197
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => LPT Realty LLC
[ListAgentMlsId] => 14754
[ListOfficeMlsId] => 1744
[OriginatingSystemName] => columbiamls
[PublicRemarks] => Investment lot opportunity in Columbia. residential lot available in the North Columbia area of Columbia, South Carolina. Located near the Fairfield Road and Old Winnsboro Road corridor with convenient access to downtown Columbia, I-20, and I-77. This parcel offers potential for new construction or long-term investment. Buyer and buyer’s agent responsible for verifying zoning, utilities, lot size, restrictions, and buildability. Information deemed reliable but not guaranteed. Seller has additional parcels available in Richland County. Inquire with listing agent. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[AssociationYN] =>
[BuildingAreaUnits] => Sqft
[CountyOrParish] => Richland
[CreationDate] => 2026-03-06T21:52:18.150789+00:00
[Directions] => I-77 N to Exit 17 (Farrow Rd). Left on Farrow Rd, right on Old Winnsboro Rd. Property on Old Winnsboro Rd.
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => realtorbjohnson@gmail.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2026-03-06
[PhotosChangeTimestamp] => 2026-03-06T21:49:39Z
[PhotosCount] => 2
[RoadFrontageType] => State
[RoadSurfaceType] => Paved
[Sewer] => None
[StateOrProvince] => SC
[StreetName] => Old Winnsboro Rd
[StreetNumber] => 6905
[SubdivisionName] => NONE
[WaterSource] => None
[TMS] => 11808-01-15
[Address] => 6905 Old Winnsboro Rd
[LVTDate] => 2026-03-06
[HighSchool] => Eau Claire
[class_name] => LD_2
[LA1UserCode] => JOHNSBRI
[MiddleSchool] => Alcorn
[LO1MainOfficeID] => 1744
[ElementarySchool] => Hyatt Park
[LA1AgentLastName] => Johnson
[RollbackTax(Y/N)] => No
[LA1AgentFirstName] => Brian
[GeoUpdateTimestamp] => 2026-03-06T21:49:39.4
[AddressSearchNumber] => 6905
[LO1OfficeIdentifier] => 1744
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[LA1AgentMiddleInitial] => W
[LO1OfficeAbbreviation] => LPTR01
[FirstPhotoAddTimestamp] => 2026-03-06T21:49:39.6
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6284990
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/628499/29e0124ce9132a20b6ae90f01c36fac9.webp
[ClassName] =>
[MediaSize] => 976739
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/628499/thumbnail-29e0124ce9132a20b6ae90f01c36fac9.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 628499
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6284991
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/628499/7ca43c0d4d55bf79f863ce28c0b7ff7e.webp
[ClassName] =>
[MediaSize] => 376549
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/628499/thumbnail-7ca43c0d4d55bf79f863ce28c0b7ff7e.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 628499
)
)
[DaysOnMarket] => 173
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('628499')
[ID] => 123817
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.13 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