51 Los Palmos Dr. SF 94127-2309 - Property Description

_yoast_indexnow_last_ping,1747912862

ffd_listing_title,3124 Clay Street, San Francisco, CA, 94115

ffd_mls_id,425042004

ffd_salesforce_id,a0EUd0000055MppMAE

num_of_fireplaces__c,1

num_of_rooms__c,6

of_units__c,2

pba__address_pb__c,3124 Clay Street, San Francisco, CA, 94115

address2__c,3124 Clay Street, San Francisco, CA, 94115

agent_only_remarks__c,Incredible top-floor unit, do not miss! Call with any questions 415.290.6058.

appliances__c,Dishwasher;Microwave;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator

architectural_style__c,Victorian

bath_features__c,Tub;Split Bath

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1900

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2025-05-21T22:46:39.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Welcome to 3124 Clay Streeta sun-drenched, top-floor 3BD/2BA residence on a stunning tree-lined block in Pacific Heights. This beautifully appointed unit features hardwood floors throughout, a spacious living area with sweeping views of Twin Peaks and Sutro Tower, and a private rear deck perfect for relaxing or entertaining. The updated kitchen flows seamlessly into the living and dining areas, while all three bedrooms offer comfort and flexibility. Additional highlights include in-unit laundry, central A/C, and one-car parking. Just steps to the library, chic shops, and acclaimed restaurants, this is the best of San Francisco living in an unbeatable location.

district__c,SF District 7

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

fireplace_features__c,Living Room

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Insurance on Structure,Trash,Water

pba__hoafees__c,378

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2025-05-22T10:46:47.000+0000

pba__latitude_pb__c,37.7896138

pba__latitude_property__c,37.7896138

laundry_features__c,Inside Room;Washer/Dryer Stacked Included;Inside Area;Washer Included;Dryer Included

listed_date__c,2025-05-21

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Maximillian

pba__listing_agent_lastname__c,Armour

listing_agent_mls_id__c,804422

ffd_listingagentname,Maximillian Armour

listing_agent_number__c,166013971

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4446139

mls_id__c,425042004

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

master_property__c,a0O1I00000AAbuhUAD

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2025-05-21

open_house_end__c,2025-05-22T17:30:00.000+0000

open_house_start__c,2025-05-22T16:00:00.000+0000

original_price__c,2195000

overall_days_on_market__c,-82320

parking_access__c,Tandem

parking_features__c,Tandem Garage

parking_type__c,On Site - Unassigned (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,1294.99

pba__propertytype__c,Condominium

ListingId,a0EUd0000055MppMAE

room_type__c,Kitchen;Dining 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,1695

size__c,1695

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Clay

subdist__c,Pacific Heights

ffd_name,3124 Clay Street, San Francisco, CA, 94115

view__c,City Lights;Twin Peaks;Sutro Tower

website_property_type__c,Condominium

window_features__c,Bay Window(s)

pba__yearbuilt_pb__c,1900

pba__postalcode_pb__c,94115

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1747877815

ffd_listing_title,249 21st Avenue, San Francisco, CA, 94121

ffd_mls_id,425042237

ffd_salesforce_id,a0EUd0000055B6QMAU

num_of_fireplaces__c,1

num_of_rooms__c,7

of_units__c,0

pba__address_pb__c,249 21st Avenue, San Francisco, CA, 94121

address2__c,249 21st Avenue, San Francisco, CA, 94121

agent_only_remarks__c,1) Offer date TBD. 2) On supra lockbox, NO appointments or additional call/text notices needed. 3) Seller credit to buyer considered. 4) For disclosures please EMAIL (not texting) listing agent Jason Chan at [email protected]. Disclosure link will be emailed to you once it's ready. 5) For questions, please text Jason at 415.215.1661. 6) For lockbox issues or showing difficulties, please contact Julie Chan via email: [email protected] or via text: 415.672.7988. Email or text preferred. 7) SF purchase agreement preferred, but CAR is okay. 8) Please INCLUDE Contingency Removal form & signing off the cover page of the disclosure packet. 9) Please tell your loan agent NOT TO CALL after your offer is submitted. I will contact them if it's necessary. 10) Pre-sale escrow opened w/ WFG National Title Insurance Company with Kathie Ng. 11) Seller reserves the right to accept, counter, or reject any offer.

appliances__c,Gas Water Heater;Microwave;Hood Over Range;Free Standing Refrigerator;Gas Cook Top

architectural_style__c,Edwardian

bath_features__c,Tub w/Shower Over;Split Bath;Low-Flow Toilet(s);Low-Flow Shower(s)

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,3

year_build_text__c,1914

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Julie Y Chan

