245 Diamond 247 Street, San Francisco, CA, 94114 - Property Description

_yoast_indexnow_last_ping,1733226865

ffd_listing_title,335 Diamond Street, San Francisco, CA, 94114

ffd_mls_id,424074024

ffd_salesforce_id,a0EUd000003k0phMAA

num_of_fireplaces__c,1

num_of_rooms__c,10

of_units__c,0

address2__c,335 Diamond Street, San Francisco, CA, 94114

pba__address_pb__c,335 Diamond Street, San Francisco, CA, 94114

agent_only_remarks__c,No sign at property. No public open houses, private showings available to qualified clients. Disclosure package available. Property website at sfmoderndiamond.com with full pics, video, etc.

appliances__c,Dishwasher;Disposal;Hood Over Range;Ice Maker;Built-In Refrigerator;Gas Cook Top;Built-In Freezer

architectural_style__c,Modern/High Tech

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,3

year_build_text__c,1904

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,MultiZone,See Remarks

ffd_createddate,2024-12-02T22:47:34.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,From the design team of Sawyers Design and architect Hulett Jones comes a residence unlike any other. Your eye is drawn to the geometric angles, individually hewn radial cut cedar slats, large glass surfaces, and standing seam metal exteriors that honor the Victorian history of the block while creating a modern masterpiece. Sited at the rear of the property, the home maximizes views downtown, north, and west, with classic SF views both expected and unexpected. The main level has public rooms for living, dining, and cooking, and an additional room currently used as a study.The kitchen features a white quartzite counter, gas cooktop, recessed range hood, custom cabinetry and downtown views. A full bath with yard access completes this level. The entire upper level is the primary bedroom suite. The NE-facing bedroom offers wrap-around windows with downtown views through mature cypress trees and extensive closet space. The bathroom offers a spa-level experience. The lower level has a separate entrance to a mudroom'' w/ W/D, wine cooler, and storage. It's the perfect transitional space designed to make living easier. There's also an additional bedroom suite and flex space that awaits your perfect use: guests, a family room, large work-from-home space, or even a fourth bedroom.

district__c,SF District 5

entry_level__c,0

fireplace_features__c,Living Room;Gas Starter

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Radiant Floor;Central;Gas;MultiZone

interior_features__c,Formal Entry;Cathedral Ceiling

ffd_lastmodifieddate,2024-12-03T11:47:59.000+0000

pba__latitude_pb__c,37.7569994

pba__latitude_property__c,37.7569994

listed_date__c,2024-10-01

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Matt

pba__listing_agent_lastname__c,Fuller

listing_agent_mls_id__c,802876

ffd_listingagentname,Matt Fuller

listing_agent_number__c,802876

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,JFLL

listing_office_name__c,Jackson Fuller Real Estate

listing_office_number__c,27078

pba__listingprice_pb__c,7500000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4364516

mls_id__c,424074024

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-12-02

original_price__c,7500000

overall_days_on_market__c,-82150

parking_access__c,Independent

parking_features__c,Garage Door Opener

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000003k0phMAA

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

size__c,3178

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Diamond

subdist__c,The Castro - Dolores Heights

ffd_name,335 Diamond Street, San Francisco, CA, 94114

view__c,Downtown;Twin Peaks

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1904

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1732449121

ffd_listing_title,209 Sanchez Street, San Francisco, CA, 94114

ffd_mls_id,424044994

ffd_salesforce_id,a0EUd000002RdiTMAS

num_of_rooms__c,17

of_units__c,6

address2__c,209 Sanchez Street, San Francisco, CA, 94114

pba__address_pb__c,209 Sanchez Street, San Francisco, CA, 94114

agent_only_remarks__c,Seller offering concessions. Seller petitioning for Cap. Imp. pass-through. approximate increase in rents of $400+ per month if approved. Call listing agent to discuss. Great units with immediate upside as soft story retrofit was not passed-through. Some banked rents. Lots of updates to systems and half the units. Escrow open with Rita Lin. Disclosures should all be uploaded to disclosures I.O. before the first showing which is Broker's Tour on 7/2/24 from noon to 2:00. Call agents with questions.

appliances__c,Varies By Unit

architectural_style__c,Edwardian

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,5

year_build_text__c,1905

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Jack J Silva

pba__contingentdate__c,1800-01-01

cooling__c,Ceiling Fan(s)

ffd_createddate,2024-06-28T19:49:59.000+0000

days_on_market__c,149

dom__c,129

ffd_description_pb,Updated building in the heart of the Castro/Upper Market Districts. Oversized lot, s/s parking in rear, soft-story work complete, and much upside in the income. This building is near everything, virtually assuring value as a desirable rental.

district__c,SF District 5

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Individual;Varies by Unit

interior_features__c,Formal Entry;Skylight(s);Storage Area(s)

ffd_lastmodifieddate,2024-11-24T11:48:42.000+0000

