254 Santa Paula Avenue, San Francisco, CA, 94127 - Property Description

_yoast_indexnow_last_ping,1728388487

ffd_listing_title,125 Yerba Buena Avenue, San Francisco, CA, 94127

ffd_mls_id,424067419

ffd_salesforce_id,a0EUd000003DUD4MAO

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,0

address2__c,125 Yerba Buena Avenue, San Francisco, CA, 94127

pba__address_pb__c,125 Yerba Buena Avenue, San Francisco, CA, 94127

agent_only_remarks__c,Title opened with Michelle Patterson at WFG Title. Disclosures available via link from listing agent. Reach out to agent regarding offer instructions. Info regarding security updates available via agent.

appliances__c,Dishwasher;Hood Over Range;Gas Cook Top

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,4

year_build_text__c,0

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Steven Huang

pba__contingentdate__c,2024-10-07

ffd_createddate,2024-09-27T15:47:24.000+0000

days_on_market__c,11

dom__c,11

ffd_description_pb,Nestled in desirable St Francis Wood, this peaceful sanctuary welcomes you with elegant features and ample living space. Discover tall ceilings, classic parquet flooring, and tastefully updated lighting throughout. From the gorgeous living room with stunning ocean views framed by floor to ceiling windows, to its chef's kitchen with stainless steel appliances and landscaped backyard, entertaining guests is a breeze. A well-lit formal dining room, sunroom (perfect for a breakfast nook or second office), and guest bedroom complete the main level. 3 sizable bedrooms and 2 bathrooms sit on the top level, with the large primary suite offering continuation of the ocean views to enjoy. The home also features a media room on the lower level plus a large garage with a loft for storage or workout equipment. With its smart design and high-end security features, this home has been reimagined into a secure haven that offers unparalleled privacy for its next residents. Neighborhood perks include easy access to St. Francis Wood Tennis Courts & playground and nearby shopping & dining experiences on West Portal Ave, Ocean ave, Stern Grove, and Stonestown Galleria, plus easy freeway access!

district__c,SF District 4

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,2903

pba__hoafrequency_pb__c,Annually

hoa_name__c,St. Francis Homes Association

hoa__c,Yes

pba__halfbathrooms_pb__c,1

ffd_lastmodifieddate,2024-10-08T11:47:26.000+0000

pba__latitude_pb__c,37.7369171

pba__latitude_property__c,37.7369171

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included;Upper Floor

listed_date__c,2024-09-20

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Daniel

pba__listing_agent_lastname__c,Risman-Jones

listing_agent_mls_id__c,400612

ffd_listingagentname,Daniel J Risman-Jones

listing_agent_number__c,1023994

listing_co_agent_mls_id__c,810090

listing_co_agent_number__c,1044640

listing_co_office_mls_id__c,ASCEND

listing_co_office_name__c,Ascend Real Estate

listing_co_office_number__c,27278

listing_office_mls_id__c,ASCEND

listing_office_name__c,Ascend Real Estate

listing_office_number__c,27278

pba__listingprice_pb__c,3598000

pba__listingtype__c,Sale

pba__listing_website__c,https://view.ricoh360.com/35906b63-e8ff-412c-bcfe-d7477012832a

pba__longitude_pb__c,-122.4626282

lower_level__c,Family Room,Partial Bath(s)

mls_id__c,424067419

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,2024-09-27

open_house_end__c,2024-10-08T15:00:00.000+0000

open_house_start__c,2024-10-08T13:00:00.000+0000

original_price__c,3598000

overall_days_on_market__c,-82084

parking_access__c,Independent

parking_features__c,Covered,Garage Door Opener,Garage Facing Front,Interior Access,Side-by-Side

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,1220.07

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000003DUD4MAO

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Other

selling_agent_number__c,0

selling_co_agent_number__c,0

selling_co_office_number__c,0

pba__status__c,Contingent - Show

pba__totalarea_pb__c,2949

size__c,2949

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Yerba Buena

subdist__c,St. Francis Wood

ffd_name,125 Yerba Buena Avenue, San Francisco, CA, 94127

view__c,Ocean;City;San Francisco

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full

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/530849532-1.jpg

_yoast_indexnow_last_ping,1727520842

ffd_listing_title,93 San Pablo Avenue, San Francisco, CA, 94127

ffd_mls_id,424066956

ffd_salesforce_id,a0EUd0000039i6fMAA

num_of_fireplaces__c,4

num_of_rooms__c,7

of_units__c,0

address2__c,93 San Pablo Avenue, San Francisco, CA, 94127

pba__address_pb__c,93 San Pablo Avenue, San Francisco, CA, 94127

agent_only_remarks__c,PLEASE TEXT: Your digital biz card (iPhone contact card if you have one, or pic) and showing date and time to Corey 323.459.2012 Thank you!

architectural_style__c,Tudor

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,5

year_build_text__c,1927

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Rafi Sarkis Ekmekian

pba__contingentdate__c,1800-01-01

cooling__c,Evaporative Cooler

ffd_createddate,2024-09-19T21:48:02.000+0000

days_on_market__c,9

dom__c,9

