querybuilder
-
99999 30th in Rosamond: Land for sale (ROSA - Rosamond) : MLS®# AR24216377
99999 30th Rosamond 93560 
$55,000Land- Status:
- Active
- MLS® Num:
- AR24216377
10 acre land located off 30th W. between Beaudette Ave. and Favorito Ave. Just minutes from 14 Freeway. APN 471-082-17-00-2 Views of desert landscape and mountains. Map the following GPS coordinates to locate the property: 34.902539, -118.184907 More detailsListed by Seven Gables Real Estate- BRIDGETTE CARRILLO
- SEVEN GABLES REAL ESTATE
- 1 (626) 6428861
- Contact by Email
-
1871 Park Drive in Los Angeles: Residential Income for sale (C21 - Silver Lake - Echo Park) : MLS®# AR24240418
1871 Park Drive Los Angeles 90026
$1,250,000Residential Income- Status:
- Active
- MLS® Num:
- AR24240418
This charming vintage duplex is nestled on the hilltops of Echo Park, offering breathtaking city-light views and serene wilderness vistas. This section of Park Drive is quite unique in that there are no homes across the street, and the property's front yard looks at trees and nature—offering a tranquil ambiance. The property features a classic Spanish-bungalow style, with 1,487 square feet of living space spread across two units. The upper unit, a spacious 875 square feet, features one bedroom, one bathroom, dining room, and stunning views. The lower unit, at 612 square feet, also offers one bedroom, one bathroom, and a cozy ambiance. Each unit features their own in-unit laundry closets, central heating, and separate patio spaces. The detached one-car garage and driveway provide convenient storage and parking for the upstairs unit. Seize the opportunity to own this unique property in a coveted location. More detailsListed by Seven Gables Real Estate- BRIDGETTE CARRILLO
- SEVEN GABLES REAL ESTATE
- 1 (626) 6428861
- Contact by Email
-
22300 Avenue X in Llano: Land for sale (LLO - Llano) : MLS®# AR25067356
22300 Avenue X Llano 93544
$55,000Land- Status:
- Active
- MLS® Num:
- AR25067356
Use Code 580V Vacant land. Total Square footage is 217,800. Open land, opportunities for development (lots have been built in the surrounding area). Great view, close to the mountains, flat land. Buyer responsible for securing water, sewer, and electricity to the property. Fence posts installed on three sides (front width and two side lengths). The 5-acre vacant lot identified by parcel number 3086-012-001 is located in Llano, California, within Los Angeles County. This property offers an opportunity for development. The lot is situated near the intersection (Highway 138) and 233 Street East. The property is zoned LCA11*, which typically permits agricultural and residential uses. This zoning designation may allow for various development opportunities, including agricultural ventures, residential construction, or a combination thereof. Prospective buyers should verify the specific zoning regulations and potential uses with the Los Angeles County Department of Regional Planning to ensure alignment with their development plans. The Llano area has several properties on the market, indicating active interest and potential for growth. These listings provide insight into the local real estate market and may serve as comparables for assessing the value and potential of the lot. Potential buyers are encouraged to conduct thorough due diligence, including consulting with local authorities and real estate professionals, to fully understand the property's potential and any development constraints. More detailsListed by Seven Gables Real Estate- BRIDGETTE CARRILLO
- SEVEN GABLES REAL ESTATE
- 1 (626) 6428861
- Contact by Email
-
2306 W Alhambra Road in Alhambra: Residential Income for sale (601 - Alhambra) : MLS®# AR25068841
2306 W Alhambra Road Alhambra 91801
$1,890,000Residential Income- Status:
- Active
- MLS® Num:
- AR25068841
Imagine stepping into a charming corner of Northwest Alhambra, where the timeless allure of Art Deco Spanish architecture meets the convenience of modern living. This meticulously renovated Quadplex, comprising two stunning Duplexes, offers a unique blend of vintage charm and contemporary efficiency. Each of the four units is thoughtfully designed with a 1-bedroom, 1-bath layout, featuring a versatile dining room that can easily be converted into a 2nd bedroom, providing flexibility for residents. The property's comprehensive remodel in 2001 ensured that it would stand the test of time. New copper plumbing, electrical systems, and HVAC were installed to guarantee long-term reliability and efficiency. Additionally, seismic retrofitting was completed to enhance structural safety, offering peace of mind for both owners and tenants. Located in a highly desirable neighborhood adjacent to South Pasadena, this Quadplex benefits from its proximity to top-rated schools, vibrant community amenities, and a variety of dining and shopping options. With reliable tenants already in place, this property represents a rare opportunity to secure a stable income-generating asset. Whether you're looking to expand your real estate portfolio or secure a steady stream of rental income, this Quadplex is an investment opportunity not to be missed. Its blend of architectural beauty, modern upgrades, and prime location makes it a standout choice for savvy investors. More detailsListed by Seven Gables Real Estate- BRIDGETTE CARRILLO
- SEVEN GABLES REAL ESTATE
- 1 (626) 6428861
- Contact by Email
-
80138 Whisper Rock Way in La Quinta: Residential for sale (313 - La Quinta South of HWY 111) : MLS®# AR25065273
80138 Whisper Rock Way La Quinta 92253
$794,000Residential- Status:
- Active
- MLS® Num:
- AR25065273
- Bedrooms:
- 3
- Bathrooms:
- 3
- Floor Area:
- 1,951 sq. ft.
Located in PGA West in the Signature Home gate. This residence was built in 2023. It offers 3 bedrooms, 2 1/2 baths, and a spacious loft area. Downstairs offers and open floor plan with a designer kitchen and a living area to enjoy. Master bedroom and bath is located downstairs along with laundry room, and 1/2 bath. Upstairs you will find 2 more bedrooms, a full bath and an open loft to use as you wish. This great location is in the center of this beautiful golf community. The Signature also has 24 hour security and guard-gated entry. Gym, pool, bbq area are just steps away for your enjoyment. Solar panels are also a benefit of this home. More detailsListed by Seven Gables Real Estate- BRIDGETTE CARRILLO
- SEVEN GABLES REAL ESTATE
- 1 (626) 6428861
- Contact by Email
-
3241 Mills in La Crescenta: Residential for sale (635 - La Crescenta/Glendale Montrose & Annex) : MLS®# AR25084106
3241 Mills La Crescenta 91214
$1,100,000Residential- Status:
- Active Under Contract
- MLS® Num:
- AR25084106
- Bedrooms:
- 3
- Bathrooms:
- 2
- Floor Area:
- 1,463 sq. ft.
Welcome to this charming three bedroom, two bath La Crescenta home, offering a blend of comfort, style, and exceptional outdoor living. Step inside to discover an open-concept kitchen and family room, bathed in natural light, perfect for both entertaining and everyday living. The spacious primary suite is privately situated at the back of the home, providing a peaceful retreat with views of the yard. Two additional front bedrooms are connected by a convenient Jack and Jill bathroom, ideal for family or guests. The large, retreat-like backyard features mature shade trees, creating a serene and private atmosphere-perfect for relaxing or hosting gatherings. With ample room to add an ADU, this property offers exciting potential for updates, expansion or additional income. A long driveway provides plenty of parking, enhancing convenience for residents and visitors alike. Located within the highly regarded Crescenta Valley High School district, and just minutes from Montrose shopping, Crescenta Valley Community Regional Park, and with easy access to the 210 Freeway, this home combines tranquility with unbeatable convenience. Don’t miss your chance to own a slice of La Crescenta’s sought-after lifestyle. More detailsListed by Seven Gables Real Estate- BRIDGETTE CARRILLO
- SEVEN GABLES REAL ESTATE
- 1 (626) 6428861
- Contact by Email
-
4599 Willow Bend Court in Chino Hills: Residential for sale (682 - Chino Hills) : MLS®# AR25101191
4599 Willow Bend Court Chino Hills 91709
$1,150,000Residential- Status:
- Active
- MLS® Num:
- AR25101191
- Bedrooms:
- 4
- Bathrooms:
- 3
- Floor Area:
- 2,392 sq. ft.
This spacious 4-bedroom, 3-bathroom residence offers 2,392 sq. ft. of thoughtfully designed living space that balances comfort, functionality, and style. Inside, a bright open layout features a dedicated home office, perfect for remote work or focused study, while the well-equipped kitchen flows effortlessly into the family room which features built-ins and a fireplace perfect for gatherings. Large living room and formal dining area with an abundance of windows to let the natural light in. There is also a bonus room with its own entrance which can be used for guests, private office, playroom lots of possibilities. Enjoy California living at its finest in your resort-style backyard oasis, complete with a sparkling saltwater pool and spa featuring tranquil waterfalls and plenty of space to lounge or host gatherings. The home also includes an electric car charging outlet, a convenient laundry room, an attached two-car garage, and ample storage throughout. Located in a desirable Chino Hills neighborhood near scenic trails, parks, schools, and local amenities, this home offers a unique blend of convenience and peaceful living. More detailsListed by Seven Gables Real Estate- BRIDGETTE CARRILLO
- SEVEN GABLES REAL ESTATE
- 1 (626) 6428861
- Contact by Email
-
821 S Cerritos Avenue Unit 17 in Azusa: Residential for sale (607 - Azusa) : MLS®# AR25118447
821 S Cerritos Avenue Unit 17 Azusa 91702
$584,995Residential- Status:
- Active
- MLS® Num:
- AR25118447
- Bedrooms:
- 3
- Bathrooms:
- 3
- Floor Area:
- 1,277 sq. ft.
Turnkey Azusa Townhouse located far from street in the Stonewood Village Community and ready to be called home! Upon entering unit, it will lead you to the open family room/dining area with a statement brick fireplace. The kitchen is remodeled with wood cabinets, granite counter tops and a breakfast bar overlooking the dining area. Guest bathroom downstairs with newer vanity and granite counter tops. All bedrooms located upstairs with large primary suite with high vaulted ceilings, primary bath with newer vanity and granite counter tops. Two other bedrooms and hall bath upgraded with newer vanity and granite counter tops. Other great features include, engineered hardwood flooring with wood plantation shutters leading to private patio yard with Gazebo and plants, central heat and air, 2 car attached garage with laundry hook-ups and direct access off the kitchen. Steps away, the community offers pool and in-ground Spa. Plenty of guest parking. Located near shopping, schools and colleges. This well loved home is ready to welcome you to make it your own! More detailsListed by Seven Gables Real Estate- BRIDGETTE CARRILLO
- SEVEN GABLES REAL ESTATE
- 1 (626) 6428861
- Contact by Email
-
1409 N Midsite Avenue in Covina: Residential for sale (614 - Covina) : MLS®# AR25124698
1409 N Midsite Avenue Covina 91722
$899,000Residential- Status:
- Active
- MLS® Num:
- AR25124698
- Bedrooms:
- 4
- Bathrooms:
- 2
- Floor Area:
- 1,565 sq. ft.
Tucked into a charming Covina neighborhood lies a residence unlike any other. This is not just a home, it is the childhood haven of a celebrity designer, now lovingly brought back to life with his artistic signature. As you step inside, you are greeted by a graceful blend of old soul and new elegance. The kitchen, reimagined with shimmering glass backsplash and rich granite countertops, holds the centerpiece of the past: a fully restored vintage stove and oven, reminiscent of the one featured on the television show Bewitched, that breathes history and magic into every meal. A new sink and thoughtfully selected hardware bring a refined edge to the space, where glamour meets function. Both the main and guest bathrooms are completely renewed, exuding a quiet luxury that whispers rather than shouts. Throughout the home, new floors seamlessly transition from room to room, framed by elegant baseboards, refined window casings, and thoughtfully designed closets. Natural light dances through the windows and a beautifully updated sliding glass entry that leads you to the heart of the backyard. Outside, every detail has been touched by care, from the new wood siding and restored fascia to custom gables and glowing landscape lighting that transforms both front and back yards into evening sanctuaries. Drought-tolerant Mediterranean gardens bloom with intention, bordered by new fencing and privacy panels that promise both beauty and retreat. Every surface, every corner, is dressed in fresh paint that feels both timeless and new. This is not simply a remodeled home, it is a revival. A place where history and design dance gracefully together. Come step into the story. More detailsListed by Seven Gables Real Estate- BRIDGETTE CARRILLO
- SEVEN GABLES REAL ESTATE
- 1 (626) 6428861
- Contact by Email
-
108 N Hacienda Avenue in Glendora: Residential for sale (629 - Glendora) : MLS®# CV25093787
108 N Hacienda Avenue Glendora 91741
$1,200,000Residential- Status:
- Active
- MLS® Num:
- CV25093787
- Bedrooms:
- 3
- Bathrooms:
- 2
- Floor Area:
- 2,011 sq. ft.
Welcome to your next home in North Glendora—where comfort, privacy, and thoughtful upgrades come together in all the right ways. This inviting single-story residence offers a spacious primary suite, two additional bedrooms, and two remodeled bathrooms. The open-concept kitchen flows into a sunlit great room with serene views of your private backyard oasis—ideal for both relaxed living and vibrant entertaining. At the front of the home, a generous, beautifully landscaped yard offers great curb appeal and a warm welcome every time you arrive. Just inside, the formal living room features a cozy gas fireplace and sits separate from the main living areas, giving you flexible spaces to gather or unwind. Step outside and discover a backyard built to impress: a large, sparkling pool surrounded by tall block walls for total privacy, with only one shared neighbor. A covered patio just off the great room and primary suite invites seamless indoor-outdoor living—whether you’re hosting friends, enjoying summer afternoons, or relaxing under the stars. This home is loaded with quality upgrades, including copper plumbing, all-new Andersen triple-pane tempered windows (replaced in 2025), a Generac whole-house generator (22 kW, installed in 2021), a new HVAC system (2021), updated pool equipment (2020-2023), and roof was replaced in 2010. Situated on a spacious corner lot in one of Glendora’s most desirable neighborhoods—just minutes from award-winning schools, charming shops, and great local dining—this home is the perfect blend of comfort, lifestyle, and value. More detailsListed by Seven Gables Real Estate- BRIDGETTE CARRILLO
- SEVEN GABLES REAL ESTATE
- 1 (626) 6428861
- Contact by Email
-
2148 Aquinas Avenue in Claremont: Residential for sale (683 - Claremont) : MLS®# CV25111449
2148 Aquinas Avenue Claremont 91711
$1,175,000Residential- Status:
- Active Under Contract
- MLS® Num:
- CV25111449
- Bedrooms:
- 4
- Bathrooms:
- 2
- Floor Area:
- 1,934 sq. ft.
Start making summer memories in a backyard oasis designed for year-round SoCal celebrations. Sited on a quiet cul de sac in NE Claremont with foothill views, this single level gem has a spacious open floor plan with three bedrooms & convenient home office. The cheery kitchen with views of the pool offers granite countertops, abundant wood cabinetry, tile floors and a built-in desk. The adjoining dining nook and family room boast gorgeous oak French doors connecting to the back yard and patio. Gleaming wood laminate flooring is accented by natural wood trim and raised panel doors throughout. Luxurious primary suite has oak French doors to the pool & patio, hardwood flooring and updated bath with custom oak vanity and tiled walk-in shower with dual showerheads. The fourth bedroom was converted into a home office and boasts rich dark wood built-in desk and shelving. This impeccably maintained home also features a tastefully remodeled full hall bath, and convenient indoor laundry room with built in cupboards. Step outside to the expansive lattice covered brick patio and rear yard with plenty of room for the grandest of garden parties. Privacy prevails as you enjoy landscaped areas designed with native plants and garden beds. An array of outdoor lighting will let the good times roll into the night. Coveted three car-attached garage features built in storage cabinetry. Enjoy the nearby hiking and biking trails of Claremont Wilderness Park, Thompson Creek Trail, or venture down to the Village to shop, dine and experience all the City of Trees and PHD’s has to offer. Welcome home! More detailsListed by Seven Gables Real Estate- BRIDGETTE CARRILLO
- SEVEN GABLES REAL ESTATE
- 1 (626) 6428861
- Contact by Email
-
176 S 2nd Avenue in Upland: Residential Income for sale (690 - Upland) : MLS®# CV25116962
176 S 2nd Avenue Upland 91786
$1,068,000Residential Income- Status:
- Active Under Contract
- MLS® Num:
- CV25116962
A rare investment opportunity awaits with this well-maintained 4-unit property, ideally located just steps from the vibrant charm of Downtown Upland. Blending functionality, walkable lifestyle appeal, and long-term value, this income-producing asset includes four rental units, three enclosed garage spaces, and additional on-site parking. Each unit—except the upper-level unit—features its own private outdoor space, perfect for relaxing or entertaining. The rear unit is the original single-level home with an attached garage with laundry. Two additional one-bedroom units are located on the ground floor, while the fourth is a bright and airy upstairs one-bedroom. All units offer in-wall A/C and heating units, dual-pane windows, and newer water heaters. The current owners have completed substantial improvements over the past several years, including a new roof, updated garage doors, rain gutters, A/C units and water heaters, new windows, concrete pads, and perimeter wood fencing—minimizing future maintenance and maximizing value. Prime Location & Village Lifestyle: Just 2–3 short blocks to Upland’s Historic Downtown Village with its local farmers market, artisan coffee shops, boutique retail, wine bars, and restaurants. One block from the Upland MetroLink Station—ideal for commuters seeking a convenient rail connection to greater Los Angeles. Easy access to both the 10 and 210 Freeways enhances connectivity to major employment hubs. Whether you're seeking a high-demand rental property or looking to expand your real estate portfolio with a well-located, pride-of-ownership asset, this Upland gem is an investment that truly checks all the boxes. More detailsListed by Seven Gables Real Estate- BRIDGETTE CARRILLO
- SEVEN GABLES REAL ESTATE
- 1 (626) 6428861
- Contact by Email
Data was last updated June 16, 2025 at 02:40 PM (UTC)
Based on information from California Regional Multiple Listing Service, Inc. as of June 16, 2025 at 02:40 PM (UTC) and/or other sources.
All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS.
All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
Office Address:
326 S Myrtle Ave
Monrovia, CA, 91016