meta_query='key:subdist__c;value:Duboce Triangle|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='238601' 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] => 2022-11-10 07:20:00
[post_modified_gmt] => 2022-11-10 15:20:00
[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, 2238 Market Street #204, San Francisco, CA, 94114
ffd_mls_id, 422699312
ffd_salesforce_id, a0E8W00000ZKY4kUAH
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 42
address2__c, 2238 Market Street #204, San Francisco, CA, 94114
pba__address_pb__c, 2238 Market Street #204, San Francisco, CA, 94114
agent_only_remarks__c, Limited-Time Rate Lock Plan Available Now. Lock In a 4.875% 7 Year Fixed Interest Rate Today. Contact Sales Office to schedule a showing.
appliances__c, Hood Over Range;Ice Maker;Built-In Refrigerator;Gas Cook Top;Built-In Electric Oven
architectural_style__c, Mediterranean
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2022-10-01T22:45:59.000+0000
days_on_market__c, 88
dom__c, 69
ffd_description_pb, Pricing adjustment on 2238 Market Street #204! This unique 2 Bedroom, 2 Bath home seamlessly blends the historic Spanish Colonial architecture with modern urban design. Features include separate dining and living areas with vaulted ceilings. The original style arched windows grace the bright southern exposure. The open kitchen is outfitted in Bosch appliances with floor-to-ceiling cabinets providing an abundance of storage. The primary bedroom features arched windows, dual closets, a spa-like contemporary bathroom with oversized walk-in shower and floating dual-vanity. A serene second bedroom with walk-in closet, a full second bathroom, washer dryer and a private garage parking space complete this rare city home. Note: Photos are of model homes and may vary from of the actual home for sale.
district__c, SF District 5
entry_level__c, 0
exterior_features__c, Entry Gate;BBQ Built-In
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Common Areas,Elevator,Gas,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Trash
pba__hoafees__c, 794
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-12-10T03:45:31.000+0000
pba__latitude_pb__c, 37.765462
pba__latitude_property__c, 37.765462
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2022-10-01
pba__listing_agent_email__c, gfrakes@polarispacific.com
pba__listing_agent_firstname__c, Garrett
pba__listing_agent_lastname__c, Frakes
listing_agent_mls_id__c, 805198
ffd_listingagentname, Garrett R Frakes
listing_agent_number__c, 802436
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, POGR
listing_office_name__c, Polaris Pacific
listing_office_number__c, 166013106
pba__listingprice_pb__c, 1398000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=944g9DcfDDP
pba__longitude_pb__c, -122.432267
mls_id__c, 422699312
master_bathroom_features__c, Shower Stall(s);Double Sinks
master_property__c, a0O8W00000EWzRRUA1
monthly_parking_fees__c, 90
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-10-01
original_price__c, 1595000
overall_days_on_market__c, -81357
parking_access__c, Side by Side
parking_features__c, Enclosed,Underground Parking
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, 1154.42
pba__propertytype__c, Condominium
ListingId, a0E8W00000ZKY4kUAH
roof__c, Spanish Tile
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, 1211
size__c, 1211
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Market
subdist__c, Duboce Triangle
ffd_name, 2238 Market Street #204, San Francisco, CA, 94114
view__c, City Lights
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530536992-1.jpg