meta_query='key:subdist__c;value:Mission Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='422771' 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, 1736295553
ffd_listing_title, 57 Cayuga Avenue, San Francisco, CA, 94112
ffd_mls_id, 425000724
ffd_salesforce_id, a0EUd000003zfz3MAA
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 0
pba__address_pb__c, 57 Cayuga Avenue, San Francisco, CA, 94112
address2__c, 57 Cayuga Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Buyers and agents are required to sign a Hold Harmless agreement before viewing the property. Property is bank owned and as a result, disclosures are very limited. Buyer acknowledges and agrees that Buyer is accepting the Property 'As Is,' without any warranties, representations or guarantees, either expressed or implied, of any kind, nature or type whatsoever from or on behalf of the Seller. All initial offers must be submitted via PropOffers.com by the BUYER AGENT ONLY. SELLING AGENT IS TO PAY A $200.00 PLUS SALES TAX OFFER MANAGEMENT FEE AT CLOSING OF ANY ACCEPTED OFFER. This property is part of a First Look program. It allows owner occupant buyers to have their offers negotiated on day 8 of being listed. Owner occupants are those buyers that will occupy the property as their principal residence within 60 days of closing and will maintain their occupancy for at least 1 year. These buyers are required to sign an Owner Occupant Certification as part of the contract. An investor, trust, vacation or part-time residence, or purchasing for another person will be considered an Investor and are not eligible for First Look. Investors are welcomed to make offers the initial 30 DOM, but will not be countered until day 31. Please text/call agent for any questions.
appliances__c, Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over;Window
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2025-01-07T11:47:33.000+0000
days_on_market__c, 1
dom__c, 1
ffd_description_pb, Welcome to this charming 2-bedroom, 1-bath Edwardian home, brimming with potential for those looking to create their dream residence. Nestled in a tranquil neighborhood, this property features a cozy layout, making it an ideal choice for both first-time buyers and seasoned investors seeking a rewarding project. As you step inside, you'll discover a living area that invites creativity and personalization. The kitchen and bathroom are in need of some tender loving care, providing an excellent opportunity to design stylish and functional spaces that meet contemporary standards while reflecting your unique taste. Additionally, the home boasts a full basement, which offers substantial potential for expansion or the creation of an ADU, thereby adding even more value to the property. A detached one-car garage faces Alemany Blvd, providing convenient parking and ample storage options. This delightful home is located near local amenities and public transportation, making it easy to access shops, restaurants, freeways, and parks. Bring your vision and handyman skills to breathe new life into this charming Edwardian home and transform it into your ideal living space!
district__c, SF District 10
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced
pba__floortype_pb__c, Linoleum;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2025-01-07T23:47:38.000+0000
pba__latitude_pb__c, 37.7312884
pba__latitude_property__c, 37.7312884
laundry_features__c, In Basement
listed_date__c, 2025-01-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Anh
pba__listing_agent_lastname__c, Pham
listing_agent_mls_id__c, 807249
ffd_listingagentname, Anh H Pham
listing_agent_number__c, 1012152
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, SKYGR
listing_office_name__c, SkyGroup Realty Inc.
listing_office_number__c, 25039
pba__listingprice_pb__c, 799900
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4300245
mls_id__c, 425000724
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Street Entrance
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2025-01-06
open_house_end__c, 2025-01-12T14:00:00.000+0000
open_house_start__c, 2025-01-12T12:00:00.000+0000
original_price__c, 799900
overall_days_on_market__c, -82185
parking_access__c, Independent
parking_features__c, Detached
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, 999.88
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000003zfz3MAA
roof__c, Tar/Gravel;Flat
room_type__c, Storage;Office;Kitchen;Living Room
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 800
size__c, 800
pba__state_pb__c, CA
stories__c, 1
pba__street_pb__c, Cayuga
subdist__c, Mission Terrace
ffd_name, 57 Cayuga Avenue, San Francisco, CA, 94112
website_property_type__c, Single Family Home
window_features__c, Window Coverings
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530926990-1.jpg