meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327167' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15731
[post_author] => 4
[post_date] => 2018-11-02 19:54:56
[post_date_gmt] => 2018-11-02 19:54:56
[post_content] => The site of perhaps the most photographed vista in San Francisco, Alamo Square is home to the world-famous Painted Ladies. The row of iconic Victorian homes, with the city skyline as the backdrop, provides a picture-perfect postcard view of San Francisco.
[post_title] => Alamo Square
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => alamo-square
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-02 19:54:56
[post_modified_gmt] => 2018-11-02 19:54:56
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15731
[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, 1147 Fell Street, San Francisco, CA, 94117
ffd_mls_id, 423715378
ffd_salesforce_id, a0E8W00000a8NGNUA2
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 2
address2__c, 1147 Fell Street, San Francisco, CA, 94117
pba__address_pb__c, 1147 Fell Street, San Francisco, CA, 94117
agent_only_remarks__c, Will be available for showings starting 2/1. 1st Opens 2/4, 2/5. Agents, THIS IS ONE YOU NEED TO GET YOUR CLIENTS IN TO, TO SEE (AND HEAR) & FULLY APPRECIATE THE SPACE & WORK THE SELLERS HAVE ACCOMPLISHED!! These sellers converted and completed a very similar project, expanding down as well, one building to the East. It was done with over the counter permits, staying inside the envelope. Spectacular! We will provide unapproved plans. Seller is willing to assist in getting proposed plans approved and permitted if buyer desires. Hot tub hookups installed in deck area already.
appliances__c, Dishwasher;Disposal;Built-In Gas Range;Built-In Gas Oven;Built-In Refrigerator
architectural_style__c, Edwardian;Modern/High Tech
bath_features__c, Shower Stall(s);Tile;Quartz
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1925
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2023-02-02T20:48:42.000+0000
days_on_market__c, 36
dom__c, 5
ffd_description_pb, Yearning for a HUGE, exclusive use, beautifully landscaped, south facing yard(Hot tub hookups too)? Looking for impeccable style, thoughtful design & excellent craftmanship? How about air conditioning. Come live in one of the most dynamic & convenient neighborhoods in The City. Owner spared no expense in unbelievable sound reducing measures. Come visit to experience this stylish & tranquil condo yourself. It will amaze you! This rare offering has it all.. & more. In addition to the flowing 2br floorplan, with a stunningly gorgeous kitchen, spacious LR & DR, spa-like bathroom & laundry room, there is a huge deeded, finished office space on the lower level. This area can be integrated with the current living space by adding an internal staircase, creating an additional primary suite & en suite bathroom, making the total living area of the condo +- 1890 sqft on 2 levels, (per unapproved architects drawing. buyer to verify/approve of plans on their own). Side-by-side parking wired for Electric car charger (Had Tesla charger). Enjoy this sublime home now, expand later if you desire! Buy-Rite, Falleti's, Che Fico, The Mill & 4505 steps away. EZ commuter access whether driving, hopping on a tech bus or riding a bike on The Wiggle. Must see gem. One of a kind ... will blow your mind.
district__c, SF District 6
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Insurance on Structure,Sewer,Trash,Water
pba__hoafees__c, 400
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 1147-119 Fell St
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2023-03-07T01:49:03.000+0000
pba__latitude_pb__c, 37.773929
pba__latitude_property__c, 37.773929
laundry_features__c, Inside Room;Washer Included;Dryer Included;Cabinets
listed_date__c, 2023-01-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ken
pba__listing_agent_lastname__c, Eggers
listing_agent_mls_id__c, 526543
ffd_listingagentname, Ken A Eggers
listing_agent_number__c, 526543
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CIP01
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28939
pba__listingprice_pb__c, 1395000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.436711
mls_id__c, 423715378
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Tile
master_property__c, a0O8W00000Fro3HUAR
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-02-02
original_price__c, 1395000
overall_days_on_market__c, -81481
parking_access__c, Side by Side
parking_features__c, Attached,EV Charging,Garage Door Opener
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2023-02-07
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-03-06T09:48:31.000+0000
price_per_square_foot__c, 1189.78
pba__propertytype__c, Condominium
ListingId, a0E8W00000a8NGNUA2
room_type__c, Office;Bonus Room;Other
sale_date__c, 2023-03-03
sale_price__c, 1630000
selling_agent_mls_id__c, 804303
selling_agent_number__c, 166013815
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Inspire Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1370
size__c, 1370
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fell
subdist__c, Alamo Square
ffd_name, 1147 Fell Street, San Francisco, CA, 94117
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1925
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530570856-1.jpg