Exception Object ( [message:protected] => _doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO `home` SET `homeid`='SS8DYH', `mlsnum`=NULL, `altmlsnum`=NULL, `rooms`=NULL, `baths`='0', `sqft`=NULL, `comments`=NULL, `updated`=NULL, `listdate`='2018-05-17', `expiredate`=NULL, `askingprice`=NULL, `addr`='4185 Bedaki Avenue NE', `city`='Lowell', `county`='Kent', `state`='MI', `zip`='49331', `country`='US', `date_posted`='0000-00-00', `status`='pending', `id`='5028208', `photographerid`=NULL, `date_linked`='0000-00-00', `contact_notes`=NULL, `leadGen`='none', `archived`='no', `exclusiveLeads`='no', `directory`=NULL, `needsLinking`='0', `vaPropertyId`=NULL, `vaHomeStatus`='inherited', `mlsName`=NULL, `externalURL`=NULL, `officeCode`=NULL, `externalImagesUpdated`=NULL, `dateMediaUpdated`=NULL, `sellingPrice`=NULL, `updateLOYTImages`=NULL, `correctedCity`=NULL, `propertyType`='Home', `propertySubType`=NULL, `fullBaths`=NULL, `halfBaths`=NULL, `threeQuarterBaths`=NULL, `quarterBaths`=NULL, `sellType`='sale', `neighborhood`=NULL, `customVideoTitle`=NULL, `isWaterfront`=NULL, `isInForeclosure`=NULL, `isShortSale`=NULL, `isREO`=NULL, `yearBuilt`=NULL, `sourceImportScriptId`=NULL, `mlsArea`=NULL, `listingStatus`=NULL, `frontImageLabel`=NULL, `LastActiveInFeed`=NULL, `DateFeedShowsUpdated`=NULL, `standardized_address`=NULL] [Native code: 1048] [Native message: Column 'askingprice' cannot be null] [string:Exception:private] => [code:protected] => 0 [file:protected] => /local/online/live/dharma/DAO/crux/DAO_Home_Crux.php [line:protected] => 671 [trace:Exception:private] => Array ( [0] => Array ( [file] => /local/online/live/dharma/DAO/DAO_Home.php [line] => 413 [function] => insert [class] => DAO_Home_Crux [type] => -> [args] => Array ( [0] => BO_Home Object ( [shortHash] => [allpro] => [_fields:BO_Home:private] => [_productStatus:BO_Home:private] => [homeid:protected] => SS8DYH [mlsnum:protected] => [altmlsnum:protected] => [rooms:protected] => [baths:protected] => 0 [sqft:protected] => [comments:protected] => [updated:protected] => [listdate:protected] => 2018-05-17 [expiredate:protected] => [askingprice:protected] => [addr:protected] => 4185 Bedaki Avenue NE [city:protected] => Lowell [county:protected] => Kent [state:protected] => MI [zip:protected] => 49331 [country:protected] => US [date_posted:protected] => 0000-00-00 [status:protected] => pending [id:protected] => 5028208 [photographerid:protected] => [date_linked:protected] => 0000-00-00 [contact_notes:protected] => [leadGen:protected] => none [archived:protected] => no [exclusiveLeads:protected] => no [directory:protected] => [needsLinking:protected] => 0 [vaPropertyId:protected] => [vaHomeStatus:protected] => inherited [mlsName:protected] => [externalURL:protected] => [officeCode:protected] => [externalImagesUpdated:protected] => [dateMediaUpdated:protected] => [sellingPrice:protected] => [updateLOYTImages:protected] => [correctedCity:protected] => [propertyType:protected] => Home [propertySubType:protected] => [fullBaths:protected] => [halfBaths:protected] => [threeQuarterBaths:protected] => [quarterBaths:protected] => [sellType:protected] => sale [neighborhood:protected] => [customVideoTitle:protected] => [isWaterfront:protected] => [isInForeclosure:protected] => [isShortSale:protected] => [isREO:protected] => [yearBuilt:protected] => [sourceImportScriptId:protected] => [mlsArea:protected] => [listingStatus:protected] => [frontImageLabel:protected] => [LastActiveInFeed:protected] => [DateFeedShowsUpdated:protected] => [standardized_address:protected] => [Photographers:protected] => [prefs:protected] => [PBINid:protected] => 5028208 [PBIN_HALOid:protected] => 366952 [PBIN_PHOTOid:protected] => 0 [PBIN_TCLSid:protected] => 0 [PBINstatusMask:protected] => 0 [Realtor:protected] => BO_Realtor Object ( [prefs:BO_Realtor:private] => [realtorid:protected] => 366952 [type:protected] => Realtor [fname:protected] => United [lname:protected] => Admin [phone:protected] => 616-866-5800 [cell:protected] => [fax:protected] => [email:protected] => Administrator@remax-rockford.com [website:protected] => www.RemaxOfRockford.com [agency:protected] => RE/MAX United - MI [office:protected] => [associd:protected] => [extid:protected] => 0 [acct_status:protected] => CREDITCARD [address:protected] => 28 N. Monroe Street [city:protected] => Rockford [county:protected] => [state:protected] => MI [zip:protected] => 49341 [signupdate:protected] => 2013-12-18 00:00:00 [notes:protected] => [permit_email:protected] => y [referral:protected] => [refferedby:protected] => [product:protected] => 100898 [credit:protected] => 0.00 [bio:protected] => [hasLeadGen:protected] => no [emailOptOut:protected] => neither [vaRealtorStatus:protected] => inherited [vaClientId:protected] => [realtorLogin:protected] => [realtorPassword:protected] => [acceptsms:protected] => unknown [mobileProvider:protected] => unknown [testimonial:protected] => [stateLicenseNumber:protected] => [personalYouTubeId:protected] => [md5Hash:protected] => [cacheExpire:protected] => 2015-02-16 [leadbeePin:protected] => 1234 [lastLogin:protected] => 2018-05-17 [defaultOrbitalRefNum:protected] => [FacebookURL:protected] => [TwitterURL:protected] => [YouTubeURL:protected] => [BlogURL:protected] => [emailBounced:protected] => 0 [pictureURL:protected] => [completedSetup:protected] => complete [tempCredit:protected] => [Company:protected] => BO_Company Object ( [prefs:BO_Company:private] => [externalURIs:BO_Company:private] => Array ( ) [CMPid:protected] => 100898 [CMPname:protected] => RE/MAX United - MI [CMPadmin:protected] => [CMPtype:protected] => basic [CMPnotes:protected] => Contract Dates: Feb 17th 2017 to Feb 17th, 2018 Launch Date: 01/16/2014 Type of account: Feed account ? Full serve and Self Serve Where agent puts pictures: Number of Images needed: Where feed comes from: Do we link to MLS? Syndication?? YouTube Channel: www.youtube.com/ [CMPbill:protected] => no [CMPbillType:protected] => [CMPbillingLoc:protected] => RE/MAX United 28 N Monroe Street Rockford, MI 49341-1228 [CMPlaunch:protected] => 2014-01-15 [CMPcontractStart:protected] => 2018-02-17 [CMPcontractEnd:protected] => 2019-02-17 [CMPguarantee:protected] => 0 [CMPrep:protected] => cseegmiller [CMPcolorScheme:protected] => [CMPparticipate:protected] => no [CMPstate:protected] => MI [CMPsalesRep:protected] => jandrews [CMPhasLeadGen:protected] => yes [CMPemailPromos:protected] => yes [CMPrelaunch:protected] => [CMPnumAgents:protected] => [CMProster:protected] => no [pricingType:protected] => Residential [vaCompanyStatus:protected] => disabled [companyInformation:protected] => CirclePix and RE/MAX United> have teamed up to provide Full Service tour discounts as well as additional FREE upgrades! Please call our friendly Customer Service staff at 877-390-6630 to order today! RE/MAX United Economy Tour, 5 Virtuals & 12 Stills for $119.99 Standard Tour, 5 Virtuals & 25 Stills for $129.99 Master Tour, 10 Virtuals & 35 Stills for $149.99 Each Tour Includes: Print Your Own Flyers eTour ePostcard Online Lead Generation QR Code Generator Craigslist Ad Creator [companyPriceDetails:protected] => [nextPromoEmailDate:protected] => [promoEmailFrequency:protected] => 0 [parentCMPid:protected] => 100651 [extid:protected] => [cacheExpire:protected] => 2017-12-06 [isLOYTAccount:protected] => 0 [urlLookUp:protected] => [webExTrainingVideo:protected] => [WebExVideoHeader:protected] => [WebExVideoText:protected] => [addr1:protected] => 28 N Monroe Street [addr2:protected] => [city:protected] => Rockford [zip:protected] => 49341-1228 [phone:protected] => 616-866-5800 [displayName:protected] => RE/MAX United [externalSubdomain:protected] => [billingRealtorId:protected] => [billingProfileId:protected] => 422103740 [googleAnalyticsCode:protected] => [Country:protected] => USA [StarMarketingStatus:protected] => Active [CompanyBrandID:protected] => 6 [Credit:protected] => 0.00 [isFake:protected] => 0 [SalesforceID:protected] => 001C0000019EkCKIA0 [CompanyBrand:protected] => [log:protected] => [myName:protected] => BO_Company ) [Office:protected] => [Realtor:protected] => [log:protected] => [myName:protected] => BO_Realtor ) [TourClass:protected] => [log:protected] => [myName:protected] => BO_Home ) ) ) [1] => Array ( [file] => /local/online/live/dharma/DAO/crux/DAO_Home_Crux.php [line] => 618 [function] => insert [class] => DAO_Home [type] => -> [args] => Array ( [0] => BO_Home Object ( [shortHash] => [allpro] => [_fields:BO_Home:private] => [_productStatus:BO_Home:private] => [homeid:protected] => SS8DYH [mlsnum:protected] => [altmlsnum:protected] => [rooms:protected] => [baths:protected] => 0 [sqft:protected] => [comments:protected] => [updated:protected] => [listdate:protected] => 2018-05-17 [expiredate:protected] => [askingprice:protected] => [addr:protected] => 4185 Bedaki Avenue NE [city:protected] => Lowell [county:protected] => Kent [state:protected] => MI [zip:protected] => 49331 [country:protected] => US [date_posted:protected] => 0000-00-00 [status:protected] => pending [id:protected] => 5028208 [photographerid:protected] => [date_linked:protected] => 0000-00-00 [contact_notes:protected] => [leadGen:protected] => none [archived:protected] => no [exclusiveLeads:protected] => no [directory:protected] => [needsLinking:protected] => 0 [vaPropertyId:protected] => [vaHomeStatus:protected] => inherited [mlsName:protected] => [externalURL:protected] => [officeCode:protected] => [externalImagesUpdated:protected] => [dateMediaUpdated:protected] => [sellingPrice:protected] => [updateLOYTImages:protected] => [correctedCity:protected] => [propertyType:protected] => Home [propertySubType:protected] => [fullBaths:protected] => [halfBaths:protected] => [threeQuarterBaths:protected] => [quarterBaths:protected] => [sellType:protected] => sale [neighborhood:protected] => [customVideoTitle:protected] => [isWaterfront:protected] => [isInForeclosure:protected] => [isShortSale:protected] => [isREO:protected] => [yearBuilt:protected] => [sourceImportScriptId:protected] => [mlsArea:protected] => [listingStatus:protected] => [frontImageLabel:protected] => [LastActiveInFeed:protected] => [DateFeedShowsUpdated:protected] => [standardized_address:protected] => [Photographers:protected] => [prefs:protected] => [PBINid:protected] => 5028208 [PBIN_HALOid:protected] => 366952 [PBIN_PHOTOid:protected] => 0 [PBIN_TCLSid:protected] => 0 [PBINstatusMask:protected] => 0 [Realtor:protected] => BO_Realtor Object ( [prefs:BO_Realtor:private] => [realtorid:protected] => 366952 [type:protected] => Realtor [fname:protected] => United [lname:protected] => Admin [phone:protected] => 616-866-5800 [cell:protected] => [fax:protected] => [email:protected] => Administrator@remax-rockford.com [website:protected] => www.RemaxOfRockford.com [agency:protected] => RE/MAX United - MI [office:protected] => [associd:protected] => [extid:protected] => 0 [acct_status:protected] => CREDITCARD [address:protected] => 28 N. Monroe Street [city:protected] => Rockford [county:protected] => [state:protected] => MI [zip:protected] => 49341 [signupdate:protected] => 2013-12-18 00:00:00 [notes:protected] => [permit_email:protected] => y [referral:protected] => [refferedby:protected] => [product:protected] => 100898 [credit:protected] => 0.00 [bio:protected] => [hasLeadGen:protected] => no [emailOptOut:protected] => neither [vaRealtorStatus:protected] => inherited [vaClientId:protected] => [realtorLogin:protected] => [realtorPassword:protected] => [acceptsms:protected] => unknown [mobileProvider:protected] => unknown [testimonial:protected] => [stateLicenseNumber:protected] => [personalYouTubeId:protected] => [md5Hash:protected] => [cacheExpire:protected] => 2015-02-16 [leadbeePin:protected] => 1234 [lastLogin:protected] => 2018-05-17 [defaultOrbitalRefNum:protected] => [FacebookURL:protected] => [TwitterURL:protected] => [YouTubeURL:protected] => [BlogURL:protected] => [emailBounced:protected] => 0 [pictureURL:protected] => [completedSetup:protected] => complete [tempCredit:protected] => [Company:protected] => BO_Company Object ( [prefs:BO_Company:private] => [externalURIs:BO_Company:private] => Array ( ) [CMPid:protected] => 100898 [CMPname:protected] => RE/MAX United - MI [CMPadmin:protected] => [CMPtype:protected] => basic [CMPnotes:protected] => Contract Dates: Feb 17th 2017 to Feb 17th, 2018 Launch Date: 01/16/2014 Type of account: Feed account ? Full serve and Self Serve Where agent puts pictures: Number of Images needed: Where feed comes from: Do we link to MLS? Syndication?? YouTube Channel: www.youtube.com/ [CMPbill:protected] => no [CMPbillType:protected] => [CMPbillingLoc:protected] => RE/MAX United 28 N Monroe Street Rockford, MI 49341-1228 [CMPlaunch:protected] => 2014-01-15 [CMPcontractStart:protected] => 2018-02-17 [CMPcontractEnd:protected] => 2019-02-17 [CMPguarantee:protected] => 0 [CMPrep:protected] => cseegmiller [CMPcolorScheme:protected] => [CMPparticipate:protected] => no [CMPstate:protected] => MI [CMPsalesRep:protected] => jandrews [CMPhasLeadGen:protected] => yes [CMPemailPromos:protected] => yes [CMPrelaunch:protected] => [CMPnumAgents:protected] => [CMProster:protected] => no [pricingType:protected] => Residential [vaCompanyStatus:protected] => disabled [companyInformation:protected] => CirclePix and RE/MAX United> have teamed up to provide Full Service tour discounts as well as additional FREE upgrades! Please call our friendly Customer Service staff at 877-390-6630 to order today! RE/MAX United Economy Tour, 5 Virtuals & 12 Stills for $119.99 Standard Tour, 5 Virtuals & 25 Stills for $129.99 Master Tour, 10 Virtuals & 35 Stills for $149.99 Each Tour Includes: Print Your Own Flyers eTour ePostcard Online Lead Generation QR Code Generator Craigslist Ad Creator [companyPriceDetails:protected] => [nextPromoEmailDate:protected] => [promoEmailFrequency:protected] => 0 [parentCMPid:protected] => 100651 [extid:protected] => [cacheExpire:protected] => 2017-12-06 [isLOYTAccount:protected] => 0 [urlLookUp:protected] => [webExTrainingVideo:protected] => [WebExVideoHeader:protected] => [WebExVideoText:protected] => [addr1:protected] => 28 N Monroe Street [addr2:protected] => [city:protected] => Rockford [zip:protected] => 49341-1228 [phone:protected] => 616-866-5800 [displayName:protected] => RE/MAX United [externalSubdomain:protected] => [billingRealtorId:protected] => [billingProfileId:protected] => 422103740 [googleAnalyticsCode:protected] => [Country:protected] => USA [StarMarketingStatus:protected] => Active [CompanyBrandID:protected] => 6 [Credit:protected] => 0.00 [isFake:protected] => 0 [SalesforceID:protected] => 001C0000019EkCKIA0 [CompanyBrand:protected] => [log:protected] => [myName:protected] => BO_Company ) [Office:protected] => [Realtor:protected] => [log:protected] => [myName:protected] => BO_Realtor ) [TourClass:protected] => [log:protected] => [myName:protected] => BO_Home ) ) ) [2] => Array ( [file] => /local/online/live/aspen/ssListingInfo.htm [line] => 146 [function] => save [class] => DAO_Home_Crux [type] => -> [args] => Array ( [0] => BO_Home Object ( [shortHash] => [allpro] => [_fields:BO_Home:private] => [_productStatus:BO_Home:private] => [homeid:protected] => SS8DYH [mlsnum:protected] => [altmlsnum:protected] => [rooms:protected] => [baths:protected] => 0 [sqft:protected] => [comments:protected] => [updated:protected] => [listdate:protected] => 2018-05-17 [expiredate:protected] => [askingprice:protected] => [addr:protected] => 4185 Bedaki Avenue NE [city:protected] => Lowell [county:protected] => Kent [state:protected] => MI [zip:protected] => 49331 [country:protected] => US [date_posted:protected] => 0000-00-00 [status:protected] => pending [id:protected] => 5028208 [photographerid:protected] => [date_linked:protected] => 0000-00-00 [contact_notes:protected] => [leadGen:protected] => none [archived:protected] => no [exclusiveLeads:protected] => no [directory:protected] => [needsLinking:protected] => 0 [vaPropertyId:protected] => [vaHomeStatus:protected] => inherited [mlsName:protected] => [externalURL:protected] => [officeCode:protected] => [externalImagesUpdated:protected] => [dateMediaUpdated:protected] => [sellingPrice:protected] => [updateLOYTImages:protected] => [correctedCity:protected] => [propertyType:protected] => Home [propertySubType:protected] => [fullBaths:protected] => [halfBaths:protected] => [threeQuarterBaths:protected] => [quarterBaths:protected] => [sellType:protected] => sale [neighborhood:protected] => [customVideoTitle:protected] => [isWaterfront:protected] => [isInForeclosure:protected] => [isShortSale:protected] => [isREO:protected] => [yearBuilt:protected] => [sourceImportScriptId:protected] => [mlsArea:protected] => [listingStatus:protected] => [frontImageLabel:protected] => [LastActiveInFeed:protected] => [DateFeedShowsUpdated:protected] => [standardized_address:protected] => [Photographers:protected] => [prefs:protected] => [PBINid:protected] => 5028208 [PBIN_HALOid:protected] => 366952 [PBIN_PHOTOid:protected] => 0 [PBIN_TCLSid:protected] => 0 [PBINstatusMask:protected] => 0 [Realtor:protected] => BO_Realtor Object ( [prefs:BO_Realtor:private] => [realtorid:protected] => 366952 [type:protected] => Realtor [fname:protected] => United [lname:protected] => Admin [phone:protected] => 616-866-5800 [cell:protected] => [fax:protected] => [email:protected] => Administrator@remax-rockford.com [website:protected] => www.RemaxOfRockford.com [agency:protected] => RE/MAX United - MI [office:protected] => [associd:protected] => [extid:protected] => 0 [acct_status:protected] => CREDITCARD [address:protected] => 28 N. Monroe Street [city:protected] => Rockford [county:protected] => [state:protected] => MI [zip:protected] => 49341 [signupdate:protected] => 2013-12-18 00:00:00 [notes:protected] => [permit_email:protected] => y [referral:protected] => [refferedby:protected] => [product:protected] => 100898 [credit:protected] => 0.00 [bio:protected] => [hasLeadGen:protected] => no [emailOptOut:protected] => neither [vaRealtorStatus:protected] => inherited [vaClientId:protected] => [realtorLogin:protected] => [realtorPassword:protected] => [acceptsms:protected] => unknown [mobileProvider:protected] => unknown [testimonial:protected] => [stateLicenseNumber:protected] => [personalYouTubeId:protected] => [md5Hash:protected] => [cacheExpire:protected] => 2015-02-16 [leadbeePin:protected] => 1234 [lastLogin:protected] => 2018-05-17 [defaultOrbitalRefNum:protected] => [FacebookURL:protected] => [TwitterURL:protected] => [YouTubeURL:protected] => [BlogURL:protected] => [emailBounced:protected] => 0 [pictureURL:protected] => [completedSetup:protected] => complete [tempCredit:protected] => [Company:protected] => BO_Company Object ( [prefs:BO_Company:private] => [externalURIs:BO_Company:private] => Array ( ) [CMPid:protected] => 100898 [CMPname:protected] => RE/MAX United - MI [CMPadmin:protected] => [CMPtype:protected] => basic [CMPnotes:protected] => Contract Dates: Feb 17th 2017 to Feb 17th, 2018 Launch Date: 01/16/2014 Type of account: Feed account ? Full serve and Self Serve Where agent puts pictures: Number of Images needed: Where feed comes from: Do we link to MLS? Syndication?? YouTube Channel: www.youtube.com/ [CMPbill:protected] => no [CMPbillType:protected] => [CMPbillingLoc:protected] => RE/MAX United 28 N Monroe Street Rockford, MI 49341-1228 [CMPlaunch:protected] => 2014-01-15 [CMPcontractStart:protected] => 2018-02-17 [CMPcontractEnd:protected] => 2019-02-17 [CMPguarantee:protected] => 0 [CMPrep:protected] => cseegmiller [CMPcolorScheme:protected] => [CMPparticipate:protected] => no [CMPstate:protected] => MI [CMPsalesRep:protected] => jandrews [CMPhasLeadGen:protected] => yes [CMPemailPromos:protected] => yes [CMPrelaunch:protected] => [CMPnumAgents:protected] => [CMProster:protected] => no [pricingType:protected] => Residential [vaCompanyStatus:protected] => disabled [companyInformation:protected] => CirclePix and RE/MAX United> have teamed up to provide Full Service tour discounts as well as additional FREE upgrades! Please call our friendly Customer Service staff at 877-390-6630 to order today! RE/MAX United Economy Tour, 5 Virtuals & 12 Stills for $119.99 Standard Tour, 5 Virtuals & 25 Stills for $129.99 Master Tour, 10 Virtuals & 35 Stills for $149.99 Each Tour Includes: Print Your Own Flyers eTour ePostcard Online Lead Generation QR Code Generator Craigslist Ad Creator [companyPriceDetails:protected] => [nextPromoEmailDate:protected] => [promoEmailFrequency:protected] => 0 [parentCMPid:protected] => 100651 [extid:protected] => [cacheExpire:protected] => 2017-12-06 [isLOYTAccount:protected] => 0 [urlLookUp:protected] => [webExTrainingVideo:protected] => [WebExVideoHeader:protected] => [WebExVideoText:protected] => [addr1:protected] => 28 N Monroe Street [addr2:protected] => [city:protected] => Rockford [zip:protected] => 49341-1228 [phone:protected] => 616-866-5800 [displayName:protected] => RE/MAX United [externalSubdomain:protected] => [billingRealtorId:protected] => [billingProfileId:protected] => 422103740 [googleAnalyticsCode:protected] => [Country:protected] => USA [StarMarketingStatus:protected] => Active [CompanyBrandID:protected] => 6 [Credit:protected] => 0.00 [isFake:protected] => 0 [SalesforceID:protected] => 001C0000019EkCKIA0 [CompanyBrand:protected] => [log:protected] => [myName:protected] => BO_Company ) [Office:protected] => [Realtor:protected] => [log:protected] => [myName:protected] => BO_Realtor ) [TourClass:protected] => [log:protected] => [myName:protected] => BO_Home ) ) ) ) [previous:Exception:private] => )