440 Waller Street, San Francisco, CA, 94117 - Property Description

_yoast_indexnow_last_ping,1729086731

ffd_listing_title,390 Page Street, San Francisco, CA, 94102

ffd_mls_id,424038699

ffd_salesforce_id,a0EUd000002XH0vMAG

num_of_fireplaces__c,9

num_of_rooms__c,13

of_units__c,0

address2__c,390 Page Street, San Francisco, CA, 94102

pba__address_pb__c,390 Page Street, San Francisco, CA, 94102

agent_only_remarks__c,Probate sale. Offers subject to Notice of Proposed Action and may be subject to court confirmation. 3-R report indicates duplex. Tax records indicate 13 units. In person there is a large vacant house w/ 2 additional rented units on the ground level. Go directly to show main house but call first so we can describe how to skip the tenant occupied units downstairs. Main house is vacant. Lower unit 1 rent is $2,650/mo. Lower unit 2 rent is $2,081/mo.

appliances__c,Free Standing Gas Oven;Free Standing Refrigerator

architectural_style__c,Victorian

pba__fullbathrooms_pb__c,4

pba__bedrooms_pb__c,6

year_build_text__c,1875

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Michael B Johnston

pba__contingentdate__c,2024-10-14

cooling__c,None

ffd_createddate,2024-07-10T10:49:32.000+0000

days_on_market__c,98

dom__c,93

ffd_description_pb,Welcome to the Gatewood-Keane Mansion, where history meets unparalleled elegance. Located at 390 Page St, this ca. 1875 Italianate Victorian residence was meticulously restored between 1982 & 1994 by the late artist William Gatewood, his family & friends. Nestled in the heart of the city on a corner lot, this absolutely spectacular home is a testament to architectural grandeur & timeless beauty. Step into a world of refined luxury as you enter through the grand facade & are greeted with walls & 13' ceilings adorned with intricate trompe l'oeil detailing. From the moment you cross the threshold, you'll be captivated by the exquisite craftsmanship & attention to detail that graces every corner of this magnificent historic home. Marvel at the stained glass windows filtering soft, colorful light into opulent interiors, where Corinthian columns stand tall amidst soaring ceilings adorned with elaborate chandeliers & huge original medallions. The oversized parlors are lavishly decorated in gold leaf & feature ornate hand-painted detailing. Each room boasts grand proportions, offering an unparalleled sense of space & sophistication. This architectural masterpiece w 9 fireplaces awaits your personal touch, with a large main residence & two downstairs units providing instant rental income.

district__c,SF District 6

driveway_sidewalks__c,Sidewalk/Curb/Gutter

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room;Dining Room;Primary Bedroom

pba__floortype_pb__c,Carpet;Laminate;Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Central;Gas;Natural Gas

interior_features__c,Formal Entry;Storage Area(s);Cathedral Ceiling

ffd_lastmodifieddate,2024-10-16T13:46:48.000+0000

pba__latitude_pb__c,37.7737353

pba__latitude_property__c,37.7737353

laundry_features__c,Upper Floor;Washer Included;Dryer Included

listed_date__c,2024-06-01

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Robert

pba__listing_agent_lastname__c,Collett

listing_agent_mls_id__c,811230

ffd_listingagentname,Robert B Collett

listing_agent_number__c,1050607

listing_co_agent_mls_id__c,810153

listing_co_agent_number__c,1044944

listing_co_office_mls_id__c,BHDP8

listing_co_office_name__c,Berkshire Hathaway Drysdale Properties

listing_co_office_number__c,27643

listing_office_mls_id__c,BHDP8

listing_office_name__c,Berkshire Hathaway Drysdale Properties

listing_office_number__c,27643

pba__listingprice_pb__c,3250000

pba__listingtype__c,Sale

pba__listing_website__c,https://listings.fluttershotmedia.com/x1489646

pba__longitude_pb__c,-122.4272373

lower_level__c,Kitchen

mls_id__c,424038699

main_level__c,Bedroom(s)

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2024-07-10

original_price__c,3995000

overall_days_on_market__c,-82005

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000002XH0vMAG

roof__c,Shingle

room_type__c,Bonus Room;Laundry;Kitchen;In Law Apartment;Living Room;Dining Room;Attic;Great Room;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,Contingent - Show

pba__totalarea_pb__c,4522

size__c,4522

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Page

subdist__c,Hayes Valley

ffd_name,390 Page Street, San Francisco, CA, 94102

view__c,City;City Lights;Bay;Downtown;San Francisco;Golden Gate Bridge

website_property_type__c,Single Family Home

window_features__c,Bay Window(s)

pba__yearbuilt_pb__c,1875

pba__postalcode_pb__c,94102

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1728989638

ffd_listing_title,442 Scott 444 Street, San Francisco, CA, 94117

