225 Cole 227 Street, San Francisco, CA, 94117 - Property Description

_yoast_indexnow_last_ping,1715036292

ffd_listing_title,403 Lyon Street, San Francisco, CA, 94117

ffd_mls_id,424011359

ffd_salesforce_id,a0EUd000001HchpMAC

num_of_rooms__c,17

of_units__c,5

address2__c,403 Lyon Street, San Francisco, CA, 94117

pba__address_pb__c,403 Lyon Street, San Francisco, CA, 94117

agent_only_remarks__c,Please call or email Rachel Abraham-Pollard at [email protected] or 415.828.3964 for more information or to schedule a showing.

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,0

year_build_text__c,1905

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-02-27T22:48:08.000+0000

days_on_market__c,70

dom__c,70

ffd_description_pb,403 Lyon Street is an excellent add-value opportunity in NOPA. This prominent corner building has tremendous upside potential for a new owner to realize. The property consists of three residential units and two commercial spaces. The residential are 4bd/1.5ba, 3bd/1ba, and 2bd/1ba. The main commercial space is occupied by an established market and deli. The smaller commercial space operates as a showroom for a cabinetry business. There is a large basement that brings in additional income on separate commercial leases. There is 400 amp electrical service, with all units being separately metered for gas and electricity. This location provides tenants with easy access to the Panhandle, Divisadero corridor, and all the conveniences of NOPA and Haight Ashbury. This offering presents a new owner with the opportunity to buy in one of the city's best rental locations and at an extremely low price per unit and square foot.

district__c,SF District 6

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-05-06T22:49:07.000+0000

pba__latitude_pb__c,37.774569

pba__latitude_property__c,37.774569

listed_date__c,2024-02-26

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Adam

pba__listing_agent_lastname__c,Filly

listing_agent_mls_id__c,803097

ffd_listingagentname,Adam D Filly

listing_agent_number__c,803097

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP13

listing_office_name__c,Compass Commercial

listing_office_number__c,27689

pba__listingprice_pb__c,1400000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.442986

mls_id__c,424011359

parkingspaces__c,0

on_market_date__c,2024-02-26

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

open_house_start__c,2024-05-09T13:30:00.000+0000

original_price__c,1600000

overall_days_on_market__c,-81870

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,208.96

price_reduced__c,1

pba__propertytype__c,5 or More Unit

ListingId,a0EUd000001HchpMAC

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

size__c,6700

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Lyon

subdist__c,North Panhandle

ffd_name,403 Lyon Street, San Francisco, CA, 94117

website_property_type__c,5 or More Unit

pba__yearbuilt_pb__c,1905

pba__postalcode_pb__c,94117

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1715252427

ffd_listing_title,2198 Fell Street #2, San Francisco, CA, 94117

ffd_mls_id,424029962

ffd_salesforce_id,a0EUd000001vF1nMAE

num_of_fireplaces__c,1

num_of_rooms__c,8

of_units__c,6

address2__c,2198 Fell Street #2, San Francisco, CA, 94117

pba__address_pb__c,2198 Fell Street #2, San Francisco, CA, 94117

agent_only_remarks__c,- OFFER DATE: Wed 5/15/2024 10:00 AM. Please submit email offers to [email protected] . Text Eric Johnson to confirm that your offer was received. - PRE ESCROW: Chicago Title - Gerrie Brindley; 415.252.2746; [email protected]

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

architectural_style__c,Contemporary

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,3

year_build_text__c,2000

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-05-03T18:47:39.000+0000

days_on_market__c,6

dom__c,6

ffd_description_pb,A MASSIVE private backyard with your very own whirlpool/hot-tub is just one of the many features of this incredible home. Live your best life in this beautifully designed 2 story condominium residence which opens directly onto your own private backyard with 5-person outdoor whirlpool spa. Located directly across the street from the world famous Golden Gate Park, this spacious home has it all... style, entertaining space, and an abundance of light. 3 bedrooms, 3 bathrooms, 1 office/flex room, 1 car parking, in unit laundry, hardwood floors throughout, new kitchen appliances, 2 storage areas, and a shared common-area roof deck. There are a total of 6 condos in this building. Imagine coming home from a long day, going across the street for a run in Golden Gate park, and then coming home to luxuriate in your very own private outdoor spa/whirlpool! This property is one of a kind, and a MUST SEE.

