meta_query='key:subdist__c;value:Pacific Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='340999' 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
(
)
)
_yoast_indexnow_last_ping, 1711148922
ffd_listing_title, 2741 Vallejo Street, San Francisco, CA, 94123
ffd_mls_id, 423919727
ffd_salesforce_id, a0E8W00000dx9XZUAY
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2741 Vallejo Street, San Francisco, CA, 94123
pba__address_pb__c, 2741 Vallejo Street, San Francisco, CA, 94123
agent_only_remarks__c, New price is a minimum overbid price. Offers must be submitted in person to listing broker along with a cashiers check for $380,000 made to "Old Republic Title Company", by 12 Noon on Monday, April 1st, 2024. All offers should have proof of financial ability to close the transaction and must be non-contingent. Offers should be made subject to bankruptcy court approval. There will be a live, public auction at 10am on Wednesday April 3rd, 2024 in the event that there is one or more qualified overbid. At such auction, bids will be made in $10,000 increments, starting at the highest overbid price. Only qualified over-bidders will be permitted to take part in the auction - that is, only bidders that have submitted a qualified overbid by 12 Noon on Monday April 1. Showings of the home can be scheduled only on the following days and times and appointments must be made in advance: Mon 3/18, Wed 3/20, Mon 3/25, Wed 3/27 all at 9:00am-11:00am. For more information contact Mark Brown, [email protected] / 415-359-5576
appliances__c, Disposal;Hood Over Range;Built-In Refrigerator;Gas Cook Top;Built-In Freezer;Built-In Electric Oven
pba__fullbathrooms_pb__c, 5
pba__bedrooms_pb__c, 5
year_build_text__c, 1907
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mark Brown
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-10-30T19:47:41.000+0000
days_on_market__c, 144
dom__c, 144
ffd_description_pb, New list price - this is a minimum overbid price. Beautiful four-level single family view home in sought-after Pacific Heights! Views of the Golden Gate Bridge and Bay are found on each level of living space. Updated floor plan incorporates the scale you would expect of a grand Pac Heights home and includes three ensuite bedrooms on one level. The luxuriously modern design culminates in a top-level family room, complete with wet bar and breathtaking views for impressive entertaining. Balconies and decks allow easy access to outdoor space on each level. The gorgeous, honed stone finishes are sublime and include walls of marble in the entry and kitchen/dining areas. Radiant heat throughout plus air conditioning. Terraced rear yard includes putting green and great entertainment spaces. Located close to the playgrounds and outdoor spaces of the Presidio and Crissy Field, and to the shops and eateries of Union and Fillmore Streets.
district__c, SF District 7
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
pba__heatingtype_pb__c, Radiant Floor
ffd_lastmodifieddate, 2024-03-22T22:47:04.000+0000
pba__latitude_pb__c, 37.7940786
pba__latitude_property__c, 37.7940786
laundry_features__c, Inside Room;Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2023-10-30
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Brown
listing_agent_mls_id__c, 197834
ffd_listingagentname, Tim A Brown
listing_agent_number__c, 197834
listing_co_agent_mls_id__c, 807124
listing_co_agent_number__c, 166018264
listing_co_office_mls_id__c, KWADVSF
listing_co_office_name__c, KW Advisors
listing_co_office_number__c, 28861
listing_office_mls_id__c, KWADVSF
listing_office_name__c, KW Advisors
listing_office_number__c, 28861
pba__listingprice_pb__c, 7600000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.2741vallejo.com
pba__longitude_pb__c, -122.4424595
mls_id__c, 423919727
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-10-30
open_house_end__c, 2024-03-25T11:00:00.000+0000
open_house_start__c, 2024-03-25T09:00:00.000+0000
original_price__c, 9995000
overall_days_on_market__c, -81751
parking_access__c, Side by Side
parking_features__c, Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1766.21
price_reduced__c, 1
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000dx9XZUAY
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 4303
size__c, 4303
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Vallejo
subdist__c, Pacific Heights
ffd_name, 2741 Vallejo Street, San Francisco, CA, 94123
view__c, Bay;Golden Gate Bridge
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1907
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530698711-1.jpg