meta_query='key:subdist__c;value:Mission Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='425394' 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, 1741691832
ffd_listing_title, 1277 Cayuga Avenue, San Francisco, CA, 94112
ffd_mls_id, 425006260
ffd_salesforce_id, a0EUd000004EIE6MAO
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
pba__address_pb__c, 1277 Cayuga Avenue, San Francisco, CA, 94112
address2__c, 1277 Cayuga Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Disclosure Link: https://app.disclosures.io/link/1277-Cayuga-Avenue-xxes7nkw Pre-escrow has been opened with Nancy Chan of Chicago Title, seller asks to please keep escrow with her due to some title work. Please call Pat Lee with any questions: 415-810-0665. Broker/Seller does not guarantee the accuracy of the information provided, including square footage,lot size, and/or bedroom/bathroom count (per tax record property is 1375 sqft. That does not include the 2 bedrooms and bath downstairs that was completed in 2006 & 2007 per 3R report). Sqft was measured by Matterport and includes the storage room/office & Laundry Room downstairs but not the garage. The buyer is advised to independently verify the accuracy of this information through personal inspection, building permits, and/or with appropriate professionals (i.e. inspector, appraiser, architect, contractor, etc.) Offer Date Wednesday,Feb 19th by 10 am. With your offer please attach POF, Preapproval Letter and Signed Cover Page of disclosures.
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 5
year_build_text__c, 1932
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2025-02-06T16:47:16.000+0000
days_on_market__c, 33
dom__c, 14
ffd_description_pb, Welcome to 1277 Cayuga Avenue in the sought-after Cayuga Terrace Neighborhood! This spacious 5-bedroom, 3-bathroom home offers plenty of room for living and entertaining. On the main level, you'll find three bedrooms and two bathrooms, a formal dining room, and an updated kitchen with a cozy eat-in dining area. The living room is bathed in natural light thanks to its beautiful arched windows, creating an inviting and open space. The home's detached layout on one side allows for west-facing windows that capture stunning afternoon light. Downstairs, enjoy two additional bedrooms and a full bath, with convenient access to the backyard that is ready for your green thumb! The entire home has been updated with new paint and modern light fixtures throughout, adding a fresh and contemporary feel. The garage provides side-by-side parking, plus a bonus storage/office room and a full laundry room perfect for staying organized. Outside, the low-maintenance backyard includes a retractable fence that allows for convenient large vehicle storage when needed. With its thoughtful layout, updated features, and excellent location, this home is truly a must-see. Schedule a tour today!
district__c, SF District 10
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Metal
fireplace_features__c, Other
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2025-03-11T10:48:21.000+0000
pba__latitude_pb__c, 37.7189213
pba__latitude_property__c, 37.7189213
laundry_features__c, In Garage;Hookups Only;In Basement;Cabinets
listed_date__c, 2024-10-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Patricia
pba__listing_agent_lastname__c, Lee
listing_agent_mls_id__c, 806248
ffd_listingagentname, Pat Lee
listing_agent_number__c, 166016601
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, RBT
listing_office_name__c, Real Brokerage Technologies
listing_office_number__c, 26763
pba__listingprice_pb__c, 988000
pba__listingtype__c, Sale
pba__listing_website__c, https://ascent-digital-solutions.aryeo.com/sites/nxnvngl/unbranded
pba__longitude_pb__c, -122.4434305
mls_id__c, 425006260
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2025-02-06
original_price__c, 988000
overall_days_on_market__c, -82216
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Garage Facing Side,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Back Porch
pba__pendingdate__c, 2025-02-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 2025-03-10T17:19:27.000+0000
price_per_square_foot__c, 574.25
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000004EIE6MAO
sale_date__c, 2025-03-10
sale_price__c, 1280000
security_features__c, Smoke Detector;Carbon Mon Detector;Video System
selling_agent_mls_id__c, MLSL5096556
selling_agent_number__c, 981395430
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Icon Properties
pba__status__c, Closed
pba__totalarea_pb__c, 2229
size__c, 2229
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Cayuga
subdist__c, Mission Terrace
ffd_name, 1277 Cayuga Avenue, San Francisco, CA, 94112
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1932
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530940040-1.jpg