3106 Turk Boulevard, San Francisco, CA, 94118 - Property Description

_yoast_indexnow_last_ping,1713567716

ffd_listing_title,574 Arguello 576 Boulevard, San Francisco, CA, 94118

ffd_mls_id,424024898

ffd_salesforce_id,a0EUd000001mqerMAA

num_of_rooms__c,10

of_units__c,2

address2__c,574 Arguello 576 Boulevard, San Francisco, CA, 94118

pba__address_pb__c,574 Arguello 576 Boulevard, San Francisco, CA, 94118

agent_only_remarks__c,Email [email protected] for showing requests, no Showing Time requests. Escrow opened with Mark Adams of WFG, and seller requests it stays there. Multiple square foot measurements, and buyer to satisfy themselves. Total building sqft measured at 4,905. Buyer should test parking to their satisfaction. Please use most current SFAR Purchase Contract, allow 24 hours to respond, include fully executed disclosure package, and 1 business day for the initial deposit.

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,4

year_build_text__c,1938

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-19T16:48:53.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,This amazing vacant 2-unit building showcases grand scale, amazing natural light, gorgeous period detail, and is located on a premier block of Lone Mountain, just steps from Rossi Park, Golden Gate Park, and bustling Clement Street. This distinctive property offers two exquisite full floor flats featuring 2 bedrooms, 1 bathroom, an expansive living room perfect for entertaining, formal dining room, and gracious chef's kitchen. There is also a large 3+ car garage, multiple storage rooms with expansion potential, and a lush landscaped shared backyard. This property offers an excellent opportunity for a family compound, an owner user with rental income, or an investment building with strong income, perfectly located in a highly coveted neighborhood location.

district__c,SF District 1

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Fireplace(s);Natural Gas

interior_features__c,Skylight(s);Storage Area(s)

ffd_lastmodifieddate,2024-04-19T22:48:51.000+0000

pba__latitude_pb__c,37.779873

pba__latitude_property__c,37.779873

laundry_features__c,Washer/Dryer Hookups

listed_date__c,2024-04-17

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Greg

pba__listing_agent_lastname__c,Fulford

listing_agent_mls_id__c,804156

ffd_listingagentname,Greg Fulford

listing_agent_number__c,166013627

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,STHB

listing_office_name__c,Sotheby's International Realty

listing_office_number__c,2050

pba__listingprice_pb__c,2895000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.45843

mls_id__c,424024898

parkingspaces__c,3

on_market_date__c,2024-04-19

open_house_end__c,2024-04-21T15:30:00.000+0000

open_house_start__c,2024-04-21T13:00:00.000+0000

original_price__c,2895000

overall_days_on_market__c,-81923

parking_features__c,Garage

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,893.52

pba__propertytype__c,Duplex

ListingId,a0EUd000001mqerMAA

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

size__c,3240

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Arguello

subdist__c,Lone Mountain

ffd_name,574 Arguello 576 Boulevard, San Francisco, CA, 94118

website_property_type__c,Duplex

pba__yearbuilt_pb__c,1938

pba__postalcode_pb__c,94118

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713308262

ffd_listing_title,1945 Fulton Street, San Francisco, CA, 94117

ffd_mls_id,423914848

ffd_salesforce_id,a0E8W00000dUGXSUA4

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,1

address2__c,1945 Fulton Street, San Francisco, CA, 94117

pba__address_pb__c,1945 Fulton Street, San Francisco, CA, 94117

architectural_style__c,Edwardian

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,3

year_build_text__c,1923

pba__city_pb__c,San Francisco

pba__contingentdate__c,2024-04-16

ffd_createddate,2023-10-06T16:47:09.000+0000

days_on_market__c,193

dom__c,190

ffd_description_pb,Classic flat over a large undeveloped garage. Three bedrooms, one bathroom. Solid oak hardwood and tile floors. Cover ceilings. Ideal location across from The University of San Francisco. Lone Mountain is a neighborhood and historic hill in west-central San Francisco, California: present site of the northern half of the University of San Francisco's main campus. Lone Mountain is one of San Francisco's historic hills. The Spanish name for Lone Mountain was "El Divisadero", from the Spanish "Divisadero", which means a point from which one can see far away. Certainly a building with high potential, needing TLC and an imagination. Considerable garage area represents additional development potential. Exceptionally Spacious back yard endowed with mature trees and delightfully colorful flower garden. Delivered vacant.

