meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='373661' 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] => 2024-03-19 14:29:22
[post_modified_gmt] => 2024-03-19 21:29:22
[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
(
)
)
_yoast_indexnow_last_ping, 1711736889
ffd_listing_title, 31 Aladdin Terrace, San Francisco, CA, 94133
ffd_mls_id, 424007480
ffd_salesforce_id, a0EUd00000158xGMAQ
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 single family residence, technically a condominium, and is part of a 4-unit association with 3 other condominiums at 870/872/874 Union Street. Garage parking on Union Street with interior courtyard access into 31 Aladdin Terrace. A CFC (final certificate )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
architectural_style__c, Contemporary
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, 2024-02-23
ffd_createddate, 2024-02-09T01:47:06.000+0000
days_on_market__c, 28
dom__c, 25
ffd_description_pb, Brand new construction modern residence offers breathtaking views and elevator to all levels in an ideal Russian Hill location near North Beach's Washington Square Park. An entertainer's dream, residence features a penthouse level entertainment space with two terraces and sweeping views to San Francisco Bay and beyond. Main level Great Room open floor plan design boasts a Chef's kitchen with professional level appliances + luxurious finishes, and spacious dining and living areas with a fireplace for large scale dining and entertaining. All four bedrooms offer en-suite bathrooms with designer fixtures and Italian design porcelain and marble finishes. Primary bedroom suite boasts a spa-inspired luxurious bathroom with enormous walk-in shower and soaking tub for a true retreat experience. Additional amenities include a home office, laundry room, garage parking, in-floor radiant heating + built-in audio speakers. Home is on a quiet and charming European-style alley street within close proximity to iconic Hyde Street and North Beach neighborhood centers offering parks, restaurants, cafes and shopping opportunities.
district__c, SF District 8
driveway_sidewalks__c, Paved Driveway
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
hoa_fee_includes__c, Insurance on Structure
pba__hoafees__c, 335
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 870-872-874 Union Street + 31 Aladdin Ter
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, 2024-03-07T11:47:14.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, 2024-02-05
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, 4850000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.41376598
lower_level__c, Bedroom(s),Full Bath(s),Garage,Primary Bedroom,Street Entrance
mls_id__c, 424007480
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Tile;Soaking Tub;Skylight/Solar Tube
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-02-08
original_price__c, 4850000
overall_days_on_market__c, -81852
parking_access__c, Side by Side
parking_features__c, Garage Door Opener,Garage Facing Rear,Interior Access,Mechanical Lift
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2024-03-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-03-06T13:42:13.000+0000
price_per_square_foot__c, 1232.96
pba__propertytype__c, Single Family Residence
ListingId, a0EUd00000158xGMAQ
room_type__c, Laundry;Kitchen;Living Room;Dining Room;Family Room;Great Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2024-03-05
sale_price__c, 4612500
selling_agent_mls_id__c, 803413
selling_agent_number__c, 803413
selling_co_agent_mls_id__c, 197832
selling_co_agent_number__c, 197832
selling_co_office_mls_id__c, COMP12
selling_co_office_name__c, Compass
selling_co_office_number__c, 28739
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 3741
size__c, 3741
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;San Francisco
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/530729573-1.jpg
_edit_lock, 1711736748:1564
_edit_last, 1564
_price_reduced__c, field_61ce1b15d3a3f
_has_3d_tour__c, field_61ce1b4cd3a40
_ListingId, field_62bf231ba1405
_pba__latitude_pb__c, field_62c436cc3ee02
_pba__longitude_pb__c, field_62c436f43ee03
_yoast_wpseo_content_score, 30
_yoast_wpseo_focuskeywords, []
_yoast_wpseo_keywordsynonyms, [""]
_yoast_wpseo_estimated-reading-time-minutes, 1
_yoast_wpseo_canonical, https://jacksonfuller.com/property/31-aladdin-terrace-san-francisco-ca-94133/