REALHUB is on fire today

Properties

Browse or get in touch to schedule a walkthrough.

  • Nearby me
Price range

Popular features

Community features

Property features

Waterfront

View

Exterior Features

Interior Features

Style

10000 properties match your criteria

Updated 1 minute ago

E-Alert name

Imagine entering through a majestic, gated entry lined with towering Palm Trees to an extraordinary Estate that exudes unparalled luxury and exquisite style. This Elegant Spanish residence is known as Casa Del Sueno or Dream House, a tranquil luxury Estate located in the exclusive gated enclave of La Quinta Polo Estates.  Meticulously kept, the property blends Old World Charm with modern elegance, and offers breathtaking views of the Santa Rosa Mountains, expansive indoor/outdoor entertaining spaces and resort-style amenities including a sparkling pool & spa surrounded by swaying, majestic palm trees, two custom stone firepits with built in cushioned lounge seating adjacent to a two bedroom guesthouse & grand outdoor living room with custom stone fireplace to enjoy evenings under the stars.  Casa Del Sueno is set on over 2 acres with sprawling lawns, stone walkways, lush, verdant landscaping, mature shade trees, an orchard, garden, vibrant bougainvillea & tropical plants, grape vines over pergolas which creates an inviting & serene oasis.  This home is designed to offer ample space with multiple outdoor terraces, 3 guesthouses, cozy media room w/fireplace, bar & wine cellar. An expansive covered outdoor loggia and enchanting fountain as the centerpiece connects the guesthouse & media room to the main house, perfect for evenings relaxing in front of a crackling fire while playing billiards or lawn games surrounded by romantic hanging lights softly illuminating the area.  This exquisite Estate offers 5 bedrooms w/ensuite baths, 7 bathrooms, chef's luxury kitchen perfect for effortless entertaining, butler's pantry, an elegant living room w/massive stone fireplace & floor to ceiling walls of glass and French doors that opens to a grand terrace & outdoor dining room/living area w/seating for 30+, outdoor kitchen, BBQ, & Poolside Bar. The master suite is a true retreat with 2 bathrooms, dressing room, living room and provides incredible views of the lush grounds & shimmering pool with French doors to a private covered terrace. This exceptional property includes superb architectural elements & sumptuous furnishings throughout.  Adjacent to Eldorado Polo Club, the Hideaway & Madison, this hidden gem offers a Magnificent setting with spectacular views that provide a stunning backdrop to unwind & enjoy the beauty of the desert.  This is a priceless opportunity to own a special piece of the Polo Estates, the finest real estate in La Quinta the Desert has to offer.
#219131247DA

La Quinta

80780 Vista Bonita Trail

5 Beds

5 Baths

5,630 Sq.Ft.

$7,125,000

MLS#: 219131247DA

*Offers Due - Friday, June 30th @ 12pm* The Wightman Place Apartments is a 44-unit multifamily building located in a CTCAC Low Resource and Opp. zone in the heart of central San Diego. Built in 1963, the property comprises an estimated six buildings on one large 1.76-acre parcel, offering a unique mix of units that range from one to five bedrooms. Ten of the two-bedroom units feature two-story townhomes with 1.5 bathrooms each. Wightman Place offers an on-site laundry room, approximately 23 balconies for select units, patios for most units, one garage (or storage site) and an estimated 45 on-site parking spaces. Gas and electric are separately metered, and the property's equipped with three 100-gallon water heaters. Recent renovations include new vinyl plank flooring for select units, dual-paned windows, and a newly installed roof throughout the complex.
#NDP2304605

San Diego

5052 Wightman Street

None Beds

None Baths

41,700 Sq.Ft.

$7,125,000

MLS#: NDP2304605

Potential for 10 to 12 acres to be entitled for Multi-Family up to 20 units/acre. Located at the I-10 and Jefferson Offramp with three signalized entrances to the project. Approved site plan for retail. This is the main freeway exit for the Coachella and Stagecoach Music Festivals. 3 miles to the new Coachella Valley Stadium/Arena. Within 1 mile from Shadow Hills High School and Desert Ridge Middle School and a new elementary school coming soon. Indio is one of the fastest-growing cities in the Coachella Valley. Known as the City of Festivals, it welcomes more than 1 million visitors each year. Drive Thru pads available. This area is experiencing explosive new growth. We cannot guarantee the accuracy or square footage, lot size or other information concerning the condition or features of property provided by the Seller or obtained from public records or other sources. The Buyer is advised to independently verify the accuracy of all information through personal and professional inspections.
#219043995DA

Indio

0 I-10 & Jefferson Street

None Beds

None Baths

20.43 acres

$7,119,440

MLS#: 219043995DA

