2580 Diamond Street, San Francisco, CA, 94131 - Property Description

_yoast_indexnow_last_ping,1713956271

ffd_listing_title,17 Miguel Street, San Francisco, CA, 94131

ffd_mls_id,424020800

ffd_salesforce_id,a0EUd000001ngOxMAI

num_of_fireplaces__c,1

num_of_rooms__c,7

of_units__c,0

address2__c,17 Miguel Street, San Francisco, CA, 94131

pba__address_pb__c,17 Miguel Street, San Francisco, CA, 94131

agent_only_remarks__c,Hidden gem, garages only at street level, detached home and gardens below. CC&R's provide for a great deal of autonomy for each townhome, with no monthly dues, minimal shared expenses. Tour 4/23 12-2pm, Open 4/27-28 1-4pm. Text 415-310-5933 or email [email protected] to show or to request disclosure packet.

appliances__c,Dishwasher;Microwave;Disposal;Electric Cook Top;Free Standing Refrigerator;Built-In Electric Oven

architectural_style__c,Modern/High Tech

bath_features__c,Tub w/Shower Over

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1978

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-22T10:47:05.000+0000

days_on_market__c,2

dom__c,2

ffd_description_pb,This contemporary and spacious 3-level home has 2BR/2BA + Den & Family Room and is set back from street level, surrounded by lush private gardens with sweeping views from all rooms. Truly unique in its setting and design. 17 Miguel is one of two detached townhomes custom built in 1978 on the same lot and subsequently subdivided so that each home is substantially independent. An entry garden leads to the main level front door opening into a great room with double-story ceilings. Green house bay windows capture a wide panorama of downtown and the Bay Bridge. Finishes here include hardwood floors, insulated windows, a central wood burning fireplace and built-ins. There is an adjacent dining alcove and modern galley kitchen overlooking the garden entrance. A full bedroom and bath complete this level. Decks off the living room and secondary bedroom. Upstairs, the loft-like den is open to the living room below, with breathtaking picture window views and a sunny private deck. The light and bright primary suite on this level also enjoys stunning views and has its own private deck plus walk-in closet. A large downstairs family room has washer/dryer hookups and draft architectural plans for further development into a separate guest suite. Lovely serene urban retreat in a central location.

district__c,SF District 5

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room;Wood Burning

pba__floortype_pb__c,Carpet;Tile;Wood

hoa_fee_includes__c,See Remarks

pba__hoafees__c,0

hoa_name__c,17-19 Miguel Street HOA

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Gas

interior_features__c,Skylight(s);Cathedral Ceiling

ffd_lastmodifieddate,2024-04-24T10:47:49.000+0000

pba__latitude_pb__c,37.739441

pba__latitude_property__c,37.739441

laundry_features__c,Hookups Only;Ground Floor

listed_date__c,2024-04-01

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Dona

pba__listing_agent_lastname__c,Crowder

listing_agent_mls_id__c,039695

ffd_listingagentname,Dona Crowder

listing_agent_number__c,39695

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CBLUXURY

listing_office_name__c,Coldwell Banker Realty

listing_office_number__c,2128

pba__listingprice_pb__c,1775000

pba__listingtype__c,Sale

pba__listing_website__c,http://www.17miguel.com

pba__longitude_pb__c,-122.430543

lower_level__c,Family Room

mls_id__c,424020800

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

master_bathroom_features__c,Tub w/Shower Over

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-22

open_house_end__c,2024-04-27T16:00:00.000+0000

open_house_start__c,2024-04-27T13:00:00.000+0000

original_price__c,1775000

overall_days_on_market__c,-81926

parking_access__c,Independent

parking_features__c,Detached,Garage Door Opener

