search properties

Great opportunity to own a prime piece of real estate in Chino. Well established grammer school on almost an acre and as a bonus it comes with 2 single family residences for added income. The school consists of 4 large class rooms, each with its own restrooms, water fountains and sinks. There is also a reception office, storage room a fully equipped kitchen. There a 3 very nice play areas, a walking path and covered area with picnic benches for lunchtime. There is a total of 4 buildings, one school, 2 SFR's and 1 leased building for toddler development center. The main school building is approx 4,471 Sq/Ft. The property also has 17 parking spaces that are gated. Chino Child Development Center was established 47 years ago, which serves the community with childcare and early education, operating as a private child center. Excellent Accessibility to the 60 & 71 Freeways. The property has 2 options, has to be kept as a school or submit plans to sub-divide for additional housing.

1706 Palmdale Lane presents a rare, fully secured industrial property designed for maximum flexibility, privacy, and functionality. This one-of-a-kind asset combines a fully restored 1929 Craftsman structure with beautiful classic architectural touches, a carriage house/workshop, and a large banquet/flex building on a highly improved lot with extensive infrastructure already in place. Strategically located within a federally designated Opportunity Zone, offering investors potential long-term tax advantages, the property presents a unique blend of functionality, flexibility, and investment potential. Designed to accommodate a wide range of uses—including contractors, fleet-based businesses, creative studios, executive offices, showroom space, or live/work configurations—the property offers a unique blend of secure yard space, heavy-duty usability, and refined interior finishes, all within a professionally landscaped and highly private setting. The restored Craftsman residence also provides the rare opportunity for an owner-user to incorporate a residential or live/work component within an industrial environment. With multiple access points, commercial-grade rolling gates, significant electrical capacity, drainage systems, and reinforced turf for heavy equipment, this asset stands apart as a turnkey opportunity for users seeking operational efficiency, flexibility, and an elevated work environment within a secure industrial setting. The offering includes two separate parcels (APNs 111-023-19 and 111-023-18), providing additional flexibility, functionality, and long-term potential for a variety of industrial and owner-user applications.

Comala Hacienda for Sale Experience luxury hacienda living in Comala, one of the most charming and picturesque areas in the state of Colima. Located in the exclusive private community of Buena Vista in Noguera, this stunning estate blends traditional Mexican architecture with resort-style amenities and expansive indoor-outdoor living. Set on approximately 26,910 sq ft of land with over 12,700 sq ft of construction, this extraordinary hacienda offers multiple entertaining spaces, lush gardens, and a private pool oasis designed for gatherings, relaxation, and luxury living. The main level features spacious terraces, elegant corridors, a grand living room, formal dining area, fully equipped kitchen, and three oversized bedrooms, each with a private bathroom, closet, and air conditioning. Additional highlights include a covered BBQ area, large parking courtyard with fountains, covered garage, service/storage room, solar water heaters, and a high-capacity water cistern system. The outdoor entertainment area feels like a private resort, complete with a swimming pool with cascading waterfalls, gazebo, outdoor kitchen and dining terrace, grilling terrace, lounge areas, showers, and separate men’s and women’s restrooms. Upstairs, the property continues with four additional bedrooms with en-suite bathrooms and A/C, a game room, additional kitchen, social bathroom, and a spacious cantina/bar area ideal for entertaining family and guests. Surrounded by the natural beauty and cooler climate of Comala, this exceptional property is perfect as a luxury family estate, boutique hospitality opportunity, vacation retreat, or event venue in western Mexico. Price: $17,500,000 MXN Hacienda for sale in Noguera, inside the private community Buena Vista. Lot size: approx. 26,910 sq ft (2,500 m²) Construction: approx. 12,700 sq ft (house and terraces) (1,180 m²) Ground Floor Family terrace Large parking area with 2 fountains Covered garage for 2 cars Green areas / gardens Covered barbecue area 12,680-gallon underground water cistern with automatic system, 2 rooftop water tanks, and 2 solar water heaters Service/storage room Hallways/corridors Kitchen Dining room Main living room Bedroom 1 with bathroom, closet, and A/C Bedroom 2 with bathroom, closet, and A/C Bedroom 3 with bathroom, closet, and A/C Staircase with skylight dome Half bathroom under the stairs Pool Area Parking area Green areas / gardens Swimming pool with waterfalls Terrace with kitchen and dining area Gazebo connected to terrace Lounge chair area Barbecue terrace Men’s and women’s restrooms Shower area Upper Floor Hallways/corridors Bedroom 1 with bathroom, A/C, and space for closet Kitchen Bathroom for social/common area Game room area Bedroom 2 with bathroom, closet, and A/C Bedroom 3 with bathroom, closet, and A/C Bedroom 4 with bathroom, closet, and A/C Social area (cantina or bar)

