27 S Main St, Milpitas that spans 0.34 acres, 15, 000 sqft, zoned for mixed-use development. The land is primed for development and capable of accommodating a seven-story building, with approximately 75, 000 square feet total building floor area. It can be designed for 48 combination of one, two and three bedroom condo units and 1062 square feet commercial unit area, along with an underground garage.This land is located in a rapidly growing region, and the development of this property offers a unique opportunity to capitalize on the growing demand for mixed-use developments in the area. With its proximity to Silicon Valley, Milpitas has seen a surge in innovation and economic growth, making it an ideal location for this project. The property is conveniently located near public transportation, shopping, and entertainment destinations, making it an attractive destination for businesses and residents alike.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 175183
[post_author] => 1
[ListingKey] => 1114181622
[ListingId] => ML82007212
[PropertyType] => Commercial Sale
[StandardStatus] => Active
[ModificationTimestamp] => 2026-09-12T19:22:47Z
[RFModificationTimestamp] => 2026-09-12T19:25:54Z
[ListPrice] => 3000000
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 14720
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => Milpitas
[PostalCode] => 95035
[UnparsedAddress] => 27 S Main Street, Milpitas, California 95035
[Coordinates] => Array
(
[0] => -121.90711313
[1] => 37.43015134
)
[Latitude] => 37.43015134
[Longitude] => -121.90711313
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Frank Liu
[ListOfficeName] => Alliance Bay Realty
[ListAgentMlsId] => ML5095069
[ListOfficeMlsId] => ML38731
[OriginatingSystemName] => CRMLS
[PublicRemarks] => 27 S Main St, Milpitas that spans 0.34 acres,15,000 sqft, zoned for mixed-use development. The land is primed for development and capable of accommodating a seven-story building, with approximately 75,000 square feet total building floor area. It can be designed for 48 combination of one, two and three bedroom condo units and 1062 square feet commercial unit area, along with an underground garage.This land is located in a rapidly growing region,and the development of this property offers a unique opportunity to capitalize on the growing demand for mixed-use developments in the area. With its proximity to Silicon Valley, Milpitas has seen a surge in innovation and economic growth, making it an ideal location for this project. The property is conveniently located near public transportation, shopping, and entertainment destinations, making it an attractive destination for businesses and residents alike.
[CLIP] => 6184412063
[ContractStatusChangeDate] => 2025-05-15
[CountyOrParish] => Santa Clara
[CreationDate] => 2025-09-20T21:34:30.561601+00:00
[DaysOnMarket] => 542
[DaysOnMarketReplication] => 485
[DaysOnMarketReplicationDate] => 2026-09-12
[DaysOnMarketReplicationIncreasingYN] => 1
[Fencing] => None
[HighSchoolDistrict] => Other
[RFTransactionType] => For Sale
[InternetAutomatedValuationDisplayYN] => 1
[InternetConsumerCommentYN] => 1
[InternetEntireListingDisplayYN] => 1
[ListAgentAOR] => MLSListings
[ListAgentDirectPhone] => 408-313-2688
[ListAgentEmail] => frank.liu1268@gmail.com
[ListAgentFax] => 408-573-1333
[ListAgentFirstName] => Frank
[ListAgentKey] => 22188336
[ListAgentKeyNumeric] => 22188336
[ListAgentLastName] => Liu
[ListAgentOfficePhone] => 510-742-6600
[ListAgentStateLicense] => 00991680
[ListAgentURL] => https://www.resultsteam.com
[ListOfficeAOR] => MLSListings
[ListOfficeFax] => 510-742-9100
[ListOfficeKey] => 4763968
[ListOfficeKeyNumeric] => 4763968
[ListOfficePhone] => 510-742-6600
[ListOfficeURL] => http://www.alliancebayrealty.com
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2025-05-15
[ListingKeyNumeric] => 1114181622
[LotSizeAcres] => 0.3379
[LotSizeSource] => Assessor
[LotSizeSquareFeet] => 14720
[MLSAreaMajor] => 699 - Not Defined
[MlsStatus] => Active
[OnMarketDate] => 2025-05-15
[OnMarketTimestamp] => 2025-05-15T22:50:05Z
[OriginalEntryTimestamp] => 2025-05-14T17:00:00Z
[OriginalListPrice] => 3000000
[OriginatingSystemID] => MLSL
[OriginatingSystemKey] => 374423509
[OriginatingSystemSubName] => CRMLS_MLSL
[ParcelNumber] => 02224024
[PhotosChangeTimestamp] => 2026-09-12T19:22:47Z
[PhotosCount] => 2
[PostalCity] => MILPITAS
[ShowingContactPhone] => 408-828-0600
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1114181622
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2025-05-15T15:31:08Z
[StreetDirPrefix] => S
[StreetName] => Main
[StreetNumber] => 27
[StreetNumberNumeric] => 27
[StreetSuffix] => Street
[UniversalPropertyId] => US-06085-N-02224024-R-N
[VideosChangeTimestamp] => 2026-09-12T19:22:47Z
[WaterSource] => Public
[Zoning] => MXD
[CustomFields] => {
"AdminUpdateYN": "0",
"ListingKey": "1114181622"
}
[HumanModifiedYN] =>
[PricePerAreaUnit] => Dollars Per Square Foot
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1114181622')
[CurrentPrice] => 3000000
[provider_name] => CRMLS
[RecordSignature] => 1139732827
[UniversalParcelId] => urn:reso:upi:2.0:US:06085:02224024
[CountrySubdivision] => 06085
[OriginatingSystemListOfficeKey] => 368558358
[OriginatingSystemListAgentMemberKey] => 371206905
[Media] => Array
(
[0] => Array
(
[Order] => 1
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006017950525
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1114181622/2eccd3d2051dafbe15ac180b752bab83.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 85546
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1114181622/thumbnail-2eccd3d2051dafbe15ac180b752bab83.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 22188336
[PropertyType] => Commercial Sale
[ResourceName] => Property
[ListOfficeKey] => 4763968
[MediaCategory] =>
[MediaObjectID] => 0.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => ML38731
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2006017950525
[PropertySubType] =>
[RecordSignature] => -1466724065
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => ML82007212
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1114181622
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => MLSL
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-09-12T19:20:55.630-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_MLSL
[ResourceRecordKeyNumeric] => 1114181622
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 374423509
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-09-12T19:20:55.630-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 374423509
)
[1] => Array
(
[Order] => 2
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006017950526
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1114181622/d4e9cb07b181432e7d4e0d7062fc006c.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 67533
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1114181622/thumbnail-d4e9cb07b181432e7d4e0d7062fc006c.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 22188336
[PropertyType] => Commercial Sale
[ResourceName] => Property
[ListOfficeKey] => 4763968
[MediaCategory] =>
[MediaObjectID] => 1.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => ML38731
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2006017950526
[PropertySubType] =>
[RecordSignature] => -1466724065
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => ML82007212
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1114181622
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => MLSL
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-09-12T19:20:55.630-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_MLSL
[ResourceRecordKeyNumeric] => 1114181622
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 374423509
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-09-12T19:20:55.630-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 374423509
)
)
[ID] => 175183
)
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 1114181622 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] => 175183
[post_author] => 1
[ListingKey] => 1114181622
[ListingId] => ML82007212
[PropertyType] => Commercial Sale
[StandardStatus] => Active
[ModificationTimestamp] => 2026-09-12T19:22:47Z
[RFModificationTimestamp] => 2026-09-12T19:25:54Z
[ListPrice] => 3000000
[BathroomsTotalInteger] => 0
[BathroomsHalf] => 0
[BedroomsTotal] => 0
[LotSizeArea] => 14720
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => Milpitas
[PostalCode] => 95035
[UnparsedAddress] => 27 S Main Street, Milpitas, California 95035
[Coordinates] => Array
(
[0] => -121.90711313
[1] => 37.43015134
)
[Latitude] => 37.43015134
[Longitude] => -121.90711313
[YearBuilt] => 0
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Frank Liu
[ListOfficeName] => Alliance Bay Realty
[ListAgentMlsId] => ML5095069
[ListOfficeMlsId] => ML38731
[OriginatingSystemName] => CRMLS
[PublicRemarks] => 27 S Main St, Milpitas that spans 0.34 acres,15,000 sqft, zoned for mixed-use development. The land is primed for development and capable of accommodating a seven-story building, with approximately 75,000 square feet total building floor area. It can be designed for 48 combination of one, two and three bedroom condo units and 1062 square feet commercial unit area, along with an underground garage.This land is located in a rapidly growing region,and the development of this property offers a unique opportunity to capitalize on the growing demand for mixed-use developments in the area. With its proximity to Silicon Valley, Milpitas has seen a surge in innovation and economic growth, making it an ideal location for this project. The property is conveniently located near public transportation, shopping, and entertainment destinations, making it an attractive destination for businesses and residents alike.
[CLIP] => 6184412063
[ContractStatusChangeDate] => 2025-05-15
[CountyOrParish] => Santa Clara
[CreationDate] => 2025-09-20T21:34:30.561601+00:00
[DaysOnMarket] => 542
[DaysOnMarketReplication] => 485
[DaysOnMarketReplicationDate] => 2026-09-12
[DaysOnMarketReplicationIncreasingYN] => 1
[Fencing] => None
[HighSchoolDistrict] => Other
[RFTransactionType] => For Sale
[InternetAutomatedValuationDisplayYN] => 1
[InternetConsumerCommentYN] => 1
[InternetEntireListingDisplayYN] => 1
[ListAgentAOR] => MLSListings
[ListAgentDirectPhone] => 408-313-2688
[ListAgentEmail] => frank.liu1268@gmail.com
[ListAgentFax] => 408-573-1333
[ListAgentFirstName] => Frank
[ListAgentKey] => 22188336
[ListAgentKeyNumeric] => 22188336
[ListAgentLastName] => Liu
[ListAgentOfficePhone] => 510-742-6600
[ListAgentStateLicense] => 00991680
[ListAgentURL] => https://www.resultsteam.com
[ListOfficeAOR] => MLSListings
[ListOfficeFax] => 510-742-9100
[ListOfficeKey] => 4763968
[ListOfficeKeyNumeric] => 4763968
[ListOfficePhone] => 510-742-6600
[ListOfficeURL] => http://www.alliancebayrealty.com
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2025-05-15
[ListingKeyNumeric] => 1114181622
[LotSizeAcres] => 0.3379
[LotSizeSource] => Assessor
[LotSizeSquareFeet] => 14720
[MLSAreaMajor] => 699 - Not Defined
[MlsStatus] => Active
[OnMarketDate] => 2025-05-15
[OnMarketTimestamp] => 2025-05-15T22:50:05Z
[OriginalEntryTimestamp] => 2025-05-14T17:00:00Z
[OriginalListPrice] => 3000000
[OriginatingSystemID] => MLSL
[OriginatingSystemKey] => 374423509
[OriginatingSystemSubName] => CRMLS_MLSL
[ParcelNumber] => 02224024
[PhotosChangeTimestamp] => 2026-09-12T19:22:47Z
[PhotosCount] => 2
[PostalCity] => MILPITAS
[ShowingContactPhone] => 408-828-0600
[SourceSystemID] => TRESTLE
[SourceSystemKey] => 1114181622
[StateOrProvince] => CA
[StatusChangeTimestamp] => 2025-05-15T15:31:08Z
[StreetDirPrefix] => S
[StreetName] => Main
[StreetNumber] => 27
[StreetNumberNumeric] => 27
[StreetSuffix] => Street
[UniversalPropertyId] => US-06085-N-02224024-R-N
[VideosChangeTimestamp] => 2026-09-12T19:22:47Z
[WaterSource] => Public
[Zoning] => MXD
[CustomFields] => {
"AdminUpdateYN": "0",
"ListingKey": "1114181622"
}
[HumanModifiedYN] =>
[PricePerAreaUnit] => Dollars Per Square Foot
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1114181622')
[CurrentPrice] => 3000000
[provider_name] => CRMLS
[RecordSignature] => 1139732827
[UniversalParcelId] => urn:reso:upi:2.0:US:06085:02224024
[CountrySubdivision] => 06085
[OriginatingSystemListOfficeKey] => 368558358
[OriginatingSystemListAgentMemberKey] => 371206905
[Media] => Array
(
[0] => Array
(
[Order] => 1
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006017950525
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1114181622/2eccd3d2051dafbe15ac180b752bab83.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 85546
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1114181622/thumbnail-2eccd3d2051dafbe15ac180b752bab83.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 22188336
[PropertyType] => Commercial Sale
[ResourceName] => Property
[ListOfficeKey] => 4763968
[MediaCategory] =>
[MediaObjectID] => 0.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => ML38731
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2006017950525
[PropertySubType] =>
[RecordSignature] => -1466724065
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => ML82007212
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1114181622
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => MLSL
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-09-12T19:20:55.630-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_MLSL
[ResourceRecordKeyNumeric] => 1114181622
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 374423509
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-09-12T19:20:55.630-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 374423509
)
[1] => Array
(
[Order] => 2
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006017950526
[MediaURL] => https://cdn.realtyfeed.com/cdn/3/1114181622/d4e9cb07b181432e7d4e0d7062fc006c.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 67533
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/3/1114181622/thumbnail-d4e9cb07b181432e7d4e0d7062fc006c.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] =>
[SyndicateTo] =>
[ListAgentKey] => 22188336
[PropertyType] => Commercial Sale
[ResourceName] => Property
[ListOfficeKey] => 4763968
[MediaCategory] =>
[MediaObjectID] => 1.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => ML38731
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2006017950526
[PropertySubType] =>
[RecordSignature] => -1466724065
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => ML82007212
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] =>
[ResourceRecordKey] => 1114181622
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] => MLSL
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-09-12T19:20:55.630-00:00
[OriginatingSystemName] => CRMLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => CRMLS_MLSL
[ResourceRecordKeyNumeric] => 1114181622
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 374423509
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-09-12T19:20:55.630-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 374423509
)
)
[ID] => 175183
)
)
[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
[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