meta_query='key:subdist__c;value:Mission Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214097' 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, 239 Seneca Avenue, San Francisco, CA, 94112
ffd_mls_id, 503997
ffd_salesforce_id, a0E1I00000TG2Z8UAL
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 239 Seneca Avenue, San Francisco, CA, 94112
pba__address_pb__c, 239 Seneca Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Offer date set for Tuesday,September 8th by 12pm. Please use pre-sale escrow opened with Barbara Jimenez at Chicago Title (415) 252-2757. The property will be shown by appointment only under current COVID Guidelines and signed CAR PEAD form,please bring your own mask and gloves. All showings can be scheduled upon reviewing the property via 3-D video https://my.matterport.com/show/?m=5SmFyJD4rrg&mls=1&ts=1 Please schedule your appointments with listing agent at https://calendly.com/arevik-2/239-seneca
appliances__c, Dishwasher;Gas Water Heater;Gas Range;Refrigerator;Hood Over Range
architectural_style__c, Marina;Traditional
bath_features__c, Shower Stall(s);Tub;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1930
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-08-24T17:45:22.000+0000
days_on_market__c, 1059
dom__c, 16
ffd_description_pb, Located less than three blocks from BART, this detached single-family home boasts an abundance of natural light and beautifully restored hardwood floors throughout. It is ideally situated on an oversized lot that spans 3859 sq ft per tax records. It has three bedrooms on one level, formal living and dining rooms, a huge backyard and a breakfast room (possible home office). The huge bonus room on the garden level at the rear of the garage could make an outstanding home office, yoga/exercise room or family room. This beautiful home has a flexible floor plan and wonderful potential for expansion. The sizable footprint of the building makes it the perfect project for contractors and families who want to create their dream home. This home awaits your personal touches and creative visions that will restore it to a new and beautiful grandeur. Near public transportation, freeway access, City College and .6 miles to Whole Foods on Ocean Ave.
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Linoleum;Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:31:24.000+0000
pba__latitude_pb__c, 37.7203627
pba__latitude_property__c, 37.7203627
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2020-08-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Arevik
pba__listing_agent_lastname__c, Makasdjian
listing_agent_mls_id__c, 804544
ffd_listingagentname, Arevik Makasdjian
listing_agent_number__c, 166014134
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STERLING
listing_office_name__c, Sterling Homes
listing_office_number__c, 27576
pba__listingprice_pb__c, 1099000
pba__listingtype__c, Sale
pba__listing_website__c, https://fusion.realtourvision.com/idx/816621
pba__longitude_pb__c, -122.4432409
pba__lotsize_pb__c, 0.09
mls_id__c, 503997
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-08-24
original_price__c, 1099000
overall_days_on_market__c, 160
parking__c, Attached,Garage,Auto Door,Interior Access
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Covered Patio
pba__pendingdate__c, 2020-09-09
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1098.66
pba__propertytype__c, Single Family Residence
id, a0E1I00000TG2Z8UAL
roof__c, Tar/Gravel
room_type__c, Storage;Bonus Room
sale_date__c, 2020-10-13
sale_price__c, 1481000
security_features__c, Smoke Detector;Security Gate
selling_agent_mls_id__c, 807221
selling_agent_name__c, Sophie Lee
selling_agent_number__c, 1009121
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Gold Cal Real Estate & Investment
pba__status__c, Closed
pba__totalarea_pb__c, 1348
size__c, 1348
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Seneca
subdist__c, Mission Terrace
ffd_name, 239 Seneca Avenue, San Francisco, CA, 94112
transportation__c, 3 Blocks
view__c, Garden/Greenbelt
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1930
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/368508-1.jpg
ListingId, a0E1I00000TG2Z8UAL