MELROSE HEIGHTS
12 Properties
Sort by:
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=SubdivisionName eq 'MELROSE HEIGHTS' AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3426 +items: array:2 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3427 +post_id: "125257" +post_author: 1 +"ListingKey": "630032" +"ListingId": "630032" +"PropertyType": "Residential Lease" +"PropertySubType": "Duplex" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-26T22:54:11Z" +"RFModificationTimestamp": "2026-06-09T06:01:03Z" +"ListPrice": 2250.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.22 +"LivingArea": 1500.0 +"BuildingAreaTotal": 1500.0 +"City": "Columbia" +"PostalCode": "29205" +"UnparsedAddress": "1205 Maple Street, Columbia, SC 29205" +"Coordinates": array:2 [ 0 => -81.002941 1 => 34.004957 ] +"Latitude": 34.004957 +"Longitude": -81.002941 +"YearBuilt": "1930" +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Brand Name Real Estate" +"ListAgentMlsId": "11434" +"ListOfficeMlsId": "879" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "***Available 7/13/2026*** Charming 3BR/2BA downstairs duplex in desirable Melrose Heights, just minutes from USC, downtown Columbia, Five Points, and area hospitals. Features include high ceilings, heart pine hardwood floors, two spacious living areas with ornamental fireplaces, and a bright enclosed sunroom ideal for a home office or flex space. Private third bedroom with built-ins offers additional versatility. Enjoy a wraparound front porch, in-unit washer/dryer, and two off-street parking spaces. Convenient to Forest Drive and Devine Street shopping, dining, and neighborhood amenities. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Dryer,Icemaker,Microwave-Countertop,Oven,Range,Refrigerator,Stack Washer/Dryer,Washer" +"ArchitecturalStyle": "Traditional" +"BuildingAreaUnits": "Sqft" +"CoListAgentEmail": "stacy@letsmovecolumbia.com" +"ConstructionMaterials": "Vinyl" +"Cooling": "Central" +"CountyOrParish": "Richland" +"CreationDate": "2026-03-26T23:00:25.163002+00:00" +"Directions": "Headed away from downtown on Gervais St., turn right onto Maple St. Home will be on the right." +"ExteriorFeatures": "Front Porch - Covered" +"Fencing": "Partial Fence" +"Heating": "Central" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Mud Room,Utility Room" +"LeaseTerm": "One Year,Two Year" +"ListAgentEmail": "scott@letsmovecolumbia.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OpenParkingSpaces": "2" +"OriginalEntryTimestamp": "2026-03-26" +"PhotosChangeTimestamp": "2026-03-26T22:54:11Z" +"PhotosCount": "22" +"RoadFrontageType": "Paved" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Maple" +"StreetNumber": "1205" +"StreetSuffix": "Street" +"SubdivisionName": "MELROSE HEIGHTS" +"VirtualTourURLUnbranded": "https://bit.ly/1205MapleStreetWalkthrough" +"WaterSource": "Public" +"TMS": "11414-20-06" +"Garage": "None" +"PetFee": "0" +"Address": "1205 Maple Street" +"LVTDate": "2026-03-26" +"Parking": "Assigned,Off Street" +"Security": "Tenant" +"BathsFull": "2" +"GasPaidBy": "Tenant" +"#ofStories": "1" +"BathsCombo": "2 / 0" +"HighSchool": "A. C. Flora" +"LawnPaidBy": "Owner" +"class_name": "RT_5" +"CablePaidBy": "Tenant" +"CreditCheck": "40" +"LA1UserCode": "LINDENBS" +"PestControl": "Owner" +"PetsAllowed": "No" +"SewerPaidBy": "Owner" +"TrashPaidBy": "Owner" +"WaterPaidBy": "Owner" +"Co-ListAgent": "13088" +"GarageSpaces": "0" +"MiddleSchool": "Crayton" +"PricePerSQFT": "1.5" +"StatusDetail": "0" +"AvailableDate": "2026-07-13" +"Co-ListOffice": "879" +"CoolingPaidBy": "Tenant" +"HeatingPaidBy": "Tenant" +"InteriorRooms": "Ceiling Fan,Living Room,Floors Hardwood,Floors - Vinyl,Formal Living Room,Kitchen,Master Bedroom,2nd Bedroom,3rd Bedroom" +"ElectricPaidBy": "Tenant" +"FullBaths-Main": "2" +"GeoSubdivision": "SC" +"HalfBaths-Main": "0" +"Levels-Kitchen": "Main" +"SchoolDistrict": "Richland One" +"LO1MainOfficeID": "879" +"Levels-Bedroom2": "Main" +"Levels-Bedroom3": "Main" +"OtherHeatedSqFt": "0" +"SecurityDeposit": "2250" +"ElementarySchool": "Brennen" +"LA1AgentLastName": "Lindenberg" +"Levels-OtherRoom": "Main" +"ListPriceTotSqFt": "1.5" +"LA1AgentFirstName": "Scott" +"Levels-LivingRoom": "Main" +"GeoUpdateTimestamp": "2026-03-26T22:54:08.8" +"Levels-LivingRoom2": "Main" +"Levels-WasherDryer": "Main" +"AddressSearchNumber": "1205" +"LO1OfficeIdentifier": "879" +"Levels-MasterBedroom": "Main" +"PublishtoInternetY/N": "Yes" +"Interior#ofFireplaces": "2" +"LA1AgentMiddleInitial": "C" +"LO1OfficeAbbreviation": "BRNA01" +"FirstPhotoAddTimestamp": "2026-03-26T22:54:11.7" +"MlsAreaMajor": "East Columbia" +"Media": array:19 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6300320" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/90256e82e91ab2b132a37dab327d7171.webp" "ClassName" => "Duplex" "MediaSize" => 355734 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-90256e82e91ab2b132a37dab327d7171.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6300321" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/8c3bd02c5f75fd7981e0d6fd6c5786e9.webp" "ClassName" => "Duplex" "MediaSize" => 85391 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-8c3bd02c5f75fd7981e0d6fd6c5786e9.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6300322" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/5a9bdf82c173afcc03dda7825125acf4.webp" "ClassName" => "Duplex" "MediaSize" => 107084 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-5a9bdf82c173afcc03dda7825125acf4.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6300323" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/b4b2b7e97de5ad1eba095f0b019864f9.webp" "ClassName" => "Duplex" "MediaSize" => 131030 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-b4b2b7e97de5ad1eba095f0b019864f9.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6300324" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/1c81f723aecb0bcd8a21dc2f16bf26aa.webp" "ClassName" => "Duplex" "MediaSize" => 100827 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-1c81f723aecb0bcd8a21dc2f16bf26aa.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6300325" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/2e0e040d5a3b6f39a4ff88d4f9537a6e.webp" "ClassName" => "Duplex" "MediaSize" => 109847 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-2e0e040d5a3b6f39a4ff88d4f9537a6e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6300326" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/78bd46c66fe26ab9597c654816eee072.webp" "ClassName" => "Duplex" "MediaSize" => 101038 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-78bd46c66fe26ab9597c654816eee072.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6300327" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/34caf6065fe8a7799975ac8c13aea000.webp" "ClassName" => "Duplex" "MediaSize" => 96203 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-34caf6065fe8a7799975ac8c13aea000.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6300328" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/38beb45cad7e477c2748081444d7990f.webp" "ClassName" => "Duplex" "MediaSize" => 77497 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-38beb45cad7e477c2748081444d7990f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6300329" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/cf527c51084b092db74976169a3d59da.webp" "ClassName" => "Duplex" "MediaSize" => 75481 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-cf527c51084b092db74976169a3d59da.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "63003210" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/94086af0baf0ad17047f3ed164150036.webp" "ClassName" => "Duplex" "MediaSize" => 80141 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-94086af0baf0ad17047f3ed164150036.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "63003211" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/4424f79e86b60da860e5b503aef3d92f.webp" "ClassName" => "Duplex" "MediaSize" => 77497 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-4424f79e86b60da860e5b503aef3d92f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "63003212" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/8f55faccb2734b5d6202c1f0f4b35b88.webp" "ClassName" => "Duplex" "MediaSize" => 120261 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-8f55faccb2734b5d6202c1f0f4b35b88.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "63003213" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/91af1dd30d3419bec59bff3cebd644d7.webp" "ClassName" => "Duplex" "MediaSize" => 73948 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-91af1dd30d3419bec59bff3cebd644d7.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "63003214" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/c87ae64d00e16503638aea295134d065.webp" "ClassName" => "Duplex" "MediaSize" => 493826 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-c87ae64d00e16503638aea295134d065.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "63003215" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/dd75fabc0e17e1c0b15df0fb4fd11216.webp" "ClassName" => "Duplex" "MediaSize" => 456061 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-dd75fabc0e17e1c0b15df0fb4fd11216.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "63003216" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/9c031b515a3e5ad9f3920b1fa5fa445e.webp" "ClassName" => "Duplex" "MediaSize" => 246946 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-9c031b515a3e5ad9f3920b1fa5fa445e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "63003217" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/fc641bf2e1639e82de99791b8807ce3d.webp" "ClassName" => "Duplex" "MediaSize" => 409644 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-fc641bf2e1639e82de99791b8807ce3d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "63003218" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/630032/720f0ce159941f1344ca0b832041ebd5.webp" "ClassName" => "Duplex" "MediaSize" => 479262 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/630032/thumbnail-720f0ce159941f1344ca0b832041ebd5.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "630032" ] ] +"DaysOnMarket": 86 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('630032')" +"ID": "125257" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3429 +post_id: "124668" +post_author: 1 +"ListingKey": "629411" +"ListingId": "629411" +"PropertyType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-19T12:40:24Z" +"RFModificationTimestamp": "2026-06-09T06:00:50Z" +"ListPrice": 200000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.138 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Columbia" +"PostalCode": "29205" +"UnparsedAddress": "2539 Cherry Street, Columbia, SC 29205" +"Coordinates": array:2 [ 0 => -81.009272 1 => 34.005119 ] +"Latitude": 34.005119 +"Longitude": -81.009272 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Compass Carolinas LLC" +"ListAgentMlsId": "20205" +"ListOfficeMlsId": "1494" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Vacant lot zoned Multi-family centrally located in Columbia. Great for a home or investment property! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"AssociationYN": false +"BuildingAreaUnits": "Sqft" +"CountyOrParish": "Richland" +"CreationDate": "2026-03-18T23:42:13.432155+00:00" +"Directions": "From Gervais, take a right onto Millwood Ave. Take a right on Short St. Take a left onto Cherry St. Property is vacant lot on the right at the curve." +"InternetEntireListingDisplayYN": true +"ListAgentEmail": "rachelspencerealtor@gmail.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OriginalEntryTimestamp": "2026-03-18" +"PhotosChangeTimestamp": "2026-03-18T23:38:00Z" +"PhotosCount": "1" +"RoadFrontageType": "City" +"RoadSurfaceType": "Paved" +"Sewer": "Available" +"StateOrProvince": "SC" +"StreetName": "Cherry" +"StreetNumber": "2539" +"StreetSuffix": "Street" +"SubdivisionName": "MELROSE HEIGHTS" +"WaterSource": "Public" +"TMS": "11410-14-01" +"Address": "2539 Cherry Street" +"LVTDate": "2026-03-18" +"LotSize": "60.1X134.2X45.4X58.3X99.9" +"class_name": "LD_2" +"LA1UserCode": "SPENCER" +"AgentHitCount": "6" +"GeoSubdivision": "SC" +"LO1MainOfficeID": "1494" +"LA1AgentLastName": "Spence" +"RollbackTax(Y/N)": "No" +"LA1AgentFirstName": "Rachel" +"GeoUpdateTimestamp": "2026-03-18T23:37:20.7" +"AddressSearchNumber": "2539" +"LO1OfficeIdentifier": "1494" +"ListingTypeAgreement": "Exclusive Right to Sell" +"PublishtoInternetY/N": "Yes" +"LO1OfficeAbbreviation": "CMPS01" +"FirstPhotoAddTimestamp": "2026-03-18T23:38:00.4" +"Media": array:1 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6294110" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/629411/23a465e99df5a15ce7d0601ea971f27d.webp" "ClassName" => null "MediaSize" => 398077 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/629411/thumbnail-23a465e99df5a15ce7d0601ea971f27d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "629411" ] ] +"DaysOnMarket": 93 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('629411')" +"ID": "124668" } ] +success: true +page_size: 10 +page_count: 2 +count: 12 +after_key: "" } "RF Response Time" => "0.16 seconds" ] "RF Cache Key: 0d2343a8c9cb3bd831b13c602011104104ea04e2585f7e16aedd27acc43086b0" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3420 +items: array:2 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3427} 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3429} ] +success: true +page_size: 10 +page_count: 2 +count: 12 +after_key: "" } ] ]
