255 Waller Street, San Francisco, CA, 94102 - Property Description

_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

_yoast_indexnow_last_ping,1713401990

ffd_listing_title,780 Haight Street, San Francisco, CA, 94117

ffd_mls_id,424019619

ffd_salesforce_id,a0EUd000001elR3MAI

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,2

address2__c,780 Haight Street, San Francisco, CA, 94117

pba__address_pb__c,780 Haight Street, San Francisco, CA, 94117

agent_only_remarks__c,Generous price adjustment from previous purchase price. Seller open to paying 2 years of parking for TWO PRIVATE, side-by-side garage spots. Shows beautifully!

appliances__c,Dishwasher;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Oven;Free Standing Gas Range

pba__fullbathrooms_pb__c,2

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-04-05T00:48:17.000+0000

days_on_market__c,13

dom__c,13

ffd_description_pb,Luxury living on Haight: completely remodeled top floor condo with a lush deeded yard for seamless indoor-outdoor living. Chef's dream kitchen boasts imported Italian porcelain stone, custom cabinetry and Miele appliances. Three generous bedrooms - each with custom closets - plus office den and marble finishes in each bathroom. The large skylight, 12ft.+ soaring ceilings, open floorplan and wide plank floors create an atmosphere of sophistication. Additional highlights include indoor and outdoor fountains, private deeded back yard, custom wet bar, gas firepit, in-unit laundry facilities. Ideally located just a few blocks from Alamo Square, Duboce Park, and an array of boutique shops, artisanal coffee shops, and craft cocktail bars. Seller open to pay for 2 years of parking for TWO PRIVATE, side-by-side garage spots. Come see this Haight street stunner!

district__c,SF District 6

entry_level__c,0

exterior_features__c,Fire Pit

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,Yes

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

pba__heatingtype_pb__c,Central

interior_features__c,Skylight(s);Wet Bar

ffd_lastmodifieddate,2024-04-18T00:47:06.000+0000

pba__latitude_pb__c,37.771779

pba__latitude_property__c,37.771779

laundry_features__c,Washer Included;Dryer Included;Cabinets

listed_date__c,2024-03-28

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Tracy

pba__listing_agent_lastname__c,Hsieh

listing_agent_mls_id__c,813002

ffd_listingagentname,Tracy Hsieh

listing_agent_number__c,1058962

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

pba__listingtype__c,Sale

pba__listing_website__c,https://my.matterport.com/show/?m=RGPTnYgF8H2

pba__longitude_pb__c,-122.435045

mls_id__c,424019619

master_property__c,a0O8W00000Db9tHUAR

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2024-04-04

open_house_end__c,2024-04-18T19:00:00.000+0000

open_house_start__c,2024-04-18T17:00:00.000+0000

original_price__c,1998000

overall_days_on_market__c,-81908

parking_access__c,Side by Side

parking_features__c,Covered,Garage Door Opener

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001elR3MAI

room_type__c,Storage;Laundry;Kitchen;Living Room;Dining Room;Family 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,Active

pba__totalarea_pb__c,2020

size__c,2020

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Haight

subdist__c,Hayes Valley

ffd_name,780 Haight Street, San Francisco, CA, 94117

website_property_type__c,Condominium

pba__yearbuilt_pb__c,0

pba__postalcode_pb__c,94117

ffd_media,Array

ffd_media_tags,Array

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