Vacant and ready for your vision. This 3-bedroom, 1-bath masonry bungalow (built 1952) offers 1, 025 square feet with hardwood floors on a deep lot with municipal water and sewer. The home needs renovation to be rent-ready – bring your contractor and unlock an estimated $1, 200/month in market rent. A value-addopportunity in Columbia’s 29203, offered as part of the Easter/Legrand/Tremont portfolio. 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] => 140944
[post_author] => 1
[ListingKey] => 647002
[ListingId] => 647002
[PropertyType] => Residential
[PropertySubType] => Single Family
[StandardStatus] => Active
[ModificationTimestamp] => 2026-11-17T18:37:09Z
[RFModificationTimestamp] => 2026-11-17T18:44:05Z
[ListPrice] => 124000
[BathroomsTotalInteger] => 2
[BathroomsHalf] => 1
[BedroomsTotal] => 3
[LotSizeArea] => 0.25
[LivingArea] => 1188
[BuildingAreaTotal] => 1188
[City] => Columbia
[PostalCode] => 29203
[UnparsedAddress] => 414 Easter Street, Columbia, SC 29203
[Coordinates] => Array
(
[0] => -80.991268
[1] => 34.065462
)
[Latitude] => 34.065462
[Longitude] => -80.991268
[YearBuilt] => 1965
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => Yip Premier Real Estate LLC
[ListAgentMlsId] => 552
[ListOfficeMlsId] => 922
[OriginatingSystemName] => columbiamls
[PublicRemarks] => Solid brick raised ranch offered as part of a three-property investor portfolio. This 3-bedroom, 1-bath home offers 1,188 square feet of living space with original hardwood floors, central air, forced-air heat, and a finished carport plus open porch. The home is tenant-occupied at $800/month on an extended lease, with market rent estimated at $1,200/month - built-in upside for the next owner. Municipal water with private septic. A straightforward, cash-flowing hold in an established Columbia neighborhood, sold as part of the Easter/Legrand/Tremont portfolio. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[ArchitecturalStyle] => Ranch
[AssociationYN] =>
[Basement] => No Basement
[BuildingAreaUnits] => Sqft
[ConstructionMaterials] => Brick-All Sides-AbvFound
[Cooling] => Central
[CountyOrParish] => Richland
[CreationDate] => 2026-11-17T18:44:00.392668+00:00
[Directions] => From SC-277 N, exit onto Fontaine Rd. Right onto Farrow Rd. Left onto Easter St. Home is on the Left.
[Heating] => Central
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => karen@yiprealestate.com
[LivingAreaUnits] => SquareFeet
[LotSizeUnits] => Acres
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2026-11-17
[PhotosChangeTimestamp] => 2026-11-17T18:37:09Z
[PhotosCount] => 1
[RoadFrontageType] => Paved
[Sewer] => Septic
[StateOrProvince] => SC
[StreetName] => Easter
[StreetNumber] => 414
[StreetSuffix] => Street
[SubdivisionName] => GREENVIEW
[WaterSource] => Public
[TMS] => 14208-01-02
[Baths] => 2
[Garage] => Carport Attached
[Address] => 414 Easter Street
[LVTDate] => 2026-11-17
[PowerOn] => Yes
[BathsFull] => 1
[#ofStories] => 1
[BathsCombo] => 1 / 1
[HighSchool] => Keenan High
[IDXInclude] => Yes
[New/Resale] => Resale
[class_name] => RE_1
[LA1UserCode] => YIPK
[GarageSpaces] => 1
[MiddleSchool] => Sanders
[PricePerSQFT] => 104.38
[ShortSaleY/N] => No
[StatusDetail] => 0
[Level-Kitchen] => Main
[FullBaths-Main] => 1
[GeoSubdivision] => SC
[HalfBaths-Main] => 1
[Level-Bedroom2] => Main
[Level-Bedroom3] => Main
[SchoolDistrict] => Richland One
[LO1MainOfficeID] => 922
[OtherHeatedSqFt] => 0
[ElementarySchool] => Greenview
[LA1AgentLastName] => Yip
[Level-LivingRoom] => Main
[ListPriceTotSqFt] => 104.38
[RollbackTax(Y/N)] => Unknown
[LA1AgentFirstName] => Karen
[ForeclosedProperty] => No
[GeoUpdateTimestamp] => 2026-11-17T18:37:09.1
[AddressSearchNumber] => 414
[LO1OfficeIdentifier] => 922
[Level-MasterBedroom] => Main
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[Interior#ofFireplaces] => 0
[LO1OfficeAbbreviation] => YIPP01
[FirstPhotoAddTimestamp] => 2026-11-17T18:37:09.2
[MlsAreaMajor] => City of Columbia, Denny terrace, Lake Elizabeth
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6470020
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/647002/d57fd33df9849bf22586b079ad477ec3.webp
[ClassName] => Single Family
[MediaSize] => 273435
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/647002/thumbnail-d57fd33df9849bf22586b079ad477ec3.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 647002
)
)
[DaysOnMarket] => 0
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('647002')
[ID] => 140944
)
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 647004 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] => 140946
[post_author] => 1
[ListingKey] => 647004
[ListingId] => 647004
[PropertyType] => Residential
[PropertySubType] => Single Family
[StandardStatus] => Active
[ModificationTimestamp] => 2026-11-17T18:38:34Z
[RFModificationTimestamp] => 2026-11-17T18:44:04Z
[ListPrice] => 124000
[BathroomsTotalInteger] => 1
[BathroomsHalf] => 0
[BedroomsTotal] => 3
[LotSizeArea] => 0
[LivingArea] => 1025
[BuildingAreaTotal] => 1025
[City] => Columbia
[PostalCode] => 29203
[UnparsedAddress] => 734 Tremont Avenue, Columbia, SC 29203
[Coordinates] => Array
(
[0] => -81.025599
[1] => 34.055304
)
[Latitude] => 34.055304
[Longitude] => -81.025599
[YearBuilt] => 1952
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => Yip Premier Real Estate LLC
[ListAgentMlsId] => 13705
[ListOfficeMlsId] => 922
[OriginatingSystemName] => columbiamls
[PublicRemarks] => Vacant and ready for your vision. This 3-bedroom, 1-bath masonry bungalow (built 1952) offers 1,025 square feet with hardwood floors on a deep lot with municipal water and sewer. The home needs renovation to be rent-ready - bring your contractor and unlock an estimated $1,200/month in market rent. A value-addopportunity in Columbia's 29203, offered as part of the Easter/Legrand/Tremont portfolio. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[ArchitecturalStyle] => Bungalow
[AssociationYN] =>
[Basement] => No Basement
[BuildingAreaUnits] => Sqft
[ConstructionMaterials] => Brick-All Sides-AbvFound
[Cooling] => Other
[CountyOrParish] => Richland
[CreationDate] => 2026-11-17T18:43:58.581534+00:00
[Directions] => From Main St, Left onto Fairfield Rd. Right onto Rosedale Arch. Right onto Tremont Ave. Home is on the Left.
[Heating] => Other
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => jim@yiprealestate.com
[LivingAreaUnits] => SquareFeet
[LotSizeUnits] => Acres
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2026-11-17
[PhotosChangeTimestamp] => 2026-11-17T18:38:34Z
[PhotosCount] => 1
[RoadFrontageType] => Paved
[Sewer] => Public
[StateOrProvince] => SC
[StreetName] => Tremont
[StreetNumber] => 734
[StreetSuffix] => Avenue
[SubdivisionName] => BELMONT
[WaterSource] => Public
[TMS] => 11702-06-12
[Baths] => 1
[Garage] => None
[Address] => 734 Tremont Avenue
[LVTDate] => 2026-11-17
[BathsFull] => 1
[#ofStories] => 1
[BathsCombo] => 1 / 0
[HighSchool] => Johnson
[IDXInclude] => Yes
[New/Resale] => Resale
[class_name] => RE_1
[LA1UserCode] => HERNDOJI
[GarageSpaces] => 0
[MiddleSchool] => Alcorn
[PricePerSQFT] => 120.98
[StatusDetail] => 0
[Level-Kitchen] => Main
[FullBaths-Main] => 1
[GeoSubdivision] => SC
[HalfBaths-Main] => 0
[Level-Bedroom2] => Main
[Level-Bedroom3] => Main
[SchoolDistrict] => Richland One
[LO1MainOfficeID] => 922
[OtherHeatedSqFt] => 0
[ElementarySchool] => Arden
[LA1AgentLastName] => Herndon
[Level-LivingRoom] => Main
[ListPriceTotSqFt] => 120.98
[RollbackTax(Y/N)] => Unknown
[LA1AgentFirstName] => Jim
[GeoUpdateTimestamp] => 2026-11-17T18:38:33.2
[AddressSearchNumber] => 734
[LO1OfficeIdentifier] => 922
[Level-MasterBedroom] => Main
[ListingTypeAgreement] => Exclusive Agency
[PublishtoInternetY/N] => Yes
[Interior#ofFireplaces] => 0
[LO1OfficeAbbreviation] => YIPP01
[FirstPhotoAddTimestamp] => 2026-11-17T18:38:34
[MlsAreaMajor] => City of Columbia, Denny terrace, Lake Elizabeth
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6470040
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/647004/5ee811e5ba8343560e39c03e753f9f31.webp
[ClassName] => Single Family
[MediaSize] => 275395
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/647004/thumbnail-5ee811e5ba8343560e39c03e753f9f31.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 647004
)
)
[DaysOnMarket] => 0
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('647004')
[ID] => 140946
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.14 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