Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 140503
[post_author] => 1
[ListingKey] => 646511
[ListingId] => 646511
[PropertyType] => Residential
[PropertySubType] => Single Family
[StandardStatus] => Active
[ModificationTimestamp] => 2026-11-07T19:08:53Z
[RFModificationTimestamp] => 2026-11-07T19:12:08Z
[ListPrice] => 248000
[BathroomsTotalInteger] => 3
[BathroomsHalf] => 1
[BedroomsTotal] => 3
[LotSizeArea] => 0.612
[LivingArea] => 1762
[BuildingAreaTotal] => 1762
[City] => West Columbia
[PostalCode] => 29169
[UnparsedAddress] => 1037 Natchez Trail, West Columbia, SC 29169
[Coordinates] => Array
(
[0] => -81.076146
[1] => 34.006066
)
[Latitude] => 34.006066
[Longitude] => -81.076146
[YearBuilt] => 1982
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => United Real Estate SC
[ListAgentMlsId] => 18121
[ListOfficeMlsId] => 1822
[OriginatingSystemName] => columbiamls
[PublicRemarks] => RUSTIC RETREAT WITH ENDLESS POTENTIAL – HIDDEN GEM!Calling all investors, renovators, and buyers with a vision! Discover a rare opportunity to transform this charming, cabin-inspired retreat into something truly special! Nestled among beautiful, mature trees, this property offers exceptional privacy, natural beauty, and a peaceful mountain-like atmosphere right here in the Midlands. It's the mountain retreat without the mountain drive. This home is right near the Congaree River, Riverbank Zoo, and just minutes from Downtown Columbia. Imagine sipping your morning coffee on the expansive front porch while enjoying picturesque views of the tree-lined front yard and the breathtaking colors of fall. The secluded backyard, surrounded by lush greenery and mature trees, provides the perfect setting for your very own private outdoor oasis.Inside, this 3-bedroom, 2.5-bath home offers a spacious and functional layout with plenty of storage. Upstairs, you’ll find the primary bedroom, two additional bedrooms, and two full bathrooms. The main level features a generous living area, formal dining room, kitchen with beautiful bay windows, convenient half bath, and laundry area.This diamond in the rough is bursting with potential! Whether you’re an investor looking for your next renovation project or a homeowner with a creative eye dreaming of a one-of-a-kind retreat, this property offers a wonderful canvas to bring your vision to life.Property is being sold strictly AS-IS, with the seller making no repairs. Price reflects the home’s current condition and needed renovations. Bring your contractor, your imagination, and your vision to unlock the possibilities!Opportunities like this don’t come along every day. Schedule your showing and discover the hidden potential waiting to be revealed! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[ArchitecturalStyle] => Contemporary
[AssociationYN] =>
[Basement] => No Basement
[BuildingAreaUnits] => Sqft
[ConstructionMaterials] => Wood
[Cooling] => Central
[CountyOrParish] => Lexington
[CreationDate] => 2026-11-07T19:11:59.229673+00:00
[Directions] => From Sunset Blvd take right on Craft St. Stay to the left on Park Place Ln. Left on Comanchee Trail, right on Fontanna Ave. Take Fontanna down to 1104 where you will find the driveway to the property against the fence on the right (property is not accessible from Natchez Trail).
[ExteriorFeatures] => Deck,Front Porch - Covered,Front Porch - Uncovered,Back Porch - Uncovered
[FireplaceFeatures] => Wood Burning
[Heating] => Central
[InternetEntireListingDisplayYN] => 1
[LaundryFeatures] => Closet
[ListAgentEmail] => mr.realestatenate@yahoo.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OpenParkingSpaces] => 8
[OriginalEntryTimestamp] => 2026-11-07
[PhotosChangeTimestamp] => 2026-11-07T19:08:53Z
[PhotosCount] => 19
[RoadFrontageType] => Gravel,Paved
[RoomKitchenFeatures] => Bay Window,Eat In,Floors-Tile,Ceiling Fan
[Sewer] => Public
[StateOrProvince] => SC
[StreetName] => Natchez
[StreetNumber] => 1037
[StreetSuffix] => Trail
[SubdivisionName] => RIVERVIEW
[WaterSource] => Public
[TMS] => 004618-02-010
[Baths] => 3
[Garage] => None
[Address] => 1037 Natchez Trail
[LVTDate] => 2026-11-07
[LotSize] => 26,666 sq. ft
[PowerOn] => Yes
[Location] => Corner
[BathsFull] => 2
[#ofStories] => 2
[BathsCombo] => 2 / 1
[HighSchool] => Brookland-Cayce
[IDXInclude] => Yes
[New/Resale] => Resale
[class_name] => RE_1
[LA1UserCode] => MILSAPN
[GarageSpaces] => 0
[MiddleSchool] => Northside
[PricePerSQFT] => 140.75
[ShortSaleY/N] => No
[StatusDetail] => 0
[FullBaths-2nd] => 2
[Level-Kitchen] => Main
[LockboxNumber] => 0
[AvailFinancing] => Cash,Conventional,FHA,VA
[FullBaths-Main] => 0
[GeoSubdivision] => SC
[HalfBaths-Main] => 1
[Level-Bedroom2] => Second
[Level-Bedroom3] => Second
[SchoolDistrict] => Lexington Two
[LO1MainOfficeID] => 946
[OtherHeatedSqFt] => 0
[ElementarySchool] => Saluda River
[LA1AgentLastName] => Milsap
[Level-LivingRoom] => Main
[ListPriceTotSqFt] => 140.75
[RollbackTax(Y/N)] => No
[LA1AgentFirstName] => Nathaniel
[Level-WasherDryer] => Main
[ForeclosedProperty] => No
[GeoUpdateTimestamp] => 2026-11-07T19:08:53
[AddressSearchNumber] => 1037
[LO1OfficeIdentifier] => 1822
[Level-MasterBedroom] => Second
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[Interior#ofFireplaces] => 1
[LO1OfficeAbbreviation] => REGA03
[FirstPhotoAddTimestamp] => 2026-11-07T19:08:53.9
[Level-FormalDiningRoom] => Main
[Level-FormalLivingRoom] => Main
[MlsAreaMajor] => Cayce/West Cola/Airport/S. Congaree
[PrivatePoolYN] => No
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6465110
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/f1a26ba149f85d573fbe9ccd96c7f0d3.webp
[ClassName] => Single Family
[MediaSize] => 1311154
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-f1a26ba149f85d573fbe9ccd96c7f0d3.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6465111
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/80e3f521e24733c1bae76c5df1154bb8.webp
[ClassName] => Single Family
[MediaSize] => 1333719
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-80e3f521e24733c1bae76c5df1154bb8.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6465112
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/1b9b8ca2bfbf16e0c78cdfc1407d85e1.webp
[ClassName] => Single Family
[MediaSize] => 1424325
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-1b9b8ca2bfbf16e0c78cdfc1407d85e1.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6465113
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/82c842260431cdb304dadf28bcfc5eae.webp
[ClassName] => Single Family
[MediaSize] => 748705
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-82c842260431cdb304dadf28bcfc5eae.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[4] => Array
(
[Order] => 4
[MediaKey] => 6465114
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/8f2a3f1a109e70d9e860891eb0d9c1a7.webp
[ClassName] => Single Family
[MediaSize] => 821883
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-8f2a3f1a109e70d9e860891eb0d9c1a7.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[5] => Array
(
[Order] => 5
[MediaKey] => 6465115
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/4ee850573d4340cd3978a235b1c9c295.webp
[ClassName] => Single Family
[MediaSize] => 681952
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-4ee850573d4340cd3978a235b1c9c295.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[6] => Array
(
[Order] => 6
[MediaKey] => 6465116
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/40a0faec2c17100723de4e289378a443.webp
[ClassName] => Single Family
[MediaSize] => 649193
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-40a0faec2c17100723de4e289378a443.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[7] => Array
(
[Order] => 7
[MediaKey] => 6465117
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/73c9a0da917c9c2d47d5c9dd8a7efa79.webp
[ClassName] => Single Family
[MediaSize] => 703585
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-73c9a0da917c9c2d47d5c9dd8a7efa79.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[8] => Array
(
[Order] => 8
[MediaKey] => 6465118
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/2f50dfc170c9d56ba57f678a56577985.webp
[ClassName] => Single Family
[MediaSize] => 299546
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-2f50dfc170c9d56ba57f678a56577985.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[9] => Array
(
[Order] => 9
[MediaKey] => 6465119
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/aef18253d3fd3007bc313492af8f1131.webp
[ClassName] => Single Family
[MediaSize] => 423275
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-aef18253d3fd3007bc313492af8f1131.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[10] => Array
(
[Order] => 10
[MediaKey] => 64651110
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/9a388a5b2b294fe0bc902231ce57a1d2.webp
[ClassName] => Single Family
[MediaSize] => 849906
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-9a388a5b2b294fe0bc902231ce57a1d2.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[11] => Array
(
[Order] => 11
[MediaKey] => 64651111
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/8c227d5b4df7d92e75cbc7200d8b427e.webp
[ClassName] => Single Family
[MediaSize] => 772099
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-8c227d5b4df7d92e75cbc7200d8b427e.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[12] => Array
(
[Order] => 12
[MediaKey] => 64651112
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/fc4ba25a92d05ca0fa6e8a3c97385e64.webp
[ClassName] => Single Family
[MediaSize] => 724041
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-fc4ba25a92d05ca0fa6e8a3c97385e64.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[13] => Array
(
[Order] => 13
[MediaKey] => 64651113
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/74aa7fadab3ad117172f5fc7295deff3.webp
[ClassName] => Single Family
[MediaSize] => 794846
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-74aa7fadab3ad117172f5fc7295deff3.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[14] => Array
(
[Order] => 14
[MediaKey] => 64651114
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/7ff203b2c801108ab73098c5565c6a94.webp
[ClassName] => Single Family
[MediaSize] => 761716
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-7ff203b2c801108ab73098c5565c6a94.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[15] => Array
(
[Order] => 15
[MediaKey] => 64651115
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/2410637ea2f8f7acd1f140fc62a3eb17.webp
[ClassName] => Single Family
[MediaSize] => 1610310
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-2410637ea2f8f7acd1f140fc62a3eb17.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[16] => Array
(
[Order] => 16
[MediaKey] => 64651116
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/a5d3529d2902b72a48b1c8a65b2e6ef7.webp
[ClassName] => Single Family
[MediaSize] => 1469885
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-a5d3529d2902b72a48b1c8a65b2e6ef7.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[17] => Array
(
[Order] => 17
[MediaKey] => 64651117
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/ca011200b07a0be1e269d39cd7e2a5a1.webp
[ClassName] => Single Family
[MediaSize] => 1380268
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-ca011200b07a0be1e269d39cd7e2a5a1.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
[18] => Array
(
[Order] => 18
[MediaKey] => 64651118
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/646511/4ec1252ac8ada1134b1ae08e16976762.webp
[ClassName] => Single Family
[MediaSize] => 1409911
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/646511/thumbnail-4ec1252ac8ada1134b1ae08e16976762.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 646511
)
)
[DaysOnMarket] => 0
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('646511')
[ID] => 140503
)