meta_query='key:subdist__c;value:Lakeside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217700' 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] => 2024-04-09 12:09:54
[post_modified_gmt] => 2024-04-09 19:09:54
[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
(
)
)
ffd_listing_title, 2956 19th Avenue, San Francisco, CA, 94132
ffd_mls_id, 421528788
ffd_salesforce_id, a0E1I00000TwyBrUAJ
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 0
address2__c, 2956 19th Avenue, San Francisco, CA, 94132
pba__address_pb__c, 2956 19th Avenue, San Francisco, CA, 94132
agent_only_remarks__c, Great tenant downstairs paying $1,730mo, market rent, for approximately 393sq.ft studio with fireplace! Main house with 3bd/2ba/2-car s/s garage is vacant and never been rented out. The same owners since 1988! For upper level showing Call/text for Lockbox Code 415-609-4438. Rental studio is very easy to show with 24-hour notice, Monday-Thursday, 2:30pm-8pm. Special arrangements on Fridays and weekends. City record shows 2,512 sq.ft, 2013 Appraisal Report shows 2,578sq.ft. Buyers to verify house size and legality of studio downstairs to their own satisfaction. Escrow with Lawyers Title Co. Showing agent responsible for all COVID-19 protocols before, during and after showings.
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Oven;Free Standing Refrigerator
architectural_style__c, Spanish
bath_features__c, Shower Stall(s);Tile;Jetted Tub;Window
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1936
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-05-09
cooling__c, None
ffd_createddate, 2021-03-20T21:26:48.000+0000
days_on_market__c, 855
dom__c, 60
ffd_description_pb, Elegant 2,512sq.ft TRI-level detached Spanish Mediterranean Home in prestigious Lakeside Location offers 4bd/3ba w/an abundance of light, character & period details. Close proximity to Lakeside & West Portal Village shopping & dining, Stonestown Shopping Center, Lakeshore Plaza, Stern Grove, Schools, Library, Playground, Golf Course, Public Transit & 101/280 HWYs. Entry foyer leads to grand sunken LR w/open-beam high ceiling, tall window & dramatic fireplace. Formal DR adjacent to lrg remodeled/upgraded kitchen w/granite countertop, stainless-steel appliances, breakfast nook & access to deck & low maintenance backyard. 2nd level features 2 lrg bedrooms & remodeled bath w/jetted tub, stall shower, toilet w/washlet, stylish vanity & tiled walls/floors. Master suite w/adjacent office complete 3rd lvl. 4th bd/1ba w/frpl down. Newly painted in & out, refinished floors. 2-car s/s garage w/ample storage & laundry. Long driveway to park 2 cars. Private alley rear of house for access to garage
district__c, SF District 3
driveway_sidewalks__c, Paved Driveway
electric__c, 220 Volts in Kitchen,220 Volts in Laundry
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard;Wood
pba__floortype_pb__c, Linoleum;Tile;Wood;Parquet
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, Formal Entry;Storage Area(s);Open Beam Ceiling
ffd_lastmodifieddate, 2022-01-25T15:47:16.000+0000
pba__latitude_pb__c, 37.7333407
pba__latitude_property__c, 37.7333407
laundry_features__c, In Garage;Washer/Dryer Stacked Included;Stacked Only
listed_date__c, 2021-03-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tanya
pba__listing_agent_lastname__c, Reperyash
listing_agent_mls_id__c, 398114
ffd_listingagentname, Tanya Reperyash
listing_agent_number__c, 398114
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COLD03
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 875
pba__listingprice_pb__c, 1948888
pba__listingtype__c, Sale
pba__listing_website__c, https://urldefense.com/v3/__https://my.matterport.com/show/?m=yJtqBZqDJWo__;!!CHCva4lQ!TJFFBORHEeiocYYHVf6pbAGh5-_yvKjaYtKv7aKjW-0IffxHW1yfJbS0qEg5kZAPMuXu9w$
pba__longitude_pb__c, -122.474692
lower_level__c, Full Bath(s),Master Bedroom
mls_id__c, 421528788
main_level__c, Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Shower Stall(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-03-16
original_price__c, 1668000
overall_days_on_market__c, 184
parking_access__c, Independent
parking_features__c, Alley Access,Attached,Garage Door Opener,Garage Facing Rear,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-05-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 736.46
pba__propertytype__c, Single Family Residence
id, a0E1I00000TwyBrUAJ
road_surface_type__c, Asphalt,Paved
roof__c, Bitumen;Spanish Tile
room_type__c, Office;Kitchen;Master Bedrooms 2+;Living Room;Dining Room
sale_date__c, 2021-06-09
sale_price__c, 1850000
security_features__c, Smoke Detector;Carbon Mon Detector;Window Security Bars
selling_agent_mls_id__c, 808482
selling_agent_number__c, 1035858
selling_co_agent_mls_id__c, 812207
selling_co_agent_number__c, 1055536
selling_co_office_mls_id__c, KWRSF
selling_co_office_name__c, Keller Williams San Francisco
selling_co_office_number__c, 26158
selling_office_name__c, Keller Williams San Francisco
pba__status__c, Closed
pba__totalarea_pb__c, 2512
size__c, 2512
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, 19th
subdist__c, Lakeside
ffd_name, 2956 19th Avenue, San Francisco, CA, 94132
website_property_type__c, Single Family Home
window_features__c, Dual Pane Partial
pba__yearbuilt_pb__c, 1936
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530200251-1.jpg
ListingId, a0E1I00000TwyBrUAJ