meta_query='key:subdist__c;value:St. Francis Wood|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='382851' 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] => 2024-06-04 09:58:17
[post_modified_gmt] => 2024-06-04 16:58:17
[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
(
)
)
_yoast_indexnow_last_ping, 1725533598
ffd_listing_title, 245 Santa Clara Avenue, San Francisco, CA, 94127
ffd_mls_id, 424049857
ffd_salesforce_id, a0EUd000002frs3MAA
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 245 Santa Clara Avenue, San Francisco, CA, 94127
pba__address_pb__c, 245 Santa Clara Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Contact Mark Brown at 415-359-5576 or [email protected] for additional information and showing requests. No lockbox. Large garage has room for 2 independent parking spaces, probably 3 tandem + one outside in driveway. Offers, if any, to be presented on SFAR Purchase Agreement via email to [email protected] by 5pm Tuesday 8/6/24.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range
architectural_style__c, Mediterranean
bath_features__c, Shower Stall(s);Tub;Tile;Window
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 0
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mark Brown
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-07-26T10:49:16.000+0000
days_on_market__c, 41
dom__c, 41
ffd_description_pb, Imposing Mediterranean Revival single-family residence in prestigious St. Francis Wood. An elegant entry foyer welcomes visitors to the main floor and its large living room with fabulous fireplace. A large formal dining room offers walk-out access to a stone patio and the manicured rear yard. An updated kitchen with an island and plentiful cabinetry adjoins both the dining room and the spacious family room. French doors connect the family room to the serene rear yard, with mature plantings and, complete with sunken hot tub, the perfect, secluded retreat! A full bath, guest room and laundry room round out the main floor. 3 spacious bedrooms and 3 full baths on the upper bedroom level include a beautiful primary suite with two walk-in closets, dual vanity, walk-in shower and jetted tub. A guest suite, 3rd bedroom and bath plus library/office are also found here. Beautiful outlooks from the primary suite and office area include partial ocean views! The thoughtful floor plan includes a 3-car garage connecting internally to the home and this large garage level offers additional storage and expansion potential. 245 Santa Clara is a unique opportunity to live in a retreat-like setting with convenient access to Downtown. West Portal Ave with cafes, bars and restaurants is a short walk.
district__c, SF District 4
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 286
pba__hoafrequency_pb__c, Monthly
hoa_name__c, St Francis Homes Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2024-09-05T10:47:51.000+0000
pba__latitude_pb__c, 37.7359547
pba__latitude_property__c, 37.7359547
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2024-07-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Brown
listing_agent_mls_id__c, 197834
ffd_listingagentname, Tim A Brown
listing_agent_number__c, 197834
listing_co_agent_mls_id__c, 807124
listing_co_agent_number__c, 166018264
listing_co_office_mls_id__c, KWADVSF
listing_co_office_name__c, KW Advisors
listing_co_office_number__c, 28861
listing_office_mls_id__c, KWADVSF
listing_office_name__c, KW Advisors
listing_office_number__c, 28861
pba__listingprice_pb__c, 3975000
pba__listingtype__c, Sale
pba__listing_website__c, https://245santaclara.com
pba__longitude_pb__c, -122.4660539
lower_level__c, Garage
mls_id__c, 424049857
main_level__c, Full Bath(s);Kitchen;Living Room;Dining Room;Family Room;Street Entrance
master_bathroom_features__c, Shower Stall(s);Double Sinks;Tile;Jetted Tub;Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 4
on_market_date__c, 2024-07-26
open_house_end__c, 2024-09-08T16:00:00.000+0000
open_house_start__c, 2024-09-08T14:00:00.000+0000
original_price__c, 3975000
overall_days_on_market__c, -82021
parking_access__c, Independent
parking_features__c, 24'+ Deep Garage,Attached,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access,See Remarks
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Patio
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, 1230.65
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000002frs3MAA
room_type__c, Office;Laundry;Living Room;Dining Room;Family Room;Possible Guest;Primary Bathroom;Primary Bedroom
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, 3230
size__c, 3230
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Santa Clara
subdist__c, St. Francis Wood
ffd_name, 245 Santa Clara Avenue, San Francisco, CA, 94127
website_property_type__c, Single Family Home
window_features__c, Dual Pane Partial
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530815645-1.jpg