506 Guerrero 508 Street, San Francisco, CA, 94110 - Property Description

_yoast_indexnow_last_ping,1726512996

ffd_listing_title,3482 17th Street, San Francisco, CA, 94110

ffd_mls_id,424065875

ffd_salesforce_id,a0EUd0000037PSzMAM

num_of_rooms__c,20

of_units__c,4

address2__c,3482 17th Street, San Francisco, CA, 94110

pba__address_pb__c,3482 17th Street, San Francisco, CA, 94110

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,6

year_build_text__c,1907

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-16T16:47:47.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Colliers International is pleased to present 3482 17th Street (located between Guerrero & Valencia Streets) in the Mission Dolores neighborhood of San Francisco. Its sunny and warm micro-climate and the eclectic mix of trendy restaurants, popular bars, cafes, and coffee shops contribute to the area's immense popularity. This Edwardian style, mid-block apartment building is conveniently located two blocks from Mission Dolores Park and short walk to the Valencia Street corridor. 3482 17th Street is minutes from the 16th Street and the 24th Street Mission Bart Stations, in addition, several bus lines provide easy access to all areas of the City. The building is comprised of two (2) - 4 Room Flats and two (2) - 5 Room Flats and two (2) storage spaces. The units feature hardwood floors, bay windows, fireplaces, and period details. The building is separately metered for gas & electricity. There is a sprinklered basement featuring five (5) storage spaces and a shared backyard for the tenants. 3482 17th Street is a meticulously maintained asset that offers investors or owner occupiers tremendous income upside potential in one of the finest areas of San Francisco.

district__c,SF District 5

external_listing__c,1

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-09-16T18:48:31.000+0000

pba__latitude_pb__c,37.763412

pba__latitude_property__c,37.763412

listed_date__c,2024-09-16

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Brad

pba__listing_agent_lastname__c,Lagomarsino

listing_agent_mls_id__c,981149

ffd_listingagentname,Brad Lagomarsino

listing_agent_number__c,981149

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CINT

listing_office_name__c,Colliers International

listing_office_number__c,24225

pba__listingprice_pb__c,2000000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.423591

mls_id__c,424065875

parkingspaces__c,0

on_market_date__c,2024-09-16

open_house_end__c,2024-09-17T14:00:00.000+0000

open_house_start__c,2024-09-17T12:00:00.000+0000

original_price__c,2000000

overall_days_on_market__c,-82073

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,364.96

pba__propertytype__c,Quadruplex

ListingId,a0EUd0000037PSzMAM

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

size__c,5480

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,17th

subdist__c,Mission Dolores

ffd_name,3482 17th Street, San Francisco, CA, 94110

website_property_type__c,Quadruplex

window_features__c,Bay Window(s)

pba__yearbuilt_pb__c,1907

pba__postalcode_pb__c,94110

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1726512941

ffd_listing_title,166 Dolores Street, San Francisco, CA, 94103

ffd_mls_id,424064421

ffd_salesforce_id,a0EUd0000036H33MAE

num_of_fireplaces__c,2

num_of_rooms__c,0

of_units__c,3

address2__c,166 Dolores Street, San Francisco, CA, 94103

pba__address_pb__c,166 Dolores Street, San Francisco, CA, 94103

agent_only_remarks__c,Escrow opened with Amy Edberg @ First American Title. https://app.disclosures.io/link/166-Dolores-Street-bubib3y6

appliances__c,Dishwasher;Hood Over Range;Free Standing Gas Oven

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

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Declan Hickey

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-13T10:47:14.000+0000

days_on_market__c,4

dom__c,4

ffd_description_pb,Timeless Elegance Meets Modern Comfort in Mission Dolores. Step into a blend of historical charm & contemporary convenience w/ this striking Edwardian condo. Exuding classic appeal, this home combines exquisite period details w/ modern upgrades for the ultimate urban living experience. Elegant Design: Curved bay windows grace the front of the condo, offering captivating views of Dolores Street's vibrant activity. Inside, the home features a spacious eat-in kitchen & formal dining room w/ gorgeous box-beam ceilings & original built-ins, all set w/in an oversized 30' wide lot. Modern Comforts: Contemporary improvements in the kitchen & baths, enhancing your daily living. The tranquil rear of the condo boasts a walkout deck overlooking a beautifully landscaped garden retreat, perfect for relaxing or entertaining. Flexible Floor Plan: 3 generous bdrms, 1.5 baths & abundant closet space, this home provides both comfort & versatility. The rear laundry area is ideal for a home office setup. Exclusive Outdoor Spaces: Dine al fresco on your private deck wrapping the rear of the building, or unwind in the large & shared yardperfect for afternoon relaxation gatherings. Convenience & Storage: Benefit from a lrg assigned storage room in the property's garage & an independent SxS parking.

district__c,SF District 5

entry_level__c,0

external_listing__c,1

fireplace_features__c,Decorative Only;Family Room;Dining Room

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Common Areas,Insurance,Insurance on Structure,Sewer,Trash,Water

