meta_query='key:subdist__c;value:Pacific Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='236896' 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, 2405 Green Street, San Francisco, CA, 94123
ffd_mls_id, 422666993
ffd_salesforce_id, a0E8W00000Xi3ndUAB
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2405 Green Street, San Francisco, CA, 94123
pba__address_pb__c, 2405 Green Street, San Francisco, CA, 94123
agent_only_remarks__c, Easy to show via Supra. Offer Date: Tuesday, June 21st by 1pm.
appliances__c, Dishwasher;Hood Over Range;Free Standing Refrigerator;Ice Maker;Free Standing Electric Range
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1922
pba__city_pb__c, San Francisco
listing_co_agent_name__c, James M Shinbori
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-06-10T01:48:41.000+0000
days_on_market__c, 405
dom__c, 12
ffd_description_pb, Special 4 bedroom, 3.5 bath view home on a desirable block in Pacific Heights. This beautiful, light-filled house is detached on 3 sides and has a coveted floor plan with 4 bedrooms on one level with great views of the Bay, Alcatraz and the city. The main level features a bright living room with a fireplace, formal dining room, inviting kitchen with a breakfast area, laundry room, bathroom and large walk-out deck. Good flow for indoor-outdoor entertaining. The upper level consists of 4 spacious bedrooms, 2 bathrooms and a deck. The lower level, with its own entrance, offers space for a family room or guest suite and office. Tall garage with storage. Roof deck potential. Sought-after location near many renowned restaurants, cafes, shops and fitness studios on Fillmore St., Union St. and Chestnut St. Near treasured outdoor spaces and parks such as the Presidio, Alta Plaza Park, Crissy Field, Marina Green and Palace of Fine Arts. Owned and loved by the same family for 45 years.
district__c, SF District 7
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-07-07T10:47:47.000+0000
pba__latitude_pb__c, 37.7955591
pba__latitude_property__c, 37.7955591
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2022-06-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Eva
pba__listing_agent_lastname__c, Stoyanov
listing_agent_mls_id__c, 803709
ffd_listingagentname, Eva Stoyanov
listing_agent_number__c, 803709
listing_co_agent_mls_id__c, 806892
listing_co_agent_number__c, 166017811
listing_co_office_mls_id__c, COMP7
listing_co_office_name__c, Compass
listing_co_office_number__c, 28751
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 3799000
pba__listingtype__c, Sale
pba__listing_website__c, https://thesfteam.com/properties/2405-green-street
pba__longitude_pb__c, -122.4388768
mls_id__c, 422666993
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-06-09
original_price__c, 3799000
overall_days_on_market__c, -81243
parking_access__c, Independent
parking_features__c, Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2022-06-21
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-07-06T18:07:16.000+0000
price_per_square_foot__c, 1418.1
pba__propertytype__c, Single Family Residence
id, a0E8W00000Xi3ndUAB
sale_date__c, 2022-07-06
sale_price__c, 4026000
selling_agent_mls_id__c, 361136
selling_agent_number__c, 361136
selling_co_agent_mls_id__c, 814864
selling_co_agent_number__c, 1068736
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2839
size__c, 2839
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Green
subdist__c, Pacific Heights
ffd_name, 2405 Green Street, San Francisco, CA, 94123
view__c, City;Bay;Water
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1922
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530475415-1.jpg
ListingId, a0E8W00000Xi3ndUAB