meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='312767' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15733
[post_author] => 4
[post_date] => 2018-11-02 19:54:58
[post_date_gmt] => 2018-11-02 19:54:58
[post_content] => Stroller paradise. Tech-bro ground zero. Sunny, sedate, central. Once upon a time home searches began in Pacific Heights and settled for Noe Valley. Now home searches begin in Noe Valley and settle for Pacific Heights.
[post_title] => Noe Valley
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => noe-valley
[to_ping] =>
[pinged] =>
[post_modified] => 2021-12-01 19:37:36
[post_modified_gmt] => 2021-12-02 03:37:36
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15733
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_wp_page_template PropertyDetails.php
ListingId a0E8W00000WkmA0UAJ
pba__address_pb__c 551 Alvarado Street, San Francisco, CA, 94114
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 2
pba__bedrooms_pb__c 4
days_on_market__c 24
mls_id__c 422665482
pba__totalarea_pb__c 2688
pba__latitude_pb__c 37.7535383
pba__longitude_pb__c -122.433275
pba__state_pb__c CA
pba__status__c Active
pba__street_pb__c Alvarado
listed_date__c 2022-06-04
sale_date__c 1800-01-01
pba__propertytype__c Single Family Residence
pba__listingprice_pb__c 1895000
pba__listingtype__c Sale
sale_price__c 0
address2__c 551 Alvarado Street, San Francisco, CA, 94114
pba__listing_agent_firstname__c Michael
pba__listing_agent_lastname__c Freethy
view__c Valley
pba__halfbathrooms_pb__c 0
parkingspaces__c 0
pba__postalcode_pb__c 94114
year_build_text__c 1900
size__c 2688
subdist__c Noe Valley
listing_agent_mls_id__c 336731
listing_co_office_number__c 0
listing_office_number__c 26293
listing_office_name__c Compass
listing_office_mls_id__c COMP
of_units__c 0
district__c SF District 5
selling_agent_number__c 0
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c -81238
dom__c 20
monthly_parking_fees__c 0
listing_co_agent_number__c 0
price_per_square_foot__c 704.99
original_price__c 1895000
agent_only_remarks__c If writing an offer, must use San Francisco Purchase Agreement with Probate Agreement Purchase Addendum, signed disclosure cover page & proof of funds. Tax rec show 1366 sq ft. Floor plan shows 2688 sq ft, which also includes attic space of 470 sq ft. The only access to attic space is with a step ladder. Buyers & Buyers' agents are advised to get their own determination as to sq ft. Sale is subject to approval of trust beneficiaries. Seller may need up to 45 days in the closing process to send Notice of Proposed Action to beneficiaries. If no objection is received, the sale may proceed. Should any beneficiaries object to terms of sale, sale will be subj to court confirmation, as outlined in the Probate Agreement Purchase Addendum. This property is being sold in its current as-is condition. No warranties are expressed or implied. Link to disclosures: https://app.disclosures.io/link/551-Alvarado-Street-e4xh1y3b
pba__yearbuilt_pb__c 1900
pba__listing_agent_email__c [email protected]
monthlyrent__c 0
external_listing__c 1
pba__latitude_property__c 37.7535383
listing_agent_number__c 336731
on_market_date__c 2022-06-04
open_house_start__c 2022-06-25T14:00:00.000+0000
open_house_end__c 2022-06-25T16:00:00.000+0000
architectural_style__c Victorian
pba__listing_website__c http://www.551Alvarado.com
website_property_type__c Single Family Home
media Array
ListingUpdateDate 2022-06-28T15:58:37