district__c,SF District 1

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-04-16T22:46:23.000+0000

pba__latitude_pb__c,37.7753217

pba__latitude_property__c,37.7753217

laundry_features__c,In Basement

listed_date__c,2023-10-06

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,John

pba__listing_agent_lastname__c,Kirkpatrick

listing_agent_mls_id__c,802848

ffd_listingagentname,John M Kirkpatrick

listing_agent_number__c,802848

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP12

listing_office_name__c,Compass

listing_office_number__c,28739

pba__listingprice_pb__c,995000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4488039

mls_id__c,423914848

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-10-06

original_price__c,999000

overall_days_on_market__c,-81727

parking_access__c,Tandem

parking_features__c,Garage Door Opener,Tandem Garage

parking_type__c,Other

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

pba__propertytype__c,Tenancy In Common

ListingId,a0E8W00000dUGXSUA4

road_surface_type__c,Asphalt

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,Contingent - Show

pba__totalarea_pb__c,1225

size__c,1225

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Fulton

subdist__c,Lone Mountain

ffd_name,1945 Fulton Street, San Francisco, CA, 94117

website_property_type__c,Tenancy In Common

pba__yearbuilt_pb__c,1923

pba__postalcode_pb__c,94117

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713574660

ffd_listing_title,225 Stanyan Street, San Francisco, CA, 94118

ffd_mls_id,424019417

ffd_salesforce_id,a0EUd000001aoQnMAI

num_of_fireplaces__c,0

num_of_rooms__c,6

of_units__c,0

address2__c,225 Stanyan Street, San Francisco, CA, 94118

pba__address_pb__c,225 Stanyan Street, San Francisco, CA, 94118

agent_only_remarks__c,Offer April 24th. 12pm. Trust sale fixer-upper. Title opened at Chicago Title Junipero Serra with Nancy Chan.

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,3

year_build_text__c,1940

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-03-28T19:47:21.000+0000

days_on_market__c,22

dom__c,22

ffd_description_pb,Welcome to 225 Stanyan Street in the prestigious Lone Mountain neighborhood across the University of San Francisco! With the iconic Golden Gate Park on your doorstep, this is a fixer-upper with huge expansion potential to add more square footage. It is a corner house which provides lots of light! This home includes 3 bedrooms and 1 bathroom on the top level, with potential to squeeze another bathroom upstairs. It contains a full basement and potential to add more bedrooms and another bathroom or an in-law, home office, etc. 225 Stanyan also provides a flat backyard that is easy to maintain. Bring your tools, this is not for the faint of heart!

district__c,SF District 1

entry_level__c,0

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-04-20T00:48:15.000+0000

pba__latitude_pb__c,37.7768877

pba__latitude_property__c,37.7768877

listed_date__c,2024-03-27

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Sevan

pba__listing_agent_lastname__c,Kevorkian

listing_agent_mls_id__c,802107

ffd_listingagentname,Sevan L Kevorkian

listing_agent_number__c,802107

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,HPUS

listing_office_name__c,Remax Prestigious Properties

listing_office_number__c,3224

pba__listingprice_pb__c,1549000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.455324

mls_id__c,424019417

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-03-28

open_house_end__c,2024-04-20T16:00:00.000+0000

open_house_start__c,2024-04-20T13:00:00.000+0000

original_price__c,1549000

overall_days_on_market__c,-81901

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001aoQnMAI

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

size__c,1425

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Stanyan

subdist__c,Lone Mountain

ffd_name,225 Stanyan Street, San Francisco, CA, 94118

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1940

pba__postalcode_pb__c,94118

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713491948

ffd_listing_title,34 Tamalpais Terrace, San Francisco, CA, 94118

ffd_mls_id,424012152

ffd_salesforce_id,a0EUd000001VmHaMAK

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

address2__c,34 Tamalpais Terrace, San Francisco, CA, 94118

pba__address_pb__c,34 Tamalpais Terrace, San Francisco, CA, 94118

