meta_query='key:subdist__c;value:Mission Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='383733' 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
(
)
)
_yoast_indexnow_last_ping, 1735681741
ffd_listing_title, 178 Cayuga Avenue, San Francisco, CA, 94112
ffd_mls_id, 424030637
ffd_salesforce_id, a0EUd000002FeC7MAK
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 178 Cayuga Avenue, San Francisco, CA, 94112
pba__address_pb__c, 178 Cayuga Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Please text Jamie for private showings. Great expansion potential within already existing lower level (approx 1165 sq ft at garage level). Large backyard almost exactly the same size as the home. Sellers added dry rain drain in backyard, double-pane windows in bedrooms, recessed lighting in living room, GFCI breaker, new water heater in 2023. Property next door with same footprint but smaller backyard sold last year for $1,330,000. Home and pest inspections completed, pest report will be added to disclosures June 17. Escrow already opened with Fidelity National Title (Bethe Battalio) and owners kindly request to keep it with FNT due to work on successor trust title work completed (no court confirmation).
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1941
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-06-07T20:50:02.000+0000
days_on_market__c, 207
dom__c, 24
ffd_description_pb, Charming, period, south-facing, home swimming in abundant natural light. Same family for almost 60 years raised 3 kids. Newly painted fresh facade and original terrazzo stairs. Formal entry with coat closet leading to the spacious living room with recessed lighting, fireplace, large windows, original decorative molding, and original parquet floors. Formal dining room. Kitchen suite with full-height cabinets, breakfast area with skylight, second skylight, and sun-drenched atrium. Airy hallway with third skylight, and linen closet. Two large bedrooms at rear overlooking expansive backyard and garden through double-pane windows. Bathroom with separate stall shower, and soaking bathtub, new vanity, and toto toilet. Internal stairs connect lower level with bonus/family room/home office/home gym overlooking backyard. Large 2+ car garage with great expansion potential plus additional storage space. Expansive, and sun-drenched, flat backyard fully-fenced with mature fruit trees and flowering plants. ADU? Intimate, quiet Slow street great proximity to Glen Park village/BART/Park (10 minute walk), Balboa Park/BART, Ocean Ave including Whole Foods, J-Church, 280/101. Mission Terrace is a hidden gem.
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Full
fireplace_features__c, Living Room
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
interior_features__c, Formal Entry;Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2024-08-10T10:47:43.000+0000
pba__latitude_pb__c, 37.7308329
pba__latitude_property__c, 37.7308329
listed_date__c, 2024-05-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jamie
pba__listing_agent_lastname__c, Ennis
listing_agent_mls_id__c, 815382
ffd_listingagentname, Jamie Ennis
listing_agent_number__c, 1072670
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CITYRE
listing_office_name__c, City Real Estate
listing_office_number__c, 27425
pba__listingprice_pb__c, 1098000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.178cayugaave.com
pba__longitude_pb__c, -122.4326562
mls_id__c, 424030637
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-06-07
original_price__c, 1098000
overall_days_on_market__c, -81972
parking_access__c, Tandem
parking_features__c, Enclosed,Garage Facing Front,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-07-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-08-09T15:43:05.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000002FeC7MAK
sale_date__c, 2024-08-09
sale_price__c, 1130000
selling_agent_mls_id__c, PSHENDAN
selling_agent_number__c, 981066922
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Grand Realty Group
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Cayuga
subdist__c, Mission Terrace
ffd_name, 178 Cayuga Avenue, San Francisco, CA, 94112
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1941
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530783058-1.jpg