meta_query='key:subdist__c;value:Mission Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219005' 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-10-31 12:59:35
[post_modified_gmt] => 2024-10-31 19:59:35
[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
(
)
)
ffd_listing_title, 285 Cayuga Avenue, San Francisco, CA, 94112
ffd_mls_id, 421553990
ffd_salesforce_id, a0E1I00000UV4jtUAD
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 285 Cayuga Avenue, San Francisco, CA, 94112
pba__address_pb__c, 285 Cayuga Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Offers, if any, welcome on Monday 7/26 10am. Lower level bed/bath are cute, functional and also considered bonus space. Buyer to investigate as desired. All showings via ShowingTime, please call 800-746-9464. If you are not an SFAR member, ask them to look up your DRE license. Disclosures: https://app.disclosures.io/link/285-Cayuga-Avenue-6tu0ri3x. If not a problem, please use open escrow with Amy Edberg w/ First Am. Square footage: 1,200 per tax records. Lot size: 1,899 sq ft per tax records. Buyer to verify as desired. PLEASE NOTE: The seller and listing agent have NOT verified that the property has been properly disinfected and is NOT providing personal protective equipment at the property to protect against exposure to COVID-19. Any party who enters the home must provide their own appropriate protective items and must enter at their own risk. Buyers should investigate to their satisfaction.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1939
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-07-15T20:51:19.000+0000
days_on_market__c, 1265
dom__c, 11
ffd_description_pb, Wonderfully located Mission Terrace home, minutes from parks, Glen Park Village and BART, and all the vibrant neighborhoods in the south side of SF! Lower level hosts a large bonus room perfect for an office or guest suite, plus 1-car garage and laundry with LG washer/dryer. On the main level, northern light pours into a generous living room with a fireplace, and the updated, open-plan kitchen and dining makes entertaining easy. Enjoy outdoor living in a private central courtyard and the reimagined, fenced backyard. Refinished hardwood floors flow through 2 comfy upstairs bedrooms, and the remodeled upstairs bath has radiant heated ceramic tile floors, quartz counters, Toto toilet, Kohler and American Faucet hardware. Smart-equipped with Nest thermostat, Ring doorbell and camera. Diverse dining and shops in Glen Park Village and Mission St, easy transit at nearby BART and the 280 freeway, and endless recreation at Balboa Park, Glen Canyon Park/Rec Center, McLaren Park and St Mary's.
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, 2022-01-25T15:53:00.000+0000
pba__latitude_pb__c, 37.7300305
pba__latitude_property__c, 37.7300305
listed_date__c, 2021-03-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Danielle
pba__listing_agent_lastname__c, Lazier
listing_agent_mls_id__c, 803117
ffd_listingagentname, Danielle Lazier
listing_agent_number__c, 803117
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP2
listing_office_name__c, Compass
listing_office_number__c, 27341
pba__listingprice_pb__c, 1095000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.youtube.com/watch?v=X0KfvA5ovfw
pba__longitude_pb__c, -122.4343213
mls_id__c, 421553990
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-07-15
original_price__c, 1095000
overall_days_on_market__c, 55
parking_access__c, Tandem
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-07-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1212.5
pba__propertytype__c, Single Family Residence
id, a0E1I00000UV4jtUAD
sale_date__c, 2021-08-20
sale_price__c, 1455000
selling_agent_mls_id__c, 800745
selling_agent_number__c, 800745
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1200
size__c, 1200
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Cayuga
subdist__c, Mission Terrace
ffd_name, 285 Cayuga Avenue, San Francisco, CA, 94112
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1939
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530245464-1.jpg
ListingId, a0E1I00000UV4jtUAD
_yoast_indexnow_last_ping, 1735670527