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 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR ArchitecturalStyle eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR CommunityFeatures eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR Cooling eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR CountyOrParish eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR ElementarySchool eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR ExteriorFeatures eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR Flooring eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR Heating eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR HighSchool eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR InteriorFeatures eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR ListingTerms eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR MiddleOrJuniorSchool eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR ParkingFeatures eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR PoolFeatures eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR PropertyType eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR Roof eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR SchoolDistrict eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR Sewer eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR Utilities eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer' OR WaterfrontFeatures eq 'Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer') 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] => 137041
[post_author] => 1
[ListingKey] => 642564
[ListingId] => 642564
[PropertyType] => Residential
[PropertySubType] => Condo
[StandardStatus] => Active
[ModificationTimestamp] => 2026-09-08T16:42:19Z
[RFModificationTimestamp] => 2026-09-08T16:50:16Z
[ListPrice] => 248900
[BathroomsTotalInteger] => 1
[BathroomsHalf] => 0
[BedroomsTotal] => 1
[LotSizeArea] => 0
[LivingArea] => 800
[BuildingAreaTotal] => 800
[City] => Columbia
[PostalCode] => 29201
[UnparsedAddress] => 601 Main Street Unit 504, Columbia, SC 29201
[Coordinates] => Array
(
[0] => -81.030686
[1] => 33.993137
)
[Latitude] => 33.993137
[Longitude] => -81.030686
[YearBuilt] => 2008
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => EXIT Real Est Consultants
[ListAgentMlsId] => 9503
[ListOfficeMlsId] => 731
[OriginatingSystemName] => columbiamls
[PublicRemarks] => ONE OF THE BEST VIEWS IN ADESSO! The sunsets you see from your balcony are stunning! This beautifully updated 5th-floor, 1BR condo offers an incredible view overlooking the pool and Strom Thurmond Wellness & Fitness Center. Located in the heart of downtown Columbia and USC, this move-in-ready condo combines an unbeatable location with upscale, low-maintenance living.Step off the elevator into an impressive sitting area with sweeping views of downtown Columbia, then enter a natural light-filled condo featuring high ceilings, hardwood flooring throughout, recessed lighting, fresh interior paint and a newer HVAC system.The kitchen features granite countertops, stainless steel appliances, and a KitchenAid refrigerator. You will enjoy having an almost new stackable washer and dryer for convenience. The spacious bedroom offers abundant natural light and a large walk-in closet with built-in storage. This unit has an abundance of storage.Adesso is one of downtown Columbia's most sought-after condominium communities, offering exceptional amenities including a swimming pool and pool deck, grilling station, 24-hour fitness room, covered parking and front desk services. The HOA also includes most utilities, adding to the convenience of an easy, lock-and-leave lifestyle. You will love the convenience and safety of the gated parking garage. This units parking spot is a flat , level spot located right near the entry door of the building.LOCATION, LOCATION, LOCATION! Enjoy being just a short walk from USC's campus, the State House, the Vista, Main Street and Five Points, with dining, shopping, entertainment and downtown attractions right at your fingertips.Fresh, updated and truly move-in ready, this 5th-floor condo delivers the combination buyers are looking for—GREAT VIEWS, GREAT AMENITIES and an EXCEPTIONAL DOWNTOWN LOCATION. Just bring your furnishings and start enjoying downtown Columbia living! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[Appliances] => Dishwasher,Disposal,Dryer,Electric Water Heater,Icemaker,Microwave Above Stove,Refrigerator,Washer
[ArchitecturalStyle] => Contemporary
[AssociationYN] =>
[Basement] => No Basement
[BuildingAreaUnits] => Sqft
[ConstructionMaterials] => Stucco - Hard Coat
[Cooling] => Central
[CountyOrParish] => Richland
[CreationDate] => 2026-09-08T16:18:50.054917+00:00
[Directions] => Blossom Street to Main Street, Adesso Condos
[ExteriorFeatures] => Back Porch - Covered
[Heating] => Central,Electric
[InternetEntireListingDisplayYN] => 1
[LaundryFeatures] => Closet
[ListAgentEmail] => jeanniemichaels@msn.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OpenParkingSpaces] => 1
[OriginalEntryTimestamp] => 2026-09-08
[PhotosChangeTimestamp] => 2026-09-08T16:42:19Z
[PhotosCount] => 18
[RoadFrontageType] => Paved
[RoomKitchenFeatures] => Cabinets-Natural,Backsplash-Tiled
[Sewer] => Public
[StateOrProvince] => SC
[StreetName] => Main
[StreetNumber] => 601
[StreetSuffix] => Street
[SubdivisionName] => ADESSO
[UnitNumber] => 504
[WaterSource] => Public
[TMS] => 11395-07-04
[Baths] => 1
[Range] => Convection
[Garage] => Parking Garage
[Address] => 601 Main Street 504
[LVTDate] => 2026-09-08
[PowerOn] => Yes
[Location] => Corner
[PoolType] => Inground-Gunite
[BathsFull] => 1
[#ofStories] => 1
[BathsCombo] => 1 / 0
[HighSchool] => Dreher
[IDXInclude] => Yes
[New/Resale] => Resale
[class_name] => RE_1
[GarageLevel] => Main
[LA1UserCode] => MICHAELSJ
[GarageSpaces] => 0
[MiddleSchool] => Hand
[PricePerSQFT] => 311.13
[ShortSaleY/N] => No
[StatusDetail] => 0
[AgentHitCount] => 6
[Level-Kitchen] => Main
[MasterBedroom] => Bath-Private,Floors-EngineeredHardwood
[Miscellaneous] => Cable,Community Pool,Gated Community,Recreation Facility,Security Cameras
[FullBaths-Main] => 1
[GeoSubdivision] => SC
[HalfBaths-Main] => 0
[SchoolDistrict] => Richland One
[LO1MainOfficeID] => 731
[OtherHeatedSqFt] => 0
[SeniorLivingY/N] => N
[AssocFeeIncludes] => Cable TV,Common Area Maintenance,Exterior Maintenance,Landscaping,Pool,Security,Sewer,Sprinkler,Trash,Water
[ElementarySchool] => A.C. Moore
[FormalDiningRoom] => Area
[FormalLivingRoom] => Floors-Laminate
[LA1AgentLastName] => Michaels
[Level-LivingRoom] => Main
[ListPriceTotSqFt] => 311.13
[RollbackTax(Y/N)] => No
[AddressSearchUnit] => 504
[DetitledMobileY/N] => N
[LA1AgentFirstName] => Jeannie
[Level-WasherDryer] => Main
[ForeclosedProperty] => No
[GeoUpdateTimestamp] => 2026-09-08T16:13:35
[AddressSearchNumber] => 601
[BrokerAttribContact] => Phone: 803-206-8570
[LO1OfficeIdentifier] => 731
[Level-MasterBedroom] => Main
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[Interior#ofFireplaces] => 0
[LO1OfficeAbbreviation] => RECO01
[FirstPhotoAddTimestamp] => 2026-09-08T16:24:28
[MlsAreaMajor] => Columbia - South
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6425640
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/b6f82e212bd75f3099733993e85e1f7d.webp
[ClassName] => Condo
[MediaSize] => 94601
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-b6f82e212bd75f3099733993e85e1f7d.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6425641
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/15fe919118d93742851d3e89d9c9ad73.webp
[ClassName] => Condo
[MediaSize] => 449573
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-15fe919118d93742851d3e89d9c9ad73.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6425642
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/fb413afe0b9237ecf037f644d8806c46.webp
[ClassName] => Condo
[MediaSize] => 445859
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-fb413afe0b9237ecf037f644d8806c46.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6425643
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/0fcb24a584391effe1f344e7810c41af.webp
[ClassName] => Condo
[MediaSize] => 364715
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-0fcb24a584391effe1f344e7810c41af.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[4] => Array
(
[Order] => 4
[MediaKey] => 6425644
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/26e9f16ebf003d2b264ade478e9cf87e.webp
[ClassName] => Condo
[MediaSize] => 339030
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-26e9f16ebf003d2b264ade478e9cf87e.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[5] => Array
(
[Order] => 5
[MediaKey] => 6425645
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/11b24f0102f766f36612b8ab0675a195.webp
[ClassName] => Condo
[MediaSize] => 360582
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-11b24f0102f766f36612b8ab0675a195.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[6] => Array
(
[Order] => 6
[MediaKey] => 6425646
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/466d13603fa37330d328ed4c5b913613.webp
[ClassName] => Condo
[MediaSize] => 328998
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-466d13603fa37330d328ed4c5b913613.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[7] => Array
(
[Order] => 7
[MediaKey] => 6425647
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/65b7f04169ac9bd63d5e193e5494d113.webp
[ClassName] => Condo
[MediaSize] => 323792
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-65b7f04169ac9bd63d5e193e5494d113.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[8] => Array
(
[Order] => 8
[MediaKey] => 6425648
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/445e0af9f731c766f3ef6baf5cb34afe.webp
[ClassName] => Condo
[MediaSize] => 367012
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-445e0af9f731c766f3ef6baf5cb34afe.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[9] => Array
(
[Order] => 9
[MediaKey] => 6425649
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/9ff1041998edceb66fab663a1990b850.webp
[ClassName] => Condo
[MediaSize] => 368041
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-9ff1041998edceb66fab663a1990b850.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[10] => Array
(
[Order] => 10
[MediaKey] => 64256410
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/d02452cf907264d9d10f4e648eb34155.webp
[ClassName] => Condo
[MediaSize] => 340211
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-d02452cf907264d9d10f4e648eb34155.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[11] => Array
(
[Order] => 11
[MediaKey] => 64256411
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/4cebf1300a8cbba4c5984046d19fe379.webp
[ClassName] => Condo
[MediaSize] => 265220
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-4cebf1300a8cbba4c5984046d19fe379.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[12] => Array
(
[Order] => 12
[MediaKey] => 64256412
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/75dc3d9386f4d7b86e083664a936d72c.webp
[ClassName] => Condo
[MediaSize] => 414564
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-75dc3d9386f4d7b86e083664a936d72c.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[13] => Array
(
[Order] => 13
[MediaKey] => 64256413
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/e7ed0c6ab71efcd8d63a99e85499d6f1.webp
[ClassName] => Condo
[MediaSize] => 424862
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-e7ed0c6ab71efcd8d63a99e85499d6f1.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[14] => Array
(
[Order] => 14
[MediaKey] => 64256414
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/722a18d2ac35c237b11dd9d642232d62.webp
[ClassName] => Condo
[MediaSize] => 378564
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-722a18d2ac35c237b11dd9d642232d62.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[15] => Array
(
[Order] => 15
[MediaKey] => 64256415
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/627623bfdc11c55b41b9089a4ca2c69b.webp
[ClassName] => Condo
[MediaSize] => 444296
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-627623bfdc11c55b41b9089a4ca2c69b.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[16] => Array
(
[Order] => 16
[MediaKey] => 64256416
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/a75b813fc54d4f9d89ec53b8c5cb8687.webp
[ClassName] => Condo
[MediaSize] => 345204
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-a75b813fc54d4f9d89ec53b8c5cb8687.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
[17] => Array
(
[Order] => 17
[MediaKey] => 64256417
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/642564/dc5bdc43fc79da9bbeed5d3bb52334f4.webp
[ClassName] => Condo
[MediaSize] => 416680
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/642564/thumbnail-dc5bdc43fc79da9bbeed5d3bb52334f4.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 642564
)
)
[DaysOnMarket] => 0
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('642564')
[ID] => 137041
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.14 seconds
)
)