meta_query='key:subdist__c;value:Financial District - Barbary Coast|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='340382' posts_per_page=4 post_type=property
int(1)
string(0) ""
_yoast_indexnow_last_ping, 1697684901
ffd_listing_title, 506 Grant 510 Avenue, San Francisco, CA, 94108
ffd_mls_id, 422674068
ffd_salesforce_id, a0E8W00000XjqQsUAJ
num_of_rooms__c, 11
of_units__c, 3
address2__c, 506 Grant 510 Avenue, San Francisco, CA, 94108
pba__address_pb__c, 506 Grant 510 Avenue, San Francisco, CA, 94108
agent_only_remarks__c, Contact for full marketing package and showing: [email protected] and [email protected]
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 4
year_build_text__c, 1909
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-06-29T17:49:04.000+0000
days_on_market__c, 476
dom__c, 400
ffd_description_pb, 506 GRANT AVE is strategically located in between Financial District, Union Square, and Chinatown. The subject property is a 3,000-square feet building sitting on a 997-square-foot lot. The subject property is a three-story building located in the heart of San Francisco. The ground floor is a commercial unit. The upper two floors are residential flats, overlooking the beautiful St. Mary Square and Financial District. There is also a full basement. Seismic retrofit has been completed in the past. The subject property's APN is 0258-013. Zoning is CCB. The subject property presents a great investment opportunity to investors.
district__c, SF District 8
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-10-19T02:56:59.000+0000
pba__latitude_pb__c, 37.791689
pba__latitude_property__c, 37.791689
listed_date__c, 2022-06-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ning
pba__listing_agent_lastname__c, Ho
listing_agent_mls_id__c, 810266
ffd_listingagentname, Ning H Ho
listing_agent_number__c, 1045343
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, M&ML
listing_office_name__c, Marcus & Millichap
listing_office_number__c, 1464
pba__listingprice_pb__c, 1500000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.405616
mls_id__c, 422674068
parkingspaces__c, 0
on_market_date__c, 2022-06-29
original_price__c, 1880000
overall_days_on_market__c, -81263
pba__pendingdate__c, 2023-08-23
price_per_square_foot__c, 500
pba__propertytype__c, Other
ListingId, a0E8W00000XjqQsUAJ
sale_date__c, 2023-10-16
sale_price__c, 1500000
selling_agent_mls_id__c, 810266
selling_agent_number__c, 1045343
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Marcus & Millichap
pba__status__c, Closed
pba__totalarea_pb__c, 3000
size__c, 3000
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Grant
subdist__c, Financial District - Barbary Coast
ffd_name, 506 Grant 510 Avenue, San Francisco, CA, 94108
website_property_type__c, Other
pba__yearbuilt_pb__c, 1909
pba__postalcode_pb__c, 94108
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530487313-1.jpg