pba__contingentdate__c,1800-01-01

ffd_createddate,2025-05-21T18:46:36.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,First time on the market in decades! This well-maintained Edwardian home offers timeless charm and a prime location near Clement Street, California Street, and Geary Boulevard shops and restaurants. Enjoy close proximity to public transit, The Presidio, Baker Beach, China Beach, Ocean Beach, Lands End trails, Lincoln Park Golf Course, the Legion of Honor, and Golden Gate Park. The upper level features three spacious bedrooms, a sunroom that can serve as a fourth bedroom or office, and a split full bath. The main floor boasts a bright east-facing living room with fireplace, formal dining room, an eat-in kitchen, family room, and a convenient powder room. There is direct access to the rear yard from this level. Perfect for indoor-outdoor living. The ground level includes two-car tandem parking, a large laundry room, and abundant space for storage or potential expansion. Freshly painted inside and out, with newly refinished original hardwood floors and brand new hardwood flooring in the kitchen and family room. Expansive, level backyard beautifully trimmed back with lush greenery and mature privacy trees - your own private oasis for relaxing or entertaining. A rare opportunity in a highly sought-after neighborhood!

district__c,SF District 1

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Living Room;Stone

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Central;Fireplace(s)

interior_features__c,Formal Entry;Skylight(s)

ffd_lastmodifieddate,2025-05-22T00:46:47.000+0000

pba__latitude_pb__c,37.7831095

pba__latitude_property__c,37.7831095

laundry_features__c,In Garage;Inside Room;Inside Area;Washer Included;Dryer Included

listed_date__c,2025-05-21

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jason

pba__listing_agent_lastname__c,Chan

listing_agent_mls_id__c,802554

ffd_listingagentname,Jason C Chan

listing_agent_number__c,802554

listing_co_agent_mls_id__c,807828

listing_co_agent_number__c,1027382

listing_co_office_mls_id__c,BARBCO

listing_co_office_name__c,BarbCo

listing_co_office_number__c,28297

listing_office_mls_id__c,BARBCO

listing_office_name__c,BarbCo

listing_office_number__c,28297

pba__listingprice_pb__c,1295000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4808773

lower_level__c,Garage,Partial Bath(s),Street Entrance

mls_id__c,425042237

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

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2025-05-21

open_house_end__c,2025-05-25T16:00:00.000+0000

open_house_start__c,2025-05-25T14:00:00.000+0000

original_price__c,1295000

overall_days_on_market__c,-82320

parking_access__c,Tandem

parking_features__c,Garage Door Opener,Interior Access

