Over 3 acres of gorgeous woods with pond access and road frontage on two roads in the heart of the Lexington/Lake Murray area. Lots of possibilities for future development with this land. Possible options for multiple home sites with pond access/view. Close to everything wonderful in Lexington. On site double wide has tree damage from hurricane, most likely irreparable. 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 616498 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] => 112475
[post_author] => 1
[ListingKey] => 616498
[ListingId] => 616498
[PropertyType] => Land
[StandardStatus] => Active
[ModificationTimestamp] => 2026-03-01T03:57:23Z
[RFModificationTimestamp] => 2026-06-09T06:01:32Z
[ListPrice] => 250000
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 3.1
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => Lexington
[PostalCode] => 29072
[UnparsedAddress] => 306 Andrew Corley Road, Lexington, SC 29072
[Coordinates] => Array
(
[0] => -81.208206
[1] => 34.027302
)
[Latitude] => 34.027302
[Longitude] => -81.208206
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => Home Again Realty
[ListAgentMlsId] => 11284
[ListOfficeMlsId] => 1237
[OriginatingSystemName] => columbiamls
[PublicRemarks] => Over 3 acres of gorgeous woods with pond access and road frontage on two roads in the heart of the Lexington/Lake Murray area. Lots of possibilities for future development with this land. Possible options for multiple home sites with pond access/view. Close to everything wonderful in Lexington. On site double wide has tree damage from hurricane, most likely irreparable. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[AssociationYN] =>
[BuildingAreaUnits] => Sqft
[CountyOrParish] => Lexington
[CreationDate] => 2026-03-01T04:02:05.955775+00:00
[Directions] => From Lexington, Hwy 6 toward lake Murray dam, take Right on Andrew Corley Rd. to 310 Andrew Corley Rd on Right.
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => jared.kyzer@yahoo.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2025-08-31
[PhotosChangeTimestamp] => 2025-08-31T17:55:23Z
[PhotosCount] => 4
[RoadFrontageType] => County
[RoadSurfaceType] => Paved
[Sewer] => Septic-Public Available
[StateOrProvince] => SC
[StreetName] => Andrew Corley
[StreetNumber] => 306
[StreetSuffix] => Road
[SubdivisionName] => NONE
[WaterSource] => Public
[TMS] => 003400-03-003
[Address] => 306 Andrew Corley Road
[LVTDate] => 2025-08-31
[HighSchool] => River Bluff
[class_name] => LD_2
[LA1UserCode] => KYZERJ
[MiddleSchool] => LAKESIDE
[AgentHitCount] => 103
[GeoSubdivision] => SC
[SchoolDistrict] => Lexington One
[LO1MainOfficeID] => 1237
[ElementarySchool] => Midway(Lex1)
[LA1AgentLastName] => Kyzer
[RollbackTax(Y/N)] => No
[LA1AgentFirstName] => Jared
[GeoUpdateTimestamp] => 2025-08-31T17:55:23.4
[AddressSearchNumber] => 306
[LO1OfficeIdentifier] => 1237
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[LO1OfficeAbbreviation] => VENT01
[FirstPhotoAddTimestamp] => 2025-08-31T17:55:23.7
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6164980
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/616498/3a2f8b6a52e82d03e121b567c5662edc.webp
[ClassName] =>
[MediaSize] => 1149797
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/616498/thumbnail-3a2f8b6a52e82d03e121b567c5662edc.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 616498
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6164981
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/616498/be8fc0591c9b669db620b9f084030c9d.webp
[ClassName] =>
[MediaSize] => 1113799
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/616498/thumbnail-be8fc0591c9b669db620b9f084030c9d.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 616498
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6164982
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/616498/1706ffc6431091e7bdcacfcd6d354648.webp
[ClassName] =>
[MediaSize] => 1202585
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/616498/thumbnail-1706ffc6431091e7bdcacfcd6d354648.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 616498
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6164983
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/616498/3b71ddd3c3a4c2aa1813e5fe98baf0ef.webp
[ClassName] =>
[MediaSize] => 1388199
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/616498/thumbnail-3b71ddd3c3a4c2aa1813e5fe98baf0ef.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 616498
)
)
[DaysOnMarket] => 179
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('616498')
[ID] => 112475
)
)
[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
[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