Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3130 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3130 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3130 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

50 Rivo Alto Canal
Long Beach, CA 90803
Kimberley Robinson with First Team Real Estate, original listing - (949) 539-0824

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $6,200,000
Beds: 5
Baths: Full: 4
Status: Active
SqFt: 3650 Square Feet
Agency: First Team Real Estate
Agency Phone: (949) 539-0824

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: Presenting a rare and exceptional opportunity, this residence sits on a sprawling double lot with 60 feet of pristine waterfront. Thoughtfully reimagined just eight years ago, this home exudes sophistication and style, with meticulous attention to detail in every aspect. Bathed in natural light, the two-story great room features retractable glass walls, seamlessly blending indoor and outdoor living while maintaining an exceptional level of privacy. This beautifully designed home, offering 4-5 bedrooms, includes a game/media room, a custom office, and a spacious fitness center. The luxurious primary suite showcases sweeping water views, a soaking tub, and a warm, inviting fireplace, while a private guest suite on the first floor provides comfort and seclusion for visitors. Set on an expansive lot, this property features a commercial-grade concrete dock with new wood on the dock ramp, a new wood deck along the canal, and accommodates 2-3 watercrafts. Additionally, there is a gated parking area with space for six vehicles, including a two-car garage. The outdoor spaces are thoughtfully designed to capture both sunrises and sunsets, offering a tranquil setting for everything from intimate gatherings to grand celebrations, complete with a private spa, barbecue area, and a stylish outdoor lounge with a fire pit. Inside, the home features a stunning kitchen with a striking double-waterfall island, an oversized walk-in pantry, and a dedicated beverage center, perfect for culinary enthusiasts and entertainers alike. This smart home is equipped with state-of-the-art technology, allowing remote control of lighting, security systems, gates, and window coverings, as well as a Sonos sound system. Designed for sustainability and comfort, the property features solar readiness, dual-pane Fleetwood windows and doors, dual HVAC systems, dual tankless water heaters, an electric car charger, and premium porcelain flooring. Don’t miss the chance to own a property as unique and extraordinary as this. Reach out for a private showing and experience the beauty and serenity of this exclusive property firsthand!
MlsNumber: --
ListingId: PW24183233


Listing Provided By: First Team Real Estate, original listing
Phone: (949) 539-0824
Office Phone: (949) 539-0824
Agent Name: Kimberley Robinson
Disclaimer: Copyright © 2024 California Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App