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 = 3131 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 = 3131 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 = 3131 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;

502 Rosecrans Avenue
Manhattan Beach, CA 90266

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,599,900
Beds: 2
Baths: 3
Status: Pending
SqFt: 1694
Agency: RE/MAX Estate Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5,994 sqft
Property Type: Residential
Year Built: 2000
Notes: Step into the townhouse of every architect's dream – a masterpiece of design and functionality! This stunning residence boasts two bedrooms and two-and-a-half baths, offering a unique and luxurious living experience. The middle level, a sanctuary of comfort, houses a guest bedroom with an en-suite bathroom, providing privacy and convenience for guests. The primary bedroom is a true retreat, featuring a cozy fireplace, a private balcony for moments of relaxation, a walk-in closet, and two separate vanities in the en-suite bathroom. The middle level is also home to a convenient laundry room, ensuring practicality in daily living. The architectural highlight of this townhouse is the beautiful arched stairwell, not only serving as a functional element but also providing ample storage space underneath, contributing to the distinctive character of the home.<br /> Ascend the architecturally intriguing staircase to the main level of living, where extravagant modern architecture takes center stage. Here, the kitchen, dining area, living room, and a half bath create an open and inviting space for everyday living and entertaining. The top level crowns the townhouse with tall ceilings, angled walls, and panoramic views of the city. This level invites natural light to flood the space, enhancing the sense of openness and grandeur. To complete the package, an attached two-car garage ensures convenience and security for your vehicles. Immerse yourself in the sophistication and innovation of this architect's dream townhouse, where every detail has been carefully curated to create a living space that is as inspiring as it is functional.
MlsNumber: SB23227735


Listing Provided By: RE/MAX Estate Properties, original listing
Name: RE/MAX Estate Properties
Phone: (310) 378-9494
Office Name: RE/MAX Estate Properties
Office Phone: (310) 378-9494
Agent Name: Bill Ruane
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