meta_query='key:subdist__c;value:Lakeside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='345663' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 79032
[post_author] => 4
[post_date] => 2018-12-07 02:44:35
[post_date_gmt] => 2018-12-07 02:44:35
[post_content] => White-picket fences surround single-family homes surrounded by a freeway (CA-1/19th Ave.) and six-lane streets. Once upon a time, Lakeside was just a few sleepy homes. Then roads got built. You can visit the library, but if you want to go shopping you’ll need to head all the way north to the end of the neighborhood or across the street to Stonestown.
[post_title] => Lakeside
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => lakeside
[to_ping] =>
[pinged] =>
[post_modified] => 2023-10-31 09:31:25
[post_modified_gmt] => 2023-10-31 16:31:25
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=79032
[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, 1700136823
ffd_listing_title, 3838 19th Avenue, San Francisco, CA, 94132
ffd_mls_id, 423916331
ffd_salesforce_id, a0E8W00000dUSdVUAW
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 3838 19th Avenue, San Francisco, CA, 94132
pba__address_pb__c, 3838 19th Avenue, San Francisco, CA, 94132
agent_only_remarks__c, Easy to show. Contact Abigail (415) 407-0701 or [email protected]. Pre-escrow open with Janet Lee, Fidelity National Title #FSFM-1072300545. Disclosures linked to Disclosures.io Offers shall be reviewed on WED, 10/18/23 at 3pm. See offer instructions on Disclosures.io
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1941
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-10-18
ffd_createddate, 2023-10-13T01:48:33.000+0000
days_on_market__c, 35
dom__c, 11
ffd_description_pb, Beautiful, split-level 3BR/2BA/2PKG detached home located in the desirable Lakeside neighborhood. Garage easily accessed from rear on Denslowe Dr. Offers an open floor plan, wonderful natural light, and is newly updated with fresh paint throughout, refinished hardwood floors and updated kitchen and baths. Kitchen includes a breakfast area that leads directly to a lovely patio and landscaped yard. Features a spacious living room with fireplace and formal dining room on the main floor. Upper level includes two spacious bedrooms and full bath with separate shower and tub. Bonus room down features an updated full bath with access to both garage and backyard. 1-car garage with additional off-street parking in the driveway, plus, ample street parking. Close to Stonestown, Whole Foods, SF State, Lake Merced and Ocean Beach. Easy freeway access. Welcome home!
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-11-16T11:48:06.000+0000
pba__latitude_pb__c, 37.719048
pba__latitude_property__c, 37.719048
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2023-08-30
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Abigail
pba__listing_agent_lastname__c, Picache
listing_agent_mls_id__c, 804125
ffd_listingagentname, Abigail R Picache
listing_agent_number__c, 166013580
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 998000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.3838-19th.com/
pba__longitude_pb__c, -122.473837
lower_level__c, Bedroom(s),Full Bath(s),Garage,Street Entrance
mls_id__c, 423916331
main_level__c, Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Shower Stall(s);Tub;Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-10-12
original_price__c, 998000
overall_days_on_market__c, -81733
parking_access__c, Independent
parking_features__c, Attached,Covered,Uncovered Parking Space
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-10-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-11-15T18:11:14.000+0000
price_per_square_foot__c, 793.24
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000dUSdVUAW
sale_date__c, 2023-11-15
sale_price__c, 1220000
selling_agent_mls_id__c, 804783
selling_agent_number__c, 166014461
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1538
size__c, 1538
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 19th
subdist__c, Lakeside
ffd_name, 3838 19th Avenue, San Francisco, CA, 94132
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1941
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530691880-1.jpg