Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 634929
[post_author] => 1
[ListingKey] => 1172036608
[ListingId] => 41136797
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Active
[ModificationTimestamp] => 2026-06-08T08:33:51Z
[RFModificationTimestamp] => 2026-06-08T08:37:49Z
[ListPrice] => 1750000
[BathroomsTotalInteger] => 4
[BathroomsHalf] => 2
[BedroomsTotal] => 3
[LotSizeArea] => 202118
[LivingArea] => 2821
[BuildingAreaTotal] => 0
[City] => Sonora
[PostalCode] => 95370
[UnparsedAddress] => 18450 Lambert Lake Rd., Sonora, California 95370
[Coordinates] => Array
(
[0] => -120.33760204
[1] => 37.95841456
)
[Latitude] => 37.95841456
[Longitude] => -120.33760204
[YearBuilt] => 2000
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Danelle Rodgers
[ListOfficeName] => Coldwell Banker Mother Lode RE
[ListAgentMlsId] => BMLS-Tdaneller
[ListOfficeMlsId] => BMLS-T10713
[OriginatingSystemName] => CRMLS
[PublicRemarks] => Tucked behind mature landscaping in prestigious Whispering Woods, this remarkable almost 5-acre estate offers a rare blend of elegance, recreation, and privacy. The property features a stunning main residence, separate guest home, barn, wine cellar, sparkling pool with pool house and outdoor kitchen, tranquil pond, cascading waterfall, and beautifully curated grounds that feel more like a private resort than a residence. Winding pathways, mature oaks, lush lawns, ivy-covered garden walls, and thoughtfully designed outdoor spaces create a setting that is both peaceful and unforgettable. Whether hosting large gatherings, accommodating multi-generational living, pursuing hobbies in the barn, or simply enjoying the beauty of the surroundings, this one-of-a-kind property offers a lifestyle rarely found in Tuolumne County.
[ArchitecturalStyle] => Custom
[AttachedGarageYN] => 1
[BathroomsFull] => 2
[CLIP] => 2884317313
[ConstructionMaterials] => Masonite
[ContractStatusChangeDate] => 2026-06-01
[Cooling] => Central Air
[CoolingYN] => 1
[CountyOrParish] => Tuolumne
[CreationDate] => 2026-06-02T00:03:33.276097+00:00
[CumulativeDaysOnMarket] => 7
[DaysOnMarket] => 121
[DaysOnMarketReplication] => 7
[DaysOnMarketReplicationDate] => 2026-06-08
[DaysOnMarketReplicationIncreasingYN] => 1
[Directions] => Cross Street: Kelly Loop.
[FireplaceYN] => 1
[Flooring] => Carpet, Stone, Tile
[GarageSpaces] => 2.0
[GarageYN] => 1
[Heating] => Forced Air,Propane,Radiant
[HeatingYN] => 1
[InteriorFeatures] => Breakfast Area
[RFTransactionType] => For Sale
[InternetEntireListingDisplayYN] => 1
[Levels] => Two
[ListAgentAOR] => Tuolumne County Association of REALTORS
[ListAgentDirectPhone] => 209-743-4226
[ListAgentEmail] => danellerodgers@yahoo.com
[ListAgentFirstName] => Danelle
[ListAgentKey] => 31219828
[ListAgentKeyNumeric] => 31219828
[ListAgentLastName] => Rodgers
[ListAgentOfficePhone] => 209-532-6993
[ListAgentStateLicense] => 01307805
[ListAgentURL] => https://www.DanelleRodgers.com
[ListOfficeAOR] => Tuolumne County Association of REALTORS
[ListOfficePhone] => 209-532-6993
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-06-01
[ListingKeyNumeric] => 1172036608
[ListingService] => Full Service
[ListingTerms] => Cash, Conventional
[LotFeatures] => Back Yard,Front Yard,Garden,Sprinklers Timer,Street Level,Yard
[LotSizeAcres] => 4.64
[LotSizeSquareFeet] => 202118
[MlsStatus] => Active
[OccupantType] => Owner
[OnMarketDate] => 2026-06-01
[OnMarketTimestamp] => 2026-06-01T16:58:42Z
[OriginalEntryTimestamp] => 2026-06-01T16:42:40Z
[OriginalListPrice] => 1750000
[OriginatingSystemID] => BMLS
[OriginatingSystemKey] => 437439537
[OriginatingSystemSubName] => CRMLS_BMLS
[OtherStructures] => Guest House
[ParcelNumber] => 097320002000
[ParkingFeatures] => Garage,Garage Door Opener
[ParkingTotal] => 2.0
[PatioAndPorchFeatures] => Front Porch,Patio,Porch
[PhotosChangeTimestamp] => 2026-06-02T00:01:45Z
[PoolFeatures] => In Ground
[Possession] => Negotiable
[PostalCity] => SONORA
[PreviousListPrice] => 1750000
[PriceChangeTimestamp] => 2026-05-31T17:00:00Z
[PropertySubTypeAdditional] => Single Family Residence
[RoomType] => Bonus Room,Office
[ShowingContactName] => Danelle Rodgers
[ShowingContactPhone] => 2097434226
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1172036608
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2026-06-07T17:00:00Z
[Stories] => 2
[StreetName] => Lambert Lake Rd.
[StreetNumber] => 18450
[StreetNumberNumeric] => 18450
[UniversalPropertyId] => US-06109-N-097320002000-R-N
[WaterfrontFeatures] => Pond
[CustomFields] => {
"RoomType": "Bonus Room,Office",
"EatingArea": "Breakfast Nook",
"AdminUpdateYN": "0",
"ListingKey": "1172036608"
}
[PricePerArea] => 620.35
[HumanModifiedYN] =>
[PricePerAreaUnit] => Dollars Per Square Foot
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1172036608')
[CurrentPrice] => 1750000
[provider_name] => CRMLS
[RecordSignature] => -1862270634
[UniversalParcelId] => urn:reso:upi:2.0:US:06109:097320002000
[CountrySubdivision] => 06109
[OriginatingSystemListAgentMemberKey] => 433328495
[ID] => 634929
)