meta_query='key:subdist__c;value:Balboa Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='390356' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70664
[post_author] => 4
[post_date] => 2018-11-30 20:30:38
[post_date_gmt] => 2018-11-30 20:30:38
[post_content] => Residents would tell you the unfortunates live in the adjacent neighborhood, St. Francis Wood. Bounded by Junipero Serra and Ocean Avenue, Balboa Terrace is home to fully detached homes in a classic West of Twin Peaks neighborhood that's not quite St. Francis Wood or Ingleside Terraces but fits perfectly between the two.
[post_title] => Balboa Terrace
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => balboa-terrace
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-11 08:36:12
[post_modified_gmt] => 2024-04-11 15:36:12
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70664
[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, 1728384809
ffd_listing_title, 250 San Benito Way, San Francisco, CA, 94127
ffd_mls_id, 424064959
ffd_salesforce_id, a0EUd0000036H2yMAE
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 250 San Benito Way, San Francisco, CA, 94127
pba__address_pb__c, 250 San Benito Way, San Francisco, CA, 94127
agent_only_remarks__c, Supra lockbox. Offers welcome as they come. Disclosures are at https://app.disclosures.io/link/250-San-Benito-Way-oyob3scr
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Built-In Refrigerator
architectural_style__c, Bungalow
bath_features__c, Shower Stall(s);Tub;Bidet;Radiant Heat
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1922
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2024-09-13T10:47:14.000+0000
days_on_market__c, 25
dom__c, 25
ffd_description_pb, This beautiful 1920's fully detached single family home is located on a scenic, tree lined block in coveted Balboa Terrace. There is a landscaped front yard and beautiful/unique front door. The living area has vaulted ceilings with wood burning fireplace and a window seat at the front windows, perfect for reading a book or enjoying a coffee or cocktail. The kitchen has high end appliances, stone counters, custom lacquer cabinets and island where you can enjoy a bite or enjoy the extra surface space while cooking. The primary suite has a walk-in closet and spa like en suite bathroom with heated floors, soaking tub and separate shower. There are double paned windows and this home has AC, Solar, garage parking in rear and room for 2nd car in rear driveway plus easy street parking in front. Proximate to famed West Portal and Ocean Avenue shopping, dining and MUNI. Lakeside Village, Stern Grove, Stonestown Mall, Chinese American School and easy freeway access are also nearby. Welcome Home!
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 490
pba__hoafrequency_pb__c, Annually
hoa_name__c, Balboa Terrace Homes Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Cathedral Ceiling
ffd_lastmodifieddate, 2024-10-08T10:48:15.000+0000
pba__latitude_pb__c, 37.7323851
pba__latitude_property__c, 37.7323851
laundry_features__c, In Garage
listed_date__c, 2024-08-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dave
pba__listing_agent_lastname__c, Cunningham
listing_agent_mls_id__c, 800745
ffd_listingagentname, Dave Cunningham
listing_agent_number__c, 800745
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, 2388000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=q7J8CxWLdBb&mls=1
pba__longitude_pb__c, -122.4671846
lower_level__c, Bedroom(s),Full Bath(s),Garage
mls_id__c, 424064959
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Tub;Bidet;Radiant Heat
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-09-13
open_house_end__c, 2024-10-12T16:00:00.000+0000
open_house_start__c, 2024-10-12T13:00:00.000+0000
original_price__c, 2388000
overall_days_on_market__c, -82070
parking_access__c, Independent
parking_features__c, Alley Access,Attached,Garage Door Opener,Interior Access
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, 1027.1
pba__propertytype__c, Single Family Residence
ListingId, a0EUd0000036H2yMAE
sale_date__c, 1800-01-01
sale_price__c, 0
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, 2325
size__c, 2325
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, San Benito
subdist__c, Balboa Terrace
ffd_name, 250 San Benito Way, San Francisco, CA, 94127
website_property_type__c, Single Family Home
window_features__c, Bay Window(s);Dual Pane Partial
pba__yearbuilt_pb__c, 1922
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530840999-1.jpg
