94-1007 Puia Street
Waipahu, HI 96797

Listing
Overview

Price: $1,750,000
Area: ROYAL KUNIA
Status: Sold

Stunning 6Bed/5.5Bath that opens up into a luxurious 18-ft high ceiling living room that can be used as a karaoke room or in-home theater with ambient surround sound and roll down projector screen. High-ceiling master bedroom with large walk-in closet with built-in shelves, double vanity, Whirlpool tub with in-line heater, steam shower, bidet, spacious balcony lanai and make-up counter. Fantastic views of Diamond Head, Pearl Harbor, and Honolulu. Outdoor pavers deck perfect for large gatherings and shaded by an abundance of fruit trees. 42 ft. long pool with full outdoor bath. Key features include: Monier roof, aluminum windows, real stucco, marble floors, granite countertops, downstairs and upstairs bars, custom-built China cabinet and bookshelves, commercial refrigerator and Samsung refrigerator, stove top, double oven, through garage with front and rear doors, bay windows with seating, ample storage, security cameras, and baby grand piano. Located on an 8,926 sq. ft. lot in a private cul-de-sac, the property borders the 14th hole overlooking the Kunia Golf Course. This house was designed with hosting and entertaining in mind, but you’ll have to see it for yourself!

Listing by: Sapigao Investment Prop., LLC

