1654 24th Avenue, San Francisco, CA, 94122 - Property Description

_yoast_indexnow_last_ping,1715252432

ffd_listing_title,3333 Lincoln Way, San Francisco, CA, 94122

ffd_mls_id,424011408

ffd_salesforce_id,a0EUd000001vTzBMAU

num_of_fireplaces__c,0

num_of_rooms__c,6

of_units__c,0

address2__c,3333 Lincoln Way, San Francisco, CA, 94122

pba__address_pb__c,3333 Lincoln Way, San Francisco, CA, 94122

agent_only_remarks__c,Call Martin to see property 415-652-4532 - no Supra. Buyer and/or buyer's agent to verify permit, rooms counts, building square footage and zoning with city authorities. Some photos have been virtually staged. Offer date: TBD

appliances__c,Dishwasher;Free Standing Refrigerator;Gas Cook Top

bath_features__c,Shower Stall(s)

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1923

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-05-03T22:47:41.000+0000

days_on_market__c,6

dom__c,6

ffd_description_pb,Bright and spacious 1,790 sq ft Central Sunset home with tasteful renovations ready to be your home! Open floor plan with two bedrooms and a sunroom- which can function as an office or third bedroom. Primary bedroom includes a bonus renovated bathroom. Gorgeous kitchen with large quartz counters and stainless steel appliances, ample living room and dining area perfect for hosting and entertaining. Light filled single-level living area and hardwood floors throughout. Moreover, the garage level holds potential for expansion, offering exciting possibilities (subject to city regulations and approval). Transform the backyard oasis into a haven for outdoor gatherings and enjoyment. Perfectly situated across from Golden Gate Park, minutes from the Great Highway, Ocean Beach, and Irving Street and Judah Street shopping and restaurants. This residence invites you to infuse it with your unique flair and create the ultimate dream home.

district__c,SF District 2

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-05-09T10:47:22.000+0000

pba__latitude_pb__c,37.7644647

pba__latitude_property__c,37.7644647

laundry_features__c,Inside Area;Ground Floor;Washer Included;Dryer Included

listed_date__c,2024-02-25

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Martin

pba__listing_agent_lastname__c,Leon

listing_agent_mls_id__c,811930

ffd_listingagentname,Martin E Leon

listing_agent_number__c,1054053

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,HARPER

listing_office_name__c,Harper Real Estate

listing_office_number__c,27612

pba__listingprice_pb__c,1249000

pba__listingtype__c,Sale

pba__listing_website__c,https://media.showingtimeplus.com/videos/018f3d88-2a60-72b6-9db6-7ebf7983bf03

pba__longitude_pb__c,-122.4938608

lower_level__c,Garage,Street Entrance

mls_id__c,424011408

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

master_bathroom_features__c,Shower Stall(s)

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,3

on_market_date__c,2024-05-03

open_house_end__c,2024-05-09T19:00:00.000+0000

open_house_start__c,2024-05-09T17:00:00.000+0000

original_price__c,1249000

overall_days_on_market__c,-81937

parking_access__c,Independent

parking_features__c,Attached,Garage Facing Front,Side-by-Side,Uncovered Parking Space

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Front Porch

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001vTzBMAU

room_type__c,Storage;Office;Sun Room;Kitchen;Living Room;Dining Room;Other;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,1790

size__c,1790

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Lincoln

subdist__c,Central Sunset

ffd_name,3333 Lincoln Way, San Francisco, CA, 94122

view__c,Park

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1923

pba__postalcode_pb__c,94122

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1714993065

ffd_listing_title,1291 28th Avenue, San Francisco, CA, 94122

ffd_mls_id,424029442

ffd_salesforce_id,a0EUd000001urPMMAY

num_of_fireplaces__c,1

num_of_rooms__c,6

of_units__c,0

address2__c,1291 28th Avenue, San Francisco, CA, 94122

pba__address_pb__c,1291 28th Avenue, San Francisco, CA, 94122

agent_only_remarks__c,2nd Open Sat 5/11, 1-3PM. More info, floor plans & Matterport for your clients at www.1291-28thAve.com. Cash or Private Lender Only Due to Gutted Kitchen & Deck In Need of Work. Trust Sale, No Court Required, elderly family member passed in home in 2022 of natural causes. NO need to call, please Email (not text) Listing Agent w/?s. Easy to show. To schedule please use the ShowingTime App downloaded to your phone. Cut & Paste link to complete offer instructions and disclosures including home, pest & roof reports will be posted here Thursday 5/9 (and likely not before). Offers reviewed Tuesday 5/14 by 1PM to allow for buyer and trustee due diligence. NO preemptives please. Broker's Note: Property is virtually stage and kitchen is virtually renovated for example only. This is an as-is Trust Sale. 3rd party property inspections provided are for informational purposes only and buyers and agents should not rely on them for making offer or purchase decisions. Buyers are advised to get any and all inspections they deem necessary. Buyers should also verify all square footage and any and all room counts, room legality and permit history for themselves.

