meta_query='key:subdist__c;value:Inner Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='339314' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12159
[post_author] => 4
[post_date] => 2018-10-30 00:24:04
[post_date_gmt] => 2018-10-30 00:24:04
[post_content] => On the foggy side but not too far. With tongue in cheek, call it Outer Cole Valley if you really can’t stomach life west of Arguello. Classic Edwardians, modern transit, Golden Gate Park adjacent.
[post_title] => Inner Sunset
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => inner-sunset
[to_ping] =>
[pinged] =>
[post_modified] => 2023-10-31 09:06:35
[post_modified_gmt] => 2023-10-31 16:06:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12159
[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, 535 Judah Street, San Francisco, CA, 94122
ffd_mls_id, 423900168
ffd_salesforce_id, a0E8W00000cpeslUAA
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 535 Judah Street, San Francisco, CA, 94122
pba__address_pb__c, 535 Judah Street, San Francisco, CA, 94122
agent_only_remarks__c, Offers to be reviewed Tues. 9/5 at 5pm. Lower unit unwarranted by seller or listing agent. Listed sq ft based on Matterport floor plan. Buyer to verify. Upper level vacant, show anytime via supra. Lower level tenant occupied, 24 hr notice required to show. Link to disclosures: https://app.disclosures.io/link/535-Judah-Street-uhge041p For questions, please contact listing agent, Stacy Chui - [email protected]/415-710-8122.
appliances__c, Gas Water Heater;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Tile;Window
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, 2023-08-26T02:52:08.000+0000
days_on_market__c, 55
dom__c, 15
ffd_description_pb, Charming 2-bedroom, 1.5-bath home, nestled in the highly sought-after Inner Sunset District. Property features fresh interior and exterior paint, newly refinished hardwood floors and updated kitchen and bath. The main level features living room with wood-burning fireplace framed by intricate rose stained glass windows. The adjoining dining room showcases built-in cabinet space with stained glass accents. The main level also boasts a conveniently located half bath and a laundry room, enhancing practicality. The upper level reveals two generously sized bedrooms, each equipped with dual closets. A versatile sunroom on this floor offers endless possibilities - a peaceful home office or creative playroom. Occupied in-law unit downstairs offers supplemental income. Close proximity to local shops, restaurants and Golden Gate Park.
district__c, SF District 2
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-10-18T10:47:37.000+0000
pba__latitude_pb__c, 37.76186
pba__latitude_property__c, 37.76186
laundry_features__c, Hookups Only
listed_date__c, 2023-06-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Stacy
pba__listing_agent_lastname__c, Chui
listing_agent_mls_id__c, 807667
ffd_listingagentname, Stacy Y Chui
listing_agent_number__c, 1023588
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, SQRE
listing_office_name__c, Sequoia Real Estate
listing_office_number__c, 28627
pba__listingprice_pb__c, 1480000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.46788
lower_level__c, Garage
mls_id__c, 423900168
main_level__c, Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-08-24
original_price__c, 1480000
overall_days_on_market__c, -81684
parking_access__c, Independent
parking_features__c, Enclosed,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-09-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 916.98
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cpeslUAA
room_type__c, Sun Room;Kitchen;In Law Apartment;Living Room;Dining Room;Primary Bedroom
sale_date__c, 2023-09-27
sale_price__c, 1480000
security_features__c, Carbon Mon Detector
selling_agent_mls_id__c, MLSL5093352
selling_agent_number__c, 981390884
selling_co_agent_mls_id__c, MLSL5091326
selling_co_agent_number__c, 981385977
selling_co_office_mls_id__c, EXPCA-1
selling_co_office_name__c, eXp Realty of California Inc
selling_co_office_number__c, 981053395
selling_office_name__c, eXp Realty of California Inc
pba__status__c, Closed
pba__totalarea_pb__c, 1614
size__c, 1614
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Judah
subdist__c, Inner Sunset
ffd_name, 535 Judah Street, San Francisco, CA, 94122
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1909
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530660852-1.jpg
_yoast_indexnow_last_ping, 1697628189