meta_query='key:subdist__c;value:St. Francis Wood|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='239977' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12174
[post_author] => 4
[post_date] => 2018-10-30 00:43:28
[post_date_gmt] => 2018-10-30 00:43:28
[post_content] => Welcome to Pacific Heights west. Developed beginning in the 1910s and 1920s on land that once belonged to Adolph Sutro, it'll make it clear right away that you've arrived in San Francisco's flagship residential park. The construction craze of the era featured the best of city amenities (sidewalks, street lights!) with wide streets, clear neighborhood boundaries, and plenty of green parks for play within the neighborhood.
[post_title] => St. Francis Wood
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => st-francis-wood
[to_ping] =>
[pinged] =>
[post_modified] => 2018-10-30 00:43:28
[post_modified_gmt] => 2018-10-30 00:43:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12174
[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 30 Santa Clara Avenue, San Francisco, CA, 94127
ffd_mls_id 422701295
ffd_salesforce_id a0E8W00000ZLcgyUAD
num_of_fireplaces__c 2
num_of_rooms__c 9
of_units__c 0
address2__c 30 Santa Clara Avenue, San Francisco, CA, 94127
pba__address_pb__c 30 Santa Clara Avenue, San Francisco, CA, 94127
agent_only_remarks__c Easy showing. Appointment Only. virtual tour at https://my.matterport.com/show/?m=3KpaWf7LSUd&brand=0 For showings, please call or text Jason Fang 415-686-5797
appliances__c Dishwasher;Gas Water Heater;Microwave;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c Mediterranean
pba__fullbathrooms_pb__c 4
pba__bedrooms_pb__c 4
year_build_text__c 1925
pba__city_pb__c San Francisco
pba__contingentdate__c 1800-01-01
cooling__c Ceiling Fan(s)
ffd_createddate 2022-10-16T20:46:04.000+0000
days_on_market__c 73
dom__c 51
ffd_description_pb Beautiful Mediterranean Home is updated and remodeled. It is approximately 3,891 square feet per appraiser. 4br 4 bath home with custom brick entryway, many arched windows, and detailed moldings throughout the property. Formal living room and dining room. Kitchen with custom-designed cabinetry with subzero fridge and wolf stove. Primary bedroom with his and hers walk-in closet, and beautifully designed bathroom with stand-alone bathtub. Two upstairs bedroom comes with uniquely designed seating area with surrounding windows overlooking the backyard. Spacious downstairs can be used as playroom or media room. Separate laundry room with extended countertop space, sink and wine cooler. Sunroom leading to backyard. Easy transportation within walking distance to shops, restaurants, and cafes in west portal. San Francis Wood has home owner association.
district__c SF District 4
driveway_sidewalks__c Paved Driveway
entry_level__c 0
external_listing__c 1
fencing__c Wood
fireplace_features__c Living Room;Gas Starter;Free Standing;Family Room
pba__floortype_pb__c Concrete;Marble;Tile;Wood;Parquet
pba__hoafees__c 2861
pba__hoafrequency_pb__c Annually
hoa_name__c St Francis hoa
hoa__c Yes
pba__halfbathrooms_pb__c 0
has_3d_tour__c 1
pba__heatingtype_pb__c Central;Gas
ffd_lastmodifieddate 2022-12-10T11:47:09.000+0000
pba__latitude_pb__c 37.7384997
pba__latitude_property__c 37.7384997
laundry_features__c Inside Room;Washer/Dryer Stacked Included
listed_date__c 2022-10-10
pba__listing_agent_email__c goldensq88@yahoo.com
pba__listing_agent_firstname__c Jason
pba__listing_agent_lastname__c Fang
listing_agent_mls_id__c 302011
ffd_listingagentname Jason Fang
listing_agent_number__c 302011
listing_co_agent_number__c 0
listing_co_office_number__c 0
listing_office_mls_id__c GSQU
listing_office_name__c Golden Square Corp
listing_office_number__c 22957
pba__listingprice_pb__c 4600000
pba__listingtype__c Sale
pba__listing_website__c https://my.matterport.com/show/?m=3KpaWf7LSUd&brand=0
pba__longitude_pb__c -122.4662201
lower_level__c Full Bath(s)
mls_id__c 422701295
main_level__c Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c Tub w/Shower Over;Shower Stall(s);Tub;Low-Flow Toilet(s);Tile;Marble;Dual Flush Toilet
monthly_parking_fees__c 0
monthlyrent__c 0
parkingspaces__c 2
on_market_date__c 2022-10-16
open_house_end__c 2022-12-11T16:00:00.000+0000
open_house_start__c 2022-12-11T14:00:00.000+0000
original_price__c 4600000
overall_days_on_market__c -81372
parking_access__c Side by Side
parking_features__c Detached,Garage Door Opener
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 1182.22
pba__propertytype__c Single Family Residence
ListingId a0E8W00000ZLcgyUAD
roof__c Tile
room_type__c Laundry;Living Room;Dining Room;Family Room
sale_date__c 1800-01-01
sale_price__c 0
security_features__c Security System Owned
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 3891
size__c 3891
pba__state_pb__c CA
stories__c 0
pba__street_pb__c Santa Clara
subdist__c St. Francis Wood
ffd_name 30 Santa Clara Avenue, San Francisco, CA, 94127
website_property_type__c Single Family Home
window_features__c Dual Pane Full;Window Screens
pba__yearbuilt_pb__c 1925
pba__postalcode_pb__c 94127
ffd_media Array
ffd_media_tags Array
ffd_featured_image https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530543487-1.jpg