meta_query='key:subdist__c;value:Lone Mountain|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='385793' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70653
[post_author] => 4
[post_date] => 2018-11-30 20:30:26
[post_date_gmt] => 2018-11-30 20:30:26
[post_content] => Charming single-family homes on streets that made sense before the University of San Francisco left its footprint on the neighborhood. The most charming circular street you'll ever meet (hello, Ewing Terrace). Discontiguous streets and student life just north of the North Panhandle.
[post_title] => Lone Mountain
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => lone-mountain
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 07:57:25
[post_modified_gmt] => 2024-04-17 14:57:25
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70653
[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, 1726696506
ffd_listing_title, 1831 Fulton Street, San Francisco, CA, 94117
ffd_mls_id, 424059788
ffd_salesforce_id, a0EUd0000032lFhMAI
num_of_fireplaces__c, 2
num_of_rooms__c, 7
of_units__c, 2
address2__c, 1831 Fulton Street, San Francisco, CA, 94117
pba__address_pb__c, 1831 Fulton Street, San Francisco, CA, 94117
agent_only_remarks__c, Offers welcome 9/18, noon. Please allow 48 hours for reply.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1917
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-09-06T10:49:37.000+0000
days_on_market__c, 12
dom__c, 12
ffd_description_pb, Light-filled, house-like, remodeled, top floor, two-level condominium in the heart of sought-after NOPA, epitomizing the perfect blend classic charm and modern convenience. Located in a well-maintained building with only two units, this ideal urban sanctuary offers three bedrooms, two baths, sunroom, parking, storage, and private walkout deck with amazing views towards the city skyline and Buena Vista Park. On the main level is a spacious living room with fireplace, built-in bookshelves, and soaring vaulted ceilings, perfect for entertaining guests or relaxing with family. Also on this level is the dining room, gourmet chef's kitchen w/granite counters and high-end appliances, two bedrooms,sunroom, and full bath. A beautiful staircase leads to the second level which has an exquisite primary suite w/fireplace, high ceilings, luxurious bath w/jetted tub, and French doors leading to the large, exclusive-use view deck.Other features include: in-unit washer/dryer, plentiful closets,gleaming wood floors, one car parking, storage, skylights, recessed lighting. Centrally located near the Panhandle, USF, shopping, grocery, restaurants, and transportation options, this home offers easy access to all that San Francisco has to offer.
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning;Gas Starter
pba__hoafees__c, 400
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
interior_features__c, Skylight(s);Cathedral Ceiling
ffd_lastmodifieddate, 2024-09-18T21:47:16.000+0000
pba__latitude_pb__c, 37.775576
pba__latitude_property__c, 37.775576
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2024-07-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Pota
pba__listing_agent_lastname__c, Perimenis
listing_agent_mls_id__c, 367238
ffd_listingagentname, Pota Perimenis
listing_agent_number__c, 367238
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP90
listing_office_name__c, Compass
listing_office_number__c, 29048
pba__listingprice_pb__c, 1895000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.1831fultonstreet.com/mls/153704761
pba__longitude_pb__c, -122.447112
mls_id__c, 424059788
master_property__c, a0OUd00000BhnASMAZ
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-09-06
open_house_end__c, 2024-09-19T19:00:00.000+0000
open_house_start__c, 2024-09-19T18:00:00.000+0000
original_price__c, 1895000
overall_days_on_market__c, -82063
parking_access__c, Side by Side
parking_features__c, Side-by-Side
parking_type__c, On Site - Mapped (Condo Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 926.2
pba__propertytype__c, Condominium
ListingId, a0EUd0000032lFhMAI
room_type__c, Sun Room
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 2046
size__c, 2046
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fulton
subdist__c, Lone Mountain
ffd_name, 1831 Fulton Street, San Francisco, CA, 94117
view__c, City Lights;Downtown;San Francisco;Hills
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1917
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530831095-1.jpg