pba__latitude_pb__c,37.7656112

pba__latitude_property__c,37.7656112

listed_date__c,2024-06-25

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Victor

pba__listing_agent_lastname__c,Borelli

listing_agent_mls_id__c,059073

ffd_listingagentname,Victor E Borelli

listing_agent_number__c,59073

listing_co_agent_mls_id__c,804784

listing_co_agent_number__c,166014462

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4307938

mls_id__c,424044994

parkingspaces__c,5

on_market_date__c,2024-06-28

original_price__c,2399500

overall_days_on_market__c,-81993

parking_features__c,Garage Door Opener,Uncovered

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,580.01

pba__propertytype__c,5 or More Unit

ListingId,a0EUd000002RdiTMAS

roof__c,Tar/Gravel;Composition

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Security Gate;Fire Alarm;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,4137

size__c,4137

pba__state_pb__c,CA

stories__c,4

pba__street_pb__c,Sanchez

subdist__c,The Castro - Dolores Heights

ffd_name,209 Sanchez Street, San Francisco, CA, 94114

view__c,Twin Peaks;Hills

website_property_type__c,5 or More Unit

pba__yearbuilt_pb__c,1905

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1733190950

ffd_listing_title,171 Caselli Street, San Francisco, CA, 94114

ffd_mls_id,424060308

ffd_salesforce_id,a0EUd000003fw1VMAQ

num_of_fireplaces__c,2

num_of_rooms__c,8

of_units__c,0

address2__c,171 Caselli Street, San Francisco, CA, 94114

pba__address_pb__c,171 Caselli Street, San Francisco, CA, 94114

agent_only_remarks__c,Can be shown by lockbox (contact [email protected] for code) or by appointment. Harcourts Certified & Transparent Non-Distressed Auction Platform. Live Auction December 19 @12pm. Bidding to start from $2,250,000. No Buyer Premium. All Property, Seller Reports/Disclosures complete. More info on auction at https://liveauction.link/171Caselli-20Yukon. All offers encouraged. Submit an offer to stop the auction -- loan or cash. Easy process to register to bid at auction. Online bidding and streaming available. Run don't walk! 2 VACANT SFHs with multiple attractive scenarios for owner occupiers or investors/developers. Projected rental for 2 houses is $14,000 to $15,000/mo. Tax records inaccurate. Per appraiser 171 Caselli approx 2,640 sq. ft. and 20 Yukon approx 829 sq. ft. Buyers to cooperate in Seller's 1031 exchange. Both homes are part of one assessor's parcel. Partner buyers' must make their own ownership agreement (tenancy in common or other). Disclosures here or linked above: https://app.disclosures.io/link/171-Caselli-Avenue20-Yukon-St-g4texwoe DEVELOPMENT ANALYSIS: go to https://www.citystructure.com/zoning/171-Caselli-Ave-San-Francisco-CA/06670002702001/gNbyINny/

appliances__c,Dishwasher;Disposal;Free Standing Gas Range

architectural_style__c,Art Deco

bath_features__c,Tub w/Shower Over;Shower Stall(s);Tub;Tile

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,4

year_build_text__c,1932

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Lisa Riddle

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-11-22T18:47:57.000+0000

days_on_market__c,87

dom__c,63

ffd_description_pb,Ready for the best opportunity of 2024? Luxury Live Auction! Bidding to start from INCREDIBLE price of $2,250,000! That's less than $650/sq ft for prime San Francisco real estate. 2 VACANT single family homes, each with a garage, on a sunny corner lot. Trophy property. Rare legacy compound. Turnkey move-in or multiple development scenarios. Quiet, sunny. Easy stroll to Dolores Pk, Castro Village, Corona Hts, MUNI, more. 171 CASELLI is a vacant 2-level, 4 BR, 2 BA deco era home with parking & sunny walkout garden. REMODELED, grand scale, rich character, sunshine galore. LR has curved ceiling, arched windows all around, gas fireplace. FDR fits a dozen friends at table. Remodeled kitchen w/ counter seating. Oversized breakfast room. 2 BRs, deco BA with separate shower / tub on main level. 2 BRs, 2 BAs lower level. Luxury primary BR downstairs has seating area, en suite BA, 2 large closets. Interior access to garage. Laundry rm. Solar energy. 20 YUKON is a VACANT 2-story free-standing 1BR 1BA house on same lot. It has its own garage and street entry. Plus downtown views! Hardwoods. FP. Eat-in kitchen. Laundry. Lots of storage. If this sounds too good to be true, then seeing is believing!

district__c,SF District 5

electric__c,Photovoltaics Seller Owned

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Living Room

pba__floortype_pb__c,Carpet;Tile;Vinyl;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Gas

interior_features__c,Formal Entry;Skylight(s)

ffd_lastmodifieddate,2024-12-03T01:47:13.000+0000

pba__latitude_pb__c,37.7595126

