meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375794' 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, 1735681075
ffd_listing_title, 1335 28th Avenue, San Francisco, CA, 94122
ffd_mls_id, 424013755
ffd_salesforce_id, a0EUd000001N6IgMAK
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 1335 28th Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1335 28th Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Offers due Wednesday 3/13/2024 by 2 p.m. 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, Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1924
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Julie Y Chan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-03-07T03:47:15.000+0000
days_on_market__c, 300
dom__c, 7
ffd_description_pb, Welcome to the heart of the Central Sunset, where convenience meets comfort in this updated home just steps from N-Judah MUNI lines, Judah Street, Irving Street shops and eateries, Golden Gate Park, UCSF, and Ocean Beach. This stunning residence boasts a barrel-front living room with a cozy fireplace, seamlessly flowing into a formal dining with an open updated kitchen & breakfast area on the top level. Two bedrooms and a full bath complete this floor. Descend the interior stairway to discover the ground floor featuring a wet bar, family room, bedroom, and full bath (unwarranted), along with generous parking for one car and a separate storage room. A separate side entrance from street level provides convenient access to the ground floor space. Indulge in outdoor relaxation and entertainment in the well-manicured spacious yard, perfect for enjoying evenings in this coveted neighborhood. Experience the epitome of urban living with every convenience at your doorstep. Don't miss the opportunity to make this your forever home in one of San Francisco's favorite neighborhoods!
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
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-12T10:47:23.000+0000
pba__latitude_pb__c, 37.762446
pba__latitude_property__c, 37.762446
laundry_features__c, In Garage
listed_date__c, 2024-03-06
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, 1095000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4870064
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage,Street Entrance
mls_id__c, 424013755
main_level__c, Full Bath(s);Bedroom(s);Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-03-06
original_price__c, 1095000
overall_days_on_market__c, -81879
parking_access__c, Independent
parking_features__c, Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-03-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-11T20:46:25.000+0000
price_per_square_foot__c, 1270
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001N6IgMAK
sale_date__c, 2024-04-11
sale_price__c, 1651000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 812181
selling_agent_number__c, 1055354
selling_co_agent_mls_id__c, 803019
selling_co_agent_number__c, 803019
selling_co_office_mls_id__c, HELM
selling_co_office_name__c, Helm Real Estate
selling_co_office_number__c, 27303
selling_office_name__c, Helm Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1300
size__c, 1300
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 28th
subdist__c, Central Sunset
ffd_name, 1335 28th Avenue, San Francisco, CA, 94122
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1924
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530741008-1.jpg