Search All A & M Consolidated (Middle School) Real Estate

Our website features the best A & M Consolidated (Middle School) real estate search for homes, condos, land and foreclosure properties available. It is the only site you will ever need! It is easy-to-use and updated by the official Realtor®’s database every 15 minutes.

You can save searches, and get daily email alerts of new listings, price changes, sold data, and market reports. Our Interactive Map Search allows you to view properties on a map or refine your search by drawing the boundaries around the area you desire.

Curious about what’s happening in your neighborhood? You can create a custom market report to see what’s active, under contract, and sold in your neighborhood!

Considering selling or refinancing your home? Get an INSTANT property valuation now!

Hot A & M Consolidated (Middle School) Properties

$105,000

1 Beds ⋅ 1 Baths ⋅ 202615644 MLS ⋅ LH - Leasehold Tenure ⋅ Tradewinds Hotel Inc BLDG.

Quiet and well-maintained cooperative 1-bedroom unit on the 3rd floor of the Tradewinds Hotel. Close to shopping, dining, and commercial conveniences. Maintenance fee includes electricity, Lease Fee includes Property Tax.Suitable for investors or owner-occupants.

1720 Ala Moana Boulevard Unit 304A, Honolulu

Listing courtesy of Starts International HI, Inc..

$279,000

1 Beds ⋅ 1 Baths ⋅ 202614961 MLS ⋅ FS - Fee Simple Tenure ⋅ Westview Plaza BLDG.

Landlord's Nightmare! Stop renting and buy your first home with no buy-back, equity sharing or occupancy requirements! Sensible one bedroom unit with lanai and covered parking! Ultra convenient residential neighborhood on Ward Ave is close to everything! A very smart start!

1516 Ward Avenue Unit 701, Honolulu

Listing courtesy of One Realty, Incorporated.

$700,000

3 Beds ⋅ 2 Baths ⋅ 202615327 MLS ⋅ FS - Fee Simple Tenure ⋅ Village On The Green 2a BLDG.

Welcome to Village on the Green in Waikele, where everyday convenience meets a relaxed island lifestyle. This rare three-bedroom, two-bath end-unit townhome offers over 1,000 square feet of comfortable living, a modernized kitchen, refreshed bathrooms, and a spacious lanai. With fresh updates, two assigned parking stalls. Just minutes from Waikele shopping, dining, parks, and golf. Parking Stall 246 and 247.

94-686 Lumiauau Street Unit UU204, Waipahu

Listing courtesy of Real Broker.

$149,000

1 Baths ⋅ 732619 MLS ⋅ ['Fee Simple'] Tenure

Brand new construction meets independent off grid living in this turnkey tiny home in Hawaiian Acres on Hawaiʻi Island. Set among native ʻōhiʻa, the property is bordered by undeveloped lots on three sides, creating a natural buffer from neighbors. The newly built main structure uses structurally insulated panels (SIP) for strong thermal performance, helping the interior stay cooler during the day and warmer at night. Insulated double-pane tinted windows include screens, while lockable metal frame sliding glass doors connect the interior to a 200 sq. ft. deck. The property offers 728 sq. ft. of roof, important to the rainwater collection system. Inside, the home interior includes a kitchen with granite countertop, two-burner propane stove, refrigerator, cabinets, and storage. The full bathroom features a shower, toilet, sink, and built-in shelving. A 48V solar system supplies power for the home and its utilities. The secure utility room houses the solar equipment, 12V water pump, pressure tank, and propane regulator. An on-demand propane water heater provides hot water. Roof gutters and plumbing direct rainwater to a hollow tile catchment tank, creating an independent water system without reliance on municipal water service. The solid catchment setup complements the home's off grid systems and makes practical use of Hawaiʻi Island rainfall. The front of the property is fenced with a gate for controlled access from the road. A driveway leads into the property, with additional outdoor space with room for gardening. With brand new construction, solar power, hollow tile rainwater catchment, plumbing, electrical outlets, lighting, appliances, and essential systems already in place, this Hawaiian Acres tiny home offers a complete off grid setup for daily living on Hawaiʻi Island.

