1747 Piikea Street
Honolulu, HI 96818

Listing
Overview

Price: $950,000
Area: FOSTER VILLAGE
Status: Sold

This home is situated on the fringe of Foster Village. Because Piikea St is located at the rear of this neighborhood, you enjoy minimum flow of traffic. This charming and well maintained home sits on a lovely landscaped yard. Red ti leaves from Hana, bougainvillea, hibiscus, plumeria trees and a planter box with bright yellow lantana greets you in the driveway. This single level home features vaulted wood grain ceilings which expands the “feel” of the interior. Much of the interior has been freshly painted with the exterior painted less than 2 years ago. The wide driveway and carport easily accommodates four cars. One of the most attractive features of this property is it’s proximity to so much of Oahu, and yet still remain nestled in a “cul de sac” community. Come and see what Foster Village has to offer.

Listing by: Arquette Properties Inc

array(146) {
  ["assd_val_imprv"]=>
  array(1) {
    [0]=>
    string(8) "93200.00"
  }
  ["assd_val_land"]=>
  array(1) {
    [0]=>
    string(9) "779300.00"
  }
  ["assd_val_total"]=>
  array(1) {
    [0]=>
    string(9) "872500.00"
  }
  ["bedrooms"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["building_style"]=>
  array(1) {
    [0]=>
    string(20) "Detach Single Family"
  }
  ["city"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["county"]=>
  array(1) {
    [0]=>
    string(4) "Oahu"
  }
  ["disclosures"]=>
  array(1) {
    [0]=>
    string(71) "1031 Exchange,Property Disclosure Stmt,Relative of Licensee,See Remarks"
  }
  ["easements"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["floor_covering"]=>
  array(1) {
    [0]=>
    string(21) "Ceramic Tile,Laminate"
  }
  ["frontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["full_baths"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["furnished"]=>
  array(1) {
    [0]=>
    string(7) "Partial"
  }
  ["half_baths"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["home_exampt"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["land_area_sf"]=>
  array(1) {
    [0]=>
    string(7) "6497.00"
  }
  ["land_recorded"]=>
  array(1) {
    [0]=>
    string(14) "Regular System"
  }
  ["land_tenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["list_agent_email"]=>
  array(1) {
    [0]=>
    string(22) "vanaarquette@gmail.com"
  }
  ["list_agent_name"]=>
  array(1) {
    [0]=>
    string(19) "Vana Lehua Arquette"
  }
  ["list_agent_phone_number"]=>
  array(1) {
    [0]=>
    string(14) "(808) 732-9494"
  }
  ["list_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-07"
  }
  ["list_office_name"]=>
  array(1) {
    [0]=>
    string(23) "Arquette Properties Inc"
  }
  ["list_price"]=>
  array(1) {
    [0]=>
    string(9) "950000.00"
  }
  ["living_sf"]=>
  array(1) {
    [0]=>
    string(4) "1202"
  }
  ["location"]=>
  array(1) {
    [0]=>
    string(38) "1747 Piikea Street, Honolulu, HI 96818"
  }
  ["mls_"]=>
  array(1) {
    [0]=>
    string(9) "202123189"
  }
  ["neighborhood"]=>
  array(1) {
    [0]=>
    string(14) "FOSTER VILLAGE"
  }
  ["number_of_parking_spaces"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["number_of_stories"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["office_mls_id"]=>
  array(1) {
    [0]=>
    string(4) "ARQU"
  }
  ["parking_features"]=>
  array(1) {
    [0]=>
    string(21) "2 Car,Driveway,Street"
  }
  ["pool_"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["possession"]=>
  array(1) {
    [0]=>
    string(15) "45 Days or More"
  }
  ["postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96818"
  }
  ["property_condition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["property_type"]=>
  array(1) {
    [0]=>
    string(13) "single_family"
  }
  ["property_type_label"]=>
  array(1) {
    [0]=>
    string(13) "single_family"
  }
  ["region"]=>
  array(1) {
    [0]=>
    string(9) "PearlCity"
  }
  ["rets_baths_full"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["rets_baths_half"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_baths_total"]=>
  array(1) {
    [0]=>
    string(4) "2.00"
  }
  ["rets_beds_total"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["rets_city"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["rets_condo_property_regime_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_current_price"]=>
  array(1) {
    [0]=>
    string(10) "1020000.00"
  }
  ["rets_dom"]=>
  array(1) {
    [0]=>
    string(2) "10"
  }
  ["rets_dual_variable_compensation_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_foreclosure_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_fractional_ownership_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_id"]=>
  array(1) {
    [0]=>
    string(8) "16146006"
  }
  ["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) 732-9494"
  }
  ["rets_list_agent_email"]=>
  array(1) {
    [0]=>
    string(22) "vanaarquette@gmail.com"
  }
  ["rets_list_agent_full_name"]=>
  array(1) {
    [0]=>
    string(19) "Vana Lehua Arquette"
  }
  ["rets_list_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "08748"
  }
  ["rets_list_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "8842719"
  }
  ["rets_list_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "ARQU"
  }
  ["rets_list_office_mui"]=>
  array(1) {
    [0]=>
    string(7) "3484555"
  }
  ["rets_list_office_name"]=>
  array(1) {
    [0]=>
    string(23) "Arquette Properties Inc"
  }
  ["rets_list_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 732-9494"
  }
  ["rets_list_price"]=>
  array(1) {
    [0]=>
    string(9) "950000.00"
  }
  ["rets_listing_contract_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-07"
  }
  ["rets_lot_size_area"]=>
  array(1) {
    [0]=>
    string(7) "6497.00"
  }
  ["rets_matrix_modified_dt"]=>
  array(1) {
    [0]=>
    string(23) "2021-12-03T18:14:21.913"
  }
  ["rets_matrix_unique_id"]=>
  array(1) {
    [0]=>
    string(8) "16146006"
  }
  ["rets_mls_number"]=>
  array(1) {
    [0]=>
    string(9) "202123189"
  }
  ["rets_neighbourhood"]=>
  array(1) {
    [0]=>
    string(14) "FOSTER VILLAGE"
  }
  ["rets_new_development_construction_yn"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["rets_original_entry_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-07T18:28:08.917"
  }
  ["rets_original_list_price"]=>
  array(1) {
    [0]=>
    string(9) "950000.00"
  }
  ["rets_parcel_number"]=>
  array(1) {
    [0]=>
    string(18) "1-9-9-065-032-0000"
  }
  ["rets_parking_total"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["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) "19"
  }
  ["rets_photo_modification_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-07T18:28:08.917"
  }
  ["rets_postal_code"]=>
  array(1) {
    [0]=>
    string(5) "96818"
  }
  ["rets_price_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-09-07T18:28:08.917"
  }
  ["rets_primary_key"]=>
  array(1) {
    [0]=>
    string(8) "16146006"
  }
  ["rets_private_remarks"]=>
  array(1) {
    [0]=>
    string(539) "Private Showings Only...Please text or call Listor with your showing request. Kindly include Pre-Approval letter and VOF with Purchase Contract.  Thank You for wearing masks while viewing this property.  Consider using Angie Goya with First American Title-Pearlridge.             
Please Note:  No Permit for enclosed patio.  Lawn Sprinkler sold in "As Is" Condition.    Subject to 1031 Exchange and finding a replacement property.  Listing Agent is related to the Seller.  All offers to be submitted by 11 am, Monday, September 13, 2021."
  }
  ["rets_public_remarks"]=>
  array(1) {
    [0]=>
    string(822) "This home is situated on the fringe of Foster Village. Because Piikea St is located at the rear of this neighborhood, you enjoy minimum flow of traffic. This charming and well maintained home sits on a lovely landscaped yard.  Red ti leaves from Hana, bougainvillea, hibiscus, plumeria trees and a planter box with bright yellow lantana greets you in the driveway.  This single level home features vaulted wood grain ceilings which expands the "feel" of the interior.  Much of the interior has been freshly painted with the exterior painted less than 2 years ago. The wide driveway and carport easily accommodates four cars. One of the most attractive  features of this property is it's proximity to so much of Oahu, and yet still remain nestled in a "cul de sac" community.  Come and see what Foster Village has to offer."
  }
  ["rets_sqft_garage_carport"]=>
  array(1) {
    [0]=>
    string(3) "374"
  }
  ["rets_sqft_roofed_living"]=>
  array(1) {
    [0]=>
    string(4) "1202"
  }
  ["rets_sqft_total"]=>
  array(1) {
    [0]=>
    string(4) "1202"
  }
  ["rets_state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["rets_status_change_timestamp"]=>
  array(1) {
    [0]=>
    string(23) "2021-12-03T18:14:21.913"
  }
  ["rets_status_contractual_search_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-12-03"
  }
  ["rets_street_name"]=>
  array(1) {
    [0]=>
    string(6) "Piikea"
  }
  ["rets_street_number"]=>
  array(1) {
    [0]=>
    string(4) "1747"
  }
  ["rets_street_view_param"]=>
  array(1) {
    [0]=>
    string(62) "1$21.367089$-157.91489$58.42$13.33$1.00$2pvFzIpkE9UX2MjLPcF2PA"
  }
  ["rets_sub_agency_compensation"]=>
  array(1) {
    [0]=>
    string(3) "2.5"
  }
  ["rets_tax_amount"]=>
  array(1) {
    [0]=>
    string(6) "254.50"
  }
  ["rets_tax_assessed_value"]=>
  array(1) {
    [0]=>
    string(9) "872500.00"
  }
  ["rets_tax_assessed_value_improvements"]=>
  array(1) {
    [0]=>
    string(8) "93200.00"
  }
  ["rets_tax_assessed_value_land"]=>
  array(1) {
    [0]=>
    string(9) "779300.00"
  }
  ["rets_tax_excemption_owner_occupancy"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["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/16146006/9cf90da739813a2ad66bcc398abc1d62"
  }
  ["rets_tmk_area"]=>
  array(1) {
    [0]=>
    string(3) "199"
  }
  ["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(2) "32"
  }
  ["rets_tmk_section"]=>
  array(1) {
    [0]=>
    string(1) "9"
  }
  ["rets_tmk_zone"]=>
  array(1) {
    [0]=>
    string(1) "9"
  }
  ["rets_tmkplat"]=>
  array(1) {
    [0]=>
    string(2) "65"
  }
  ["rets_year_built"]=>
  array(1) {
    [0]=>
    string(4) "1966"
  }
  ["rets_year_remodeled"]=>
  array(1) {
    [0]=>
    string(4) "2012"
  }
  ["setbacks"]=>
  array(1) {
    [0]=>
    string(9) "Of Record"
  }
  ["state_or_province"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["street_name"]=>
  array(1) {
    [0]=>
    string(6) "Piikea"
  }
  ["street_number"]=>
  array(1) {
    [0]=>
    string(4) "1747"
  }
  ["street_suffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["terms_accept"]=>
  array(1) {
    [0]=>
    string(20) "Cash,Conventional,VA"
  }
  ["tmk"]=>
  array(1) {
    [0]=>
    string(18) "1-9-9-065-032-0000"
  }
  ["topography"]=>
  array(1) {
    [0]=>
    string(5) "Clear"
  }
  ["view"]=>
  array(1) {
    [0]=>
    string(6) "Garden"
  }
  ["wpp::rets_pk"]=>
  array(1) {
    [0]=>
    string(8) "16146006"
  }
  ["wpp_gpid"]=>
  array(1) {
    [0]=>
    string(9) "202123189"
  }
  ["wpp_import_schedule_id"]=>
  array(1) {
    [0]=>
    string(10) "1463343682"
  }
  ["wpp_import_time"]=>
  array(1) {
    [0]=>
    string(10) "1638591317"
  }
  ["year_built"]=>
  array(1) {
    [0]=>
    string(4) "1966"
  }
  ["year_remodeled_"]=>
  array(1) {
    [0]=>
    string(4) "2012"
  }
  ["zoning"]=>
  array(1) {
    [0]=>
    string(29) "05 - R-5 Residential District"
  }
  ["new_attached_media"]=>
  array(1) {
    [0]=>
    string(2159) "a:133:{i:0;i:20694000;i:1;i:20694001;i:2;i:20694002;i:3;i:20694003;i:4;i:20694004;i:5;i:20694005;i:6;i:20694006;i:7;i:20694007;i:8;i:20694008;i:9;i:20694009;i:10;i:20694010;i:11;i:20694011;i:12;i:20694012;i:13;i:20694013;i:14;i:20694014;i:15;i:20694015;i:16;i:20694016;i:17;i:20694017;i:18;i:20694018;i:19;i:20694046;i:20;i:20694047;i:21;i:20694048;i:22;i:20694049;i:23;i:20694050;i:24;i:20694051;i:25;i:20694052;i:26;i:20694053;i:27;i:20694054;i:28;i:20694055;i:29;i:20694056;i:30;i:20694057;i:31;i:20694058;i:32;i:20694059;i:33;i:20694060;i:34;i:20694061;i:35;i:20694062;i:36;i:20694063;i:37;i:20694064;i:38;i:20705756;i:39;i:20705757;i:40;i:20705758;i:41;i:20705759;i:42;i:20705760;i:43;i:20705761;i:44;i:20705762;i:45;i:20705763;i:46;i:20705764;i:47;i:20705765;i:48;i:20705766;i:49;i:20705767;i:50;i:20705768;i:51;i:20705769;i:52;i:20705770;i:53;i:20705771;i:54;i:20705772;i:55;i:20705773;i:56;i:20705774;i:57;i:20720469;i:58;i:20720470;i:59;i:20720471;i:60;i:20720472;i:61;i:20720473;i:62;i:20720474;i:63;i:20720475;i:64;i:20720476;i:65;i:20720477;i:66;i:20720478;i:67;i:20720479;i:68;i:20720480;i:69;i:20720481;i:70;i:20720482;i:71;i:20720483;i:72;i:20720484;i:73;i:20720485;i:74;i:20720486;i:75;i:20720487;i:76;i:20770337;i:77;i:20770338;i:78;i:20770339;i:79;i:20770340;i:80;i:20770341;i:81;i:20770342;i:82;i:20770343;i:83;i:20770344;i:84;i:20770345;i:85;i:20770346;i:86;i:20770347;i:87;i:20770348;i:88;i:20770349;i:89;i:20770350;i:90;i:20770351;i:91;i:20770352;i:92;i:20770353;i:93;i:20770354;i:94;i:20770355;i:95;i:21114562;i:96;i:21114563;i:97;i:21114564;i:98;i:21114565;i:99;i:21114566;i:100;i:21114567;i:101;i:21114568;i:102;i:21114569;i:103;i:21114570;i:104;i:21114571;i:105;i:21114572;i:106;i:21114573;i:107;i:21114574;i:108;i:21114575;i:109;i:21114576;i:110;i:21114577;i:111;i:21114578;i:112;i:21114579;i:113;i:21114580;i:114;i:21271828;i:115;i:21271829;i:116;i:21271830;i:117;i:21271831;i:118;i:21271832;i:119;i:21271833;i:120;i:21271834;i:121;i:21271835;i:122;i:21271836;i:123;i:21271837;i:124;i:21271838;i:125;i:21271839;i:126;i:21271840;i:127;i:21271841;i:128;i:21271842;i:129;i:21271843;i:130;i:21271844;i:131;i:21271845;i:132;i:21271846;}"
  }
  ["rets_active_continue_to_show_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-17"
  }
  ["rets_pending_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-09-17"
  }
  ["rets_tax_annual_amount"]=>
  array(1) {
    [0]=>
    string(7) "3054.00"
  }
  ["rets_close_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-12-03"
  }
  ["rets_close_price"]=>
  array(1) {
    [0]=>
    string(10) "1020000.00"
  }
  ["rets_expiration_date"]=>
  array(1) {
    [0]=>
    string(10) "2022-09-07"
  }
  ["rets_off_market_date"]=>
  array(1) {
    [0]=>
    string(10) "2021-12-03"
  }
  ["rets_selling_agent_direct_work_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 797-3344"
  }
  ["rets_selling_agent_email"]=>
  array(1) {
    [0]=>
    string(21) "tammylam808@gmail.com"
  }
  ["rets_selling_agent_full_name"]=>
  array(1) {
    [0]=>
    string(11) "Tammy T Lam"
  }
  ["rets_selling_agent_mlsid"]=>
  array(1) {
    [0]=>
    string(5) "45945"
  }
  ["rets_selling_agent_mui"]=>
  array(1) {
    [0]=>
    string(7) "9899087"
  }
  ["rets_selling_office_mlsid"]=>
  array(1) {
    [0]=>
    string(4) "LXHM"
  }
  ["rets_selling_office_mui"]=>
  array(1) {
    [0]=>
    string(8) "10320561"
  }
  ["rets_selling_office_name"]=>
  array(1) {
    [0]=>
    string(26) "Luxury Homes International"
  }
  ["rets_selling_office_phone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 797-3344"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "21271828"
  }
}
Array
(
    [assd_val_imprv] => Array
        (
            [0] => 93200.00
        )

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

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

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

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

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

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

    [disclosures] => Array
        (
            [0] => 1031 Exchange,Property Disclosure Stmt,Relative of Licensee,See Remarks
        )

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

    [floor_covering] => Array
        (
            [0] => Ceramic Tile,Laminate
        )

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

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

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

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

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

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

    [land_recorded] => Array
        (
            [0] => Regular System
        )

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

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

    [list_agent_name] => Array
        (
            [0] => Vana Lehua Arquette
        )

    [list_agent_phone_number] => Array
        (
            [0] => (808) 732-9494
        )

    [list_date] => Array
        (
            [0] => 2021-09-07
        )

    [list_office_name] => Array
        (
            [0] => Arquette Properties Inc
        )

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

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

    [location] => Array
        (
            [0] => 1747 Piikea Street, Honolulu, HI 96818
        )

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

    [neighborhood] => Array
        (
            [0] => FOSTER VILLAGE
        )

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

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

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

    [parking_features] => Array
        (
            [0] => 2 Car,Driveway,Street
        )

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

    [possession] => Array
        (
            [0] => 45 Days or More
        )

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

    [property_condition] => Array
        (
            [0] => Above Average
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [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) 732-9494
        )

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

    [rets_list_agent_full_name] => Array
        (
            [0] => Vana Lehua Arquette
        )

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

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

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

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

    [rets_list_office_name] => Array
        (
            [0] => Arquette Properties Inc
        )

    [rets_list_office_phone] => Array
        (
            [0] => (808) 732-9494
        )

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

    [rets_listing_contract_date] => Array
        (
            [0] => 2021-09-07
        )

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

    [rets_matrix_modified_dt] => Array
        (
            [0] => 2021-12-03T18:14:21.913
        )

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

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

    [rets_neighbourhood] => Array
        (
            [0] => FOSTER VILLAGE
        )

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

    [rets_original_entry_timestamp] => Array
        (
            [0] => 2021-09-07T18:28:08.917
        )

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

    [rets_parcel_number] => Array
        (
            [0] => 1-9-9-065-032-0000
        )

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

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

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

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

    [rets_photo_modification_timestamp] => Array
        (
            [0] => 2021-09-07T18:28:08.917
        )

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

    [rets_price_change_timestamp] => Array
        (
            [0] => 2021-09-07T18:28:08.917
        )

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

    [rets_private_remarks] => Array
        (
            [0] => Private Showings Only...Please text or call Listor with your showing request. Kindly include Pre-Approval letter and VOF with Purchase Contract.  Thank You for wearing masks while viewing this property.  Consider using Angie Goya with First American Title-Pearlridge.             
Please Note:  No Permit for enclosed patio.  Lawn Sprinkler sold in "As Is" Condition.    Subject to 1031 Exchange and finding a replacement property.  Listing Agent is related to the Seller.  All offers to be submitted by 11 am, Monday, September 13, 2021.
        )

    [rets_public_remarks] => Array
        (
            [0] => This home is situated on the fringe of Foster Village. Because Piikea St is located at the rear of this neighborhood, you enjoy minimum flow of traffic. This charming and well maintained home sits on a lovely landscaped yard.  Red ti leaves from Hana, bougainvillea, hibiscus, plumeria trees and a planter box with bright yellow lantana greets you in the driveway.  This single level home features vaulted wood grain ceilings which expands the "feel" of the interior.  Much of the interior has been freshly painted with the exterior painted less than 2 years ago. The wide driveway and carport easily accommodates four cars. One of the most attractive  features of this property is it's proximity to so much of Oahu, and yet still remain nestled in a "cul de sac" community.  Come and see what Foster Village has to offer.
        )

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

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

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

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

    [rets_status_change_timestamp] => Array
        (
            [0] => 2021-12-03T18:14:21.913
        )

    [rets_status_contractual_search_date] => Array
        (
            [0] => 2021-12-03
        )

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

    [rets_street_number] => Array
        (
            [0] => 1747
        )

    [rets_street_view_param] => Array
        (
            [0] => 1$21.367089$-157.91489$58.42$13.33$1.00$2pvFzIpkE9UX2MjLPcF2PA
        )

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

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

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

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

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

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

    [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/16146006/9cf90da739813a2ad66bcc398abc1d62
        )

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

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

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

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

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

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

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

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

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

    [setbacks] => Array
        (
            [0] => Of Record
        )

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

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

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

    [street_number] => Array
        (
            [0] => 1747
        )

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

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

    [tmk] => Array
        (
            [0] => 1-9-9-065-032-0000
        )

    [topography] => Array
        (
            [0] => Clear
        )

    [view] => Array
        (
            [0] => Garden
        )

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

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

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

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

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

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

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

    [new_attached_media] => Array
        (
            [0] => a:133:{i:0;i:20694000;i:1;i:20694001;i:2;i:20694002;i:3;i:20694003;i:4;i:20694004;i:5;i:20694005;i:6;i:20694006;i:7;i:20694007;i:8;i:20694008;i:9;i:20694009;i:10;i:20694010;i:11;i:20694011;i:12;i:20694012;i:13;i:20694013;i:14;i:20694014;i:15;i:20694015;i:16;i:20694016;i:17;i:20694017;i:18;i:20694018;i:19;i:20694046;i:20;i:20694047;i:21;i:20694048;i:22;i:20694049;i:23;i:20694050;i:24;i:20694051;i:25;i:20694052;i:26;i:20694053;i:27;i:20694054;i:28;i:20694055;i:29;i:20694056;i:30;i:20694057;i:31;i:20694058;i:32;i:20694059;i:33;i:20694060;i:34;i:20694061;i:35;i:20694062;i:36;i:20694063;i:37;i:20694064;i:38;i:20705756;i:39;i:20705757;i:40;i:20705758;i:41;i:20705759;i:42;i:20705760;i:43;i:20705761;i:44;i:20705762;i:45;i:20705763;i:46;i:20705764;i:47;i:20705765;i:48;i:20705766;i:49;i:20705767;i:50;i:20705768;i:51;i:20705769;i:52;i:20705770;i:53;i:20705771;i:54;i:20705772;i:55;i:20705773;i:56;i:20705774;i:57;i:20720469;i:58;i:20720470;i:59;i:20720471;i:60;i:20720472;i:61;i:20720473;i:62;i:20720474;i:63;i:20720475;i:64;i:20720476;i:65;i:20720477;i:66;i:20720478;i:67;i:20720479;i:68;i:20720480;i:69;i:20720481;i:70;i:20720482;i:71;i:20720483;i:72;i:20720484;i:73;i:20720485;i:74;i:20720486;i:75;i:20720487;i:76;i:20770337;i:77;i:20770338;i:78;i:20770339;i:79;i:20770340;i:80;i:20770341;i:81;i:20770342;i:82;i:20770343;i:83;i:20770344;i:84;i:20770345;i:85;i:20770346;i:86;i:20770347;i:87;i:20770348;i:88;i:20770349;i:89;i:20770350;i:90;i:20770351;i:91;i:20770352;i:92;i:20770353;i:93;i:20770354;i:94;i:20770355;i:95;i:21114562;i:96;i:21114563;i:97;i:21114564;i:98;i:21114565;i:99;i:21114566;i:100;i:21114567;i:101;i:21114568;i:102;i:21114569;i:103;i:21114570;i:104;i:21114571;i:105;i:21114572;i:106;i:21114573;i:107;i:21114574;i:108;i:21114575;i:109;i:21114576;i:110;i:21114577;i:111;i:21114578;i:112;i:21114579;i:113;i:21114580;i:114;i:21271828;i:115;i:21271829;i:116;i:21271830;i:117;i:21271831;i:118;i:21271832;i:119;i:21271833;i:120;i:21271834;i:121;i:21271835;i:122;i:21271836;i:123;i:21271837;i:124;i:21271838;i:125;i:21271839;i:126;i:21271840;i:127;i:21271841;i:128;i:21271842;i:129;i:21271843;i:130;i:21271844;i:131;i:21271845;i:132;i:21271846;}
        )

    [rets_active_continue_to_show_date] => Array
        (
            [0] => 2021-09-17
        )

    [rets_pending_date] => Array
        (
            [0] => 2021-09-17
        )

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

    [rets_close_date] => Array
        (
            [0] => 2021-12-03
        )

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

    [rets_expiration_date] => Array
        (
            [0] => 2022-09-07
        )

    [rets_off_market_date] => Array
        (
            [0] => 2021-12-03
        )

    [rets_selling_agent_direct_work_phone] => Array
        (
            [0] => (808) 797-3344
        )

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

    [rets_selling_agent_full_name] => Array
        (
            [0] => Tammy T Lam
        )

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

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

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

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

    [rets_selling_office_name] => Array
        (
            [0] => Luxury Homes International
        )

    [rets_selling_office_phone] => Array
        (
            [0] => (808) 797-3344
        )

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

)

  • Bedrooms: 3
  • Full Baths: 2
  • Land Area (sf): 6,497
  • Living (sf): 1,202
  • Year Built: 1966

  • Property Condition: Above Average
  • Number of Parking Spaces: 2
  • Pool: None
  • Number of Stories: One
  • View: Garden
  • Listing Office: Arquette Properties Inc

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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