WATERFRONT HOME WITH FLOATING POOL! Exceptional waterfront living on desirable Beaver Bay! This custom south-facing home offers a prime location just minutes to fast water and the marina, making it ideal for boating enthusiasts. Enjoy stunning water views from the expansive waterfront deck, perfect for entertaining, relaxing, or taking in Delta sunsets. The private dock features a unique built-in pool, creating your own resort-style retreat on the water. Inside, the updated interior showcases granite countertops, quality finishes, and an open, inviting floor plan designed to maximize waterfront views. Whether you’re looking for a full-time residence or weekend getaway, this rare Beaver Bay property combines location, lifestyle, and exceptional outdoor living in one of Discovery Bay’s most sought-after waterfront settings.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 659887
[post_author] => 1
[ListingKey] => 1174707376
[ListingId] => 41138466
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Active
[ModificationTimestamp] => 2026-07-07T22:32:54Z
[RFModificationTimestamp] => 2026-07-07T22:45:30Z
[ListPrice] => 1400000
[BathroomsTotalInteger] => 3
[BathroomsHalf] => 1
[BedroomsTotal] => 4
[LotSizeArea] => 7320
[LivingArea] => 2700
[BuildingAreaTotal] => 0
[City] => Discovery Bay
[PostalCode] => 94505
[UnparsedAddress] => 5450 Beaver Ln, Discovery Bay, California 94505
[Coordinates] => Array
(
[0] => -121.59343402
[1] => 37.91317398
)
[Latitude] => 37.91317398
[Longitude] => -121.59343402
[YearBuilt] => 1985
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Michael Guzzardo
[ListOfficeName] => Corcoran Icon Properties
[ListAgentMlsId] => BMLS-R01066846
[ListOfficeMlsId] => BMLS-DINTBH1
[OriginatingSystemName] => CRMLS
[PublicRemarks] => WATERFRONT HOME WITH FLOATING POOL! Exceptional waterfront living on desirable Beaver Bay! This custom south-facing home offers a prime location just minutes to fast water and the marina, making it ideal for boating enthusiasts. Enjoy stunning water views from the expansive waterfront deck, perfect for entertaining, relaxing, or taking in Delta sunsets. The private dock features a unique built-in pool, creating your own resort-style retreat on the water. Inside, the updated interior showcases granite countertops, quality finishes, and an open, inviting floor plan designed to maximize waterfront views. Whether you're looking for a full-time residence or weekend getaway, this rare Beaver Bay property combines location, lifestyle, and exceptional outdoor living in one of Discovery Bay's most sought-after waterfront settings.
[ArchitecturalStyle] => Contemporary
[AttachedGarageYN] => 1
[BathroomsFull] => 2
[CLIP] => 2651775832
[ConstructionMaterials] => Stucco
[ContractStatusChangeDate] => 2026-06-16
[Cooling] => Central Air
[CoolingYN] => 1
[CountyOrParish] => Contra Costa
[CreationDate] => 2026-06-18T01:05:33.101175+00:00
[CumulativeDaysOnMarket] => 21
[DaysOnMarket] => 154
[DaysOnMarketReplication] => 21
[DaysOnMarketReplicationDate] => 2026-07-07
[DaysOnMarketReplicationIncreasingYN] => 1
[Directions] => Cross Street: willow lake road.
[FireplaceFeatures] => Living Room
[FireplaceYN] => 1
[Flooring] => Carpet, Wood
[GarageSpaces] => 3.0
[GarageYN] => 1
[Heating] => Forced Air
[HeatingYN] => 1
[RFTransactionType] => For Sale
[InternetEntireListingDisplayYN] => 1
[Levels] => Two
[ListAgentAOR] => Delta
[ListAgentDirectPhone] => 925-864-5757
[ListAgentEmail] => mike@guzzardoteam.com
[ListAgentFax] => 866-444-8421
[ListAgentFirstName] => Michael
[ListAgentKey] => 17270876
[ListAgentKeyNumeric] => 17270876
[ListAgentLastName] => Guzzardo
[ListAgentOfficePhone] => 925-634-1111
[ListAgentStateLicense] => 01066846
[ListAgentURL] => www.Guzzardo Team.com
[ListOfficeAOR] => Delta
[ListOfficeEmail] => steve.b@corcoranicon.com
[ListOfficeFax] => 925-634-0902
[ListOfficeKey] => 3240714
[ListOfficeKeyNumeric] => 3240714
[ListOfficePhone] => 925-634-1111
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-06-16
[ListingKeyNumeric] => 1174707376
[ListingService] => Full Service
[ListingTerms] => Cash,Conventional,FHA,VA Loan
[LivingAreaUnits] => SquareFeet
[LotSizeAcres] => 0.168
[LotSizeSource] => Public Records
[LotSizeSquareFeet] => 7320
[LotSizeUnits] => SquareFeet
[MlsStatus] => Active
[OccupantType] => Tenant
[OnMarketDate] => 2026-06-16
[OnMarketTimestamp] => 2026-06-16T07:28:14Z
[OriginalEntryTimestamp] => 2026-06-16T07:18:41Z
[OriginalListPrice] => 1400000
[OriginatingSystemID] => BMLS
[OriginatingSystemKey] => 441925985
[OriginatingSystemSubName] => CRMLS_BMLS
[ParcelNumber] => 0044720134
[ParkingFeatures] => Garage,Garage Door Opener
[ParkingTotal] => 3.0
[PatioAndPorchFeatures] => Deck
[PhotosChangeTimestamp] => 2026-07-07T22:32:54Z
[PhotosCount] => 1
[PoolFeatures] => Fiberglass
[Possession] => Close Of Escrow
[PostalCity] => DISCOVERY BAY
[PreviousListPrice] => 1400000
[PriceChangeTimestamp] => 2026-06-15T17:00:00Z
[PropertySubTypeAdditional] => Single Family Residence
[Roof] => Tile
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1174707376
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2026-06-22T17:00:00Z
[Stories] => 2
[StreetName] => Beaver Ln
[StreetNumber] => 5450
[StreetNumberNumeric] => 5450
[SubdivisionName] => DELTA WATERFRONT ACCESS
[UniversalPropertyId] => US-06013-N-0044720134-R-N
[VideosChangeTimestamp] => 2026-07-07T22:32:54Z
[View] => Bay, Water
[ViewYN] => 1
[CustomFields] => {
"RoomKitchenFeatures": "Stone Counters",
"AdminUpdateYN": "0",
"ListingKey": "1174707376"
}
[HumanModifiedYN] =>
[PricePerArea] => 518.52
[PricePerAreaUnit] => Dollars Per Square Foot
[UniversalParcelId] => urn:reso:upi:2.0:US:06013:0044720134
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1174707376')
[CurrentPrice] => 1400000
[RecordSignature] => -1114247616
[OriginatingSystemListOfficeKey] => 361820626
[CountrySubdivision] => 06013
[OriginatingSystemListAgentMemberKey] => 361834464
[provider_name] => CRMLS
[Media] => Array
(
[0] => Array
(
[OffMarketDate] =>
[ResourceRecordKey] => 1174707376
[ResourceName] => Property
[OriginatingSystemMediaKey] => 441925985
[PropertyType] => Residential
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1174707376/thumbnail-09b9e8616bbcd56c07aa36fd4debfeea.webp
[ListAgentKey] => 17270876
[ShortDescription] =>
[OriginatingSystemName] => CRMLS
[ImageWidth] =>
[HumanModifiedYN] =>
[Permission] =>
[MediaType] => webp
[OriginalMediaUrl] =>
[PropertySubTypeAdditional] => Single Family Residence
[ResourceRecordID] => 41138466
[ModificationTimestamp] => 2026-07-07T22:30:16.683-00:00
[ImageSizeDescription] =>
[MediaStatus] =>
[Order] => 1
[SourceSystemResourceRecordKey] =>
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1174707376/09b9e8616bbcd56c07aa36fd4debfeea.webp
[MediaAlteration] =>
[SourceSystemID] => TRESTLE
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemID] => BMLS
[SyndicateTo] =>
[MediaKeyNumeric] => 2005679761815
[ListingPermission] =>
[OriginatingSystemResourceRecordKey] => 441925985
[ImageHeight] =>
[ChangedByMemberKey] =>
[RecordSignature] => -1906463258
[X_MediaStream] =>
[OriginatingSystemSubName] => CRMLS_BMLS
[ListOfficeKey] => 3240714
[MediaModificationTimestamp] => 2026-07-07T22:30:16.683-00:00
[SourceSystemName] =>
[MediaStatusDescription] =>
[ListOfficeMlsId] => BMLS-DINTBH1
[StandardStatus] => Active
[MediaKey] => 2005679761815
[ResourceRecordKeyNumeric] => 1174707376
[ChangedByMemberID] =>
[ChangedByMemberKeyNumeric] =>
[ClassName] =>
[ImageOf] =>
[MediaCategory] =>
[MediaObjectID] => 0.jpg
[MediaSize] => 123524
[SourceSystemMediaKey] =>
[MediaHTML] =>
[PropertySubType] => Single Family Residence
[PreferredPhotoYN] =>
[LongDescription] =>
[ListAOR] =>
[OriginatingSystemResourceRecordId] =>
[MediaClassification] => PHOTO
)
)
[ID] => 659887
)
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 1174707376 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] => 659887
[post_author] => 1
[ListingKey] => 1174707376
[ListingId] => 41138466
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Active
[ModificationTimestamp] => 2026-07-07T22:32:54Z
[RFModificationTimestamp] => 2026-07-07T22:45:30Z
[ListPrice] => 1400000
[BathroomsTotalInteger] => 3
[BathroomsHalf] => 1
[BedroomsTotal] => 4
[LotSizeArea] => 7320
[LivingArea] => 2700
[BuildingAreaTotal] => 0
[City] => Discovery Bay
[PostalCode] => 94505
[UnparsedAddress] => 5450 Beaver Ln, Discovery Bay, California 94505
[Coordinates] => Array
(
[0] => -121.59343402
[1] => 37.91317398
)
[Latitude] => 37.91317398
[Longitude] => -121.59343402
[YearBuilt] => 1985
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Michael Guzzardo
[ListOfficeName] => Corcoran Icon Properties
[ListAgentMlsId] => BMLS-R01066846
[ListOfficeMlsId] => BMLS-DINTBH1
[OriginatingSystemName] => CRMLS
[PublicRemarks] => WATERFRONT HOME WITH FLOATING POOL! Exceptional waterfront living on desirable Beaver Bay! This custom south-facing home offers a prime location just minutes to fast water and the marina, making it ideal for boating enthusiasts. Enjoy stunning water views from the expansive waterfront deck, perfect for entertaining, relaxing, or taking in Delta sunsets. The private dock features a unique built-in pool, creating your own resort-style retreat on the water. Inside, the updated interior showcases granite countertops, quality finishes, and an open, inviting floor plan designed to maximize waterfront views. Whether you're looking for a full-time residence or weekend getaway, this rare Beaver Bay property combines location, lifestyle, and exceptional outdoor living in one of Discovery Bay's most sought-after waterfront settings.
[ArchitecturalStyle] => Contemporary
[AttachedGarageYN] => 1
[BathroomsFull] => 2
[CLIP] => 2651775832
[ConstructionMaterials] => Stucco
[ContractStatusChangeDate] => 2026-06-16
[Cooling] => Central Air
[CoolingYN] => 1
[CountyOrParish] => Contra Costa
[CreationDate] => 2026-06-18T01:05:33.101175+00:00
[CumulativeDaysOnMarket] => 21
[DaysOnMarket] => 154
[DaysOnMarketReplication] => 21
[DaysOnMarketReplicationDate] => 2026-07-07
[DaysOnMarketReplicationIncreasingYN] => 1
[Directions] => Cross Street: willow lake road.
[FireplaceFeatures] => Living Room
[FireplaceYN] => 1
[Flooring] => Carpet, Wood
[GarageSpaces] => 3.0
[GarageYN] => 1
[Heating] => Forced Air
[HeatingYN] => 1
[RFTransactionType] => For Sale
[InternetEntireListingDisplayYN] => 1
[Levels] => Two
[ListAgentAOR] => Delta
[ListAgentDirectPhone] => 925-864-5757
[ListAgentEmail] => mike@guzzardoteam.com
[ListAgentFax] => 866-444-8421
[ListAgentFirstName] => Michael
[ListAgentKey] => 17270876
[ListAgentKeyNumeric] => 17270876
[ListAgentLastName] => Guzzardo
[ListAgentOfficePhone] => 925-634-1111
[ListAgentStateLicense] => 01066846
[ListAgentURL] => www.Guzzardo Team.com
[ListOfficeAOR] => Delta
[ListOfficeEmail] => steve.b@corcoranicon.com
[ListOfficeFax] => 925-634-0902
[ListOfficeKey] => 3240714
[ListOfficeKeyNumeric] => 3240714
[ListOfficePhone] => 925-634-1111
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-06-16
[ListingKeyNumeric] => 1174707376
[ListingService] => Full Service
[ListingTerms] => Cash,Conventional,FHA,VA Loan
[LivingAreaUnits] => SquareFeet
[LotSizeAcres] => 0.168
[LotSizeSource] => Public Records
[LotSizeSquareFeet] => 7320
[LotSizeUnits] => SquareFeet
[MlsStatus] => Active
[OccupantType] => Tenant
[OnMarketDate] => 2026-06-16
[OnMarketTimestamp] => 2026-06-16T07:28:14Z
[OriginalEntryTimestamp] => 2026-06-16T07:18:41Z
[OriginalListPrice] => 1400000
[OriginatingSystemID] => BMLS
[OriginatingSystemKey] => 441925985
[OriginatingSystemSubName] => CRMLS_BMLS
[ParcelNumber] => 0044720134
[ParkingFeatures] => Garage,Garage Door Opener
[ParkingTotal] => 3.0
[PatioAndPorchFeatures] => Deck
[PhotosChangeTimestamp] => 2026-07-07T22:32:54Z
[PhotosCount] => 1
[PoolFeatures] => Fiberglass
[Possession] => Close Of Escrow
[PostalCity] => DISCOVERY BAY
[PreviousListPrice] => 1400000
[PriceChangeTimestamp] => 2026-06-15T17:00:00Z
[PropertySubTypeAdditional] => Single Family Residence
[Roof] => Tile
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1174707376
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2026-06-22T17:00:00Z
[Stories] => 2
[StreetName] => Beaver Ln
[StreetNumber] => 5450
[StreetNumberNumeric] => 5450
[SubdivisionName] => DELTA WATERFRONT ACCESS
[UniversalPropertyId] => US-06013-N-0044720134-R-N
[VideosChangeTimestamp] => 2026-07-07T22:32:54Z
[View] => Bay, Water
[ViewYN] => 1
[CustomFields] => {
"RoomKitchenFeatures": "Stone Counters",
"AdminUpdateYN": "0",
"ListingKey": "1174707376"
}
[HumanModifiedYN] =>
[PricePerArea] => 518.52
[PricePerAreaUnit] => Dollars Per Square Foot
[UniversalParcelId] => urn:reso:upi:2.0:US:06013:0044720134
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1174707376')
[CurrentPrice] => 1400000
[RecordSignature] => -1114247616
[OriginatingSystemListOfficeKey] => 361820626
[CountrySubdivision] => 06013
[OriginatingSystemListAgentMemberKey] => 361834464
[provider_name] => CRMLS
[Media] => Array
(
[0] => Array
(
[OffMarketDate] =>
[ResourceRecordKey] => 1174707376
[ResourceName] => Property
[OriginatingSystemMediaKey] => 441925985
[PropertyType] => Residential
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1174707376/thumbnail-09b9e8616bbcd56c07aa36fd4debfeea.webp
[ListAgentKey] => 17270876
[ShortDescription] =>
[OriginatingSystemName] => CRMLS
[ImageWidth] =>
[HumanModifiedYN] =>
[Permission] =>
[MediaType] => webp
[OriginalMediaUrl] =>
[PropertySubTypeAdditional] => Single Family Residence
[ResourceRecordID] => 41138466
[ModificationTimestamp] => 2026-07-07T22:30:16.683-00:00
[ImageSizeDescription] =>
[MediaStatus] =>
[Order] => 1
[SourceSystemResourceRecordKey] =>
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1174707376/09b9e8616bbcd56c07aa36fd4debfeea.webp
[MediaAlteration] =>
[SourceSystemID] => TRESTLE
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemID] => BMLS
[SyndicateTo] =>
[MediaKeyNumeric] => 2005679761815
[ListingPermission] =>
[OriginatingSystemResourceRecordKey] => 441925985
[ImageHeight] =>
[ChangedByMemberKey] =>
[RecordSignature] => -1906463258
[X_MediaStream] =>
[OriginatingSystemSubName] => CRMLS_BMLS
[ListOfficeKey] => 3240714
[MediaModificationTimestamp] => 2026-07-07T22:30:16.683-00:00
[SourceSystemName] =>
[MediaStatusDescription] =>
[ListOfficeMlsId] => BMLS-DINTBH1
[StandardStatus] => Active
[MediaKey] => 2005679761815
[ResourceRecordKeyNumeric] => 1174707376
[ChangedByMemberID] =>
[ChangedByMemberKeyNumeric] =>
[ClassName] =>
[ImageOf] =>
[MediaCategory] =>
[MediaObjectID] => 0.jpg
[MediaSize] => 123524
[SourceSystemMediaKey] =>
[MediaHTML] =>
[PropertySubType] => Single Family Residence
[PreferredPhotoYN] =>
[LongDescription] =>
[ListAOR] =>
[OriginatingSystemResourceRecordId] =>
[MediaClassification] => PHOTO
)
)
[ID] => 659887
)
)
[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