meta_query='key:subdist__c;value:Parkside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215098' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70657
[post_author] => 4
[post_date] => 2018-11-30 20:30:31
[post_date_gmt] => 2018-11-30 20:30:31
[post_content] => Proximity to parks, room to roam, and the Pacific Ocean at your front door. Downtown is a quick (and probably crowded) L-Taraval ride away, and car commuters can hop on 19th Avenue to head south. Like its northern twin the Sunset, there’s more fog than on the east side of town, but that keeps things cool and comfy.
[post_title] => Parkside
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => parkside
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-11 08:39:13
[post_modified_gmt] => 2024-04-11 15:39:13
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70657
[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, 2450 29th Avenue, San Francisco, CA, 94116
ffd_mls_id, 506945
ffd_salesforce_id, a0E1I00000THoVGUA1
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 2450 29th Avenue, San Francisco, CA, 94116
pba__address_pb__c, 2450 29th Avenue, San Francisco, CA, 94116
agent_only_remarks__c, Sq. ft. includes improved rooms down which are not warranted as living space. Offers due on Friday, Oct. 2nd by 12pm. Please use SFAR purchase contract. Disclosures.IO link: https://app.disclosures.io/link/2450-29th-Avenue-rfuohgc9. Contact listing agent for offer date. Pre-escrow opened with Joy Fogarty, First American Title, [email protected], escrow #6364038
appliances__c, Dishwasher;Gas Range;Refrigerator;Hood Over Range
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1940
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-10-02
ffd_createddate, 2020-09-25T22:46:42.000+0000
days_on_market__c, 1027
dom__c, 25
ffd_description_pb, Incredible opportunity to own this beautiful 3bd/2ba home w/bonus rooms, 4 car garage, your own backyard putting green! Formal entryway w/parquet floors, stunning LR w/recessed ceiling, center gas fireplace, separate FDR overlooks side patio w/custom mural. Quaint breakfast room streams w/natural light, chef's kitchen features custom wood cabinets, impressive Wolf range, ample counter space w/tile backsplash. The main en-suite bedroom has French doors that open to deck w/access to private spacious full bath. Two addt'l bedrooms off hallway w/custom Venetian plaster & split bath off hall w/rustic Turkish travertine. LL has a perfect setup for home ofc/guest room/family room and 3rd bath w/European style shower. Large laundry room w/abundance of cabinet & counter space. Incredible open garage features up to 4 car pkg or potential expansion for your personal needs. Enjoy backyard gatherings on deck leading to your own putting green. 1/2 block to Metro, Taraval St. specialty shops.
district__c, SF District 2
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Parquet
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T15:35:53.000+0000
pba__latitude_pb__c, 37.7416233
pba__latitude_property__c, 37.7416233
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2020-09-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Paul
pba__listing_agent_lastname__c, Barbagelata
listing_agent_mls_id__c, 342615
ffd_listingagentname, Paul Barbagelata
listing_agent_number__c, 342615
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BARBCO
listing_office_name__c, BarbCo
listing_office_number__c, 28297
pba__listingprice_pb__c, 1595000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4860575
pba__lotsize_pb__c, 0.07
lower_level__c, Full Bath(s)
mls_id__c, 506945
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 4
on_market_date__c, 2020-09-25
original_price__c, 1595000
overall_days_on_market__c, 100
parking__c, Garage,Auto Door,Interior Access
parking_features__c, Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-10-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 783.93
pba__propertytype__c, Single Family Residence
id, a0E1I00000THoVGUA1
room_type__c, Office;Laundry
sale_date__c, 2020-11-16
sale_price__c, 1825000
selling_agent_mls_id__c, 811411
selling_agent_name__c, Cara Mia Lembi
selling_agent_number__c, 1051470
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 2328
size__c, 2328
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 29th
subdist__c, Parkside
ffd_name, 2450 29th Avenue, San Francisco, CA, 94116
transportation__c, 1 Block
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1940
pba__postalcode_pb__c, 94116
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371079-1.jpg
ListingId, a0E1I00000THoVGUA1