16-788 Road F (Ale), KURTISTOWN

Listing courtesy of Aloha Sotheby's Intl Realty - Hawai'i.

$529,000

2 Beds ⋅ 2 Baths ⋅ 202614910 MLS ⋅ FS - Fee Simple Tenure ⋅ Cliffside Village At Waipio BLDG.

Welcome home to this rarely available, corner-end residence of Cliffside Villages at Waipio! Offering the ideal blend of space, privacy, breathtaking views, and modern updates, this immaculate 2-bedroom, 2-bath home with 2 conveniently located parking stalls is truly a standout. Step inside and immediately appreciate the fresh, inviting feel created by new carpet, fresh paint, and new appliances. The renovated kitchen and updated bathrooms add a stylish touch, while abundant natural light and cool breezes flow throughout the home. The spacious primary suite provides a peaceful retreat with two closets, an en-suite bathroom with shower, and a convenient in-unit washer and dryer. Step outside onto your large, private lanai balcony to take in mountain, city, and ocean views. Enjoy the added convenience of two side-by-side parking stalls located close to the residence, plus a dedicated car wash area. Ideally positioned in the heart of Central Oahu, just minutes from freeway access, Costco, Foodland, shopping, dining, parks, military bases, and more. Move-in ready, thoughtfully upgraded, and perfectly positioned, this is the home you've been waiting for! OPEN HOUSE SUNDAY, 8/16, 2-5PM

94-100 Huki Place Unit 201, Waipahu

Listing courtesy of Coldwell Banker Realty.

$1,050,000

2 Beds ⋅ 2 Baths ⋅ 732838 MLS ⋅ ['Fee Simple'] Tenure ⋅ Shores At Waikoloa Beach Resort BLDG.

Best-Priced 2-Bedroom in the Community | Ground Floor | Move-In Ready Villa #102 offers an exceptional opportunity to own in The Shores at Waikoloa Beach Resort. Currently the best-priced 2-bedroom in the community, this ground-floor villa combines value, comfort, privacy, and a peaceful connection to nature. Tucked into a quiet setting surrounded by lush tropical landscaping, the villa offers a grounding sense of calm from the moment you arrive. A separate front pathway creates a more private entrance, while the ideally located parking space makes coming and going especially convenient. Inside, the open and airy 2-bedroom, 2.5-bath layout flows seamlessly from the living and dining areas to a generous private lanai. With no stairs or elevators, ground-floor living makes it easy to step directly outside and enjoy the tropical surroundings. Both bedrooms function as private suites, offering excellent separation for owners and guests. Thoughtful comfort upgrades include an organic Avocado mattress, an organic latex king mattress, and bidets. The villa is already operating as an active vacation rental and is offered move-in ready, creating an attractive opportunity for an investor, second-home buyer, or full-time resident. The gated Shores community features a pool, spa, tennis courts, fitness center, and beautifully landscaped grounds. ʻAnaehoʻomalu Bay, Kings’ Shops, Queens’ Marketplace, golf, dining, and the best of Waikoloa Beach Resort are all just minutes away. With its quiet ground-floor setting, natural surroundings, private pathway, excellent parking location, and compelling price point, Villa #102 delivers an ideal combination of location, lifestyle, comfort, and value.

69-1035 Keana Pl Unit 102, WAIKOLOA

Listing courtesy of Hawaii Development Group.

$1,300,000

2 Beds ⋅ 3 Baths ⋅ 732836 MLS ⋅ ['Fee Simple'] Tenure ⋅ Shores At Waikoloa Beach Resort BLDG.

