REALHUB is on fire today

Properties

Browse or get in touch to schedule a walkthrough.

  • Nearby me
Price range

10000 properties match your criteria

Updated 1 minute ago

E-Alert name

Over 44 Acres of Prime Land in Magical Sky Forest – A Rare Opportunity!!



Discover over 44 acres of pristine mountain land in the heart of Sky Forest, ideally situated just off Highway 18 for convenient access. Surrounded by a variety of trees and breathtaking natural beauty, this expansive property offers incredible potential to build something truly special in a magical setting.

Whether you're seeking a private mountain retreat or looking to develop a unique project, this property offers the perfect blend of seclusion and accessibility. Formerly known as the Wylie Woods Retreat and once home to the Old Presbyterian Church Conference Center, the land holds a rich history. Although the hotel and lodge structures were destroyed in the Old Fire (per seller), the opportunity to reimagine this space is wide open.

The land includes three parcels totaling over 44 acres, with several hundred feet of frontage along Highway 18. It’s also accessible via Sycamore Drive through the recognizable 'Wonderland' gate. Nestled among the trees is a rustic cabin featuring five bedrooms and two bathrooms, adding charm and potential utility to the property. Well rights are included, enhancing its development appeal.

The parcel borders Sycamore Road, Green Briar, and stretches toward Cumberland Road, and is adjacent to SkyPark at Santa’s Village. With a location this unique and accessible, the possibilities are as vast as the forest itself.

Come explore Sky Forest and envision what you could create in this one-of-a-kind setting.
#IG25125830

Lake Arrowhead

28879 Sycamore Drive

None Beds

None Baths

44.34 acres

$5,800,000

MLS#: IG25125830

Over 44 Acres of Prime Land in Magical Sky Forest 

Nestled among the trees is a rustic cabin featuring five bedrooms and two bathrooms, adding charm and potential utility to the property. Water rights are included, enhancing its development appeal. The parcel borders Sycamore Road, Green Briar, and stretches toward Cumberland Road, and is adjacent to SkyPark at Santa’s Village. With a location this unique and accessible, the possibilities are as vast as the forest itself. A Rare Opportunity to own over 44 acres of pristine mountain land in the heart of Sky Forest, ideally situated just off Highway 18 for convenient access. Surrounded by a variety of trees and breathtaking natural beauty, this expansive property offers incredible potential to build something truly special in a magical setting. Whether you're seeking a private mountain retreat or looking to develop a unique project, this property offers the perfect blend of seclusion and accessibility. Formerly known as the Wylie Woods Retreat and once home to the Old Presbyterian Church Conference Center, the land holds a rich history. Although the hotel and lodge structures were destroyed in the Old Fire (per seller), the opportunity to reimagine this space is wide open. The land includes three parcels totaling over 44 acres, with frontage along Highway 18. It’s also accessible via Sycamore Drive through the recognizable 'Wonderland' gate.  Come explore Sky Forest and envision what you could create in this one-of-a-kind setting. The cabin is one of the parcels (2.36 acres) and the other 2 parcels are commercial/vacant land. Per seller, it has mineral rights and logging rights.
#IG25126891

Lake Arrowhead

28879 Sycamore

5 Beds

2 Baths

2,250 Sq.Ft.

$5,800,000

MLS#: IG25126891

Park Views, Prime Location, and Unmatched Elegance | Welcome to the prestigious 24-hour guard-gated community of Altair Irvine. This south-facing estate is ideally situated on one of the most premium lots, directly bordering a lush greenbelt. Enjoy unobstructed park views from the first floor, second floor, and the beautifully landscaped backyard—like living inside a dynamic work of art seamlessly blended with the home.



A private gated entry leads to a thoughtfully designed front yard and courtyard, offering both privacy and timeless curb appeal. The home also includes a spacious three-car garage, ideal for car lovers or flexible multi-purpose needs.



Inside, every corner showcases Extensive Designer Upgrades, from wide-plank hardwood floors to a bright, airy layout that maximizes natural light and elevates comfort. The chef’s kitchen boasts a waterfall-edge quartz island, floor-to-ceiling cabinetry, and top-tier stainless steel appliances, flowing into an expansive great room and formal dining area overlooking a peaceful courtyard.



