meta_query='key:subdist__c;value:Parkside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210514' 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, 2475 23rd Avenue, San Francisco, CA, 94116
ffd_mls_id, 497156
ffd_salesforce_id, a0E1I00000Sm4bhUAB
num_of_fireplaces__c, 0
num_of_rooms__c, 8
of_units__c, 0
address2__c, 2475 23rd Avenue, San Francisco, CA, 94116
pba__address_pb__c, 2475 23rd Avenue, San Francisco, CA, 94116
agent_only_remarks__c, This property is vacant and on a Supra lockbox; however, please send PEAD form to listing agent ([email protected]) prior to showing. Please follow COVID-19 protocols for in person showings. No more than 2 clients at one time in the property, please wear gloves and masks. If your clients are unable to view the property in person, please call the listing agent (Joe Polyak) to make a video call appointment. Disclosures available: https://app.disclosures.io/link/2475-23rd-Avenue-zz710pg7. Please contact listing agent with any questions: Joe Polyak (415) 595-2647 or [email protected]. Note that measurements of a property tend to vary from source to source and often conflict. There is no official source or standard method of calculation. Buyer(s) and buyer agent(s) should perform their own investigation of number of rooms and sqft. measurements prior to entering into a contract. Buyer to cooperate with seller's 1031 deferred exchange at no cost of liabilities to buyers. Escrow opened with Karen Tam with Old Republic Title Company: [email protected] or (510)286-7705.
architectural_style__c, Marina
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1928
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-05-25T10:46:05.000+0000
days_on_market__c, 1148
dom__c, 0
ffd_description_pb, For Comp Sale Purposes Only...Located in the highly desirable Parkside neighborhood, this Marina style home opens up to 4-bedrooms, 2.5-bathrooms, and a large recreation room with a wet bar. Accented by a series of bow windows and fireplace, the stylish living room transcends to a separate dining room and foyer. The home offers hardwood flooring throughout into the bedrooms to allow for a seamless transition. This home has been meticulously maintained by the current owners. Low-maintenance landscaping compliments the quaint outdoor space, perfect for a patio set and fire pit. Use the attached garage or convenient street parking, it is an easy drive to San Francisco State University or the Stonestown Galleria. Enjoy a nice few blocks walk to different eateries, cafes, and grocery stores or take the light rail and bus throughout the city.
district__c, SF District 2
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
ffd_lastmodifieddate, 2022-01-12T15:30:39.000+0000
pba__latitude_pb__c, 37.74146
pba__latitude_property__c, 37.74146
listed_date__c, 2020-05-27
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Joseph
pba__listing_agent_lastname__c, Polyak
listing_agent_mls_id__c, 814792
ffd_listingagentname, Joe Polyak
listing_agent_number__c, 1068311
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, RISEHOME
listing_office_name__c, Rise Homes
listing_office_number__c, 28134
pba__listingprice_pb__c, 1800000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=Cpy1wui9pM1
pba__longitude_pb__c, -122.4802
pba__lotsize_pb__c, 0.07
mls_id__c, 497156
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-05-27
original_price__c, 1800000
overall_days_on_market__c, 34
parking__c, Attached
parking_access__c, Independent
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-05-27
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 692.31
pba__propertytype__c, Single Family Residence
id, a0E1I00000Sm4bhUAB
roof__c, Composition
sale_date__c, 2020-05-27
sale_price__c, 1800000
selling_agent_mls_id__c, 806718
selling_agent_name__c, Sherri Howe
selling_agent_number__c, 166017501
selling_co_agent_mls_id__c, 814525
selling_co_agent_name__c, Savinie Lam
selling_co_agent_number__c, 1066691
selling_co_office_mls_id__c, CGL01
selling_co_office_name__c, Corcoran Global Living
selling_co_office_number__c, 28273
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 2600
size__c, 2600
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 23rd
subdist__c, Parkside
ffd_name, 2475 23rd Avenue, San Francisco, CA, 94116
view__c, Ocean;Partial
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1928
pba__postalcode_pb__c, 94116
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/362339-1.jpg
ListingId, a0E1I00000Sm4bhUAB