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.
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-27T04:52:51Z
[RFModificationTimestamp] => 2026-08-27T04:55:46Z
[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 641687 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] => 136277
[post_author] => 1
[ListingKey] => 641687
[ListingId] => 641687
[PropertyType] => Land
[StandardStatus] => Active
[ModificationTimestamp] => 2026-08-27T04:52:51Z
[RFModificationTimestamp] => 2026-08-27T04:55:46Z
[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
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.14 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
[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