_yoast_indexnow_last_ping,1742556041
ffd_listing_title,687 28th Street, San Francisco, CA, 94131
ffd_mls_id,425017242
ffd_salesforce_id,a0EUd000004ZA8gMAG
num_of_fireplaces__c,1
num_of_rooms__c,8
of_units__c,0
pba__address_pb__c,687 28th Street, San Francisco, CA, 94131
address2__c,687 28th Street, San Francisco, CA, 94131
agent_only_remarks__c,The downstairs family room can be used as a fourth bedroom or office. The roof level solarium can be used as an office or guest room. Ev Charger in the spacious parking garage
appliances__c,Dishwasher;Hood Over Range;Free Standing Gas Oven;ENERGY STAR Qualified Appliances;Free Standing Refrigerator;Electric Water Heater
architectural_style__c,Contemporary;Modern/High Tech
bath_features__c,Shower Stall(s);Skylight/Solar Tube
pba__fullbathrooms_pb__c,3
pba__bedrooms_pb__c,3
year_build_text__c,1953
pba__city_pb__c,San Francisco
pba__contingentdate__c,1800-01-01
ffd_createddate,2025-03-21T10:48:34.000+0000
days_on_market__c,0
dom__c,0
ffd_description_pb,Contemporary Noe Valley residence redesigned and remodeled in 2014 by acclaimed architect John Lum, featuring strategic interplay of windows, light, and texture, with spectacular city and bay views. 3 bedrooms and 3 baths. The main level presents an open-concept living space with city views and a sleek gas fireplace, transitioning to a skylit dining area and chef's kitchen with premium appliances. A guest suite completes this floor. Upstairs, discover the primary bedroom with view of mature foliage creating a natural sanctuary, and served by a luxurious en-suite featuring dual vanities, a free standing soaking tub, and waterfall shower. The show stopping roof-level solarium incorporates innovative suspended planters with integrated irrigation, opening to a stunning roof deck with 180 degree views spanning downtown SF, the Bay, and the East Bay hills. The garden level continues the indoor-outdoor lifestyle with a multi-functional room and third en-suite bedroom, both accessing a private manicured garden through expansive sliding glass doors. 2 car tandem parking and extensive storage space in the garage. This residence masterfully balances architectural innovation with functional luxury for discerning urban dwellers seeking both sophisticated design and tranquil living.
district__c,SF District 5
driveway_sidewalks__c,Paved Sidewalk
electric__c,220 Volts
entry_level__c,0
external_listing__c,1
fencing__c,Back Yard;Fenced;Front Yard;Full
fireplace_features__c,Living Room;Gas Starter
pba__floortype_pb__c,Concrete;Wood
pba__hoafees__c,0
hoa__c,No
pba__halfbathrooms_pb__c,0
has_3d_tour__c,1
pba__heatingtype_pb__c,Central
interior_features__c,Skylight(s)
ffd_lastmodifieddate,2025-03-21T10:48:34.000+0000
pba__latitude_pb__c,37.7444838
pba__latitude_property__c,37.7444838
laundry_features__c,Washer/Dryer Stacked Included
listed_date__c,2025-01-26
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Afi
pba__listing_agent_lastname__c,Valizadeh
listing_agent_mls_id__c,812050
ffd_listingagentname,Afi Valizadeh
listing_agent_number__c,1054599
listing_co_agent_number__c,0
listing_co_office_number__c,0
listing_office_mls_id__c,SRNO06
listing_office_name__c,Christie's Int'l R.E. San Francisco
listing_office_number__c,29142
pba__listingprice_pb__c,3500000
pba__listingtype__c,Sale
pba__listing_website__c,https://my.matterport.com/show/?m=vwDufxqi8Zo
pba__longitude_pb__c,-122.4375464
lower_level__c,Bedroom(s),Family Room,Full Bath(s),Garage,Primary Bedroom,Retreat,Street Entrance
mls_id__c,425017242
main_level__c,Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance;Primary Bedroom
master_bathroom_features__c,Shower Stall(s);Double Sinks;Tile;Soaking Tub;Closet;Window;Skylight/Solar Tube
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,2
on_market_date__c,2025-03-21
open_house_end__c,2025-03-22T16:00:00.000+0000
open_house_start__c,2025-03-22T13:30:00.000+0000
original_price__c,3500000
overall_days_on_market__c,-82259
parking_access__c,Tandem
parking_features__c,Attached,Enclosed,EV Charging,Garage Door Opener,Garage Facing Front,Interior Access,Private,Tandem Garage
parking_type__c,On Site (Single Family Only)
patio_and_porch_features__c,Roof Deck;Uncovered Deck
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,1474.3
pba__propertytype__c,Single Family Residence
ListingId,a0EUd000004ZA8gMAG
room_type__c,Storage;Office;Sun Room;Kitchen;Living Room;Solarium;Dining Room;Family Room;Primary Bathroom;Primary Bedroom 2+
sale_date__c,1800-01-01
sale_price__c,0
security_features__c,Smoke Detector;Carbon Mon Detector;Other
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,2374
size__c,2374
pba__state_pb__c,CA
stories__c,0
pba__street_pb__c,28th
subdist__c,Noe Valley
ffd_name,687 28th Street, San Francisco, CA, 94131
view__c,City;City Lights;Bay;Downtown;San Francisco;Hills
website_property_type__c,Single Family Home
pba__yearbuilt_pb__c,1953
pba__postalcode_pb__c,94131
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530957098-1.jpg
New
3D Tour
Open 03/22 01:30pm till 04:00pm