Charming single story masterfully updated by Reid Hastings Construction. Gorgeous backyard with an in ground spool, outdoor barbecue, blue stone patio and hillside views. Leased solar, slate walkways and paver driveway

Set behind maturing landscaping and timeless architectural lines, this extraordinary Craftsman estate offers a rare opportunity to own a distinctive piece of Point Loma history. Rich with original character and thoughtfully updated for modern living, the residence showcases dramatic wood-beamed ceilings, original hardwood floors, gourmet kitchen and expansive living spaces filled with natural light. Elegant fireplaces, detailed millwork, and multiple sunrooms create warmth, architectural charm, and flexibility throughout the home. Designed for both elevated entertaining and everyday comfort, the property features a dedicated media room with a 100-inch television, creating the ideal cinematic experience, A speakeasy-inspired lounge and a private study provides an ideal space for executive-level productivity. The detached carriage house offers additional versatility for guests, extended stays, a private studio, office, or potential income-producing use. The property’s generous layout and indoor-outdoor flow create an environment equally suited for luxury daily living and entertaining. Located near Liberty Station, yacht clubs, waterfront dining, San Diego Bay, and coastal attractions, the home blends historic architecture with one of San Diego’s most desirable lifestyles. The property may qualify for Mills Act property tax savings and will also benefit from substantial Quieter Home Program improvements, including upgraded historically appropriate windows and doors designed to enhance comfort while preserving the integrity of the home’s original architecture. Extensively renovated by John Bradford Inc. (CA Lic. #1068625), this historic 1917 Craftsman residence underwent a comprehensive interior and exterior restoration designed to elevate the property to modern luxury standards while preserving select original architectural character elements. Improvements include extensive demolition and site preparation, upgraded plumbing systems with new supply and drain lines, new fixtures throughout, laundry hookups, and installation of a high-efficiency water heater. Electrical improvements include rewiring and modernization as needed for current code compliance, upgraded outlets and switches with GFCI/AFCI protection, recessed lighting, designer fixtures, accent lighting, dedicated appliance circuits, and exterior landscape lighting enhancements. Original hardwood flooring was carefully protected and professionally refinished with updated stain and sealing, while select bedroom areas received new premium carpet and padding. The redesigned kitchen features custom or semi-custom cabinetry, quartz or natural stone countertops, full tile backsplash installation, upgraded sink and faucet, pantry construction with custom shelving, and a high-end appliance package including range, oven, refrigerator, dishwasher, and hood vent. All bathrooms were extensively remodeled with new showers and tubs, waterproofing systems, tile flooring and walls, glass shower enclosures, updated vanities, mirrors, lighting, plumbing fixtures, and ventilation systems. Interior improvements also include repaired drywall, new texture, fresh interior paint, updated trim, baseboards, doors, and hardware throughout. Exterior enhancements include surface preparation and repainting, upgraded exterior elements, concrete and hardscape improvements to walkways and patio areas, refreshed landscaping with irrigation improvements, new planting, sod and decorative accents, plus additional outdoor lighting integration. The home also features multiple sunrooms, a private study/library office, a dedicated media room with a 100-inch television, and a speakeasy-inspired lounge space designed for entertaining. The detached carriage house above the garage offers additional flexible-use living or workspace potential. The property has received full approval through the Quieter Home Program (QHP), including historically appropriate upgraded windows and doors, with installation pen...

Gemini said Since you want to focus specifically on the main building and its basement while excluding the separate Olive Avenue lot, we need to adjust the square footage and lot size to reflect only the primary parcel. Tax records often underreport functional space because they focus on "above-grade" area. For your MLS listing, you want to highlight the usable space to show the true value. Corrected Data for Primary Parcel (247 S Riverside) Category Data for MLS Notes Total Building SF 21,200 SF Combines 10,200 SF main floor + 11,000 SF basement. Lot Size (Acres) .2433 AC This matches the specific parcel footprint from your tax info. Lot Sq Ft 10,600 SF The land area of the primary parcel only. Stories 1 + Basement Use this to explain the discrepancy between tax records and actual SF. Updated MLS Public Remarks (Basement Focus) Note: This version emphasizes the massive storage/production capacity of the basement without mentioning the extra parking lot. Turn-Key Business & Real Estate Opportunity in Downtown Rialto A rare chance to acquire J&J Auto Fabrics, a premier upholstery business established in 1982, along with its substantial real estate. This offering features a versatile 10,200 SF main floor complemented by a massive, fully functional 11,000 SF basement, totaling over 21,000 SF of usable space. The basement is a standout feature, equipped with a grade-level roll-up door for easy loading and inventory management. Ideally located directly across from the Rialto Metrolink Station, the property benefits from high visibility and DMUZ (Downtown Mixed-Use) zoning, providing excellent long-term investment potential. Sale includes the business name, goodwill, and all existing inventory. Whether you are looking to continue the legacy of a 40-year upholstery staple or repurpose the massive square footage for a new creative or industrial use, this property offers unmatched scale in the heart of the city.

3832 Santa Claus Ln is a well-maintained, multi-tenant property featuring four (4) ground-floor retail/office suites, one (1) second-floor office suite, and two (2) common restrooms. The property comprises approximately 5,697 SF of building area situated on a 14,375 SF lot and benefits from gated on-site parking. Suite C includes a large storage area equipped with loading doors, floor drains, wash sink, heated flooring, and surround-sound speakers, providing exceptional functionality and flexibility for a work space. Suite D on the second floor is outfitted with a full bathroom and kitchenette, offering a private space and the potential for a live/work environment.

Prime Downtown Merced Commercial Portfolio – 5 Contiguous C-C Parcels. Rare bulk sale opportunity consisting of five contiguous Central Commercial (C-C) zoned parcels totaling approximately 1.03 acres. All Fully improved commercial lots with utility hookups in place and precious home of Kentucky Fried Chicken drive through. The hard corner consists of a 15,000 SF parcel and operates as the established “Downtown Grubs” food truck plaza, generating strong foot traffic with potential gross rents of approximately $15,000 per month. Improvements include: a ±2,500 SF retail building currently supporting food truck operations (restrooms, storage, utility sinks). A ±6,000 SF retail warehouse leased to an antique & collectibles dealer at $4,125/month gross. All tenants are on month-to-month leases, offering flexibility for investors or owner-users. Located within walking distance to Downtown Merced and near major national retailers including Chick-fil-A (new site), Starbucks, In-N-Out, Popeyes, and Taco Bell. Excellent proximity to Hwy 99 and downtown landmarks such as UC Merced Downtown Campus Center, El Capitan Hotel, and the Mainzer Theatre. Strong existing income with redevelopment and value-add potential in a high-visibility commercial corridor.

Introducing an exceptional investment opportunity just blocked from the San Diego Yacht Club and San Diego Bay. This 8 unit property sits on 2 parcels. All units are 1 bed, 1 bath and are around 500 sqft. The property also has (4) 1 car garages which are currently being rented. This property is a rare opportunity for value add in a coastal community.