meta_query='key:subdist__c;value:Merced Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='233285' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12156
[post_author] => 4
[post_date] => 2018-10-29 01:19:06
[post_date_gmt] => 2018-10-29 01:19:06
[post_content] => A tiny neighborhood, just two blocks by 12 blocks in size. But pay attention to the “Heights” in the name -- that altitude creates views for days. It’s strictly residential, with not even a corner store in the mix.
[post_title] => Merced Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => merced-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 10:03:55
[post_modified_gmt] => 2024-03-19 17:03:55
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12156
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 520 Orizaba Avenue, San Francisco, CA, 94132
ffd_mls_id, 488677
ffd_salesforce_id, a0E1I00000FYmXiUAL
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 520 Orizaba Avenue, San Francisco, CA, 94132
pba__address_pb__c, 520 Orizaba Avenue, San Francisco, CA, 94132
agent_only_remarks__c, On lockbox. Disclosures ready on IO. Offer date on Wednesday, September 4th at 12pm.
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1976
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Selina N Loc
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2019-08-21T20:46:40.000+0000
days_on_market__c, 1664
dom__c, 14
ffd_description_pb, Rare opportunity for a fully detached view home in Merced Heights! This 3bed/3bath home is ready for someone to make it their very own. Located on a quiet street, enjoy breath-taking views with lots of privacy. The greenspace behind the home makes it feel even more private and a mini-hike up the street will take you to the Lakeview and Ashton Mini Park where you can get 360 degree views of the City. All of this and yet you still are centrally located to shops and restaurants on Ocean Avenue, including Whole Foods, Target, gyms, and cafes. Close to the expanding Stonestown Galleria, Serramonte, Westlake, and much more! Easy access to public transportation and freeways.
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2024-03-11T21:47:21.000+0000
pba__latitude_pb__c, 37.718673
pba__latitude_property__c, 37.718673
listed_date__c, 2019-03-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Peter
pba__listing_agent_lastname__c, Tham
listing_agent_mls_id__c, 810739
ffd_listingagentname, Peter C Tham
listing_agent_number__c, 1047728
listing_co_agent_mls_id__c, 809678
listing_co_agent_number__c, 1042665
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 899000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.462454
pba__lotsize_pb__c, 0.05
mls_id__c, 488677
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2019-08-21
original_price__c, 899000
overall_days_on_market__c, -80220
parking__c, Attached,Garage
parking_access__c, Tandem
parking_features__c, Attached,Tandem Garage,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2019-09-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 635.41
pba__propertytype__c, Single Family Residence
id, a0E1I00000FYmXiUAL
sale_date__c, 2019-09-23
sale_price__c, 1206000
selling_agent_mls_id__c, 813174
selling_agent_name__c, Adrian Tan
selling_agent_number__c, 1059866
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1898
size__c, 1898
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Orizaba
subdist__c, Merced Heights
ffd_name, 520 Orizaba Avenue, San Francisco, CA, 94132
view__c, San Francisco
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1976
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/354656_d1dd3b86-55dc-46e0-a147-7a4c87c97719.jpg
ListingId, a0E1I00000FYmXiUAL
_yoast_indexnow_last_ping, 1710194085