meta_query='key:subdist__c;value:Marina|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209445' 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, 134 Alhambra Street, San Francisco, CA, 94123
ffd_mls_id, 490738
ffd_salesforce_id, a0E1I00000H1Ps8UAF
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 134 Alhambra Street, San Francisco, CA, 94123
pba__address_pb__c, 134 Alhambra Street, San Francisco, CA, 94123
agent_only_remarks__c, Motivated Seller! Call John at 415-999-0673 to schedule appointment. Buyers shall satisfy themselves regarding square footage. Escrow opened with Gerrie Brindley, Chicago Title.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Hood Over Range
architectural_style__c, Marina
bath_features__c, Shower Stall(s);Tub;Skylight/Solar Tube
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1925
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2019-12-06
ffd_createddate, 2019-09-28T16:46:15.000+0000
days_on_market__c, 1118
dom__c, 82
ffd_description_pb, Huge Price Reduction! Exquisitely renovated, loaded with numerous upgrades, 2 Master Suites and inviting garden. Main level has 2 BR + 2 BA, oak floors, a sun-drenched Living Room with FP, formal Dining Room and a renovated Kitchen featuring a Lacanche range, Gaggenau refrigerator and quartzstone counters. Living Room has ornate detailing around the marble FP, bookshelves and Plantation shutters. The Upper Bedroom Suite is enhanced by an inset ceiling and built-in closet systems. The spacious 2nd Bedroom has a cedar-lined closet. The lower level features a second Master Suite opening to the mature garden and walk-in closet. The spa-like Master Bathroom is graced with a luxurious bathtub, separate shower and double-sink vanity. An Office/Den and a Laundry Room are adjacent to the Master BR. The one car Garage offers abundant storage. Located in the desirable Marina district, the home is near Chestnut Street shops & restaurants, Marina Green and the Palace of Fine Arts.
district__c, SF District 7
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-12T15:25:04.000+0000
pba__latitude_pb__c, 37.8022913
pba__latitude_property__c, 37.8022913
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2019-08-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Solaegui
listing_agent_mls_id__c, 803722
ffd_listingagentname, John R Solaegui
listing_agent_number__c, 803722
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 3229000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4387617
pba__lotsize_pb__c, 0.07
lower_level__c, Bedroom(s),Full Bath(s),Master Bedroom
mls_id__c, 490738
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2019-09-28
original_price__c, 3400000
overall_days_on_market__c, 140
parking__c, Attached,Garage,Auto Door,Interior Access
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Patio(s)
pba__pendingdate__c, 2019-12-19
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1192.77
pba__propertytype__c, Single Family Residence
id, a0E1I00000H1Ps8UAF
roof__c, Composition
room_type__c, Laundry;Den
sale_date__c, 2020-01-15
sale_price__c, 3100000
security_features__c, Security Alarm(s)
selling_agent_mls_id__c, 808939
selling_agent_name__c, John J. Caruso
selling_agent_number__c, 1038631
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 2599
size__c, 2599
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Alhambra
subdist__c, Marina
ffd_name, 134 Alhambra Street, San Francisco, CA, 94123
transportation__c, 2 Blocks
website_property_type__c, Single Family Home
window_features__c, Bay Window(s);Dual Pane;Window Screens
pba__yearbuilt_pb__c, 1925
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/356574-1.jpg
ListingId, a0E1I00000H1Ps8UAF