Spacious and beautifully maintained 2-story single-family home in South Sundales desirable Rosewood community. This 5-bedroom, 3-bath home offers a quiet neighborhood setting with convenient access to major freeways and Silicon Valley employers. Two private neighborhood parks and playgrounds are nearby for recreation and outdoor enjoyment. The open floor plan features elegant tile flooring in the living room, hardwood floors throughout the home and stairway, and fresh interior and exterior paint. The spacious kitchen offers a granite island, wraparound granite countertops and backsplash, stainless steel appliances, built-in microwave and oven, and abundant oak cabinetry with ample storage. The primary suite offers a comfortable private retreat, while the additional bedrooms provide flexible living space. Additional features include wired internet connections in all rooms and an installed security system. This well-maintained home offers comfort, functionality, and convenient access to Silicon Valley.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 767751
[post_author] => 1
[ListingKey] => 1191141218
[ListingId] => ML82059810
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Active
[ModificationTimestamp] => 2026-09-20T04:36:43Z
[RFModificationTimestamp] => 2026-09-20T04:40:48Z
[ListPrice] => 1988888
[BathroomsTotalInteger] => 3
[BathroomsHalf] => 0
[BedroomsTotal] => 5
[LotSizeArea] => 4000
[LivingArea] => 2350
[BuildingAreaTotal] => 0
[City] => Fremont
[PostalCode] => 94538
[UnparsedAddress] => 4473 Keepsake Rose, Fremont, California 94538
[Coordinates] => Array
(
[0] => -121.97519948
[1] => 37.53385399
)
[Latitude] => 37.53385399
[Longitude] => -121.97519948
[YearBuilt] => 2008
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Michael Adari
[ListOfficeName] => Coldwell Banker Realty
[ListAgentMlsId] => ML5064829
[ListOfficeMlsId] => ML35490
[OriginatingSystemName] => CRMLS
[PublicRemarks] => Spacious and beautifully maintained 2-story single-family home in South Sundales desirable Rosewood community. This 5-bedroom, 3-bath home offers a quiet neighborhood setting with convenient access to major freeways and Silicon Valley employers. Two private neighborhood parks and playgrounds are nearby for recreation and outdoor enjoyment. The open floor plan features elegant tile flooring in the living room, hardwood floors throughout the home and stairway, and fresh interior and exterior paint. The spacious kitchen offers a granite island, wraparound granite countertops and backsplash, stainless steel appliances, built-in microwave and oven, and abundant oak cabinetry with ample storage. The primary suite offers a comfortable private retreat, while the additional bedrooms provide flexible living space. Additional features include wired internet connections in all rooms and an installed security system. This well-maintained home offers comfort, functionality, and convenient access to Silicon Valley.
[ArchitecturalStyle] => Contemporary
[AssociationFee] => 120.0
[AssociationPhone] => (925) 264-8722
[AssociationYN] => 1
[AttachedGarageYN] => 1
[BathroomsFull] => 3
[CLIP] => 6650671651
[CommonWalls] => No Common Walls
[ContractStatusChangeDate] => 2026-09-19
[Cooling] => Central Air
[CoolingYN] => 1
[CountyOrParish] => Alameda
[CreationDate] => 2026-09-20T04:36:15.375518+00:00
[DaysOnMarketReplicationDate] => 2026-09-19
[DaysOnMarketReplicationIncreasingYN] => 1
[Directions] => Stevenson Blvd |Margery Dr | Lalolo Rd |Keepsake Cross Street: Lalolo Rd
[FireplaceFeatures] => Family Room,Living Room
[FireplaceYN] => 1
[Flooring] => Tile, Wood
[GarageSpaces] => 2.0
[GarageYN] => 1
[Heating] => Central
[HeatingYN] => 1
[HighSchoolDistrict] => Fremont Unified
[RFTransactionType] => For Sale
[InternetAutomatedValuationDisplayYN] => 1
[InternetConsumerCommentYN] => 1
[InternetEntireListingDisplayYN] => 1
[ListAgentAOR] => MLSListings
[ListAgentDirectPhone] => 408-621-1873
[ListAgentEmail] => michael.adari@cbrealty.com
[ListAgentFirstName] => Michael
[ListAgentKey] => 21000848
[ListAgentKeyNumeric] => 21000848
[ListAgentLastName] => Adari
[ListAgentOfficePhone] => (408) 996-1100
[ListAgentStateLicense] => 01817128
[ListAgentURL] => https://veranorealestateteam.com
[ListOfficeAOR] => MLSListings
[ListOfficeFax] => 408-996-0849
[ListOfficeKey] => 4762506
[ListOfficeKeyNumeric] => 4762506
[ListOfficePhone] => (408) 996-1100
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-09-19
[ListingKeyNumeric] => 1191141218
[ListingService] => Full Service
[LivingAreaSource] => Other
[LotSizeAcres] => 0.0918
[LotSizeSource] => Assessor
[LotSizeSquareFeet] => 4000
[MLSAreaMajor] => 699 - Not Defined
[MlsStatus] => Active
[OccupantType] => Vacant
[OnMarketDate] => 2026-09-19
[OnMarketTimestamp] => 2026-09-19T21:34:44Z
[OriginalEntryTimestamp] => 2026-09-18T17:00:00Z
[OriginalListPrice] => 1988888
[OriginatingSystemID] => MLSL
[OriginatingSystemKey] => 641686113
[OriginatingSystemSubName] => CRMLS_MLSL
[ParcelNumber] => 5251674047
[ParkingTotal] => 2.0
[PhotosChangeTimestamp] => 2026-09-20T04:36:43Z
[PhotosCount] => 1
[PostalCity] => FREMONT
[PropertySubTypeAdditional] => Single Family Residence
[Roof] => Tile
[Sewer] => Public Sewer
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1191141218
[SpecialListingConditions] => Standard
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2026-09-02T02:57:19Z
[StoriesTotal] => 2
[StreetName] => Keepsake Rose
[StreetNumber] => 4473
[StreetNumberNumeric] => 4473
[UniversalPropertyId] => US-06001-N-5251674047-R-N
[VideosChangeTimestamp] => 2026-09-20T04:36:43Z
[WaterSource] => Public
[YearBuiltSource] => Assessor
[Zoning] => P-2006
[CustomFields] => {
"AdminUpdateYN": "0",
"ListingKey": "1191141218"
}
[PricePerArea] => 846.34
[HumanModifiedYN] =>
[PricePerAreaUnit] => Dollars Per Square Foot
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1191141218')
[CurrentPrice] => 1988888
[provider_name] => CRMLS
[RecordSignature] => -549843442
[UniversalParcelId] => urn:reso:upi:2.0:US:06001:5251674047
[CountrySubdivision] => 06001
[OriginatingSystemListOfficeKey] => 368549129
[OriginatingSystemListAgentMemberKey] => 368813626
[Media] => Array
(
[0] => Array
(
[Order] => 1
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006047137240
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1191141218/7f3cdcdce1e340773bb2034b53f448ee.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 156515
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1191141218/thumbnail-7f3cdcdce1e340773bb2034b53f448ee.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 21000848
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 4762506
[MediaCategory] => Photo
[MediaObjectID] => 0.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => ML35490
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2006047137240
[PropertySubType] => Single Family Residence
[RecordSignature] => 812410157
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => ML82059810
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1191141218
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => MLSL
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-09-20T04:35:46.347-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_MLSL
[ResourceRecordKeyNumeric] => 1191141218
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 641686113
[PropertySubTypeAdditional] => Single Family Residence
[MediaModificationTimestamp] => 2026-09-20T04:35:46.347-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 641686113
)
)
[DaysOnMarket] => 0
[ID] => 767751
)
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 1191141218 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] => 767751
[post_author] => 1
[ListingKey] => 1191141218
[ListingId] => ML82059810
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Active
[ModificationTimestamp] => 2026-09-20T04:36:43Z
[RFModificationTimestamp] => 2026-09-20T04:40:48Z
[ListPrice] => 1988888
[BathroomsTotalInteger] => 3
[BathroomsHalf] => 0
[BedroomsTotal] => 5
[LotSizeArea] => 4000
[LivingArea] => 2350
[BuildingAreaTotal] => 0
[City] => Fremont
[PostalCode] => 94538
[UnparsedAddress] => 4473 Keepsake Rose, Fremont, California 94538
[Coordinates] => Array
(
[0] => -121.97519948
[1] => 37.53385399
)
[Latitude] => 37.53385399
[Longitude] => -121.97519948
[YearBuilt] => 2008
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Michael Adari
[ListOfficeName] => Coldwell Banker Realty
[ListAgentMlsId] => ML5064829
[ListOfficeMlsId] => ML35490
[OriginatingSystemName] => CRMLS
[PublicRemarks] => Spacious and beautifully maintained 2-story single-family home in South Sundales desirable Rosewood community. This 5-bedroom, 3-bath home offers a quiet neighborhood setting with convenient access to major freeways and Silicon Valley employers. Two private neighborhood parks and playgrounds are nearby for recreation and outdoor enjoyment. The open floor plan features elegant tile flooring in the living room, hardwood floors throughout the home and stairway, and fresh interior and exterior paint. The spacious kitchen offers a granite island, wraparound granite countertops and backsplash, stainless steel appliances, built-in microwave and oven, and abundant oak cabinetry with ample storage. The primary suite offers a comfortable private retreat, while the additional bedrooms provide flexible living space. Additional features include wired internet connections in all rooms and an installed security system. This well-maintained home offers comfort, functionality, and convenient access to Silicon Valley.
[ArchitecturalStyle] => Contemporary
[AssociationFee] => 120.0
[AssociationPhone] => (925) 264-8722
[AssociationYN] => 1
[AttachedGarageYN] => 1
[BathroomsFull] => 3
[CLIP] => 6650671651
[CommonWalls] => No Common Walls
[ContractStatusChangeDate] => 2026-09-19
[Cooling] => Central Air
[CoolingYN] => 1
[CountyOrParish] => Alameda
[CreationDate] => 2026-09-20T04:36:15.375518+00:00
[DaysOnMarketReplicationDate] => 2026-09-19
[DaysOnMarketReplicationIncreasingYN] => 1
[Directions] => Stevenson Blvd |Margery Dr | Lalolo Rd |Keepsake Cross Street: Lalolo Rd
[FireplaceFeatures] => Family Room,Living Room
[FireplaceYN] => 1
[Flooring] => Tile, Wood
[GarageSpaces] => 2.0
[GarageYN] => 1
[Heating] => Central
[HeatingYN] => 1
[HighSchoolDistrict] => Fremont Unified
[RFTransactionType] => For Sale
[InternetAutomatedValuationDisplayYN] => 1
[InternetConsumerCommentYN] => 1
[InternetEntireListingDisplayYN] => 1
[ListAgentAOR] => MLSListings
[ListAgentDirectPhone] => 408-621-1873
[ListAgentEmail] => michael.adari@cbrealty.com
[ListAgentFirstName] => Michael
[ListAgentKey] => 21000848
[ListAgentKeyNumeric] => 21000848
[ListAgentLastName] => Adari
[ListAgentOfficePhone] => (408) 996-1100
[ListAgentStateLicense] => 01817128
[ListAgentURL] => https://veranorealestateteam.com
[ListOfficeAOR] => MLSListings
[ListOfficeFax] => 408-996-0849
[ListOfficeKey] => 4762506
[ListOfficeKeyNumeric] => 4762506
[ListOfficePhone] => (408) 996-1100
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-09-19
[ListingKeyNumeric] => 1191141218
[ListingService] => Full Service
[LivingAreaSource] => Other
[LotSizeAcres] => 0.0918
[LotSizeSource] => Assessor
[LotSizeSquareFeet] => 4000
[MLSAreaMajor] => 699 - Not Defined
[MlsStatus] => Active
[OccupantType] => Vacant
[OnMarketDate] => 2026-09-19
[OnMarketTimestamp] => 2026-09-19T21:34:44Z
[OriginalEntryTimestamp] => 2026-09-18T17:00:00Z
[OriginalListPrice] => 1988888
[OriginatingSystemID] => MLSL
[OriginatingSystemKey] => 641686113
[OriginatingSystemSubName] => CRMLS_MLSL
[ParcelNumber] => 5251674047
[ParkingTotal] => 2.0
[PhotosChangeTimestamp] => 2026-09-20T04:36:43Z
[PhotosCount] => 1
[PostalCity] => FREMONT
[PropertySubTypeAdditional] => Single Family Residence
[Roof] => Tile
[Sewer] => Public Sewer
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1191141218
[SpecialListingConditions] => Standard
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2026-09-02T02:57:19Z
[StoriesTotal] => 2
[StreetName] => Keepsake Rose
[StreetNumber] => 4473
[StreetNumberNumeric] => 4473
[UniversalPropertyId] => US-06001-N-5251674047-R-N
[VideosChangeTimestamp] => 2026-09-20T04:36:43Z
[WaterSource] => Public
[YearBuiltSource] => Assessor
[Zoning] => P-2006
[CustomFields] => {
"AdminUpdateYN": "0",
"ListingKey": "1191141218"
}
[PricePerArea] => 846.34
[HumanModifiedYN] =>
[PricePerAreaUnit] => Dollars Per Square Foot
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1191141218')
[CurrentPrice] => 1988888
[provider_name] => CRMLS
[RecordSignature] => -549843442
[UniversalParcelId] => urn:reso:upi:2.0:US:06001:5251674047
[CountrySubdivision] => 06001
[OriginatingSystemListOfficeKey] => 368549129
[OriginatingSystemListAgentMemberKey] => 368813626
[Media] => Array
(
[0] => Array
(
[Order] => 1
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006047137240
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1191141218/7f3cdcdce1e340773bb2034b53f448ee.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 156515
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1191141218/thumbnail-7f3cdcdce1e340773bb2034b53f448ee.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 21000848
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 4762506
[MediaCategory] => Photo
[MediaObjectID] => 0.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => ML35490
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2006047137240
[PropertySubType] => Single Family Residence
[RecordSignature] => 812410157
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => ML82059810
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1191141218
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => MLSL
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-09-20T04:35:46.347-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_MLSL
[ResourceRecordKeyNumeric] => 1191141218
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 641686113
[PropertySubTypeAdditional] => Single Family Residence
[MediaModificationTimestamp] => 2026-09-20T04:35:46.347-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 641686113
)
)
[DaysOnMarket] => 0
[ID] => 767751
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.32 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