ffd_description_pb,Perched high on the hill in the coveted Saint Francis Wood neighborhood, this timeless Tudor-style home offers breathtaking ocean views, central access to the city, and was meticulously remodeled in 2008 with high-end materials, finishes, and fixtures throughout. The spacious open floor plan seamlessly connects the deluxe chef's kitchen to the inviting family room, which opens to a lush garden, perfect for entertaining or relaxing. The private primary suite includes a terrace with panoramic views, providing a serene retreat. The home features a premium sound system for high-quality audio, elegant hardwood floors that add timeless beauty, and four gas fireplaces that create a warm and inviting atmosphere. Motorized shades offer effortless control of the natural light and privacy, while a new furnace ensures modern comfort and efficiency. The property also includes a bonus room that could be used as sixth bedroom or media room, and a two-car attached garage providing convenient parking and direct access. Experience coastal living in this turn-key home, where elegance meets comfort.

district__c,SF District 4

entry_level__c,0

external_listing__c,1

fireplace_features__c,Gas Piped;Electric

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

ffd_lastmodifieddate,2024-09-28T10:47:43.000+0000

pba__latitude_pb__c,37.7389694

pba__latitude_property__c,37.7389694

laundry_features__c,Laundry Closet

listed_date__c,2024-09-19

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Corey

pba__listing_agent_lastname__c,Trevor

listing_agent_mls_id__c,819509

ffd_listingagentname,Corey A Trevor

listing_agent_number__c,1078153

listing_co_agent_mls_id__c,819510

listing_co_agent_number__c,1078152

listing_co_office_mls_id__c,EXPRE

listing_co_office_name__c,eXp Realty of California, Inc

listing_co_office_number__c,26334

listing_office_mls_id__c,EXPRE

listing_office_name__c,eXp Realty of California, Inc

listing_office_number__c,26334

pba__listingprice_pb__c,3980000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4621822

mls_id__c,424066956

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-09-19

original_price__c,3980000

overall_days_on_market__c,-82076

parking_access__c,Side by Side

parking_features__c,Attached

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,1142.69

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000039i6fMAA

roof__c,Shingle;Slate

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,3483

size__c,3483

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,San Pablo

subdist__c,St. Francis Wood

ffd_name,93 San Pablo Avenue, San Francisco, CA, 94127

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1927

pba__postalcode_pb__c,94127

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530844700-1.jpg

_yoast_indexnow_last_ping,1724151588

ffd_listing_title,8 San Lorenzo Way, San Francisco, CA, 94127

ffd_mls_id,424058660

ffd_salesforce_id,a0EUd000002tXqGMAU

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

address2__c,8 San Lorenzo Way, San Francisco, CA, 94127

pba__address_pb__c,8 San Lorenzo Way, San Francisco, CA, 94127

agent_only_remarks__c,Approved Plan. Owner took more than 8 years to get entitlement.

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,3

year_build_text__c,0

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-08-20T10:49:54.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Nestled at the corner of San Lorenzo Way of the prestigious St Francis Wood, this expansive 4,002 square foot vacant lot offers a once-in-a-lifetime opportunity for discerning investors and visionary developers. Imagine the possibilities in one of San Francisco's most sought-after neighborhoods, just a stone's throw from the vibrant West Portal Station and surrounded by an array of shops, banks, and retail spaces with a very walkable score of 90/100. It's also located within one of the great school districts. This prime piece of real estate comes with an approved plan of a 3-level house (total gross area: 3,959 sqf). A sophisticated design featuring a basement with a two-car garage and 2 storage rooms of 838 sqf. You enter the first floor with a stunning Living Room of 19 ft height ceiling; and an ensuite bedroom, 1.5 baths and the windowed Dining Room. An elegant second floor is featured with a grand Master bedroom of big walk-in closets and bathroom, as well as another ensuite bedroom. The potential here is truly boundless. Seize this rare chance to create a bespoke masterpiece in an unbeatable location. This is more than just a lot. It's the foundation for your future. https://www.8sanlorenzoway.com/

district__c,SF District 4

entry_level__c,0

external_listing__c,1

pba__hoafees__c,2863

pba__hoafrequency_pb__c,Annually

hoa_name__c,St. Francis Association

hoa__c,Yes

pba__halfbathrooms_pb__c,1

interior_features__c,Formal Entry

ffd_lastmodifieddate,2024-08-20T10:49:54.000+0000

pba__latitude_pb__c,37.739708

pba__latitude_property__c,37.739708

listed_date__c,2024-08-18

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Dickson

pba__listing_agent_lastname__c,Sum

listing_agent_mls_id__c,806360

ffd_listingagentname,Dickson Sum

listing_agent_number__c,166016816

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,JODI

listing_office_name__c,JODI Group

listing_office_number__c,15618

pba__listingprice_pb__c,2100000

pba__listingtype__c,Sale

pba__listing_website__c,https://www.8sanlorenzoway.com/

pba__longitude_pb__c,-122.464343

mls_id__c,424058660

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-08-19

original_price__c,2100000

overall_days_on_market__c,-82045

parking_access__c,Side by Side

parking_features__c,Side-by-Side

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,0

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000002tXqGMAU

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,0

size__c,0

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,San Lorenzo

subdist__c,St. Francis Wood

ffd_name,8 San Lorenzo Way, San Francisco, CA, 94127

website_property_type__c,Single Family Home

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/530828808-1.jpg

_yoast_indexnow_last_ping,1728953549

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,80

dom__c,80

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-10-15T00:48:17.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-10-15T15:00:00.000+0000

open_house_start__c,2024-10-15T13: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