The main level includes two en-suite bedrooms, including a private-entry guest suite ideal for multigenerational living or extended stays. Upstairs, the luxurious primary suite features dual vanities, a large walk-in shower, and two custom walk-in closets. The primary bathroom is richly appointed with marble finishes, creating a true spa-like retreat. A generous loft and bonus room offer flexible space for a home theater, gym, or game room, while a large covered terrace nearby provides the perfect setting for relaxing or entertaining.



Step outside to your private backyard oasis, complete with a built-in BBQ, mature fruit trees, and sweeping greenbelt views—perfect for hosting guests or enjoying quiet evenings at home. All within walking distance to Altair’s resort-inspired clubhouse, featuring pools, tennis courts, playgrounds, scenic trails, and more.



Move-in ready and sure to impress—book your private tour today before it’s gone.
#OC25098693

Irvine

100 Bellatrix

5 Beds

5 Baths

5,140 Sq.Ft.

$5,800,000

MLS#: OC25098693

SW Beach Hotel is a 9-unit boutique hotel located near the corner of 11th Street and Hermosa Avenue near the pier in the heart of Hermosa Beach, California. Formerly an 11-unit multi-family building, the Property was purchased by its current owner in 2014, operated for several years as a multi-family property before being approved in 2020 and subsequently transformed and reopened as the SW Beach Hotel in 2023. The hotel offers 9 rooms within a two-story, wood-frame I-shaped structure. The primary amenity is the 1800-sf Rooftop Deck, which serves as a guest amenity and also a revenue center when rented out to hotel guests. Guestrooms are unique in design and decor, and range from 184 to 550 square feet. Six of nine rooms offer full kitchens and outdoor patios or balconies. A large 550-square-foot penthouse is proximate and offers easy access to the Rooftop Deck. Each guestroom is individually styled and named.Current ownership spent +/-1 million renovating the hotel, adding a small lobby and a decorative glass atrium and steel frame stair case providing access to a new Rooftop Deck. The hotel features design cues from Las Vegas, 'where Las Vegas and Coastal living collide.' The hotel is positioned as a boutique hotel providing 9 units within steps to the sand and the bustling Pier Plaza district with its numerous restaurants, bars and shops.
#219116630PS

Hermosa Beach

66 11th Street

None Beds

None Baths

N/A

$5,800,000

MLS#: 219116630PS

Space for friends, family, recreation and cars!  This single level (step-down living room) home has 4 bedrooms + custom office + formal dining area + family room with attached 4-car garage and a 400 sq. ft multi-purpose  room with full bath. In addition, a cheerful full-fitted 2 bedroom 1400+sq. ft ADU with balcony is above a second garage. At the end of a long driveway, and bordered by tall hedges, the park-like setting is perfect for  relaxation or large gatherings. Less than 1 mile from downtown Menlo Park and within easy reach of Menlo Park schools, and commute routes. TOTAL BEDROOM COUNT : House has 4 + 2 in ADU = 6 BEDROOMS.   BATHROOMS house has 3 + 1 in multi-purpose/storage rm + 1 in ADU = 5 Bathrooms. . HOME OFFICE could be converted to create 7th bedroom. Lots to appreciate here !
#ML81925709

Atherton

191 Glenwood Avenue

4 Beds

4 Baths

2,950 Sq.Ft.

$5,800,000

MLS#: ML81925709

This multifamily apartment portfolio, consists of (3) Iconic Properties: Ivy Hall, Dorchester mansion and The Duplex Manor. 279 E San Fernando (Ivy Hall)  consists of  (17) Single Room Occupancy Bedrooms (SROs). 295 E San Fernando (Dorchester Mansion) consists of  (1) 2 Bed 1 Bath (9) 1 Bed 1 Bath (5) Studios and  (1) 4 Bed 1.5 Bed Single Family House. 73 S 7th St (Duplex Mansion) consists of  (1) 4 Bed 1 Bath (1) 3 Bed 1 Bath Units. The portfolio is located across the street from San Jose State University and down the street from Downtown San Jose. The four buildings are iconic to the city of San Jose with a pride of ownership corner lot
#ML81933427

San Jose

295 E San Fernando Street

None Beds

None Baths

10,255 Sq.Ft.

$5,800,000

MLS#: ML81933427

