My Company's Active Listings

$1,999,000
Active

Glenmoor Area Single Family Home

Active

38388 Logan Dr Fremont, CA 94536

5 Bed
3 Baths
2052 sqft
MLS# 41104397
Virtual Tour
Located in one of Fremont’s most sought-after neighborhoods, this gorgeous Glenmoor single-story home offers the ideal blend of comfort, space, and modern upgrades. Filled with natural light, the thoughtfully designed floor plan offers generous space ideal for multi-generational living, featuring separate living areas and two private entrances. Notable upgrades include freshly painted interior and exterior, central heating and air conditioning, a Nest thermostat, recessed lighting, and energy-efficient dual-pane windows. The beautifully updated kitchen offers sleek white cabinetry, quartz countertops and backsplash, and stainless steel appliances. Additional enhancements include luxury vinyl flooring, durable tile flooring, and updated modern light fixtures. Step outside to discover spacious front and back yards with mature fruit trees, a charming flagstone patio, large storage shed, and raised flower beds - perfect for peaceful gardening and outdoor gatherings! This home is in an excellent location, walking distance to great schools, community parks, playgrounds, tennis courts & pools! Perfect for commuters with access to nearby 880, Dumbarton Bridge, BART & Centerville Train Station. Don’t miss this rare opportunity in the Glenmoor neighborhood - this home is a must see!
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Lester Belliveau
$1,999,000
Pending

Santa Clara Area Detached Single Family

Pending

798 Orkney Avenue Santa Clara, CA 95054

5 Bed
3 Baths
2591 sqft
MLS# ML82010934
Welcome to 798 Orkney Avenue a thoughtfully updated home offering 5 bedrooms, 3 full bathrooms, and approx. 2,591 square feet of living space on a generous approx, 7,200 square foot lot. Perfectly situated near Montague Elementary, Montague Expressway, and Highway 101, this home combines comfort, convenience, and flexibility for a variety of lifestyles. The home features two spacious primary suites, ideal for multigenerational living or guest accommodations. Three bedrooms and two full bathrooms are located on the main level, providing easy access and a practical layout for everyday living. Upstairs, the luxurious second primary suite boasts a spa-like bathroom with heated floors and a jetted tub, a large walk-in closet, and a private balcony overlooking the front yard - your own personal retreat. Enjoy a bright and inviting formal living room, perfect for entertaining, and a spacious family room with a cozy fireplace for relaxing nights at home. The functional layout allows for seamless flow between living spaces, giving the home a warm and welcoming feel. Outside, the expansive yard offers a spa, RV parking, plenty of room for outdoor entertaining, and an attached two-car garage for added convenience. The attached two-car garage and large shed provide great storage space.
Listing Courtesy of MLSlistings Inc. / Coldwell Banker Realty / Derek Essary
$1,998,800
Active

Brisbane Area Detached Single Family

Active

33 Lupine Valley Court Brisbane, CA 94005

4 Bed
3 Baths
2830 sqft
MLS# ML82012670
Virtual Tour
Experience breathtaking views of San Bruno Mountain and luxurious living in this stunning two-story Landmark at the Ridge home. Upon entering, youll be welcomed into a bright open floor plan, ideal for hosting elegant dinner parties or casual gatherings. Built in 2004, this desirable home offers roughly 2,830 sq ft, 4 bedrooms and 2.5 bathrooms. The main level features wide plank luxury vinyl flooring, recessed lights and a dining area that flows into the living room with a cozy gaslit fireplace, creating a warm ambiance on cool evenings. The gourmet eat-in kitchen is a chefs dream, boasting a center aisle with a 5-burner GE Monogram cooktop, sleek black granite counters, stainless steel appliances, maple cabinets, and expansive deck, great for al fresco dining. Adjacent to the kitchen is a family room with a gaslit fireplace, ideal for movie nights, a guest powder room and oversize 2-car garage with storage racks. The lower level boasts 4 bedrooms, including a huge primary suite with spectacular mountain views and sliding doors that open to the deck. A spa-like bathroom features dual vanity sinks, Jacuzzi tub, walk-in shower, walk-in closet, laundry room, hall bath & storage room. Close to SSF Biotech Firms, San Francisco, Silicon Valley, freeways, Caltrain, trails and more.
Listing Courtesy of MLSlistings Inc. / Coldwell Banker Realty / Jo-Ann DeRewenda