Title Page Background
HFQUERY 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 ('usahud','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 ('usahud','ilhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 ('usahud','ilhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

2535 San Clemente Avenue
Vista, CA 92084
Viktoria Bartok Conaway with Coldwell Banker Realty, original listing - (760) 941-6888

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,888,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4665 Square Feet
Agency: Coldwell Banker Realty
Agency Phone: (760) 941-6888

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: . **Luxurious Custom Home in the Exclusive "Hollywood of Vista"** Welcome to your dream home, located in the highly sought-after, "Hollywood of Vista" neighborhood, celebrated for its custom-built homes and upscale charm. This remarkable property offers 5 bedrooms, 4 bathrooms, and an impressive 4,665 square feet of living space, all designed to meet your every need. As you enter, solid wood flooring and high ceilings create a grand first impression. The entryway opens to an elegant, winding staircase turret that leads to a loft overlooking the formal living room which features soaring cathedral ceilings, tall tower windows, and a cozy fireplace. Formal dining room is dressed with French doors to backyard BBQ. Upstairs, you will find three spacious bedrooms ( two with ocean views), while downstairs offers two additional bedrooms—one room with bath and exit door to backyard, other with French doors. A second staircase near the gourmet kitchen provides convenient access to the upper floor and connects to the laundry room and 3-car garage, which includes electric car hookups, epoxy flooring, finished walls and shelves. The kitchen is a culinary haven, boasting high-end appliances(subzero and Viking), granite countertops, and premium-quality tile flooring. Two expansive family rooms—one upstairs and one downstairs—offer abundant space for relaxation and entertainment. The lower-level family room also features a warm and inviting fireplace, perfect for gatherings. The luxurious master suite offers a two-sided fireplace and private balcony with peekaboo ocean views, and the master bathroom provides a spa-like retreat with a soaking tub, a shower- sauna and two sinks for two individuals. This eco-friendly home comes equipped with leased solar panels, which the buyer can assume, and two air conditioning units, one of which is brand new, and build in vacuum system throughout the house. Outside, the fenced and meticulous cared-for backyard provides a private oasis of flora & fauna. It includes a patio with a built-in BBQ area, plus burner with cover lid, complete with countertops, a refrigerator, a fire pit, also, there is ample space for a pool or maybe an ADU. Situated in a tranquil and prestigious neighborhood, this custom home perfectly blends elegance, comfort, modern convenience and safety with set up alarm system and no HOA. The opportunity to own this one-of-a-kind move-in ready property in the heart of Vista. Call Viktoria for appointment, 760-696-2401
MlsNumber: --
ListingId: NDP2504386


Listing Provided By: Coldwell Banker Realty, original listing
Phone: (800) 500-4053
Office Phone: (760) 941-6888
Agent Name: Viktoria Bartok Conaway
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

HFQUERY 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 ('usahud','ilhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC 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