Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
Array
(
[RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(PropertyType eq 'Land' or PropertyType eq 'Residential' or PropertyType eq 'Residential Income') and (Appliances eq 'Workshop,Back Porch - Uncovered' OR ArchitecturalStyle eq 'Workshop,Back Porch - Uncovered' OR CommunityFeatures eq 'Workshop,Back Porch - Uncovered' OR Cooling eq 'Workshop,Back Porch - Uncovered' OR CountyOrParish eq 'Workshop,Back Porch - Uncovered' OR ElementarySchool eq 'Workshop,Back Porch - Uncovered' OR ExteriorFeatures eq 'Workshop,Back Porch - Uncovered' OR Flooring eq 'Workshop,Back Porch - Uncovered' OR Heating eq 'Workshop,Back Porch - Uncovered' OR HighSchool eq 'Workshop,Back Porch - Uncovered' OR InteriorFeatures eq 'Workshop,Back Porch - Uncovered' OR ListingTerms eq 'Workshop,Back Porch - Uncovered' OR MiddleOrJuniorSchool eq 'Workshop,Back Porch - Uncovered' OR ParkingFeatures eq 'Workshop,Back Porch - Uncovered' OR PoolFeatures eq 'Workshop,Back Porch - Uncovered' OR PropertyType eq 'Workshop,Back Porch - Uncovered' OR Roof eq 'Workshop,Back Porch - Uncovered' OR SchoolDistrict eq 'Workshop,Back Porch - Uncovered' OR Sewer eq 'Workshop,Back Porch - Uncovered' OR Utilities eq 'Workshop,Back Porch - Uncovered' OR WaterfrontFeatures eq 'Workshop,Back Porch - Uncovered') 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] => 108820
[post_author] => 1
[ListingKey] => 612570
[ListingId] => 612570
[PropertyType] => Residential
[PropertySubType] => Single Family
[StandardStatus] => Active
[ModificationTimestamp] => 2026-09-15T18:23:22Z
[RFModificationTimestamp] => 2026-09-15T18:27:19Z
[ListPrice] => 575000
[BathroomsTotalInteger] => 2
[BathroomsHalf] => 0
[BedroomsTotal] => 3
[LotSizeArea] => 0.07
[LivingArea] => 2402
[BuildingAreaTotal] => 2402
[City] => West Columbia
[PostalCode] => 29169-7537
[UnparsedAddress] => 101 Shuler Street, West Columbia, SC 29169-7537
[Coordinates] => Array
(
[0] => -81.057891
[1] => 33.993809
)
[Latitude] => 33.993809
[Longitude] => -81.057891
[YearBuilt] => 1901
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => M & R Realty & Construction
[ListAgentMlsId] => 690
[ListOfficeMlsId] => 263
[OriginatingSystemName] => columbiamls
[PublicRemarks] => Zoned C2 commercial, the historic Hall House built in 1901 was the home to prominent members of West Columbia. The home is located in the River District and has access to all the new shops and businesses. The home features three bedrooms, two bathrooms, living room, dining room, den and a spacious kitchen with lots of cabinet space, range, dishwasher, refrigerator and washer/dryer. There are features such as high ceilings and hardwood flooring. The basement has a workshop area as well. This well cared for historical home is convenient to USC and you can walk to restaurants on State Street and Knox Abbott Drive. There is a view of the Columbia skyline and the Congaree River. When you live here you get to enjoy the lifestyle of being near the River Walk or have neighbors in communities like The Avenues. You are minutes from great restaurants that include Savage Craft Ale Works, Cafe Strudel, Terra Restaurant and D's Wings. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[Appliances] => Dishwasher,Dryer,Refrigerator,Washer
[ArchitecturalStyle] => Colonial
[AssociationYN] =>
[Basement] => Yes Basement
[BuildingAreaUnits] => Sqft
[ConstructionMaterials] => Wood
[Cooling] => Central
[CountyOrParish] => Lexington
[CreationDate] => 2025-07-08T13:41:31.763254+00:00
[Directions] => State Street to Meeting Street and go one block and the home is on the left on the corner of Meeting Street and Shuler Street.
[ExteriorFeatures] => Workshop,Back Porch - Uncovered
[Fencing] => NONE
[Heating] => Central
[InteriorFeatures] => Ceiling Fan,Smoke Detector
[InternetEntireListingDisplayYN] => 1
[LaundryFeatures] => Kitchen
[ListAgentEmail] => hebrazzell@aol.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OpenParkingSpaces] => 2
[OriginalEntryTimestamp] => 2025-07-08
[PhotosChangeTimestamp] => 2025-07-08T13:34:34Z
[PhotosCount] => 15
[RoadFrontageType] => Paved
[RoomKitchenFeatures] => Eat In,Counter Tops-Formica,Floors-Vinyl,Cabinets-Painted
[Sewer] => Community
[StateOrProvince] => SC
[StreetName] => Shuler
[StreetNumber] => 101
[StreetSuffix] => Street
[SubdivisionName] => THE AVENUES
[WaterSource] => Community
[TMS] => 004639-04-001
[Baths] => 2
[Range] => Free-standing
[Garage] => None
[Address] => 101 Shuler Street
[LVTDate] => 2025-07-08
[PowerOn] => Yes
[Location] => Corner
[BathsFull] => 2
[#ofStories] => 2
[2ndBedroom] => Bath-Shared,Floors-Hardwood
[3rdBedroom] => Bath-Shared,Floors-Hardwood
[BathsCombo] => 2 / 0
[HighSchool] => Brookland-Cayce
[IDXInclude] => Yes
[LivingRoom] => Floors-Hardwood,Molding
[New/Resale] => Resale
[class_name] => RE_1
[LA1UserCode] => BRAZZELH
[GarageSpaces] => 0
[MiddleSchool] => Busbee
[PricePerSQFT] => 239.38
[ShortSaleY/N] => No
[StatusDetail] => 0
[AgentHitCount] => 322
[FullBaths-2nd] => 1
[Level-Kitchen] => Main
[MasterBedroom] => Ceiling Fan,Floors-Hardwood
[Miscellaneous] => Cable TV Available
[FullBaths-Main] => 1
[GeoSubdivision] => SC
[HalfBaths-Main] => 0
[Level-Bedroom2] => Second
[SchoolDistrict] => Lexington Two
[LO1MainOfficeID] => 263
[OtherHeatedSqFt] => 0
[SeniorLivingY/N] => N
[ElementarySchool] => Cayce Elementary
[FormalDiningRoom] => Floors-Hardwood,Molding
[FormalLivingRoom] => Floors-Hardwood,Molding
[LA1AgentLastName] => Brazzell
[Level-LivingRoom] => Main
[ListPriceTotSqFt] => 239.38
[RollbackTax(Y/N)] => No
[DetitledMobileY/N] => N
[LA1AgentFirstName] => Gene
[Level-WasherDryer] => Main
[ForeclosedProperty] => No
[GeoUpdateTimestamp] => 2025-07-08T13:34:20.5
[AddressSearchNumber] => 101
[LO1OfficeIdentifier] => 263
[Level-MasterBedroom] => Main
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[Interior#ofFireplaces] => 0
[LO1OfficeAbbreviation] => MRRC01
[FirstPhotoAddTimestamp] => 2025-07-08T13:34:34.9
[Level-FormalDiningRoom] => Main
[Level-FormalLivingRoom] => Main
[MlsAreaMajor] => Cayce/West Cola/Airport/S. Congaree
[PrivatePoolYN] => No
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6125700
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/612570/c029e62ce4c4f4e3ca01bc1d666eef1f.webp
[ClassName] => Single Family
[MediaSize] => 133785
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/612570/thumbnail-c029e62ce4c4f4e3ca01bc1d666eef1f.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 612570
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6125701
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/612570/71c92e08a4b27a9a481cc59a0701431e.webp
[ClassName] => Single Family
[MediaSize] => 860183
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/612570/thumbnail-71c92e08a4b27a9a481cc59a0701431e.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 612570
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6125702
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/612570/aadbd4ddcbba0ef13a3bdb851795c691.webp
[ClassName] => Single Family
[MediaSize] => 669921
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/612570/thumbnail-aadbd4ddcbba0ef13a3bdb851795c691.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 612570
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6125703
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/612570/8fb923e2bf4067eac37af668ff4d9159.webp
[ClassName] => Single Family
[MediaSize] => 631963
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/612570/thumbnail-8fb923e2bf4067eac37af668ff4d9159.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 612570
)
[4] => Array
(
[Order] => 4
[MediaKey] => 6125704
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/612570/56e36856862cc6b922e7445d39d300ef.webp
[ClassName] => Single Family
[MediaSize] => 441828
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/612570/thumbnail-56e36856862cc6b922e7445d39d300ef.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 612570
)
[5] => Array
(
[Order] => 5
[MediaKey] => 6125705
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/612570/95bbde70fc746bd2a0f23b62905a5a5d.webp
[ClassName] => Single Family
[MediaSize] => 465767
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/612570/thumbnail-95bbde70fc746bd2a0f23b62905a5a5d.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 612570
)
[6] => Array
(
[Order] => 6
[MediaKey] => 6125706
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/612570/abe82d2ce8d6941e119f4c8772880302.webp
[ClassName] => Single Family
[MediaSize] => 450046
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/612570/thumbnail-abe82d2ce8d6941e119f4c8772880302.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 612570
)
[7] => Array
(
[Order] => 7
[MediaKey] => 6125707
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/612570/f5bfc35b2e06550e7ee10708226619d3.webp
[ClassName] => Single Family
[MediaSize] => 455589
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/612570/thumbnail-f5bfc35b2e06550e7ee10708226619d3.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 612570
)
[8] => Array
(
[Order] => 8
[MediaKey] => 6125708
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/612570/7c4597a80d676d3aad6f00df3e4c2faf.webp
[ClassName] => Single Family
[MediaSize] => 661808
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/612570/thumbnail-7c4597a80d676d3aad6f00df3e4c2faf.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 612570
)
[9] => Array
(
[Order] => 9
[MediaKey] => 6125709
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/612570/09d2e1fc3cdb89dae6ea58614e49a39b.webp
[ClassName] => Single Family
[MediaSize] => 619940
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/612570/thumbnail-09d2e1fc3cdb89dae6ea58614e49a39b.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 612570
)
[10] => Array
(
[Order] => 10
[MediaKey] => 61257010
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/612570/4788f1a06f1055c433e81fac14cfbf50.webp
[ClassName] => Single Family
[MediaSize] => 748678
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/612570/thumbnail-4788f1a06f1055c433e81fac14cfbf50.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 612570
)
[11] => Array
(
[Order] => 11
[MediaKey] => 61257011
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/612570/290216c8d484efc3b3836fa9ae1744f0.webp
[ClassName] => Single Family
[MediaSize] => 470819
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/612570/thumbnail-290216c8d484efc3b3836fa9ae1744f0.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 612570
)
[12] => Array
(
[Order] => 12
[MediaKey] => 61257012
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/612570/bff3a690c62693d0ca9d24292653397f.webp
[ClassName] => Single Family
[MediaSize] => 364027
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/612570/thumbnail-bff3a690c62693d0ca9d24292653397f.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 612570
)
[13] => Array
(
[Order] => 13
[MediaKey] => 61257013
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/612570/c63bf5a398cb506d4ebeb5d0bd0ac9a8.webp
[ClassName] => Single Family
[MediaSize] => 633145
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/612570/thumbnail-c63bf5a398cb506d4ebeb5d0bd0ac9a8.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 612570
)
[14] => Array
(
[Order] => 14
[MediaKey] => 61257014
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/612570/374e1b5ac0b013f1f08f93dc5d355ebe.webp
[ClassName] => Single Family
[MediaSize] => 329352
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/612570/thumbnail-374e1b5ac0b013f1f08f93dc5d355ebe.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 612570
)
)
[DaysOnMarket] => 7
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('612570')
[ID] => 108820
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.18 seconds
)
)