meta_query='key:subdist__c;value:Glen Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='340154' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15605
[post_author] => 4
[post_date] => 2018-11-02 02:30:48
[post_date_gmt] => 2018-11-02 02:30:48
[post_content] => Once dismissed as 'south of Noe Valley,' Glen Park is now embraced and adored for an I-280 on-ramp to Silicon Valley and a BART station to everywhere else. Start your day with coffee at a not-a-corporate-copycat coffeehouse in the heart of the village, stroll on to the neighborhood public library branch and then off for a hike/jog/bike/climb through Glen Canyon Park? Yes you can in Glen Park.
[post_title] => Glen Park
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => glen-park-2
[to_ping] =>
[pinged] =>
[post_modified] => 2023-10-31 09:47:46
[post_modified_gmt] => 2023-10-31 16:47:46
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15605
[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, 1697281805
ffd_listing_title, 40 Lippard Avenue, San Francisco, CA, 94131
ffd_mls_id, 423911336
ffd_salesforce_id, a0E8W00000dThBtUAK
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 40 Lippard Avenue, San Francisco, CA, 94131
pba__address_pb__c, 40 Lippard Avenue, San Francisco, CA, 94131
agent_only_remarks__c, ** Offers September 29, 2023 at 9:00 am**There are no more showing requests accepted before Friday.** Seller has opened escrow and prefers it with Kelley Kish (415) 645-8020 at First American Title No:38076998529 because of Trust. 24 hour notice for appointments. Disclosure Package available soon. Seller reserves the right to accept and or reject any and or all offers.Standing artwork's in back yard are excluded from sale. www.46lippardave.com
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Farmhouse
bath_features__c, Tub w/Shower Over;Split Bath
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1925
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-09-22T22:47:30.000+0000
days_on_market__c, 22
dom__c, 10
ffd_description_pb, This magical oasis in Glen Park is a San Francisco sanctuary. This farm style home is located on a double plus-sized lot. Formal living room with fireplace, formal dining room Two bedroom/one bath and lower level bonus rooms with one bath and laundry area. Chef's kitchen with all the amenities and a Custom Heath Tile wall. Award winning garden with hand stacked stone waterfall. Multiple entertaining areas with a outdoor kitchen area with sink, storage, range, grill, smoker and pizza oven. Additional cottage area with gas fire pit and two car carport parking. While conveniently accessible to all the city's wonderful offerings, this spectacular property provides a generous lifestyle haven.
district__c, SF District 5
driveway_sidewalks__c, Gated,Gravel
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Fenced
pba__floortype_pb__c, Other;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
ffd_lastmodifieddate, 2023-10-14T10:48:42.000+0000
pba__latitude_pb__c, 37.7349603
pba__latitude_property__c, 37.7349603
laundry_features__c, In Basement;Washer Included;Dryer Included
listed_date__c, 2023-06-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Marc
pba__listing_agent_lastname__c, Calderon
listing_agent_mls_id__c, 229218
ffd_listingagentname, Marc C Calderon
listing_agent_number__c, 229218
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 1995000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.46lippardave.com
pba__longitude_pb__c, -122.435677
lower_level__c, Full Bath(s),Kitchen,Street Entrance
mls_id__c, 423911336
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-09-22
original_price__c, 1995000
overall_days_on_market__c, -81713
parking_access__c, Tandem
parking_features__c, Garage Facing Side
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-10-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-10-13T14:00:21.000+0000
price_per_square_foot__c, 1600.47
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000dThBtUAK
roof__c, Bitumen;Composition
room_type__c, Bonus Room;Kitchen;Living Room;Dining Room;Attic
sale_date__c, 2023-10-13
sale_price__c, 2700000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector;Security System Prewired
selling_agent_mls_id__c, 808098
selling_agent_number__c, 1030746
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Mosaik Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1687
size__c, 1687
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Lippard
subdist__c, Glen Park
ffd_name, 40 Lippard Avenue, San Francisco, CA, 94131
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1925
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530681768-1.jpg