meta_query='key:subdist__c;value:Duboce Triangle|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='236981' 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, 2235 15th Street, San Francisco, CA, 94114
ffd_mls_id, 422670297
ffd_salesforce_id, a0E8W00000XidbGUAR
num_of_fireplaces__c, 2
num_of_rooms__c, 8
of_units__c, 0
address2__c, 2235 15th Street, San Francisco, CA, 94114
pba__address_pb__c, 2235 15th Street, San Francisco, CA, 94114
agent_only_remarks__c, Offers, if any are due Saturday, June 25th, by 12-noon. Please submit offers via HomeLight Listing Management. If you have any issues with submitting it on HomeLight please email them to [email protected] and copy my team member, Hollis, at [email protected]
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Range;Wine Refrigerator;Double Oven
architectural_style__c, Victorian;Traditional
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-06-16T22:48:37.000+0000
days_on_market__c, 398
dom__c, 10
ffd_description_pb, Welcome home to this undeniably charming and magical 3BR/2BA Victorian home situated on a tranquil tree-lined street in the prized neighborhood of Duboce Triangle. Upon entering, you will be welcomed into a spacious foyer, which leads to the double parlor- a formal living room with a fireplace and bay windows plus a light-filled formal dining room. The eat-in kitchen opens up to a large sitting area and looks out to a deck which leads to a large, private garden with mature fruit trees and a hot tub. 2 bedrooms, a remodeled full bathroom and an office nook are also on this level. The garden level features a master suite complete with a fireplace, walk-in closet and full bathroom with double sinks. Off the laundry room is the spacious garage with plenty of space for storage. Adding to the allure of this outstanding property is its close proximity to Duboce Park, The Castro, Market Street and the vibrant shops and restaurants on the Divis corridor.
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Fireplace(s)
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2023-07-13T17:14:17.000+0000
pba__latitude_pb__c, 37.765638
pba__latitude_property__c, 37.765638
laundry_features__c, Ground Floor;Washer Included;Dryer Included
listed_date__c, 2022-06-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mary Lou
pba__listing_agent_lastname__c, Castellanos
listing_agent_mls_id__c, 301994
ffd_listingagentname, Mary Castellanos
listing_agent_number__c, 301994
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, 2295000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4340621
lower_level__c, Garage,Primary Bedroom,Retreat
mls_id__c, 422670297
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Shower Stall(s);Double Sinks;Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-06-16
original_price__c, 2295000
overall_days_on_market__c, -81250
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio;Covered Patio
pba__pendingdate__c, 2022-06-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1306.71
pba__propertytype__c, Single Family Residence
record_id, a0E8W00000XidbGUAR
sale_date__c, 2022-07-12
sale_price__c, 2650000
security_features__c, Carbon Mon Detector;Security System Owned
selling_agent_mls_id__c, 814097
selling_agent_number__c, 1064305
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Kinoko
pba__status__c, Closed
pba__totalarea_pb__c, 2028
size__c, 2028
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 15th
subdist__c, Duboce Triangle
ffd_name, 2235 15th Street, San Francisco, CA, 94114
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530479681-1.jpg
ListingId, a0E8W00000XidbGUAR