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 = 3349 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 = 3349 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 = 3349 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;

315 Big Canyon Drive N
Palm Springs, CA 92264

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,995,000
Beds: 4
Baths: 5
Status: Active
SqFt: 2650
Agency: HomeSmart Professionals

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2004
Notes: Enjoy a GREAT LOCATION with SPECTACULAR MOUNTAIN VIEWS blocks from Downtown Palm Springs! This 4 bedroom home features a detached casita, pebble tech salt water pool and spa. It is nestled on the inside corridor of the private gated Canyons at Belardo. Enter a serene garden patio with fountain to the private front door. The Great Room features 12-foot ceilings with crown molding, a limestone fireplace, porcelain tiles and built-in entertainment center/bookcase. The kitchen has a center sink island, stainless steel appliances, granite counters and plenty of cabinets. A separate formal dining room, and/or entertainment room, affords a view of the private front patio. The large Master features floor-to-ceiling sliding window shutters and sliders to the back yard, walk-in closet, spacious bath, travertine tile counters, separate shower and soaking tub. Each of the two in-house bedrooms afford its own private bathroom. French doors from the great room lead to the covered patio with a misting system. The lush tropical back yard includes a built-in bbq and a firepit. Large granite boulders, palms and plants highlight the pool and cascading waterfall. The spacious detached casita has a full bath and affords privacy and ample room for guests. The 3-car garage and long driveway provides additional plentiful parking. Seller is Owner/Licensed Real Estate Agent Enjoy a GREAT LOCATION with SPECTACULAR MOUNTAIN VIEWS blocks from Downtown Palm Springs! This 4-bedroom home features a detached casita, salt water pool and spa. It is nestled on the inside corridor of the private gated Canyons at Belardo. Enter the serene garden patio with trickling fountain to the private front door entrance. The Great Room features 12-foot ceilings with crown molding, a limestone fireplace, porcelain tiles on the vertical and built-in entertainment center/bookcase. The kitchen is complete with center sink island, stainless steel appliances, granite counters and plenty of cabinets. Enjoy views to the tropical pool paradise and mountains from the breakfast area. A separate formal dining room, and/or entertainment room, affords a view of the private front patio. The large Master features floor-to-ceiling sliding window shutters and sliders to the back yard, a designer walk-in closet, a spacious bath, 2 sinks with travertine tile, separate shower and soaking tub. A separate powder room is down the hall for convenience and privacy. Each of the large two in-house bedrooms affords its own private bathroom, one with a full bath, the other with shower. French doors from the great room lead to the covered patio with a misting system for cooling. The lush tropical back yard includes a built-in bbq and a firepit for entertaining. Enjoy SPECTACULAR mountain views from the pebble tech pool and spa. Large granite boulders, palms and plants encompass the pool and cascading waterfall. The spacious detached casita has a full bath and affords privacy and ample room for guests. The 3-car garage and long driveway provides additional plentiful parking. Seller is Owner/Licensed Real Estate Agent
MlsNumber: 219102241


Listing Provided By: HomeSmart Professionals, original listing
Name: HomeSmart Professionals
Phone: (760) 844-7500
Office Name: HomeSmart
Office Phone: (760) 844-7500
Agent Name: Mary Ann Rojo
Disclaimer: Copyright © 2024 California Desert Association of REALTORS ®, 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 Real Estate Expert

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 = 3349 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 Stacy Wolfson
Stacy Wolfson
ASCIIeXp Realty - The Wolfson Luxury Group
Call Today!: (813) 240-8888

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App