meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='323599' 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] => 2018-10-29 19:47:38
[post_modified_gmt] => 2018-10-29 19:47:38
[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 2240 Judah 2242 Street, San Francisco, CA, 94122
ffd_mls_id 423716698
ffd_salesforce_id a0E8W00000a7oQIUAY
num_of_fireplaces__c 0
num_of_rooms__c 0
of_units__c 0
address2__c 2240 Judah 2242 Street, San Francisco, CA, 94122
pba__address_pb__c 2240 Judah 2242 Street, San Francisco, CA, 94122
agent_only_remarks__c Supra installed. Door code for each unit 123456# Disclosure package https://app.disclosures.io/link/2240-Judah-Street-2242-yvyv3crm Down to stud renovation work was done with permit and finaled with certificate of occupancy. Show and sell. Escrow opened with Jennifer Bratko (Jennifer.Bratko@fnf.com ) with Fidelity Title. Call or text Jenny 6502886600 with questions. Offer Date TBD
appliances__c Microwave;Disposal;Free Standing Gas Oven
architectural_style__c Mid-Century
bath_features__c Tub w/Shower Over;Low-Flow Toilet(s);Window
pba__fullbathrooms_pb__c 5
pba__bedrooms_pb__c 6
year_build_text__c 1945
pba__city_pb__c San Francisco
pba__contingentdate__c 1800-01-01
cooling__c None
ffd_createddate 2023-01-20T20:45:58.000+0000
days_on_market__c 9
dom__c 8
ffd_description_pb Welcome to Sunset Luxury Home! Two 3b2b flats with laundry in each unit, and two car side-by-side garage (with EV charging), plus bonus room in lower level with full bath which is perfect for WFH. Property underwent extensive down-to-stud renovation with permits. Unique open floorplan give this house plenty of natural sunlight with practicality and style. Kitchen in each unit is equipped with brand new high-end stainless appliances, quartz counter top with high-end plumbing and light fixtures. Recessed lights in all living room. Backdeck with access to low-maintenance backyard from each unit. Bathrooms are designed with motion sensor lights, simple and clean style. 2 water meters, 2 gas meters and 3 electric meters. Available asTIC . This property is perfect for owner live in and rent one unit out or share with family members, also perfect for investors keep it as rental property with its excellent condition and great income potential! Come enjoy modern city lifestyle with the convenience of its premium location! Claim it yours before it's gone!
district__c SF District 2
electric__c 220 Volts
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
interior_features__c Skylight(s);Storage Area(s)
ffd_lastmodifieddate 2023-01-28T11:47:29.000+0000
pba__latitude_pb__c 37.761503
pba__latitude_property__c 37.761503
laundry_features__c Inside Room;Laundry Closet;Washer/Dryer Stacked Included
listed_date__c 2023-01-20
pba__listing_agent_email__c jwbayareahomes@gmail.com
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 2195000
pba__listingtype__c Sale
pba__listing_website__c https://my.matterport.com/show/?m=iyRvJtULTX5
pba__longitude_pb__c -122.486292
lower_level__c Garage,Retreat
mls_id__c 423716698
main_level__c Full Bath(s);Bedroom(s);Kitchen;Family Room;Primary Bedroom
master_bathroom_features__c Shower Stall(s)
monthly_parking_fees__c 0
monthlyrent__c 0
parkingspaces__c 2
on_market_date__c 2023-01-20
open_house_end__c 2023-01-28T15:00:00.000+0000
open_house_start__c 2023-01-28T11:00:00.000+0000
original_price__c 2195000
overall_days_on_market__c -81468
parking_access__c Side by Side
parking_features__c Attached,Garage Door Opener,Garage Facing Front
parking_type__c On Site (Single Family Only)
patio_and_porch_features__c Back Porch;Uncovered Deck
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 1058.34
pba__propertytype__c Single Family Residence
ListingId a0E8W00000a7oQIUAY
roof__c Bitumen;Shingle
room_type__c Storage;In Law Apartment;Primary Bedroom
sale_date__c 1800-01-01
sale_price__c 0
security_features__c Smoke Detector;Carbon Mon Detector;Double Strapped Water Heater
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 2074
size__c 2074
pba__state_pb__c CA
stories__c 0
pba__street_pb__c Judah
subdist__c Central Sunset
ffd_name 2240 Judah 2242 Street, San Francisco, CA, 94122
view__c City;San Francisco
website_property_type__c Single Family Home
window_features__c Dual Pane Full;Bay Window(s)
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/530570889-1.jpg