meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376565' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15716
[post_author] => 4
[post_date] => 2018-11-02 19:54:31
[post_date_gmt] => 2018-11-02 19:54:31
[post_content] => Ground zero for gentrification arguments in almost every housing cycle. Flat streets, sunny weather, historical cultural institutions, and colorful street life. Welcome to the Mission, where hipsters zoom down Valencia on tomorrow's transport idea while humble housekeepers hustle hard with their heads down.
[post_title] => The Mission
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => the-mission
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 14:14:15
[post_modified_gmt] => 2024-03-19 21:14:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15716
[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, 1714690885
ffd_listing_title, 2906 Cesar Chavez Street, San Francisco, CA, 94110
ffd_mls_id, 424026568
ffd_salesforce_id, a0EUd000001prkxMAA
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 2906 Cesar Chavez Street, San Francisco, CA, 94110
pba__address_pb__c, 2906 Cesar Chavez Street, San Francisco, CA, 94110
agent_only_remarks__c, Pre-escrow opened with Lynn Chan at FNTC. For showings, disclosures/questions or offer info, please contact Calvin at (415) 812-0235 or [email protected]. Virtual tour available at www.2906CesarChavez.com.
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1916
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-04-25T10:47:08.000+0000
days_on_market__c, 7
dom__c, 7
ffd_description_pb, Situated at the intersection of the hip Bernal Heights & Inner Mission neighborhoods, 2906 Cesar Chavez is an Edwardian charmer looking to welcome its new owners. With Southern exposure, the home is flooded with natural light and possesses many period details from a bygone era. On the main level, you'll find a gracious foyer, a living room with coved ceilings and beautiful brick fireplace, a formal dining room, a chef's kitchen with modern finishes and butcher block island, a powder room and laundry room. As you ascend the stairs to the top, there is a primary bedroom with en-suite bath and two spacious secondary bedrooms. The ground floor boasts an additional bonus room with attached full bath that's perfect for guests. The backyard has multiple entertaining spaces and the two-car tandem garage has ample additional storage space. Conveniently located close to 24th/Mission/Cortland shopping corridors, Precita Park, Bernal Heights Park, Casa Lucas Market, BART, Caltrain, freeways, transportation and all other consumer conveniences.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2024-05-02T22:46:47.000+0000
pba__latitude_pb__c, 37.748597
pba__latitude_property__c, 37.748597
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2024-04-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Calvin
pba__listing_agent_lastname__c, Kam
listing_agent_mls_id__c, 807826
ffd_listingagentname, Calvin M Kam
listing_agent_number__c, 1027255
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1298000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.2906cesarchavez.com/mls/136348446
pba__longitude_pb__c, -122.408036
mls_id__c, 424026568
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-04-25
open_house_end__c, 2024-05-04T16:00:00.000+0000
open_house_start__c, 2024-05-04T14:00:00.000+0000
original_price__c, 1298000
overall_days_on_market__c, -81929
parking_access__c, Tandem
parking_features__c, Attached
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, 643.21
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001prkxMAA
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, 2018
size__c, 2018
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Cesar Chavez
subdist__c, The Mission
ffd_name, 2906 Cesar Chavez Street, San Francisco, CA, 94110
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1916
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530766908-1.jpg
