94-871 Hiapo Street Waipahu, HI 96797

Take a Virtual Tour

Listing
Overview

Price: $1,260,000
Area: WAIKELE-RENAISSANCE
Status: Active

Immaculate two-story 4 bedroom, 2.5 bath single family home with two family rooms. Situated on a nice corner lot in the Renaissance subdivision. Over $190,000.00 in recent upgrades including a brand new custom kitchen with Rev-A-Shelf inserts, all new appliances, and new flooring throughout with luxury vinyl planks, and ceramic tile. Brand new hot water/solar heater, new whole-house water softener, and security cameras. Bathroom renovations include new custom wood cabinets, countertops, lighted crown molding, new vanities, and light fixtures. A new central air conditioner with 27 owned photovoltaic panels. Brand-new paint interior and exterior, and new outdoor wired security lighting. Additionally, the upgraded garage with True-Lock Extreme Diamond Pattern Tile flooring. Conveniently located to on/off freeway access, close to Waikele Shopping Outlets, Safeway, and Lowe’s. Centrally located on the island with easy commutes to Ewa, Kapolei, and to the Daniel K. Inouye International Airport! Feel the comfort of living in this tranquil, convenient, and great neighborhood of the Renaissance subdivision with a park directly across the street for children to play. A must-see! Listing by: OahuRE.com (808) 425-7887

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202427519"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "94-871"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(5) "Hiapo"
  }
  ["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(92) "https://oahurealestatevirtualtours.net/SellYourHome.php?MLSNumber=202427519&PropertyType=RES"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1260000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(19) "WAIKELE-RENAISSANCE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1189) "Immaculate two-story 4 bedroom, 2.5 bath single family home with two family rooms. Situated on a nice corner lot in the Renaissance subdivision. Over $190,000.00 in recent upgrades including a brand new custom kitchen with Rev-A-Shelf inserts, all new appliances, and new flooring throughout with luxury vinyl planks, and ceramic tile. Brand new hot water/solar heater, new whole-house water softener, and security cameras. Bathroom renovations include new custom wood cabinets, countertops, lighted crown molding, new vanities, and light fixtures. A new central air conditioner with 27 owned photovoltaic panels. Brand-new paint interior and exterior, and new outdoor wired security lighting. Additionally, the upgraded garage with True-Lock Extreme Diamond Pattern Tile flooring. Conveniently located to on/off freeway access, close to Waikele Shopping Outlets, Safeway, and Lowe’s. Centrally located on the island with easy commutes to Ewa, Kapolei, and to the Daniel K. Inouye International Airport! Feel the comfort of living in this tranquil, convenient, and great neighborhood of the Renaissance subdivision with a park directly across the street for children to play. A must-see!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(10) "OahuRE.com"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "4191.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2185"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2005"
  }
  ["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(8) "Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(7) "Waikele"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "GIVE"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(15) "bryn@oahure.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 425-7887"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Bryn W Kaufman"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-01-12T19:00:01.003"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18407880"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26790243"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26790243"
    [1]=>
    string(8) "26790244"
    [2]=>
    string(8) "26790245"
    [3]=>
    string(8) "26790246"
    [4]=>
    string(8) "26790247"
    [5]=>
    string(8) "26790248"
    [6]=>
    string(8) "26790249"
    [7]=>
    string(8) "26790250"
    [8]=>
    string(8) "26790251"
    [9]=>
    string(8) "26790252"
    [10]=>
    string(8) "26790253"
    [11]=>
    string(8) "26790254"
    [12]=>
    string(8) "26790255"
    [13]=>
    string(8) "26790256"
    [14]=>
    string(8) "26790257"
    [15]=>
    string(8) "26790258"
    [16]=>
    string(8) "26790259"
    [17]=>
    string(8) "26790260"
    [18]=>
    string(8) "26790261"
    [19]=>
    string(8) "26790262"
    [20]=>
    string(8) "26790263"
    [21]=>
    string(8) "26790264"
    [22]=>
    string(8) "26790265"
    [23]=>
    string(8) "26790266"
    [24]=>
    string(8) "26790267"
    [25]=>
    string(8) "26790268"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-11-30"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "19:00:01.003"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202427519
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://oahurealestatevirtualtours.net/SellYourHome.php?MLSNumber=202427519&PropertyType=RES
        )

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

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

    [Neighbourhood] => Array
        (
            [0] => WAIKELE-RENAISSANCE
        )

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

    [PublicRemarks] => Array
        (
            [0] => Immaculate two-story 4 bedroom, 2.5 bath single family home with two family rooms. Situated on a nice corner lot in the Renaissance subdivision. Over $190,000.00 in recent upgrades including a brand new custom kitchen with Rev-A-Shelf inserts, all new appliances, and new flooring throughout with luxury vinyl planks, and ceramic tile. Brand new hot water/solar heater, new whole-house water softener, and security cameras. Bathroom renovations include new custom wood cabinets, countertops, lighted crown molding, new vanities, and light fixtures. A new central air conditioner with 27 owned photovoltaic panels. Brand-new paint interior and exterior, and new outdoor wired security lighting. Additionally, the upgraded garage with True-Lock Extreme Diamond Pattern Tile flooring. Conveniently located to on/off freeway access, close to Waikele Shopping Outlets, Safeway, and Lowe’s. Centrally located on the island with easy commutes to Ewa, Kapolei, and to the Daniel K. Inouye International Airport! Feel the comfort of living in this tranquil, convenient, and great neighborhood of the Renaissance subdivision with a park directly across the street for children to play. A must-see!
        )

    [ListOfficeName] => Array
        (
            [0] => OahuRE.com
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => bryn@oahure.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 425-7887
        )

    [ListAgentFullName] => Array
        (
            [0] => Bryn W Kaufman
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-01-12T19:00:01.003
        )

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

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

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26790243
            [1] => 26790244
            [2] => 26790245
            [3] => 26790246
            [4] => 26790247
            [5] => 26790248
            [6] => 26790249
            [7] => 26790250
            [8] => 26790251
            [9] => 26790252
            [10] => 26790253
            [11] => 26790254
            [12] => 26790255
            [13] => 26790256
            [14] => 26790257
            [15] => 26790258
            [16] => 26790259
            [17] => 26790260
            [18] => 26790261
            [19] => 26790262
            [20] => 26790263
            [21] => 26790264
            [22] => 26790265
            [23] => 26790266
            [24] => 26790267
            [25] => 26790268
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-11-30
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 19:00:01.003
        )

)

  • BedsTotal: 4
  • Full Baths: 2
  • Half Baths: 1
  • Land Area (sf): 4,191 sf
  • Living (sf): 2,185
  • Year Built: 2005

  • Property Condition: Excellent
  • Number of Parking Spaces: 4
  • View: Mountain
  • Listing Office: OahuRE.com

  • Land Tenure: FS - Fee Simple

  • Elementary School: Waikele
  • Middle School: Waipahu
  • High School: Waipahu

CONTACT US

Marcus Realty

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