meta_query='key:subdist__c;value:Pacific Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215122' 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] => 2024-03-28 07:08:05
[post_modified_gmt] => 2024-03-28 14:08:05
[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
(
)
)
ffd_listing_title, 1890 Green Street, San Francisco, CA, 94123
ffd_mls_id, 506989
ffd_salesforce_id, a0E1I00000THpMnUAL
num_of_fireplaces__c, 2
num_of_rooms__c, 6
of_units__c, 3
address2__c, 1890 Green Street, San Francisco, CA, 94123
pba__address_pb__c, 1890 Green Street, San Francisco, CA, 94123
agent_only_remarks__c, Contact Listing Agent to show Dylan Hunter 415-902-8180 mobile. Disclosure packet available. Escrow Open w/ Jennifer Bratko 2001 Union 94123
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1905
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-09-26T16:47:21.000+0000
days_on_market__c, 1026
dom__c, 4
ffd_description_pb, 3BR/2BA Pacific Heights full floor flat in a 3-unit building with sweeping Bay and GG Bridge views. Modern updates with 1905 period charm. Remodeled kitchen with new quartz counter tops, Bosch refrigerator and dishwasher, and Viking stove. Bowed front bay windows, high ceilings, oak hardwood floors. The open and spacious living room and dining room span the rear of the building presenting sweeping views of the Bay. En suite master bedroom with walk in closets and gas fireplace. Next to a local market for convenience and just around the corner from Union Street shops and restaurants 99 walk score. Shared yard. In-unit w/d. Parking for 1 car.
district__c, SF District 7
entry_level__c, 0
external_listing__c, 1
pba__floor__c, 0
pba__floortype_pb__c, Wood
hoa_dues__c, 300
pba__hoafees__c, 300
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:35:53.000+0000
pba__latitude_pb__c, 37.797043
pba__latitude_property__c, 37.797043
listed_date__c, 2020-09-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dylan
pba__listing_agent_lastname__c, Hunter
listing_agent_mls_id__c, 805632
ffd_listingagentname, Dylan Hunter
listing_agent_number__c, 166015628
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12PUI
listing_office_name__c, Compass
listing_office_number__c, 27690
pba__listingprice_pb__c, 1795000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.430171
pba__lotsize_pb__c, 0
mls_id__c, 506989
master_property__c, a0O1I00000AnLXMUA3
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-26
original_price__c, 1795000
overall_days_on_market__c, 96
parking_access__c, Independent
parking_features__c, Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-09-30
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1104.82
pba__propertytype__c, Condominium
id, a0E1I00000THpMnUAL
sale_date__c, 2020-11-02
sale_price__c, 1950000
selling_agent_mls_id__c, 400638
selling_agent_name__c, Natalie Kitchen
selling_agent_number__c, 1021887
selling_co_agent_mls_id__c, 372883
selling_co_agent_name__c, Nina Hatvany
selling_co_agent_number__c, 372883
selling_co_office_mls_id__c, COMP12PUI
selling_co_office_name__c, Compass
selling_co_office_number__c, 27690
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1765
size__c, 1765
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Green
subdist__c, Pacific Heights
ffd_name, 1890 Green Street, San Francisco, CA, 94123
transportation__c, 1 Block
view__c, Bay;Water;Golden Gate Bridge
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1905
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371118-1.jpg
ListingId, a0E1I00000THpMnUAL