REDUCED PRICED! We are pleased to present Marlborough Villas Apartments for sale in a northern City Heights location. Completed in 1981,  Marlborough Villas is a well-maintained apartment community featuring large floor plans with updated interiors. The unit mix includes twelve 2bd/1.5ba town homes, four 2bd/2ba flats, one large 3bd/2ba unit and one 1bd/1ba unit. All of the units have in-unit washer/dryers and private balconies or patios. There is assumable financing available with vastly superior terms than what an investor can get in today's market. The property was extensively renovated in 2007 with the intent to sell as condominiums. Renovations included new windows and doors, updated kitchens with new appliances, granite counter tops and in-unit washer/dryers. The property has a Final Map allowing a buyer to sell units as condominiums as a potential exit strategy.
#240013211SD

San Diego

4102 Marlborough Ave

None Beds

None Baths

N/A

$5,800,000

MLS#: 240013211SD

Located in the heart of downtown Los Angeles, just moments away from the prestigious University of Southern California (USC), lies a rare gem of real estate: two parcels totaling 13,390 square feet, awaiting a visionary investor or developer. Located at 2819 S Flower Street, this expansive property offers an exceptional canvas for realizing your dreams of urban development.



Unbeatable Location: Situated in one of the most dynamic and sought-after neighborhoods in Los Angeles, this land enjoys unparalleled proximity to USC, making it an ideal investment for student housing, mixed-use development, or commercial ventures catering to the vibrant university community.



Fully Entitled Development: This rare offering comes with the invaluable advantage of full entitlements for a 47-guest room hotel, streamlining the development process and expediting your journey from vision to reality. With all necessary approvals in place, you can begin construction without delay, saving both time and resources.



Generous Size: With a total area of 13,390 square feet spread across two parcels, this property presents ample space for creative construction and versatile design concepts. Whether you envision a multi-story residential complex, retail establishments, or a combination of both, the possibilities are endless.



Thriving Urban Environment: Surrounded by a diverse array of cultural attractions, dining options, entertainment venues, and convenient amenities, this location offers an unparalleled urban lifestyle experience. Residents and visitors alike will appreciate the convenience of living in close proximity to downtown LA's bustling scene.



Investment Potential: As downtown Los Angeles continues to undergo rapid revitalization and gentrification, savvy investors have recognized the immense potential for growth and profitability in this area. Secure your stake in the future of one of the nation's most dynamic real estate markets.



Accessibility: Enjoy easy access to major transportation arteries, including highways, public transit routes, and bike lanes, facilitating seamless connectivity to all corners of the city and beyond.



Whether you're looking to capitalize on the thriving student population, capitalize on the burgeoning urban renaissance, or simply secure a strategic investment for the future, 2819 S Flower Street beckons with limitless potential.
#AR24099585

Los Angeles

2819 S Flower Street

None Beds

None Baths

0.3075 acres

$5,800,000

MLS#: AR24099585

Hidden behind a tall privacy hedge lies a custom-built home with magical gardens on a rare double lot in the prized Via Mesa. Designed to usher in light and relate to the lush surroundings, this inviting home has tall ceilings, wd. flrs., clerestory windows and Fr. Drs. opening to the garden and patios. Upstairs, 3BR & 2 BA plus the Primary ste. w/ ocean vw. deck. Downstairs, a room off kitchen could be off., gym or play rm. Detached office overlooking garden. The grounds invite year-round enjoyment with a patio for dining, entertaining and lounging, a lap pool, and a grassy expanse that inspires every manner of outdoor fun. Live the California dream within blocks of the Palisades Village.
#21774950

Pacific Palisades

659 Via De La Paz

4 Beds

2 Baths

3,895 Sq.Ft.

$5,800,000

MLS#: 21774950

We are pleased to present 1345-1355 Hilda Avenue Apartments, a well-maintained property portfolio in a great Glendale location.  Collectively the property is comprised of sixteen (16) units and one (1) Non-Conforming Studio in the highly sought-after upscale residential area of Somerset.  The building features a favorable unit mix consisting of (14) 2 bed/ 1 bath, (1) 2 bed/ 1.5 bath, and (1) 3 bed + 2 bath units. The 3 bed + 2 bath unit has been completely renovated, accompanied with central heat/air-conditioning, new stainless-steel appliances, new flooring, beautiful cabinetry, walk-in closets, fireplace, and quartz counter tops.  The building features a community pool, on-site laundry facility, and a combination of carports. The total size of the two buildings are 17,405 square feet and sit on 26,352 square feet that is GLR4YY zoned.   1345-1355 Hilda Avenue Apartments is located in the quiet, trendy neighborhood of Somerset, an area with tree-lined avenues and distant mountain-views.  This location also features a Walk Score of 80 (very Walkable) as it is in close proximity to cafes, casual dining options, and local shops and services.  Major attractions like Griffith Park, the Los Angeles Zoo, and the Hollywood Sign are less than 10 miles away.  The location also provides residents with excellent accessibility to employment in surrounding areas such as Hollywood, Pasadena, and Burbank. The property is additionally located just blocks from the 2 and 134 freeways.
#23277273

