meta_query='key:subdist__c;value:Pacific Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376585' 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, 1714092987
ffd_listing_title, 2295 Vallejo Street #509, San Francisco, CA, 94123
ffd_mls_id, 424016586
ffd_salesforce_id, a0EUd000001TBKVMA4
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 44
address2__c, 2295 Vallejo Street #509, San Francisco, CA, 94123
pba__address_pb__c, 2295 Vallejo Street #509, San Francisco, CA, 94123
agent_only_remarks__c, Please call Charlene for showings 415-608-8585
appliances__c, Electric Cook Top
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1975
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-03-23
ffd_createddate, 2024-03-18T10:47:32.000+0000
days_on_market__c, 39
dom__c, 17
ffd_description_pb, This special Pacific Heights penthouse condo has World-Class 180 degree views spanning from the Golden Gate Bridge to Berkeley! There are breathtaking views of the Presidio, the Golden Gate Bridge, the Marin Headlands, Sausalito, Mt. Tam., Tiburon, Angel Island, Crissy Field, Russian Hill, the East Bay Hills and more! PH509 is a gem, having had only two owners since 1975. A skylight, solatubes and the beautiful northern exposure flood the condo with natural light. There is a gas fireplace and beautiful white oak hardwood flooring throughout. Pacific Heights Place is a luxury mid-rise situated alongside the Fillmore stairs. The buildings amenities include a glass elevator, a common panoramic roof deck, laundry facilities, an exercise room with a sauna, a community room, security cameras, and a secure mail room. This unit has deeded outdoor space, one-car assigned garage parking and an adjacent storage locker. 2295 Vallejo is a walker's paradise with a 99 walk score and is in close vicinity to the Marina, Upper Fillmore, Chestnut Street, Polk Street, Union Street, Chinatown, the Embarcadero and much more!
district__c, SF District 7
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 747
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant
interior_features__c, Skylight Tube;Skylight(s)
ffd_lastmodifieddate, 2024-04-26T00:46:50.000+0000
pba__latitude_pb__c, 37.794987
pba__latitude_property__c, 37.794987
listed_date__c, 2024-03-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Charlene
pba__listing_agent_lastname__c, Attard
listing_agent_mls_id__c, 324325
ffd_listingagentname, Charlene A Attard
listing_agent_number__c, 324325
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP3
listing_office_name__c, Compass
listing_office_number__c, 27342
pba__listingprice_pb__c, 849000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.434747
mls_id__c, 424016586
master_property__c, a0O1I000001VhsNUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-03-17
original_price__c, 849000
overall_days_on_market__c, -81890
parking_access__c, Side by Side
parking_features__c, Garage Door Opener,Interior Access
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2024-04-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-25T09:56:47.000+0000
price_per_square_foot__c, 1538.46
pba__propertytype__c, Condominium
ListingId, a0EUd000001TBKVMA4
sale_date__c, 2024-04-22
sale_price__c, 1000000
selling_agent_mls_id__c, A334915
selling_agent_number__c, 981091879
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Golden Gate Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 650
size__c, 650
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Vallejo
subdist__c, Pacific Heights
ffd_name, 2295 Vallejo Street #509, San Francisco, CA, 94123
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1975
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530746494-1.jpg