Quiet Ground-Floor Villa with Ocean Views, Grand Floor Plan & Exceptional Resort Value Villa #5 at The Shores at Waikoloa Beach Resort offers a rare combination of space, privacy, ocean views, and an exceptional location within the community. Set in a quiet position beyond the other villas, this ground-floor residence feels private and peaceful while remaining remarkably close to the ocean. Ocean views can be enjoyed from every room, while the west-facing orientation captures beautiful Hawaiʻi sunsets. At approximately 1,484 square feet, this grand floor plan offers generous indoor-outdoor living. The open-concept interior is filled with natural light and features a distinctive tiled garden atrium. Both bedrooms are designed as private suites with direct access to the expansive lanai, making the layout ideal for full-time living, a resort retreat, or vacation-rental use. The oversized lanai features upgraded tile and provides an inviting space for morning coffee, sunset evenings, and relaxed island living. Thoughtful furnishings include zero-gravity recliners in the living room and organic latex king-size mattresses for added comfort. The villa is offered fully furnished and is currently operating as a vacation rental. Multiple parking spaces, including a covered carport, add convenience. The property is also listed with ThirdHome, a luxury home-exchange network that may provide qualifying owners access to luxury homes and vacation experiences around the world. Residents of The Shores enjoy a gated setting with a pool, spa, tennis courts, fitness center, and landscaped grounds. ʻAnaehoʻomalu Bay, Kings’ Shops, Queens’ Marketplace, golf, dining, and resort amenities are all nearby. For buyers seeking a quiet ground-floor residence with ocean views from every room, generous living space, proximity to the coastline, and incredible value, Villa #5 stands out as one of The Shores’ most compelling opportunities.

69-1035 Keana Pl Unit 5, WAIKOLOA

Listing courtesy of Hawaii Development Group.

$795,000

732351 MLS ⋅ ['Fee Simple'] Tenure

Set along the coveted rim of Waikii Ranch on the Big Island of Hawaii, Lot 122 presents an exceptional opportunity to create a legacy estate within Hawaiʻi's only gated equestrian community. Encompassing approximately 10 acres, this remarkable homesite enjoys protected vistas that stretch across the Kohala Coast to the Pacific, framed by the majestic peaks of Mauna Kea, Mauna Loa, Hualālai, and the Kohala Mountains. The views remains a defining feature of this extraordinary offering. Unlike many vacant parcels, Lot 122 has already undergone extensive improvements, allowing a future owner to move forward with confidence. The property has been professionally graded and filled while preserving its natural beauty. It is fully enclosed with premium no-climb equestrian fencing complemented by a solar-powered hot wire system, making it immediately suitable for horses. Two well-constructed horse shelters are already in place, complete with water and electrical service. House plans will be included with an acceptable offer, representing valuable savings in both time and design costs. Designed with the equestrian lifestyle in mind, the parcel borders Waikii Ranch's expansive agricultural corridor, providing convenient access to more than 12 miles of private riding and hiking trails that meander throughout the ranch. Life at Waikii Ranch is unlike anywhere else in Hawaiʻi. Spanning approximately 2,000 acres on the western slopes of Mauna Kea at elevations between 3,500 and 5000 feet, the ranch enjoys an enviable year-round climate characterized by sunny mornings, cool evenings, low humidity, and crisp mountain air. Private ranch amenities include two gated entrances, an clubhouse with guest accomodations. A mere twenty minutes from the prestigious schools, hospital and shopping of Kamuela, come see just how special Waikii is.

Palekaiko Rd, KAMUELA

Listing courtesy of Aloha Sotheby's Intl Realty - Hawai'i.

$249,000

1 Beds ⋅ 1 Baths ⋅ 202614626 MLS ⋅ FS - Fee Simple Tenure ⋅ Woodlawn Terr-Melema BLDG.