ffd_mls_id,424071202

ffd_salesforce_id,a0EUd000003LMztMAG

num_of_rooms__c,0

of_units__c,4

address2__c,442 Scott 444 Street, San Francisco, CA, 94117

pba__address_pb__c,442 Scott 444 Street, San Francisco, CA, 94117

agent_only_remarks__c,Call/text Omar 415.937.2224 for questions or showing requests

pba__fullbathrooms_pb__c,4

pba__bedrooms_pb__c,7

year_build_text__c,1900

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-10-14T10:48:47.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Excellent investment opportunity with strong current rents at 442-444 Scott Street in San Francisco. This turnkey property offers a chance to invest in a prime SF location with high rental demand in lively Hayes Valley. The asset's flexibility is notable, featuring a spacious three-bedroom, two-bath unit, plus 3 additional units (one 2/1 and two 1/1's). Includes three-car independent parking and rentable storage spaces. The building has steel framing in the garage and access to a large, private backyard. Its ideal location near Golden Gate Park, trendy shops, cafes, and restaurants makes it perfect for investors targeting the city's thriving rental market.

district__c,SF District 6

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-10-15T10:49:25.000+0000

pba__latitude_pb__c,37.7717185

pba__latitude_property__c,37.7717185

listed_date__c,2024-10-04

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Omar Georg

pba__listing_agent_lastname__c,Maissen

listing_agent_mls_id__c,811531

ffd_listingagentname,Omar Georg Maissen

listing_agent_number__c,1052071

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP

listing_office_name__c,Compass

listing_office_number__c,26293

pba__listingprice_pb__c,2600000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4438929

mls_id__c,424071202

parkingspaces__c,0

on_market_date__c,2024-10-14

open_house_end__c,2024-10-15T13:00:00.000+0000

open_house_start__c,2024-10-15T11:00:00.000+0000

original_price__c,2600000

overall_days_on_market__c,-82101

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,611.48

pba__propertytype__c,Quadruplex

ListingId,a0EUd000003LMztMAG

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

size__c,4252

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Scott

subdist__c,Hayes Valley

ffd_name,442 Scott 444 Street, San Francisco, CA, 94117

view__c,City Lights;Twin Peaks

website_property_type__c,Quadruplex

pba__yearbuilt_pb__c,1900

pba__postalcode_pb__c,94117

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1729076115

ffd_listing_title,521 Waller 525 Street, San Francisco, CA, 94117

ffd_mls_id,424072818

ffd_salesforce_id,a0EUd000003LKV3MAO

num_of_rooms__c,14

of_units__c,3

address2__c,521 Waller 525 Street, San Francisco, CA, 94117

pba__address_pb__c,521 Waller 525 Street, San Francisco, CA, 94117

architectural_style__c,Victorian

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,10

year_build_text__c,1900

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Brooke E Mattice

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-10-13T21:50:13.000+0000

days_on_market__c,3

dom__c,3

ffd_description_pb,Introducing 521-525 Waller Street a prime 3 unit victorian in the Lower Haight. This property is comprised of One (1) 2 Bedroom 1 Bathroom unit & Two (2) 4 Bedroom 1 Bathroom units. All units have been updated, and feature period detail and hardwood floors throughout. There is a backyard, large storage room in the basement, Coin-op Laundry, and a garage with 2 car parking. Located on beautiful tree lined street near Duboce Park, MUNI, all the shopping & dining on Haight, Safeway, Whole Foods, BitRite & More! This is a fantastic opportunity for an investor to purchase a stabilized building in a well sought after location.

district__c,SF District 6

external_listing__c,1

pba__floortype_pb__c,Wood;Varies by Unit

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Wall Furnace;Gas

ffd_lastmodifieddate,2024-10-16T10:49:40.000+0000

pba__latitude_pb__c,37.7717185

pba__latitude_property__c,37.7717185

laundry_features__c,Coin Operated

listed_date__c,2024-10-10

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Cristobal

pba__listing_agent_lastname__c,Lamas

listing_agent_mls_id__c,813454

ffd_listingagentname,Cris Lamas

listing_agent_number__c,1061408

listing_co_agent_mls_id__c,819300

listing_co_agent_number__c,1077969

listing_co_office_mls_id__c,UC-SF

listing_co_office_name__c,Urban Capital SF

listing_co_office_number__c,28610

listing_office_mls_id__c,UC-SF

listing_office_name__c,Urban Capital SF

listing_office_number__c,28610

pba__listingprice_pb__c,2295000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4438929

mls_id__c,424072818

parkingspaces__c,2

on_market_date__c,2024-10-13

open_house_end__c,2024-10-17T11:30:00.000+0000

open_house_start__c,2024-10-17T10:00:00.000+0000

original_price__c,2295000