agent_only_remarks__c,Easy to show by appointment - text Omar at (408) 470-0498. Tax records state 1825 sq', Floor Plan Visuals show 2437sq'. New owner should receive communication from SF assessor's office to report updated sq' as final project completion was recent. 200amp electrical upgrade in motion with contract (paid for) with licensed electrician - see disclosures. https://app.disclosures.io/link/34-Tamalpais-Terrace-k35l1hm3

appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Oven;Electric Water Heater;Built-In Refrigerator

architectural_style__c,Contemporary;Modern/High Tech;Mid-Century

bath_features__c,Tub w/Shower Over;Marble;Dual Flush Toilet

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,4

year_build_text__c,1937

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central,MultiZone

ffd_createddate,2024-03-21T10:47:15.000+0000

days_on_market__c,28

dom__c,28

ffd_description_pb,Fully remodeled (2024) with a timeless design, an easy-living layout, beautiful outdoor space, and a fantastic location on one of the most coveted Lone Mountain streets, make this the home you've been waiting for! This down to the studs remodel transforms the 1937 classic, equipped with new electrical, plumbing, HVAC, seismic strengthening, and more, creating a harmonious blend of contemporary design and mid-century charm within its 4 beds and 3 baths. Entertain effortlessly in formal living and dining spaces, while culinary adventures unfold in the modern chef's kitchen, featuring premium appliances. The skylit breakfast nook opens to a charming atrium, and the backyard, adorned with fresh pavers, invites seamless entertaining and playful family moments. Well-proportioned bedrooms reveal ample closets, with the main-level master suite offering a luminous bathroom. Upstairs, an additional spacious bedroom beckons, while the lower level unveils two more bedrooms, a versatile family/gym/office area, and a convenient laundry room. The garage, equipped with an EV charger, adds an extra layer of modern convenience. Nestled on one of Lone Mountain's most coveted streets, this fantastic home will not disappoint.

district__c,SF District 1

driveway_sidewalks__c,Paved Driveway,Sidewalk/Curb/Gutter

electric__c,220 Volts,220 Volts in Kitchen,220 Volts in Laundry

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard;Wood;Fenced;Masonry

pba__floortype_pb__c,Marble;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Electric;MultiZone

interior_features__c,Formal Entry;Skylight(s);Storage Area(s)

ffd_lastmodifieddate,2024-04-19T01:46:53.000+0000

pba__latitude_pb__c,37.777892

pba__latitude_property__c,37.777892

laundry_features__c,Ground Floor;Washer Included;Dryer Included;Electric;Sink

listed_date__c,2024-03-01

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Omar

pba__listing_agent_lastname__c,Khayat

listing_agent_mls_id__c,815649

ffd_listingagentname,Omar Khayat

listing_agent_number__c,1073759

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,OLIVE

listing_office_name__c,Olive Realty

listing_office_number__c,28611

pba__listingprice_pb__c,2795000

pba__listingtype__c,Sale

pba__listing_website__c,http://youtu.be/0leEVbMA4Wc

pba__longitude_pb__c,-122.4485181

lower_level__c,Bedroom(s),Family Room,Full Bath(s),Garage

mls_id__c,424012152

main_level__c,Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room

master_bathroom_features__c,Shower Stall(s);Marble;Skylight/Solar Tube;Dual Flush Toilet

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-03-21

open_house_end__c,2024-04-20T16:00:00.000+0000

open_house_start__c,2024-04-20T14:00:00.000+0000

original_price__c,2795000

overall_days_on_market__c,-81894

parking_access__c,Tandem

parking_features__c,Attached,EV Charging,Garage Door Opener,Garage Facing Front

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001VmHaMAK

roof__c,Bitumen;Shingle;Spanish Tile

room_type__c,Storage;Laundry;Atrium;Living Room;Guest Quarters;Dining Room;Family Room;Media Room;Primary Bathroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Carbon Mon Detector;Double Strapped Water Heater

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

size__c,2437

pba__state_pb__c,CA

stories__c,2

pba__street_pb__c,Tamalpais

subdist__c,Lone Mountain

ffd_name,34 Tamalpais Terrace, San Francisco, CA, 94118

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full;Window Screens

pba__yearbuilt_pb__c,1937

pba__postalcode_pb__c,94118

ffd_media,Array

ffd_media_tags,Array

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