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

_yoast_indexnow_last_ping,1713610859

ffd_listing_title,714 Hayes Street, San Francisco, CA, 94102

ffd_mls_id,424025144

ffd_salesforce_id,a0EUd000001nKZiMAM

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,5

address2__c,714 Hayes Street, San Francisco, CA, 94102

pba__address_pb__c,714 Hayes Street, San Francisco, CA, 94102

agent_only_remarks__c,Leased parking is available and secured on the same block! For more information and showing requests, please contact Jeff Stephenson at (415)577-2580 / [email protected]

appliances__c,Dishwasher;Disposal;Hood Over Range;Free Standing Gas Range;Built-In Refrigerator

bath_features__c,Tub w/Shower Over;Shower Stall(s);Tub;Tile;Double Sinks;Radiant Heat;Quartz;Window;Multiple Shower Heads

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,4

year_build_text__c,1900

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Mark Brown

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-20T00:49:11.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Top floor and totally remodeled! Massive four-bed, three-bath home in the heart of Hayes Valley. Expansive full-floor flat in a trophy building with tall ceilings, great light, and views of downtown! The modern, open plan layout includes a chef's kitchen with Euro-style cabinets, gleaming quartz counters, and Bertazzoni counter-depth, cabinet-finish appliances. Bathrooms offer walk-in showers and a deep soaking tub, surrounded by designer tile and spa-like fixtures. Spacious, well-lit bedrooms include a large primary suite with generous closet space and a luxurious bath with dual sink vanity. Additional amenities include in-unit laundry, in-floor radiant heat beneath wide-plank white oak, and recessed LED lighting with Lutron smart controls. This luxurious residence also enjoys access to a unique penthouse common room with wet bar and deck. Located at roof level, this space is perfect for those special celebrations with amazing views of the San Francisco skyline. Only a couple of short blocks to Patricia's Green and the wonderful entertainment and shopping of Hayes Valley. Awarded a Walk Score of 98, this is your perfect City home!

district__c,SF District 6

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Insurance on Structure,Management,Trash

pba__hoafees__c,609

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,0

has_monthly_parking_fees__c,1

pba__heatingtype_pb__c,Radiant Floor

ffd_lastmodifieddate,2024-04-20T10:46:59.000+0000

pba__latitude_pb__c,37.776439

pba__latitude_property__c,37.776439

laundry_features__c,Inside Room;Hookups Only

listed_date__c,2024-04-17

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

pba__listingtype__c,Sale

pba__listing_website__c,https://hayes-valley-homes.com

pba__longitude_pb__c,-122.428243

mls_id__c,424025144

master_bathroom_features__c,Quartz;Double Sinks;Tile;Window;Radiant Heat;Multiple Shower Heads

monthly_parking_fees__c,300

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-19

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

overall_days_on_market__c,-81923

parking_access__c,Independent

parking_features__c,See Remarks

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

pba__propertytype__c,Tenancy In Common

ListingId,a0EUd000001nKZiMAM

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Security Gate;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,2063

size__c,2063

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Hayes

subdist__c,Hayes Valley

ffd_name,714 Hayes Street, San Francisco, CA, 94102

view__c,City;City Lights;San Francisco

website_property_type__c,Tenancy In Common

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,1900

pba__postalcode_pb__c,94102

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713614091

ffd_listing_title,28 Lloyd Street, San Francisco, CA, 94117

ffd_mls_id,424024849

ffd_salesforce_id,a0EUd000001nFGgMAM

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,4

address2__c,28 Lloyd Street, San Francisco, CA, 94117

pba__address_pb__c,28 Lloyd Street, San Francisco, CA, 94117

agent_only_remarks__c,Escrow is opened with Gerrie Brindley at Chicago Title. Full disclosure package will be available after first weekend of open houses.

appliances__c,Dishwasher;Free Standing Gas Oven;Free Standing Refrigerator;Gas Plumbed

architectural_style__c,Edwardian

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1906

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-19T22:47:33.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Welcome to this super sweet condo in a gracious four unit Edwardian building. Tucked away on a quiet one block street and just steps from Duboce Park, you can not beat 28 Lloyd's location! Period details throughout include wainscoting, built-ins, soaring ceilings, picture rails and a clawfoot bathtub. Bright and inviting living room overlooks a lush garden, perfect for afternoon musings. Recently refreshed kitchen walks out to a laundry porch with side by side washer/dryer. Each unit has a huge independent storage space that gives you lots of extra use options. Walk to EVERYTHING including the N-Judah, shops on Haight Street, cafes, restaurants, the Castro, and more. The Duboce Triangle neighborhood is a thriving San Francisco community and this home is a perfect part of it!

district__c,SF District 6

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,422

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Floor Furnace;Gas;Fireplace(s)

ffd_lastmodifieddate,2024-04-20T11:46:50.000+0000

pba__latitude_pb__c,37.769995

pba__latitude_property__c,37.769995

laundry_features__c,Dryer Included;Gas Hook-Up

listed_date__c,2024-02-16

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Gabriella

pba__listing_agent_lastname__c,Fracchia

listing_agent_mls_id__c,807337

ffd_listingagentname,Gabriella Fracchia

listing_agent_number__c,1015996

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP90

listing_office_name__c,Compass

listing_office_number__c,29048

pba__listingprice_pb__c,895000

pba__listingtype__c,Sale

pba__listing_website__c,https://www.28lloyd.com

pba__longitude_pb__c,-122.435655

mls_id__c,424024849

master_property__c,a0OUd000006EUAyMAO

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2024-04-19

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

