Beautiful New Home will be complete by 12/19/2026. Welcome to this stunning two story residence offering 4 bedrooms, 2.5 baths, 2, 876 sqft living space. Enjoy the benefits of paid off solar, no HOA, and a layout designed for relaxation and entertaining. Come and make this beautiful house your new home. Located near Costco, Safeway and plenty of restaurants near by.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 824629
[post_author] => 1
[ListingKey] => 1194685152
[ListingId] => 41153106
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Active
[ModificationTimestamp] => 2026-11-17T20:29:37Z
[RFModificationTimestamp] => 2026-11-17T20:32:21Z
[ListPrice] => 878830
[BathroomsTotalInteger] => 3
[BathroomsHalf] => 1
[BedroomsTotal] => 4
[LotSizeArea] => 4905
[LivingArea] => 2876
[BuildingAreaTotal] => 0
[City] => Fairfield
[PostalCode] => 94534
[UnparsedAddress] => 503 Yarrow Drive, Fairfield, California 94534
[Coordinates] => Array
(
[0] => -122.15368011
[1] => 38.20013708
)
[Latitude] => 38.20013708
[Longitude] => -122.15368011
[YearBuilt] => 2026
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => John Arcidiacono
[ListOfficeName] => Seecon Realty, Inc
[ListAgentMlsId] => CCBE-159510820
[ListOfficeMlsId] => CCBE-CCSRIJA
[OriginatingSystemName] => CRMLS
[PublicRemarks] => Beautiful New Home will be complete by 12/19/2026. Welcome to this stunning two story residence offering 4 bedrooms, 2.5 baths, 2,876 sqft living space. Enjoy the benefits of paid off solar, no HOA, and a layout designed for relaxation and entertaining. Come and make this beautiful house your new home. Located near Costco, Safeway and plenty of restaurants near by.
[ArchitecturalStyle] => Traditional
[AttachedGarageYN] => 1
[BathroomsFull] => 2
[CLIP] => 1040245463
[CompensationComments] => No sales office. Please call Jerry Bassler 925-655-8117.
[ConstructionMaterials] => Stucco
[ContractStatusChangeDate] => 2026-11-05
[Cooling] => Central Air
[CoolingYN] => 1
[CountyOrParish] => Solano
[CreationDate] => 2026-11-05T20:54:27.997804+00:00
[CumulativeDaysOnMarket] => 12
[DaysOnMarket] => 14
[DaysOnMarketReplication] => 12
[DaysOnMarketReplicationDate] => 2026-11-17
[DaysOnMarketReplicationIncreasingYN] => 1
[Directions] => Cross Street: Valerian Dr.
[FireplaceFeatures] => Gas
[FireplaceYN] => 1
[Flooring] => Carpet, Concrete, Tile
[FoundationDetails] => Slab
[GarageSpaces] => 2.0
[GarageYN] => 1
[HeatingYN] => 1
[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-11-05
[ListingKeyNumeric] => 1194685152
[ListingService] => Full Service
[ListingTerms] => Cash,Conventional,1031 Exchange,FHA,VA Loan
[LivingAreaUnits] => SquareFeet
[LotFeatures] => Back Yard,Front Yard
[LotSizeAcres] => 0.1126
[LotSizeSource] => Builder
[LotSizeSquareFeet] => 4905
[LotSizeUnits] => SquareFeet
[MlsStatus] => Active
[NewConstructionYN] => 1
[OnMarketDate] => 2026-11-05
[OnMarketTimestamp] => 2026-11-05T12:13:47Z
[OriginalEntryTimestamp] => 2026-11-05T12:06:17Z
[OriginalListPrice] => 878830
[OriginatingSystemID] => CCBE
[OriginatingSystemKey] => 698404254
[OriginatingSystemSubName] => CRMLS_CCBE
[ParcelNumber] => 0180401010
[ParkingFeatures] => Garage
[ParkingTotal] => 2.0
[PhotosChangeTimestamp] => 2026-11-05T20:16:17Z
[PhotosCount] => 1
[PoolFeatures] => None
[Possession] => Close Of Escrow
[PostalCity] => FAIRFIELD
[PreviousListPrice] => 878830
[PriceChangeTimestamp] => 2026-11-04T16:00:00Z
[PropertySubTypeAdditional] => Single Family Residence
[Roof] => Tile
[ShowingContactName] => Jerry Bassler
[ShowingContactPhone] => 925-671-8073
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1194685152
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2026-11-11T16:00:00Z
[Stories] => 2
[StreetName] => Yarrow Drive
[StreetNumber] => 503
[StreetNumberNumeric] => 503
[SubdivisionName] => Not Listed
[UniversalPropertyId] => US-06095-N-0180401010-R-N
[CustomFields] => {
"RoomBathroomFeatures": "Shower in Tub",
"AdminUpdateYN": "0",
"ListingKey": "1194685152"
}
[PricePerArea] => 305.57
[HumanModifiedYN] =>
[PricePerAreaUnit] => Dollars Per Square Foot
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1194685152')
[CurrentPrice] => 878830
[provider_name] => CRMLS
[RecordSignature] => 1094662060
[UniversalParcelId] => urn:reso:upi:2.0:US:06095:0180401010
[CountrySubdivision] => 06095
[OriginatingSystemListOfficeKey] => 370193253
[OriginatingSystemListAgentMemberKey] => 370222131
[Media] => Array
(
[0] => Array
(
[Order] => 1
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006168830259
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1194685152/35d33cd4111a9d5bf5d776d0582a8eb2.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 66318
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1194685152/thumbnail-35d33cd4111a9d5bf5d776d0582a8eb2.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 21677581
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5108622
[MediaCategory] => Photo
[MediaObjectID] => 0.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => CCBE-CCSRIJA
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2006168830259
[PropertySubType] => Single Family Residence
[RecordSignature] => -440998438
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => 41153106
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1194685152
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => CCBE
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-11-05T20:15:55.227-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_CCBE
[ResourceRecordKeyNumeric] => 1194685152
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 698404254
[PropertySubTypeAdditional] => Single Family Residence
[MediaModificationTimestamp] => 2026-11-05T20:15:55.227-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 698404254
)
)
[ID] => 824629
)
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 1194685152 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] => 824629
[post_author] => 1
[ListingKey] => 1194685152
[ListingId] => 41153106
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Active
[ModificationTimestamp] => 2026-11-17T20:29:37Z
[RFModificationTimestamp] => 2026-11-17T20:32:21Z
[ListPrice] => 878830
[BathroomsTotalInteger] => 3
[BathroomsHalf] => 1
[BedroomsTotal] => 4
[LotSizeArea] => 4905
[LivingArea] => 2876
[BuildingAreaTotal] => 0
[City] => Fairfield
[PostalCode] => 94534
[UnparsedAddress] => 503 Yarrow Drive, Fairfield, California 94534
[Coordinates] => Array
(
[0] => -122.15368011
[1] => 38.20013708
)
[Latitude] => 38.20013708
[Longitude] => -122.15368011
[YearBuilt] => 2026
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => John Arcidiacono
[ListOfficeName] => Seecon Realty, Inc
[ListAgentMlsId] => CCBE-159510820
[ListOfficeMlsId] => CCBE-CCSRIJA
[OriginatingSystemName] => CRMLS
[PublicRemarks] => Beautiful New Home will be complete by 12/19/2026. Welcome to this stunning two story residence offering 4 bedrooms, 2.5 baths, 2,876 sqft living space. Enjoy the benefits of paid off solar, no HOA, and a layout designed for relaxation and entertaining. Come and make this beautiful house your new home. Located near Costco, Safeway and plenty of restaurants near by.
[ArchitecturalStyle] => Traditional
[AttachedGarageYN] => 1
[BathroomsFull] => 2
[CLIP] => 1040245463
[CompensationComments] => No sales office. Please call Jerry Bassler 925-655-8117.
[ConstructionMaterials] => Stucco
[ContractStatusChangeDate] => 2026-11-05
[Cooling] => Central Air
[CoolingYN] => 1
[CountyOrParish] => Solano
[CreationDate] => 2026-11-05T20:54:27.997804+00:00
[CumulativeDaysOnMarket] => 12
[DaysOnMarket] => 14
[DaysOnMarketReplication] => 12
[DaysOnMarketReplicationDate] => 2026-11-17
[DaysOnMarketReplicationIncreasingYN] => 1
[Directions] => Cross Street: Valerian Dr.
[FireplaceFeatures] => Gas
[FireplaceYN] => 1
[Flooring] => Carpet, Concrete, Tile
[FoundationDetails] => Slab
[GarageSpaces] => 2.0
[GarageYN] => 1
[HeatingYN] => 1
[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-11-05
[ListingKeyNumeric] => 1194685152
[ListingService] => Full Service
[ListingTerms] => Cash,Conventional,1031 Exchange,FHA,VA Loan
[LivingAreaUnits] => SquareFeet
[LotFeatures] => Back Yard,Front Yard
[LotSizeAcres] => 0.1126
[LotSizeSource] => Builder
[LotSizeSquareFeet] => 4905
[LotSizeUnits] => SquareFeet
[MlsStatus] => Active
[NewConstructionYN] => 1
[OnMarketDate] => 2026-11-05
[OnMarketTimestamp] => 2026-11-05T12:13:47Z
[OriginalEntryTimestamp] => 2026-11-05T12:06:17Z
[OriginalListPrice] => 878830
[OriginatingSystemID] => CCBE
[OriginatingSystemKey] => 698404254
[OriginatingSystemSubName] => CRMLS_CCBE
[ParcelNumber] => 0180401010
[ParkingFeatures] => Garage
[ParkingTotal] => 2.0
[PhotosChangeTimestamp] => 2026-11-05T20:16:17Z
[PhotosCount] => 1
[PoolFeatures] => None
[Possession] => Close Of Escrow
[PostalCity] => FAIRFIELD
[PreviousListPrice] => 878830
[PriceChangeTimestamp] => 2026-11-04T16:00:00Z
[PropertySubTypeAdditional] => Single Family Residence
[Roof] => Tile
[ShowingContactName] => Jerry Bassler
[ShowingContactPhone] => 925-671-8073
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1194685152
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2026-11-11T16:00:00Z
[Stories] => 2
[StreetName] => Yarrow Drive
[StreetNumber] => 503
[StreetNumberNumeric] => 503
[SubdivisionName] => Not Listed
[UniversalPropertyId] => US-06095-N-0180401010-R-N
[CustomFields] => {
"RoomBathroomFeatures": "Shower in Tub",
"AdminUpdateYN": "0",
"ListingKey": "1194685152"
}
[PricePerArea] => 305.57
[HumanModifiedYN] =>
[PricePerAreaUnit] => Dollars Per Square Foot
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1194685152')
[CurrentPrice] => 878830
[provider_name] => CRMLS
[RecordSignature] => 1094662060
[UniversalParcelId] => urn:reso:upi:2.0:US:06095:0180401010
[CountrySubdivision] => 06095
[OriginatingSystemListOfficeKey] => 370193253
[OriginatingSystemListAgentMemberKey] => 370222131
[Media] => Array
(
[0] => Array
(
[Order] => 1
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006168830259
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1194685152/35d33cd4111a9d5bf5d776d0582a8eb2.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 66318
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1194685152/thumbnail-35d33cd4111a9d5bf5d776d0582a8eb2.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 21677581
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5108622
[MediaCategory] => Photo
[MediaObjectID] => 0.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => CCBE-CCSRIJA
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2006168830259
[PropertySubType] => Single Family Residence
[RecordSignature] => -440998438
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => 41153106
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1194685152
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => CCBE
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-11-05T20:15:55.227-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_CCBE
[ResourceRecordKeyNumeric] => 1194685152
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 698404254
[PropertySubTypeAdditional] => Single Family Residence
[MediaModificationTimestamp] => 2026-11-05T20:15:55.227-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 698404254
)
)
[ID] => 824629
)
)
[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