meta_query='key:subdist__c;value:Monterey Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218341' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70666
[post_author] => 4
[post_date] => 2018-11-30 20:30:41
[post_date_gmt] => 2018-11-30 20:30:41
[post_content] => While you may have never heard of this neighborhood, you'll realize the name perfectly describes it: North of Monterey on a hill with views to the Pacific Ocean. Nestled between St. Francis Wood, Sherwood Forest, and Westwood Highlands lies a collection of stately single-family homes.
[post_title] => Monterey Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => monterey-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2023-10-30 17:00:50
[post_modified_gmt] => 2023-10-31 00:00:50
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70666
[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, 100 San Felipe Avenue, San Francisco, CA, 94127
ffd_mls_id, 421539290
ffd_salesforce_id, a0E1I00000US9kNUAT
num_of_fireplaces__c, 1
num_of_rooms__c, 10
of_units__c, 0
address2__c, 100 San Felipe Avenue, San Francisco, CA, 94127
pba__address_pb__c, 100 San Felipe Avenue, San Francisco, CA, 94127
agent_only_remarks__c, OFFERS DUE TUE, 4/27 AT 1 PM. To schedule showings use https://calendly.com/adam-betta/100-san-felipe. No need to contact agent, just email your pead after scheduling on calendly. Supra box on hose bib left of the garage. Seller(s), listing agent, and Highland Partners are unable to guarantee all surfaces have been disinfected and therefore advise showing agents and potential buyers to exercise caution while viewing the listing. Per Fair Housing Act Advisory, Seller(s) will not be accepting ANY buyer(s) support letters with offers and letters will not be delivered to Seller. Pre with Semiko Prim at Chicago Title. https://app.disclosures.io/link/100-San-Felipe-Avenue-3c0vgki6
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator;Ice Maker;Free Standing Freezer
architectural_style__c, Tudor
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Marble
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1928
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-04-22T21:32:27.000+0000
days_on_market__c, 821
dom__c, 3
ffd_description_pb, Where Old Hollywood meets San Francisco. This stately English Tudor boasts a grand living room with wood beamed ceilings, a wood-burning fireplace. Off the living room is a lovely atrium surrounded by exquisite windows; just above the living room ascend to a library with built-in bookshelves. Formal dining room with beautifully detailed ceilings adjacent to an expansive kitchen with commercial range plus an eat-in breakfast room which looks out to the garden & patio. 4 bedrooms, 3.5 baths includes an au pair suite, the media room and 2 of the large upstairs bedrooms all boast magnificent views of the Pacific Ocean. Two car garage with interior access.
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
electric__c, 220 Volts in Kitchen
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry;Open Beam Ceiling
ffd_lastmodifieddate, 2022-01-25T15:50:00.000+0000
pba__latitude_pb__c, 37.73125
pba__latitude_property__c, 37.73125
laundry_features__c, Hookups Only
listed_date__c, 2021-04-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Adam
pba__listing_agent_lastname__c, Betta
listing_agent_mls_id__c, 814020
ffd_listingagentname, Adam R Betta
listing_agent_number__c, 1064009
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, HIGHLAND
listing_office_name__c, Highland Partners
listing_office_number__c, 27566
pba__listingprice_pb__c, 2495000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.tourfactory.com/idxr2861736
pba__longitude_pb__c, -122.462289
mls_id__c, 421539290
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Marble;Sunken Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-04-19
original_price__c, 2495000
overall_days_on_market__c, 72
parking_access__c, Side by Side
parking_features__c, Attached,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2021-04-27
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 981.24
pba__propertytype__c, Single Family Residence
id, a0E1I00000US9kNUAT
road_surface_type__c, Paved
roof__c, Composition
room_type__c, Kitchen;Library;Atrium;Living Room;Master Bathroom;Dining Room;Family Room;Master Bedroom
sale_date__c, 2021-05-07
sale_price__c, 3400000
selling_agent_mls_id__c, 666666
selling_agent_number__c, 666666
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Ankur Luthra
pba__status__c, Closed
pba__totalarea_pb__c, 3465
size__c, 3465
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, San Felipe
subdist__c, Monterey Heights
ffd_name, 100 San Felipe Avenue, San Francisco, CA, 94127
view__c, Ocean;City Lights
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1928
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530220906-1.jpg
ListingId, a0E1I00000US9kNUAT