Lumiaina St, Waipahu HI street index
1-399 400-940599 940600+
| Block | Buildings | Properties | Businesses | Residents |
|---|---|---|---|---|
| 1-399 | 92-94 | 268 | 225 | 162 |
| 400-940599 | 427-940510 | 62 | 1 | 64 |
1-399 Lumiaina St, Waipahu HI
Market Activities
May 2024 - present
Listed for sale
May 2024 - present
Listed for sale
May 2024 - present
Listed for sale
Dec 2023 - present
Listed for sale
Oct 2022 - present
Listed for sale
Mar 2021 - present
Listed for sale
Mar 2021 - Feb 2024
Sold
Oct 2022 - May 2023
Sold
Mar 2021 - May 2023
Sold
Jul 2022 - Apr 2023
Sold
Jan 2023 - Apr 2023
Sold
Mar 2021 - Mar 2023
Sold
May 2021 - Feb 2023
Sold
Jun 2022 - Feb 2023
Sold
Jan 2023 - Jan 2023
Sold
Nov 2022 - Dec 2022
Sold
Sep 2022 - Nov 2022
Sold
Jun 2022 - Jun 2022
Sold
Aug 2021 - Mar 2022
Sold
Jul 2021 - Mar 2022
Sold
Fire Incident History
12 Nov 2019
Building fires
Property Use:
Restaurant or cafeteria
Area of Origin:
Cooking area, kitchen
First Ignition:
Appliance housing or casing
Heat Source:
Heat from direct flame, convection currents
07 Sep 2019
Passenger vehicle fire
Property Use:
Vehicle parking area
Area of Origin:
Exterior, exposed surface
First Ignition:
Item First Ignited, Other
20 Aug 2018
Mobile property (vehicle) fire, other
Property Use:
Vehicle parking area
Area of Origin:
Engine area, running gear, wheel area
Incidents registered in Federal Emergency Management Agency
15 Dec 2015
Vehicle accident, general cleanup
Property Use:
Street or road in commercial area
09 Nov 2015
Gasoline or other flammable liquid spill
Property Use:
Street, other
22 Sep 2015
Cultivated trees or nursery stock fire
Property Use:
Vehicle parking area
Residents
Residence for Single Family
- Waikele Center
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| Bugle Boy | 808-***-**** | Categories: Mens Clothing & Furnishings - Retail | |
| Guy Matsumoto - State Farm Insurance Agent | 808-***-**** 808-***-**** | Categories: Auto Insurance, Homeowners' & Renters' Insurance, Insurance, Life Insurance, Property & Casualty Insurance Site: guymatsumoto.com | |
| Vitamin World, Inc | 808-***-**** | Industry: Ret Vitamins, Food, Health, Supplement Stores SIC: 5499 - Miscellaneous Food Stores Site: vitaminworld.com | |
| Jos*** | |||
| Eri*** | 808-***-**** |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| Restaurant Kunio | 808-***-**** | Categories: Foods - Carry Out |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| SEWFIRE SELENA | Industry: Making Of Wig/natural Hair And Sales Inactive: Mar 21, 2020 |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| KEOKI'S KOLLECTIONS | Industry: Craft Product Inactive: Aug 17, 1998 |
For Rent
$1,975
Sold
$545,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| AIKO'S GIFTS | Industry: Sales Inactive: Nov 20, 2015 | ||
| BRIAN DOS SANTOS L.AC., LMT | Industry: Acupuncture , Massage, Herbal Medicine Health Practitioner Inactive: Nov 30, 2013 | ||
| COLORFUL EATS LIMITED LIABILITY COMPANY | Type of Business: Domestic Limited Liability Company (LLC) | ||
| DPG INVESTMENT CORP | Type of Business: Domestic Profit Corporation | ||
| DVD SHOP HAWAII LLC | Industry: Inactive Type of Business: Domestic Limited Liability Company (LLC) |
For Sale
$420,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| BOMBSHEL PHOTOGRAPHY | Industry: Photography Inactive: Aug 6, 2018 | ||
| NATURALLY | Industry: Sale Of Herbal, Natural And Environmentally Conscious Products Inactive: Aug 7, 1996 | ||
| VIP IMPORTS LLC | Type of Business: Domestic Limited Liability Company (LLC) |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| MAESTAS MARKETING INC | Type of Business: Domestic Profit Corporation | ||
| Robert Smith | SIC: 6022 - State Commercial Banks | ||
| TSUNAMI GRAFIX LLC | 808-***-**** | Type of Business: Domestic Limited Liability Company (LLC) SIC: 6541 - Title Abstract Offices |
For Sale
$415,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| FERNROCKS LLC | Industry: Media Services Type of Business: Domestic Limited Liability Company (LLC) | ||
| JENNY ZERCHER CONSULTING | Industry: Administrative Management Consulting Services Inactive: Jun 30, 2015 |
Sold $540,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| ACZON'S FRESH PRODUCE | Industry: Farming Inactive: Sep 9, 1997 | ||
| STREET SOUND | Industry: Auto Stereo & Alarms Inactive: Nov 9, 1998 |
Sold
$430,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| GLK ENTERPRISES LLC | Type of Business: Domestic Limited Liability Company (LLC) |
For Sale
$525,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| EGUCHI MIDRO HOLDINGS, LLC | Type of Business: Domestic Limited Liability Company (LLC) | ||
| H2 PHOTOWORKS | Industry: Photography And Graphics Inactive: Feb 1, 2013 | ||
| LAKEVIEW SERVICES | Industry: Maintenance And Repair, Handyman Jobs Inactive: Jul 4, 2012 | ||
| PARKDALE REALTY INVESTMENTS, LLC | Type of Business: Domestic Limited Liability Company (LLC) |
Sold
$455,000
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| BLO-CHECKPOINT LLC | Type of Business: Domestic Limited Liability Company (LLC) | ||
| LegalShield | 808-***-**** |
For Sale
$449,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| Michael Ishihara | Industry: Nonclassifiable Establishments | ||
| UKANA MAKAMAE | Industry: Freight Forwarding Inactive: Oct 15, 2019 |
Sold
$550,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| CONSTRUCTION ENGINEERS, INC | Type of Business: Domestic Profit Corporation |
Sold $545,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| AIKANE FUN JUMPS, LLC | Type of Business: Domestic Limited Liability Company (LLC) |
Sold $510,000
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| DUNNUCK ENTERPRISES INCORPORATED | Industry: Inactive Type of Business: Domestic Profit Corporation | ||
| J&J Homes, Inc | 808-***-**** | Industry: Real Estate Agent/Manager |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| PASSION PARTIES BY IESHA | Industry: Retail Sale Of Passion Parties Products As An In-Home Independent Consultant Inactive: Jul 2, 2013 |
Sold $555,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| INNOVENTIONS | Industry: Writing, Book Selling, Consulting Inactive: Apr 3, 2018 |
- 2 beds
- 1 bath
- Lot: 657 sqft
Sold
$490,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| A CRAFT ACT | Industry: Selling Crafts At Craft Fairs Inactive: Jun 12, 2005 |
Sold
$445,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| BEAUTY IN BLOOM | Industry: Makeup Application Inactive: May 22, 2013 | ||
| C. PERARO CONSULTING, LLC | Industry: Business Consulting Services Type of Business: Domestic Limited Liability Company (LLC) | ||
| FANTASTIC FINISHES PROFESSIONAL SERVICES LLC | Type of Business: Domestic Limited Liability Company (LLC) |
Sold
$420,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| DUX ARCHITECTS LLC | Industry: Architect Type of Business: Domestic Limited Liability Company (LLC) | ||
| KNC SPORTING GOODS, INC | Industry: Retail/wholesale Sporting Goods Type of Business: Domestic Profit Corporation |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| HOMEGROWN CLOTHING COMPANY | Industry: Apparel (Retailing) Inactive: Apr 16, 2012 | ||
| PACQUIAO BRAND | Industry: Wholesale / Retail Of Apparel Inactive: Mar 22, 2016 | ||
| SKEMATIX | Industry: Apparel Retail / Wholesale Inactive: Mar 24, 2014 |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| NRG MEDIACOM LLC | Type of Business: Domestic Limited Liability Company (LLC) | ||
| WHITEGINGER PRESS LLC | Type of Business: Domestic Limited Liability Company (LLC) |
For Sale
$550,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| ADTRIX INTERNET GROUP, LLC | Type of Business: Domestic Limited Liability Company (LLC) | ||
| DOCUMENT DISTRIBUTION SOLUTIONS HAWAII LLC | Type of Business: Domestic Limited Liability Company (LLC) |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| SNM BUILDERS, LLC | 808-***-**** | Categories: Construction & Remodeling Services Industry: General Contracting, Doors, Remodeling, Bathroom & Kitchen Remodeling, New Single-Family Housing Construction (except Operative Bui Type of Business: Domestic Limited Liability Company (LLC) SIC: 1521 - General Contractors-Single-Family Houses |
For Sale
$465,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| ANALOG BAND | Type of Business: General Domestic Partnership |
For Sale
$550,000
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| THE DATABASE CENTER | 808-***-**** | Categories: Information Technology Services Industry: Computer Software Services, Business Services Whol Computers/Peripherals, Computer Systems Design Computer Programming Svc Ret Computers/Software Data Processing School Computer Re... Inactive: May 24, 2015 Site: tdc-hawaii.com | |
| SOULLUSIONS ENTERTAINMENT | Industry: Event Promotion Services Inactive: Oct 16, 2001 | ||
| THE SUNDAY CLUB | Industry: Distributor / Vendor Inactive: Feb 27, 2006 |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| C. INO DESIGN | Industry: Professional Graphic Design Services Inactive: Nov 16, 2013 |
- 2 beds
- 2 baths
- Lot: 830 sqft
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| COLLEGEAID -- THE SCHOLARSHIP SOURCE | Industry: A Scholarship Finding/matching Service Inactive: Nov 28, 1995 | ||
| THE MARKETING MAIDS | Industry: Personal Shopping And Errand-Running Service Inactive: Dec 4, 1995 |
Sold $509,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| JASON P. TABA, LLC | Type of Business: Domestic Limited Liability Company (LLC) |
Sold
$545,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| KNT TANAKAYA CORPORATION | Industry: Retail - Ice Cream Type of Business: Domestic Profit Corporation |
Sold
$475,000
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| COLUMBIA INN | Industry: Restaurant And Bar Inactive: Jan 7, 2008 | ||
| COLUMBIA INN - KAIMUKI | Industry: Restaurant Inactive: Aug 5, 2009 | ||
| Kai Construction Hawaii Inc | 808-***-**** | Categories: Building & Home Construction Industry: General Contractor | |
| RJ'S SERVICES | Industry: Cleaning Services, Silk Screening, Luggage Tags Inactive: Jan 8, 2007 |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| CONSULTING SERVICES HAWAII | Industry: Small Business Consulting Inactive: Mar 31, 2016 |
Sold $625,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| LEO SINGH LLC | Type of Business: Domestic Limited Liability Company (LLC) |
Sold $537,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| SCRIPTS AT HOME, LLC | Type of Business: Domestic Limited Liability Company (LLC) SIC: 1521 - General Contractors-Single-Family Houses |
Sold
$530,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| Goodfriend Co Inc | Industry: Eating Place | ||
| GOODFRIEND CHINESE KITCHEN | Industry: Retailing Fast Food Inactive: Mar 23, 2016 | ||
| HELMUT KAE | Industry: Referee Services Inactive: Feb 22, 2018 | ||
| SBJ INVESTMENT CORPORATION | Industry: To Engage In And Carry On Any Business Which May Be Lawfully Undertaken Or Carried On By A Corporation Organized Under The Laws Of The State Of Hawaii Type of Business: Domestic Profit Corporation | ||
| SMALLKINE CREATIONS | Industry: Manufacture And Retail Of Jewelry Inactive: Jul 8, 2017 |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| NETSERVICING | Industry: Computer Sales And Service Inactive: Sep 29, 2013 |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| INES USON INC | Type of Business: Domestic Profit Corporation |
Sold
$455,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| CARMEL FOUNDATION | Type of Business: Domestic Nonprofit Corporation | ||
| SPORTING HAWAII LLC | Type of Business: Domestic Limited Liability Company (LLC) |
- 2 beds
- 2 baths
- Lot: 835 sqft
For Sale
$525,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| H&L Solutions LLC | Industry: Landscape Contractor | ||
| THE TRAVELLING STORYTELLERS | Industry: Theatrical Performance Inactive: Jul 18, 2012 |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| TUTTO BENE CAFE | Industry: CAFE Inactive: Jun 6, 2013 |
- 3 beds
- 2 baths
- Lot: 4,704 sqft
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| HOBBIES HAWAII DISTRIBUTORS | Industry: Wholesale Distribution Trading Cards Inactive: Aug 31, 1996 |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| OFFICE MAX | 808-***-**** 808-***-**** | Industry: Copies, Office Supplies & Stationery Stores SIC: 5943 - Stationery Stores Site: officemax.com officemaxsolutions.com |
- 3 beds
- 3 baths
- Lot: 1,407 sqft
For Sale
$935,000
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| TRICAM MEDIA | Industry: Web Design Inactive: Nov 13, 2012 |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| Hawaii Warehouse Company LLC | Industry: Whol Hardware Whol Electrical Equip |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| Barney's New York | 808-***-**** 808-***-**** | Categories: General Merchandise - Retail Industry: Men's Clothing Stores SIC: 5311 - Department Stores SIC6: 561100 - Men's and boys' clothing stores Site: barneys.com | |
| Big Dog Sportswear | 808-***-**** | Industry: Other Clothing Stores SIC: 5699 - Miscellaneous Apparel and Accessory Stores | |
| Blue Hawaii Surf LLC | 808-***-**** 808-***-**** | Industry: Ret Sporting Goods/Bicycles, Fitness Equipment, Sporting Goods Stores SIC: 5941 - Sporting Goods Stores and Bicycle Shops Site: bluehawaiisurf.com | |
| Calvin Klein | 808-***-**** | Industry: Store Retailers Not Specified Elsewhere SIC: 5999 - Miscellaneous Retail Stores, Not Elsewhere Classified Site: pvh.com | |
| CAREER IMAGE | 808-***-**** 808-***-**** | Industry: Women's Clothing, Employment Placement Agencies and Executive Search Services, Women's Clothing Stores Inactive: Mar 17, 2000 SIC: 7361 - Employment Agencies Site: papaya.com |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| Carter's For Kids | 808-***-**** | Industry: Children's & Infants' Clothing Stores SIC: 5641 - Children's and Infants' Wear Stores Site: carters.com | |
| Carter's Retail, Inc | 808-***-**** | Categories: Childrens & Infants Wear - Retail Site: carters.com | |
| Destination Maternity Corporation | 808-***-**** | Industry: Ret Women's Clothing | |
| Factory Brand Shoes | 808-***-**** | Industry: Shoe Stores SIC: 5661 - Shoe Stores Site: famousfootwear.com | |
| Famous Footwear | 808-***-**** | Industry: Men's Clothing Stores SIC: 5611 - Men's and Boys' Clothing and Accessory Stores |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| 2b Bebe | 808-***-**** | Categories: Clothing - Retail Site: 2bstores.com | |
| Adidas North America, Inc | Industry: Ret Shoes | ||
| Bebe | 808-***-**** 808-***-**** | Categories: Clothing Accessories Retail, Women's Clothing Industry: Family Clothing Stores SIC: 5651 - Family Clothing Stores Site: bebe.com | |
| Coach Factory Outlet | 212-***-**** | Categories: Retail Stores Site: coach.com | |
| Coach Factory Store the | 808-***-**** | Industry: Footwear Merchant Wholesalers SIC: 5139 - Footwear |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| Chilis Grill and Bar | 808-***-**** | Industry: Full-Service Restaurants SIC: 5812 - Eating Places | |
| Chili's Grill & Bar | 808-***-**** 808-***-**** | Specialties: Baby Back Ribs, Big MouthB. Bites, Craft Burgers, CrispersB., Fresh Mex Bowl, House-made Garlic Dill Pickles, Monterey ChickenB., OldtimerB., OldtimerB. With Cheese, Pepper Pals, Q... Categories: American Restaurants, Bar & Grill Restaurants, Family Restaurants, Restaurants, Southwestern Restaurants Industry: Full-Service Restaurants SIC: 5812 - Eating Places Site: chilis.com |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| Banana Republic, LLC | 808-***-**** | Industry: Ret Family Clothing, Family Clothing Stores SIC: 5651 - Family Clothing Stores Site: bananarepublic.com | |
| BAS & Co | 808-***-**** | Industry: Footwear Merchant Wholesalers SIC: 5139 - Footwear | |
| GH Bass & Co | 808-***-**** | Industry: Footwear Merchant Wholesalers SIC: 5139 - Footwear | |
| Bcbg Max Azria Group, Inc | 808-***-**** | Industry: Ret Women's Clothing, Women's and Girls' Cut and Sew Dress Manufacturing, Women's Clothing Stores SIC: 2335 - Women's, Misses', and Juniors' Dresses | |
| Samsonite Co Store | 808-***-**** | Industry: Luggage and Leather Goods Stores SIC: 5948 - Luggage and Leather Goods Stores |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| Baskin-Robbins | 808-***-**** | Industry: Snack & Nonalcoholic Beverage Bars SIC: 5812 - Eating Places Site: baskinrobbins.com | |
| Baskin-Robbins Ice Cream | Industry: Ice Crm Stdsdairy Br | ||
| Century 21 All Islands | 808-***-**** 808-***-**** | Categories: General Real Estate, Homes & Residential Real Estate, Real Estate Agencies & Brokerage, Real Estate Agents, Real Estate Commercial & Industrial Industry: Real Estate Agents SIC: 6531 - Real Estate Agents and Managers Site: hawaiimoves.com | |
| CRISPIES, INC | Industry: To Engage In The Business Of Retail Sales Type of Business: Domestic Profit Corporation | ||
| Genki Sushi Hawaii | 808-***-**** 808-***-**** 808-***-**** | Specialties: Fundraisers Categories: Hawaiian Restaurants, Restaurants Industry: Full-Service Restaurants SIC: 5812 - Eating Places Site: genkisushi.com |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| Oasis Cafe | 808-***-**** | Industry: Eating Place, Full-Service Restaurants SIC: 5812 - Eating Places | |
| Off 5th Ave | 808-***-**** | Industry: Department Stores SIC: 5311 - Department Stores | |
| Saks and Co | 808-***-**** | Industry: Department Stores SIC: 5311 - Department Stores | |
| Saks Fifth Avenue | 808-***-**** 808-***-**** | Industry: Department Stores, Except Discount SIC: 5311 - Department Stores Site: saksfifthavenue.com | |
| Saks Fifth Avenue Enterprises | 808-***-**** 808-***-**** | Categories: General Merchandise - Retail, Womens Apparel - Retail, Mens Clothing & Furnishings - Retail |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| Kazi Foods Corp. of Hawaii | 808-***-**** | Industry: Fast-Food Rest Chain |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| LOWE'S | 808-***-**** | Industry: Home Improvement Stores | |
| Lowe's HIW, Inc | 808-***-**** 808-***-**** | Categories: Home Improvements, Hardware - Retail, Building Materials Site: lowes.com |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| SPORTS AUTHORITY | 808-***-**** 808-***-**** | Industry: Fitness Equipment, Sporting Goods Stores SIC: 5941 - Sporting Goods Stores and Bicycle Shops Site: sportsauthority.com |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| Old Navy | 808-***-**** 808-***-**** | Categories: General Merchandise - Retail Industry: Department Stores, Family Clothing Stores SIC: 5311 - Department Stores Site: oldnavy.com |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| Waikele Branch | 808-***-**** | Industry: Commercial Banking SIC: 6022 - State Commercial Banks |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| Borders Inc | 808-***-**** | Industry: Prerecorded Tape, Compact Disc, and Record Stores SIC: 5735 - Record and Prerecorded Tape Stores | |
| Borders Books & Music | 808-***-**** 808-***-**** | Industry: Book Stores SIC: 5942 - Book Stores Site: borders.com | |
| Borders Group, Inc. | 808-***-**** | Industry: Prerecorded Tape, Compact Disc, and Record Stores SIC: 5735 - Record and Prerecorded Tape Stores | |
| Brooks Brothers Group, Inc | 808-***-**** | Industry: Ret Men's/Boy's Clothing, Family Clothing Stores SIC: 5651 - Family Clothing Stores Site: brooksbrothers.com | |
| Gamestop, Inc | 808-***-**** 808-***-**** | Categories: Compact Discs, Tapes, Records - Wholesale & Manufacturing Industry: Gift Shops, Hobby, Toy, & Game Stores SIC: 5945 - Hobby, Toy, and Game Shops Site: gamestop.com |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| GOODNEWS COMMITTEE | Industry: Raise Funds For Charities Inactive: Jul 15, 2009 | ||
| KMART PORTRAIT STUDIO | 808-***-**** | Industry: Photographers | |
| Little Caesars | 808-***-**** | Industry: Department Stores SIC: 5311 - Department Stores | |
| Olan Mills | 808-***-**** | Industry: Department Stores SIC: 5311 - Department Stores | |
| OLAN MILLS PORTRAIT STUDIO | 808-***-**** | Industry: Photographers |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| American Assets, Inc | 808-***-**** | Industry: Nonresidential Building Operator SIC6: 651202 - Office Buildings & Parks | |
| Waikele Center Lp | 808-***-**** | Industry: Lessors of Nonresidential Buildings SIC: 6512 - Operators of Nonresidential Buildings Site: waikelecenter.com | |
| DRS. KUWABARA, ISHIHARA, ISHIMOTO & ARAKAKI, OPTOMETRISTS, INC | Industry: To Own, Manage, Maintain, Conduct, Operate And Carry On The Practice Of Optometry For Gain; (*see Amendment Dated 7/22/2002) Type of Business: Domestic Professional Corporation | ||
| Eye Care Associates of Hawaii | 808-***-**** 808-***-**** | Categories: Optometrists, Contact Lenses Site: visionsource-ecahawaii.com | |
| James Okamoto MD | 808-***-**** | Categories: Family & General Practice Physicians & Surgeons Industry: Family Doctor |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| Officemax North America Inc | 808-***-**** | Industry: Office Supplies and Stationery Stores SIC: 5943 - Stationery Stores |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| INSPIRE INTERNATIONAL | Industry: To Fulfill The Great Commission And Great Commandment By Proclaiming The Good News Of Jesus Christ; To Establish And Nurture A Worshipping Community Of Fully Devoted Followers Of J... Type of Business: Domestic Nonprofit Corporation | ||
| SEND HOPE INTERNATIONAL | Industry: To Promote And Foster Christianity In Hawaii, Throughout The Pacific Rim, And Elsewhere; Type of Business: Domestic Nonprofit Corporation |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| Ashley Furniture Homestore | 808-***-**** | Categories: Furniture Stores Industry: Furniture Sales Site: ashleyfurniture.com |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| Bank of Hawaii | 808-***-**** | Industry: New Car Dealers SIC: 5511 - Motor Vehicle Dealers (New and Used) |
Who has lived here
| Resident | Phone Number | Additional info | |
|---|---|---|---|
| JOE'S APPLIANCE SERVICE, INC | Industry: Sale & Service Of All Major Household Appliances Including, But Not Limited To, Laundry, Dishwashers, Ranges, Refrigerators, Water Heaters Type of Business: Domestic Profit Corporation | ||
| JOE'S APPLIANCE SVC | 808-***-**** | Industry: Appliance Repair |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| DARREN TAKEMOTO PAINTING CO | Industry: General Painting And Decorating Contractor, Commercial & Residential Painting Contractor, Residential And Commercial Painting Contractor Inactive: Feb 13, 1998 |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| GARY'S ROOFING AND REPAIR | Industry: Roof Repair Inactive: Aug 10, 1993 | ||
| MERZ ROOFING | Industry: Roofing Company Inactive: Apr 22, 1991 |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| PAD THAI | Industry: Operate Fast Food Restaurant Inactive: Apr 24, 2017 | ||
| QUICK THAI | Type of Business: General Domestic Partnership | ||
| SPICY HOUSE | Industry: Full Service Restaurant Type of Business: General Domestic Partnership |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| COOLS IN CATERING, LLP | Type of Business: Domestic Limited Liability Partnership | ||
| JEM STAR CARGO LLC | Type of Business: Domestic Limited Liability Company (LLC) Inactive: Oct 28, 2013 | ||
| JEM STAR CARGO & CATERING LLC | Type of Business: Domestic Limited Liability Company (LLC) | ||
| JEM STAR CATERING LLP | Type of Business: General Domestic Partnership |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| FINAL TOUCHES CLEANING SERVICE, INC | Industry: Cleaning Contractor Type of Business: Domestic Profit Corporation |
Who has lived here
| Resident | Additional info | ||
|---|---|---|---|
| EDEN LEIS ADULT RESIDENTIAL & EXPANDED CARE HOME | Industry: CARE HOME Type of Business: Domestic Limited Liability Company (LLC) Inactive: Mar 2, 2013 |