meta_query='key:subdist__c;value:Ingleside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218016' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12158
[post_author] => 4
[post_date] => 2018-10-29 01:19:09
[post_date_gmt] => 2018-10-29 01:19:09
[post_content] => Ingleside is a lot more down-to-earth than some of its swankier neighbors on the north end of town, and it's also a lot more affordable. Homes tend to be modest, some in the same family for generations. Unexpected views of downtown add to the attraction of this more-affordable neighborhood, which also has great public transit options and easy freeway access.
[post_title] => Ingleside
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => ingleside
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 11:47:15
[post_modified_gmt] => 2024-04-09 18:47:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12158
[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, 1223 Capitol Avenue #1225, San Francisco, CA, 94112
ffd_mls_id, 421534075
ffd_salesforce_id, a0E1I00000TxaGrUAJ
num_of_fireplaces__c, 0
num_of_rooms__c, 14
of_units__c, 0
address2__c, 1223 Capitol Avenue #1225, San Francisco, CA, 94112
pba__address_pb__c, 1223 Capitol Avenue #1225, San Francisco, CA, 94112
agent_only_remarks__c, Hello Agents! 1. Book showing appointments through https://calendly.com/homesbyrise/1223-1225-capitol-ave-san-francisco-ca-94112 there is a Supra iBox on front door no CBS code required please send PEAD to [email protected] prior to showing 2. Disclosures can be pulled through https://app.disclosures.io/link/12231225-Capitol-Ave-vr3c4hjj 3. Note that measurements of 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 the number of rooms and sqft. measurements prior to entering into a contract. 4. Escrow officer is Katie Berggren ([email protected] or 650-343-6282). 5. Offer date TBD, PLEASE NO PRE-EMPTIVES. Thank you!
pba__fullbathrooms_pb__c, 5
pba__bedrooms_pb__c, 6
year_build_text__c, 2004
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-04-16
ffd_createddate, 2021-04-01T19:08:26.000+0000
days_on_market__c, 839
dom__c, 15
ffd_description_pb, Overflowing with possibilities, this 2-unit, 3-story duplex built in 2004, offers a large amount of space in a prime setting. This is the perfect property to rent out 1 of the units and live in the other or potentially fast-track a condo conversion. The lower level supplies 1-bed, 1-bath and a living area, while the second floor tacks on 3 beds, 2 baths, a kitchen, living/dining and a den. A separate third floor unit includes a kitchen, living/dining, 2-beds, 2-baths and a den. Each level opens to generous patios with views overlooking the backyard. As a bonus, a ladder leads up to the roof, which could be converted to a rooftop balcony. Right off Ocean Ave and close to 280, the duplex sits in between SF State and City College, plus close to shopping, dining, Muni and BART.
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:48:40.000+0000
pba__latitude_pb__c, 37.724041
pba__latitude_property__c, 37.724041
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2021-04-01
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, 1995000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?brand=0&m=BSZVmLWkkee
pba__longitude_pb__c, -122.459528
mls_id__c, 421534075
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-04-01
original_price__c, 1995000
overall_days_on_market__c, 91
parking_access__c, Independent
parking_features__c, Attached,Tandem Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-04-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 603.01
pba__propertytype__c, Single Family Residence
id, a0E1I00000TxaGrUAJ
sale_date__c, 2021-06-23
sale_price__c, 2005000
selling_agent_mls_id__c, 666666
selling_agent_number__c, 666666
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Ascend Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 3325
size__c, 3325
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Capitol
subdist__c, Ingleside
ffd_name, 1223 Capitol Avenue #1225, San Francisco, CA, 94112
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 2004
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530210286-1.jpg
ListingId, a0E1I00000TxaGrUAJ