Glendale

1345 Hilda Avenue

33 Beds

None Baths

17,405 Sq.Ft.

$5,800,000

MLS#: 23277273

Nestled in the base of a verdant, private valley in Beverly Crest, is an opportunity to craft your dream home. This 4 acre, very buildable parcel sits up the hill, behind the gates of a private road. A previous appraisal states it is 65% buildable (2.6 acres) and is equipped with power, gas, water, and sewer connections. This extraordinary collection comprises four unique, separate, and buildable parcels, totaling 18 acres and are being sold separately or together. The parcels include: 4384-006-036, 4384-006-034, and 4384-006-035. Past architectural plans for four individual homes or one grand estate are available.
#23282375

None

9670 Antelope Road

None Beds

None Baths

4.0079 acres

$5,800,000

MLS#: 23282375

Nestled behind a secure gated entry on a desirable lot in West Atherton, this exquisite single-story home offers a sanctuary of comfort and privacy. With approximately 2,997 sq ft of thoughtfully designed space and meticulously maintained, the home exudes timeless elegance and a multitude of possibilities for the modern professional. Abundant skylights. The spacious living room adjoins the sunny dining room. A separate family room offers great space for everyday living. The primary bedroom invites relaxation with its ensuite full bathroom. Two additional bedrooms, two full bathrooms, plus a convenient office to work from home. Beautifully maintained lawns, trees and shrubs provide a peaceful outdoor haven.  A charming, separate guest house awaits, featuring 1 bedroom and full bathroom, kitchenette, laundry area and living room - perfect for hosting colleagues or extended family. Commute with ease to top tech campuses, downtown Menlo Park, and Stanford University.
#ML81975107

Atherton

179 Stockbridge Avenue

4 Beds

4 Baths

2,494 Sq.Ft.

$5,800,000

MLS#: ML81975107

Sky's The Limit at Hillsborough's 2 Acre Corridor. Opportunity to renovate, expand or build a new dream estate on one of the best 2.acre settings in recent years. Home in pristine original condition. Once home to legendary high-tech pioneer and Fortune 250 CEO Dr. An Wang.  Many eight figure estates dot this area including recent sales that do not match the caliber of this lot. 1960s house is mostly original but with strong architectural bones of 10 foot ceilings, large rooms, and vistas. Floorplan mostly on one level, plus huge downstairs media room that opens to pool. Imagine a renovation, expansion or new dream mansion. Current tennis court site may accommodate future new pool, pool house, or guesthouse. Ultimate privacy and lot orientation. Views into San Francisco skyscrapers. Sky's the Limit!
#ML81613409

Hillsborough

460 Pullman Road

4 Beds

4 Baths

5,580 Sq.Ft.

$5,800,000

MLS#: ML81613409

Sold Before Processing - Inputted for Comp Purposes Only
#250029373SD

Rancho Santa Fe

6693 Paseo Delicias

6 Beds

5 Baths

5,191 Sq.Ft.

$5,800,000

MLS#: 250029373SD

This contemporary compound within the gates of the renowned Vintage Club features scale and volume rarely found. Embedded into the natural mountain terrain, floor to ceiling windows and doors boast expansive views of the desert below. Situated on a 52,836 square foot lot, the 7,258 square foot layout offers a seductive and spacious silhouette with a natural flow into oversized living spaces including, a sunken living room with fireplace, a formal dining area, and a gourmet chef's kitchen, all complemented by windows showcasing the dramatic backdrop. Four ensuite bedrooms, including a primary suite with picturesque vistas, surround the pool offering a seamless transition of indoor-outdoor living that only the desert can provide. Two guest suites share a common sitting area and kitchenette with a private entry. An owned solar grid minimizes maintenance costs. The prime location and unique infrastructure poses an opportunity for customization and personal touch.
#219085277PS

Indian Wells

75300 Hidden

5 Beds

5 Baths

7,258 Sq.Ft.

$5,800,000

MLS#: 219085277PS

1 ... 594 595 596 597 598 ... 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

Reason for contacting?

Sign Out

Virtual Assistant

Would you like to receive some additional information on this specific property or similar properties?

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