array(161) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(9) "478400.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "646600.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(10) "1125000.00"
  }
  ["assn_fee_inclusions"]=>
  array(1) {
    [0]=>
    string(3) "131"
  }
  ["association_fees"]=>
  array(1) {
    [0]=>
    string(3) "131"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(20) "Detach Single Family"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(38) "Inactive Licensed Owner,Licensed Owner"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["elementary_school"]=>
  array(1) {
    [0]=>
    string(9) "Kaleiopuu"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(33) "Ceramic Tile,Marble/Granite,Vinyl"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(11) "Golf Course"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(7) "Partial"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["high_school"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(6) "100000"
  }
  ["lanai_sf"]=>
  array(1) {
    [0]=>
    string(3) "310"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(7) "8926.00"
  }
  ["land_recorded"]=>
  array(1) {
    [0]=>
    string(12) "Dual Systems"
  }
  ["land_tenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["list_agent_email"]=>
  array(1) {
    [0]=>
    string(23) "frank.sapigao@gmail.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(23) "Francisco B Sapigao Jr."
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 291-4049"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-08-21"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(29) "Sapigao Investment Prop., LLC"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(10) "1750000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "4676"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(38) "94-1007 Puia Street, Waipahu, HI 96797"
  }
  ["middle_school"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202121297"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(11) "ROYAL KUNIA"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "SAPI"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(22) "3 Car+,Driveway,Garage"
  }
  ["pool_"]=>
  array(1) {
    [0]=>
    string(31) "In Ground,Tile,Pool on Property"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(26) "45 Days or Less,At Closing"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96797"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["property_type"]=>
  array(1) {
    [0]=>
    string(13) "single_family"
  }
  ["property_type_label"]=>
  array(1) {
    [0]=>
    string(13) "single_family"
  }
  ["region"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["rets_association_fee"]=>
  array(1) {
    [0]=>
    string(3) "131"
  }
  ["rets_association_fee_total"]=>
  array(1) {
    [0]=>
    string(3) "131"
  }
  ["rets_baths_full"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["rets_baths_half"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_baths_total"]=>
  array(1) {
    [0]=>
    string(4) "5.01"
  }
  ["rets_beds_total"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["rets_builder_name"]=>
  array(1) {
    [0]=>
    string(25) "Sapigao Construction Inc."
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["rets_condo_property_regime_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(10) "1700000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "63"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_elementary_school"]=>
  array(1) {
    [0]=>
    string(9) "Kaleiopuu"
  }
  ["rets_foreclosure_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_fractional_ownership_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_high_school"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "16112089"
  }
  ["rets_immoviewer_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_internet_automated_valuation_dis"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_internet_consumer_comment_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_list_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 291-4049"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(23) "frank.sapigao@gmail.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(23) "Francisco B Sapigao Jr."
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "12797"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "3472927"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "SAPI"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "15868574"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(29) "Sapigao Investment Prop., LLC"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 291-4049"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(10) "1750000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-08-21"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(7) "8926.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-12-01T10:35:55.007"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16112089"
  }
  ["rets_middle_or_junior_school"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202121297"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "ROYAL KUNIA"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-08-21T21:14:39.643"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(10) "1750000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-9-4-137-126-0000"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["rets_permit_address_internet_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_permit_internet_yn"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_photo_count"]=>
  array(1) {
    [0]=>
    string(2) "25"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-08-21T21:14:39.643"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96797"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-08-21T21:14:39.643"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16112089"
  }
  ["rets_room_count"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_sqft_garage_carport"]=>
  array(1) {
    [0]=>
    string(3) "528"
  }
  ["rets_sqft_lanai_open"]=>
  array(1) {
    [0]=>
    string(3) "310"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "4308"
  }
  ["rets_sqft_roofed_other"]=>
  array(1) {
    [0]=>
    string(2) "58"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "4676"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-12-01T10:35:55.007"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-30"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(4) "Puia"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(7) "94-1007"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(63) "1$21.399833$-158.021427$73.13$13.33$1.00$1UYZBPtSZroBpUfnzk6eGA"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "298.96"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(10) "1125000.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(9) "478400.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "646600.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(6) "100000"
  }
  ["rets_tax_paid_by_seller_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tax_year"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["rets_thumbnail_url"]=>
  array(1) {
    [0]=>
    string(81) "https://cdn.rets.ci/marcusrealty-images/16112089/5cf778af34bca38804207a7475c0baed"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "194"
  }
  ["rets_tmk_condo_property_regime_number"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_tmk_division"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["rets_tmk_parcel"]=>
  array(1) {
    [0]=>
    string(3) "126"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "9"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(3) "137"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1993"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["security"]=>
  array(1) {
    [0]=>
    string(5) "Video"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(3) "C&C"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(4) "Puia"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(7) "94-1007"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(17) "Cash,Conventional"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-9-4-137-126-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(17) "Irregular,Rim Lot"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(53) "City,Diamond Head,Garden,Golf Course,Mountain,Sunrise"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16112089"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202121297"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1638391028"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1993"
  }
  ["year_remodeled_"]=>
  array(1) {
    [0]=>
    string(4) "2021"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(29) "05 - R-5 Residential District"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(1683) "a:105:{i:0;i:20579082;i:1;i:20579083;i:2;i:20579084;i:3;i:20579085;i:4;i:20579086;i:5;i:20579087;i:6;i:20579088;i:7;i:20579089;i:8;i:20579090;i:9;i:20579091;i:10;i:20579092;i:11;i:20579093;i:12;i:20579094;i:13;i:20579095;i:14;i:20579096;i:15;i:20579097;i:16;i:20579098;i:17;i:20579099;i:18;i:20579100;i:19;i:20579101;i:20;i:20579102;i:21;i:20579182;i:22;i:20579183;i:23;i:20579184;i:24;i:20579185;i:25;i:20579186;i:26;i:20579187;i:27;i:20579188;i:28;i:20579189;i:29;i:20579190;i:30;i:20579191;i:31;i:20579192;i:32;i:20579193;i:33;i:20579194;i:34;i:20579195;i:35;i:20579196;i:36;i:20579197;i:37;i:20579198;i:38;i:20579199;i:39;i:20579200;i:40;i:20579201;i:41;i:20579202;i:42;i:20583387;i:43;i:20583388;i:44;i:20583389;i:45;i:20583390;i:46;i:20583391;i:47;i:20583392;i:48;i:20583393;i:49;i:20583394;i:50;i:20583395;i:51;i:20583396;i:52;i:20583397;i:53;i:20583398;i:54;i:20583399;i:55;i:20583400;i:56;i:20583401;i:57;i:20583402;i:58;i:20583403;i:59;i:20583404;i:60;i:20583405;i:61;i:20583406;i:62;i:20583407;i:63;i:21020985;i:64;i:21020986;i:65;i:21020987;i:66;i:21020988;i:67;i:21020989;i:68;i:21020990;i:69;i:21020991;i:70;i:21020992;i:71;i:21020993;i:72;i:21020994;i:73;i:21020995;i:74;i:21020996;i:75;i:21020997;i:76;i:21020998;i:77;i:21020999;i:78;i:21021000;i:79;i:21021001;i:80;i:21021002;i:81;i:21021003;i:82;i:21021004;i:83;i:21021005;i:84;i:21252533;i:85;i:21252534;i:86;i:21252535;i:87;i:21252536;i:88;i:21252537;i:89;i:21252538;i:90;i:21252539;i:91;i:21252540;i:92;i:21252541;i:93;i:21252542;i:94;i:21252543;i:95;i:21252544;i:96;i:21252545;i:97;i:21252546;i:98;i:21252547;i:99;i:21252548;i:100;i:21252549;i:101;i:21252550;i:102;i:21252551;i:103;i:21252552;i:104;i:21252553;}"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(197) "Easy to show, but shown by apartment only.  Listed by owner.  Contact Frank Sapigao (RB) at (808) 291-4049 or Ciarra Sapigao (RA) at (808) 291-6118 to schedule a showing.  COVID-19 protocols apply."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(1193) "Stunning 6Bed/5.5Bath that opens up into a luxurious 18-ft high ceiling living room that can be used as a karaoke room or in-home theater with ambient surround sound and roll down projector screen.  High-ceiling master bedroom with large walk-in closet with built-in shelves, double vanity, Whirlpool tub with in-line heater, steam shower, bidet, spacious balcony lanai and make-up counter.  Fantastic views of Diamond Head, Pearl Harbor, and Honolulu.  Outdoor pavers deck perfect for large gatherings and shaded by an abundance of fruit trees.  42 ft. long pool with full outdoor bath.  Key features include: Monier roof, aluminum windows, real stucco, marble floors, granite countertops, downstairs and upstairs bars, custom-built China cabinet and bookshelves, commercial refrigerator and Samsung refrigerator, stove top, double oven, through garage with front and rear doors, bay windows with seating, ample storage, security cameras, and baby grand piano.  Located on an 8,926 sq. ft. lot in a private cul-de-sac, the property borders the 14th hole overlooking the Kunia Golf Course.  This house was designed with hosting and entertaining in mind, but you'll have to see it for yourself!"
  }
  ["rets_pending_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-10-22"
  }
  ["rets_tax_annual_amount"]=>
  array(1) {
    [0]=>
    string(7) "3587.52"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-30"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(10) "1700000.00"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-02-21"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-11-30"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-0695"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(24) "malcolmshiroma@gmail.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(17) "Malcolm S Shiroma"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "04974"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "8842649"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "NASH"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3484748"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(21) "Property Center, Inc."
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-0695"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "21252533"
  }
}
Array
(
    [assd_val_imprv] => Array
        (
            [0] => 478400.00
        )

    [assd_val_land] => Array
        (
            [0] => 646600.00
        )

    [assd_val_total] => Array
        (
            [0] => 1125000.00
        )

    [assn_fee_inclusions] => Array
        (
            [0] => 131
        )

    [association_fees] => Array
        (
            [0] => 131
        )

    [bedrooms] => Array
        (
            [0] => 6
        )

    [building_style] => Array
        (
            [0] => Detach Single Family
        )

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

    [county] => Array
        (
            [0] => Oahu
        )

    [disclosures] => Array
        (
            [0] => Inactive Licensed Owner,Licensed Owner
        )

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

    [elementary_school] => Array
        (
            [0] => Kaleiopuu
        )

    [floor_covering] => Array
        (
            [0] => Ceramic Tile,Marble/Granite,Vinyl
        )

    [frontage] => Array
        (
            [0] => Golf Course
        )

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

    [furnished] => Array
        (
            [0] => Partial
        )

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

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

    [home_exampt] => Array
        (
            [0] => 100000
        )

    [lanai_sf] => Array
        (
            [0] => 310
        )

    [land_area_sf] => Array
        (
            [0] => 8926.00
        )

    [land_recorded] => Array
        (
            [0] => Dual Systems
        )

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

    [list_agent_email] => Array
        (
            [0] => frank.sapigao@gmail.com
        )

    [list_agent_name] => Array
        (
            [0] => Francisco B Sapigao Jr.
        )

    [list_agent_phone_number] => Array
        (
            [0] => (808) 291-4049
        )

    [list_date] => Array
        (
            [0] => 2021-08-21
        )

    [list_office_name] => Array
        (
            [0] => Sapigao Investment Prop., LLC
        )

    [list_price] => Array
        (
            [0] => 1750000.00
        )

    [living_sf] => Array
        (
            [0] => 4676
        )

    [location] => Array
        (
            [0] => 94-1007 Puia Street, Waipahu, HI 96797
        )

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

    [mls_] => Array
        (
            [0] => 202121297
        )

    [neighborhood] => Array
        (
            [0] => ROYAL KUNIA
        )

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

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

    [office_mls_id] => Array
        (
            [0] => SAPI
        )

    [parking_features] => Array
        (
            [0] => 3 Car+,Driveway,Garage
        )

    [pool_] => Array
        (
            [0] => In Ground,Tile,Pool on Property
        )

    [possession] => Array
        (
            [0] => 45 Days or Less,At Closing
        )

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

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

    [property_type] => Array
        (
            [0] => single_family
        )

    [property_type_label] => Array
        (
            [0] => single_family
        )

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

    [rets_association_fee] => Array
        (
            [0] => 131
        )

    [rets_association_fee_total] => Array
        (
            [0] => 131
        )

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

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

    [rets_baths_total] => Array
        (
            [0] => 5.01
        )

    [rets_beds_total] => Array
        (
            [0] => 6
        )

    [rets_builder_name] => Array
        (
            [0] => Sapigao Construction Inc.
        )

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

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

    [rets_current_price] => Array
        (
            [0] => 1700000.00
        )

    [rets_dom] => Array
        (
            [0] => 63
        )

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

    [rets_elementary_school] => Array
        (
            [0] => Kaleiopuu
        )

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

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

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

    [rets_id] => Array
        (
            [0] => 16112089
        )

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

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

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

    [rets_list_agent_direct_work_phone] => Array
        (
            [0] => (808) 291-4049
        )

    [rets_list_agent_email] => Array
        (
            [0] => frank.sapigao@gmail.com
        )

    [rets_list_agent_full_name] => Array
        (
            [0] => Francisco B Sapigao Jr.
        )

    [rets_list_agent_mlsid] => Array
        (
            [0] => 12797
        )

    [rets_list_agent_mui] => Array
        (
            [0] => 3472927
        )

    [rets_list_office_mlsid] => Array
        (
            [0] => SAPI
        )

    [rets_list_office_mui] => Array
        (
            [0] => 15868574
        )

    [rets_list_office_name] => Array
        (
            [0] => Sapigao Investment Prop., LLC
        )

    [rets_list_office_phone] => Array
        (
            [0] => (808) 291-4049
        )

    [rets_list_price] => Array
        (
            [0] => 1750000.00
        )

    [rets_listing_contract_date] => Array
        (
            [0] => 2021-08-21
        )

    [rets_lot_size_area] => Array
        (
            [0] => 8926.00
        )

    [rets_matrix_modified_dt] => Array
        (
            [0] => 2021-12-01T10:35:55.007
        )

    [rets_matrix_unique_id] => Array
        (
            [0] => 16112089
        )

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

    [rets_mls_number] => Array
        (
            [0] => 202121297
        )

    [rets_neighbourhood] => Array
        (
            [0] => ROYAL KUNIA
        )

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

    [rets_original_entry_timestamp] => Array
        (
            [0] => 2021-08-21T21:14:39.643
        )

    [rets_original_list_price] => Array
        (
            [0] => 1750000.00
        )

    [rets_parcel_number] => Array
        (
            [0] => 1-9-4-137-126-0000
        )

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

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

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

    [rets_photo_count] => Array
        (
            [0] => 25
        )

    [rets_photo_modification_timestamp] => Array
        (
            [0] => 2021-08-21T21:14:39.643
        )

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

    [rets_price_change_timestamp] => Array
        (
            [0] => 2021-08-21T21:14:39.643
        )

    [rets_primary_key] => Array
        (
            [0] => 16112089
        )

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

    [rets_sqft_garage_carport] => Array
        (
            [0] => 528
        )

    [rets_sqft_lanai_open] => Array
        (
            [0] => 310
        )

    [rets_sqft_roofed_living] => Array
        (
            [0] => 4308
        )

    [rets_sqft_roofed_other] => Array
        (
            [0] => 58
        )

    [rets_sqft_total] => Array
        (
            [0] => 4676
        )

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

    [rets_status_change_timestamp] => Array
        (
            [0] => 2021-12-01T10:35:55.007
        )

    [rets_status_contractual_search_date] => Array
        (
            [0] => 2021-11-30
        )

    [rets_street_name] => Array
        (
            [0] => Puia
        )

    [rets_street_number] => Array
        (
            [0] => 94-1007
        )

    [rets_street_view_param] => Array
        (
            [0] => 1$21.399833$-158.021427$73.13$13.33$1.00$1UYZBPtSZroBpUfnzk6eGA
        )

    [rets_sub_agency_compensation] => Array
        (
            [0] => 2.5
        )

    [rets_tax_amount] => Array
        (
            [0] => 298.96
        )

    [rets_tax_assessed_value] => Array
        (
            [0] => 1125000.00
        )

    [rets_tax_assessed_value_improvements] => Array
        (
            [0] => 478400.00
        )

    [rets_tax_assessed_value_land] => Array
        (
            [0] => 646600.00
        )

    [rets_tax_excemption_owner_occupancy] => Array
        (
            [0] => 100000
        )

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

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

    [rets_thumbnail_url] => Array
        (
            [0] => https://cdn.rets.ci/marcusrealty-images/16112089/5cf778af34bca38804207a7475c0baed
        )

    [rets_tmk_area] => Array
        (
            [0] => 194
        )

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

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

    [rets_tmk_parcel] => Array
        (
            [0] => 126
        )

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

    [rets_tmk_zone] => Array
        (
            [0] => 9
        )

    [rets_tmkplat] => Array
        (
            [0] => 137
        )

    [rets_year_built] => Array
        (
            [0] => 1993
        )

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

    [security] => Array
        (
            [0] => Video
        )

    [setbacks] => Array
        (
            [0] => C&C
        )

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

    [status] => Array
        (
            [0] => Sold
        )

    [street_name] => Array
        (
            [0] => Puia
        )

    [street_number] => Array
        (
            [0] => 94-1007
        )

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

    [terms_accept] => Array
        (
            [0] => Cash,Conventional
        )

    [tmk] => Array
        (
            [0] => 1-9-4-137-126-0000
        )

    [topography] => Array
        (
            [0] => Irregular,Rim Lot
        )

    [view] => Array
        (
            [0] => City,Diamond Head,Garden,Golf Course,Mountain,Sunrise
        )

    [wpp::rets_pk] => Array
        (
            [0] => 16112089
        )

    [wpp_gpid] => Array
        (
            [0] => 202121297
        )

    [wpp_import_schedule_id] => Array
        (
            [0] => 1463343682
        )

    [wpp_import_time] => Array
        (
            [0] => 1638391028
        )

    [year_built] => Array
        (
            [0] => 1993
        )

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

    [zoning] => Array
        (
            [0] => 05 - R-5 Residential District
        )

    [new_attached_media] => Array
        (
            [0] => a:105:{i:0;i:20579082;i:1;i:20579083;i:2;i:20579084;i:3;i:20579085;i:4;i:20579086;i:5;i:20579087;i:6;i:20579088;i:7;i:20579089;i:8;i:20579090;i:9;i:20579091;i:10;i:20579092;i:11;i:20579093;i:12;i:20579094;i:13;i:20579095;i:14;i:20579096;i:15;i:20579097;i:16;i:20579098;i:17;i:20579099;i:18;i:20579100;i:19;i:20579101;i:20;i:20579102;i:21;i:20579182;i:22;i:20579183;i:23;i:20579184;i:24;i:20579185;i:25;i:20579186;i:26;i:20579187;i:27;i:20579188;i:28;i:20579189;i:29;i:20579190;i:30;i:20579191;i:31;i:20579192;i:32;i:20579193;i:33;i:20579194;i:34;i:20579195;i:35;i:20579196;i:36;i:20579197;i:37;i:20579198;i:38;i:20579199;i:39;i:20579200;i:40;i:20579201;i:41;i:20579202;i:42;i:20583387;i:43;i:20583388;i:44;i:20583389;i:45;i:20583390;i:46;i:20583391;i:47;i:20583392;i:48;i:20583393;i:49;i:20583394;i:50;i:20583395;i:51;i:20583396;i:52;i:20583397;i:53;i:20583398;i:54;i:20583399;i:55;i:20583400;i:56;i:20583401;i:57;i:20583402;i:58;i:20583403;i:59;i:20583404;i:60;i:20583405;i:61;i:20583406;i:62;i:20583407;i:63;i:21020985;i:64;i:21020986;i:65;i:21020987;i:66;i:21020988;i:67;i:21020989;i:68;i:21020990;i:69;i:21020991;i:70;i:21020992;i:71;i:21020993;i:72;i:21020994;i:73;i:21020995;i:74;i:21020996;i:75;i:21020997;i:76;i:21020998;i:77;i:21020999;i:78;i:21021000;i:79;i:21021001;i:80;i:21021002;i:81;i:21021003;i:82;i:21021004;i:83;i:21021005;i:84;i:21252533;i:85;i:21252534;i:86;i:21252535;i:87;i:21252536;i:88;i:21252537;i:89;i:21252538;i:90;i:21252539;i:91;i:21252540;i:92;i:21252541;i:93;i:21252542;i:94;i:21252543;i:95;i:21252544;i:96;i:21252545;i:97;i:21252546;i:98;i:21252547;i:99;i:21252548;i:100;i:21252549;i:101;i:21252550;i:102;i:21252551;i:103;i:21252552;i:104;i:21252553;}
        )

    [rets_private_remarks] => Array
        (
            [0] => Easy to show, but shown by apartment only.  Listed by owner.  Contact Frank Sapigao (RB) at (808) 291-4049 or Ciarra Sapigao (RA) at (808) 291-6118 to schedule a showing.  COVID-19 protocols apply.
        )

    [rets_public_remarks] => Array
        (
            [0] => Stunning 6Bed/5.5Bath that opens up into a luxurious 18-ft high ceiling living room that can be used as a karaoke room or in-home theater with ambient surround sound and roll down projector screen.  High-ceiling master bedroom with large walk-in closet with built-in shelves, double vanity, Whirlpool tub with in-line heater, steam shower, bidet, spacious balcony lanai and make-up counter.  Fantastic views of Diamond Head, Pearl Harbor, and Honolulu.  Outdoor pavers deck perfect for large gatherings and shaded by an abundance of fruit trees.  42 ft. long pool with full outdoor bath.  Key features include: Monier roof, aluminum windows, real stucco, marble floors, granite countertops, downstairs and upstairs bars, custom-built China cabinet and bookshelves, commercial refrigerator and Samsung refrigerator, stove top, double oven, through garage with front and rear doors, bay windows with seating, ample storage, security cameras, and baby grand piano.  Located on an 8,926 sq. ft. lot in a private cul-de-sac, the property borders the 14th hole overlooking the Kunia Golf Course.  This house was designed with hosting and entertaining in mind, but you'll have to see it for yourself!
        )

    [rets_pending_date] => Array
        (
            [0] => 2021-10-22
        )

    [rets_tax_annual_amount] => Array
        (
            [0] => 3587.52
        )

    [rets_close_date] => Array
        (
            [0] => 2021-11-30
        )

    [rets_close_price] => Array
        (
            [0] => 1700000.00
        )

    [rets_expiration_date] => Array
        (
            [0] => 2022-02-21
        )

    [rets_off_market_date] => Array
        (
            [0] => 2021-11-30
        )

    [rets_selling_agent_direct_work_phone] => Array
        (
            [0] => (808) 596-0695
        )

    [rets_selling_agent_email] => Array
        (
            [0] => malcolmshiroma@gmail.com
        )

    [rets_selling_agent_full_name] => Array
        (
            [0] => Malcolm S Shiroma
        )

    [rets_selling_agent_mlsid] => Array
        (
            [0] => 04974
        )

    [rets_selling_agent_mui] => Array
        (
            [0] => 8842649
        )

    [rets_selling_office_mlsid] => Array
        (
            [0] => NASH
        )

    [rets_selling_office_mui] => Array
        (
            [0] => 3484748
        )

    [rets_selling_office_name] => Array
        (
            [0] => Property Center, Inc.
        )

    [rets_selling_office_phone] => Array
        (
            [0] => (808) 596-0695
        )

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

)

  • Bedrooms: 6
  • Full Baths: 5
  • Half Baths: 1
  • Land Area (sf): 8,926
  • Living (sf): 4,676
  • Year Built: 1993

  • Property Condition: Excellent
  • Number of Parking Spaces: 5
  • Pool: In Ground,Tile,Pool on Property
  • Number of Stories: Two
  • View: City,Diamond Head,Garden,Golf Course,Mountain,Sunrise
  • Listing Office: Sapigao Investment Prop., LLC

  • Association Fees: $131
  • Land Tenure: FS - Fee Simple

  • Elementary School: Kaleiopuu
  • Middle School: Waipahu
  • High School: Waipahu

CONTACT US

Marcus Realty

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