Sort By:
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:1 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=3672&$filter=(StandardStatus eq 'Active') and (StandardStatus eq 'For Sale' OR RFTransactionType eq 'For Sale')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#6335 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6337 +post_id: "57546" +post_author: 1 +"ListingKey": "1128295563" +"ListingId": "202518527" +"PropertyType": "For Sale" +"PropertySubType": "Multi Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-22T02:15:42Z" +"RFModificationTimestamp": "2025-11-11T01:56:17Z" +"ListPrice": 2300000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 5530.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Honolulu" +"PostalCode": "96826" +"UnparsedAddress": "707 Hausten Street, Honolulu, Hawaii 96826" +"Coordinates": array:2 [ 0 => -157.8252599 1 => 21.2892117 ] +"Latitude": 21.2892117 +"Longitude": -157.8252599 +"YearBuilt": 1944 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Gifford KF Chang" +"ListOfficeName": "Ideal Properties, Inc." +"ListAgentMlsId": "17118" +"ListOfficeMlsId": "IDEL" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Super Location. Steady income stream AND rents are below market. Expenses are manageable. Self-managed property owners will find rental business easy. Close to University, public and private schools. Approximately 1 to 2 blocks walking distance away to bus stop and mini shopping malls." +"Appliances": "Dryer, Washer" +"ArchitecturalStyle": "Fourplex" +"AttributionContact": "(808) 593-9776" +"CLIP": 2611468846 +"CommunityFeatures": "None" +"ConstructionMaterials": "Hollow Tile,Single Wall,Wood Frame" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-08-22T02:15:07.064888+00:00" +"DaysOnMarketReplicationDate": "2025-08-22" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "1031 Exchange,Familial Relation,Pet on Property,Seller Disclosure" +"ElementarySchool": "Ala Wai" +"Furnished": "Unfurnished" +"HighSchool": "Kaimuki" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Coin-operated" +"Levels": "Two" +"ListAgentDirectPhone": "(808) 593-9776" +"ListAgentEmail": "idealgifford@gmail.com" +"ListAgentKey": "10773765" +"ListAgentKeyNumeric": "10773765" +"ListAgentOfficePhone": "(808) 593-9776" +"ListAgentPreferredPhone": "(808) 593-9776" +"ListAgentStateLicense": "RB-16205" +"ListOfficeEmail": "idealpropertiesinc@yahoo.com" +"ListOfficeKey": "2586346" +"ListOfficeKeyNumeric": "2586346" +"ListOfficePhone": "(808) 593-9776" +"ListingContractDate": "2025-08-21" +"ListingKeyNumeric": 1128295563 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Level" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2025-08-21T16:12:19Z" +"MiddleOrJuniorSchool": "Washington" +"MlsStatus": "Active" +"NetOperatingIncome": 34000.0 +"NumberOfUnitsTotal": "7" +"OnMarketDate": "2025-08-21" +"OpenParkingYN": true +"OperatingExpense": "50000.0" +"OperatingExpenseIncludes": "Insurance,Manager,Maintenance,Other,Real Estate Tax,New Tax,Water/Sewer" +"OriginalListPrice": 2300000.0 +"OriginatingSystemKey": "18938068" +"ParcelNumber": "1-2-7-011-002-0000" +"ParkingFeatures": "Assigned, Open" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-11-11T00:21:13Z" +"PhotosCount": 3 +"PostalCity": "Honolulu" +"PropertyCondition": "Average Condition" +"Sewer": "Connected" +"SourceSystemKey": "1128295563" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Hausten" +"StreetNumber": "707" +"StreetNumberNumeric": "707" +"StreetSuffix": "Street" +"StructureType": "Apartment,Multi Family,Triplex" +"SubdivisionName": "MOILIILI" +"TaxAnnualAmount": "5100.0" +"TaxAssessedValue": 1456200 +"TenantPays": "Cable TV,Electricity,Gas,Parking Fee" +"Topography": "Level" +"TotalActualRent": 7000.0 +"Utilities": "Above Ground Utilities,Electricity Available,Natural Gas Available,Sewer Available,Water Available,Sewer Connected" +"View": "None" +"WaterSource": "Public" +"YearBuiltEffective": 1950 +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1128295563"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "1322400" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "133800" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1128295563')" +"provider_name": "HICMLS" +"RecordSignature": -733155354 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-7-011-002-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3484728" +"OriginatingSystemListAgentMemberKey": "8842918" +"Media": array:3 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004232986374" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128295563/c160d1945bb147f309716149dd69053f.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 100594 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128295563/thumbnail-c160d1945bb147f309716149dd69053f.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10773765" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2586346" "MediaCategory" => null "MediaObjectID" => "Front Dwelling.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "IDEL" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004232986374 "PropertySubType" => "Multi Family" "RecordSignature" => 1807233008 "PreferredPhotoYN" => null "ResourceRecordID" => "202518527" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128295563" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:41.950-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128295563 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18939183" "PropertySubTypeAdditional" => "Multi Family" "MediaModificationTimestamp" => "2025-11-11T00:20:41.950-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18938068" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004232986375" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128295563/09c0ae4e8ff89afda9595ffa5f9d0b04.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 108321 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128295563/thumbnail-09c0ae4e8ff89afda9595ffa5f9d0b04.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10773765" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2586346" "MediaCategory" => null "MediaObjectID" => "Back dwelling.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "IDEL" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004232986375 "PropertySubType" => "Multi Family" "RecordSignature" => 1807233008 "PreferredPhotoYN" => null "ResourceRecordID" => "202518527" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128295563" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:41.950-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128295563 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18939184" "PropertySubTypeAdditional" => "Multi Family" "MediaModificationTimestamp" => "2025-11-11T00:20:41.950-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18938068" ] 2 => array:57 [ "Order" => 3 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004232986376" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128295563/43f0ac81fa24de9dd1c7973dfc0c8232.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 62834 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128295563/thumbnail-43f0ac81fa24de9dd1c7973dfc0c8232.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10773765" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2586346" "MediaCategory" => null "MediaObjectID" => "Coin Laundry.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "IDEL" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004232986376 "PropertySubType" => "Multi Family" "RecordSignature" => 1807233008 "PreferredPhotoYN" => null "ResourceRecordID" => "202518527" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128295563" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:41.950-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128295563 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18939185" "PropertySubTypeAdditional" => "Multi Family" "MediaModificationTimestamp" => "2025-11-11T00:20:41.950-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18938068" ] ] +"ID": "57546" } ] +success: true +page_size: 9 +page_count: 409 +count: 3673 +after_key: "" } "RF Response Time" => "0.15 seconds" ] ]
