94-1160 Halelaukoa Drive Unit A1-48 Waipahu, HI 96797

Listing
Overview

Price: $1,400,000
Area: KOA RIDGE
Status: Active

4.75% VA ASSUMABLE LOAN TO VA QUALIFIED BUYERS! Welcome to this stunning and elegant 2-story home in Koa Ridge. This beautiful home has 5-bedrooms, 3 full baths with 2-car garage and 2 additional parking on the driveway. A spacious bedroom and full bath are located on the lower level. There are two large living spaces adjacent to the main entrance and 2nd level where it opens up at the top of the stairs. The bathrooms are with ceramic tile and bedrooms, living rooms and kitchen are with luxury vinyl flooring. The yard is fenced in with Rockwall on the front, backyard and Diamond Head side of the home. The home is equipped with Split AC Unit for your comfort throughout the living rooms and bedrooms. This property is in close proximity of freeway access, shopping centers, eateries, Costco, schools and public parks. Listing by: Five Star Realty, Inc. (808) 753-7211

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202407431"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(7) "94-1160"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(10) "Halelaukoa"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Drive"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(5) "A1-48"
  }
  ["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) "1400000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1400000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(9) "KOA RIDGE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(825) "4.75% VA ASSUMABLE LOAN TO VA QUALIFIED BUYERS!  Welcome to this stunning and elegant 2-story home in Koa Ridge. This beautiful home has 5-bedrooms, 3 full baths with 2-car garage and 2 additional parking on the driveway. A spacious bedroom and full bath are located on the lower level. There are two large living spaces adjacent to the main entrance and 2nd level where it opens up at the top of the stairs. The bathrooms are with ceramic tile and bedrooms, living rooms and kitchen are with luxury vinyl flooring. The yard is fenced in with Rockwall on the front, backyard and Diamond Head side of the home. The home is equipped with Split AC Unit for your comfort throughout the living rooms and bedrooms. This property is in close proximity of freeway access, shopping centers, eateries, Costco, schools and public parks."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Five Star Realty, Inc."
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "4278.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2266"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(12) "Garden,Other"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(5) "50.00"
  }
  ["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(6) "FIVE02"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(20) "Ruth@RuthSells.Homes"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 753-7211"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(19) "Ruth Manzano Javier"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-06-28T16:45:01.337"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17916402"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-04-01T14:19:19.037"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26157848"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26157848"
    [1]=>
    string(8) "26157849"
    [2]=>
    string(8) "26157850"
    [3]=>
    string(8) "26157851"
    [4]=>
    string(8) "26157852"
    [5]=>
    string(8) "26157853"
    [6]=>
    string(8) "26157854"
    [7]=>
    string(8) "26157855"
    [8]=>
    string(8) "26157856"
    [9]=>
    string(8) "26157857"
    [10]=>
    string(8) "26157858"
    [11]=>
    string(8) "26157859"
    [12]=>
    string(8) "26157860"
    [13]=>
    string(8) "26157861"
    [14]=>
    string(8) "26157862"
    [15]=>
    string(8) "26157863"
    [16]=>
    string(8) "26157864"
    [17]=>
    string(8) "26157865"
    [18]=>
    string(8) "26157866"
    [19]=>
    string(8) "26157867"
    [20]=>
    string(8) "26157868"
    [21]=>
    string(8) "26157869"
    [22]=>
    string(8) "26157870"
    [23]=>
    string(8) "26157871"
    [24]=>
    string(8) "26157872"
    [25]=>
    string(8) "26157873"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202407431
        )

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

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

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

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

    [UnitNumber] => Array
        (
            [0] => A1-48
        )

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

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

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

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

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

    [CurrentPrice] => Array
        (
            [0] => 1400000.00
        )

    [Neighbourhood] => Array
        (
            [0] => KOA RIDGE
        )

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

    [PublicRemarks] => Array
        (
            [0] => 4.75% VA ASSUMABLE LOAN TO VA QUALIFIED BUYERS!  Welcome to this stunning and elegant 2-story home in Koa Ridge. This beautiful home has 5-bedrooms, 3 full baths with 2-car garage and 2 additional parking on the driveway. A spacious bedroom and full bath are located on the lower level. There are two large living spaces adjacent to the main entrance and 2nd level where it opens up at the top of the stairs. The bathrooms are with ceramic tile and bedrooms, living rooms and kitchen are with luxury vinyl flooring. The yard is fenced in with Rockwall on the front, backyard and Diamond Head side of the home. The home is equipped with Split AC Unit for your comfort throughout the living rooms and bedrooms. This property is in close proximity of freeway access, shopping centers, eateries, Costco, schools and public parks.
        )

    [ListOfficeName] => Array
        (
            [0] => Five Star Realty, Inc.
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Ruth@RuthSells.Homes
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 753-7211
        )

    [ListAgentFullName] => Array
        (
            [0] => Ruth Manzano Javier
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-06-28T16:45:01.337
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-04-01T14:19:19.037
        )

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

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

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

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

    [listing_image] => Array
        (
            [0] => 26157848
            [1] => 26157849
            [2] => 26157850
            [3] => 26157851
            [4] => 26157852
            [5] => 26157853
            [6] => 26157854
            [7] => 26157855
            [8] => 26157856
            [9] => 26157857
            [10] => 26157858
            [11] => 26157859
            [12] => 26157860
            [13] => 26157861
            [14] => 26157862
            [15] => 26157863
            [16] => 26157864
            [17] => 26157865
            [18] => 26157866
            [19] => 26157867
            [20] => 26157868
            [21] => 26157869
            [22] => 26157870
            [23] => 26157871
            [24] => 26157872
            [25] => 26157873
        )

)

  • BedsTotal: 5
  • Full Baths: 3
  • Land Area (sf): 4,278
  • Living (sf): 2,266
  • Year Built: 2021

  • Property Condition: Excellent
  • Number of Parking Spaces: 4
  • View: Garden,Other
  • Listing Office: Five Star Realty, Inc.

  • Maintenance Fees: $50
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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