Set atop a prime Bel Air hilltop, this classic estate offers a serene escape with unobstructed ocean, city, and canyon views. Spanning almost an acre, the home blends mid-century charm with timeless appeal. A stunning cantilevered tennis court, sparkling pool and spa, and expansive grassy yard invite relaxation while enjoying the spectacular blue-sky vistas. The light-filled residence features spacious, well-appointed living areas, including a formal dining room, family room, and a vast bonus room perfect for entertainment. Hardwood floors flow throughout, enhancing the home's elegant atmosphere. The gourmet kitchen, complete with a sunny breakfast nook, is ideal for gatherings. Four bedrooms, including a luxurious master suite with a marble bath, offer comfort and privacy. Smart home capabilities, multiple fireplaces, and a two-car garage complete the offerings. The private backyard, with a tennis court featuring area lights, creates a resort-like atmosphere perfect for both active play and tranquil retreats. This estate is the epitome of refined living in Bel Air.
#25496907

Los Angeles

1237 Bel Air Road

5 Beds

4 Baths

3,881 Sq.Ft.

$7,100,000

MLS#: 25496907

Constructed in 2001 with additional recent renovations, this custom home offering 4 bedrooms, an office, and 3.5 bathrooms is a masterpiece of East Coast-influenced architecture from the signature wraparound front porch to the perfect symmetry of the shuttered windows. The home's grandeur begins with the magnificent curb appeal and continues inside where beautiful appointments include hardwood flooring throughout, European stone selections, and architectural columns. Tall ceilings and wide passageways enhance the spacious dimensions of ~4,400 square feet. Equally impressive this private setting of almost one acre is discretely situated away from the road at the end of a cul-de-sac with a gated entrance.  This estate is surrounded by verdant shade and sun gardens, crushed stone paths, manicured landscaping plus a vast limestone terrace ideal for entertaining. Located in the heart of desirable Lindenwood on approximately one acre, this home benefits from acclaimed Menlo Park schools.
#ML81598901

Atherton

53 Magnolia Drive

4 Beds

3 Baths

4,390 Sq.Ft.

$7,100,000

MLS#: ML81598901

For statistical purposes only.
#24362599

Santa Barbara

865 Romero Canyon Road

6 Beds

6 Baths

3,826 Sq.Ft.

$7,100,000

MLS#: 24362599

7342 Haskell Ave, a 21-unit multifamily asset not subject to LA City Rent Control. SELLER WILL CARRY at 4.5% interest-only in year 1, 5.5% interest-only in year 2. Built in 1986, the property is exempt from Los Angeles City rent control, allowing for annual rental increases of 5% plus CPI, currently 8.8% annually. Significant capital improvements totaling approximately $500,000 have been invested into the property, including a new roof, elevator, exterior paint, upgraded hallway flooring, modern lobby tile, security camera installation, and updated interior lighting. Additionally, there is an opportunity to add Five 1-bedroom/1-bath ADUs without losing adequate parking and potentially increasing annual income by $100,000.Proximity to Major Developments: *East San Fernando Valley Light Rail Transit Project: Approximately 1.5 miles east, this 6.7-mile light rail line along Van Nuys Boulevard is under construction, with completion anticipated in 2031. It will enhance connectivity and transit options in the area.*G Line Busway Improvements: Around 2 miles southeast, the Metro G Line is undergoing a $668 million upgrade, including the construction of elevated stations at key intersections like Van Nuys Boulevard and Sepulveda Boulevard, aiming to improve travel times and reliability. *The Brightly at 6569 Van Nuys Blvd: Located approximately 2.5 miles southeast, this six-story development features 174 residential units and 18,400 square feet of ground-floor commercial space, contributing to the area's revitalization. *Affordable Housing at 6100 Hazeltine Ave: About 3 miles southeast, a seven-story building with 72 affordable units is under development, addressing housing needs and promoting community growth. This offering is ideal for investors seeking a well-maintained asset with value-add potential in a neighborhood poised for continued growth and development. ***Contact us today to request the OM or schedule a private tour.***
#25548685

Van Nuys

7342 Haskell Avenue

36 Beds

None Baths

24,349 Sq.Ft.

$7,100,000

MLS#: 25548685

Closest cross street is ‘Carmel Valley Hwy & Country Club Dr’
#41109836

Carmel Valley

306 Country Club Hts Hts HTS

4 Beds

3 Baths

5,624 Sq.Ft.

$7,100,000

MLS#: 41109836

We are pleased to exclusively offer for sale this multi-family investment opportunity in the vibrant city of El Monte. This newly listed property features a collection of 29 units, showcasing true pride of ownership. The subject property predominantly consists of two-story townhouse-style units (28 Units), complemented by a quaint 2-Bedroom/1-Bathroom cottage, all extremely spacious in size. Occupying an oversized lot of 47,437 square feet, the property offers an expansive 24,734 square feet of rental space, designed to cater to the modern tenant's needs.



