meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='330420' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12160
[post_author] => 4
[post_date] => 2018-10-29 19:47:38
[post_date_gmt] => 2018-10-29 19:47:38
[post_content] => Proximity to parks, room to roam in the bigger-than-some-SF-neighborhoods yards, and lots of great eateries and local haunts. Downtown is a quick (and probably crowded) N-Judah ride away, and car commuters can hop on 19th Avenue to head south. Yes, there’s more fog than on the east side of town, but that keeps things cool and comfy.
[post_title] => Central Sunset
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => central-sunset
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 12:20:19
[post_modified_gmt] => 2024-03-19 19:20:19
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12160
[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, 2242 Judah Street, San Francisco, CA, 94122
ffd_mls_id, 423723334
ffd_salesforce_id, a0E8W00000bEYO9UAO
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 2
address2__c, 2242 Judah Street, San Francisco, CA, 94122
pba__address_pb__c, 2242 Judah Street, San Francisco, CA, 94122
agent_only_remarks__c, Supra installed Go direct Door code for each unit 123456#. Offer date 3/15 at 11:00am. Will consider pre-emptive offers. Disclosure package https://app.disclosures.io/link/2240-Judah-Street-2242-yvyv3crm Down to stud renovation work was done with permit and finalled with certificate of occupancy. Show and sell. Seller will install shower door before COE. Escrow opened with Jennifer Bratko ([email protected] ) with Fidelity Title. Call or text Jenny 6502886600 with questions. TIC agreement is being drafted, 2240 has left side of the garage, 2242 unit has right side of the garage (w/ EV charger)+ bonus room. Units are separated metered. Your offer should be contingent of review of the TIC agreement.
appliances__c, Microwave;Disposal;Hood Over Range;Free Standing Gas Range
architectural_style__c, Mid-Century
bath_features__c, Shower Stall(s);Tub;Dual Flush Toilet
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1945
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-03-23
cooling__c, None
ffd_createddate, 2023-02-23T20:48:39.000+0000
days_on_market__c, 146
dom__c, 48
ffd_description_pb, Welcome to Sunset Luxury Penthouse Unit! 3b2b flats with laundry on the top floor. 1 deeded parking in a 2 car side-by-side garage (with EV charging), plus bonus room in lower level with full bath which is perfect for WFH. This home underwent extensive down-to-stud renovation with permits. Unique open floorplan give this house plenty of natural sunlight with practicality and style. Kitchen is equipped with brand new high-end stainless appliances, quartz counter top with high-end plumbing fixtures. Artistic light fixtures throughout, recessed lights in living room. Back deck with access to low-maintenance backyard. Bathrooms are designed with motion sensor lights, simple and clean style. Intercom system and keyless entry. This unit perfect for a small family that want all updated amenities, also an extra office/room for Work From Home. No monthly HOA due! Come enjoy modern city lifestyle with the convenience of its premium location! Claim it yours before it's gone! Unit 2240 is also being sold as TIC. Welcome to see both units when you visit!
district__c, SF District 2
driveway_sidewalks__c, Maintenance Agreement
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-13T18:27:34.000+0000
pba__latitude_pb__c, 37.761465
pba__latitude_property__c, 37.761465
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2023-02-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Lu
pba__listing_agent_lastname__c, Wang
listing_agent_mls_id__c, 816565
ffd_listingagentname, Jenny L Wang
listing_agent_number__c, 1075525
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP31
listing_office_name__c, Compass
listing_office_number__c, 27894
pba__listingprice_pb__c, 1150000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=iyRvJtULTX5
pba__longitude_pb__c, -122.486295
lower_level__c, Full Bath(s),Garage,Retreat,Street Entrance
mls_id__c, 423723334
main_level__c, Full Bath(s);Bedroom(s);Dining Room;Family Room;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Low-Flow Toilet(s);Dual Flush Toilet
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-02-23
original_price__c, 1200000
overall_days_on_market__c, -81502
parking_access__c, Side by Side
parking_features__c, Attached,EV Charging,Garage Door Opener
parking_type__c, On Site (Single Family Only);On Site - Assigned (Condo Only)
pba__pendingdate__c, 2023-04-12
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Tenancy In Common
ListingId, a0E8W00000bEYO9UAO
roof__c, Bitumen;Shingle
room_type__c, Storage;Office;Bonus Room;Kitchen;Living Room;Guest Quarters;Dining Room;Possible Guest;Primary Bathroom;Primary Bedroom
sale_date__c, 2023-04-25
sale_price__c, 1150000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 810704
selling_agent_number__c, 1047495
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, City Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Judah
subdist__c, Central Sunset
ffd_name, 2242 Judah Street, San Francisco, CA, 94122
website_property_type__c, Tenancy In Common
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1945
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530583364-1.jpg