Title Page Background
DEBUG FN args: Array ( [0] => 224 [1] => [2] => [3] => agent ) BEFORE: Site: 224 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 224 Igate: njhud LocID: 224 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 224 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 224 [1] => [2] => [3] => lender ) BEFORE: Site: 224 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 224 Igate: njhud LocID: 224 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 224 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 224 [1] => [2] => [3] => other ) BEFORE: Site: 224 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 224 Igate: njhud LocID: 224 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 224 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

334 Old Stagecoach Run
Alpine, CA 91901
Terri Pontzious with Willis Allen Real Estate, original listing - (619) 238-8065

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,450,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active Under Contract
SqFt: 3374 Square Feet
Agency: Willis Allen Real Estate
Agency Phone: (619) 238-8065

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Resort-Style Living in One of Alpine’s Premier Communities! This is the dream home you’ve been waiting for—where every day, it feels like a vacation! Nestled in one of Alpine’s most desirable neighborhoods, this single-level beauty on a 2.85-acre lot offers spectacular panoramic views to the west. Imagine relaxing evenings with picture-perfect sunsets—yes, they’re as stunning as they sound!Step inside to soaring vaulted ceilings and a bright, open layout that blends comfort with elegance. The formal living room with cozy fireplace and the adjoining dining room set the stage for gracious entertaining. Just beyond, the heart of the home awaits—a spacious kitchen and second living area that’s perfect for gatherings. You’ll love the granite counters, large center island, stainless steel appliances, garden window, and thoughtful touches like a Lazy Susan, pullout shelves, and solid oak cabinetry. A 6-burner Jenn-Air cooktop makes cooking a breeze!The second living space features built-in entertainment, a warm fireplace with wood-burning stove, and breathtaking views of the resort-style backyard—including an infinity-edge pool, bubbling spa, and a palapa that’s ready for poolside fun. There’s also a flexible bonus room—ideal for a home office, game room, or creative space.Tucked away for privacy, the luxurious primary suite is a serene retreat with its own sitting area and fireplace. The en-suite bathroom is truly spa-worthy with two walk-in closets, a soaking tub, walk-in shower, dual vanities, and direct access to the pool and spa—your own private oasis.Three additional bedrooms and two full baths, including a Jack & Jill, offer comfort and convenience for family and guests.And there’s so much more!This home features an owned solar system, natural gas, a well for irrigation (with municipal water from Padre Dam for household use), and a bounty of fruit and avocado trees. The property is gated, fenced and cross-fenced, and includes two driveways—one with RV parking and hookups. The 4-car garage includes a workshop area, while the indoor laundry room provides plenty of storage and a deep sink. A whole-house Waterboy filtration system, dual-zone heating and air, fire sprinklers, and Wi-Fi controls for the pool lights and music system add to the comfort and convenience. And when the rain comes—you just might enjoy your own seasonal waterfall!This is truly a one-of-a-kind home where luxury meets lifestyle. Come see it for yourself—you’ll never want to leave!
MlsNumber: --
ListingId: PTP2503793


Listing Provided By: Willis Allen Real Estate, original listing
Phone: (858) 459-4033
Office Phone: (619) 238-8065
Agent Name: Terri Pontzious
Disclaimer: Copyright © 2025 California Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Mortgage Pro

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => san-diego-greater [3] => CA [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: san-diego-greater State: CA Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: san-diego-greater State: CA Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 224 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Damian Enrique Diaz NMLS#1085614
Damian Enrique Diaz NMLS#1085614
ASCIILoan Factory
Call Today!: (760) 505-0284

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App