meta_query='key:subdist__c;value:West Portal|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='220063' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15138
[post_author] => 4
[post_date] => 2018-10-31 23:34:48
[post_date_gmt] => 2018-10-31 23:34:48
[post_content] => Stroll down West Portal Avenue -- the heart of this charming west-side neighborhood -- and you might feel like you’ve stepped back in time. Many shops and restaurants have been in operation for decades. The houses are spacious and many are detached from their neighbors, but you’ll feel welcome and at home.
[post_title] => West Portal
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => west-portal
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-27 10:09:58
[post_modified_gmt] => 2024-11-27 18:09:58
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15138
[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, 225 Claremont Boulevard, San Francisco, CA, 94127
ffd_mls_id, 421575245
ffd_salesforce_id, a0E1I00000UVA3hUAH
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 225 Claremont Boulevard, San Francisco, CA, 94127
pba__address_pb__c, 225 Claremont Boulevard, San Francisco, CA, 94127
agent_only_remarks__c, Easy to show at any time by appointment. For showings and agent previews, please contact Robert Callan 415-748-1481 & [email protected]
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1924
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Barbara J Callan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-07-19T19:23:56.000+0000
days_on_market__c, 1261
dom__c, 11
ffd_description_pb, A rare find in a prime West Portal location! This fully detached remodeled Mediterranean style home features lovely architectural detail throughout including shimmering hardwood floors, vintage fireplace, crown moldings, archways, bay windows, & a vintage built-in credenza. It boasts all the elegant details from the era in which it was built & blends beautifully with the modern features & conveniences for today's modern lifestyle. A great floor plan provides the perfect home for entertaining, home studies, & guest quarters. 4 good sized bedrooms with 3 bedrooms on the same floor, 2 baths, 1/4 bath, elegant foyer, formal dining room, spacious living room, breakfast room, a fabulous remodeled kitchen & media room it offers an elegant & spacious setting. Walk to all the fabulous shops & restaurants in West Portal Village. Walk to great parks, schools, & transportation. Walk out garden & deck, excellent storage, two car garage. Photos, Video, & Matterport3D Tour at 225Claremont.com
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T15:57:37.000+0000
pba__latitude_pb__c, 37.7417006
pba__latitude_property__c, 37.7417006
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2021-05-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Robert
pba__listing_agent_lastname__c, Callan
listing_agent_mls_id__c, 804668
ffd_listingagentname, Robert R Callan Jr.
listing_agent_number__c, 166014312
listing_co_agent_mls_id__c, 215760
listing_co_agent_number__c, 215760
listing_co_office_mls_id__c, STHB4
listing_co_office_name__c, Sotheby's International Realty
listing_co_office_number__c, 28397
listing_office_mls_id__c, STHB4
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 28397
pba__listingprice_pb__c, 1849000
pba__listingtype__c, Sale
pba__listing_website__c, http://225Claremont.com
pba__longitude_pb__c, -122.4639456
mls_id__c, 421575245
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-07-19
original_price__c, 1849000
overall_days_on_market__c, 118
parking_access__c, Tandem
parking_features__c, Garage Facing Front
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-07-30
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1185.57
pba__propertytype__c, Single Family Residence
id, a0E1I00000UVA3hUAH
sale_date__c, 2021-08-25
sale_price__c, 2300000
selling_agent_mls_id__c, 803379
selling_agent_number__c, 803379
selling_co_agent_mls_id__c, 812832
selling_co_agent_number__c, 1058392
selling_co_office_mls_id__c, COMP12PUI
selling_co_office_name__c, Compass
selling_co_office_number__c, 27690
selling_office_name__c, Bay Real Estate Group
pba__status__c, Closed
pba__totalarea_pb__c, 1940
size__c, 1940
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Claremont
subdist__c, West Portal
ffd_name, 225 Claremont Boulevard, San Francisco, CA, 94127
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1924
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530286215-1.jpg
ListingId, a0E1I00000UVA3hUAH
_yoast_indexnow_last_ping, 1735670631