meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='329667' 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] => 2022-12-05 02:53:28
[post_modified_gmt] => 2022-12-05 10:53:28
[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
(
)
)
ffd_listing_title, 2959 23rd Street, San Francisco, CA, 94110
ffd_mls_id, 423733804
ffd_salesforce_id, a0E8W00000bbDTSUA2
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2959 23rd Street, San Francisco, CA, 94110
pba__address_pb__c, 2959 23rd Street, San Francisco, CA, 94110
agent_only_remarks__c, Escrow opened with Janette Marcelo. Agent preview Friday, April 14, 12-1 pm. Please call Kathleen DiGrande at 415.766.1132 for showing instructions.
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1923
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Kathleen DiGrande
pba__contingentdate__c, 2023-05-20
cooling__c, None
ffd_createddate, 2023-04-13T16:48:11.000+0000
days_on_market__c, 40
dom__c, 39
ffd_description_pb, Generous space, exquisite craftsmanship and inspired design meld beautifully in this light-filled, newly-renovated Mission District home. Located in the heart of San Francisco's sunniest neighborhood, enjoy a wonderful indoor-outdoor lifestyle, nearly 3,000 SF, 4+ bedrooms, 3.5 baths, a 1-car garage and more. An entry foyer on the ground level leads you into the massive family room, complete with wet bar and direct access to the sunny south-facing rear garden. Also on this level are a 4th bedroom, full bath, laundry area and garage. On the second floor is the heart of the home, a stunning open kitchen and dining area with walk-out deck, a generous living room and half bath. Top floor includes 3 sizable bedrooms including the gorgeous primary suite with a spa-like bath and balcony with Bernal Hill views. Another set of laundry machines is conveniently found on this level. Highlights include 1-car garage with EV charger, wood floors and recessed lighting.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-05-23T01:48:07.000+0000
pba__latitude_pb__c, 37.7541076
pba__latitude_property__c, 37.7541076
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2023-04-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mary
pba__listing_agent_lastname__c, Macpherson
listing_agent_mls_id__c, 806933
ffd_listingagentname, Mary Macpherson
listing_agent_number__c, 166017897
listing_co_agent_mls_id__c, 810528
listing_co_agent_number__c, 1046694
listing_co_office_mls_id__c, VANTAGE
listing_co_office_name__c, Vantage Realty
listing_co_office_number__c, 28995
listing_office_mls_id__c, VANTAGE
listing_office_name__c, Vantage Realty
listing_office_number__c, 28995
pba__listingprice_pb__c, 3300000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.retreatinthemission.com/#
pba__longitude_pb__c, -122.4114093
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 423733804
main_level__c, Partial Bath(s);Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Tub;Double Sinks
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-04-13
open_house_end__c, 2023-05-23T16:00:00.000+0000
open_house_start__c, 2023-05-23T14:00:00.000+0000
original_price__c, 3380000
overall_days_on_market__c, -81551
parking_access__c, Independent
parking_features__c, EV Charging,Garage Door Opener,Garage Facing Front,Interior Access
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, 1110.36
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bbDTSUA2
room_type__c, Office;Laundry;Kitchen;Living Room;Dining Room;Family Room;Great Room;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Security Gate
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Contingent - Show
pba__totalarea_pb__c, 2972
size__c, 2972
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, 23rd
subdist__c, The Mission
ffd_name, 2959 23rd Street, San Francisco, CA, 94110
view__c, Downtown
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1923
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530602870-1.jpg