Just released! Brand-new home located in located in sought-after Fremont. A spacious living and dining area leads to a gourmet kitchen showcasing a large island, pantry, and stainless-steel appliances. Convenient powder bath. An outdoor deck welcomes weekend brunch. Relax and unwind in the primary bedroom boasting a walking closet and luxurious primary bath. Secondary bedroom features its own bath as well. Great commuter location; convenient to Silicon Valley employers, I-880, I-680 and Fremont BART station Near outdoor recreation at Central Park, Mission Peak Regional Preserve, Coyote Hills Regional Park and Alameda Creek Regional Trail Great shopping, dining and entertainment nearby at Fremont Downtown Event Center & Plaza, Fremont Hub and Pacific Commons Shopping Center.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 639963
[post_author] => 1
[ListingKey] => 1170507879
[ListingId] => ML82049024
[PropertyType] => Residential
[PropertySubType] => Townhouse
[StandardStatus] => Active
[ModificationTimestamp] => 2026-11-09T12:01:21Z
[RFModificationTimestamp] => 2026-11-09T13:08:16Z
[ListPrice] => 875121
[BathroomsTotalInteger] => 3
[BathroomsHalf] => 1
[BedroomsTotal] => 2
[LotSizeArea] => 0
[LivingArea] => 1165
[BuildingAreaTotal] => 0
[City] => Fremont
[PostalCode] => 94536
[UnparsedAddress] => 37408 Hazel Terrace, Fremont, California 94536
[Coordinates] => Array
(
[0] => -122.006012
[1] => 37.557086
)
[Latitude] => 37.557086
[Longitude] => -122.006012
[YearBuilt] => 2026
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Theresa Mejia
[ListOfficeName] => KB Home Sales -Northern California Inc
[ListAgentMlsId] => ML5095889
[ListOfficeMlsId] => ML37617
[OriginatingSystemName] => CRMLS
[PublicRemarks] => Just released! Brand-new home located in located in sought-after Fremont. A spacious living and dining area leads to a gourmet kitchen showcasing a large island, pantry, and stainless-steel appliances. Convenient powder bath. An outdoor deck welcomes weekend brunch. Relax and unwind in the primary bedroom boasting a walking closet and luxurious primary bath. Secondary bedroom features its own bath as well. Great commuter location; convenient to Silicon Valley employers, I-880, I-680 and Fremont BART station Near outdoor recreation at Central Park, Mission Peak Regional Preserve, Coyote Hills Regional Park and Alameda Creek Regional Trail Great shopping, dining and entertainment nearby at Fremont Downtown Event Center & Plaza, Fremont Hub and Pacific Commons Shopping Center.
[AssociationAmenities] => Other
[AssociationFee] => 215.0
[AssociationYN] => 1
[AttachedGarageYN] => 1
[BathroomsFull] => 2
[BuildingName] => Veranda
[CommonInterest] => Condominium
[ContractStatusChangeDate] => 2026-05-28
[Cooling] => Central Air
[CoolingYN] => 1
[CountyOrParish] => Alameda
[CreationDate] => 2026-05-29T05:26:52.732831+00:00
[DaysOnMarket] => 165
[DaysOnMarketReplication] => 165
[DaysOnMarketReplicationDate] => 2026-11-09
[DaysOnMarketReplicationIncreasingYN] => 1
[Directions] => From I-880 North, exit Mowry Ave. and turn right. Turn left on Blacow Rd., right on Central Ave., left on Fremont Blvd. and left on Verdue Common to sales office. Cross Street: Fremont Blvd and Peralta Blvd.
[ElementarySchool] => Other
[FoundationDetails] => Slab
[GarageSpaces] => 2.0
[GarageYN] => 1
[Heating] => Forced Air
[HeatingYN] => 1
[HighSchool] => Washington
[HighSchoolDistrict] => Fremont Unified
[RFTransactionType] => For Sale
[InternetAutomatedValuationDisplayYN] => 1
[InternetConsumerCommentYN] => 1
[InternetEntireListingDisplayYN] => 1
[ListAgentAOR] => MLSListings
[ListAgentDirectPhone] => 510-589-5271
[ListAgentEmail] => tmejia@kbhome.com
[ListAgentFirstName] => Theresa
[ListAgentKey] => 22318960
[ListAgentKeyNumeric] => 22318960
[ListAgentLastName] => Mejia
[ListAgentOfficePhone] => (925) 983-4500
[ListAgentStateLicense] => 01809951
[ListAgentURL] => www.kbhome.com
[ListOfficeAOR] => MLSListings
[ListOfficeKey] => 4765100
[ListOfficeKeyNumeric] => 4765100
[ListOfficePhone] => (925) 983-4500
[ListOfficeURL] => http://kbhome.com
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-05-28
[ListingKeyNumeric] => 1170507879
[LivingAreaSource] => Other
[LotSizeSource] => Assessor
[MLSAreaMajor] => 699 - Not Defined
[MiddleOrJuniorSchool] => Other
[MlsStatus] => Active
[OnMarketDate] => 2026-05-28
[OnMarketTimestamp] => 2026-05-28T22:20:07Z
[OriginalEntryTimestamp] => 2026-05-28T15:01:54Z
[OriginalListPrice] => 964990
[OriginatingSystemID] => MLSL
[OriginatingSystemKey] => 436390056
[OriginatingSystemSubName] => CRMLS_MLSL
[ParcelNumber] => 0000000000000000000000000000
[ParkingTotal] => 2.0
[PhotosChangeTimestamp] => 2026-11-09T12:01:21Z
[PhotosCount] => 1
[PostalCity] => FREMONT
[PreviousListPrice] => 875008
[PriceChangeTimestamp] => 2026-10-24T11:49:00Z
[PropertySubTypeAdditional] => Townhouse
[Roof] => Tile
[Sewer] => Public Sewer
[ShowingContactPhone] => 510-589-5271
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1170507879
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2026-05-28T15:01:54Z
[StreetName] => Hazel
[StreetNumber] => 37408
[StreetNumberNumeric] => 37408
[StreetSuffix] => Terrace
[UniversalPropertyId] => US-06001-N-0000000000000000000000000000-R-N
[VideosChangeTimestamp] => 2026-11-09T12:01:21Z
[WaterSource] => Public
[YearBuiltSource] => Other
[Zoning] => 1
[CustomFields] => {
"AdminUpdateYN": "0",
"ListingKey": "1170507879"
}
[PricePerArea] => 751.18
[HumanModifiedYN] =>
[PricePerAreaUnit] => Dollars Per Square Foot
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1170507879')
[CurrentPrice] => 875121
[provider_name] => CRMLS
[RecordSignature] => 1562501229
[UniversalParcelId] => urn:reso:upi:2.0:US:06001:0000000000000000000000000000
[CountrySubdivision] => 06001
[OriginatingSystemListOfficeKey] => 368560227
[OriginatingSystemListAgentMemberKey] => 371596298
[Media] => Array
(
[0] => Array
(
[Order] => 1
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006175781925
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1170507879/022ebd3d8cfa8442e062e9f50e591b0c.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 73456
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1170507879/thumbnail-022ebd3d8cfa8442e062e9f50e591b0c.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 22318960
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 4765100
[MediaCategory] => Photo
[MediaObjectID] => 0.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => ML37617
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2006175781925
[PropertySubType] => Townhouse
[RecordSignature] => 2037885459
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => ML82049024
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1170507879
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => MLSL
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-11-09T11:54:37.550-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_MLSL
[ResourceRecordKeyNumeric] => 1170507879
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 436390056
[PropertySubTypeAdditional] => Townhouse
[MediaModificationTimestamp] => 2026-11-09T11:54:37.550-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 436390056
)
)
[ID] => 639963
)
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 1170507879 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] => 639963
[post_author] => 1
[ListingKey] => 1170507879
[ListingId] => ML82049024
[PropertyType] => Residential
[PropertySubType] => Townhouse
[StandardStatus] => Active
[ModificationTimestamp] => 2026-11-09T12:01:21Z
[RFModificationTimestamp] => 2026-11-09T13:08:16Z
[ListPrice] => 875121
[BathroomsTotalInteger] => 3
[BathroomsHalf] => 1
[BedroomsTotal] => 2
[LotSizeArea] => 0
[LivingArea] => 1165
[BuildingAreaTotal] => 0
[City] => Fremont
[PostalCode] => 94536
[UnparsedAddress] => 37408 Hazel Terrace, Fremont, California 94536
[Coordinates] => Array
(
[0] => -122.006012
[1] => 37.557086
)
[Latitude] => 37.557086
[Longitude] => -122.006012
[YearBuilt] => 2026
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Theresa Mejia
[ListOfficeName] => KB Home Sales -Northern California Inc
[ListAgentMlsId] => ML5095889
[ListOfficeMlsId] => ML37617
[OriginatingSystemName] => CRMLS
[PublicRemarks] => Just released! Brand-new home located in located in sought-after Fremont. A spacious living and dining area leads to a gourmet kitchen showcasing a large island, pantry, and stainless-steel appliances. Convenient powder bath. An outdoor deck welcomes weekend brunch. Relax and unwind in the primary bedroom boasting a walking closet and luxurious primary bath. Secondary bedroom features its own bath as well. Great commuter location; convenient to Silicon Valley employers, I-880, I-680 and Fremont BART station Near outdoor recreation at Central Park, Mission Peak Regional Preserve, Coyote Hills Regional Park and Alameda Creek Regional Trail Great shopping, dining and entertainment nearby at Fremont Downtown Event Center & Plaza, Fremont Hub and Pacific Commons Shopping Center.
[AssociationAmenities] => Other
[AssociationFee] => 215.0
[AssociationYN] => 1
[AttachedGarageYN] => 1
[BathroomsFull] => 2
[BuildingName] => Veranda
[CommonInterest] => Condominium
[ContractStatusChangeDate] => 2026-05-28
[Cooling] => Central Air
[CoolingYN] => 1
[CountyOrParish] => Alameda
[CreationDate] => 2026-05-29T05:26:52.732831+00:00
[DaysOnMarket] => 165
[DaysOnMarketReplication] => 165
[DaysOnMarketReplicationDate] => 2026-11-09
[DaysOnMarketReplicationIncreasingYN] => 1
[Directions] => From I-880 North, exit Mowry Ave. and turn right. Turn left on Blacow Rd., right on Central Ave., left on Fremont Blvd. and left on Verdue Common to sales office. Cross Street: Fremont Blvd and Peralta Blvd.
[ElementarySchool] => Other
[FoundationDetails] => Slab
[GarageSpaces] => 2.0
[GarageYN] => 1
[Heating] => Forced Air
[HeatingYN] => 1
[HighSchool] => Washington
[HighSchoolDistrict] => Fremont Unified
[RFTransactionType] => For Sale
[InternetAutomatedValuationDisplayYN] => 1
[InternetConsumerCommentYN] => 1
[InternetEntireListingDisplayYN] => 1
[ListAgentAOR] => MLSListings
[ListAgentDirectPhone] => 510-589-5271
[ListAgentEmail] => tmejia@kbhome.com
[ListAgentFirstName] => Theresa
[ListAgentKey] => 22318960
[ListAgentKeyNumeric] => 22318960
[ListAgentLastName] => Mejia
[ListAgentOfficePhone] => (925) 983-4500
[ListAgentStateLicense] => 01809951
[ListAgentURL] => www.kbhome.com
[ListOfficeAOR] => MLSListings
[ListOfficeKey] => 4765100
[ListOfficeKeyNumeric] => 4765100
[ListOfficePhone] => (925) 983-4500
[ListOfficeURL] => http://kbhome.com
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-05-28
[ListingKeyNumeric] => 1170507879
[LivingAreaSource] => Other
[LotSizeSource] => Assessor
[MLSAreaMajor] => 699 - Not Defined
[MiddleOrJuniorSchool] => Other
[MlsStatus] => Active
[OnMarketDate] => 2026-05-28
[OnMarketTimestamp] => 2026-05-28T22:20:07Z
[OriginalEntryTimestamp] => 2026-05-28T15:01:54Z
[OriginalListPrice] => 964990
[OriginatingSystemID] => MLSL
[OriginatingSystemKey] => 436390056
[OriginatingSystemSubName] => CRMLS_MLSL
[ParcelNumber] => 0000000000000000000000000000
[ParkingTotal] => 2.0
[PhotosChangeTimestamp] => 2026-11-09T12:01:21Z
[PhotosCount] => 1
[PostalCity] => FREMONT
[PreviousListPrice] => 875008
[PriceChangeTimestamp] => 2026-10-24T11:49:00Z
[PropertySubTypeAdditional] => Townhouse
[Roof] => Tile
[Sewer] => Public Sewer
[ShowingContactPhone] => 510-589-5271
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1170507879
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2026-05-28T15:01:54Z
[StreetName] => Hazel
[StreetNumber] => 37408
[StreetNumberNumeric] => 37408
[StreetSuffix] => Terrace
[UniversalPropertyId] => US-06001-N-0000000000000000000000000000-R-N
[VideosChangeTimestamp] => 2026-11-09T12:01:21Z
[WaterSource] => Public
[YearBuiltSource] => Other
[Zoning] => 1
[CustomFields] => {
"AdminUpdateYN": "0",
"ListingKey": "1170507879"
}
[PricePerArea] => 751.18
[HumanModifiedYN] =>
[PricePerAreaUnit] => Dollars Per Square Foot
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1170507879')
[CurrentPrice] => 875121
[provider_name] => CRMLS
[RecordSignature] => 1562501229
[UniversalParcelId] => urn:reso:upi:2.0:US:06001:0000000000000000000000000000
[CountrySubdivision] => 06001
[OriginatingSystemListOfficeKey] => 368560227
[OriginatingSystemListAgentMemberKey] => 371596298
[Media] => Array
(
[0] => Array
(
[Order] => 1
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006175781925
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1170507879/022ebd3d8cfa8442e062e9f50e591b0c.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 73456
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1170507879/thumbnail-022ebd3d8cfa8442e062e9f50e591b0c.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 22318960
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 4765100
[MediaCategory] => Photo
[MediaObjectID] => 0.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => ML37617
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2006175781925
[PropertySubType] => Townhouse
[RecordSignature] => 2037885459
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => ML82049024
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1170507879
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => MLSL
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-11-09T11:54:37.550-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_MLSL
[ResourceRecordKeyNumeric] => 1170507879
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 436390056
[PropertySubTypeAdditional] => Townhouse
[MediaModificationTimestamp] => 2026-11-09T11:54:37.550-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 436390056
)
)
[ID] => 639963
)
)
[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