GRAND 2-STORY DUMONT PLAN WITH EXPERT PRIVACY ARCHITECTURE! Welcome to the flagship Dumont layout by Seeno Homes (Est. 1938) The main level includes a private bedroom and adjacent full bath. Upstairs, the smart engineering ensures absolute privacy: all second-floor bedrooms are positioned at separate corners of the home with zero adjoining bedroom walls. A central bonus loft and dedicated laundry room complete the upper level. AMENITIES & LOCATION: $0 HOA! NO Mello-Roos! Enjoy huge monthly savings with a fully owned solar panel array included in the purchase price, a lower local tax base, and advanced energy-efficient dual-zone HVAC systems. Located steps from the future municipal park and within the top-tier Liberty Union school district. Experience premium estate living. Schedule a showing today!
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 664329
[post_author] => 1
[ListingKey] => 1175504296
[ListingId] => 41139185
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Active
[ModificationTimestamp] => 2026-09-30T15:43:57Z
[RFModificationTimestamp] => 2026-09-30T15:45:09Z
[ListPrice] => 983190
[BathroomsTotalInteger] => 4
[BathroomsHalf] => 0
[BedroomsTotal] => 5
[LotSizeArea] => 6490
[LivingArea] => 3248
[BuildingAreaTotal] => 0
[City] => Oakley
[PostalCode] => 94561
[UnparsedAddress] => 3559 Cloverbrook Ave, Oakley, California 94561
[Coordinates] => Array
(
[0] => -121.70942975
[1] => 37.9774295
)
[Latitude] => 37.9774295
[Longitude] => -121.70942975
[YearBuilt] => 2026
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => John Arcidiacono
[ListOfficeName] => Seecon Realty, Inc
[ListAgentMlsId] => CCBE-159510820
[ListOfficeMlsId] => CCBE-CCSRIJA
[OriginatingSystemName] => CRMLS
[PublicRemarks] => GRAND 2-STORY DUMONT PLAN WITH EXPERT PRIVACY ARCHITECTURE! Welcome to the flagship Dumont layout by Seeno Homes (Est. 1938) The main level includes a private bedroom and adjacent full bath. Upstairs, the smart engineering ensures absolute privacy: all second-floor bedrooms are positioned at separate corners of the home with zero adjoining bedroom walls. A central bonus loft and dedicated laundry room complete the upper level. AMENITIES & LOCATION: $0 HOA! NO Mello-Roos! Enjoy huge monthly savings with a fully owned solar panel array included in the purchase price, a lower local tax base, and advanced energy-efficient dual-zone HVAC systems. Located steps from the future municipal park and within the top-tier Liberty Union school district. Experience premium estate living. Schedule a showing today!
[Appliances] => Electric Water Heater
[ArchitecturalStyle] => Traditional
[AttachedGarageYN] => 1
[BathroomsFull] => 4
[CLIP] => 4718573524
[CompensationComments] => 403 Longhorn Way, Oakley, CA 94561. Hours: 10AM-6PM daily, Weds: 1PM-6PM. Call 925.446.6174 for more
[ContractStatusChangeDate] => 2026-06-22
[Cooling] => Central Air
[CoolingYN] => 1
[CountyOrParish] => Contra Costa
[CreationDate] => 2026-06-22T19:40:58.901014+00:00
[CumulativeDaysOnMarket] => 100
[DaysOnMarket] => 100
[DaysOnMarketReplication] => 100
[DaysOnMarketReplicationDate] => 2026-09-30
[DaysOnMarketReplicationIncreasingYN] => 1
[Directions] => Cross Street: Rose & Longhorn.
[FireplaceFeatures] => Family Room,Gas
[FireplaceYN] => 1
[FoundationDetails] => Slab
[GarageSpaces] => 3.0
[GarageYN] => 1
[Heating] => Forced Air
[HeatingYN] => 1
[InteriorFeatures] => Eat-in Kitchen
[RFTransactionType] => For Sale
[InternetEntireListingDisplayYN] => 1
[Levels] => Two
[ListAgentAOR] => Contra Costa
[ListAgentDirectPhone] => 925-203-0462
[ListAgentEmail] => jarcidiacono@seenohomes.com
[ListAgentFirstName] => John
[ListAgentKey] => 21677581
[ListAgentKeyNumeric] => 21677581
[ListAgentLastName] => Arcidiacono
[ListAgentOfficePhone] => 925-671-7711
[ListAgentStateLicense] => 01367796
[ListOfficeAOR] => Contra Costa
[ListOfficeKey] => 5108622
[ListOfficeKeyNumeric] => 5108622
[ListOfficePhone] => 925-671-7711
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-06-22
[ListingKeyNumeric] => 1175504296
[ListingService] => Full Service
[ListingTerms] => Cash,Conventional,1031 Exchange,FHA,VA Loan
[LotFeatures] => Back Yard
[LotSizeAcres] => 0.149
[LotSizeSource] => Builder
[LotSizeSquareFeet] => 6490
[MlsStatus] => Active
[NewConstructionYN] => 1
[OnMarketDate] => 2026-06-22
[OnMarketTimestamp] => 2026-06-22T12:28:35Z
[OriginalEntryTimestamp] => 2026-06-22T12:19:39Z
[OriginalListPrice] => 983190
[OriginatingSystemID] => CCBE
[OriginatingSystemKey] => 443665341
[OriginatingSystemSubName] => CRMLS_CCBE
[ParcelNumber] => 0345700371
[ParkingFeatures] => Garage,Garage Door Opener
[ParkingTotal] => 3.0
[PhotosChangeTimestamp] => 2026-06-22T19:30:42Z
[PhotosCount] => 1
[PoolFeatures] => None
[Possession] => Close Of Escrow
[PostalCity] => OAKLEY
[PreviousListPrice] => 983190
[PriceChangeTimestamp] => 2026-06-21T17:00:00Z
[PropertySubTypeAdditional] => Single Family Residence
[Roof] => Tile
[ShowingContactName] => Stonewood Sales Center
[ShowingContactPhone] => 925.446.6174
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1175504296
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2026-06-28T17:00:00Z
[Stories] => 2
[StreetName] => Cloverbrook Ave
[StreetNumber] => 3559
[StreetNumberNumeric] => 3559
[SubdivisionName] => Not Listed
[UniversalPropertyId] => US-06013-N-0345700371-R-N
[VirtualTourURLBranded] => https://www.seenohomes.com/homes/oakley/the-preserve-at-stonewood/3559-cloverbrook-ave
[WindowFeatures] => Screens
[CustomFields] => {
"EatingArea": "In Kitchen",
"RoomKitchenFeatures": "Kitchen Island",
"RoomBathroomFeatures": "Shower in Tub,Separate tub and shower,Double sinks in bath(s)",
"AdminUpdateYN": "0",
"ListingKey": "1175504296"
}
[PricePerArea] => 302.71
[HumanModifiedYN] =>
[PricePerAreaUnit] => Dollars Per Square Foot
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1175504296')
[CurrentPrice] => 983190
[provider_name] => CRMLS
[RecordSignature] => 940245140
[UniversalParcelId] => urn:reso:upi:2.0:US:06013:0345700371
[CountrySubdivision] => 06013
[OriginatingSystemListOfficeKey] => 370193253
[OriginatingSystemListAgentMemberKey] => 370222131
[Media] => Array
(
[0] => Array
(
[Order] => 1
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2005610354195
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1175504296/c2186e9b9be73f46e84a87f42837f208.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 98219
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1175504296/thumbnail-c2186e9b9be73f46e84a87f42837f208.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 21677581
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5108622
[MediaCategory] =>
[MediaObjectID] => 0.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => CCBE-CCSRIJA
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2005610354195
[PropertySubType] => Single Family Residence
[RecordSignature] => -1932057232
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => 41139185
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1175504296
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => CCBE
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-06-22T19:30:40.990-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_CCBE
[ResourceRecordKeyNumeric] => 1175504296
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 443665341
[PropertySubTypeAdditional] => Single Family Residence
[MediaModificationTimestamp] => 2026-06-22T19:30:40.990-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 443665341
)
)
[ID] => 664329
)
MLS On The Fly Debug Panel
Array
(
[RF Query: /Property?$select=ALL&$top=20&$filter=(StandardStatus eq 'Active' or (ListAgentMlsId eq 'ZHOCHHOY') or (ListAgentMlsId eq 'CDAR-D81064')) and ListingKey eq 1175504296 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true] => Array
(
[RF Response] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse Object
(
[items] => Array
(
[0] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 664329
[post_author] => 1
[ListingKey] => 1175504296
[ListingId] => 41139185
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Active
[ModificationTimestamp] => 2026-09-30T15:43:57Z
[RFModificationTimestamp] => 2026-09-30T15:45:09Z
[ListPrice] => 983190
[BathroomsTotalInteger] => 4
[BathroomsHalf] => 0
[BedroomsTotal] => 5
[LotSizeArea] => 6490
[LivingArea] => 3248
[BuildingAreaTotal] => 0
[City] => Oakley
[PostalCode] => 94561
[UnparsedAddress] => 3559 Cloverbrook Ave, Oakley, California 94561
[Coordinates] => Array
(
[0] => -121.70942975
[1] => 37.9774295
)
[Latitude] => 37.9774295
[Longitude] => -121.70942975
[YearBuilt] => 2026
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => John Arcidiacono
[ListOfficeName] => Seecon Realty, Inc
[ListAgentMlsId] => CCBE-159510820
[ListOfficeMlsId] => CCBE-CCSRIJA
[OriginatingSystemName] => CRMLS
[PublicRemarks] => GRAND 2-STORY DUMONT PLAN WITH EXPERT PRIVACY ARCHITECTURE! Welcome to the flagship Dumont layout by Seeno Homes (Est. 1938) The main level includes a private bedroom and adjacent full bath. Upstairs, the smart engineering ensures absolute privacy: all second-floor bedrooms are positioned at separate corners of the home with zero adjoining bedroom walls. A central bonus loft and dedicated laundry room complete the upper level. AMENITIES & LOCATION: $0 HOA! NO Mello-Roos! Enjoy huge monthly savings with a fully owned solar panel array included in the purchase price, a lower local tax base, and advanced energy-efficient dual-zone HVAC systems. Located steps from the future municipal park and within the top-tier Liberty Union school district. Experience premium estate living. Schedule a showing today!
[Appliances] => Electric Water Heater
[ArchitecturalStyle] => Traditional
[AttachedGarageYN] => 1
[BathroomsFull] => 4
[CLIP] => 4718573524
[CompensationComments] => 403 Longhorn Way, Oakley, CA 94561. Hours: 10AM-6PM daily, Weds: 1PM-6PM. Call 925.446.6174 for more
[ContractStatusChangeDate] => 2026-06-22
[Cooling] => Central Air
[CoolingYN] => 1
[CountyOrParish] => Contra Costa
[CreationDate] => 2026-06-22T19:40:58.901014+00:00
[CumulativeDaysOnMarket] => 100
[DaysOnMarket] => 100
[DaysOnMarketReplication] => 100
[DaysOnMarketReplicationDate] => 2026-09-30
[DaysOnMarketReplicationIncreasingYN] => 1
[Directions] => Cross Street: Rose & Longhorn.
[FireplaceFeatures] => Family Room,Gas
[FireplaceYN] => 1
[FoundationDetails] => Slab
[GarageSpaces] => 3.0
[GarageYN] => 1
[Heating] => Forced Air
[HeatingYN] => 1
[InteriorFeatures] => Eat-in Kitchen
[RFTransactionType] => For Sale
[InternetEntireListingDisplayYN] => 1
[Levels] => Two
[ListAgentAOR] => Contra Costa
[ListAgentDirectPhone] => 925-203-0462
[ListAgentEmail] => jarcidiacono@seenohomes.com
[ListAgentFirstName] => John
[ListAgentKey] => 21677581
[ListAgentKeyNumeric] => 21677581
[ListAgentLastName] => Arcidiacono
[ListAgentOfficePhone] => 925-671-7711
[ListAgentStateLicense] => 01367796
[ListOfficeAOR] => Contra Costa
[ListOfficeKey] => 5108622
[ListOfficeKeyNumeric] => 5108622
[ListOfficePhone] => 925-671-7711
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-06-22
[ListingKeyNumeric] => 1175504296
[ListingService] => Full Service
[ListingTerms] => Cash,Conventional,1031 Exchange,FHA,VA Loan
[LotFeatures] => Back Yard
[LotSizeAcres] => 0.149
[LotSizeSource] => Builder
[LotSizeSquareFeet] => 6490
[MlsStatus] => Active
[NewConstructionYN] => 1
[OnMarketDate] => 2026-06-22
[OnMarketTimestamp] => 2026-06-22T12:28:35Z
[OriginalEntryTimestamp] => 2026-06-22T12:19:39Z
[OriginalListPrice] => 983190
[OriginatingSystemID] => CCBE
[OriginatingSystemKey] => 443665341
[OriginatingSystemSubName] => CRMLS_CCBE
[ParcelNumber] => 0345700371
[ParkingFeatures] => Garage,Garage Door Opener
[ParkingTotal] => 3.0
[PhotosChangeTimestamp] => 2026-06-22T19:30:42Z
[PhotosCount] => 1
[PoolFeatures] => None
[Possession] => Close Of Escrow
[PostalCity] => OAKLEY
[PreviousListPrice] => 983190
[PriceChangeTimestamp] => 2026-06-21T17:00:00Z
[PropertySubTypeAdditional] => Single Family Residence
[Roof] => Tile
[ShowingContactName] => Stonewood Sales Center
[ShowingContactPhone] => 925.446.6174
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1175504296
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2026-06-28T17:00:00Z
[Stories] => 2
[StreetName] => Cloverbrook Ave
[StreetNumber] => 3559
[StreetNumberNumeric] => 3559
[SubdivisionName] => Not Listed
[UniversalPropertyId] => US-06013-N-0345700371-R-N
[VirtualTourURLBranded] => https://www.seenohomes.com/homes/oakley/the-preserve-at-stonewood/3559-cloverbrook-ave
[WindowFeatures] => Screens
[CustomFields] => {
"EatingArea": "In Kitchen",
"RoomKitchenFeatures": "Kitchen Island",
"RoomBathroomFeatures": "Shower in Tub,Separate tub and shower,Double sinks in bath(s)",
"AdminUpdateYN": "0",
"ListingKey": "1175504296"
}
[PricePerArea] => 302.71
[HumanModifiedYN] =>
[PricePerAreaUnit] => Dollars Per Square Foot
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1175504296')
[CurrentPrice] => 983190
[provider_name] => CRMLS
[RecordSignature] => 940245140
[UniversalParcelId] => urn:reso:upi:2.0:US:06013:0345700371
[CountrySubdivision] => 06013
[OriginatingSystemListOfficeKey] => 370193253
[OriginatingSystemListAgentMemberKey] => 370222131
[Media] => Array
(
[0] => Array
(
[Order] => 1
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2005610354195
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1175504296/c2186e9b9be73f46e84a87f42837f208.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 98219
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1175504296/thumbnail-c2186e9b9be73f46e84a87f42837f208.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 21677581
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5108622
[MediaCategory] =>
[MediaObjectID] => 0.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => CCBE-CCSRIJA
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2005610354195
[PropertySubType] => Single Family Residence
[RecordSignature] => -1932057232
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => 41139185
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1175504296
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => CCBE
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-06-22T19:30:40.990-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_CCBE
[ResourceRecordKeyNumeric] => 1175504296
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 443665341
[PropertySubTypeAdditional] => Single Family Residence
[MediaModificationTimestamp] => 2026-06-22T19:30:40.990-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 443665341
)
)
[ID] => 664329
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.31 seconds
)
)
MLS On The Fly Debug Panel
[Warning] Undefined array key "file" in /mnt/customers/customers-bh-1pq6z0/e79c15af-daf5-4b07-94b5-b8edbc56c945/wp-content/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /mnt/customers/customers-bh-1pq6z0/e79c15af-daf5-4b07-94b5-b8edbc56c945/wp-content/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147