pba__hoafees__c,483

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-09-16T18:47:05.000+0000

pba__latitude_pb__c,37.7668506

pba__latitude_property__c,37.7668506

laundry_features__c,Inside Room;Washer Included;Dryer Included

listed_date__c,2024-08-19

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Mollie

pba__listing_agent_lastname__c,Poe

listing_agent_mls_id__c,802851

ffd_listingagentname,Mollie W Poe

listing_agent_number__c,802851

listing_co_agent_mls_id__c,808252

listing_co_agent_number__c,1032461

listing_co_office_mls_id__c,COMP

listing_co_office_name__c,Compass

listing_co_office_number__c,26293

listing_office_mls_id__c,COMP

listing_office_name__c,Compass

listing_office_number__c,26293

pba__listingprice_pb__c,1749000

pba__listingtype__c,Sale

pba__listing_website__c,http://www.166Dolores.com

pba__longitude_pb__c,-122.4268561

mls_id__c,424064421

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

master_property__c,a0OUd00000C02z1MAB

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-09-12

open_house_end__c,2024-09-17T14:00:00.000+0000

open_house_start__c,2024-09-17T12:00:00.000+0000

original_price__c,1749000

overall_days_on_market__c,-82069

parking_access__c,Independent

parking_features__c,Attached,Covered,Garage Door Opener

