querybuilder
-
1871 Park Drive in Los Angeles: Residential Income for sale (C21 - Silver Lake - Echo Park) : MLS®# AR24240418
1871 Park Drive Los Angeles 90026 
$1,198,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
-
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
$579,995Residential- Status:
- Active Under Contract
- 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 Under Contract
- 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
-
5140 N Clydebank Avenue in Covina: Residential for sale (614 - Covina) : MLS®# AR25141367
5140 N Clydebank Avenue Covina 91722
$695,000Residential- Status:
- Active
- MLS® Num:
- AR25141367
- Bedrooms:
- 3
- Bathrooms:
- 2
- Floor Area:
- 1,198 sq. ft.
Discover this 1958 single-story ranch home in a pleasant Covina neighborhood. This charming residence offers 1,198 square feet with 3 bedrooms and 2 bathrooms. The interior offers a traditional layout, featuring a galley-style kitchen, an adjacent breakfast nook, a comfortable living room, and a convenient laundry room. Enjoy outdoor living with a quaint front porch and a spacious rear covered patio. An attached garage provides ample parking and storage. Needing some updates, this home is an ideal opportunity for owner-occupants and investors alike. Sold as-is. More detailsListed by Seven Gables Real Estate- BRIDGETTE CARRILLO
- SEVEN GABLES REAL ESTATE
- 1 (626) 6428861
- Contact by Email
-
4800 Daleview Avenue Unit 157 in El Monte: Manufactured In Park for sale (619 - El Monte) : MLS®# AR25137319
4800 Daleview Avenue Unit 157 El Monte 91731
$249,000Manufactured In Park- Status:
- Active
- MLS® Num:
- AR25137319
- Bedrooms:
- 2
- Bathrooms:
- 2
- Floor Area:
- 1,368 sq. ft.
This comfortable mobile home is located in the desirable Daleview Estates 55+ senior park. The welcoming front door opens to an entry and a bright living room with a row of windows allowing for plenty of natural light. The home offers a well-designed floor plan featuring an inviting dining area with a built-in hutch, and a spacious kitchen with ample cupboard space, quartz countertops, double stainless steel sink, tile floor, pantry, dishwasher, cooktop and a stainless steel refrigerator. The open family room has a sliding glass door for easy access to the carport. The home offers 2 large bedrooms, each with its own bathroom. The primary bedroom suite has a wall-length wardrobe closet, a sliding glass door leading to the side yard, and a private bathroom with walk-in closet, dressing area, an expansive vanity and double sinks. Other amenities include 1,368 square feet of living space, wood laminate flooring, laundry area with washer and dryer, a ceiling fan and central air and heat. The exterior space includes a covered front porch, 2-car carport parking and 2 storage sheds. The bonus feature of this property is the expansive side-yard brick patio. The park has a community pool and spa, clubhouse, plenty of guest parking, a walking trail with sitting areas among lush gardens, and a covered barbecue area with picnic tables for outside entertaining. More detailsListed by Seven Gables Real Estate- BRIDGETTE CARRILLO
- SEVEN GABLES REAL ESTATE
- 1 (626) 6428861
- Contact by Email
-
2236 Saratoga Lane in Glendora: Residential for sale (629 - Glendora) : MLS®# AR25143266
2236 Saratoga Lane Glendora 91741
$1,600,000Residential- Status:
- Active
- MLS® Num:
- AR25143266
- Bedrooms:
- 4
- Bathrooms:
- 3
- Floor Area:
- 2,988 sq. ft.
Welcome to Elevated Living in Glendora's Prestigious Saratoga Estates Discover refined comfort and timeless elegance in this beautifully designed single-story residence nestled in the exclusive, gated community of Saratoga Estates. Built in 2005, this home blends thoughtful design, upscale finishes, and everyday functionality to deliver a true resort-style lifestyle in one of Glendora’s most sought-after neighborhoods, located adjacent to the esteemed Glendora Country Club. Spanning nearly 3,000 sq. ft. of open-concept living space, this 4-bedroom, 3-bathroom home is perfectly situated on a generous 10,101 sq. ft. lot with lush landscaping, a custom-built patio, and outdoor entertaining areas. Step into the great room, a welcoming central space with soaring ceilings, gleaming hardwood floors, a fireplace, and expansive windows with automatic custom blinds that flood the room with natural light. The gourmet kitchen offers an ideal space for everyday living and entertaining, featuring European-style cabinetry with pull-out shelves, granite countertops, a center island, GE Monogram stainless steel appliances, and a large walk-in pantry. The primary suite offers a peaceful retreat with French doors that open to the backyard, creating a sense of seamless indoor-outdoor living. The en suite bathroom evokes spa-like relaxation with a soaking tub, dual vanities, a separate walk-in shower, and a large walk-in closet. Other highlights include formal living and dining rooms with elegant details, a separate laundry room with utility sink, dual-zone HVAC, a three-car garage, and an oversized driveway with ample guest parking. Enjoy exclusive access to community amenities including private entry gates, a picnic area, basketball court, and tot lot, located within the boundaries of the award-winning Glendora Unified School District. 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,100,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
-
647 Ridgefield Dr in Claremont: Residential for sale (683 - Claremont) : MLS®# CV25140822
647 Ridgefield Dr Claremont 91711
$985,000Residential- Status:
- Active
- MLS® Num:
- CV25140822
- Bedrooms:
- 4
- Bathrooms:
- 2
- Floor Area:
- 1,500 sq. ft.
Live the dream of sun kissed Socal summers relaxing in the private backyard resort of this single-story gem. Chill by the sparkling pool during long summer days, grill on the built in BBQ island for an al fresco dinner, and enjoy a bubbling spa under the stars at night. The versatile four-bedroom split wing floor plan offers one bedroom and ¾ bath ideal for guests, extended family or private home office. Interior accents include four sets of custom bay windows to bring in the view, and gleaming hardwood floors newly refinished. A raised hearth stacked stone fireplace warms the living and dining rooms. The bright and cheery kitchen has a view of the rear yard and offers abundant wood cabinetry and cozy built in banquette nook. Both baths have been remodeled, including a gorgeous primary bath with tiled walk-in shower. The owner has made many recent updates to the property, including HVAC, electrical and pool. Park-like rear yard nearly ¼ acre offers a private setting with room to entertain in multiple patio areas and lawn for kids and pets to play. Attractive waterwise landscaping in front and large concrete driveway allows for extra vehicle parking. This property is in the acclaimed Claremont School District, and within walking distance to Sumner Elementary. Griffith Park is just around the corner, and you can catch the Thompson Creek trail for hiking and biking access into the local foothills. The vibrant downtown Claremont Village has an array of restaurants, art galleries, bakeries and boutiques to enjoy year-round. A rare find! More detailsListed by Seven Gables Real Estate- BRIDGETTE CARRILLO
- SEVEN GABLES REAL ESTATE
- 1 (626) 6428861
- Contact by Email
Data was last updated July 2, 2025 at 12:40 AM (UTC)
Based on information from California Regional Multiple Listing Service, Inc. as of July 2, 2025 at 12:40 AM (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