architectural_style__c,Edwardian

bath_features__c,Tub w/Shower Over

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,3

year_build_text__c,1923

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-05-03T10:47:29.000+0000

days_on_market__c,4

dom__c,4

ffd_description_pb,Centrally located in the coveted Outer Sunset District, with easy access to Golden Gate Park, Ocean Beach and Irving Street shopping and dining, 1291 28th Avenue offers value-conscious buyers a rare opportunity to reimagine a vintage 1920s 3BD/1BA Edwardian to their specific tastes and desires. 1281 28th Ave greets visitors with a bright FLR w/fireplace, a big FDR and a large kitchen w/sliding doors to a rear deck that has been taken down to the studs and ready for the next owners' project start. Up the home's grand staircase are 3 ample BDs, including a large primary BD, and a conveniently located full BA w/shower over tub in the middle. Fresh paint, warm wood floors, high ceilings & configuration options run thru-out. The home's ground floor boasts a large full-floor garage w/room for multiple car parking, hobbies and/or possible expansion (buyers to verify). A low maintenance rear yard ready for pets & play, with deck ready for redo, completes this comprehensive offering. Wonderful location, with a great Walk Score, steps from GG Park, Muni, Irving St. shopping & dining, local schools, Ocean Beach & more. Bring your tape measure & imagination & come see the opportunity on 28th! Brokers Note: Cash or private lender financing only due to condition. Property is virtually staged.

district__c,SF District 2

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

external_listing__c,1

fencing__c,Fenced

fireplace_features__c,Living Room

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

interior_features__c,Formal Entry

ffd_lastmodifieddate,2024-05-06T10:47:18.000+0000

pba__latitude_pb__c,37.763344

pba__latitude_property__c,37.763344

laundry_features__c,In Garage

listed_date__c,2024-05-02

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Andrew

pba__listing_agent_lastname__c,de Vries

listing_agent_mls_id__c,803319

ffd_listingagentname,Andrew de Vries

listing_agent_number__c,803319

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,BHFP

listing_office_name__c,Berkshire Hathaway-Franciscan

listing_office_number__c,1665

pba__listingprice_pb__c,1048000

pba__listingtype__c,Sale

pba__listing_website__c,http://www.1291-28thave.com/

pba__longitude_pb__c,-122.487026

mls_id__c,424029442

main_level__c,Kitchen;Living Room;Dining Room;Street Entrance

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-05-02

open_house_end__c,2024-05-07T16:00:00.000+0000

open_house_start__c,2024-05-07T09:00:00.000+0000

original_price__c,1048000

overall_days_on_market__c,-81936

parking_access__c,Side by Side

parking_features__c,Attached,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,598.86

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001urPMMAY

roof__c,Bitumen

room_type__c,Kitchen;Living Room;Dining Room;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,1750

size__c,1750

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,28th

subdist__c,Central Sunset

ffd_name,1291 28th Avenue, San Francisco, CA, 94122

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1923

pba__postalcode_pb__c,94122

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1715205507

ffd_listing_title,1281 27th Avenue, San Francisco, CA, 94122

ffd_mls_id,424028537

ffd_salesforce_id,a0EUd000001tMfKMAU

num_of_fireplaces__c,1

num_of_rooms__c,7

of_units__c,0

address2__c,1281 27th Avenue, San Francisco, CA, 94122

pba__address_pb__c,1281 27th Avenue, San Francisco, CA, 94122

agent_only_remarks__c,No lockbox installed per seller's request. All showings by appt. Lots of opens posted on the MLS. Lovely home in the same family for 40 years. Well maintained. Offers Wednesday May 8, 2 pm. Disclosures IO link: https://app.disclosures.io/link/1281-27th-Avenue-k594wzlr

appliances__c,Dishwasher;Free Standing Gas Range;Free Standing Refrigerator

bath_features__c,Tub w/Shower Over

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,3

year_build_text__c,1915

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-05-01T10:47:33.000+0000

days_on_market__c,7

dom__c,7

