Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 814734
[post_author] => 1
[ListingKey] => 1194391200
[ListingId] => 41152898
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Active
[ModificationTimestamp] => 2026-11-03T18:45:43Z
[RFModificationTimestamp] => 2026-11-03T18:48:26Z
[ListPrice] => 939000
[BathroomsTotalInteger] => 3
[BathroomsHalf] => 0
[BedroomsTotal] => 5
[LotSizeArea] => 6630
[LivingArea] => 2928
[BuildingAreaTotal] => 0
[City] => Hercules
[PostalCode] => 94547
[UnparsedAddress] => 650 Turquoise Dr., Hercules, California 94547
[Coordinates] => Array
(
[0] => -122.27502215
[1] => 37.99659135
)
[Latitude] => 37.99659135
[Longitude] => -122.27502215
[YearBuilt] => 1998
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Carol Nassar
[ListOfficeName] => Dudum Real Estate Group
[ListAgentMlsId] => CCBE-159525977
[ListOfficeMlsId] => CCBE-CCDUDREG
[OriginatingSystemName] => CRMLS
[PublicRemarks] => Enter 650 Turquoise Drive and fall in love with an inviting floor plan featuring abundant natural light, vaulted ceilings, and generous living spaces. With 5 bedrooms, 3 bathrooms, and approximately 2,928 square feet, there’s plenty of room to spread out, gather, and enjoy everyday living. Remodeled around 2021, the beautifully updated kitchen features white cabinetry, elegant countertops, stainless steel appliances, a Fulgor Milano range, and a center island. Opening to the adjoining family room and casual dining area, it’s a space designed for both everyday living and entertaining. Whether hosting dinner in the formal living and dining areas or gathering with friends in the backyard, this home offers plenty of opportunities to bring people together. With the holidays approaching, imagine being the one everyone looks forward to visiting! A bedroom and full bathroom on the main level provide added flexibility for guests or a home office. Upstairs, the spacious primary suite offers a comfortable retreat, complete with a two-sided fireplace shared between the bedroom and an additional sitting area, wonderful for a secluded office, reading nook, or quiet escape. The primary bathroom features two separate vanities, a soaking tub, separate shower, and walk-in closet. Additional bedrooms offer plenty of flexibility to fit your lifestyle. Outside, the backyard extends the living space with an expansive patio, covered seating area, and room for outdoor dining and entertaining. A three-car garage adds convenience and extra storage. Conveniently located near Refugio Park, shopping, dining, and commuter routes, 650 Turquoise Drive combines generous living spaces, thoughtful updates, and everyday comfort in a place you’ll love calling home.
[Appliances] => Gas Water Heater
[ArchitecturalStyle] => Traditional
[AttachedGarageYN] => 1
[BathroomsFull] => 3
[CLIP] => 4409028365
[ConstructionMaterials] => Stucco
[ContractStatusChangeDate] => 2026-11-03
[Cooling] => Central Air
[CoolingYN] => 1
[CountyOrParish] => Contra Costa
[CreationDate] => 2026-11-03T18:47:58.722865+00:00
[DaysOnMarketReplicationDate] => 2026-11-03
[DaysOnMarketReplicationIncreasingYN] => 1
[Directions] => Cross Street: Sycamore.
[FireplaceFeatures] => Family Room,Primary Bedroom
[FireplaceYN] => 1
[Flooring] => Carpet,See Remarks,Tile
[GarageSpaces] => 3.0
[GarageYN] => 1
[HeatingYN] => 1
[RFTransactionType] => For Sale
[InternetEntireListingDisplayYN] => 1
[Levels] => Two
[ListAgentAOR] => Contra Costa
[ListAgentDirectPhone] => 925-788-9847
[ListAgentEmail] => carol@nassarrealtygroup.com
[ListAgentFirstName] => Carol
[ListAgentKey] => 21727777
[ListAgentKeyNumeric] => 21727777
[ListAgentLastName] => Nassar
[ListAgentOfficePhone] => 925-937-4000
[ListAgentStateLicense] => 02042940
[ListOfficeAOR] => Contra Costa
[ListOfficeFax] => 925-937-4001
[ListOfficeKey] => 5104361
[ListOfficeKeyNumeric] => 5104361
[ListOfficePhone] => 925-937-4000
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-11-03
[ListingKeyNumeric] => 1194391200
[ListingService] => Full Service
[ListingTerms] => Cash, Conventional
[LotFeatures] => Back Yard,Corner Lot
[LotSizeAcres] => 0.1522
[LotSizeSource] => Measured
[LotSizeSquareFeet] => 6630
[MlsStatus] => Active
[OccupantType] => Owner
[OnMarketDate] => 2026-11-03
[OnMarketTimestamp] => 2026-11-03T10:43:29Z
[OriginalEntryTimestamp] => 2026-11-03T10:25:33Z
[OriginalListPrice] => 939000
[OriginatingSystemID] => CCBE
[OriginatingSystemKey] => 696923694
[OriginatingSystemSubName] => CRMLS_CCBE
[ParcelNumber] => 4071020137
[ParkingFeatures] => Garage
[ParkingTotal] => 3.0
[PhotosChangeTimestamp] => 2026-11-03T18:45:43Z
[PhotosCount] => 53
[PoolFeatures] => None
[Possession] => Close Of Escrow
[PostalCity] => HERCULES
[PriceChangeTimestamp] => 2026-11-02T16:00:00Z
[PropertySubTypeAdditional] => Single Family Residence
[Roof] => Tile
[ShowingContactName] => Listing Agent- Carol Nassar
[ShowingContactPhone] => 9257889847
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1194391200
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2026-11-02T16:00:00Z
[Stories] => 2
[StreetName] => Turquoise Dr.
[StreetNumber] => 650
[StreetNumberNumeric] => 650
[SubdivisionName] => None
[UniversalPropertyId] => US-06013-N-4071020137-R-N
[VideosChangeTimestamp] => 2026-11-03T18:45:43Z
[VirtualTourURLBranded] => https://listings.dremarvisuals.com/sites/650-turquoise-dr-hercules-ca-94547-30282518/branded
[VirtualTourURLUnbranded] => https://listings.dremarvisuals.com/sites/rdaglqkw/unbranded
[CustomFields] => {
"RoomBathroomFeatures": "Shower in Tub",
"AdminUpdateYN": "0",
"ListingKey": "1194391200"
}
[PricePerArea] => 320.7
[HumanModifiedYN] =>
[PricePerAreaUnit] => Dollars Per Square Foot
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1194391200')
[CurrentPrice] => 939000
[provider_name] => CRMLS
[short_address] => Hercules, California 94547, USA
[RecordSignature] => 1730519674
[UniversalParcelId] => urn:reso:upi:2.0:US:06013:4071020137
[CountrySubdivision] => 06013
[OriginatingSystemListOfficeKey] => 370205619
[OriginatingSystemListAgentMemberKey] => 370220520
[DaysOnMarket] => 0
[ID] => 814734
)