The entire property benefits from copper plumbing, ensuring durability and reducing maintenance concerns. Ample car-port parking and generous open spaces address the practical needs of residents, while the onsite laundry facility and private backyards in each unit add a touch of convenience and privacy to their living experience. Tenants are responsible for their own electricity and gas, allowing for easier management of utilities.



Currently offered at 13 GRM and a 4.72% CAP Rate, a standout feature of this investment is the significant potential for a 40% increase in rental income, with all units currently poised for a rental adjustment (April 2024.) This opportunity is further enhanced by attractive private seller financing terms; 35% Down Payment, 6.5% Interest-Only Payments, Due in 10 years. This investment offers not only a stable income stream but also a considerable upside in rental income, making it an ideal choice for discerning investors seeking growth and sustainability in their portfolio.
#CV24042328

El Monte

2629 Gage Avenue

None Beds

None Baths

24,734 Sq.Ft.

$7,100,000

MLS#: CV24042328

Graceland Apartments, located at 107 N. Columbus Avenue, is a charming 13-unit historic American Four Square building just one block from the Glendale Americana. The current owner has made over $1 million in strategic capital improvements, including upgrades to the electrical system, plumbing, and roofing. Spanning two parcels, the property offers a diverse mix of units: (2) 2-bedroom/1-bathroom, (6) 1-bedroom/1-bathroom, and (5) studios. With spacious floorplans, many units have been meticulously restored to cater to the area's strong tenant demand. A RUBS (Ratio Utility Billing System) program has been implemented across all units, boosting operational efficiency and allowing for a sub-30% expense ratio for future owners. The property also includes ten garages, currently generating rental income with the potential to be converted into three 2-bedroom/1-bathroom ADUs, each around 700 square feet. These ADUs could add approximately $34,605 in annual rental income. By capitalizing on market rent increases and investing in ADU construction, a new owner could see an impressive return on cost of up to 333%. ***Assumable Financing Available***
#25482897

Glendale

107 N Columbus Avenue

10 Beds

None Baths

7,796 Sq.Ft.

$7,100,000

MLS#: 25482897

None
#250036657SD

San Diego

1568 Coporate Center Drive & Otay Mesa Rd

None Beds

None Baths

3.29 acres

$7,100,000

MLS#: 250036657SD

Self Storage facility for sale as part of larger portfolio.
#CV23134566

Crescent City

1065 Mcnamara Road

None Beds

None Baths

78,628 Sq.Ft.

$7,100,000

MLS#: CV23134566

Excellent opportunity to purchase a large contiguous tract of land in a productive farming region near Farmington, CA. 383.0 gross acres featuring adaptable open land and walnuts. The ranch is eligible to receive surface water from Central San Joaquin Water Conservation District and has two (2) ag wells, 50HP with two (2) sand media filters and 150HP with six (6) sand media filters. 17.0 acres of 24th leaf Livermore walnuts, planted on the south-west corner of the subject, irrigated via a double-line drip system. The remaining acreage currently in open land adaptable for permanent plantings. Subject previously featured vineyards which were removed in Summer 2025. The subject is enrolled in the Williamson Act, providing tax benefits to the new owner. Prime opportunity to purchase a large tract of land in a desirable growing region for tree nuts, row crop farming and dairy operations.
#MC25188925

Escalon

2507 S. Escalon Belotta Road

None Beds

None Baths

383.0 acres

$7,100,000

MLS#: MC25188925

Sold during the Listing process. Submitted for comps purposes.
#OC25154180

Laguna Niguel

39 Poppy Hills Road

5 Beds

5 Baths

8,358 Sq.Ft.

$7,100,000

MLS#: OC25154180

13717 Chadron Avenue is a well-maintained 28-unit apartment complex located in the heart of Hawthorne, one of the most dynamic rental markets in Los Angeles' South Bay. Built in 1972, the property offers a desirable mix of spacious one- and two-bedroom units across approximately 22,000 square feet of rentable space.



Tenants enjoy on-site amenities including a swimming pool, solar energy system, secure parking with camera surveillance, and on-site laundry. The property sits on a 19,535 square foot lot with gated access and strong curb appeal.



Centrally positioned near major employers like SpaceX, Raytheon, Northrop Grumman, and LAX, the property also benefits from proximity to the beach cities of Manhattan Beach, Hermosa Beach, and Redondo Beach. With easy access to freeways, transit, and entertainment, 13717 Chadron is an ideal long-term hold in a high-demand, supply-constrained submarket.
#SB25139694

Hawthorne

13717 Chadron Avenue

None Beds

None Baths

22,000 Sq.Ft.

$7,100,000

MLS#: SB25139694

1 ... 401 402 403 404 405 ... 666
* Listings identified with the FMLS IDX logo come from FMLS and are held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request. © 2024. First Multiple Listing Service, Inc.
 - property

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

Reason for contacting?

Sign Out

Virtual Assistant

Would you like to take the next step with this property? We can help you schedule a showing or virtual tour, or send you more details.

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

Already have an account ? Login here