parking_type__c,On Site (Single Family Only);On Site - Mapped (Condo 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,860.81

pba__propertytype__c,Townhouse

ListingId,a0EUd000001ngOxMAI

room_type__c,Den;Kitchen;Living Room;Dining Room;Family Room;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Alarm;Carbon Mon Detector;Security System Owned

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

size__c,2062

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Miguel

subdist__c,Glen Park

ffd_name,17 Miguel Street, San Francisco, CA, 94131

view__c,Panoramic;Garden/Greenbelt;Bay;Downtown;Bay Bridge;Mt Diablo

website_property_type__c,Townhouse

window_features__c,Dual Pane Full;Bay Window(s)

pba__yearbuilt_pb__c,1978

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713697095

ffd_listing_title,1840 Church 1842 Street, San Francisco, CA, 94131

ffd_mls_id,424025677

ffd_salesforce_id,a0EUd000001nX78MAE

num_of_fireplaces__c,2

num_of_rooms__c,10

of_units__c,0

address2__c,1840 Church 1842 Street, San Francisco, CA, 94131

pba__address_pb__c,1840 Church 1842 Street, San Francisco, CA, 94131

agent_only_remarks__c,VACANT 2 Noe Valley Units - 1031 Exchange - Sale subject to Seller identifying replacement property. Disclosures are coming soon, and buyers may investigate to their satisfaction. Please call or text Alex to schedule an appointment 415-505-7579.

appliances__c,Gas Water Heater;Free Standing Gas Oven;Gas Plumbed

architectural_style__c,Contemporary

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

pba__fullbathrooms_pb__c,4

pba__bedrooms_pb__c,0

year_build_text__c,1979

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-20T16:46:13.000+0000

days_on_market__c,2

dom__c,2

ffd_description_pb,Spacious Church Street duplex awaits your vision and TLC in Upper Noe Valley. Family-owned for 50 years, now looking for a new owner who needs a large space for hobbies (cars/motorcycles) or an Investor, or even separate individuals with a goal to partner as TIC ownership. Property has 2 identical units with 2 bedrooms &1.5 baths each. Both feature in-unit laundry rooms, formal living rooms w/ fireplaces, formal dining rooms, large kitchens and 1-car parking in garage. The front driveway can accommodate 2 additional cars. Lower unit includes a bonus non-conforming space with an efficiency kitchen & bath that can be used as a private office or gym. Top flat boasts views, and access to a rooftop deck and has an additional Junior apartment above, perfect for guests or an Au pair/Nanny. The rear yard can be accessed via the garage. Proximity to Glen Park and the Church & 30th Shops or the Upper Noe Valley Recreation Center.

district__c,SF District 5

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Living Room;Wood Burning

pba__floortype_pb__c,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-04-21T10:46:33.000+0000

pba__latitude_pb__c,37.741048

pba__latitude_property__c,37.741048

laundry_features__c,Hookups Only;Inside Area

listed_date__c,2024-04-19

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Alex

pba__listing_agent_lastname__c,Maltez

listing_agent_mls_id__c,980113

ffd_listingagentname,Alex Maltez

listing_agent_number__c,980113

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,BRES02

listing_office_name__c,Bay Area Real Estate Services

listing_office_number__c,27779

pba__listingprice_pb__c,2980850

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.42705

lower_level__c,Loft

mls_id__c,424025677

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,4

on_market_date__c,2024-04-19

open_house_end__c,2024-04-21T16:00:00.000+0000

open_house_start__c,2024-04-21T13:00:00.000+0000

original_price__c,2980850

overall_days_on_market__c,-81923

parking_access__c,Side by Side

parking_features__c,Assigned,Garage Door Opener,Interior Access,Side-by-Side

parking_type__c,Other

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

pba__propertytype__c,Halfplex

ListingId,a0EUd000001nX78MAE

road_surface_type__c,Asphalt

roof__c,Flat

room_type__c,Kitchen;Dining Room;Primary Bathroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Security Gate;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,2640

size__c,2640

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Church

subdist__c,Glen Park

ffd_name,1840 Church 1842 Street, San Francisco, CA, 94131

view__c,City;Hills

website_property_type__c,Halfplex

pba__yearbuilt_pb__c,1979

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1714093117

ffd_listing_title,186 Lippard Avenue, San Francisco, CA, 94131

ffd_mls_id,424022619

ffd_salesforce_id,a0EUd000001mYDRMA2

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

address2__c,186 Lippard Avenue, San Francisco, CA, 94131

pba__address_pb__c,186 Lippard Avenue, San Francisco, CA, 94131

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1910

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-19T10:49:46.000+0000

days_on_market__c,7

dom__c,7

ffd_description_pb,Delightful two-bedroom Victorian home in A+ Glen Park location. Rich, warm wood floors & period details throughout. Light-filled living room w/ crown molding & bay windows. Beautiful family room/den/home office w/ cute bar sink connects to kitchen. Bright kitchen w/ stainless appliances and quartz counter tops. Generous dining space w/ beautiful, original built-in hutch - great for entertaining! Sumptuous principal bedroom w/ luxe, skylit ensuite bath and French doors opening to the lush garden and hot tub. Flexible second BDR with built in shelving. Laundry room & second full tiled bath complete the home. Stunning garden w/ succulents, lemon tree & mature plantings. Stone patio for al fresco dining. Large basement & attic space - great for all storage needs. Architectural plans for second story addition available. Ample street parking. Nestled in a walker's paradise, this home offers easy access to BART (4 mins), tech shuttles (Google, Genentech, Apple, etc.) (4 mins), Glen Park Library, playgrounds, tennis courts, Canyon Market, Gialina, La Corneta, and more! With proximity to Noe, Bernal, downtown, SFO, 280/101 freeways, and various MUNI lines, this beautiful home with a perfect layout and a charming backyard is will make you swoon.

district__c,SF District 5

entry_level__c,0

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-04-26T00:46:44.000+0000

pba__latitude_pb__c,37.733045

pba__latitude_property__c,37.733045

listed_date__c,2024-03-18

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jessica

pba__listing_agent_lastname__c,Branson

listing_agent_mls_id__c,805610

ffd_listingagentname,Jessica Branson

listing_agent_number__c,166015601

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP41

listing_office_name__c,Compass

listing_office_number__c,27887

pba__listingprice_pb__c,1395000

pba__listingtype__c,Sale

pba__listing_website__c,http://www.GlenParkDream.com

pba__longitude_pb__c,-122.436368

mls_id__c,424022619

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2024-04-18

open_house_end__c,2024-04-25T13:00:00.000+0000

open_house_start__c,2024-04-25T12:00:00.000+0000

original_price__c,1395000

overall_days_on_market__c,-81922

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001mYDRMA2

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

size__c,1090

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Lippard

subdist__c,Glen Park

ffd_name,186 Lippard Avenue, San Francisco, CA, 94131

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1910

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713178659

ffd_listing_title,228 Stillings Avenue, San Francisco, CA, 94131

ffd_mls_id,424022159

ffd_salesforce_id,a0EUd000001fm50MAA

num_of_fireplaces__c,1

num_of_rooms__c,9

of_units__c,0

address2__c,228 Stillings Avenue, San Francisco, CA, 94131

pba__address_pb__c,228 Stillings Avenue, San Francisco, CA, 94131

agent_only_remarks__c,Buyer to investigate square footage to their satisfaction. Public records are not accurate. Offer date Wed. 4/24 @ 10am. Property not on lockbox. Offers to be written on the most updated SFAR Purchase Agreement. Seller reserves the right to accept or decline any offers. Seller requests escrow to stay with Old Republic Title Co., Mia McDowell.

architectural_style__c,Art Deco;Mid-Century

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1942

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-08T10:47:05.000+0000

days_on_market__c,7

dom__c,7

ffd_description_pb,Welcome to 228 Stillings Ave., a move-in ready, sun-filled, mid-century, Miraloma Park home on the border of Glen Park. It features high ceilings, original wood floors, multiple skylights and art deco-inspired details. On the main level, you will find a spacious living room, a wood burning fireplace, opening into a formal dining room along with a renovated kitchen. Towards the back, are two large bedrooms and a full bathroom with built-in storage cabinets. Both bedrooms face the beautifully landscaped backyard with expansive views of Glen Canyon. Downstairs is a generous primary bedroom with views, a large walk in closet and ensuite bathroom. On this level you will also find a spacious office with a built-in reading nook and a large laundry/mud room with interior access to the garage. Off the garage there is entry to a coveted wine cellar, huge storage room and entrance to the garden. There you will find a tranquil low maintenance backyard, perfect for relaxation and entertaining. The large brick patio is ideal for dining and the raised planter beds surround additional open space to share with family and friends. Located near highly rated Miraloma Park Elementary school, Sunnyside Playground, Glen Canyon Park, shops, BART, with close transit & freeway access.

district__c,SF District 5

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard;Wood

fireplace_features__c,Living Room;Wood Burning;Stone;Raised Hearth

pba__floortype_pb__c,Carpet;Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

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

ffd_lastmodifieddate,2024-04-15T10:47:25.000+0000

pba__latitude_pb__c,37.734713

pba__latitude_property__c,37.734713

laundry_features__c,Inside Room;Hookups Only;Cabinets

listed_date__c,2023-08-01

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Pamela

pba__listing_agent_lastname__c,Parker Murphy

listing_agent_mls_id__c,812647

ffd_listingagentname,Pam Parker Murphy

listing_agent_number__c,1057609

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CIP01

listing_office_name__c,Corcoran Icon Properties

listing_office_number__c,28939

pba__listingprice_pb__c,1495000

pba__listingtype__c,Sale

pba__listing_website__c,https://drive.google.com/drive/folders/1pQZjmvHKT5PuCONXUmyPWqvcM0BN5zE3

pba__longitude_pb__c,-122.4448793

lower_level__c,Full Bath(s),Garage,Primary Bedroom,Retreat,Street Entrance

mls_id__c,424022159

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

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-08

open_house_end__c,2024-04-16T14:00:00.000+0000

open_house_start__c,2024-04-16T12:00:00.000+0000

original_price__c,1495000

overall_days_on_market__c,-81912

parking_access__c,Independent

parking_features__c,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access,Private

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001fm50MAA

room_type__c,Storage;Office;Laundry;Wine Cellar;Wine Storage Area

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

size__c,1732

pba__state_pb__c,CA

stories__c,2

pba__street_pb__c,Stillings

subdist__c,Glen Park

ffd_name,228 Stillings Avenue, San Francisco, CA, 94131

view__c,City Lights;Garden/Greenbelt;Twin Peaks;Canyon

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1942

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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