parking_type__c,On Site - Assigned (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,870.15

pba__propertytype__c,Condominium

ListingId,a0EUd0000036H33MAE

room_type__c,Laundry;Den;Kitchen;Living Room;Dining 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,2010

size__c,2010

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Dolores

subdist__c,Mission Dolores

ffd_name,166 Dolores Street, San Francisco, CA, 94103

view__c,City

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1914

pba__postalcode_pb__c,94103

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1726196331

ffd_listing_title,3525 19th Street, San Francisco, CA, 94110

ffd_mls_id,424063920

ffd_salesforce_id,a0EUd00000361cRMAQ

num_of_fireplaces__c,3

num_of_rooms__c,0

of_units__c,3

address2__c,3525 19th Street, San Francisco, CA, 94110

pba__address_pb__c,3525 19th Street, San Francisco, CA, 94110

agent_only_remarks__c,Offer date TBD after the first weekend of open houses. Disclosures will be ready shortly. Offer on 7-page SFAR Purchase agreement with pre-approval and proof of funds. Easy to show. Contact Jean-Paul at 415-279-0997 or Stephanie at 619-964-4709. Thank you!

appliances__c,Dishwasher;Gas Water Heater;Microwave;Hood Over Range;Built-In Gas Range;Wine Refrigerator;Built-In Refrigerator

architectural_style__c,Edwardian

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,4

year_build_text__c,1911

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Edward R Deleski

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-12T19:48:30.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Welcome to this grand condominium residence with the charm and feel of a single-family home, located in the highly desirable Mission Dolores neighborhood, just steps from Dolores Park and vibrant Valencia Street. This entertainer's dream offers two levels of grand living space and a sunny, magical south-facing garden. The main level features an open floor plan great room, including a chef's kitchen, a dining room with period built-ins and a working fireplace, and a sunny sunroom/lounge -ideal for entertaining. The front of the home offers a lovely double parlor with a formal living room and/or home office and a spacious bedroom. This level also includes two additional bedrooms, a full bathroom, a powder room, & laundry. The lower level boasts a dramatic entertainment room with a wet bar, wine refrigerator, fireplace, and direct access to the private garden. This room can also serve as a primary bedroom suite, with an ensuite bathroom, a walk-in closet & second laundry. Storage and interior access to the garage are also available. Located near a plethora of shops, bakeries, restaurants, and cafes, including Bi-Rite, Tartine, Good Good Culture Club, Lolo, and Craftsman and Wolves. A dog park, kids' playground, pool, tennis courts, bike lanes, and public transportation are nearby

district__c,SF District 5

entry_level__c,0

external_listing__c,1

fireplace_features__c,Wood Burning;Decorative Only;Family Room;Dining Room;Gas Log

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Homeowners Insurance,Sewer,Trash,Water

pba__hoafees__c,746

pba__hoafrequency_pb__c,Monthly

hoa_name__c,3523-3523A-3525 19th Street

hoa__c,Yes

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Central;Gas

interior_features__c,Formal Entry;Wet Bar

ffd_lastmodifieddate,2024-09-13T02:46:26.000+0000

pba__latitude_pb__c,37.7599696

pba__latitude_property__c,37.7599696

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included;Washer Included;Dryer Included

listed_date__c,2024-05-21

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jean-Paul

pba__listing_agent_lastname__c,Samaha

listing_agent_mls_id__c,804997

ffd_listingagentname,Jean-Paul Samaha

listing_agent_number__c,166014752

listing_co_agent_mls_id__c,807512

listing_co_agent_number__c,1020319

listing_co_office_mls_id__c,VANG02

listing_co_office_name__c,Vanguard Properties

listing_co_office_number__c,166013449

listing_office_mls_id__c,VANG02

listing_office_name__c,Vanguard Properties

listing_office_number__c,166013449

pba__listingprice_pb__c,1995000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4220755

lower_level__c,Family Room,Full Bath(s),Garage,Primary Bedroom

mls_id__c,424063920

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

master_bathroom_features__c,Shower Stall(s);Double Sinks

master_property__c,a0OUd00000ByWhqMAF

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-09-12

open_house_end__c,2024-09-14T16:00:00.000+0000

open_house_start__c,2024-09-14T14:00:00.000+0000

original_price__c,1995000

overall_days_on_market__c,-82069

parking_access__c,Tandem

parking_features__c,Garage Door Opener,Interior Access,Tandem Garage,Unassigned

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

pba__propertytype__c,Condominium

ListingId,a0EUd00000361cRMAQ

roof__c,Bitumen

room_type__c,Sun Room;Kitchen;Living Room;Dining Room;Family Room;Great Room

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Security Gate

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

size__c,2345

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,19th

subdist__c,Mission Dolores

ffd_name,3525 19th Street, San Francisco, CA, 94110

view__c,Garden/Greenbelt

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1911

pba__postalcode_pb__c,94110

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1726512925

ffd_listing_title,130 Landers Street #H, San Francisco, CA, 94114

ffd_mls_id,424064841

ffd_salesforce_id,a0EUd0000035ueFMAQ

num_of_fireplaces__c,1

num_of_rooms__c,5

of_units__c,0

address2__c,130 Landers Street #H, San Francisco, CA, 94114

pba__address_pb__c,130 Landers Street #H, San Francisco, CA, 94114

agent_only_remarks__c,Pre-escrow opened with Michelle Patterson at WFG. Disclosure package to be ready after first weekend of open houses. Contact Andres Restrepo for showings.

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1983

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Martha Golonko

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-12T17:47:32.000+0000

days_on_market__c,4

dom__c,4

ffd_description_pb,Designed by renowned architect Stephen A. Roake, the Church Street Gardens complex is a true oasis in the heart of the city. This bright and modern 2BD/1.5BA townhouse-like condo is located on a quiet side street in a prime Mission Dolores location.These units are rarely available, and are only steps away from Duboce & Castro neighborhoods and tech shuttle stops. Enjoy a functional & open floor plan on the upper level that offers plenty of natural light via skylights & floor-to-ceiling windows, high 16' wood-beamed ceilings, engineered hardwood flooring, & down-to-the-studs updated electrical system. Both generously sized bedrooms with custom closets are located on a separate level with a full spa-like renovated bathroom. A laundry closet, half-bath, smart thermostats, fireplace, & outdoor patio add additional functionality and convenience to the space. Deeded 1 car parking & XXL private storage space included. This well-maintained building shares a common courtyard that has a wine country feel with landscaped gardens & several BBQ seating areas with secluded hot tub, outdoor shower, and sauna. Ideally located near Dolores Park, Valencia St, groceries, lively restaurants and bars in the Castro & on Market St, Bart, and underground Muni transportation.

district__c,SF District 5

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room

pba__hoafees__c,874

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,1

has_3d_tour__c,1

ffd_lastmodifieddate,2024-09-16T18:47:05.000+0000

pba__latitude_pb__c,37.7656154

pba__latitude_property__c,37.7656154

listed_date__c,2024-09-12

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Andres

pba__listing_agent_lastname__c,Restrepo

listing_agent_mls_id__c,813538

ffd_listingagentname,Andres F Restrepo

listing_agent_number__c,1062005

listing_co_agent_mls_id__c,816568

listing_co_agent_number__c,1075528

listing_co_office_mls_id__c,COMP50

listing_co_office_name__c,Compass

listing_co_office_number__c,28741

listing_office_mls_id__c,COMP50

listing_office_name__c,Compass

listing_office_number__c,28741

pba__listingprice_pb__c,1295000

pba__listingtype__c,Sale

pba__listing_website__c,https://my.matterport.com/show/?m=QYBVmP3hJd9

pba__longitude_pb__c,-122.4278548

mls_id__c,424064841

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-09-12

open_house_end__c,2024-09-17T13:30:00.000+0000

open_house_start__c,2024-09-17T12:00:00.000+0000

original_price__c,1295000

overall_days_on_market__c,-82069

parking_access__c,Independent

parking_features__c,Covered,Garage Door Opener

parking_type__c,On Site - Assigned (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,1125.11

pba__propertytype__c,Townhouse

ListingId,a0EUd0000035ueFMAQ

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

size__c,1151

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Landers

subdist__c,Mission Dolores

ffd_name,130 Landers Street #H, San Francisco, CA, 94114

website_property_type__c,Townhouse

pba__yearbuilt_pb__c,1983

pba__postalcode_pb__c,94114

ffd_media,Array

ffd_media_tags,Array

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