overall_days_on_market__c,-82100

parking_features__c,Garage

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,572.32

pba__propertytype__c,Triplex

ListingId,a0EUd000003LKV3MAO

roof__c,Shingle

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

size__c,4010

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Waller

subdist__c,Hayes Valley

ffd_name,521 Waller 525 Street, San Francisco, CA, 94117

website_property_type__c,Triplex

pba__yearbuilt_pb__c,1900

pba__postalcode_pb__c,94117

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1729162523

ffd_listing_title,300 Ivy Street #314, San Francisco, CA, 94102

ffd_mls_id,424066052

ffd_salesforce_id,a0EUd000003INAwMAO

num_of_fireplaces__c,0

num_of_rooms__c,4

of_units__c,63

address2__c,300 Ivy Street #314, San Francisco, CA, 94102

pba__address_pb__c,300 Ivy Street #314, San Francisco, CA, 94102

agent_only_remarks__c,Please call/text Sally at 415-812-7032 or Brian 415-385-9410 for showing requests & questions. Please no ShowingTime. Please execute disclosure package with all offers. Please provide proof of funds and relevant loan information if financing is required with offers. https://www.youtube.com/embed/TtK_TC_wEkk 300ivy314.sageteam.com

appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;ENERGY STAR Qualified Appliances;Built-In Refrigerator;Plumbed For Ice Maker;Gas Plumbed

architectural_style__c,Contemporary

bath_features__c,Shower Stall(s);Tub

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,2014

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Sally A Thompson

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2024-10-07T19:47:40.000+0000

days_on_market__c,10

dom__c,10

ffd_description_pb,Stunning 2 bed, 2 bath condominium, nestled in vibrant Hayes Valley- also known as AI Valley! Built in 2014, this contemporary residence offers an unparalleled blend of sophisticated design and modern comforts. The building boasts a lush garden entrance and an impressive, spacious lobby with soaring ceilings. Step into a sun-drenched living space with floor-to-ceiling windows that fill the home with natural light, complemented by wide-plank oak flooring and central air conditioning for year-round comfort. The modern chef's kitchen is outfitted with premium appliances and opens to an inviting dining area. The living room features custom Italian cabinetry and display units, adding both function and style. The primary suite is your private retreat, complete with a large walk-in closet with custom organizers and a spa-like ensuite bathroom with a deep soaking tub and rain shower head. The second bedroom, thoughtfully designed with custom built-in shelving, desk, and a Murphy bed, offers versatility as a guest room, office, or both. Building amenities in this LEED-certified eco-friendly building include deeded parking, storage, and a beautifully landscaped rooftop deck with BBQ facilities and lounge seating, perfect for entertaining.

district__c,SF District 6

driveway_sidewalks__c,Paved Driveway

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Carpet;Tile;Wood

hoa_fee_includes__c,Door Person,Homeowners Insurance,Maintenance Exterior,Maintenance Grounds,Trash,Water

pba__hoafees__c,718

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-10-17T10:48:47.000+0000

pba__latitude_pb__c,37.7775203

pba__latitude_property__c,37.7775203

laundry_features__c,Laundry Closet

listed_date__c,2024-09-17

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Brian

pba__listing_agent_lastname__c,Garrett

listing_agent_mls_id__c,805155

ffd_listingagentname,Brian W Garrett

listing_agent_number__c,166014957

listing_co_agent_mls_id__c,400394

listing_co_agent_number__c,400394

listing_co_office_mls_id__c,SAGERE

listing_co_office_name__c,Sage Real Estate

listing_co_office_number__c,28708

listing_office_mls_id__c,SAGERE

listing_office_name__c,Sage Real Estate

listing_office_number__c,28708

pba__listingprice_pb__c,1499000

pba__listingtype__c,Sale

pba__listing_website__c,https://www.youtube.com/embed/TtK_TC_wEkk

pba__longitude_pb__c,-122.423566

mls_id__c,424066052

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

master_bathroom_features__c,Tub w/Shower Over;Double Sinks;Soaking Tub;Low-Flow Shower(s)

master_property__c,a0O1I000001VhrnUAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-10-07

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

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

original_price__c,1499000

overall_days_on_market__c,-82094

parking_access__c,Side by Side

parking_features__c,Garage Door Opener,Interior Access,Side-by-Side

parking_type__c,On Site - Assigned (Condo 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,1545.36

pba__propertytype__c,Condominium

ListingId,a0EUd000003INAwMAO

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Carbon Mon Detector

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

size__c,970

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Ivy

subdist__c,Hayes Valley

ffd_name,300 Ivy Street #314, San Francisco, CA, 94102

website_property_type__c,Condominium

pba__yearbuilt_pb__c,2014

pba__postalcode_pb__c,94102

ffd_media,Array

ffd_media_tags,Array

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