meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='325309' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15719
[post_author] => 4
[post_date] => 2018-11-02 19:54:35
[post_date_gmt] => 2018-11-02 19:54:35
[post_content] => Russian sailors were once buried upon this hill. That's why. Ground zero for the San Francisco high-rise revolt that began in the 1960s. Not coincidentally, also home to The Summit, The Royal Towers, Green Hill Tower, the so-called crookedest street in SF (the real crookedest street is in Potrero Hill), and the authentic inspiration for Armistead Maupin's magical Barbary Lane.
[post_title] => Russian Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => russian-hill
[to_ping] =>
[pinged] =>
[post_modified] => 2022-12-14 03:40:15
[post_modified_gmt] => 2022-12-14 11:40:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15719
[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, 31 Aladdin Terrace, San Francisco, CA, 94133
ffd_mls_id, 423720053
ffd_salesforce_id, a0E8W00000bDvAuUAK
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 31 Aladdin Terrace, San Francisco, CA, 94133
pba__address_pb__c, 31 Aladdin Terrace, San Francisco, CA, 94133
agent_only_remarks__c, This is a brand new construction, free-standing single family residence, officially a condominium, as a part of a 4-unit association with 3 other condominiums at 870 Union Street. Garage parking on Union Street. HOA budget is a close estimate and to be confirmed. COE conditioned on CFC which is imminent.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Wine Refrigerator;Double Oven;Ice Maker;Built-In Refrigerator;Gas Plumbed
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 2023
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Edward R Deleski
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-02-13T17:49:07.000+0000
days_on_market__c, 46
dom__c, 45
ffd_description_pb, Exquisite brand new construction single family home with views in an ideal Russian Hill location steps to Iconic Hyde Street and North Beach's Washington Square. This designer residence features an elevator to all levels, with a penthouse family room with terraces affording sweeping views to San Francisco Bay. Main level open floor plan concept boasts a Chef's kitchen with professional level appliances + designer finishes, and spacious dining and living areas with a fireplace for large scale dining and entertaining + powder room. All four bedrooms offer en-suite bathrooms with designer fixtures and Italian design porcelain and marble finishes. Primary bedroom suite features a spa-inspired luxurious bathroom with enormous walk-in shower and free standing tub for a true retreat experience. Additional amenities include a home office, laundry room, garage parking, in-floor radiant heating + built-in audio speakers throughout. Home is on a quiet and charming European-style alley street steps to Russian Hill and North Beach commercial centers offering parks, restaurants, cafes and shopping opportunities.
district__c, SF District 8
entry_level__c, 0
exterior_features__c, Balcony;Fire Pit
external_listing__c, 1
fireplace_features__c, Living Room;Gas Piped;Gas Log
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 250
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant Floor
interior_features__c, Formal Entry;Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2023-03-31T00:47:37.000+0000
pba__latitude_pb__c, 37.80031492
pba__latitude_property__c, 37.80031492
laundry_features__c, Inside Room;Washer Included;Dryer Included;Cabinets
listed_date__c, 2023-02-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jean-Paul
pba__listing_agent_lastname__c, Samaha
listing_agent_mls_id__c, 804997
ffd_listingagentname, Jean-Paul Samaha
listing_agent_number__c, 166014752
listing_co_agent_mls_id__c, 807512
listing_co_agent_number__c, 1020319
listing_co_office_mls_id__c, VANG02
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 166013449
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 5850000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.31aladdin.com/
pba__longitude_pb__c, -122.41376598
lower_level__c, Bedroom(s),Full Bath(s),Garage,Primary Bedroom,Street Entrance
mls_id__c, 423720053
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Soaking Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-02-13
open_house_end__c, 2023-04-02T16:00:00.000+0000
open_house_start__c, 2023-04-02T14:00:00.000+0000
original_price__c, 5850000
overall_days_on_market__c, -81492
parking_access__c, Side by Side
parking_features__c, Garage Door Opener,Garage Facing Rear,Interior Access,Mechanical Lift
parking_type__c, On Site - Assigned (Condo Only)
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, 1596.18
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bDvAuUAK
room_type__c, Laundry;Kitchen;Living Room;Dining Room;Family Room;Great Room;Primary Bathroom;Primary Bedroom
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, 3665
size__c, 3665
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Aladdin
subdist__c, Russian Hill
ffd_name, 31 Aladdin Terrace, San Francisco, CA, 94133
view__c, Panoramic;City Lights;Bay;Water
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 2023
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530579251-1.jpg