district__c,SF District 6

entry_level__c,0

external_listing__c,1

fireplace_features__c,Gas Log

pba__floortype_pb__c,Wood

pba__hoafees__c,808

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,0

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

pba__latitude_pb__c,37.772221

pba__latitude_property__c,37.772221

laundry_features__c,Washer/Dryer Stacked Included

listed_date__c,2024-05-03

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Eric

pba__listing_agent_lastname__c,Johnson

listing_agent_mls_id__c,805920

ffd_listingagentname,Eric M Johnson

listing_agent_number__c,166016005

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.453945

lower_level__c,Primary Bedroom

mls_id__c,424029962

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

master_property__c,a0O8W00000H5tlBUAR

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

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:30:00.000+0000

original_price__c,1499000

overall_days_on_market__c,-81937

parking_access__c,Side by Side

parking_features__c,Covered,Enclosed,Garage Door Opener,Interior Access,Private,Side-by-Side

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001vF1nMAE

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

size__c,1559

spa__c,1

pba__state_pb__c,CA

stories__c,2

pba__street_pb__c,Fell

subdist__c,North Panhandle

ffd_name,2198 Fell Street #2, San Francisco, CA, 94117

website_property_type__c,Condominium

pba__yearbuilt_pb__c,2000

pba__postalcode_pb__c,94117

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1715252420

ffd_listing_title,1851 Hayes Street, San Francisco, CA, 94117

ffd_mls_id,424026350

ffd_salesforce_id,a0EUd000001urPFMAY

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,2

address2__c,1851 Hayes Street, San Francisco, CA, 94117

pba__address_pb__c,1851 Hayes Street, San Francisco, CA, 94117

agent_only_remarks__c,Dues paid annually ($2K/yr). Sellers motivated. Offers as they come. Call or text for Qs. On iSupra: Text, then go & show. Disc. Pkg: https://app.disclosures.io/link/1851-Hayes-Street-5az7zv3a

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

bath_features__c,Shower Stall(s);Tile

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1909

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

dom__c,6

ffd_description_pb,Centrally nestled just north of The Panhandle, is a tastefully updated 2 bed, 1 bath condominium that accentuates contentment and accessibility. The unit evokes balance with a full living room, formal dining room and spacious kitchen that seamlessly thread together. Speaking of the kitchen, storage cabinets and counter space abound to satisfy a wide range of culinary needs. What's more, a convenient laundry room sits off the kitchen, with stair access to the garage. Two generously sized bedrooms don the rear of the unit, with large windows facing south, that will enjoy horizontal sunlight and the jasmine/rosemary scented backyard. If that wasn't enough, an additional bonus room offers flexibility like a home gym or office. Living in NoPa puts you steps away from cafes, restaurants, grocery stores, and warm greenery. Public transportation can take you in any direction to visit other corners of the city. See this opportunity for yourself.

district__c,SF District 6

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Trash,Water

pba__hoafees__c,2000

pba__hoafrequency_pb__c,Annually

hoa__c,Yes

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

pba__heatingtype_pb__c,Central

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

pba__latitude_pb__c,37.773613

pba__latitude_property__c,37.773613

laundry_features__c,Inside Area;Washer Included;Dryer Included;Cabinets

listed_date__c,2024-04-21

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Raymond

pba__listing_agent_lastname__c,Solis

listing_agent_mls_id__c,810567

ffd_listingagentname,Raymond Solis

listing_agent_number__c,1047041

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,SAGERE

listing_office_name__c,Sage Real Estate

listing_office_number__c,28708

pba__listingprice_pb__c,1299000

pba__listingtype__c,Sale

pba__listing_website__c,https://my.matterport.com/show/?m=u5pFefSqWCc&brand=0&mls=1&

