meta_query='key:subdist__c;value:Duboce Triangle|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210911' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15098
[post_author] => 4
[post_date] => 2018-10-31 18:22:48
[post_date_gmt] => 2018-10-31 18:22:48
[post_content] => Just north of the Castro and south of the Lower Haight, Duboce Triangle is a bustling neighborhood that’s got something for almost everyone: Duboce Park for families with kids and/or dogs, easy transit options for commuters, tree-lined streets for pedestrians, and plenty of shopping, eating and drinking options for everyone.
Nearby: Mission Dolores, The Castro, Hayes Valley, Corona Heights
[post_title] => Duboce Triangle
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => duboce-triangle
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 12:49:47
[post_modified_gmt] => 2024-03-19 19:49:47
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15098
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 210 Noe 212 Street, San Francisco, CA, 94114
ffd_mls_id, 504318
ffd_salesforce_id, a0E1I00000THmwzUAD
vacant__c, 2
num_of_rooms__c, 0
of_units__c, 2
address2__c, 210 Noe 212 Street, San Francisco, CA, 94114
pba__address_pb__c, 210 Noe 212 Street, San Francisco, CA, 94114
agent_only_remarks__c, Offers, if any, will be reviewed Wed, Oct 7 at 2pm. To schedule a viewing please book an appointment through Calendly (copy & paste link in browser): https://calendly.com/sfdwell/dubocedwell?month=2020-09 Private COVID-compliant showings only. Property website: www.DuboceDwell.com. Owner will sell entire building or each unit as TIC (no TIC agreement in place so Buyer has flexibility with which area to be allocated for each unit; Buyer to consult with TIC attorney). 210 Noe listed under MLS 504551. 212 Noe listed under MLS 504554. Deep backyard + large storage area in garage = expansion potential! Check w/city &/or local architect to determine expansion options. 3 car garage parking (2 tandem and other side-by-side). Buyer to verify if they have concerns about their vehicle(s) fitting.
appliances__c, Dishwasher;Disposal;Free Standing Refrigerator;Free Standing Oven/Range
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 4
year_build_text__c, 1905
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Christiane Gigas
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-09-23T10:49:26.000+0000
days_on_market__c, 1029
dom__c, 28
ffd_description_pb, Prime Duboce Triangle 2-unit building w/numerous options! OPTION 1: Create family compound w/ outdoor spaces; OPTION 2: Buy one of two TICs; OPTION 3: Purchase building, live in one unit & generate income from other. OUTDOOR SPACE?: YES! spacious garden w/redwood decks off both levels. LOCATION?: YES! prime Duboce Park on a tree-lined street; steps away from outdoor dining, farmer's market & parks. MOVE-IN READY?: YES! Enjoy updated finishes w/open kitchen/dining areas in both flats that open directly to decks. PERIOD DETAILS?: YES! seller meticulously restored fine trim work, ornate door hinges & original pocket doors...with high ceilings to boot. PARKING?: YES! spacious 3 car garage + storage. EXPANSION POTENTIAL?: YES! Potential to convert the large storage area in garage & other development options. Bring your architect to help realize the full potential. CONDO CONVERSION? POSSIBLE! Check with your TIC attorney. Don't miss out on this opportunity! See MLS 504551 and 504554.
district__c, SF District 5
est_total_expenses__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
gross_annual_income__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T13:31:47.000+0000
pba__latitude_pb__c, 37.765566
pba__latitude_property__c, 37.765566
laundry_features__c, In Common Area
listed_date__c, 2020-08-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Myrick
pba__listing_agent_lastname__c, Tantiado
listing_agent_mls_id__c, 807341
ffd_listingagentname, Myrick Tantiado
listing_agent_number__c, 1016143
listing_co_agent_mls_id__c, 804817
listing_co_agent_number__c, 166014506
listing_co_office_mls_id__c, STHB
listing_co_office_name__c, Sotheby's International Realty
listing_co_office_number__c, 2050
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 2395000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.dubocedwell.com/
pba__longitude_pb__c, -122.433561
pba__lotsize_pb__c, 0.06
mls_id__c, 504318
master_property__c, a0O8W00000DaF2yUAF
parkingspaces__c, 3
on_market_date__c, 2020-09-23
original_price__c, 2395000
overall_days_on_market__c, 254
parking__c, Garage
parking_features__c, Garage
patio_and_porch_features__c, Deck(s);Balcony/Deck
pba__pendingdate__c, 2020-10-21
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1004
pba__propertytype__c, Duplex
id, a0E1I00000THmwzUAD
sale_date__c, 2020-11-05
sale_price__c, 2510000
selling_agent_mls_id__c, 806789
selling_agent_name__c, Eric T. Rahe
selling_agent_number__c, 166017619
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 2500
size__c, 2500
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Noe
style__c, Edwardian
subdist__c, Duboce Triangle
ffd_name, 210 Noe 212 Street, San Francisco, CA, 94114
type__c, Duplex
website_property_type__c, Duplex
window_features__c, Dual Pane
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/368797-1.jpg
ListingId, a0E1I00000THmwzUAD