Looking for a move-in ready one-bedroom in Mililani under $250,000? This Woodlawn Terrace home in Central Oahu has been renovated from the floor up: quartz counters with full-slab backsplash, soft-white shaker cabinetry, stainless appliances, full-size washer and dryer inside the unit, renovated bath, newer flooring throughout, ceiling fans, and a covered lanai looking out over the park and ball field across the street. The living area is unusually generous for a one-bedroom, and the pricing is the real story - roughly half the current Oahu condo median. This is a short sale, so a serious buyer has genuine room to write a price and terms that work for them. The lender has been responsive, with approval currently estimated around 60 days. Minutes to Mililani Town Center, Schofield Barracks, Wheeler Army Airfield, H-2 freeway access, shopping, dining, and parks. Well suited as a first home, a military PCS purchase, or a low-maintenance primary residence. Easy to see. Call your Realtor and bring your offer.

95-009 Waikalani Drive Unit A209, Mililani

Listing courtesy of Talk Realty LLC.

$1,295,000

3 Beds ⋅ 4 Baths ⋅ 732225 MLS ⋅ ['Fee Simple'] Tenure

New construction on Alii Drive means waking up steps from Kailua Kona's most storied coastline road, with the security of a gated 19-home community. This brand-new 1,580-square-foot home in the Royal Alii subdivision delivers three bedrooms, three full baths, and a powder room — a smart layout built for how people live today. Inside, energy-efficient appliances outfit the kitchen — electric range, refrigerator, dishwasher, microwave — alongside an in-unit washer and dryer, while a hybrid electric heat pump water heater and multi-zone air conditioning keep the home running efficiently in Kona's climate. The primary suite offers a private retreat with its own full bath, and two additional bedrooms give guests or a home office room to spread out. Outside, a covered lanai extends the living space into the open air, and the two-car garage adds storage most new builds skip. The 6,637-square-foot lot sits behind Royal Alii's private gates. Alii Drive puts Kailua Kona's harbor, dining, and coastline within easy reach.

77-3309 Kahili Place, KAILUA KONA

Listing courtesy of Island Land Company, Inc..

$419,000

2 Beds ⋅ 1 Baths ⋅ 202615630 MLS ⋅ FS - Fee Simple Tenure ⋅ Maunaihi Terrace BLDG.

This cozy move-in-ready unit is tucked away on Punchbowl with Diamond Head, mountain, and city views! It is located on the cooler East side with secure entry to a boutique building. Enjoy new ceiling-height kitchen cabinets with under-cabinet lights, granite countertop, glass tile backsplash, and newer stainless steel appliances including a dish washer. Flex den has sliding doors, a closet, and a window, making it perfect as a 2nd bedroom, office, or living room extension. Popcorn ceiling has been removed. It has newer double-paned/UV filtered windows and newer paint! Enjoy the resort-sized recreation deck, pool, BBQ, & lounge with a grand backdrop of the ocean and Honolulu! Guest stalls, resident manager, & easy access to H-1.

1031 Maunaihi Place Unit 401, Honolulu

Listing courtesy of Praise God Realty.

$695,000

202615546 MLS ⋅ FS - Fee Simple Tenure ⋅ Wahiawa Medical Building BLDG.

This commercial space offers excellent visibility and value in a prime, strategically located location within the Wahiawa Medical Building, with easy freeway access. Situated on the ground floor and conveniently located across from the building's common parking areas, this turnkey unit was fully renovated and boasts a modern design and an inviting interior that greets visitors with a stunning high-end mural as they enter the reception area. Over $200,000 in renovations was completed in August of 2021. Rent is triple net. Water is included in the CAM. The unit encompasses a generous 1,280 square feet of functional space, which includes four examination rooms, a triad room, a storage room, a conference area that can also serve as an employee lounge, and a restroom. This is an opportunity to establish your own business in a vibrant area at the heart of Wahiawa. Must-see. While the information provided is deemed reliable, it is not guaranteed.

302 California Avenue Unit B, Wahiawa

Listing courtesy of Ilar.Homes LLC.

Start Your Search

Based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on . Information is deemed reliable but not guaranteed. Copyright: 2026 by HiCentral MLS, Ltd. IDX information is provided exclusively for consumers' personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.