meta_query='key:subdist__c;value:Pacific Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='238803' 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] => 2018-11-02 19:54:44
[post_modified_gmt] => 2018-11-02 19:54:44
[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, 2638 Webster 2640 Street, San Francisco, CA, 94123
ffd_mls_id, 422623642
ffd_salesforce_id, a0E8W00000VtlcUUAR
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2638 Webster 2640 Street, San Francisco, CA, 94123
pba__address_pb__c, 2638 Webster 2640 Street, San Francisco, CA, 94123
agent_only_remarks__c, We will be prepping the property to market at the beginning of April. Sellers are willing to show and sell now. Please call me at 415-305-5172 for more information and showings.
appliances__c, Dishwasher;Built-In Gas Range;Double Oven;Built-In Refrigerator;Gas Cook Top;Built-In Freezer
bath_features__c, Tile
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1940
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-03-08T19:52:31.000+0000
days_on_market__c, 295
dom__c, 0
ffd_description_pb, 2638-40 Webster Preview: Fabulous 3 bedroom, 3 bath, 3+ car home in the heart of Pacific Heights. Great scale, lovely condition and fabulous entertaining flow await you. A large living room with Golden Gate Bridge views flows into a formal dining room adjacent to an interior courtyard. A breakfast area and kitchen opening into a family room and deck out to the large, flat backyard, finish the public spaces on the main floor. A generous sized bedroom overlooking the backyard and en-suite bathroom also adorn this level. The second floor is home to two large bedrooms and two baths. The primary bedroom has the same Golden Gate Bridge views as the living room, a remodeled bathroom and walk in closet. And don't forget the garage - high ceilings, loads of space, and a home workshop!
district__c, SF District 7
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-12-17T00:53:09.000+0000
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2022-01-25
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Kelly
pba__listing_agent_lastname__c, Canady
listing_agent_mls_id__c, 804331
ffd_listingagentname, Kelly L Canady
listing_agent_number__c, 166013856
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB4
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 28397
pba__listingprice_pb__c, 3795000
pba__listingtype__c, Sale
lower_level__c, Garage,Street Entrance
mls_id__c, 422623642
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Double Sinks;Walk-In Closet;Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2022-03-08
original_price__c, 3795000
overall_days_on_market__c, -81150
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Interior Access,Side-by-Side,Tandem Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-03-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1398.6
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000VtlcUUAR
room_type__c, Kitchen;Living Room;Dining Room;Family Room;Workshop;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+
sale_date__c, 2022-03-08
sale_price__c, 4000000
selling_agent_mls_id__c, 400402
selling_agent_number__c, 400402
selling_co_agent_mls_id__c, 816742
selling_co_agent_number__c, 1075684
selling_co_office_mls_id__c, STHB
selling_co_office_name__c, Sotheby's International Realty
selling_co_office_number__c, 2050
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 2860
size__c, 2860
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Webster
subdist__c, Pacific Heights
ffd_name, 2638 Webster 2640 Street, San Francisco, CA, 94123
view__c, Bay;Golden Gate Bridge
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1940
pba__postalcode_pb__c, 94123