539 Waller 541 Street, San Francisco, CA, 94117 - Property Description

_yoast_indexnow_last_ping,1713535082

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

ffd_mls_id,424025144

ffd_salesforce_id,a0EUd000001mYDTMA2

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-19T10:49:46.000+0000

days_on_market__c,0

dom__c,0

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-19T13:47:17.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,a0EUd000001mYDTMA2

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

ffd_listing_title,530 Page Street, San Francisco, CA, 94117

ffd_mls_id,424024137

ffd_salesforce_id,a0EUd000001jnLlMAI

num_of_rooms__c,30

of_units__c,6

address2__c,530 Page Street, San Francisco, CA, 94117

pba__address_pb__c,530 Page Street, San Francisco, CA, 94117

agent_only_remarks__c,Please call or email Rachel Abraham-Pollard at 415.828.3964 or [email protected] to schedule a showing or for any questions.

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,0

year_build_text__c,1907

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Dan M McGivern

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-15T16:48:18.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,530 Page Street presents an exceptional six-unit investment opportunity located along a quiet tree-lined block in Lower Haight, near Hayes Valley. Each of the six 3-bedroom units offer original period details including box beam ceilings, decorative crown molding, turret windows and most have hardwood floors throughout. A 1-car garage, two storage spaces and a shared laundry area occupy the ground floor. All units have their own water heaters and are separately metered for gas and electric. The soft-story retrofit was completed in 2016. Residents enjoy the location, a short walk from Alamo Square and Duboce Park, and the Lower Haight and Hayes Valley shopping districts. There is also easy access to major highways and ample public transportation. Don't miss this exceptional opportunity!

district__c,SF District 6

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-04-15T22:48:46.000+0000

pba__latitude_pb__c,37.773416

pba__latitude_property__c,37.773416

listed_date__c,2024-04-15

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Adam

pba__listing_agent_lastname__c,Filly

listing_agent_mls_id__c,803097

ffd_listingagentname,Adam D Filly

listing_agent_number__c,803097

listing_co_agent_mls_id__c,812343

listing_co_agent_number__c,1056241

listing_co_office_mls_id__c,COMP13

listing_co_office_name__c,Compass Commercial

listing_co_office_number__c,27689

listing_office_mls_id__c,COMP13

listing_office_name__c,Compass Commercial

listing_office_number__c,27689

pba__listingprice_pb__c,2600000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.429514

mls_id__c,424024137

parkingspaces__c,1

on_market_date__c,2024-04-15

open_house_end__c,2024-04-16T13:00:00.000+0000

open_house_start__c,2024-04-16T11:00:00.000+0000

original_price__c,2600000

overall_days_on_market__c,-81919

parking_features__c,Garage

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,368.79

pba__propertytype__c,5 or More Unit

ListingId,a0EUd000001jnLlMAI

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

size__c,7050

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Page

subdist__c,Hayes Valley

ffd_name,530 Page Street, San Francisco, CA, 94117

website_property_type__c,5 or More Unit

pba__yearbuilt_pb__c,1907

pba__postalcode_pb__c,94117

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530761067-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