meta_query='key:subdist__c;value:Mission Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375235' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15735
[post_author] => 4
[post_date] => 2018-11-02 20:00:49
[post_date_gmt] => 2018-11-02 20:00:49
[post_content] => Balboa Park BART. Single-family homeowners shuttling south to Silicon Valley or BARTing to downtown and points east. Balboa Park. An urban delight with an indoor swimming pool, outdoor ball fields, and a great playground. Ocean Avenue boutiques, grocery stores, restaurants, and more are a quick meander away.
[post_title] => Mission Terrace
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mission-terrace
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-12 12:23:14
[post_modified_gmt] => 2024-04-12 19:23:14
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15735
[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, 1712228288
ffd_listing_title, 246 Tingley Street, San Francisco, CA, 94112
ffd_mls_id, 424012309
ffd_salesforce_id, a0EUd000001JQ6KMAW
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 0
address2__c, 246 Tingley Street, San Francisco, CA, 94112
pba__address_pb__c, 246 Tingley Street, San Francisco, CA, 94112
agent_only_remarks__c, Offers due Tuesday 3/12/2024 by 12 p.m. Disclosure link will be emailed to you once it's ready. For questions, please call Bailey Cheung at 415-608-9848. Pre-sale escrow opened w/ WFG National Title Insurance Company with Diana Ou-Yang. Buyer is aware that the seller's intention is to complete a 1031 Exchange through this transaction and hereby agrees to cooperate with seller to accomplish same, at no additional cost or liability to buyer. Seller reserves the right to accept, counter, or reject any offer. One of the sellers is a California Real Estate Licensee.
appliances__c, Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Shower Stall(s)
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 2
year_build_text__c, 1911
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-03-01T11:47:40.000+0000
days_on_market__c, 35
dom__c, 13
ffd_description_pb, Home for sale.
district__c, SF District 10
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2024-04-04T10:47:14.000+0000
pba__latitude_pb__c, 37.730539
pba__latitude_property__c, 37.730539
laundry_features__c, Hookups Only
listed_date__c, 2024-02-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Bailey
pba__listing_agent_lastname__c, Cheung
listing_agent_mls_id__c, 802707
ffd_listingagentname, Bailey C Cheung
listing_agent_number__c, 802707
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CAFH
listing_office_name__c, CENTURY 21 Real Estate Alliance
listing_office_number__c, 166014509
pba__listingprice_pb__c, 828000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.435132
mls_id__c, 424012309
main_level__c, Full Bath(s);Bedroom(s);Kitchen
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2024-02-29
original_price__c, 828000
overall_days_on_market__c, -81873
pba__pendingdate__c, 2024-03-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-03T17:03:37.000+0000
price_per_square_foot__c, 825.69
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001JQ6KMAW
sale_date__c, 2024-04-02
sale_price__c, 900000
selling_agent_mls_id__c, 808605
selling_agent_number__c, 1037209
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, CENTURY 21 Real Estate Alliance
pba__status__c, Closed
pba__totalarea_pb__c, 1090
size__c, 1090
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Tingley
subdist__c, Mission Terrace
ffd_name, 246 Tingley Street, San Francisco, CA, 94112
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1911
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530738254-1.jpg