parking_type__c,On Site (Single Family 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,716.26

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000055B6QMAU

room_type__c,Storage;Office;Sun Room;Laundry;Kitchen;Living Room;Dining Room;Family Room

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;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,1808

size__c,1808

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,21st

subdist__c,Central Richmond

ffd_name,249 21st Avenue, San Francisco, CA, 94121

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1914

pba__postalcode_pb__c,94121

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1747877813

ffd_listing_title,229 Brannan Street #11J, San Francisco, CA, 94107

ffd_mls_id,425042185

ffd_salesforce_id,a0EUd0000055B6PMAU

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,113

pba__address_pb__c,229 Brannan Street #11J, San Francisco, CA, 94107

address2__c,229 Brannan Street #11J, San Francisco, CA, 94107

agent_only_remarks__c,Easy to show, contact Eric.

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

architectural_style__c,Modern/High Tech

bath_features__c,Shower Stall(s);Tile

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,2001

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2025-05-21T18:46:36.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Located 1 block from the Embarcadero Waterfront, this corner unit offers an extensive sunlight throughout the day, two bedrooms, two full baths and Twin Peaks and SF skyline views. Unit 11J is highlighted by an expansive and elegant L shaped living and dining rooms complemented by a spacious lounge and reading area. A large primary bedroom with en suite bathroom includes a private balcony with Twin Peaks views, while the expansive windows in the second bedroom provide far-reaching and dramatic city views. Situated on opposite sides of the unit, the two bedrooms provide an unparalleled level of privacy. The Brannan is a full-service building offering 24-hr security, concierge services, professionally managed, amazing pool, jacuzzi and fitness center.

district__c,SF District 9

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

pba__floortype_pb__c,Other;Tile

hoa_fee_includes__c,Common Areas,Elevator,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Pool,Roof,Sewer,Trash,Water

pba__hoafees__c,1600

pba__hoafrequency_pb__c,Monthly

hoa_name__c,The Brannan HOA

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

interior_features__c,Formal Entry

ffd_lastmodifieddate,2025-05-22T00:46:47.000+0000

pba__latitude_pb__c,37.7826271

pba__latitude_property__c,37.7826271

laundry_features__c,Inside Room;Laundry Closet;Washer/Dryer Stacked Included;Inside Area;Washer Included;Dryer Included

listed_date__c,2025-05-21

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Eric

pba__listing_agent_lastname__c,Turner

listing_agent_mls_id__c,804276

ffd_listingagentname,Eric Turner

listing_agent_number__c,166013782

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.3903642

mls_id__c,425042185

master_bathroom_features__c,Tub w/Shower Over;Tub;Marble

master_property__c,a0O1I000001VhhnUAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2025-05-21

open_house_end__c,2025-05-24T16:00:00.000+0000

open_house_start__c,2025-05-24T14:00:00.000+0000

original_price__c,1450000

overall_days_on_market__c,-82320

parking_access__c,Side by Side

parking_features__c,Assigned,Attached,Garage Door Opener,Interior Access

parking_type__c,On Site - Mapped (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,1026.91

pba__propertytype__c,Condominium

ListingId,a0EUd0000055B6PMAU

room_type__c,Kitchen;Living Room;Dining Room;Primary Bathroom

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

size__c,1412

pba__state_pb__c,CA

stories__c,18

pba__street_pb__c,Brannan

subdist__c,South Beach

ffd_name,229 Brannan Street #11J, San Francisco, CA, 94107

view__c,City;Downtown

website_property_type__c,Condominium

pba__yearbuilt_pb__c,2001

pba__postalcode_pb__c,94107

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1747912757

ffd_listing_title,2094 48th Avenue, San Francisco, CA, 94116

ffd_mls_id,425035405

ffd_salesforce_id,a0EUd000004t3B5MAI

num_of_fireplaces__c,0

num_of_rooms__c,4

of_units__c,0

pba__address_pb__c,2094 48th Avenue, San Francisco, CA, 94116

address2__c,2094 48th Avenue, San Francisco, CA, 94116

agent_only_remarks__c,Back on market - Supra installed 5/22. Open house will be Sunday 5/25 from 1 to 4. Surfer / beach lover dreamy Great Highway alternative with Ocean views from loft/den over the garage. 1 block to the beach. Tax records show 1,305 square feet. Floor plan measured at 1,162 square feet including den/bedroom. Buyers and their agent should verify square footage to their satisfaction. Escrow open with Katerina Rosignuolo at WFG. On Supra lockbox (Please call)

appliances__c,Free Standing Gas Oven;Free Standing Refrigerator

architectural_style__c,Mid-Century

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1950

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2025-04-30T20:46:22.000+0000

days_on_market__c,22

dom__c,10

ffd_description_pb,Charming mid-century Ocean Beach cottage you will fall in love with! Don't miss this opportunity to live in a fantastic location near the beach in the amazing Outer Sunset Neighborhood of San Francisco. Surf, sea, sandy beach & city living all in one. Lovely and rare southern facing home detached on three and a half sides. Two large bedrooms looking out over a delightful outdoor space. Spacious and bright living area with high ceilings and large windows. Refreshed kitchen and new tile floor and shower in the bath. The upstairs den has ocean views, a large closet and has always been used as a third bedroom. 2094 48th Avenue is located near the highly rated Sunset Elementary School and is perfectly situated between the shops and transportation on Noriega and Taraval. Easy access to 280 for Peninsula commutes.

district__c,SF District 2

entry_level__c,0

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2025-05-22T10:46:47.000+0000

pba__latitude_pb__c,37.7474299

pba__latitude_property__c,37.7474299

laundry_features__c,Hookups Only;Gas Hook-Up

listed_date__c,2025-04-30

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Matt

pba__listing_agent_lastname__c,Ciganek

listing_agent_mls_id__c,807697

ffd_listingagentname,Matt Ciganek

listing_agent_number__c,1024004

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,VANG06

listing_office_name__c,Vanguard Properties

listing_office_number__c,25987

pba__listingprice_pb__c,1195000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.5069628

mls_id__c,425035405

main_level__c,Bedroom(s);Kitchen;Dining Room;Family Room

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2025-04-30

open_house_end__c,2025-05-25T16:00:00.000+0000

open_house_start__c,2025-05-25T13:00:00.000+0000

original_price__c,1195000

overall_days_on_market__c,-82299

parking_access__c,Independent

parking_features__c,Attached

parking_type__c,On Site (Single Family 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,0

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000004t3B5MAI

roof__c,Composition

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

size__c,0

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,48th

subdist__c,Outer Parkside

ffd_name,2094 48th Avenue, San Francisco, CA, 94116

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1950

pba__postalcode_pb__c,94116

ffd_media,Array

ffd_media_tags,Array

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