94-540 Loaa Street Waipahu, HI 96797

Listing
Overview

Price: $1,050,000
Area: HARBOR VIEW
Status: Active Under Contract

Experience island living at its finest in this beautifully renovated 4-bedroom, 2-bath single-level home designed for comfort, functionality, and modern style. Come inside to a bright, open layout with luxury vinyl plank flooring throughout and seamless flow between the living, dining, and kitchen areas. The stunning kitchen features a large island, brand new stainless steel appliances, and custom cabinetry — perfect for entertaining or everyday enjoyment. Every detail, from lighting to finishes, has been thoughtfully selected to create a warm and inviting atmosphere. The landscaped front yard with sprinkler system offers curb appeal and easy maintenance, while solar panels provide energy efficiency and long-term savings. Conveniently located near schools, parks, shopping, and dining, this move-in ready home blends quality renovation with timeless island charm. Description may not match tax records. Listing by: Refined Real Estate Hawaii LLC (808) 796-7694

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202524758"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-540"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(4) "Loaa"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96797"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1050000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "HARBOR VIEW"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(914) "Experience island living at its finest in this beautifully renovated 4-bedroom, 2-bath single-level home designed for comfort, functionality, and modern style. Come inside to a bright, open layout with luxury vinyl plank flooring throughout and seamless flow between the living, dining, and kitchen areas. The stunning kitchen features a large island, brand new stainless steel appliances, and custom cabinetry — perfect for entertaining or everyday enjoyment. Every detail, from lighting to finishes, has been thoughtfully selected to create a warm and inviting atmosphere. The landscaped front yard with sprinkler system offers curb appeal and easy maintenance, while solar panels provide energy efficiency and long-term savings. Conveniently located near schools, parks, shopping, and dining, this move-in ready home blends quality renovation with timeless island charm. Description may not match tax records."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(30) "Refined Real Estate Hawaii LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "6730.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1662"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1970"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(23) "Excellent,Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "RREH"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(26) "rubyanne@refinedhawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 796-7694"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(19) "Ruby Anne N Paulino"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19078735"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-11-17T09:59:38.827"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-11-15"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "09:59:38.827"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27221087"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27221087"
    [1]=>
    string(8) "27221088"
    [2]=>
    string(8) "27221089"
    [3]=>
    string(8) "27221090"
    [4]=>
    string(8) "27221091"
    [5]=>
    string(8) "27221092"
    [6]=>
    string(8) "27221093"
    [7]=>
    string(8) "27221094"
    [8]=>
    string(8) "27221095"
    [9]=>
    string(8) "27221096"
    [10]=>
    string(8) "27221097"
    [11]=>
    string(8) "27221098"
    [12]=>
    string(8) "27221099"
    [13]=>
    string(8) "27221100"
    [14]=>
    string(8) "27221101"
    [15]=>
    string(8) "27221102"
    [16]=>
    string(8) "27221103"
    [17]=>
    string(8) "27221104"
    [18]=>
    string(8) "27221105"
    [19]=>
    string(8) "27221106"
    [20]=>
    string(8) "27221107"
    [21]=>
    string(8) "27221108"
    [22]=>
    string(8) "27221109"
    [23]=>
    string(8) "27221110"
    [24]=>
    string(8) "27221111"
    [25]=>
    string(8) "27221112"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202524758
        )

    [StreetNumber] => Array
        (
            [0] => 94-540
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

    [StreetName] => Array
        (
            [0] => Loaa
        )

    [StreetSuffix] => Array
        (
            [0] => Street
        )

    [UnitNumber] => Array
        (
            [0] => 
        )

    [City] => Array
        (
            [0] => Waipahu
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96797
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 1050000.00
        )

    [Neighbourhood] => Array
        (
            [0] => HARBOR VIEW
        )

    [Status] => Array
        (
            [0] => Active Under Contract
        )

    [PublicRemarks] => Array
        (
            [0] => Experience island living at its finest in this beautifully renovated 4-bedroom, 2-bath single-level home designed for comfort, functionality, and modern style. Come inside to a bright, open layout with luxury vinyl plank flooring throughout and seamless flow between the living, dining, and kitchen areas. The stunning kitchen features a large island, brand new stainless steel appliances, and custom cabinetry — perfect for entertaining or everyday enjoyment. Every detail, from lighting to finishes, has been thoughtfully selected to create a warm and inviting atmosphere. The landscaped front yard with sprinkler system offers curb appeal and easy maintenance, while solar panels provide energy efficiency and long-term savings. Conveniently located near schools, parks, shopping, and dining, this move-in ready home blends quality renovation with timeless island charm. Description may not match tax records.
        )

    [ListOfficeName] => Array
        (
            [0] => Refined Real Estate Hawaii LLC
        )

    [BedsTotal] => Array
        (
            [0] => 4
        )

    [BathsFull] => Array
        (
            [0] => 2
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 6730.00
        )

    [SqftTotal] => Array
        (
            [0] => 1662
        )

    [YearBuilt] => Array
        (
            [0] => 1970
        )

    [BuildingName] => Array
        (
            [0] => 
        )

    [PropertyCondition] => Array
        (
            [0] => Excellent,Above Average
        )

    [ParkingTotal] => Array
        (
            [0] => 4
        )

    [StoriesType] => Array
        (
            [0] => One
        )

    [View] => Array
        (
            [0] => Other
        )

    [MaintenanceExpense] => Array
        (
            [0] => 
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => 
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => 
        )

    [ListOfficeMLSID] => Array
        (
            [0] => RREH
        )

    [ListAgentEmail] => Array
        (
            [0] => rubyanne@refinedhawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 796-7694
        )

    [ListAgentFullName] => Array
        (
            [0] => Ruby Anne N Paulino
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 19078735
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-11-17T09:59:38.827
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-11-15
        )

    [MLSAreaMajor] => Array
        (
            [0] => Waipahu
        )

    [PropertyFrontage] => Array
        (
            [0] => Other
        )

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 09:59:38.827
        )

    [_thumbnail_id] => Array
        (
            [0] => 27221087
        )

    [listing_image] => Array
        (
            [0] => 27221087
            [1] => 27221088
            [2] => 27221089
            [3] => 27221090
            [4] => 27221091
            [5] => 27221092
            [6] => 27221093
            [7] => 27221094
            [8] => 27221095
            [9] => 27221096
            [10] => 27221097
            [11] => 27221098
            [12] => 27221099
            [13] => 27221100
            [14] => 27221101
            [15] => 27221102
            [16] => 27221103
            [17] => 27221104
            [18] => 27221105
            [19] => 27221106
            [20] => 27221107
            [21] => 27221108
            [22] => 27221109
            [23] => 27221110
            [24] => 27221111
            [25] => 27221112
        )

)

  • BedsTotal: 4
  • Full Baths: 2
  • Land Area (sf): 6,730 sf
  • Living (sf): 1,662
  • Year Built: 1970

  • Property Condition: Excellent,Above Average
  • Number of Parking Spaces: 4
  • View: Other
  • Listing Office: Refined Real Estate Hawaii LLC

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on November 17, 2025 - 9:59 AM Information is deemed reliable but not guaranteed. Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®. If you are interested in those active listings, our company may represent you as the buyer's agent. If the active listing you are interested in is our company's active listing, you may speak to one of our agents regarding your options for representation.

© Marcus Realty. All Rights Reserved.