meta_query='key:subdist__c;value:Merced Manor|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218502' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70660
[post_author] => 4
[post_date] => 2018-11-30 20:30:34
[post_date_gmt] => 2018-11-30 20:30:34
[post_content] => The most notable neighborhood feature is the eponymous reservoir. It's such a small rectangle of homes -- bounded by Eucalyptus, 19th Ave./CA-1, Sloat Blvd., and 26th Ave. -- that you'd be unlikely to know it's a distinct neighborhood unless you live there. Or you're reading this.
[post_title] => Merced Manor
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => merced-manor
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-12 12:26:09
[post_modified_gmt] => 2024-04-12 19:26:09
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70660
[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, 3095 23rd Avenue, San Francisco, CA, 94132
ffd_mls_id, 421540410
ffd_salesforce_id, a0E1I00000USDWoUAP
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 3095 23rd Avenue, San Francisco, CA, 94132
pba__address_pb__c, 3095 23rd Avenue, San Francisco, CA, 94132
agent_only_remarks__c, Appointment only. Please Call Dixie Hurst to schedule showings. Provide a PEAD prior to showing to [email protected]
appliances__c, Dishwasher;Free Standing Refrigerator;Gas Cook Top
architectural_style__c, Mediterranean
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 6
year_build_text__c, 1936
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Dixie D Hurst
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2021-04-24T01:47:03.000+0000
days_on_market__c, 820
dom__c, 17
ffd_description_pb, This charming mediterranean-style corner home lives in an ideal location in Merced Manor overlooking Rolph Nicol Park. The single family home has been extensively renovated showcasing high end finishes while maintaining its historic charm. The spacious foyer leads to a formal dining room. The light-filled living room features a cathedral ceiling with an inviting fireplace. The brand new kitchen has all new appliances, cabinetry, and hardware. Enjoy sunny views of Rolph Nicol Park from the breakfast area. Master bedroom with ensuite and an additional bedroom with bathroom complete main level. The lower level is made for entertaining with a wet bar, open family room, fire place, and an additional 2 bedrooms and full bath. The upper level has an additional 2 bedrooms. Lowell High School is one of the best rated public schools in the area making this an ideal family home. Steps from SFSU. Ocean Beach, Lake Merced Golf Course, SF Zoo all in close proximity. House is on solar.
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Solar w/Backup
interior_features__c, Storage Area(s);Cathedral Ceiling
ffd_lastmodifieddate, 2022-01-25T15:50:42.000+0000
pba__latitude_pb__c, 37.731287
pba__latitude_property__c, 37.731287
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2021-04-20
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Richard
pba__listing_agent_lastname__c, Teed
listing_agent_mls_id__c, 803471
ffd_listingagentname, Richard B Teed
listing_agent_number__c, 803471
listing_co_agent_mls_id__c, 813020
listing_co_agent_number__c, 1059018
listing_co_office_mls_id__c, COMP12PUI
listing_co_office_name__c, Compass
listing_co_office_number__c, 27690
listing_office_mls_id__c, COMP12PUI
listing_office_name__c, Compass
listing_office_number__c, 27690
pba__listingprice_pb__c, 2495000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4793976
lower_level__c, Bedroom(s),Family Room,Garage,Kitchen
mls_id__c, 421540410
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, 2
on_market_date__c, 2021-04-20
original_price__c, 2495000
overall_days_on_market__c, 255
parking_access__c, Tandem
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-05-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 921.25
pba__propertytype__c, Single Family Residence
id, a0E1I00000USDWoUAP
room_type__c, Office;Kitchen;Living Room;Master Bathroom;Dining Room;Family Room
sale_date__c, 2021-05-28
sale_price__c, 3100000
security_features__c, Security System Leased
selling_agent_mls_id__c, 804295
selling_agent_number__c, 166013807
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Tapestry Properties
pba__status__c, Closed
pba__totalarea_pb__c, 3365
size__c, 3365
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 23rd
subdist__c, Merced Manor
ffd_name, 3095 23rd Avenue, San Francisco, CA, 94132
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1936
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530225508-1.jpg
ListingId, a0E1I00000USDWoUAP