overall_days_on_market__c,-81923

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001nFGgMAM

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

size__c,860

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Lloyd

subdist__c,Hayes Valley

ffd_name,28 Lloyd Street, San Francisco, CA, 94117

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1906

pba__postalcode_pb__c,94117

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1712890564

ffd_listing_title,8 Buchanan Street #613, San Francisco, CA, 94102

ffd_mls_id,424022563

ffd_salesforce_id,a0EUd000001iMAoMAM

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,115

address2__c,8 Buchanan Street #613, San Francisco, CA, 94102

pba__address_pb__c,8 Buchanan Street #613, San Francisco, CA, 94102

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,2014

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2024-04-11T20:46:59.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,The quintessential Hayes Valley lifestyle everyone has been talking about! A stunning two bedroom and two bath, in a prime location across from Whole Foods, & close to Mission Dolores, Duboce Park, Lower Haight. This home features a balcony overlooking an interior courtyard with lush plantings & greenery creating a serene interior view, recessed lighting, in-unit washer/dryer, large modern bathrooms, walk in closet & 1 deeded parking space. Enjoy breathtaking panoramic city views from the furnished rooftop deck. Linea provides concierge services, a grand attended lobby finished with porcelain tile floors, natural white-oak wood panels & Italian marble. Incredible central location with proximity to tech shuttles, Bart, and MUNI. Tenant is month to month paying $4,500

district__c,SF District 6

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

hoa_fee_includes__c,Door Person,Gas,Homeowners Insurance,Maintenance Grounds,Sewer,Trash,Water

pba__hoafees__c,737

pba__hoafrequency_pb__c,Monthly

hoa_name__c,LINEA Owners Association

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Radiant

ffd_lastmodifieddate,2024-04-12T02:46:41.000+0000

pba__latitude_pb__c,37.770074

pba__latitude_property__c,37.770074

laundry_features__c,Washer Included;Dryer Included

listed_date__c,2024-03-01

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Michael

pba__listing_agent_lastname__c,Riordan

listing_agent_mls_id__c,352679

ffd_listingagentname,Mike T Riordan

listing_agent_number__c,352679

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.426208

mls_id__c,424022563

master_property__c,a0O1I000001VhmeUAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-11

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

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

original_price__c,995000

overall_days_on_market__c,-81915

parking_access__c,Tandem

parking_features__c,Mechanical Lift

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001iMAoMAM

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

size__c,963

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Buchanan

subdist__c,Hayes Valley

ffd_name,8 Buchanan Street #613, 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/530759393-1.jpg

_yoast_indexnow_last_ping,1712699700

ffd_listing_title,329 Waller Street #2, San Francisco, CA, 94117

ffd_mls_id,424004863

ffd_salesforce_id,a0EUd000000wR35MAE

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,4

address2__c,329 Waller Street #2, San Francisco, CA, 94117

pba__address_pb__c,329 Waller Street #2, San Francisco, CA, 94117

agent_only_remarks__c,Please contact listing agent, Edward Ong, for showing instructions or with any questions: [email protected]; (408) 571-9626 -- text preferred. Showings by appointment but can be flexible with 1-2 hours notice as the sellers still go in and out of the property. ** When showing, please note the building door and front door automatically lock when closed. Do NOT double lock the unit's front door ** Disclosures available here: https://app.disclosures.io/link/329-Waller-Street-2-rzr0vite

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1900

pba__city_pb__c,San Francisco

pba__contingentdate__c,2024-02-25

ffd_createddate,2024-01-25T22:46:31.000+0000

days_on_market__c,75

dom__c,60

ffd_description_pb,Enjoy quintessential city living in this centrally-located condo. The two-level home features impressive high ceilings and abundant natural light. The main level has an open floor plan with a spacious dining and living room space, home office nook, convenient powder room, and a fully-equipped kitchen with plenty of counter space and a breakfast bar area. The two bedrooms downstairs each have an en-suite bath and enjoy access to the private, deeded patio through the primary bedroom. Additional highlights include the hardwood floors and recessed lighting throughout the home and in-unit washer/dryer. Fantastic location just steps from Duboce Park, public transit, restaurants, cafes, shopping, and so much more.

district__c,SF District 6

entry_level__c,0

external_listing__c,1

pba__hoafees__c,540

pba__hoafrequency_pb__c,Monthly

hoa_name__c,329 Waller Street HOA

hoa__c,Yes

pba__halfbathrooms_pb__c,1

ffd_lastmodifieddate,2024-04-09T21:46:39.000+0000

pba__latitude_pb__c,37.771131

pba__latitude_property__c,37.771131

listed_date__c,2024-01-25

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Edward

pba__listing_agent_lastname__c,Ong

listing_agent_mls_id__c,813205

ffd_listingagentname,Edward Ong

listing_agent_number__c,1060094

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CORPEN

listing_office_name__c,Corpen Real Estate Group

listing_office_number__c,27177

pba__listingprice_pb__c,1100000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.429103

lower_level__c,Bedroom(s),Full Bath(s)

mls_id__c,424004863

main_level__c,Partial Bath(s);Kitchen;Living Room;Dining Room

master_property__c,a0O8W00000KUKb4UAH

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2024-01-25

original_price__c,1100000

overall_days_on_market__c,-81838

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

pba__propertytype__c,Condominium

ListingId,a0EUd000000wR35MAE

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

size__c,1074

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Waller

subdist__c,Hayes Valley

ffd_name,329 Waller Street #2, San Francisco, CA, 94117

website_property_type__c,Condominium

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