pba__latitude_property__c,37.7595126

laundry_features__c,Inside Room;Washer Included;Dryer Included

listed_date__c,2024-06-18

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Cynthia

pba__listing_agent_lastname__c,Cummins

listing_agent_mls_id__c,244893

ffd_listingagentname,Cynthia Cummins

listing_agent_number__c,244893

listing_co_agent_mls_id__c,816679

listing_co_agent_number__c,1075631

listing_co_office_mls_id__c,KINDRED

listing_co_office_name__c,Kindred SF Homes

listing_co_office_number__c,27654

listing_office_mls_id__c,KINDRED

listing_office_name__c,Kindred SF Homes

listing_office_number__c,27654

pba__listingprice_pb__c,2250000

pba__listingtype__c,Sale

pba__listing_website__c,https://vimeo.com/1003517451

pba__longitude_pb__c,-122.4424087

lower_level__c,Bedroom(s)

mls_id__c,424060308

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

master_bathroom_features__c,Shower Stall(s);Tile

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-09-06

open_house_end__c,2024-12-03T14:00:00.000+0000

open_house_start__c,2024-12-03T12:00:00.000+0000

original_price__c,3750000

overall_days_on_market__c,-82063

parking_access__c,Independent

parking_features__c,Attached,Garage Door Opener,Garage Facing Front,Garage Facing Side,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,648.6

pba__propertytype__c,2 Houses on Lot

ListingId,a0EUd000003fw1VMAQ

room_type__c,Laundry;Kitchen;Living Room;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,3469

size__c,3469

pba__state_pb__c,CA

stories__c,2

pba__street_pb__c,Caselli

subdist__c,The Castro - Dolores Heights

ffd_name,171 Caselli Street, San Francisco, CA, 94114

view__c,Garden/Greenbelt;Downtown;Hills

website_property_type__c,2 Houses on Lot

pba__yearbuilt_pb__c,1932

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1733403331

ffd_listing_title,3381 21st Street, San Francisco, CA, 94110

ffd_mls_id,424081043

ffd_salesforce_id,a0EUd000003fc7dMAA

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,2

address2__c,3381 21st Street, San Francisco, CA, 94110

pba__address_pb__c,3381 21st Street, San Francisco, CA, 94110

agent_only_remarks__c,Sirkin TIC Agreement with fast track condo conversion possibility. For more information and showing requests, contact Jeff Stephenson 415-577-2580 / [email protected]

architectural_style__c,Victorian

pba__fullbathrooms_pb__c,4

pba__bedrooms_pb__c,5

year_build_text__c,1909

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Mark Brown

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-11-22T01:47:58.000+0000

days_on_market__c,14

dom__c,14

ffd_description_pb,Discover this beautifully remodeled, move-in ready home in San Francisco's desirable Liberty Hill neighborhood. This two-level, 5-bedroom residence has been tastefully updated throughout, featuring an open-plan kitchen with counter-level dining at the built-in island - perfect for entertaining! The versatile family room, which can also serve as a large guest bedroom, opens directly to an exclusive-use patio, ideal for outdoor gatherings. With five generously sized bedrooms, there's ample space for guests and a home office. The home boasts four updated full baths, including a split bath, complemented by a convenient powder room on the main floor. Located in a charming Queen Anne Victorian duplex, buyers are encouraged to explore the potential for a fast-track condominium conversion. Period details such as decorative moldings, warm hardwood floors, and an elegant fireplace add to the home's charm and character. Enjoy the vibrant community of Eureka Valley and Dolores Heights, with shops, dining, and entertainment right at your doorstep!

district__c,SF District 5

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Living Room

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,Yes

pba__halfbathrooms_pb__c,1

ffd_lastmodifieddate,2024-12-05T12:47:03.000+0000

pba__latitude_pb__c,37.7567066

pba__latitude_property__c,37.7567066

laundry_features__c,Hookups Only

listed_date__c,2024-11-19

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

pba__listingtype__c,Sale

pba__listing_website__c,https://3381-21st-street.com

pba__longitude_pb__c,-122.4229586

lower_level__c,Bedroom(s),Family Room,Full Bath(s),Partial Bath(s)

mls_id__c,424081043

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

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2024-11-21

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

open_house_start__c,2024-12-07T14:00:00.000+0000

original_price__c,1598000

overall_days_on_market__c,-82139

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

pba__propertytype__c,Tenancy In Common

ListingId,a0EUd000003fc7dMAA

room_type__c,Office;Laundry;Baths Other;Family Room;Possible Guest;Great Room

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

size__c,2815

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,21st

subdist__c,The Castro - Dolores Heights

ffd_name,3381 21st Street, San Francisco, CA, 94110

website_property_type__c,Tenancy In Common

pba__yearbuilt_pb__c,1909

pba__postalcode_pb__c,94110

ffd_media,Array

ffd_media_tags,Array

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