meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375658' 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-11-07 23:32:48
[post_modified_gmt] => 2024-11-08 07:32:48
[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
(
)
)
_yoast_indexnow_last_ping, 1735681131
ffd_listing_title, 1654 24th Avenue, San Francisco, CA, 94122
ffd_mls_id, 424015077
ffd_salesforce_id, a0EUd000001ReaKMAS
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 1654 24th Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1654 24th Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Offers due Wednesday 3/20/2024 by 2 pm. It's on supra lockbox, no appointments or additional unnecessary call/text notices needed! For disclosures please EMAIL (NOT TEXT) listing agent Jason Chan at [email protected]. Disclosure link will be emailed to you once it's ready. For questions, please text Jason at 415.215.1661. For lockbox issues or showing difficulties, please contact Julie Chan via email: [email protected] or via text: 415.672.7988. Email or text preferred. Please use San Francisco purchase agreement. Please include Contingency Removal form & signing off the cover page of the disclosure packet. Please tell your loan agent NOT TO CALL after your offer is submitted. I will contact them if it's necessary. Pre-sale escrow opened w/ WFG National Title Insurance Company with Kathie Ng. Seller reserves the right to accept, counter, or reject any offer.
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Marina
bath_features__c, Shower Stall(s);Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1927
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Julie Y Chan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-03-14T18:46:55.000+0000
days_on_market__c, 293
dom__c, 7
ffd_description_pb, Introducing this stunning Sunset residence, cherished by many generations of the same family! Ideally situated just short blocks away from Noriega & Irving Street's vibrant restaurants and shops, Judah Street MUNI lines, public transit on both Noriega & 19th Avenue, Sunset Recreation Center, and Sunset Reservoir, this home offers unparalleled convenience. The top floor of this charming Marina-style home boasts a barrel front living room with an original fireplace and a spacious formal dining room seamlessly integrated with an open kitchen with large skylight. Two bedrooms in the back side by side, a full bath, and a large deck off the bedrooms complete this level. Interior stairway off the long hallway leads to the ground level accessing a two-car garage with an additional legal bedroom & bath added over the decades. Completing this level is a substantial laundry room & a second spacious deck accessed either through the laundry room or the bedroom. Additionally, a separate side entrance provides access to the ground floor level, offering versatile living options. Discover the epitome of Sunset living in this remarkable home!
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-04-10T10:46:29.000+0000
pba__latitude_pb__c, 37.7567153
pba__latitude_property__c, 37.7567153
laundry_features__c, Ground Floor
listed_date__c, 2024-03-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jason
pba__listing_agent_lastname__c, Chan
listing_agent_mls_id__c, 802554
ffd_listingagentname, Jason C Chan
listing_agent_number__c, 802554
listing_co_agent_mls_id__c, 807828
listing_co_agent_number__c, 1027382
listing_co_office_mls_id__c, BARBCO
listing_co_office_name__c, BarbCo
listing_co_office_number__c, 28297
listing_office_mls_id__c, BARBCO
listing_office_name__c, BarbCo
listing_office_number__c, 28297
pba__listingprice_pb__c, 1195000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4817894
lower_level__c, Bedroom(s),Full Bath(s),Garage
mls_id__c, 424015077
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-03-13
original_price__c, 1195000
overall_days_on_market__c, -81886
parking_access__c, Tandem
parking_features__c, Interior Access,Tandem Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-03-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-09T14:02:44.000+0000
price_per_square_foot__c, 1106.08
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001ReaKMAS
sale_date__c, 2024-04-09
sale_price__c, 1710000
selling_agent_mls_id__c, 806945
selling_agent_number__c, 166017922
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1546
size__c, 1546
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 24th
subdist__c, Central Sunset
ffd_name, 1654 24th Avenue, San Francisco, CA, 94122
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1927
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530744785-1.jpg