meta_query='key:subdist__c;value:Marina|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327912' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15725
[post_author] => 4
[post_date] => 2018-11-02 19:54:46
[post_date_gmt] => 2018-11-02 19:54:46
[post_content] => Where Biff met Buffy and they rented their first apartment so they could jog to Crossfit together. Marina Green, yacht clubs, Ft. Mason, and front-row views from the Golden Gate Bridge to Alcatraz and the East Bay. This is as north as San Francisco goes.
[post_title] => Marina
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => marina
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-02 19:54:46
[post_modified_gmt] => 2018-11-02 19:54:46
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15725
[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, 1734 Lombard Street #8, San Francisco, CA, 94123
ffd_mls_id, 423727190
ffd_salesforce_id, a0E8W00000bFsJAUA0
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 9
address2__c, 1734 Lombard Street #8, San Francisco, CA, 94123
pba__address_pb__c, 1734 Lombard Street #8, San Francisco, CA, 94123
agent_only_remarks__c, Vacant easy to show. Text for showings. Pre-escrow open with FIRSTAM Title. Call LA with questions and for offer details. Buyer to verify advertised square footage. Neither seller nor listing agent has verified the accuracy of any of the disclosed sources of information.
appliances__c, Dishwasher;Disposal;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Jetted Tub
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 2005
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-03-17T02:48:38.000+0000
days_on_market__c, 2
dom__c, 1
ffd_description_pb, Quiet rear penthouse condo with large private outdoor patio boasting city and GG views. There is room to spread out in this bright tri-level contemporary town-home style condo. An open floor plan with soaring ceilings, outdoor space on each floor, a gas fireplace, and bamboo floors throughout make this an entertainer's dream. Gourmet chef's kitchen with charcoal granite countertops, high end appliances including Viking gas range, Bosch dishwasher and Jenn-Air refrigerator, and a wine fridge. The master suite has a private patio, a huge walk-in closet with custom California Closets, and a spa-like bathroom complete with a jet tub. Additional features include 2 large bedrooms with in unit washer & dryer, and bonus storage spaces throughout, and 2 spacious parking spaces. Situated in a small boutique elevator building in the heart of the Marina the unit is centrally located to Cow Hollow, Pacific Heights and Russian Hill. Stroll to the nearby cafes, restaurants, boutiques, and marina.
district__c, SF District 7
entry_level__c, 2
exterior_features__c, Balcony
external_listing__c, 1
fireplace_features__c, Gas Starter;Family Room;Metal
pba__floortype_pb__c, Bamboo;Carpet;Tile;Wood
hoa_fee_includes__c, Insurance on Structure,Management,Trash,Water
pba__hoafees__c, 973
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
ffd_lastmodifieddate, 2023-03-18T02:48:03.000+0000
pba__latitude_pb__c, 37.800931
pba__latitude_property__c, 37.800931
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2023-03-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Courtney
pba__listing_agent_lastname__c, Cohan
listing_agent_mls_id__c, 812044
ffd_listingagentname, Courtney A Cohan
listing_agent_number__c, 1054560
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1700000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=1FqQTHo8VvG
pba__longitude_pb__c, -122.430088
mls_id__c, 423727190
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub
master_property__c, a0O8W00000HuayCUAR
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-03-16
open_house_end__c, 2023-03-18T15:00:00.000+0000
open_house_start__c, 2023-03-18T13:00:00.000+0000
original_price__c, 1700000
overall_days_on_market__c, -81523
parking_access__c, Independent
parking_features__c, Attached,Covered,Garage Door Opener,Side-by-Side
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, 957.21
pba__propertytype__c, Condominium
ListingId, a0E8W00000bFsJAUA0
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, 1776
size__c, 1776
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Lombard
subdist__c, Marina
ffd_name, 1734 Lombard Street #8, San Francisco, CA, 94123
view__c, Marina;City;City Lights;Bay;Downtown;San Francisco;Golden Gate Bridge;Bridges
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2005
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530591746-1.jpg
