meta_query='key:subdist__c;value:North Panhandle|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='328504' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15727
[post_author] => 4
[post_date] => 2018-11-02 19:54:51
[post_date_gmt] => 2018-11-02 19:54:51
[post_content] => Flat streets dotted with gingerbread Victorians and unashamedly modern interpretations of Edwardians run parallel to the panhandle of Golden Gate Park. It's all you love about Golden Gate Park, just a little more central.
[post_title] => North Panhandle
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => north-panhandle
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-02 19:54:51
[post_modified_gmt] => 2018-11-02 19:54:51
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15727
[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, 633 Broderick 635 Street, San Francisco, CA, 94117
ffd_mls_id, 423726958
ffd_salesforce_id, a0E8W00000bGEpFUAW
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 2
address2__c, 633 Broderick 635 Street, San Francisco, CA, 94117
pba__address_pb__c, 633 Broderick 635 Street, San Francisco, CA, 94117
agent_only_remarks__c, http://nopacondos.com Please contact Monica to show 415-902-9502 [email protected]
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Range;Built-In Refrigerator
architectural_style__c, Victorian;Modern/High Tech
bath_features__c, Shower Stall(s);Quartz
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 6
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-03-24T16:49:00.000+0000
days_on_market__c, 70
dom__c, 69
ffd_description_pb, New Renovated 2 Unit Condo Building! These newly beautifully renovated 3 bedroom, 2 bathroom condos in the North Panhandle neighborhood have undergone a complete transformation. High Ceilings over 10.5 feet. Construction by the outstanding team of Cairn Construction. NEW foundation, sewer, electric, heating system, roof, windows, Ring camera system, and sound proofing provide peace of mind knowing that these condos are built to modern standards.The engineered wide plank European oak floors adds a touch of elegance and warmth to the space, while the Thermador kitchen appliances and quartz countertops provide both functionality and style. The Whirlpool washer and dryer is a great convenience, making laundry day a breeze. The custom-built kitchen and living room are perfect for entertaining. The decks off the kitchens overlook the lovely shared garden. The bathrooms have stall showers, vanities with beautiful quartz counters and mosaic tile floor. It also includes 2-car parking for the upper unit (635) & 1 car parking for unit (633) with EV charger and a large deed separate storage area for each unit.
district__c, SF District 6
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Fenced
pba__floortype_pb__c, Simulated Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2023-06-02T00:48:38.000+0000
pba__latitude_pb__c, 37.776142
pba__latitude_property__c, 37.776142
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included;Washer Included;Dryer Included
listed_date__c, 2023-02-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Monica
pba__listing_agent_lastname__c, Pauli
listing_agent_mls_id__c, 802345
ffd_listingagentname, Monica M Pauli
listing_agent_number__c, 802345
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 4890000
pba__listingtype__c, Sale
pba__listing_website__c, http://nopacondos.com
pba__longitude_pb__c, -122.440036
mls_id__c, 423726958
master_bathroom_features__c, Shower Stall(s);Quartz
master_property__c, a0O8W00000Hv6IaUAJ
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2023-03-24
open_house_end__c, 2023-06-03T15:00:00.000+0000
open_house_start__c, 2023-06-03T13:00:00.000+0000
original_price__c, 4890000
overall_days_on_market__c, -81531
parking_access__c, Side by Side
parking_features__c, Attached,Enclosed,EV Charging,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, 0
pba__propertytype__c, Condominium
ListingId, a0E8W00000bGEpFUAW
roof__c, Shingle
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector;Video System
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, Broderick
subdist__c, North Panhandle
ffd_name, 633 Broderick 635 Street, San Francisco, CA, 94117
view__c, City;City Lights
website_property_type__c, Condominium
window_features__c, Dual Pane Full;Bay Window(s)
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530593664-1.jpg