ffd_description_pb,A stately three-bedroom nestled in the coveted Parkway Terrace neighborhood of the Sunset where classic charm meets modern convenience. Built in 1915, this home showcases craftsmanship and pride of ownership as seen in the details; the decorative windows, built-ins, hardwood floors, exquisite moldings, well preserved woodwork, and an excellent flow. The main level sets the stage for seamless entertaining, featuring a warm formal entry, a living room adorned with a fireplace and built-ins, and a dining room boasting a stately hutch. The kitchen blends contemporary and period accents with stainless appliances, vintage cabinetry, a pantry and direct access to the rear yard. The second floor has three nice sized bright bedrooms including a sunroom off the rear bedroom. The bathroom is charming with vintage tiles and great light. Outside, the front and back are adorned with carefully selected plants, trees and hardscape. The over-sized rear yard is inviting with zoned areas, drip irrigation, artificial turf and low maintenance plants. The garage level is like another house below the house, with lots of space for your projects and activities. Situated just minutes from Golden Gate Park, the 9th Avenue, and Irving Corridor. It has a 90 Walk Score and an 87 Biker's Score.

district__c,SF District 2

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-05-08T21:47:50.000+0000

pba__latitude_pb__c,37.7635328

pba__latitude_property__c,37.7635328

laundry_features__c,In Garage;Washer Included;Dryer Included

listed_date__c,2024-04-01

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Amanda

pba__listing_agent_lastname__c,Jones

listing_agent_mls_id__c,803622

ffd_listingagentname,Amanda M Jones

listing_agent_number__c,803622

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

pba__listingtype__c,Sale

pba__listing_website__c,https://vimeo.com/941352303

pba__longitude_pb__c,-122.4859763

lower_level__c,Garage,Street Entrance

mls_id__c,424028537

main_level__c,Kitchen;Living Room;Dining Room;Street Entrance

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-05-01

original_price__c,1695000

overall_days_on_market__c,-81935

parking_access__c,Independent

parking_features__c,Garage Facing Front

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001tMfKMAU

roof__c,Bitumen

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

size__c,1885

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,27th

subdist__c,Central Sunset

ffd_name,1281 27th Avenue, San Francisco, CA, 94122

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1915

pba__postalcode_pb__c,94122

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1715129829

ffd_listing_title,1370 36th Avenue, San Francisco, CA, 94122

ffd_mls_id,424026369

ffd_salesforce_id,a0EUd000001qctaMAA

num_of_fireplaces__c,1

num_of_rooms__c,5

of_units__c,0

address2__c,1370 36th Avenue, San Francisco, CA, 94122

pba__address_pb__c,1370 36th Avenue, San Francisco, CA, 94122

agent_only_remarks__c,Offers, if any, due Wednesday May 8 by noon.

appliances__c,Dishwasher;Disposal;Built-In Gas Range;Built-In Gas Oven;Double Oven;Built-In Refrigerator

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,4

year_build_text__c,1940

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-26T10:47:22.000+0000

days_on_market__c,11

dom__c,11

ffd_description_pb,Flooded with light, this three-level home is perfect for even the most discriminant buyer. As you enter the main level, you'll step into a beautiful living room blessed with a view of the Sunset. Turn around to the dining room, with its vintage chandelier overhead. As you walk through the house, you'll enter the eat-in kitchen a chef's dream with kind updating. In the back of the main level, you'll find two bedrooms and a bath. Off the back bedrooms, there lies a stupendous deck overlooking the garden. As your pilgrimage continues upstairs, it is like entering Shangri-la. This peaceful level boasts a large master, a second bedroom, and a full bath. Both bedrooms have stunning natural light and beautiful views. Downstairs on the street level, there is an enormous garage, which begs for development, an additional bedroom, and a bath. The gracious garden is perfect for a green thumb and grew award-winning Dahlias in the past. The room and bath down are unwarranted and were added without permit. This is an as-is trust sale.

district__c,SF District 2

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Gas Starter

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Gas

ffd_lastmodifieddate,2024-05-08T00:47:30.000+0000

pba__latitude_pb__c,37.7614598

pba__latitude_property__c,37.7614598

laundry_features__c,In Garage;Washer 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,1695000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4950125

lower_level__c,Garage,Street Entrance

mls_id__c,424026369

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

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-04-26

open_house_end__c,2024-05-07T15:00:00.000+0000

open_house_start__c,2024-05-07T13:00:00.000+0000

original_price__c,1695000

overall_days_on_market__c,-81930

parking_access__c,Tandem

parking_features__c,Enclosed,Garage Door Opener,Interior Access

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,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,742.77

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001qctaMAA

room_type__c,In Law Apartment

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

size__c,2282

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,36th

subdist__c,Central Sunset

ffd_name,1370 36th Avenue, San Francisco, CA, 94122

view__c,Garden/Greenbelt

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1940

pba__postalcode_pb__c,94122

ffd_media,Array

ffd_media_tags,Array

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