Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 836952
[post_author] => 1
[ListingKey] => 1195470209
[ListingId] => PW26247686
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Active
[ModificationTimestamp] => 2026-11-21T14:12:02Z
[RFModificationTimestamp] => 2026-11-21T14:16:59Z
[ListPrice] => 399999
[BathroomsTotalInteger] => 2
[BathroomsHalf] => 0
[BedroomsTotal] => 2
[LotSizeArea] => 5227
[LivingArea] => 1128
[BuildingAreaTotal] => 0
[City] => Palm Desert
[PostalCode] => 92211
[UnparsedAddress] => 78582 Hampshire, Palm Desert, California 92211
[Coordinates] => Array
(
[0] => -116.293177
[1] => 33.761003
)
[Latitude] => 33.761003
[Longitude] => -116.293177
[YearBuilt] => 2002
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => James McCormick
[ListOfficeName] => Real Broker
[ListAgentMlsId] => ZMCCOJAM
[ListOfficeMlsId] => PB14811
[OriginatingSystemName] => CRMLS
[PublicRemarks] => An artist inspired modern, hip retreat, this gorgeous revamped home in award-winning Sun City, hits the senses the second you enter. Sunlight bounces off the high gloss marblesque tile floors, the open-air layout pulls the eye straight to the private pool and two cascading waterfalls that become your daily soundtrack. Reimagined with a youthful, Palm Springs hip vibe, this home offers retirement luxury living with style. Renovated with gorgeous finishes and an artist’s personal touch, this home offers a fresh, elevated lifestyle including its own private saltwater pool. 2024 Upgrades include: 24-inch marble look tile throughout, bright white plantation shutters, new doors, 6-inch wood trim, new lighting, and crisp white interior paint. The kitchen and laundry rooms feature stainless LG top of the line appliances. Both bedrooms have mini splits; the primary closet has been reimagined with a vanity area, floor to ceiling mirrors, and an accent wall and chandelier. Outdoors, enjoy a private pool with two cascading waterfalls and a freshly painted deck designed to keep feet and paws cool. The garage includes a flexible nook perfect for a golf cart, workshop, or craft space and a NEW AC/Heat Pump installed in 2023. With Sun City’s award-winning amenities including golf, dining, fitness centers, pools, tennis/pickleball courts and 100+ private clubs, this home delivers a modern, design forward living experience that stands apart. Optional turnkey furnishings and golf cart available outside escrow. Investors 45 and up can purchase in this 55
[AssociationAmenities] => Clubhouse,Dog Park,Fitness Center,Fire Pit,Golf Course,Game Room,Meeting/Banquet/Party Room,Picnic Area,Pickleball,Pool,Sauna,Spa/Hot Tub
[AssociationFee] => 532.5
[AssociationFeeFrequency] => Monthly
[AssociationPhone] => 7602002200
[AssociationYN] => 1
[AttachedGarageYN] => 1
[AttributionContact] => 562-400-3468
[BathroomsFull] => 2
[CLIP] => 4604481106
[CommonInterest] => None
[CommonWalls] => No Common Walls
[CommunityFeatures] => Biking,Curbs,Dog Park,Fishing,Golf,Lake,Park
[Contingency] => This is a short sale subject to and contingent on lender approval.
[ContractStatusChangeDate] => 2026-11-20
[Cooling] => Central Air
[CoolingYN] => 1
[Country] => US
[CountyOrParish] => Riverside
[CreationDate] => 2026-11-21T14:16:47.561481+00:00
[CumulativeDaysOnMarket] => 76
[DaysOnMarket] => 1
[DaysOnMarketReplication] => 1
[DaysOnMarketReplicationDate] => 2026-11-21
[DaysOnMarketReplicationIncreasingYN] => 1
[Directions] => Manorgate Rd to Devin Rd to Hampshire
[ElevationUnits] => Feet
[EntryLevel] => 1
[EntryLocation] => Lower
[FireplaceFeatures] => None
[GarageSpaces] => 2.0
[GarageYN] => 1
[Heating] => Central
[HeatingYN] => 1
[HighSchoolDistrict] => Oak Grove
[InteriorFeatures] => All Bedrooms Down
[RFTransactionType] => For Sale
[InternetAutomatedValuationDisplayYN] => 1
[InternetConsumerCommentYN] => 1
[InternetEntireListingDisplayYN] => 1
[LaundryFeatures] => Inside
[Levels] => One
[ListAgentAOR] => Pacific West
[ListAgentDirectPhone] => 562-400-3468
[ListAgentEmail] => JMC@Mccfin.com
[ListAgentFax] => 562-496-1366
[ListAgentFirstName] => James
[ListAgentKey] => 17068931
[ListAgentKeyNumeric] => 17068931
[ListAgentLastName] => Mc Cormick
[ListAgentOfficePhone] => 619-248-6434
[ListAgentOfficePhoneExt] => 0
[ListAgentPager] => 562-400-3468
[ListAgentStateLicense] => 00804012
[ListAgentURL] => www.sunbelt1.com
[ListAgentVoiceMailExt] => 0
[ListOfficeAOR] => Pacific West
[ListOfficeEmail] => cabroker@therealbrokerage.com
[ListOfficeKey] => 3268016
[ListOfficeKeyNumeric] => 3268016
[ListOfficePhone] => 619-248-6434
[ListOfficePhoneExt] => 0
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-11-20
[ListingKeyNumeric] => 1195470209
[ListingService] => Full Service
[ListingTerms] => Cash,Cash to New Loan,Conventional,Subject To Other
[LivingAreaSource] => Assessor
[LivingAreaUnits] => SquareFeet
[LotFeatures] => 0-1 Unit/Acre
[LotSizeAcres] => 0.12
[LotSizeSource] => Assessor
[LotSizeSquareFeet] => 5227
[LotSizeUnits] => SquareFeet
[MLSAreaMajor] => 307 - Sun City
[MainLevelBathrooms] => 2
[MainLevelBedrooms] => 2
[MajorChangeTimestamp] => 2026-11-20T17:36:29Z
[MajorChangeType] => New Listing
[MlsStatus] => Active
[NumberOfUnitsTotal] => 4985
[OccupantType] => Owner
[OnMarketDate] => 2026-11-20
[OnMarketTimestamp] => 2026-11-20T17:36:29Z
[OriginalEntryTimestamp] => 2026-11-20T17:36:29Z
[OriginalListPrice] => 399999
[OriginatingSystemID] => CRM
[OriginatingSystemKey] => 833456496
[OriginatingSystemSubName] => CRMLS_CRM
[ParcelNumber] => 748420064
[ParkingTotal] => 2.0
[PhotosChangeTimestamp] => 2026-11-21T01:41:50Z
[PoolFeatures] => Gunite,Heated,In Ground,Private,Salt Water,Association
[PoolPrivateYN] => 1
[PostalCity] => PALM DESERT
[PropertySubTypeAdditional] => Single Family Residence
[RoomType] => Bedroom
[SeniorCommunityYN] => 1
[Sewer] => Unknown
[ShowingContactName] => Melissa
[ShowingContactPhone] => 7608957109
[ShowingContactType] => Occupant, Owner
[SignOnPropertyYN] => 1
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1195470209
[SpecialListingConditions] => Short Sale
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2026-11-20T17:36:29Z
[Stories] => 1
[StoriesTotal] => 1
[StreetName] => Hampshire
[StreetNumber] => 78582
[StreetNumberNumeric] => 78582
[StructureType] => House
[SubdivisionName] => Sun City
[TaxLot] => 120
[TaxOtherAnnualAssessmentAmount] => 421.0
[UniversalPropertyId] => US-06065-N-748420064-R-N
[View] => None
[YearBuiltSource] => Assessor
[CustomFields] => {
"RoomType": "All Bedrooms Down",
"DPResourceYN": "1",
"AdminUpdateYN": "0",
"SellerConsiderConcessionYN": "1",
"ListingKey": "1195470209"
}
[PricePerArea] => 354.61
[HumanModifiedYN] =>
[PricePerAreaUnit] => Dollars Per Square Foot
[ThirdPartyIntegrationType] => Down Payment Resource
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1195470209')
[CurrentPrice] => 399999
[provider_name] => CRMLS
[short_address] => Palm Desert, California 92211, US
[RecordSignature] => 807226257
[UniversalParcelId] => urn:reso:upi:2.0:US:06065:748420064
[CountrySubdivision] => 06065
[OriginatingSystemListOfficeKey] => 86290
[OriginatingSystemListAgentMemberKey] => 299809
[ID] => 836952
)