meta_query='key:subdist__c;value:Pacific Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='296959' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15724
[post_author] => 4
[post_date] => 2018-11-02 19:54:44
[post_date_gmt] => 2018-11-02 19:54:44
[post_content] => The grand estates of San Francisco. Commanding views. Lavishly large lots. Neighbors that you could name drop, but that's not your style. Pacific Heights says it all, without saying a word.
[post_title] => Pacific Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => pacific-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2021-12-01 19:33:36
[post_modified_gmt] => 2021-12-02 03:33:36
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15724
[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 a0E1I000001wT1VUAU
pba__address_pb__c 2244 Vallejo Street, San Francisco, CA, 94123
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 0
pba__bedrooms_pb__c 7
days_on_market__c 1523
mls_id__c 470159
pba__totalarea_pb__c 0
pba__latitude_pb__c 37.795620
pba__longitude_pb__c -122.434273
pba__state_pb__c CA
pba__status__c Closed
pba__street_pb__c Vallejo
listed_date__c 2018-04-04
sale_date__c 2018-05-17
pba__propertytype__c Triplex
pba__listingprice_pb__c 5588000
pba__listingtype__c Sale
sale_price__c 6633000
pba__lotsize_pb__c 0.13
address2__c 2244 Vallejo Street, San Francisco, CA, 94123
pba__listing_agent_firstname__c Miyuki Mia
pba__listing_agent_lastname__c Takami
view__c Marina;Panoramic;Bay;Water;Golden Gate Bridge
pba__halfbathrooms_pb__c 0
parkingspaces__c 7
pba__postalcode_pb__c 94123
year_build_text__c 1909
size__c 0
subdist__c Pacific Heights
listing_agent_mls_id__c 806485
selling_agent_mls_id__c 806485
listing_co_office_number__c 0
listing_office_number__c 26158
listing_office_name__c Keller Williams San Francisco
listing_office_mls_id__c KWRSF
of_units__c 3
vacant__c 1
district__c SF District 7
selling_agent_number__c 166017050
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c 158
dom__c 12
parking__c Attached,Garage,Auto Door
listing_co_agent_number__c 0
price_per_square_foot__c 0
selling_office_name__c Keller Williams San Francisco
original_price__c 5588000
agent_only_remarks__c www.2244vallejo.com. First showing 4/28 2-4pm. For showings, disclosures, offer details, please contact Mia Takami @ 415.728.2596 | [email protected] To view tenant's units, please try to visit during set open houses. Inspection and pest reports available. Trust sale/to be sold As Is. 2 tandem parking in garage plus storage, 5 tandem in driveway. Pre-escrow: Michael Yip/Chicago Title. Offers due on Monday, May 7th by 1pm.
pba__yearbuilt_pb__c 1909
pba__listing_agent_email__c [email protected]
gross_annual_income__c 0
est_total_expenses__c 0
external_listing__c 1
pba__latitude_property__c 37.795620
listing_agent_number__c 166017050
on_market_date__c 2018-04-26
selling_agent_name__c Miyuki Mia Takami
website_property_type__c Triplex
media Array
ListingUpdateDate 2022-06-28T03:38:34