pba__longitude_pb__c,-122.446951

mls_id__c,424026350

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

master_property__c,a0O8W00000JaMZpUAN

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

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

overall_days_on_market__c,-81937

parking_access__c,Independent

parking_features__c,Attached,Covered,Enclosed,Garage Door Opener,Interior Access

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

pba__propertytype__c,Condominium

ListingId,a0EUd000001urPFMAY

room_type__c,Storage;Bonus Room;Laundry;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,1236

size__c,1236

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Hayes

subdist__c,North Panhandle

ffd_name,1851 Hayes Street, San Francisco, CA, 94117

website_property_type__c,Condominium

window_features__c,Dual Pane Partial

pba__yearbuilt_pb__c,1909

pba__postalcode_pb__c,94117

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1714647620

ffd_listing_title,211 Cole Street, San Francisco, CA, 94117

ffd_mls_id,424023998

ffd_salesforce_id,a0EUd000001jXQgMAM

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,2

address2__c,211 Cole Street, San Francisco, CA, 94117

pba__address_pb__c,211 Cole Street, San Francisco, CA, 94117

agent_only_remarks__c,2 unit bldg, fast track condo conversion. Unit 209 and 211 Cole need to close simultaneously for group loan to be paid off, new owners to obtain their own fractional financing. Escrow open with Michael Yip, Chicago Title. Unwarranted in-law. HOA dues handled informally between two owners. Contact Jenn for disclosures and offer date.

architectural_style__c,Edwardian

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1906

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-14T14:46:38.000+0000

days_on_market__c,18

dom__c,18

ffd_description_pb,Experience elegance in this expansive top-floor 2BR plus den, 1BA flat, beautifully appointed with softwood floors and classic architectural details. The interior features built-in cabinets, wainscoting, 2 fireplaces, and boxwood ceilings, enhancing the charm of each space. The flexible floor plan includes graciously scaled bedrooms and a versatile fainting room that can serve as a den or office. A spacious kitchen opens to a formal dining room, ideal for entertaining and gatherings. The large laundry area offers additional space that can also function as an office, providing flexibility and practicality to your living arrangement. Includes separate bonus room, a garage workshop, 1 car side-by-side parking. Shared garden. 2-unit building, fast track for condo conversion. Offering the very best NOPA lifestyle and urban living just blocks from the vibrant Divisadero corridor, some of San Francisco's best parks, Golden Gate Park, Panhandle, Buena Vista, Alamo Square, Trader Joe's, the USF campus, and transportation.

district__c,SF District 6

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

interior_features__c,Skylight(s)

ffd_lastmodifieddate,2024-05-02T10:47:00.000+0000

pba__latitude_pb__c,37.773019

pba__latitude_property__c,37.773019

laundry_features__c,Inside Area;Washer Included;Dryer Included

listed_date__c,2023-11-17

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jennifer

pba__listing_agent_lastname__c,Davis

listing_agent_mls_id__c,803209

ffd_listingagentname,Jenn Davis

listing_agent_number__c,803209

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,SRNO04

listing_office_name__c,Christie's Int'l Real Estate

listing_office_number__c,29064

pba__listingprice_pb__c,1495000

pba__listingtype__c,Sale

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

pba__longitude_pb__c,-122.451221

mls_id__c,424023998

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

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-14

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

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

original_price__c,1495000

overall_days_on_market__c,-81918

parking_access__c,Side by Side

parking_features__c,Side-by-Side

parking_type__c,Other

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,Tenancy In Common

ListingId,a0EUd000001jXQgMAM

roof__c,Foam

room_type__c,Bonus Room;Den;Kitchen;In Law Apartment;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,0

size__c,0

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Cole

subdist__c,North Panhandle

ffd_name,211 Cole Street, San Francisco, CA, 94117

website_property_type__c,Tenancy In Common

pba__yearbuilt_pb__c,1906

pba__postalcode_pb__c,94117

ffd_media,Array

ffd_media_tags,Array

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